Fleview exercises Exercise 1 The Crumb and Custard Bakery makes coffee cakes and Danish pastries in large pans. The main ingredients are our and sugar. There are 12.5 kilograms of flour and 8 kilograms of sugar available and the demand for coffee cakes is 4. Two and a half kilograms of our and one kilogram of sugar are required to make a pan of coffee cakes and two and a half kilograms of our and two kilograms of sugar are required to make a pan of Danish pastries. A pan of coffee cakes has a prot of $31 and a pan of Danish pastries has a prot of $5. Determine the number of pans of coffee cakes and Danish pastries to produce each day so that the prot is maximised. Formulate a linear programming model for the bakery and solve this linear programming model using the graphical method. Solve this linear programming model using Excel Solver and use the Answer and Sensitivity Reports to answer the following questions: {a} If The Crumb and Custard Elakery produces the optimum number of cakes and pastries per day, will the maximum demand for coffee cakes be met? If not by how much will it be missed? {b} Will the bakery be using up all available our and sugar each day\"? If not, how much will be left? {c} Suppose that the prot per coffee cake turns out to be only $2. What effect, if any, will this have on the optimum solution? {d} What would be the effect on the optimum solution of increasing the amount of sugar available per day to 9.5 kilograms