Question: Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 12 and changing the objective
Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 12 and changing the objective function coefficient for Product_3 to 18?
Variable Cells
| Cell | Name | Final Value | Reduced Cost | Objective Coefficient | Allowable Increase | Allowable Decrease |
| $B$2 | Product_1 | 0 | 2 | 9 | 3 | 1E+30 |
| $B$3 | Product_2 | 175 | 0 | 12 | 1E+30 | 14 |
| $B$4 | Product_3 | 0 | 1.5 | 15 | 4 | 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 |
Applying the 100% rule,_______________(The optimal solution will not change / the optimal solution may change)because of the total change in the objective function coefficients __________ (does exceed /does not exceed)100%.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
