Question: Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 62 and, at the same
Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 62 and, at the same time, changing the constraint right-hand side for Resource_C to 580?
Variable Cells
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$2 | Product_1 | 0 | 2 | 5 | 2 | 1E+30 |
| $B$3 | Product_2 | 175 | 0 | 7 | 1E+30 | 1 |
| $B$4 | Product_3 | 0 | 1.5 | 9 | 1.5 | 1E+30 |
Constraints
| Cell | Name | Final Value | Shadow Price | Constraint R.H.Side | Allowable Increase | Allowable Decrease |
| $H$9 | Resource_A | 0 | 0 | 100 | 1E+30 | 60 |
| $H$10 | Resource_B | 525 | 0 | 800 | 1E+30 | 440 |
| $H$11 | Resource_C | 700 | 1.75 | 700 | 290 | 200 |
Applying the 100% rule,Answer The shadow price remains validor The shadow price no longer is valid because the total change in the constraint right-hand sides Answer does not exceed ordoes exceed100%.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
