Question: Shown below is a sensitivity report produced by Excel Solver for an LP problem with 3 decision variables ( x_1, x_2, x_3 ) and 5

Shown below is a sensitivity report produced by ExcelSolverfor an LP problem with 3 decision variables (x_1, x_2, x_3) and 5 constraints (cons1, cns2,cons3, cons4, cons5)

1)If we change the coefficient ofx_1in the objective function to 3.0, what would be the resultant LP optimal value ofx_1?Explain why (1-2 sentences).

2)By how much can the coefficient ofx_1be increased without changing its LP optimal value?Explain why (1-2 sentences).

3) If the RHS constraint ofcons1is decreased to 400, what would be the numerical change in the optimal value of the objective function?Explain why (1-2 sentences).

4)If the RHS constraint ofcons2is increased to 330, what would be the numerical change in the optimal value of the objective function?Explain why (1-2 sentences).

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