In: Accounting
Exercise 5-22 CVP analysis using composite units LO P4
Handy Home sells windows and doors in the ratio of 8:2
(windows:doors). The selling price of each window is $106 and of
each door is $256. The variable cost of a window is $65.50 and of a
door is $178.00. Fixed costs are $624,000. (Enter your "per
unit" values in two decimal places.)
|
1)
Calculation of selling price per composite unit. | |||
Quantity (A) | Selling Price per unit (B) | Total per composite unit (A*B) | |
Windows | 8 | $106.00 | $848.00 |
Doors | 2 | $256.00 | $512.00 |
Selling price per Composite unit | $1,360.00 |
2)
Calculation of variable costs per composite unit. | |||
Quantity (A) | Variable costs per unit (B) | Total per composite unit (A*B) | |
Windows | 8 | $65.50 | $524.00 |
Doors | 2 | $178.00 | $356.00 |
Variable cost per composite unit | $880.00 | ||
Contribution margin per composite unit | |||
Sales | $1,360.00 | ||
Less: Variable costs | $880.00 | ||
Contribution margin | $480.00 |
3)
Calculation of break-even point in composite units. | |||||
Choose Numerator: | / | Choose Denominator: | = | Break Even Units | |
Total Fixed Costs | / | Contribution margin per unit | = | Break even units | |
$624,000 | / | $480.00 | = | 1,300 | Composite units |
4)
Calculation of number of units of each product that will be sold at the break-even point. | ||||
Quantity (A) | Number of composite units to break even. (B) | Unit sales at break-even point (A*B) | ||
Windows | 8 | 1,300 | 10,400 | Windows |
Doors | 2 | 1,300 | 2,600 | Doors |
13,000 | Total |