Excel Assignment #3 Part 1- CVP Graph DATA SECTION TABLE SECTION ...
80.2K
Verified Solution
Link Copied!
Question
Accounting
Excel Assignment #
Part CVP Graph
DATA SECTION
TABLE SECTION
Compute the following for various sales volume levels. Start with units and increase the units sold by units. Enter the sales volume in a column You need to go on for whatever it takes to view the breakeven point nicely in the middle of the graph.
Sales revenues
Total variable cost
Total Contribution margin
Fixed cost
Total costs variable and fixed
Income before tax
Required:
Plot the Sales Volume in units as independent variable axis versus the following dependent variables axisall in one graph
Sales Revenue dollars
Fixed cost dollars
Total cost dollars
Plot the Sales Volume in units as independent variable axis versus Income before tax Y axis
Be sure to label the graph axes appropriately, and to include a legend identifying the lines.
Show the entire worksheet on one page as a formal business report ie suppress grid lines and row and column headings...do not include the graphs in this report but attach the two graphs as two separate tabs Use data given in Section above.
Redo the entire worksheet on one page again as a formal business report, changing the selling price to $ No need for the graphs here.
Answer & Explanation
Solved by verified expert
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
