Problem A$-8($Algo$)$

C$-$town brewery brews two beers: Expansion Draft and Burning River. Expansion draft sells for $$15$ per barrel while Buming River sells for $$5$ per barrel. Producing a barrel of Expansion Draft takes $6$ pounds of corn and $2$ pounds of hops. Producing a barrel of Burning River requires $6$ pounds of corn, $6$ pounds of rice, and $2$ pounds of hops. The brewery has $720$ pounds of corn, $500$ pounds of rice. and $530$ 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. $($Leove no cells blank $-$ be certaln to enter $"$O$"$ wherever requlred. Round your answers to $2$ decimal pleces.$)$

Answer is not complete.

$\backslash$table$[[,],[$Decision for expansion draft,$],[$Decision for burning river,$],[$Total sales,$]]$

Answer is complete and correct.

$\backslash$table$[[,\backslash$table$[[$Resources$],[$Used$]]],[$Com$,720\mathrm{.}00],[$Rice$,0\mathrm{.}00],[$Hops$,240\mathrm{.}00]]$