In: Accounting
Year 1 |
year 2 | year 3 | |
Sales Units | 2500 | 2750 | 2900 |
sales Price Unit | $150.00 | $ 150.00 | $ 150.00 |
REVENUE | $185,000 | $250,000 | $440,000 |
$375,000.00 | $ 412,500.00 | $ 435,000.00 | |
Variable Costs: | |||
Direct Materials | $20.00 | $20.50 | $26.01 |
Direct Labor | $17.15 | $17.60 | $19.22 |
Variable OH |
$2.50 |
$2.53 | $2.55 |
Fixed Costs: | |||
Rent | 80,000 | $80,000 | $80,000 |
Supervision | 200,000 | $205,000 | $210,250 |
Mixed Costs: | |||
Utilites-Fixed | 20,000 | 20,000 | 20,000 |
Utilities-Variable | $2.50 | $2.50 | $2.50 |
Total Costs: | |||
Variable cost per unit | $42.15 | $43.13 | $50.28 |
Fixed Costs | $300,000 | $305,000 | $310,250 |
Contribution Margin | 3.74 | 4.12 | 4.34 |
37% | 41% | 43% | |
Breakeven: | |||
Sales Units | |||
Sales Revenue | |||
Margin of Safety: | |||
What would be the margin of safety and the breakeven sales units and sale revenue |
im not understanding what details are wrong ? |
Year 1 | Year 2 | Year 3 | |
Sales in Units | 2,500 | 2,750 | 2,900 |
Sales Price Per Unit | 150.00 | 150.00 | 150.00 |
Variable Cost per Unit: | |||
Direct Materials | 20.00 | 20.50 | 26.01 |
Direct Labor | 17.15 | 17.60 | 19.22 |
Variable Overhead | 2.50 | 2.53 | 2.55 |
Utilities - Variable | 2.50 | 2.50 | 2.50 |
Total Variable Cost per Unit | 42.15 | 40.63 | 47.78 |
Contribution Per Unit | 107.85 | 109.37 | 102.22 |
Contribution Margin | 71.90% | 72.91% | 68.15% |
Fixed Costs: | |||
Rent | 80,000.00 | 80,000.00 | 80,000.00 |
Supervision | 200,000.00 | 205,000.00 | 210,250.00 |
Utilities | 20,000.00 | 20,000.00 | 20,000.00 |
Total Fixed Costs | 300,000.00 | 305,000.00 | 310,250.00 |
BEP (In Units) (Approx.) | 2,782 | 2,789 | 3,035 |
BEP (In $) (Approx) | 417,246 | 418,305 | 455,268 |
Sales Revenue | 375,000 | 412,500 | 435,000 |
Margin Of Safety | 42,246 | 5,805 | 20,268 |
BEP (In Units) = Fixed Costs / Contribution Margin per Unit | |||
BEP (In $) = Fixed Costs / Contribution Margin Ratio | |||
Magin of Safety = Sales - BEP (In $) |