Please help with the below question #4, by using solver. I don't know if I have the correct Parameters. Enter a constraint if needed. On the operating margin I calculated by using formula =D23/D16.

Review Help File Home Insert Page Layout Formulas Data View From Text/CSV Recent Sources Queries & Connections From Web [ Existing Connections B Properties Get Refresh Data E From Table/Range All Edit Links Get & Transform Data Queries & Connections 21 72 Z Sort y Clear Te Reapply Advanced ! Flash Fill - Consolidate Remove Duplicates Relationships Text to Columns E Data Validation Manage Data Model Stocks Currencies Geography Automatic Filter W An: Data Types Sort & Filter Data Tools X fa L A B D E F G . 6 4) Management want to reduce S&GA. How much do they have to save to hit a 15% Operating Margin. Enter that number in d in yellow 7 Profitability 9 Operating Margin 13% 11 Revised S&GA 12 HINT: Use the solver tool 13 Serendipity Manufacturing Co, Inc Solver Parameters 14 Consolidated Income Statement 15 Year X Year X-1 Set Objective: SD$11 16 Net Sales 765,000 725,000 17 Cost of Sales 535,000 517,000 To: O Max O Min O Value of: 0.15 18 Gross Profit 230,000 208,000 By Changing Variable Cells: 19 SD$21,SD$221 1 20 Operating Expenses 21 Subject to the Constraints: Depreciation and Amortization 28,000 25,000 Add 22 Selling, General and Admin Expenses 100,929 109,500 23 Operating Income 101,071 73,500 Change 24 Delete 25 Other Income (Expense) 26 Dividend and Interest Income 5,250 9,500 Reset All 27 Interest Expense (12,125) (16,250) Load/Save 28 Foreign Currency gain (loss) 2,000 (1,000) Make Unconstrained variables Non-Negative 29 Income Before Taxes and Extraordinary Loss 96,196 65,750 Select a Solving GRG Nonlinear 30 Method: Options 31 Income Taxes 41,446 26,250 Solving Method 32 Income Before Extraordinary Loss 54,750 39,500 Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP 33 Extraordinary Loss (5,000) Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non-smooth. 34 Net Income 49,750 39,500 35 Help Solve 36 Close 37 Serendipity Manufacturing Co, Inc