1. Using Charts: Prepare a CVP graph for Donaldson Company. To prepare your graph, use sales volumes of zero units and 50,000 units as shown in cells B29 and B30.

• As a first step, create formulas in cells C29, D29, and E29 that compute the total sales dollars, total fixed expenses, and total expenses when unit sales are zero. Your formulas should reference data from the contribution format income statement provided in rows 4 through 18 of the worksheet.
• As a second step, copy your formulas from cells C29, D29, and E29, to cells C30, D30, and E30. The information shown in rows 29 and 30 provides the data points that you need to create a CVP graph.

Excel File Edit View Insert Format Tools Data Window Help 2 Sat Mar 19 2:17 PM O.. AutoSave OFF ASP . U ExcelAnalytics_CVPRelationships_Template (2) Home Insert Draw Page Layout Formulas Data Review View Tell me Share V Comments X Calibri (Body) V 11 YA APA = = Oy S. Wrao Text General y 3-I-E v 27. Or WS Paste B TU Merga & Center $ % 9 111 Insert Delete Conditional Format Cell Formatting as Table Styles Format Sort & Filter Find & Select Analyze Data Open recovered workbooks? Your recent changes were saved. Da you want to continue working where you left off? Yos No K21 D E H J L % 100% % 60% Margin of Safety Actual sales (a) Break-even sales {b) Margin of safety in dollars (a) (b) Margin of safety percentage $ $ $ 500.000 450,000 50,000 40% 10.00% B 4 Date Inputs: 5 Unit sales 40,000 6 Selling price per unit $ 12.50 7 Variable expense per unit $ 7.50 8 Total fixed expenses $ 180,000 9 10 Contribution Format Income Statement 11 Total Per Unit 12 Sales $ 500,000 $ 12.50 13 Variable expenses 300,000 7.50 14 Contribution margin 200,000 $ 5.00 15 Fixed expenses 180,000 16 Net operating income $ 20,000 17 18 Net profit margin percentage 4.00% 19 20 21 Profit Graph Information 22 Profit 23 Data Points 24 50,000 25 26 27 CVP Graph Information 28 Sales Dollars 29 Data Points 30 50,000 31 32 Goal Soak Solver Charts Template + Select destination and press ENTER or chacse Paste Fixed Expenses Total Expenses 120% MAR 81571 19 ZA O 2