Hi, could you help me with this problem using Excel and the "solver tool". Thanks!

C-Town Brewery brews two beets: Eitpansion Draft and Burning River. Expansion Draft sells for $21) per barreL while Burning River sells for $8 per barrel. Producing a barrel of Expansion Draft takes 8 pounds of com and 4 pounds of hops. Producing a barrel of Burning River requires 2 pounds of com, 6 pounds of rice. and 3 pounds of hops. The brewery has 500 pounds of com, 300 pounds of rice. and 400 pounds of hops. Assuming a linear relationship. use Excel Solver to determine the optimal mix of Expansion Draft and Burning River that maximizes C-Town's revenue. To help you with your analysis, answer the following questions: a) What is (are) the decision variable(s) in this problem? b) What is the objective function? 0) Explain clearly the constraints of the decision problem. d) Provide the algebraic (mathematical) formulation of the optimization problem. 6) Determine the optimal solution of the problem using Excel Solver. i. Present a screenshot of your Excel spreadsheet model, including the row and column headings. ii. Present a screenshot of the Solver Parameter Window after you build your Solver model. iii. Present a screenshot of your Excel spreadsheet model that shows the optimal solution, including optimal values of the decision variab1e(s) and the optimal value of the objective lnction