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 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 1) What is the optimal objective function value for this problem? 2) If the coefficient for Activity 2 in the objective function changes to $400, will the optimal solution change? Will the objective function value change? If it does, what is the new value? 3) If the right-hand side of Resource B changes to 80, then how will the objective function value change?4) If the objective coefficients of Activity 2 and Activity 3 are both decreased by $100, will the optimal solution change? Why? How would that affect the optimal objective function value?
The following sensitivity report is for the questions below.
|
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 |
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 |
1) What is the optimal objective
2) If the coefficient for Activity 2 in the objective function changes to $400, will the optimal solution change? Will the objective function value change? If it does, what is the new value?
3) If the right-hand side of Resource B changes to 80, then how will the objective function value change?4) If the objective coefficients of Activity 2 and Activity 3 are both decreased by $100, will the optimal solution change? Why? How would that affect the optimal objective function value?
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
