Solve Linear Optimization Models

$12.$ In the Data tab, click on the Solver souver button. In the Solver Parameters windows, set the followings:

If you do not have the Solver button in excel, please refer to the link: Load the Solver Add$-$in in Excel.

For the Set Objective field, set the objective to maximize total profit $($D$22).$

For the By Changing Variable Cells field, set the decision variables as Jordanelle skis and Deercrest skis produced per day $($B$14$ and C$14).$

For the Subject to the Constraints field, add the five constraints from step $4.$

For the Select a Solving Method field, choose Simplex LP as the solving method.