D E F G H | 1 A B C Microsoft Excel 16.46 Sensitivity Report 2 Worksheet: [excel assignment 2.xlsx]Sheet1 3 Report Created: 13/10/22 12:07:00 am 4 5 6 Variable Cells 7 Final Reduced Objective Allowable Allowable 8 Cell Name Value Cost Coefficient Increase Decrease 9 $B$4 Decision Variables x1 20 0 0.67 0.23 0.71 10 $C$4 Decision Variables x2 25 0 0.46 0.44 0.33 11 $D$4 Decision Variables x3 21.66666667 0 0.9 0.99 0.23 12 $E$4 Decision Variables x4 0 -1.05 -0.23 1.05 1E+30 13 $F$4 Decision Variables x5 0 -0.33 0.49 0.33 1E+30 14 $G$4 Decision Variables x6 0 -0.71 0.32 0.71 1E+30 15 $H$4 Decision Variables x7 33.33333333 0 1.98 1E+30 0.98 16 $I$4 Decision Variables x8 0 -0.98 1 0.98 1E+30 17 $J$4 Decision Variables x9 0 -2.16 -0.9 2.16 1E+30 0 -1.83 -0.57 1.83 1E+30 22222222222333333 34 35 18 $K$4 Decision Variables x10 19 20 Constraints 21 Cell Final Shadow Constraint Allowable Allowable Name Value Price $B$11 Constraint 1 LHS 24 $B$12 Constraint 2 LHS 25 $B$13 Constraint 3 LHS 26 $B$14 Constraint 4 LHS 100 1.26 R.H. Side 100 Increase Decrease 1E+30 32.5 0 0 15 1E+30 15 66.66666667 0 0 66.66666667 1E+30 66.66666667 0 0 33.33333333 1E+30 27 $B$15 Constraint 5 LHS 66.66666667 0 0 66.66666667 1E+30 28 $B$16 Constraint 6 LHS 29 $B$17 Constraint 7 LHS 66.66666667 -0.36 0 40 50 20 -0.23 20 21.66666667 0 30 $B$18 Constraint 8 LHS 20 0 20 0 1E+30 31 $B$19 Constraint 9 LHS 33.33333333 0 $B$20 Constraint 10 LHS 25 -0.44 20 13.33333333 25 21.66666667 1E+30 25 Returns and Standard deviations Answer Report 3 Sensitivity Report 3