1. Describe to the manager what the report means including:

   1. Variable cells (Door and Window):

      1. Final value

      2. Objective coefficient

      3. Allowable increase

      4. Allowable decrease

   2. Constraints (cutting, sanding, finishing)

      1. Final value

      2. Shadow prices (if any is zero, explain this)

      3. Allowable increase

A Window Door $26,000 Units Produced Profit = 20 40 $500 $400 Profit Consumed Available 40 Constraint Cutting Sanding 1 0.5 40 40 40 0.5 0.75 Finishing 50 60 0.5 Microsoft Excel 16.26 Sensitivity Report Worksheet: [391 Project Part 2.xlsx]Sanderson Report Created: 6/2/19 11:29:31 PM Variable Cells Final Reduced Objective Allowable Allowable Coefficient Cell Value Name Cost Increase Decrease $D$2 Units Produced Door 20 500 300 233.3333333 $E$2 Units Produced Window 40 400 350 150 Constraints Allowable Final Shadow Constraint Allowable Cell Value Price Name R.H. Side Increase Decrease $F$6 Cutting Used $F$7 Sanding Used $F$8 Finishing Used 40 350 40 13.33333333 40 40 300 40 20 6.666666667 50 60 1E+30 10 A Window Door $26,000 Units Produced Profit = 20 40 $500 $400 Profit Consumed Available 40 Constraint Cutting Sanding 1 0.5 40 40 40 0.5 0.75 Finishing 50 60 0.5 Microsoft Excel 16.26 Sensitivity Report Worksheet: [391 Project Part 2.xlsx]Sanderson Report Created: 6/2/19 11:29:31 PM Variable Cells Final Reduced Objective Allowable Allowable Coefficient Cell Value Name Cost Increase Decrease $D$2 Units Produced Door 20 500 300 233.3333333 $E$2 Units Produced Window 40 400 350 150 Constraints Allowable Final Shadow Constraint Allowable Cell Value Price Name R.H. Side Increase Decrease $F$6 Cutting Used $F$7 Sanding Used $F$8 Finishing Used 40 350 40 13.33333333 40 40 300 40 20 6.666666667 50 60 1E+30 10