Question: Shown below is a sensitivity report produced by Excel Solver for an LP problem with 2 decision variables ( x 1 , x 2 )
Shown below is a sensitivity report produced by Excel Solver for an LP problem with decision variables x x and constraints cons cons cons Use the information to solve the following questions Variable Cells Final Reduced Objective AllowableAllowable Cell NameValue Cost Coefficient Increase Decrease $B$ x $C$ xE Constraints Final Shadow Constraint AllowableAllowable Cell NameValue Price RH Side Increase Decrease $D$ consE $D$ cons $D$ consSensitivity Analysis Sample Questions If we change the coefficient of x in the objective function to what would be the numerical change in the LP optimal value of x A B C D E We have to solve the problem again If we change the coefficient of x in the objective function to what would be the numerical change in the LP optimal value of x A B C D E We have to solve the problem againSensitivity Analysis Sample Questions If the RHS constraint of cons is increased to what would be the numerical change in the LP optimal value of the objective function? A B C D E We have to solve the problem again If the RHS constraint of cons is increased to what would be the numerical change in the LP optimal value of the objective function? A B C D E We have to solve the problem again If the RHS constraint of cons is increased to what would be the numerical change in the LP optimal value of the objective function? A B C D E We have to solve the problem again
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
