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 |
What is the optimal objective function value for this problem?
Question 47 options:
|
|
|
| a) | $90. |
|
|
|
| b) | $240. |
|
|
|
| c) | $7.78. |
|
|
|
| d) | $330. |
|
|
|
| e) | It cannot be determined from the given information. |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
