The sensitivity report provided below was generated using Excel Solver to determine the optimal solution to a linear program. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $A$1 0 4 13 1E+30 4 $B$1 0 1.5 24 1E+30 1.5 $C$1 75 0 1.2 18 18 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $D$3 300 300 400 71.4285714 $D$4 525 0 400 125 1E+30 $D$5 300 0 700 1E+30 400 4.5 QUESTION 13 Will the current optimal solution stay optimal if we add a constraint that says the variable in cell A1 should be at least 5? O No Yes QUESTION 14 Will the current optimal solution stay optimal if the objective coefficient of the variable in cell B1 decreases to 20? Yes QUESTION 15 What is the effect of decreasing the right-hand side of the first constraint by 10 units on the optimal objective value? 45 units increase 4.5 units decrease O 45 units decrease O 400 units increase QUESTION 16 What is the effect of increasing the right-hand side of the second constraint by 200 units on the optimal objective value? O 125 units increase 1250 units increase No change cannot be calculated using this report QUESTION 17 Will the shadow price of the third constraint remain valid if we decrease its right-hand side to 200? Yes O No