Question $1.$

You are working as a design engineer for a brewery which produces two different types of beer $($CHE Yellow and CHE Orange$).$ Each Barrel of CHE Yellow requires $1oz$ of hops, $25$ pounds of malt. CHE Orange needs $24$ pounds of corn, $3$ ozs. of hops and $8$ pounds of malt. The profit for CHE Yellow is $$29$ per barrel and CHE Orange is $$21$ per barrel. You need decide how many barrels of each type, brewery need to produce to maximize the profit. The brewery has $500$ pounds of corn, $60$ozs. of hops and $900$ pounds of malt on site.

Please use Excel, thank you!