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 2 decision variables (x1, x2) and 3 constraints (cons1, cons2, cons3) Use the information to solve the following 5 questions Variable Cells Final Reduced Objective AllowableAllowable Cell NameValue Cost Coefficient Increase Decrease $B$4 x1600200300200 $C$4 x22005001E+30300 Constraints Final Shadow Constraint AllowableAllowable Cell NameValue Price R.H. Side Increase Decrease $D$7 cons110001601E+3060 $D$8 cons2401504012040 $D$9 cons380200806060Sensitivity Analysis (Sample Questions) If we change the coefficient of x1 in the objective function to 300, what would be the numerical change in the LP optimal value of x1? A.0 B.200 C.300 D.500 E. We have to solve the problem again If we change the coefficient of x2 in the objective function to 100, what would be the numerical change in the LP optimal value of x2? A.0 B.100 C.300 D.500 E. We have to solve the problem againSensitivity Analysis (Sample Questions) If the RHS constraint of cons1 is increased to 200, what would be the numerical change in the LP optimal value of the objective function? A.0 B.40 C.60 D.160 E. We have to solve the problem again If the RHS constraint of cons2 is increased to 80, what would be the numerical change in the LP optimal value of the objective function? A.40 B.120 C.150 D.6000 E. We have to solve the problem again If the RHS constraint of cons3 is increased to 160, what would be the numerical change in the LP optimal value of the objective function? A.60 B.80 C.200 D.16000 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 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!