In: Accounting
3.
Morris Industries manufactures and sells three products (AA, BB, and CC). The sales price and unit variable cost for the three products are as follows:
Product | Sales Price per Unit |
Variable Cost per Unit |
AA | $55 | $25 |
BB | 45 | 20 |
CC | 30 | 5 |
Their sales mix is reflected as a ratio of 5:3:2. Annual fixed costs shared by the three products are $275,000 per year.
A. What are total variable costs for Morris with their current product mix?
Total variable costs $
B. Calculate the number of units of each product that will need to be sold in order for Morris to break even.
Number of Units per Product |
|||
AA | |||
BB | |||
CC |
C. What is their break-even point in sales dollars?
Break-even point in sales $
D. Using an income statement format, prove that this is the break-even point. If an amount is zero, enter "0".
Income Statement | |
Sales | |
Product AA | $ |
Product BB | |
Product CC | |
Total Sales | $ |
Variable Costs | |
Product AA | $ |
Product BB | |
Product CC | |
Total Variable Costs | $ |
Contribution Margin | $ |
Fixed Costs | |
Net Income | $ |
Product | Sales Price | Variable Cost | |||||
per Unit | per Unit | Contribution margin | Mix | Weighted Contribution | |||
AA | $55 | $25 | $30 | 5 | $15.00 | ||
BB | 45 | 20 | $25 | 3 | $7.50 | ||
CC | 30 | 5 | $25 | 2 | $5.00 | ||
10 | $27.50 | ||||||
A. | Total variable costs | $19.50 | (25*5/10+20*3/10+5*2/10) | ||||
B. | Breakeven in number of units | ||||||
Weighted contribution per unit = | $27.50 | ||||||
Breakeven | 10,000 | ||||||
AA | 5000 | Units | |||||
BB | 3000 | Units | |||||
CC | 2000 | Units | |||||
C. | Breakeven in sales dollar | ||||||
AA | $275,000 | (5000*55) | |||||
BB | $135,000 | (3000*45) | |||||
CC | $60,000 | (2000*30) | |||||
D. | |||||||
Income statement | |||||||
Sales | |||||||
Product AA | $275,000 | ||||||
Product BB | $135,000 | ||||||
Product CC | $60,000 | ||||||
Total sales | $470,000 | ||||||
Variable costs | |||||||
Product AA | $125,000 | ||||||
Product BB | $60,000 | ||||||
Product CC | $10,000 | ||||||
Total VC | $195,000 | ||||||
Contribution margin | $275,000 | ||||||
Fixed costs | 275000 | ||||||
Net income | $0 |