Based On The Following Sensitivity Report What Would Be The Impact Of Changing The Objective Function Coefficient For P 1 (30.12 KiB) Viewed 65 times
Based On The Following Sensitivity Report What Would Be The Impact Of Changing The Objective Function Coefficient For P 2 (28.9 KiB) Viewed 65 times
Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 11 and changing the objective function coefficient for Product_3 to 11? Variable Cells Allowable Increase Cell $B$2 $B$3 $B$4 Final Value Reduced Cost| 0 -2 175 0 0 -1.5 Name Product 1 Product_2 Product_3 6 Objective Coefficient 9 10 10 Allowable Decrease 1E+30 14 1E+30 1 E+30 5 Constraints Shadow Price Cell $H$9 $H$10 $H$11 0 Final Value 0 525 700 Name Resource_A A Resource_B Resource_C Constraint R.H.Side 100 800 700 Allowable Increase 1E+30 1E+30 366.6666667 Allowable Decrease 100 275 700 0 1.75 Applying the 100% rule, because the total change in the objective function coefficients 100% The optimal solution will not change The optimal solution may change
Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 11 and changing the objective function coefficient for Product_3 to 11? Variable Cells Objective Coefficient Cell $B$2 B Final Value Reduced Cost 0 -2 175 -1.5 Name Product 1 Product 2 Product_3 9 Allowable Increase 6 1E+30 5 Allowable Decrease 1E+30 14 1E+30 $B$3 10 $B$4 10 Constraints Final Value Shadow Price Name Cell $H$9 $H$10 $H$11 Resource A Resource B Resource_ Constraint R.H. Side 100 800 700 Allowable Increase 1E+30 1E+30 366.6666667 Allowable Decrease 100 275 700 525 700 1.75 Applying the 100% rule, because the total change in the objective function coefficients 100% does exceed does not exceed
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!