Manhattan Brewery produces two types of beer: Lager and India pale ale (IPA). The Lager sells for $90 per barrel and IPA sells for $95 per barrel. Producing a barrel of Lager requires 15 pounds of malt and 10 pounds of hops. Producing a barrel of IPA requires 40 pounds of malt and 25 pounds of hops. The brewery has 600 pounds of malt and 300 pounds of hops available. How can Manhattan Brewery earn the most revenue? a. Formulate an LP model for this problem. Write out the linear optimization problem being solved. (4 pts) b. Develop a spreadsheet model in EXCEL to solve the problem and solve it. (4 pts) What is the optimal solution (i.e., total revenue and amount of each type of beer produced)? (2 pts) c. Manhattan Brewery produces two types of beer: Lager and India pale ale (IPA). The Lager sells for $90 per barrel and IPA sells for $95 per barrel. Producing a barrel of Lager requires 15 pounds of malt and 10 pounds of hops. Producing a barrel of IPA requires 40 pounds of malt and 25 pounds of hops. The brewery has 600 pounds of malt and 300 pounds of hops available. How can Manhattan Brewery earn the most revenue? a. Formulate an LP model for this problem. Write out the linear optimization problem being solved. (4 pts) b. Develop a spreadsheet model in EXCEL to solve the problem and solve it. (4 pts) What is the optimal solution (i.e., total revenue and amount of each type of beer produced)? (2 pts) c