SoccerBoss
Category:
Other
Price: \$5 USD

Question description

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.

(Top Tutor) Daniel C.
(997)
School: Duke University
Studypool has helped 1,244,100 students

1820 tutors are online

### Related Other questions

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors