Question: Please also explain the answer. Appreciate it! Q4. Multiple Choice) (10 pts.) (Excel Solver Question) The Sensitivity Analysis report given below for a Linear Programming

Please also explain the answer. Appreciate it!
Q4. Multiple Choice) (10 pts.) (Excel Solver Question) The Sensitivity Analysis report given below for a Linear Programming (LP) problem. Microsoft Excel 16.0 Sensitivity Report Worksheet: [Book1.xlsx]Sheet Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 X1 4 0 1 0 1 $C$4 X2 4 0 1 1 0 $D$4 X3 6 0 1 0 1 $E$4 X4 1 0 1 1 0 $F$4 X5 11 0 1 0 1 $G$4 X6 0 o 1 1E+30 0 0 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $B$11 Const 4 1 4 1 4 $B$12 Const 8 0 8 6 1 $B$13 Const 10 1 10 1 6 $B$14 Const 7 7 7 1 $B$15 Const 12 1 12 1E+30 7 $B$16 Const 11 0 4 7 1E+30 Which of the following statements is NOT CORRECT based on the report? a) The LP problem has multiple optimal solutions b) The optimal value is 26. c) If the coefficient of X1 decreases by 1 unit, then the optimal value decreases by 4 units. d) If the coefficients of X1 and X3 decrease by 1 unit at the same time, then the optimal value decreases by 10 units. e) All of the above are correct. f) None of the above is correctStep 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
