2. Magnolium Bakery would like to expand their operations by introducing a new cupcake flavor: caramel cake. Caramel cake cupcakes sell for a profit of $5 per cupcake. In addition, the bakery now needs to keep track of a new ingredient for each of their cupcakes, butter. The number of cups of each ingredient needed to make each cupcake flavor are given in the chart below. Ingredient Blueberry Lemon Red Velvet Caramel Cake Flour 2 4 Sugar 4. 4 Butter 0.2 0.3 0.1 2 3 Magnolium Bakery has 100 cups of flour, 120 cups of sugar, and 5 cups of butter available to make their cupcakes. As before, they would like to make at least 5 blueberry lemon cupcakes. In order to maximize their profit, the bakery has entered the following LP into Excel. 5 I1, 12, 13 > 0 Solve the above LP using Excel and answer the following questions. 11 c. By how much would the profit of a red velvet cupcake have to decrease before the bak- ery decides to reduce the number of red velvet cupcakes to make? 2. Magnolium Bakery would like to expand their operations by introducing a new cupcake flavor: caramel cake. Caramel cake cupcakes sell for a profit of $5 per cupcake. In addition, the bakery now needs to keep track of a new ingredient for each of their cupcakes, butter. The number of cups of each ingredient needed to make each cupcake flavor are given in the chart below. Ingredient Blueberry Lemon Red Velvet Caramel Cake Flour 2 4 Sugar 4. 4 Butter 0.2 0.3 0.1 2 3 Magnolium Bakery has 100 cups of flour, 120 cups of sugar, and 5 cups of butter available to make their cupcakes. As before, they would like to make at least 5 blueberry lemon cupcakes. In order to maximize their profit, the bakery has entered the following LP into Excel. 5 I1, 12, 13 > 0 Solve the above LP using Excel and answer the following questions. 11 c. By how much would the profit of a red velvet cupcake have to decrease before the bak- ery decides to reduce the number of red velvet cupcakes to make