WILL GIVE THUMBS UP IF ALL CORRECT! please help with this excel problem by using the correct cell references and formulas

should be good now! thanks

Q42 D E F G H 1 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 Proposed Structure 2 Current Structure 20,000 Unit Sales 20,000 3 Unit Sales $ 100 s 100 4 Sales PricePerUnit Sales PricePerUnit $ 3 Total Variable Costs (but on 30,000 unta 400,000 $ 700,000 Total Variable coststed on 20.000 $ 6 Total Fixed Costs 900,000 $ 600.000 Total Fixed Costs 7 1.) Prepere e CVP Statement for each cost structure incorporate cell references and formules 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 heading when copying you want to keep the Proposed Structure heading 10 CVP Statement. Current Structure CVP Statement-Proposed Structure 11 12 Total Per Unit X 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 Label Here formula 18 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 19 section to the next. Be careful with the headings 20 Breakeven Units-Current Structure Breakeven Units. Proposed Structure 21 22 cwrence cell reference formula 23 cell reference cell reference formula 24 25 Breakeven Sales Dollars - Current Structure Breakeven Sales Dollars-Proposed Structure 26 27 cellence cell reference formula 28 cellence ce reference formula 29 30 31 D.) Compare the Net Operating Income and Breakeven calculations for both scenaries. What happened to the breakeven point and why? 32 Type response here 33 34 35 36 17 Compute the Degree of Operating Leverage for both scenarios. Sowe time again 38 Degree of Operating Leverage Current Structure 39 40 cell reference 41 cell reference formula Decree of Operating Levere.Proposed Structure cell reference creerence E formula 43 Use the Degree of Operating leverage to determine how to increase in 44 sales will impact Net Income Proposal cell reference 46 47 Degree of Operating leverage 48 LABEL 49 Net Income Impact 50 Old Niet income 51 LABEL Original Current cell reference cell reference formula selference formula formula Q42 A D 20 Breakeven Units. Current Structure Breakeven Units.Propowd Structure 21 22 cell reference careference formula formula 23 cell recerence cal reference 24 25 Breakeven Sales Dollars. Current Structure Breakoven Sales Dollars. Proposed Structure 26 27 cellerence formula cell reference formula 28 cell reference cerelerence 29 30 31 ) Compare the Net Operating income and Breakeven calculations for both scenarios What happened to the breakeven point and why? 32 Type response here 33 34 35 36 37 4.) Compute the Degree of Operating Leverage for both scenarios. Save time again 36 Degree of Operating Leverage Current Structure Degree of Operating Leverage - Proposed Structure 39 40 cellrederence cell reference 41 cell reference formula E cell reference formula 43 SJ Use the Degree of Operating Leverage to determine howo 10% increase in 44 sales will impact Net Income 45 46 Current Proposal 47 Degree of Operating leverage cell reference cell reference 48 LABEL cell reference cel reference 49 Net Income Impact formula formula so Old Net Income caleference sellference 51 LABEL facmua formula 52 New Net Income formule formula 53 54 6.) Save and print oce-to-face class) 55 56 7. Copy ROWS 1-17 of this spreadsheet tob ORIGINAL") to the "Revisions tab 27 SS 8. Use the "Revision spreadsheet to prove your calculation from instructions of the Original spreadsheet by increasing the sales volume in the data section (gray 59 shaded ares) 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 60 below row 6. 62 6.) Save and print (face-to-face class or upload to Blackboard online class 63 64 65 66 67 63 69 70 71 Original Revlon + Total Q42 D 1 Fraser Co. is considering achange to its cost structure. Below is the data relating to the current structure as well as the proposed change 2 Current Structure Proposed Structure 20,000 3 Unit Sales Unit Sales 20,000 100 S 5 Sales PricePerUnit 4 Sales Price Per Unit 100 5 Total Variable Costased on 20.000 $ 400,000 Total Variable Costs 20.000) $ 700,000 $ 6 Total Fixed Costs 900,000 $ 600,000 Total Fixed Costs 7 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 9 headings when copying. You want to the proposed Structure heading 10 CVP Statement. Current Structure CVP Statement - Proposed Structure 11 12 Per Unit X of Sales 13 Type a Label Here formula cell reference formula 14 Type a label Here cell rerence formula formala 15 Type a Label Here formula formula formula 16 Type a Label Here ce reference 17 Type a Label Here formula 18 2.) Use the Contribution Mergin technique to calculate the Breakeven point in units and dollars for each scenario. You can save time again by copying from one 19 section to the next. Be careful with the headings. 20 Breakeven Units. Current Structure Breakeven Units-Proposed Structure 21 22 cell reference ce reference formula formula 23 cell reference cell reference 24 25 Breakeven Sales Dollars Current Structure Breakeven Sales Dollars - Proposed Structure 26 27 cell reference cel reference formula 28 cell reference formula cellence 29 30 31 3. Compare the Net Operating income and Breakeven calculations for both scenarios. What happened to the breakeven point and why? 32 Type response here 33 34 35 36 Degree of Operating Leverage Proposed Structure cell reference cell reference formula 374) Compute the Degree of Operating Leverage for both scenarios. Sove time again, 39 Degree of Operating Leverae. Current Structure 39 40 cei reference formula 41 cell reference 42 43 SJ Use the Degree of Operating Leverage to determine howa 10% increase in 44 soles will impact Net Income 45 46 Current Proposal 47 Degree of Operating Leverage cell reference cell reference 48 LABEL celence 49 Net Income Impact formula formula 50 Old Net Income Sell reference 51 LABEL for formule Original Rovisions + 242 E Breakeven Sales Dollars-Current Structure Breskve Sales Dollar-Proposed Structure cell reference cell reference formula cell reference cell reference formula 3.) Compare the Net Operating income and Bresleven calculations for both scenaries. What happened to the breakren polot and why? Type response here 7) Compute the Degree of Operating Leverage for both scenarios. Save time again. Degree of Operating Leverage Current Structure Degree of articleverage- Proposed Structure Cerence cell reference formula cerrence cell reference formula 3.) Use the Degree of Operating Leverage to determine how a 10% increase in sales will impact Net Income Proposal cellence 6 7 Degree of Operating leverage LABE 9 Net Income Impact @ Old Net income 1 LABEL Current cell reference Sellreference formula eders fans formula es formula 2 New Net Income 46. Sore and print face-to-face class) 5 67.)Copy ROWS 1-17 of this spreadsheet tab ORIGINAL") to the Revisionstab 68 3. Use the "Revision spreadsheet to prove your calculation from instructions of the Original spreadsheet by increasing the sales volume in the date section gray 9 sheded area) by 10. Remember to change anything else in the date section which would be affected by change in sales volume. You should not make any changes So below row 52 6. Save and print face to face class or upload to Blackboard fonline class 53 34 55 66 67 + 70 21 72 73 74 75 75 771 Original Revisions +