Wk Qu. 5-14 Based on the following sensitivity... 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 Cell $852 $B$ 3 $B$4 Name Product 1 Product 2 Product_3 Final Value Reduced cost e -2 175 -1.5 Objective Coefficient 13 15 Allowable Increase 3 14 4 Allowable Decrease 1E+30 1 1E+30 8 Constraints Shadow Price Cell SH$9 SH$10 54511 Name Resource Resource B Resources Final Value . 525 700 Constraint R.H. Side 100 800 700 Allowable Increase 1E+30 1E+30 366.6666667 Allowable Decrease 100 275 700 1.75 (Round your answer to the nearest whole number.) Change in the objective function value Based on the following sensitivity report, how much should the firm be willing to pay for 55 more units of Resource_C? Variable Cells Objective Coefficient Cell $B$2 $B$3 $B$4 Name Product 1 Product 2 Product 3 Final Value Reduced Cost -2 175 -1.5 5 7 9 Allowable Increase 2 1E+30 1.5 Allowable Decrease 1E+30 1 1E+30 Constraints Final Value Shadow Price Cell $$9 SH$ 10 $4511 Name Resource A Resources Resource_ Constraint R.H.Side 100 800 700 Allowable Increase 1E +30 1E+30 180 Allowable Decrease 90 340 73 525 700 1.35 (Round your answer to 2 decimal places.) Units of Resource_C Wk Qu. 5-14 Based on the following sensitivity... 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 Cell $852 $B$ 3 $B$4 Name Product 1 Product 2 Product_3 Final Value Reduced cost e -2 175 -1.5 Objective Coefficient 13 15 Allowable Increase 3 14 4 Allowable Decrease 1E+30 1 1E+30 8 Constraints Shadow Price Cell SH$9 SH$10 54511 Name Resource Resource B Resources Final Value . 525 700 Constraint R.H. Side 100 800 700 Allowable Increase 1E+30 1E+30 366.6666667 Allowable Decrease 100 275 700 1.75 (Round your answer to the nearest whole number.) Change in the objective function value Based on the following sensitivity report, how much should the firm be willing to pay for 55 more units of Resource_C? Variable Cells Objective Coefficient Cell $B$2 $B$3 $B$4 Name Product 1 Product 2 Product 3 Final Value Reduced Cost -2 175 -1.5 5 7 9 Allowable Increase 2 1E+30 1.5 Allowable Decrease 1E+30 1 1E+30 Constraints Final Value Shadow Price Cell $$9 SH$ 10 $4511 Name Resource A Resources Resource_ Constraint R.H.Side 100 800 700 Allowable Increase 1E +30 1E+30 180 Allowable Decrease 90 340 73 525 700 1.35 (Round your answer to 2 decimal places.) Units of Resource_C
