Question: Variable cells Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2
Variable cells
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$6 | Activity 1 | 3 | 0 | 30 | 23 | 17 |
| $C$6 | Activity 2 | 6 | 0 | 40 | 50 | 10 |
| $D$6 | Activity 3 | 0 | 7 | 20 | 7 | 1E+30 |
Constraints
| Cell | Name | Final Value | Shadow Price | Constraint R.H. Side | Allowable Increase | Allowable Decrease |
| $E$2 | Resource A | 20 | 7.78 | 20 | 10 | 12.5 |
| $E$3 | Resource B | 30 | 6 | 30 | 50 | 10 |
| $E$4 | Resource C | 18 | 0 | 40 | 1E+30 | 22 |
1. If the coefficient for Activity 3 in the objective function changes to $30, then the objective function value:
will increase by $70.
is $0.
will increase by $30.
will remain the same.
will increase by an unknown amount.
2. Which parameter is most sensitive to an increase in its value?
The objective coefficient of Activity 1.
The objective coefficient of Activity 2.
The objective coefficient of Activity 3.
All of the choices are correct.
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
