Part b: When you get the Solver Results dialog page, run a sensitivity report (see below) and interpret the allowable increase and decrease for both the variable cells (doors and windows produced) and the constraints (Plants 1,2, and 3). Sensitivity reports and interpretation are discussed in the text on pp. 160-162.

Microsoft Excel 15.28 Sensitivity Report Worksheet: [Wyndor.xlsx]Wyndor Report Created: 9/14/19 12:21:19 PM Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$12 Units Produced Doors 4 0 600 1E+30 150 $D$12 Units Produced Windows 3 0 300 100 300 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $E$7 Plant 1 Used 4 150 4 2 2 $E$8 Plant 2 Used 6 0 12 1E+30 6 $E$9 Plant 3 Used 18 150 18 6 6