Need the excel and solver steps

MGMT 315 Exercise 13 The correct LP model for problem 7 from page 64.65 at the end of Chapter 2 is: Maximize 2=2x1+5x2 (profit) Subject to: 5X2+5X225 pounds (fiour) 2X1+4X216pounds(sugar)X2=5pansofcoffeecakes(demand)X14X20(non-negative) Note: where x1= number of pans of coffee cakes and x2= number of pans of Danish pastries. Instructions for Exercise as: Setup this problem in Excel and SOLvE with Solver. Save the file which should include the Answer Report from Solver and the solution in the Excel spreadsheet. Upload your file in Blackboard. 7. The Crumb and Custand Bakery makes cottee cakes and Danish pastries in targe pans. The man ingredionts are flour and sugar. There are 25 pounds of flour and 16 pounds of nugar available, and the demand for coffee cakes is 5 . Five pounds of flour and 2 pounds of sugar are required to make a pan of collee cakes, and 5 pounds of flour and 4 pounds of sugar are required to make a pan of Danish. A pan of cotlee cakes has a profit of $1, and a pan of Danish has a profit of $5. Dotermine the number of pans of cakes and Danish to produce each day so that profit will be maximised. a. Formulate a linear programming model for this problem. b. Solve this model by using graphical analysis