A. Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to15 and changing the objective function coefficient for Product_3 to 17?

Variable Cells

Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease

$B$2 Product_1 0 2 10 5 1E+30

$B$3 Product_2 175 0 12 1E+30 15

$B$4 Product_3 0 1.5 15 3 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

1. Applying the 100% rule

2. Because the total change in the objective function coefficients _______ 100%

B. Based on the following sensitivity report, what would be the impact of changing the constraint right-hand side for Resource_A to 69 and, at the same time, changing the constraint right-hand side for Resource_C to 580?

Variable Cells

Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease

$B$2 Product_1 0 2 5 2 1E+30

$B$3 Product_2 175 0 7 1E+30 1

$B$4 Product_3 0 1.5 9 1.5 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 20

$H$10 Resource_B 525 0 800 1E+30 350

$H$11 Resource_C 700 1.75 700 380 180

1. Applying the 100% rule

2. Because the total change in the objective function coefficients _______ 100%

C. Based on the following sensitivity report, how much should the firm be willing to pay for 118 more units of Resource_C?

Variable Cells

Cell Name Final Value Reduced Cost Objective Coefficient Allowable Increase Allowable Decrease

$B$2 Product_1 0 2 5 2 1E+30

$B$3 Product_2 175 0 7 1E+30 1

$B$4 Product_3 0 1.5 9 1.5 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 30

$H$10 Resource_B 525 0 800 1E+30 320

$H$11 Resource_C 700 1.09 700 180 61

1. What is the Units of Resource_C?