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?
Expert Answer:
Related Book For 
Posted Date:
