Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read under where it says required, those are the questions Part 1 - CVP Graph 2. TABLE SECTION Compute the following for various sales volume

image text in transcribedimage text in transcribedimage text in transcribed

Read under where it says required, those are the questions

Part 1 - CVP Graph 2. 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: 1. 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 2. 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. 3. 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. 4. 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. TABLE SECTION Prepare a contribution margin format income statement for each scenario making cell ANALYSIS SECTION - Scenario \#2: A proposed new machine will reduce variable product cost to $13, increase fixed product cost to $30,000, and keep S\&A costs the same. What will be the profit? Hint: If your formulas are correct, then all you need is to change the Data section of Scenario 2. Use Goal Seek function (search help on goal seek and read the instructions) to find the following: - Scenario \#3: Break even sales volume in units and dollars with the old machine as in Scenario \#1. Hint: The "goal" is zero net income. You can achieve the goal by changing the Sales volume. - Scenario \#4: Sales volume in units and dollars needed for a Net Income After Tax of $10,000, all else as in #1. - Scenario \#5: Break even sales volume in units and dollars with the new machine. - Scenario \#6: Sales volume in units and dollars to give with the new machine the same profit before tax as with the current machine in \#1. Part 1 - CVP Graph 2. 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: 1. 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 2. 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. 3. 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. 4. 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. TABLE SECTION Prepare a contribution margin format income statement for each scenario making cell ANALYSIS SECTION - Scenario \#2: A proposed new machine will reduce variable product cost to $13, increase fixed product cost to $30,000, and keep S\&A costs the same. What will be the profit? Hint: If your formulas are correct, then all you need is to change the Data section of Scenario 2. Use Goal Seek function (search help on goal seek and read the instructions) to find the following: - Scenario \#3: Break even sales volume in units and dollars with the old machine as in Scenario \#1. Hint: The "goal" is zero net income. You can achieve the goal by changing the Sales volume. - Scenario \#4: Sales volume in units and dollars needed for a Net Income After Tax of $10,000, all else as in #1. - Scenario \#5: Break even sales volume in units and dollars with the new machine. - Scenario \#6: Sales volume in units and dollars to give with the new machine the same profit before tax as with the current machine in \#1

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

The Politics Of Internal Auditing

Authors: Dr. Larry Rittenberg, Patty Miller

1st Edition

0894139053, 978-0894139055

More Books

Students also viewed these Accounting questions

Question

Define Administration and Management

Answered: 1 week ago

Question

Define organisational structure

Answered: 1 week ago

Question

Define line and staff authority

Answered: 1 week ago

Question

Define the process of communication

Answered: 1 week ago

Question

Explain the importance of effective communication

Answered: 1 week ago