Question: The following is the sensitivity report for a maximization problem. If the company can increase the available hours for one of their constraints by two
The following is the sensitivity report for a maximization problem. If the company can increase the available hours for one of their constraints by two hours, which constraint the should increase?
MAX 50R + 75S
s.t.
1.2 R + 1.6 S 600 assembly (hours)
0.8 R + 0.5 S 300 paint (hours)
.16 R + 0.4 S 100 inspection (hours)
Sensitivity Report:
| Cell |
Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$7 | Regular = | 291.67 | 0.00 | 50 | 70 | 20 |
| $C$7 | Super = | 133.33 | 0.00 | 75 | 50 | 43.75 |
| Cell |
Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $E$3 | Assembly (hr/unit) | 563.33 | 0.00 | 600 | 1E+30 | 36.67 |
| $E$4 | Paint (hr/unit) | 300.00 | 33.33 | 300 | 39.29 | 175 |
| $E$5 | Inspect (hr/unit) | 100.00 | 145.83 | 100 | 12.94 | 40 |
Select one:
a.
Paint
b.
Inspect
c.
Assembly
d.
Paint or Inspect
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
