EXERCISE $2-$LINEAR OPTIMIZATION

Recall the linear optimization problem for Valencia Products that you worked on in the previous class. The linear program for that problem is shown below. Implement the problem on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables by substituting the optimal solution into the model constraints.

L: # of produced LaserStop

S: # of produced SpeedBuster

Max$124L+136S$

$18L+12S4000($ Availability $ofA)$

$6L+8S3500(AvailabilityofB)$

$L,S0(Nonnegativity)$