You should type the calculations and your solution to each question and submit your answer in a word file. You should not solve the problems of this homework by using Excel solver tool.

Use the following sensitivity report for this LP model to answer the following questions.

1. How much does the profit change if the bakery increases the bride dream cake price by $2?
2. Changing the baking plan is very difficult for the bakery. What is the highest price that the bakery can ask for the blueberry cake to increase their total profit with the same baking plan (number of cakes)? How much does the new price increase the total profit?
3. Suppose that the criteria on baking at least 5 Bride dream cake is eliminated. How much and in which direction does it change the objective function? Does it change the optimal decision variables value as well? If yes, in which direction?
4. Based on some emergency condition for the operator of mixing station, he is available just for 39 hours in the following week. On the other hand, the operator of the final design station announced that he is available for 46 hours in the following week. How do these changes affect the objective function in the same week? Does that change the1 optimal decision variables value as well?

Variable Cells Cell Name $B$4 Number of cakes Blueberry $C$4 Number of cakes Go Spurs $D$4 Number of cakes Bride dream Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 41.5 0 8.2 1.05 0.271428571 27.5 0 11.1 0.38 1.26 5 0 6.85 7.84 1E+30 Constraints Cell Name $E$16 Blueberry minimum $E$17 Go Spurs minimum $E$18 Bride dream minimum $E$9 Mixing $E$10 Baking $E$11 Final design $E$12 Packing $E$13 Blueberry maximum $E$14 Go Spurs maximum $E$15 Bride dream maximum Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 41.5 0 5 36.5 1E+30 27.5 0 5 22.5 1E+30 5 -7.84 5 1.976744186 5 40 3.8 40 0.607142857 2.25 76.5 0 80 1E+30 3.5 45 12.6 45 2.25 0.708333333 0 1E+30 1.6 41.5 50 1E+30 8.5 27.5 0 50 1E+30 22.5 5 0 50 1E+30 45 7.4 OOO