The Bluegrass Distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 400 gallons of the custom blend. The customer specified that the order must contain at least 40% rye and not more than 250 gallons of bourbon. The customer also specified that the blend should be mixed in the ratio of two parts rye to one part bourbon. The distillery can produce 500 gallons per week, regardless of the blend. The production manager wants to complete the order in 1 week. The blend is sold for $5 per gallon. The distillery company's cost per gallon is $2 for rye and $1 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits. Formulate a linear programming model and solve graphically using Excel and QM.
I have the set up in Excel for this problem, but am not sure where to plug in the correct numbers for the formulas to work. I am not sure what the constraints should be in regards to gallons and maximizing the profits. I have gotten similar problems like this one but they did not contain percents/gallons ratio.