Mathematics- Linear Programming

(#46)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.21 tons of grapes, a cask of Red requires 0.24 tons, and a cask of Blush requires 0.18 tons. 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.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.

(#47) Solve the linear programming model formulated in Problem #46 for Mountain Laurel Vineyards by using the computer. (All answers below should be one line answers)

(47A). If the vineyard were to determine that the profit from Red was $7,600 instead of $8,200, how would that affect the optimal solution? (The answer is based on #46 Sensitivity analysis report.)

(47B) If the vineyard could secure one additional unit of any of the resources used in the production of wine, which one should it select? (Use shadow price)

(47C). If the vineyard could obtain 0.5 more tons of grapes, 500 more hours of production capacity, or enough storage capacity to store 4 more casks of wine, which should it choose? (Use shadow price)

(47D). 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? (Use sensitivity analysis report.)