In: Accounting
Gold (a) | Silver (b) | Copper (c ) | Overall Company (a+b+c) | |
Sales volume (a) | 118,000 | 207,000 | 292,000 | 617,000 |
Selling Price per unit (b) | $1.80 | $1.50 | $1.40 | |
Sales Revenue (a * b) | $212,400 | $310,500 | $408,800 | $931,700 |
Less: Variable costs (118,000*$0.70); (207,000*$0.80); (292,000*$1.10) | ($82,600) | ($165,600) | ($321,200) | ($569,400) |
Contribution Margin | $129,800 | $144,900 | $87,600 | $362,300 |
Less: Traceable Fixed Expenses | ($28,050) | ($120,400) | ($58,800) | ($207,250) |
Segment margin | $101,750 | $24,500 | $28,800 | $155,050 |
Less: Common Fixed Expenses ($262,000 - $207,250) | ($54,750) | |||
Net Operating Income | $100,300 | |||
1) | ||||
Total Fixed Expenses (a) | $262,000 | |||
Contribution margin ratio ($362,600/$931,700*100) (b) | 39% | |||
Break-even point in sales dollars (a/b) | $673,766 | |||
2-a) | ||||
Treable Fixed Expenses (a) | $28,050 | $120,400 | $58,800 | |
Contribution margin per unit ($1.80-$0.70); ($1.50-$0.80); ($1.40-$1.10) (b) | $1.10 | $0.70 | $0.30 | |
Break-even point in sales units (a/b) | 25,500 | 172,000 | 196,000 | |
2-b) | ||||
Sales volume (a) | 25,500 | 172,000 | 196,000 | 393,500 |
Selling Price per unit (b) | $1.80 | $1.50 | $1.40 | |
Sales Revenue (a * b) | $45,900 | $258,000 | $274,400 | $578,300 |
Less: Variable costs (25,500*$0.70); (172,000*$0.80); (196,000*$1.10) | ($17,850) | ($137,600) | ($215,600) | ($371,050) |
Contribution Margin | $28,050 | $120,400 | $58,800 | $207,250 |
Less: Traceable Fixed Expenses | ($28,050) | ($120,400) | ($58,800) | ($207,250) |
Segment margin | $0 | $0 | $0 | $0 |
Less: Common Fixed Expenses ($262,000 - $207,250) | ($54,750) | |||
Net Operating Income (loss) | ($54,750) |