Question: I know the answer is for sure not the optimal solution will change The following tables were generated in the sensitivity report by Excel Solver.

The following tables were generated in the sensitivity report by Excel Solver. Variable cells Cell Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease $B$6 Activity 1 3 0 30 23 17 $C$6 Activity 2 6 0 40 50 10 $D$6 Activity 3 0 -7 20 7 1E+30 Constraints Cell Name Final Shadow Constraint Value Price R.H. Side Allowable Increase Allowable Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 Cell Name Final Shadow Constraint Value Price R.H. Side Allowable Allowable Increase Decrease $E$2 Resource A 20 7.78 20 10 12.5 $E$3 Resource B 30 6 30 50 10 $E$4 Resource C 18 0 40 1E+30 22 If the right-hand side of Resource B is increased by 30, then: The optimal solution will change. The shadow prices of the resources remains the same The shadow prices might change. The optimal solution remains the same
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
