In: Accounting
|
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $46; white, $76; and blue, $101. The per unit variable costs to manufacture and sell these products are red, $31; white, $51; and blue, $71. Their sales mix is reflected in a ratio of 2:2:1 (red:white:blue). Annual fixed costs shared by all three products are $141,000. One type of raw material has been used to manufacture all three products. The company has developed a new material of equal quality for less cost. The new material would reduce variable costs per unit as follows: red, by $6; white, by $16; and blue, by $6. However, the new material requires new equipment, which will increase annual fixed costs by $11,000. |
| Required: | |
| 1. |
Assume if the company continues to use the old material, determine its break-even point in both sales units and sales dollars of each individual product. (Round up your composite units to whole number. Omit the "$" sign in your response.) |
| Break-Even Points | Sales Units | Sales Dollars |
| Red at break-even | $ | |
| White at break-even | $ | |
| Blue at break-even | $ | |
| 2. |
Assume if the company uses the new material, determine its new break-even point in both sales units and sales dollars of each individual product. (Round up your composite units to whole number. Omit the "$" sign in your response.) |
| Break-Even Points | Sales Units | Sales Dollars |
| Red at break-even | $ | |
| White at break-even | $ | |
| Blue at break-even | $ |
| Break even point in units | Fixed cost /(Selling price Less variable cost) | |
| Break even sales | Fixed expenses / contribution margin ratio | |
| Contribution | Selling price Less variable cost | |
| Contribution margin | Contribution /Sales | |
| Break even points in units | Old raw material | New raw material |
| Fixed cost | 141000 | 152,000 |
| Total selling price | 223 | 223 |
| Variable cost | 153 | 125 |
| Contribution | 70 | 98 |
| Break even point in units | 2,014 | 1,551 |
| in the ratio of 2:2:1 | ||
| Red | 806 | 620 |
| White | 806 | 620 |
| Blue | 403 | 311 |
| Break even point in sales | ||
| Contribution margin | 31% | 44% |
| Sales in dollars | 449,186 | 345,878 |
| in the ratio of 2:2:1 | ||
| Red | 179,674 | 138,351 |
| White | 179,674 | 138,351 |
| Blue | 89,837 | 69,176 |