Mountain Laurel Vineyards manufactures three types of wine -Mountain Blanc, Mountain Red, and Mountain Blush. Company has 17 tons of grapes available to make wine this season. Cask of Blanc needs 0.21 ton of grapes, a cask of Red requires 0.24 ton, and cask of Blush requires 0.18 ton. Vineyard has sufficient storage space in its aging room to store 80 casks of wine.
Vineyard has 2,500 hours of production capacity, and it needs 12 hours to make cask of Blanc, 14.5 hours to make cask of Red, and 16 hours to make cask of Blush. From past sales vineyard knows that demand for Blush will be no more than half of sales of other two wines combined. Profit for cask of Blanc is $7,500, profit for cask of Red is $8,200, and profit for a cask of Blush is $10,500.
Management wishes to know how many casks of each wine to make to maximize total. profit.
Prepare the linear programming model for this problem.
Solve linear programming model using Excel Solver.
Define your suggested decision in one paragraph.