Question

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 ton of grapes, a cask of Red requires 0.24 ton, and a cask of Blush requires 0.18 ton. The vineyard has enough storage space in its aging room to store 80 casks of wine. The vineyard has 1200 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.

Please answer question 3

1. Solve the linear programming model for Mountain Laurel Vineyards by using software, e.g. MS Excel.
2. If the vineyard could secure one additional unit of any of the resources used in the production of wine, which one should it select?
3. If the vineyard could obtain 0.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?

Answer 1

ut 6olying be vnodel thowh exal Solle: ro.of α SKS 9iaReS 200 (20o 1200 5000 to, Totol Poft The Optimal Saion dbesvot chace ed uns $も600 iusto of $8,200 781500 d) If the VineĶed detevmmd tot the pickit fiom Blank tones of gvaRes (3/ = 0.21 O | t3.5 | 13.5 | 17 Picabction hooNS Pidts (osK |Total PoRt o 1200 1200 1200 750 |キ600 (050 178千50