please help me using excel!

Problem 1: Bloomington Brewery Bloomington Brewery produces beer and ale. Beer sells for $5 per barrel, and ale sells for $2 per barrel. Producing a barrel of beer requires 5 pounds of corn and 2 pounds of hops. Producing a barrel of ale requires 2 pounds of corn and 1 pound of hops. The brewery has 65 pounds of corn and 25 pounds of hops. Bloomington Brewery wants to maximize its revenue. a) Write the managerial formulation for Bloomington Brewery. b) Use Solver to determine the production plan that maximizes Bloomington Brewery's revenue. Report the optimum solution in a textbox. Note: it is possible to produce a fraction of a barrel. c) What is (are) the bottleneck resource(s) for the brewery? Why? d) If additional hops became available at 3 $/pound, should the brewery purchase any? (Hint: You need to generate the sensitivity report to answer that)