Excel - CVP Analysisneed help kinda lost. It's Chapter 5/6 Excel - CVP Analysis

Fraser Co. is considering a change to its cost structure. Below is the data relating to the current structure as well as the proposed change. Current Structure Proposed Structure Unit Sales 20,000 Unit Sales Sales Price Per Unit $ 100 Sales Price Per Unit Total Variable Costs (based on 20,000 units) $ 400,000 Total Variable Costs (based on 20,000 units) Total Fixed Costs $ 900,000 Total Fixed Costs 20,000 $ 100 $ 700,000 $ 600,000 1.) Prepare a CVP Statement for each cost structure. Incorporate cell references and formulas where indicated. You can instantly create the CVP Statement for the Proposed Structure, by copying and pasting your completed CVP Statement for the Current Structure. Make sure all highlighted areas are completed. Try to avoid the headings when copying. You want to keep the Proposed Structure heading. CVP Statement - Current Structure CVP Statement - Proposed Structure Type a Label Here Type a Label Here Type a Label Here Type a Label Here Type a Label Here Total formula cell reference formula cell reference formula Per Unit cell reference formula formula % of Sales formula formula formula 2.) Use the Contribution Margin technique to calculate the Breakeven point in units and dollars for each scenario. You can save time again by copying from one section to the next. Be careful with the headings. Breakeven Units - Current Structure cell reference cell reference = formula Breakeven Units - Proposed Structure cell reference cell reference Breakeven Sales Dollars - Current Structure cell reference cell reference = formula = formula Breakeven Sales Dollars - Proposed Structure cell reference cell reference = formula 3.) Compare the Net Operating Income and Breakeven calculations for both scenarios. What happened to the breakeven point and why? Type response here 4.) Compute the Degree of Operating Leverage for both scenarios. Save time again. Degree of Operating Leverage - Current Structure cell reference cell reference = formula Degree of Operating Leverage - Proposed Structure cell reference cell reference = formula 5.) Use the Degree of Operating Leverage to determine how a 10% increase in sales will impact Net Income. Degree of Operating Leverage LABEL Net Income Impact Old Net Income LABEL Current cell reference cell reference formula cell reference formula Proposal cell reference cell reference formula cell reference formula New Net Income formula formula 6.) Save and Print this spreadsheet 7.) Print the formulas (CTRL ~) 8.) Copy the entire spreadsheet to the "Revisions" tab (click on the upper left hand corner of the worksheet to highlight the entire page before copying). 9.) Use the "Revision" spreadsheet to prove your calculation from instruction #5 of the "Original" spreadsheet by increasing the sales volume in the data section (gray shaded area) by 10%. Remember to change anything else in the data section which would be affected by a change in sales volume. You should not make any changes below row 6. 10.) Save and Print the "Revision" Spreadsheet. 11.) Return to the "Original" spreadsheet, Instruction #5. Show the impact of a 20% decrease in sales. 12. Compare the 10% Increase to the 20 % decrease on both Originals. What do you notice? Type Response Here 13. Save the file as Run 2 and print the Original spreadsheet again