Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Karen BraunWendy Tietz

3rd Edition

0132890542, 978-0132890540

More Books

Students also viewed these Accounting questions

Question

Given that P (B) = .29 and P (A and B) = .24, find P (A | B).

Answered: 1 week ago