Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. excel assignment #3 part 1- cvp graph data sect

Excel Assignment #3 Part 1- CVP Graph DATA SECTION TABLE SECTION ...

80.2K

Verified Solution

Question

Accounting

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

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: Zin AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Question 5 STV 1 5 he video and answer the question liste uld Dr Vickers...

Statistics
Q

2. Review Recent molecular biology advance in tumor diagnosis and treatment ( more than 2000 words)

Biology
Q

NOTE In case you haven t clued in on this yet I want to make...

Biology
Q

1 How was the Cold War an influence among these new nation states

Biology
Q

Which of the following numbers best describes inequality above?A) [0,4/3)B)[4/3, ?)C) (-?, ?)D) (-?, -4]u[3,...

Basic Math
Q

For each probability and percentile problem draw the picture 74 Births are approximately uniformly distributed...

Statistics
Q

Park Corporation is planning to issue bonds with a face value of $600,000 and a...

Accounting
Q

Un corredor tiene una relacin de agencia nica con el vendedor. Cualquier divulgacin REQUERIDA de...

Accounting
Q

On August 1, 2011, Bonnie purchased $20,000 of Huber Co.'s 14%, 13-year bonds at face...

Accounting
Q

Ordinary differential equations ? 1-Might be converted to an exact differential equation via thoughtful multiplication....

Accounting
Q

In the theory of constraints, the only direct costs are? a )direct material, direct labor,...

Accounting
Q

Sheridan uses the conventional retail method to determine its ending inventory at cost. Assume the...

Accounting