1. I need help with a chart within Excel to plan how many units must be sold to break even and how many to sell to make a target profit of $10,000 in your project. You should make up all other numbers for this project.
2. I need help building a columnar analysis spreadsheet to show Sales, Variable Costs, Contribution Margin, Fixed Costs, Total Costs, Net Income, and any other information you wish for your project with all columns being clearly identified in a spreadsheet.
3. Compete a sensitivity analysis (what-if analysis) that examines how a result will change if the original predicted data or underlying assumption changes. This type of data can be presented with assumptions for different scenarios
4. Plot break-even point on the exact point as calculated and rounded in your spreadsheet.
5. Format the break-even point in color.
6. Include a title for your unique project.
7. Put labels on the xy lines in your Chart.
8. Include a legend to clearly identify the information.