$1.$ Open the Excel spreadsheet Solver Assessment Spreadsheet.

$2.$ Save the spreadsheet as: Firstname$\_$Lastname$\_$Solver Assessment Spreadsheet.

$3.$ First calculate the $$inventory used$$ in cell F$10(=$C$10*$$C$$6+$D$10*$$D$$6+$E$10*$$E$$6).$ Copy the formula to F$11$:F$14.$ NOTE: Nothing will change in these cells until you add variables and constraints.

$4.$ Start Solver $($Data Tab, Analysis Group$).$ If you don$$t have it refer to the Training to add.

$5.$ Use the Total Profits cell as the objective $($$C$$18)..$

$6.$ You want to maximize profits.

$7.$ Enter the variable cells that you want to change to achieve maximum profits $($$C$$6$:$E$$6).$

$8.$ Add the following constraints:

a$.$ The leftover stock of raw materials should be greater than or equal to zero. So$,$ enter $G$$10$:$G$$14$ as the cell reference, then greater than or equal to $(>=),$ then $0$ as the constraint.

b$.$ The quantity of the three products $($television set, stereo, and speaker$)$ should be greater than or equal to zero. So$,$ enter $C$$6$:$E$$6>=0$ as done for the preceding point.

$9.$ Select the solving method as GRG nonlinear.

$10.$ Click $$solve$.$ Click to keep the solution. Review the results.