C- Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $ 20

Question:

C- Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $ 20 per barrel, while Burning River sells for $ 8 per barrel. Producing a barrel of Expansion Draft takes 8 pounds of corn and 4 pounds of hops. Producing a barrel of Burning River requires 2 pounds of corn, 6 pounds of rice, and 3 pounds of hops. The brewery has 500 pounds of corn, 300 pounds of rice, and 400 pounds of hops. Assuming a linear relationship, use Excel Solver to determine the optimal mix of Expansion Draft and Burning River that maximizes C- Town’s revenue.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Operations and Supply Chain Management

ISBN: 978-0078024023

14th edition

Authors: F. Robert Jacobs, Richard Chase

Question Posted: