Question: Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_2 increases to
Based on the following sensitivity report, what would be the change in the objective function value if the objective function coefficient for Product_2 increases to 20?
Variable Cells
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
|---|---|---|---|---|---|---|
| $B$2 | Product_1 | 0 | 2 | 12 | 3 | 1E+30 |
| $B$3 | Product_2 | 175 | 0 | 15 | 8 | 1 |
| $B$4 | Product_3 | 0 | 1.5 | 12 | 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 | 100 |
| $H$10 | Resource_B | 525 | 0 | 800 | 1E+30 | 275 |
| $H$11 | Resource_C | 700 | 1.75 | 700 | 366.6666667 | 700 |
Note: Round your answer to the nearest whole number.

Change in the objective function value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
