C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $21 per barrel while Burnin

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $21 per barrel while Burnin

Post by answerhappygod »

C Town Brewery Brews Two Beers Expansion Draft And Burning River Expansion Draft Sells For 21 Per Barrel While Burnin 1
C Town Brewery Brews Two Beers Expansion Draft And Burning River Expansion Draft Sells For 21 Per Barrel While Burnin 1 (62.77 KiB) Viewed 79 times
C-town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $21 per barrel while Burning River sells for $7 per barrel. Producing a barrel of Expansion Draft takes 10 pounds of corn and 3 pounds of hops. Producing a barrel of Burning River requires 6 pounds of corn, 7 pounds of rice, and 7 pounds of hops. The brewery has 750 pounds of corn, 530 pounds of rice, and 370 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. (Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.) Barrels of expansion draft Barrels of burning river Total sales Resources Used Corn Rice Hops
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply