Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 | 1350.00 | 1680.00 | 450.00 | 1750.00 | 1650.00 | 1540.00 | 300.00 |
Total cost | 2350.00 | 2880.00 | 2450.00 | 2750.00 | 2850.00 | 3040.00 | 900.00 |
Sales revenue | 2100.00 | 3360.00 | 2400.00 | 3150.00 | 3900.00 | 4400.00 | 1800.00 |
Net income | -250.00 | 480.00 | -50.00 | 400.00 | 1050.00 | 1360.00 | 900.00 |
- Use what-if solver in Excel to predict the breakeven point.
- Interpret the result. Explain what the result means. What useful information is generated by this data analysis?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started