(Solved): please help, show steps in excel 11. Implement the linear optimization model that you developed for ...

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. Valencia Products 18 Numbers Produced Unit Profit $124.00 Component A Component B 10 11 TOTAL PROFIT 33 LaserStop SpeedBuster 0.00 333.33 $138.00 18 6 D F G Used 12 4000 4000 units available 8 2006 0066673500 units available M Answer Report Objective Cell (Max) Variable Cels Constraints Cell Name SAS12 TOTAL PROFIT Cell Name 3018 Component A Used 5019 Component 8 Used K Name Cell $855 Numbers Produced Laserstop SC$5 Numbers Produced SpeedBuster M Original Value Final Value $0.00 $45,333.33 N Original Value Final Value Integer 0.00 0.00 0.00 Contin 333.33 Contin O Cell Value Formula Status 4000 1018$F$8 Binding 2006.000067 3059-F59 Not finding 833.3333333 Slack 0 D19 14 15 16 1292 1 Valencia Products 2 3 4 5 Numbers Produced 6 Unit Profit 7 8 9 10 11 TOTAL PROFIT 12 13 17 18 AV 20 A x vfx | Component A Component B LaserStop Speed Buster 333.33 $136.00 0.00 $124.00 ? 18 6 12 8 Used D E 4000 2666.666667 < F G 4000 units available 3500 units available H 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 M Original Value Final Value $0.00 $45,333.33 Original Value Final Value 0.00 0.00 N Integer 0.00 Contin 333.33 Contin Cell Value Formula Status 4000 $D$8<-$F$8 Binding 2666.666667 $D$9<-$F$9 Not Binding 833.3333333 Slack 0