Product A Product B Product C Product D Product E Product F Product G Price 7.00 12.00
Fantastic news! We've Found the answer you've been seeking!
Question:
Product A | Product B | Product C | Product D | Product E | Product F | Product G | |
Price | 7.00 | 12.00 | 16.00 | 9.00 | 13.00 | 20.00 | 6.00 |
Unit of sales | 300.00 | 280.00 | 150.00 | 350.00 | 300.00 | 220.00 | 300.00 |
Unit cost | 4.50 | 6.00 | 3.00 | 5.00 | 5.50 | 7.00 | 1.00 |
Fixed cost | 1000.00 | 1200.00 | 2000.00 | 1000.00 | 1200.00 | 1500.00 | 600.00 |
Variable cost | |||||||
Total cost | |||||||
Sales revenue | |||||||
Net income |
1.Use what-if solver in Excel to predict the breakeven point.
2. Interpret the result. Explain what the result means. What useful information is generated by this data analysis?
Related Book For
Posted Date: