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

2)By how much can the coefficient ofx_1be increased without changing its LP optimal value?Explain why

3)If the RHS constraint ofcons1is decreased to 400, what would be the numerical change in the optimal value of the objective function?

4)If the RHS constraint ofcons2is increased to 330, what would be the numerical change in the optimal value of the objective function?

Microsoft Excel - N-5_0351_LP-ASC.xIs File Edit View Insert Format Tools Data StatPro Window Help Adobe PDF Type a question for help V-ox 4 E - 2 Al [ 200% . Q 3 67. / Office Arial 10 - B / U = = 2 $ % , 184 4 4 8- 2 - A - AutoFormat. .. D' A & N . D. L34 A B C D E F G H 6 Adjustable Cells 7 W Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $C$4 X_1 750 2.5 1E+30 0.7 10 $D$4 x 2 200 DOO 1.2 1.3 1E+30 I'm 11 $E$4 x 3 50 1.8 0.7 1E+30 12 13 Constraints 14 Final Shadow Constraint Allowable Allowable 15 Cell Name Value Price R.H. Side Increase Decrease 16 $G$7 cons1 750 0 600 150 1E+30 17 $G$8 cons2 200 -1.3 200 150 200 18 $G$9 cons3 50 -0.7 50 150 40 19 $G$10 cons4 50 0 10 40 1+30 20 $G$11 cons5 1000 2.5 1000 1E+30 150 > > 190 7:11 PM