In: Accounting
a leading firm in the sports industry, produces basketballs for the consumer market. For the year ended December 31,
2017,
Verena
sold
242,100
basketballs at an average selling price of
$41
per unit. The following information also relates to
2017
(assume constant unit costs and no variances of any kind):
Inventory, January 1, 2017:
29,300 basketballs
Inventory, December 31, 2017:
27,200 basketballs
Fixed manufacturing costs:
$1,200,000
Fixed administrative costs:
$3,234,000
Direct materials costs:
$12 per basketball
Direct labor costs:
$9 per basketball
|
1. |
Calculate the breakeven point (in basketballs
sold) in
2017 under: |
|
|
a. |
Variable costing |
|
|
b. |
Absorption costing |
|
|
2. |
Suppose direct materials costs were
$16 per basketball instead. Assuming all other data are the same, calculate the minimum number of basketballsVerena must have sold in2017 to attain a target operating income of$110,000 under: |
|
|
a. |
Variable costing |
|
|
b. |
Absorption costing |
|
| 1) Calculate the breakeven point (in basketballs sold) in 2017 | ||
| Fixed manufacturing costs: | $1,200,000 | |
| Fixed administrative costs: | $3,234,000 | |
| Total | $4,434,000 | |
| Selling Price | $41 | |
| Less: Direct materials costs: | ($12) | |
| Less: Direct labor costs: | ($9) | |
| Contribution Margin | $20 | |
| Break even point under variable costing= Total fixed expenses/Contribution margin per unit | ||
| Break even point under variable costing= $,4,434,000/$20 | 221,700.00 | Units |
| Absorption Costing | ||
| Selling Price | $41 | |
| Less: Direct materials costs: | ($12) | |
| Less: Direct labor costs: | ($9) | |
| Contribution Margin | $20 | |
| Less: fixed cost rate* | $ (5.00) | |
| Adjusted CM | $15 | |
| Production = Sales + Ending Inventory - Beginning Inventory | 240,000.00 | units |
| * Fixed manufacturing cost rate = $1200000/240,000 | $ 5.00 | |
| BEP units = $3234000/$15 | $ 215,600.00 | units |
| Alternative method | ||
| BEP Units = [Total fixed costs + Target operating income + (Fixed manufacturing cost rate x (Breakeven sales - Units produced))]/ Contribution margin per unit | ||
| BEP Units( Q) = 4434000 + 0 + (5 x (Q - 240,000)/ $20 | ||
| 20Q = 4434000 + 0 + 5Q - 1200000 | ||
| 15Q = 4434000 - 1200000 | ||
| BEP Units( Q) = | 215,600.00 | units |
| 2) | ||
| Calculate the breakeven point (in basketballs sold) in 2017 | ||
| Fixed manufacturing costs: | $1,200,000 | |
| Fixed administrative costs: | $3,234,000 | |
| Total | $4,434,000 | |
| Selling Price | $41 | |
| Less: Direct materials costs: | ($16) | |
| Less: Direct labor costs: | ($9) | |
| Contribution Margin | $16 | |
| Break even point under variable costing= Total fixed expenses + target profit /Contribution margin per unit | ||
| Break even point under variable costing= ($,4,434,000 + $110,000)/$16 | 284,000.00 | Units |
| Absorption Costing | ||
| Selling Price | $41 | |
| Less: Direct materials costs: | ($16) | |
| Less: Direct labor costs: | ($9) | |
| Contribution Margin | $16 | |
| Less: fixed cost rate* | $ (5.00) | |
| Adjusted CM | $11 | |
| Production = Sales + Ending Inventory - Beginning Inventory | 240,000.00 | units |
| * Fixed manufacturing cost rate = $1200000/240,000 | $ 5.00 | |
| BEP units =( $3234000 + 110,000)/$11 | 304,000.00 | units |
| Alternative method | ||
| BEP Units = [Total fixed costs + Target operating income + (Fixed manufacturing cost rate x (Breakeven sales - Units produced))]/ Contribution margin per unit | ||
| BEP Units( Q) = 4434000 + 110,000 + (5 x (Q - 240,000)/ $16 | ||
| 16Q = 4434000 + 110,000 + 5Q - 1200000 | ||
| 11Q = 3344000 | ||
| BEP Units( Q) = | 304,000.00 | units |