$(15$ points$)$ Question $29,$ Quantitative Methods for Business, Chapter $7$

a$.($PS$6$: Excel Model $-10$ points$)$ Part a$.$ Formulate the model, then build the Excel model.

b$.($PS$2$: Computation and Execution $-5$ points$)$ Part b$.$ Optimal solution. Ensure you include the production plan for each component at each production facility.

$(10$ points$)$ Question $37,$ Quantitative Methods for Business, Chapter $7$

a$.($PS$2$: Computation and Execution $-10$ points$)$ How many containers of Regular and Zesty should New England Cheese produce?

$(25$ points$)$ Case Problem $2$: Production Strategy, Quantitative Methods for Business, Chapter $7$

a$.$ Build a linear programming model in Excel and answer the three questions at the end of the case. $($Note: you do NOT need to include the graphical solution$).$ You may answer the questions in your Excel worksheet, if you prefer.

b$.($PS$6$: Excel Model $-10$ points$)$ Build the LP model.

c$.($PS$2$: Computation and Execution $-5$ points$)$ Optimal solution, question $1.$

d$.($PS$4$: Interpretation $-5$ points$)$ question $2.$

e$.($PS$4$: Interpretation $-5$ points$)$ question $3.$