1. The Excel Sensitivity Report for Feed problem where the objective is minimization of cost is provided below. Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 Feed A 8 0 0.96 1E+30 0.51 $C$4 Feed B 2 0 0.85 1E+30 0.475 $D$4 Feed C 2 0 0.775 1E+30 0.4 $E$4 Feed D 12 0 0.45 0.51 0.075 $F$4 Feed E 16 0 0.375 0.075 1E+30 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease | 818 Cell Name Max B, C, & E $G$7 requirement $G$14 Size requirement $G$8 Min A requirement $G$9 Min B requirement $G$10 Min C requirement $G$11 Min D requirement $G$12 Min E requirement $G$13 Min B & D requirement 8 2 2 12 16 14 -0.075 0.45 0.51 0.475 0.4 0 0 0 20 40 8 2 2 2 2 12 2 1E+30 2 14 14 10 14 2 14 2 8 2 2 1E+30 1E+30 1E+30 Answer the following questions: a. What is the impact on cost if we increase Min E requirement by 10 units? b. If the objective function coefficient of Feed B decreases by $0.15, will the optimal solution and the value of the objective function change? c. We can decrease "Min A requirement by 3 units, while increasing Min B &D requirement by 1 unit. Is it worth the effort? d. If the objective function coefficient of Feed C decreases by $0.2 and the objective function coefficient of Feed E increases by $0.04, what will be the impact on cost