Answer Happy

11. Implement the linear optimization model that you developed for Valencia Products in Problem 4 on a spreadsheet and use Solver to find an optimal solu- tion. 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.

1 Valencia Products 2 3 4 5 Numbers Produced 6 Unit Profit 7 8 9 10 11 TOTAL PROFIT 12 13 456 14 15 16 17 18 19 2723 20 Component A Component B 21 B с LaserStop SpeedBuster 0.00 333.33 $124.00 $136.00 18 6 Used D E 12 4000 8 2666.666667 < F LL G 4000 units available 3500 units available

Answer Report Objective Cell (Max) Variable Cells Constraints J Cell $A$12 TOTAL PROFIT Name Cell Name $B$5 Numbers Produced LaserStop $C$5 Numbers Produced SpeedBuster Cell Name $D$8 Component A Used $D$9 Component B Used L M Original Value Final Value $0.00 $45,333.33 N Original Value Final Value Integer 0.00 Contin 0.00 0.00 333.33 Contin Cell Value O Formula Status 4000 $D$8< $F$8 Binding 2666.666667 $D$9<=$F$9 Not Binding 833.3333333 Slack 0