Microsoft Excel 15.0 Sensitivity Report Objective Cell (Min) Use the Sensitivity report posted on Blackboard (similar/same problem from HW2 ), answer the following questions: a. Is the solution degenerate? (10 points) b. Is the solution unique? ( 10 points ) c. Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why does the sign of its associated reduced cost make economic sense? (20 points ) d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solution change? Would the optimal objective function value change? (20 points) e. If the company could reduce any of the nutrient requirements, which one should it choose and why? (20 points) f. If the company could increase any of the nutrient requirements, which one should it choose and why? (20 points) Please type your answers in Word with justifications (calculations if necessary). You could also choose write down your work on a piece of paper and then take a picture of it. Microsoft Excel 15.0 Sensitivity Report Objective Cell (Min) Use the Sensitivity report posted on Blackboard (similar/same problem from HW2 ), answer the following questions: a. Is the solution degenerate? (10 points) b. Is the solution unique? ( 10 points ) c. Explain the signs of the reduced costs for each of the decision variables. That is, considering the optimal value of each decision variable, why does the sign of its associated reduced cost make economic sense? (20 points ) d. Suppose the cost per pound for Feed 3 increased by $3. Would the optimal solution change? Would the optimal objective function value change? (20 points) e. If the company could reduce any of the nutrient requirements, which one should it choose and why? (20 points) f. If the company could increase any of the nutrient requirements, which one should it choose and why? (20 points) Please type your answers in Word with justifications (calculations if necessary). You could also choose write down your work on a piece of paper and then take a picture of it