Problems 8 and 15 in Chapter 13 presented a scenario for Bangs Leisure Chairs.  The Solver Sensitivity Report for the optimal solution (Problem 15a only) is shown in Figure 15.38. Clearly explain the information it provides.

Data from Figure 15.38

Transcribed Image Text:

Variable Cells 7 8 Cell Name 9 $B$14 Quantity Produced Sling Chairs SC$14 Quantity Produced Adirondack 10 11 $D$14 Quantity Produced Hammocks 12 13 Constraints 14 15 Cell Name $E$15 Cutting Hours Used SES16 Assembling Hours Used SE$17 Finishing Hours Used 16 17 18 19 $E$18 Total Hours Used Final Value Cost 0-4.758064516 22.58064516 1.612903226 Final Value 45.80645161 Reduced Objective Allowable Coefficient Increase 40 4.758064516 1E+30 100 2.272727273 8.550724538 90 39.33333333 24.19354839 0 Shadow Constraint Price R.H. Side 50 1.612903226 0 G 120 19.35483871 Allowable Increase Allowable Decrease Allowable Decrease 1E+30 4.193548387 50 50 31.81818182 50 120 2 1E+30 25.80645161 5 46.56666667