please answer asap!! i will give you a

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 PricePerUnit 100 Sales PricePerUnit Total Variable Costs (ned on 20,000 units) $ 400,000 Total Variable Costs (based on 20,000 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 8 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 9 headings when copying. You want to keep the Proposed Structure heading 10 CVP Statement Current Structure CVP Statement - Proposed Structura 11 12 Total Per Unit of Sales 13 Type a Label Here formula cell reference formula 14 Type a Label Here cell reference formula formula 15 Type a Label Here formula formula formula 16 Type a Label Here cell reference 17 Type a Label Here 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 Breakeven Units - Proposed Structure cell reference cell reference formula cell reference cell reference formula Breakeven Sales Dollars. Current Structure Breakeven Sales Dollars - Proposed Structure cell reference cell reference formula cal reference cell reference formula 3.) Compare the Net Operating Income and Breakeven calculations for both scenarlos. 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 Degree of Operating Leverage - Proposed Structure cal reference cell reference formula cell reference cell reference formula 6.) Save and print face-to-face closs) 7.) Copy ROWS 1.17 of this spreadsheet tab ("ORIGINAL") to the "Revisions tab 8.) Use the "Revision spreadsheet to prove your calculation from Instruction as 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