The Valley Wine Company produces two types of wine-Valley Nectar as well as Valley Red. The wines are produced from 64 tons of grapes the company has acquired this season. A 1,000-gallon batch of Nectar needs four tons of grapes and a batch of Red requires 8 tons.
But production is limited by the availability of merely 50 cubic yards of storage space for aging and 120 hours of processing time. A batch of each kind of wine requires 5 yd. of storage space. The dispensation time for a batch of Nectar is 15 hours and the processing time for a batch of Red is 8 hours. Demand for each kind of wine is limited to 7 batches. The profit for a lot of Nectar is $9,000 and the profit for a batch of Red is $12,000.
The company needs to determine the number of 1,000 gallon batches of Nectar as well as Red to produce in order to maximize profit.
Articulate a linear programming model for this problem
Solve the problem using Solver.