$11$

Problem $19$S$-8($Algo$)$

C$-$Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $$14$ per barrel, while Burning River sells for $$9$ per barrel. Producing a barrel of

$5$ points

$01$:$58$:$56$ Expansion Draft takes $4$ pounds of corn and $2$ pounds of hops. Producing a barrel of Burning River requires $5$ pounds of corn, $11$ pounds of rice, and $7$ pounds of hops. The brewery has $630$ pounds of corn, $550$ pounds of rice, and $310$ 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.

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Round your answers to $2$ decimal places.

$\backslash$table$[[$Barrels of expansion draft,$155\mathrm{.}00],[$Barrels of burning river,$0\mathrm{.}00],[$Total sales,$2,170\mathrm{.}00$