A linear programming model has been formulated in a spreadsheet to determine the production levels for tomorrow that would maximize profit. The solved spreadsheet model and corresponding sensitivity reports shows determine the production levels for tomorrow that would maximize profit. The solved spreadsheet model and corresponding sensitivity reports shows below for each of the following parts 1. Allowable Decrease for Production of Mugs 2. Allowable Decrease for Amount of Clay (ounces) Used:

Transcribed Image Text:

Variable Cells Cell Name Value Cost Final Reduced Objective Allowable Allowable Coefficient Increase Decrease $B$10 Production Plates 300 0 3.1 2.23 0.37 $C$10 Production Mugs 0 -0.46 4.75 0.46 $D$10 Production Steins 400 0 4 0.65 1.37 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$5 Molding (minutes) Used 2400 0.22 2400 200 600 $E$6 Finishing (minutes) Used 7200 0.28 7200 2400 2400 $E$7 Clay (ounces) Used 2700 0 3000 1E+30 Variable Cells Cell Name Value Cost Final Reduced Objective Allowable Allowable Coefficient Increase Decrease $B$10 Production Plates 300 0 3.1 2.23 0.37 $C$10 Production Mugs 0 -0.46 4.75 0.46 $D$10 Production Steins 400 0 4 0.65 1.37 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$5 Molding (minutes) Used 2400 0.22 2400 200 600 $E$6 Finishing (minutes) Used 7200 0.28 7200 2400 2400 $E$7 Clay (ounces) Used 2700 0 3000 1E+30

Answer rating: 100% (QA)

It looks like the information provided is from a sensitivity analysis of a linear programming model ... View the full answer