In: Accounting
5. Gatewood Hills Corporation has three products X, Y, and Z. The company’s fixed costs are $69,000. The sales mix for its products are 3 units of X, 4 units of Y, and 1 unit of Z. Information about the three products follows:
X |
Y |
Z |
|
Projected sales in dollars |
$192,000 |
$192,000 |
$64,000 |
Selling price per unit |
$40 |
$30 |
$40 |
Contribution margin ratio |
30% |
35% |
35% |
Calculate the company's break-even point in composite units and sales dollars. (Hint: You will need to calculate the selling price of a composite unit and CM of a composite unit to calculate the break-even point in composite units. (2 points)
(b) Calculate the number of units of each individual product to be sold at the break-even point. (Check: At break-even point you should have 2,250 units of product X.
Calculation of company's break even point: | ||||||||
Contribution margin of a composite unit= (40*0.30*3/8)+(30*0.35*4/8)+(40*0.35*1/8) | ||||||||
=4.5+5.25+1.75=$11.5 | ||||||||
Selling price of a composite unit= (40*3/8)+(30*4/8)+(40*1/8)=15+15+5=$35 | ||||||||
Break even point (in units)=Fixed cost/contribution margin | ||||||||
=69000/11.5= 6000 units | ||||||||
Break even point in units=6000 units | ||||||||
Break even point in sales dollar= 6000*35=$210000 | ||||||||
Break even point in sales dollar=$210000 | ||||||||
(b) Calculation of number of unit of each product to break even: | ||||||||
Units of X= 6000*3/8=2250 units | ||||||||
Units of Y= 6000*4/8= 3000 units | ||||||||
Units of Z= 6000*1/8= 750 units |