1. Please show work for using problem solver in excel.

C-Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $20 per barrel, while Burning River sells for $8 per barrel. Producing a barrel of Expansion Draft takes 8 pounds of corn and 4 pounds of hops. Producing a barrel of Burning River requires 2 pounds of corn, 6 pounds of rice, and 3 pounds of hops. The brewery has 500 pounds of corn, 300 pounds of rice, and 400 pounds of hops. Assuming a lincar 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, ansjover the following questions: a) What is (are) the decision variable(s) in this problem? b) What is the objective function? c) Explain clearly the constraints of the decision problem. d) Provide the algebraic (mathematical) formulation of the optimization problem. e) 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. Present a screenshot of your Excel spreadsheet model that shows the optimal solution, including optimal values of the decision variable(s) and the optimal value of the objective function. 111. C-Town Brewery brews two beers: Expansion Draft and Burning River. Expansion Draft sells for $20 per barrel, while Burning River sells for $8 per barrel. Producing a barrel of Expansion Draft takes 8 pounds of corn and 4 pounds of hops. Producing a barrel of Burning River requires 2 pounds of corn, 6 pounds of rice, and 3 pounds of hops. The brewery has 500 pounds of corn, 300 pounds of rice, and 400 pounds of hops. Assuming a lincar 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, ansjover the following questions: a) What is (are) the decision variable(s) in this problem? b) What is the objective function? c) Explain clearly the constraints of the decision problem. d) Provide the algebraic (mathematical) formulation of the optimization problem. e) 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. Present a screenshot of your Excel spreadsheet model that shows the optimal solution, including optimal values of the decision variable(s) and the optimal value of the objective function. 111