Question: Please Help Construct a chart within Excel to plan how many units must be sold to break even and how many to sell to make

Please Help

  1. Constructa 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. Createa 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, such as that described on p. 214 of your textbook.
  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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!