Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Excel Assignment # 3 Part 1 - CVP Graph DATA SECTION TABLE SECTION Compute the following for various sales volume levels. ( Start with 0

Excel Assignment #3
Part 1- CVP Graph
DATA SECTION
TABLE SECTION
Compute the following for various sales volume levels. (Start with 0 units and increase the units sold by 500 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 (x axis) versus the following dependent variables (Y axis)(all in one graph)
Sales Revenue dollars
Fixed cost dollars
Total cost dollars
Plot the Sales Volume in units as independent variable (x 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 (i.e., 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 1 above.
Redo the entire worksheet on one page again as a formal business report, changing the selling price to $33. No need for the graphs here.
image text in transcribed

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

Advanced Financial Accounting

Authors: Richard E. Baker, Valdean C. Lembke, Thomas E. King

5th Edition

0072444126, 978-0072444124

More Books

Students also viewed these Accounting questions

Question

How should Disney manage their global diversity?

Answered: 1 week ago