Question

In: Accounting

Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it...

Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:

  Cost Cost Formula
  Cost of good sold    $23 per unit sold
  Advertising expense    $173,000 per quarter
  Sales commissions    6% of sales
  Shipping expense    ?
  Administrative salaries    $83,000 per quarter
  Insurance expense    $9,300 per quarter
  Depreciation expense    $53,000 per quarter

Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters follow:

  Quarter     Units Sold Shipping
Expense
  Year 1:
      First 19,000    $ 163,000
      Second 21,000      $ 178,000
      Third 26,000      $ 220,000
      Fourth 22,000      $ 183,000
  Year 2:
      First 20,000    $ 173,000
      Second 23,000    $ 188,000
      Third 33,400    $ 235,000
      Fourth 30,400     $ 211,000

Milden Company’s president would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter.

Required:

1. Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above.

Y = $68,000 + $5 X


2. In the first quarter of Year 3, the company plans to sell 27,000 units at a selling price of $53 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)

Milden Company
Budgeted Contribution Format Income Statement
For the First Quarter, Year 3
Sales
Variable expenses:
Cost of goods sold
Sales commissions
Shipping expense
Total variable expenses 0
0
Fixed expenses:
Total fixed expenses 0
Net operating income $0

Solutions

Expert Solution

1)
units Shipping
Sold expense
High activity level 33,400 235,000
low activity level 19,000 163,000
change 14,400 72,000
Variable cost per unit 5 per unit
Fixed cost element 68000
Variable cost per unit = 72000/14400 = $5per unit
Fixed cost element     = 235,000-(33400*5)= 68000
Y= 68,000 + 5 X
2)                                        Milden Company
Budgeted Contribution Format Income Statement
For the First Quarter , year 3
Sales (27000*53) 1431000
Variable expenses:
Cost of goods sold (27000*23) 621000
Sales commission (1,431,000*6%) 85860
Shipping expense (27000*5) 135000
total variable expense 841860
Contribution margin 589140
Fixed expenses
Advertising expense 173,000
Shipping expense 68,000
Administrative salaries 83,000
insurance expense 9,300
Depreciation expense 53,000
total fixed expense 386,300
Net income 202,840

Related Solutions

Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it...
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:   Cost Cost Formula   Cost of good sold    $26 per unit sold   Advertising expense    $183,000 per quarter   Sales commissions    7% of sales   Shipping...
Question 6: Milden Company has an exclusive franchise to purchase a product from the manufacturer and...
Question 6: Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:   Cost Cost Formula   Cost of good sold    $27 per unit sold   Advertising expense    $184,000 per quarter   Sales commissions    7% of...
Problem 1-23A High-Low Method; Contribution Format Income Statement [LO1-5, LO1-6] Milden Company has an exclusive franchise...
Problem 1-23A High-Low Method; Contribution Format Income Statement [LO1-5, LO1-6] Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: Cost Cost Formula Cost of good sold $30 per unit sold Advertising...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and at times the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and, at times, the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and, at times, the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and, at times, the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the...
Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces, has an exclusive franchise on the distribution of the necklaces, and sales have grown so rapidly over the past few years that it has become necessary to add new members to the management team. To date, the company’s budgeting practices have been inferior, and at times the company has experienced a cash shortage. You have been given responsibility for all planning and budgeting. Your first assignment is to prepare a...
Alcoa, a U.S. firm, has signed a contract to purchase goods from a manufacturer in Germany...
Alcoa, a U.S. firm, has signed a contract to purchase goods from a manufacturer in Germany for €5,000,000. The purchase was made in June with payment due six months later in December. The following market quotes are available: o The spot exchange rate is $1.20/€ o The six month forward rate is $1.21/€ o The Euro zone 6-month borrowing rate is 7% o The Euro zone 6-month deposit rate is 5% o The U.S. 6-month borrowing rate is 6% o...
Glass Product Limited (GPL) is a manufacturer specializing in glass products . The company has been...
Glass Product Limited (GPL) is a manufacturer specializing in glass products . The company has been in operation for ten years and during that time has built up a loyal and expanding customer base.GPL Limited has three signature lines, Trophies, Glasses and Mirrors all produced from Italian imported sand.. Successful marketing and sales of these products has resulted in the company exceeding full capacity at its current manufacturing base in Habour Road. Consequently, the directors are considering expanding production capacity...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT