FOR THIS PROBLEM: MAKE AND SOLVE A LINEAR PROGRAMMING MODEL IN EXCEL, THEN USE SENSITIVITY REPORT AND SOLVER.

Mountain Laurel Vineyards produces three kinds of wine$$Mountain Blanc, Mountain Red, and Mountain Blush. The company has $17$ tons of grapes available to produce wine this season. A cask of Blanc requires $0\mathrm{.}21$ ton of grapes, a cask of Red requires $0\mathrm{.}24$ ton, and a cask of Blush requires $0\mathrm{.}18$ ton. The vineyard has enough storage space in its aging room to store $80$ casks of wine.

The vineyard has $2,500$ hours of production capacity, and it requires $12$ hours to produce a cask of Blanc, $14\mathrm{.}5$ hours to produce a cask of Red, and $16$ hours to produce a cask of Blush. From past sales the vineyard knows that demand for the Blush will be no more than half of the sales of the other two wines combined. The profit for a cask of Blanc is $$7,500,$ the profit for a cask of Red is $$8,200,$ and the profit for a cask of Blush is $$10,500.$

a$)$ Formulate and solve the linear programming model for this problem.

b$)$ If the vineyard determined that the profit from Red was $$7,600$ instead of $$8,200,$ how would that affect the optimal solution?

c$)$ If the vineyard could secure one additional unit of any of the resources used in the production of wine, which one should it select?

d$)$ If the vineyard could obtain $0\mathrm{.}5$ ton more of grapes, $500$ more hours of production capacity, or enough storage capacity to store $4$ more casks of wine, which should it choose?

e$)$ All three wines are produced in the optimal solution. How little would the profit for Blanc have to be for it to no longer be produced?