Question: Problem A-8 (Static) C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $20 per barrel while Burning River sells for

Problem A-8 (Static) C-town brewery brews two
Problem A-8 (Static) C-town brewery brews two
Problem A-8 (Static) 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 com, 300 pounds of rice. and 400 pounds of hops Assuming a linear relationship, use the Excel Solver to determine the optimal mix of Expansion Draft and Burning River that maximizes C-town's revenue. (Round your answers to the nearest whole number.) Decision for expansion draft Decision for burning river Total sales Decision for expansion draft Decision for burning river Total sales Resources Used Corn Rice Hops

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!