I really need to know how to solve these problems using excel formulas and analysis. Especially C and D

Use Brewery worksheet to answer the following: Don't Drink And Drive Brewery (DDAD) produces beer and ale. Beer sells for $5.70 per barrel, and ale sells for $2.05 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. Operational costs are $0.25 for a barrel of beer and S0.10 for a barrel of ale. The brewery has 12,000 pounds of corn and 6,000 pounds of hops. DDAD wants to maximize its profit. a) Find the optimal production plan that maximizes the profit. Write the solution. Binding Constraints: b) What is (are) the bottleneck resource(s) for the brewery? Why? Shadow Price: c) If additional corn is available at 1.25 $/pound, should DDAD purchase any? Why (not)? Reduced Cost: d) What should be the minimum selling price of ale, so that its production becomes profitable? U 4 5 6 7 8 9 Used Corn Hops 5 Unit (per barrel) Selling Price Cost Unit Profit $5.70 $0.25 $5.45 $2.05 $0.10 $1.95 Produced: 2400 0 2 1 Beer Ale N 12000 4800 Resource Used: CE CE 10 11 12 13 12000 6000 Answers: Available: a) Total Profit: $13,080.00 15 16 17 b) Corn is a bottleneck resource because 40