Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost Formula Cost of good sold $33 per unit sold Advertising expense $189,000 per quarter Sales commissions 8% of sales Shipping expense ? Administrative salaries $99,000 per quarter Insurance expense $10,900 per quarter Depreciation expense $69,000 per quarter Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit sold and the fixed shipping expense per quarter using the following data: Quarter Units Sold Shipping Expense Year 1: First 35,000 $ 179,000 Second 37,000 $ 194,000 Third 42,000 $ 236,000 Fourth 38,000 $ 199,000 Year 2: First 36,000 $ 189,000 Second 39,000 $ 204,000 Third 53,000 $ 251,000 Fourth 50,000 $ 227,000 Required: 1. Using the high-low method, estimate a cost formula for shipping expense in the form Y = a + bX. 2. In the first quarter of Year 3, the company plans to sell 41,000 units at a selling price of $66 per unit. Prepare a contribution format income statement for the quarter.
Answer
period |
Units |
Cost |
|
High Level |
Year 2, 3rd Quarter |
53,000 |
$ 251,000.00 |
Low Level |
Year 1, 1st quarter |
35,000 |
$ 179,000.00 |
Difference |
18,000 |
$ 72,000.00 |
Difference in Cost |
$ 72,000.00 |
Difference in units |
18,000 |
Variable cost per unit |
$ 4.00 |
Working |
High Level |
Low Level |
|
A |
Total Cost |
$ 251,000.00 |
$ 179,000.00 |
B |
Total Units |
53000 |
35000 |
C |
Variable cost per unit |
$ 4.00 |
$ 4.00 |
D = B x C |
Total Variable cost |
$ 212,000.00 |
$ 140,000.00 |
E = A - D |
Total Fixed Cost |
$ 39,000.00 |
$ 39,000.00 |
Hence, Variable shipping
expense = $ 4 per unit
Fixed shipping expense = $ 39000 per quarter
Cost Formula for shipping expense: Y =
a +bX
Y [total shipping
expense] = $ 39,000 + ($4.00 x Units)
Contribution margin format income statement
A = 41000 units x $ 66 |
Sales Revenue |
$2,706,000 |
|
Variable costs: |
|||
B =41000 units x $33 |
Cost of Goods Sold |
$1,353,000 |
|
C = A x 8% |
Sales Commission |
$216,480 |
|
D = 41000 units x $ 4 |
Shipping Expenses |
$164,000 |
|
E = B+C+D |
Total variable cost |
$1,733,480 |
|
F = A - E |
Contribution margin |
$972,520 |
|
Fixed Costs: |
|||
Advertising expense |
$189,000 |
||
Shipping Expenses |
$39,000 |
||
Administrative salaries |
$99,000 |
||
Insurance expense |
$10,900 |
||
Depreciation expense |
$69,000 |
||
G |
Total Fixed Cost |
$406,900 |
|
H = F - G |
Net Income |
$565,620 |
Milden Company is a distributor who wants to start using a contribution format income statement for...
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost Formula Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries $27 per unit sold $184,000 per quarter 7% of sales $94,000 per quarter $10,400 per quarter $64,000 per quarter Insurance expense Depreciation expense Because shipping expense is a mixed cost, the company needs to estimate...
Milden Company is a distributor who wants to start using a
contribution format income statement for planning purposes. The
company has analyzed its expenses and developed the following cost
formulas:
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense Cost Formula $25...
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost Formula Cost of good sold $27 per unit sold Advertising expense $177,000 per quarter Sales commissions 6% of sales Shipping expense ? Administrative salaries $87,000 per quarter Insurance expense $9,700 per quarter Depreciation expense $57,000 per quarter Because shipping expense is a mixed cost, the company needs to...
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Formula $26 per unit sold $183,000 per quarter 7% of sales Cost Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense $93,000 per quarter $10,300 per quarter $63,000 per quarter Because shipping expense is a mixed cost, the company needs to estimate...
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 of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense Cost Formula $27 per unit...
Problem 2-23 High-Low Method; Contribution Format Income Statement [LO2-5, LO2-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 of good sold Advertising expense Sales commissions Shipping expense Administrative...
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 of good sold Advertising Cost Formula $30 per unit sold $180,000 per expense quarter Sales commissions Shipping expense Administrative 7%...
Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the reta 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 of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense Cost Formula $30 per unit...
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...
value: 10.00 points 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 Formula $28 per unit sold $185,000 per quarter 6% of sales Cost Cost of good sold Advertising expense...