Build the linear programming model in Excel and solve it using Excel Solver. Make sure you follow the

color$-$coding rules learned in class. Don$$t forget to include units, proper labeling, etc. $(40$ Points$)$

b$)$ What is the optimal solution? What is the optimal objective value? Explain in words what each of them

means. $(10$ Points$)$

c$)$ Provide the mathematical formulation of this problem. Clearly explain the decision variables, state the

units of each constraint and clearly label your constraints. Make sure your model includes all the required

components of the LP mathematical formulation. $(30$ Points$)$

d$)$ How many decision variables do you have in this problem? How many constraints? $(10$ Points$)$

e$)$ Using your Excel model or by plugging the optimal solution into your constraints answer the following

questions. Which constraints are binding? Which constraints are non$-$binding? Explain why; do not just

mention the constraints. Don$$t forget to include the non$-$negativity constraints in your discussions. $(10$

Points$)$