Question: Based on the following sensitivity report, how much should the firm be willing to pay for 118 more units of Resource_C? Variable Cells Objective Coefficient

Based on the following sensitivity report, how much should the firm be willing to pay for 118 more units of Resource_C? Variable Cells Objective Coefficient Allowable Increase Cell SB$2 $B$3 $B$4 2 Final Value Reduced Cost @ -2 175 8 -1.5 Name Product 1 Product 2 Product_3 5 7 Allowable Decrease 1E+30 1 1E+30 1E+30 1.5 9 Constraints Final Value Cell SH59 SH$10 SHS11 Name Resource A Resource o Resource C Shadow Price @ @ + 1.09 Constraint R.H. Side 100 808 Allowable Increase 1E+30 1E+30 180 Allowable Decrease 30 320 61 525 700 700 (Round your answer to 2 decimal places.) Units of Resource_C 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 21? Variable Cells Allowable Increase Cell $852 $653 $854 Final Value Reduced Cost -2 175 Nane Product 1 Product_2 Product_3 Objective Coefficient 13 14 13 Allowable Decrease 1E+30 4 11 7 16.30 Constraints Final Value Shadow Price 0 Allowable Increase Cell SHS 9 SHS 28 SH511 Name Resource Resources Resource Constraint R.H. Side 100 800 700 Allowable Decrease 200 275 700 525 700 LE+30 366.6566667 1.75 (Round your answer to the nearest whole number.) Change in the objctive function value Based on the following sensitivity report, how much should the firm be willing to pay for 118 more units of Resource_C? Variable Cells Objective Coefficient Allowable Increase Cell SB$2 $B$3 $B$4 2 Final Value Reduced Cost @ -2 175 8 -1.5 Name Product 1 Product 2 Product_3 5 7 Allowable Decrease 1E+30 1 1E+30 1E+30 1.5 9 Constraints Final Value Cell SH59 SH$10 SHS11 Name Resource A Resource o Resource C Shadow Price @ @ + 1.09 Constraint R.H. Side 100 808 Allowable Increase 1E+30 1E+30 180 Allowable Decrease 30 320 61 525 700 700 (Round your answer to 2 decimal places.) Units of Resource_C 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 21? Variable Cells Allowable Increase Cell $852 $653 $854 Final Value Reduced Cost -2 175 Nane Product 1 Product_2 Product_3 Objective Coefficient 13 14 13 Allowable Decrease 1E+30 4 11 7 16.30 Constraints Final Value Shadow Price 0 Allowable Increase Cell SHS 9 SHS 28 SH511 Name Resource Resources Resource Constraint R.H. Side 100 800 700 Allowable Decrease 200 275 700 525 700 LE+30 366.6566667 1.75 (Round your answer to the nearest whole number.) Change in the objctive function value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
