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.

 I know the answer is for sure not "the optimal solution
will change" The following tables were generated in the sensitivity report by
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. 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

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 Finance Questions!