Q42 D G 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. 2 Current Structure 3 Unit Sales 4 Sales Price Per Unit 5 Total Variable Costs (based on 20,000 units) 6 Total Fixed Costs Proposed Structure 20,000 $ 100 $700,000 20,000 100 Unit Sales Sales Price Per Unit 400,000 900,000 Total Variable Costs (based on 20,000 units) Total Fixed Costs $600,000 71.) 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 Structure 11 12 Total 13 Type a Label Here 14 Type a Label Here 15 Type a Label Here 16 Type a Label Here formula cell reference formula cell reference formula Per Unit cell reference % of Sales formula formula formula formula formula 17 Type a Label Here 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 21 22 cell reference. 23 cell reference 24 25 261 27 cell reference 28 cell reference 29 30 Breakeven Units-Current Structure Breakeven Units-Proposed Structure formula cell reference cell reference formula Breakeven Sales Dollars-Current Structure Breakeven Sales Dollars-Proposed Structure formula cell reference cell reference formula