Required information Excel Analytics 05-01 (Static) Cost-Volume-Profit Relationships (LO5-1, LO5-2, LO5-5, LO5-6, LO5-7) [The following information applies to the questions displayed below) Donaldson Company's contribution format income statement for the most recent month is shown below: Total $500,000 300,000 200,000 180,000 $ 20,000 Per Unit $12.50 7.50 $ 5.00 Sales Variable expenses Contribution margin Fixed expenses Net operating income The company sold 40,000 units in its most recent month and its relevant range of production is 30,000 to 50,000 units. Click here to download the Excel template, which you will use to answer the questions that follow Click here for a brief tutorial on Goal Seek in Excel Click here for a brief tutorial on SOLVER in Excel Click here for a a brief tutorial on Charts in Excel Excel Analytics 05-01 (Static) Part 3 4. Using Charts Prepare a profit graph for Donaldson Company. To prepare your graph use sales volumes of rounds and 50.000 unta spowin Cel 23 and 24 secrete mancata come profit when unit sies are ter Your formule should reference data from the contribution format income statement provided into the worst Accoy yow cho coll 24. The profit for oss shown in cells 23 and 24 provide the two data points that you need to create a profit b. Prepare CVP groh for Donaldson Company to prepare your graph, se sales volumes of seront and 10.000 unts as shown in 79 and 600 Asino come formatie C21,00 Ezt compute the total started expenses, and total expenses when in sales are your forms should reference dentro e contribution forma constamment provide in rows the worksheet As a seconds, Copy your formules from cells 29.02. und 29, to cell 0.030, and The Sound post your create 5. Next, assume the company can decrease its variable expense per unit from $750 to $700 and decreased petsson 100.000 to 55000 de dos . Prepare a profit graph for Donaldson Company b. Prepare a CVP prograph for Donaldson Company Save your completed worksheet to your computer and then upload it here by clicking "Browse Next click "Sure." Formatting as Table Str D G H % 100% 50% 405 Margin of Safety Actual sales(a) Break-even sale by Margin of safety in dollars (al-(b) Margin of safety percentage 5 $ 5 500.000 450.000 50.000 10.00% B 4 Dato Inputs: 5 Init sales 40.000 Gelling price per unit 5 12.50 7 ariable expense per unit s 7.50 8 tal fixed expenses $ 180,000 9 10 Contribution Format Income Statement 11 Total Per Unit 12 ales $ 500,000 $ 12.50 13 ariable expenses 300,000 7:50 14 ontribution margin 200,0005 5.00 15 ixed expenses 180.000 16 let operating income 20.000 17 18 Jet profit margin percentage 4.00% 19 20 21 rofit Graph Information 22 Profit 23 Data Points 24 50,000 25 26 27 VP Graph Information 28 Sales Dollars 29 Data Points 50,000 30 31 32 33 34 Fired Expenses Total Expenses