Question: Based on the following sensitivity report, what would be the impact of changing the objective function coefficient for Product_1 to 12 and changing the objective

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

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 10 1E+30 14
$B$4 Product_3 0 1.5 8 6 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

Applying the 100% rule, ------ (the optimal solution may change/the optimal solution will not change) because the total change in the objective function coefficients ----- (does exceed/does not exceed) 100%.

please provide correct answers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!