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.



$1.99
Sales0
Views102
Comments0
  • CreatedApril 09, 2014
  • Files Included
Post your question
5000