Attempts Remaining $1$ Submit AutoSave Off H PB Financials.xlsx $-$ Excel Solver Parameters File Home Insert Page Layout Formulas Data Review View Tell me what you want to do Set Objective: $1$ Queries & Connections $21$ T Y clear $21$ Sort To: O Min o Max $0$ O Value of: Get From From From Table$/$ Recent Existing Data Text$/$CSV Web Range Sources Connections B Properties Edit Links Refresh All Reapply ERO Text to Advanced Columns ESD Filter By Changing Variable Cells: Get & Transform Data Queries & Connections Sort & Filter $$ Subject Constraints: A B $$ D E F G H Add Change Precision Building Delete $1$ Reset All Load$/$Save $202157,897,58337,633,429$ Make Unconstrained variables Non$-$Negative GRG Nonlinear Select a Solving Method: Options $2$ Profit and Loss Statement $320204$ Sales $ $55,140,555$ $ $5$ Direct Costs $ $35,841,361$ $ $6$ Gross Margin $78$ Operating Expenses $9$ Corporate Payroll $ $676,251$ $ $10$ Contractor Wages $ $15,865,917$ $ $11$ Facilities $ $658,000$ $ $12$ Equipment and Supplies $ $327,500$ $ $13$ Insurance $ $275,800$ $ $14$ Marketing$/$Advertising $ $346,300$ $ $15$ Total Expenses $ $18,149,767$ $ $16$ Income Statement $+$ Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non$-$smooth. $676,25116,500,553690,900343,875289,590363,61518,864,784$ Task Instructions Help Create a Solver model with a target value of $1450000$ for cell C$17$ and cell C$9$ as the variable cell. Run the Solver model and keep the results, then close the Solver Results dialog box. Enter