Excel breakeven

# Excel breakeven - Break Even Analysis Solution Example 2...

This preview shows pages 1–3. Sign up to view the full content.

Break Even Analysis Solution - Example 2 Variable Cost/Unit \$ 6.20 Fixed Cost \$ 24,000 Price/Unit \$ 8.70 BEP Unit 9600 BEP (\$) \$83,520.00 Goal Seek is used when you know what answer you want, but don't know the exact figure to input for that answer 0 1000 2000 3000 4000 5000 6000 7000 8000 9 0 20,000 40,000 60,000 80,000 100,000 120,000 140,000 160,000

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Unit Fixed cost Variale cost Total CostRevenue Profit 0 24,000 0 24,000 0 -24,000 1000 24,000 6200 30,200 8700 -21,500 2000 24,000 12400 36,400 17400 -19,000 3000 24,000 18600 42,600 26100 -16,500 4000 24,000 24800 48,800 34800 -14,000 5000 24,000 31000 55,000 43500 -11,500 6000 24,000 37200 61,200 52200 -9,000 7000 24,000 43400 67,400 60900 -6,500 8000 24,000 49600 73,600 69600 -4,000 9000 24,000 55800 79,800 78300 -1,500 10000 24,000 62000 86,000 87000 1,000 11000 24,000 68200 92,200 95700 3,500 12000 24,000 74400 98,400 104400 6,000 13000 24,000 80600 104,600 113100 8,500 14000 24,000 86800 110,800 121800 11,000 0 9000 10000 11000 12000 13000 14000 Profit Total Cost Fixed cost
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 4

Excel breakeven - Break Even Analysis Solution Example 2...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online