Q$1$: Chapter $4,$ Problem $14($except part g$)(7$th edition$)$

Please download the Excel file for your work and submit your Excel file.

Use Solver to create a Sensitivity Report for Q$15($HW$1$ problem$)$ at the end of Chapter $3,$ answer the following questions:

a$.$ Is the solution degenerate?

b$.$ Is the solution unique?

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?

d$.$ Suppose the cost per pound for Feed $3$ increased by $$3.$ Would the optimal solution change? Would the optimal objective function value change?

e$.$ If the company could reduce any of the nutrient requirements, which one should it choose and why?

f$.$ If the company could increase any of the nutrient requirements, which one should it choose and why?