Question: Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 0 425 500 1E+30 425 $C$6 Activity 2
Variable cells
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$6 | Activity 1 | 0 | 425 | 500 | 1E+30 | 425 |
| $C$6 | Activity 2 | 27.5 | 0.0 | 300 | 500 | 300 |
| $D$6 | Activity 3 | 0 | 250 | 400 | 1E+30 | 250 |
Constraints
| Cell | Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $E$2 | Benefit A | 110 | 0 | 60 | 50 | 1E+30 |
| $E$3 | Benefit B | 110 | 75 | 110 | 1E+30 | 46 |
| $E$4 | Benefit C | 137.5 | 0 | 80 | 57.5 | 1E+30 |
If the right-hand side of Resource C changes to 130, then:
a. the original solution remains optimal.
b. the problem must be resolved to find the optimal solution.
c. the shadow price is valid.
d. the shadow price is not valid.
e. None of the choices is correct.
If the coefficient for Activity 1 in the objective function changes to $50, then the objective function value:
a. will decrease by $450.
b. is $0.
c. will decrease by $2750.
d. will remain the same.
e. can only be discovered by resolving the problem.
If the right-hand side of Resource C is increased by 40, and the right-hand side of Resource B is decreased by 20, then:
a. the optimal solution remains the same.
b. the optimal solution will change.
c. the shadow price is valid.
d. the shadow price may or may not be not valid.
e. None of the choices is correct.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
