In: Accounting
PA6-1 Calculating Contribution Margin, Contribution Margin Ratio, Break-Even Point [LO 6-1, 6-2]
Hermosa, Inc., produces one model of mountain bike. Partial
information for the company follows:
| Number of bikes produced and sold | 510 | 800 | 970 | |||
| Total costs | ||||||
| Variable costs | $ | 126,990 | $ | ? | $ | ? | 
| Fixed costs per year | ? | ? | ? | |||
| Total costs | ? | ? | ? | |||
| Cost per unit | ||||||
| Variable cost per unit | ? | ? | ? | |||
| Fixed cost per unit | ? | ? | ? | |||
| Total cost per unit | ? | $ | 533.75 | ? | ||
     
Required:
1. Complete the table. (Round
your "Cost per Unit" answers to 2 decimal
places.)
  
2. Calculate Hermosa’s contribution margin ratio
and its total contribution margin at each sales level indicated in
the table assuming the company sells each bike for $780.
(Round your percentage answers to 2 decimal places. (i.e.
.1234 should be entered as 12.34%.))
4. Calculate Hermosa’s break-even point in units
and sales revenue. (Round your answers to the nearest whole
number.)
| 
 Number of bikes produced and sold  | 
 510  | 
 800  | 
 970  | 
|||
| 
 Total Costs  | 
||||||
| 
 Variable Costs  | 
 $  | 
 126,990  | 
 $  | 
 199,200  | 
 $  | 
 241,530  | 
| 
 Fixed costs per year  | 
 $  | 
 227,800  | 
 $  | 
 227,800  | 
 $  | 
 227,800  | 
| 
 Total Costs  | 
 $  | 
 354,790  | 
 $  | 
 427,000  | 
 $  | 
 469,330  | 
| 
 Cost per unit  | 
||||||
| 
 Variable cost per unit  | 
 $  | 
 249  | 
 $  | 
 249  | 
 $  | 
 249  | 
| 
 Fixed cost per unit  | 
 $  | 
 446.67  | 
 $  | 
 284.75  | 
 $  | 
 234.84  | 
| 
 Total Cost per unit  | 
 $  | 
 695.67  | 
 $  | 
 533.75  | 
 $  | 
 483.84  | 
2. Contribution margin ratio and total contribution
| 
 Number of bikes produced and sold  | 
 510  | 
 800  | 
 970  | 
| 
 Selling price  | 
 $ 780  | 
 $ 780  | 
 $ 780  | 
| 
 Sales  | 
 $ 397,800  | 
 $ 624,000  | 
 $ 756,600  | 
| 
 Less: Variable Cost  | 
 $ 126,990  | 
 $ 199,200  | 
 $ 241,530  | 
| 
 Contribution margin  | 
 $ 270,810  | 
 $ 424,800  | 
 $ 515,070  | 
| 
 Contribution margin ratio  | 
 68.07%  | 
 68.07%  | 
 68.07%  | 
3. Break even point
Break Even Point in units = Total Fixed cost / Contribution margin per unit
= $ 229,500 / ($ 780-249)
= $ 229,500/ 531 = 432 units
(As per the calculation we get the answer as 432.20units. It rounded to 432 units being the nearest whole number)
Break Even Point in dollar sales =Break even point in units*Selling price per unit
=432 units* $780 = $ 336,960