MGMT 315 Exercise 43 The correct LP model for problem #7 from page 6465 at the end of Chapter 2 is: Maximize 2=1X1+5X2 (profit) Subject to: 5X2+5X225 pounds (fiour) 2X1+4X216 pounds (sugar) X1=5 pans of coffee cakes (demand) X1,X20 (non-negative) Note: where X1= number of pans of coffee cakes and X2= number of pans of Danish pastries. Instructions for Exercise \#3: 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 Custard Bakery makes coffee cakes and Danish pastries in large pans. The main ingredients are flour and sugar. There are 25 pounds of flour and 16 pounds of sugar 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 coffee cakes, and 5 pounds of flour and 4 pounds of sugar are required to make a pan of Danish. A pan of coffee cakes has a profit of $1, and a pan of Danish has a profit of $5. Determine the number of pans of cakes and Danish to produce each day so that profit will be maximized. a. Formulate a linear programming model for this problem. b. Solve this model by using graphical analysis