Answered step by step
Verified Expert Solution
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
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 \#1Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started