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 28? Variable Cells Allowable Increase Cell Objective Coefficient 13 Final Value Reduced Cost 0 -2 175 0 0 -1.5 Allowable Decrease 1E+30 $B$2 $B$3 $B$4 3 Name Product_1 Product_2 Product 3 15 14 8 4 1E+30 Constraints Final Value Shadow Price Cell $H$9 $H$10 $H$11 Name Resource_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 525 700 0 1.75 (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
