Please help me complete the degree of operating level question (#5) regarding the 10% increase in sales, as well as the new table amounts (#8). Thank you!

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 Sales Price Per Unit Total Variable Costs (based on 20,000 units) Total Fixed Costs 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 headi 20,000 100 Unit Sales 20,000 $100 $700,000 $600,000 Sales Price Per Unit $ 400,000 Total Variable Costs (based on 20,000 units $ 900,000 Total Fixed Costs CVP Statement - Current Structure CVP Statement Proposed Structure Per Unit % of Sales Per Unit %Of Sales 100% 35% 65% Total Total $ 2,000,000$100.00 20.00 Sales Variable Costs Contribution Margin$1,600,000 Fixed Costs Net Income Sales Variable Costs |Contribution Margin $ 2,000,000 $ S 700,000 S $ $600,000 $ 700,000 100% 20% 100.00 35.00 65.00 S 400,000 S $ 80.00 80%) 1,300,000 $900,000 $700,000 Fixed Costs Net Income 4.) Compute the Degree of Operating Leverage for both scenarios. Save time again Degree of Operating Leverage Current Structure Degree of Operating Leverage - Proposed Structure 1,600,000 700,000 1,300,000 700,000 2.285714286 1.857142857 5) Use the Degree of Operating Leverage to determine how a 10% increase in sales will im pact Net Income Current Proposal Degree of Operating Leverage LABEL Net Income Impact Old Net Income LABEL 2.285714286 1.857142857 cell referencecell reference formula formula S 700,000 700,000 formula formula New Net Income formula 7.) Copy ROWS 1-17 of this spreadsheet tab ("ORIGINAL") to the "Revisions" tab 8. Use the "Revision spreadsheet to prove your calculation rom instruction #5 o the Orignal" spreadsheet by increasing the sales vol me in the dot section gray shaded area by 10%. Remember to change anything else in the data section which would be a ected by a change in sales volume. You should not make any changes below row 6