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 | ||||||||