Question: Please do not solve this in excel. I only want to see your model formulation as we have learned in this module. The Jack-Green distillery
Please do not solve this in excel. I only want to see your model formulation as we have learned in this module.
The Jack-Green distillery produces custom-blended whiskey. A particular blend consists of rye and bourbon whiskey. The company has received an order for a minimum of 450 gallons of the custom blend. The customer specified that the order must contain at least 35% rye and not more than 270 gallons of bourbon. The customer also specified that the blend should be mixed in the ratio of two parts rye to one part bourbon (Hint: Rye = 2 Bourbon, very similar to your homework assignment). The distillery can produce 550 gallons per week, regardless of the blend. The production manager wants to complete the order in 1 week. The blend is sold for $5.5 per gallon. The distillery company's cost per gallon is $2.50 for rye and $1.25 for bourbon. The company wants to determine the blend mix that will meet customer requirements and maximize profits.
Define your decision variables.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
