Problem/Question 4 [10pts] Given the following Excel Output: Variable Cells Final Reduced Objective Allowable Allowable cell Name Value Cost Coefficient Increase Decrease SD$17 A, 1 0 -6 -192 16+30 SES17 A, 2 532 -179 16 6 SF$17 A, 3 0 -17 -200 17 18+30 $G$17 A, 4 0 -6 -19 6 15+30 $D$18 B, 1 0 -10 -180 10 1E+30 $ESIS B, 2 -15 -178 15 1E+30 SFS18 B, 3 720 0 -167 183 SG$18 B, 4 486 0 -176 10 SD$19 C, 1 470 -144 186 6 SE$19 C, 2 38 -137 6 15 SF$19 C, I 0 -4 -145 4 1E+30 SG$19 C, 4 164 -150 10 Constraints Final Shadow Constraint Allowable Allowable Cell Name Price R.H. Side Increase Decrease $D$14 Demand1 470 -186 470 38 470 SE$14 Demand 570 179 570 198 532 $F$14 Demand3 720 -183 720 38 164 $G$14 Demand4 650 192 650 38 164 $IS10 Supply1 532 730 16+30 198 $IS11 Supply2 1206 16 1206 164 38 SIS12 Supply3 672 47 672 532 38 4.1 What is/are the non-binding constraint/constraints? 4.2 For 'Supply3, if the RHS value decreased by 10 units, what would be the impact on objective function value? 4.3 If the coefficient for 'A,2' in the objective function increases by 10, what will be the final value for B2? 4.4 For 'Supply2', assume the RHS value in the constraint decreases to 1106. Looking at the Excel sensitivity report, can an analyst determine the new objective function value? If yes, calculate the value, if no, state the reasons