solver

Objective Cell Mird Name Final Value $B$13 Obj Func AN 3850000 Decision Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease variables SA 511 50000 o AN 30 5.0000001 45.0000001 SC$11 variables 0 5 50 1E430 S variables $D$11 EN 30000 o 25 15.0000001 5.0000001 30000 arable SES11 variables BO 40000 0 40 5.0000001 15.0000001 Shadow Cell Name RH. Side Increase LHS 45 $B$17 LHS 40 40000 LH -15 o LHS 40000 60000 Constraints Final Constraint Allowable Allowable Value Price Decrease $B$16 50000 50000 20000 40000 70000 70000 20000 $B$18 B0000 80000 40000 20000 $B$19 1E+30 20000 The answers to the questions are found in this sensitivity report. Questions: Write your responses in the space provided 1. What is the range of optimality for the DN and BO variables? write your answers in this format: Lower limit -- Coefficient of AN - Upper limit Example 224-C of AN +40 2. What is the range of feasibility for the constraints located on B17 and B18? 3. If the right-hand side of the constraint located on B16 is decreased by 2000, what is the effect on the value of the objective function? 4. If the coefficient of variable DO changes from 40 to 47, do the final values of the variables remain the same