Question: Problem 1 9 S - 8 ( Algo ) C - Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for
Problem SAlgo
CTown Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $ per barrel while Burning River sells for $ per barrel. Producing a barrel of Expansion Draft takes pounds of corn and pounds of hops. Producing a barrel of Burning River requires pounds of corn, pounds of rice, and pounds of hops. The brewery has pounds of corn, pounds of rice, and pounds of hops.
Assuming a linear relationship, use the Excel Solver to determine the optimal mix of Expansion Draft and Burning River that maximizes CTown's revenue. Leave no cells blank be certain to enter wherever required. Round your answers to decimal places.
tableBarrels of expansion draftBarrels of burning riverTotal sales
tableResources UsedCornRiceHops
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
