10 points HSS desserts supplies its ice cream shops with three flavors of ice cream chocolate, vari, and banana, in addition to the specific flavors, the main ingredients in the ice creams are milk sugar and cream. Due to extreme hot weather and a high demand for its products, the company has run short of its supply of ingredients and will not be able to all the orders received from the ice cream stores. The chocolate vanila and banana flavors generate AED 20, 18, and 16 of profit for each gallon sold, respectively. Below is a screenshot of the spreadsheet model that was used to determine how mary gallons of ice cream should the company produce of each favor in order to maximize the total profit, along with its corresponding sensitivity report Chocolate Varia Ban Unit Pro (AED) 20 * Hequirements Galon of Ice Cream Used Ae M 05 04 200 Sug OS 04 04 150 150 Com 0.1 015 02 00 Gallone Produced Total (AED) Variables Final Cell Reduced Objective Allowable Allowable Name Value Cost Coefficient increase Decrease SCAN Chocolate 0 23 25 130 100 Var 375 0 10 1:30 2 DES 3 16 045 Carts Pinal Cell Name Value 1764 Med 1875 135 Sud 150 Om Used 56 25 Shadow Constraint Allowable Allowalife Price RH. Side Increase Decrease 200 130 175 45 150 10 150 16:30 2. What is the minimum profit per gallon of Vanilla ke cream that would guarantee keeping the optimal daly production of Vanilla ice cream unchanged at 375 gallo? AED per gallon pounds 3. The company is interested in buying an additional pound of sugar. What is the maximum price that the company would be willing to pay? ALD b) How many more pounds of sugar can be purchased at this price? 4. The company has the opportunity to buy an additional 25 pounds of sugar at a total cost of 300 AED Compute the minimum additional profit or loss associated with taking this decision. AED by is the value calculated above a profit or loss? 5. The company is considering adding 0.20 gallons of condensed milk to the ingredient for making each pation of the three types of ice cream, where the total wable gallons et condensed miks to gallons per day. Assume th-V, and representatos of chocolate vanila and banana ice cream produced, respectively indicate whether the following statements are True (Tor False a) The new constraint may be algebraically represented as 0.2 0.02V+0.20 100 The new constraint may be algebrakally represented as 02C+02.0206-100 Adding the new constraint to the model will affect the optimal mix because the original optimal solution over tires the resource Adding the new constraint to the model will not affect the optimal mit because the convainis non Adding the new constraint to the model will not affect the optimal mix because the orgnal optimal solution saistes the new constraint 6. The company has decided to simultaneously reduce the daily available Sugar and Cream by 5% each a) Will this decision result in a change in optimal solution (Yes/No? by What will be the value of the total profit after this decision? AED 7. The company is considering raising the profit per gallon for Chocolate and Banana ke creams by 1 AED each indicate whether the following statements are True (T) or False () a) When applying the 100% rule, the sum of percentage changes 0.90 b) When applying the 100% rule, the sum of percentage changes 0.11 c) The 100% rule is not satisfied for this case and the problem needs to be resolved to find the new optimal solution d) The 100% rule is satisfied for this case and there will be no changes in the optimal solution e) Producing additional units of Chocolate and Banana ice cream would increase the total profit Producing additional units of Chocolate and Banana ice cream would reduce the total profit 8. The company has decided to enforce daily production of one gallon of Chocolate and one gallon of Banana ice cream. This decision will reduce total profit by AED 10 points HSS desserts supplies its ice cream shops with three flavors of ice cream chocolate, vari, and banana, in addition to the specific flavors, the main ingredients in the ice creams are milk sugar and cream. Due to extreme hot weather and a high demand for its products, the company has run short of its supply of ingredients and will not be able to all the orders received from the ice cream stores. The chocolate vanila and banana flavors generate AED 20, 18, and 16 of profit for each gallon sold, respectively. Below is a screenshot of the spreadsheet model that was used to determine how mary gallons of ice cream should the company produce of each favor in order to maximize the total profit, along with its corresponding sensitivity report Chocolate Varia Ban Unit Pro (AED) 20 * Hequirements Galon of Ice Cream Used Ae M 05 04 200 Sug OS 04 04 150 150 Com 0.1 015 02 00 Gallone Produced Total (AED) Variables Final Cell Reduced Objective Allowable Allowable Name Value Cost Coefficient increase Decrease SCAN Chocolate 0 23 25 130 100 Var 375 0 10 1:30 2 DES 3 16 045 Carts Pinal Cell Name Value 1764 Med 1875 135 Sud 150 Om Used 56 25 Shadow Constraint Allowable Allowalife Price RH. Side Increase Decrease 200 130 175 45 150 10 150 16:30 2. What is the minimum profit per gallon of Vanilla ke cream that would guarantee keeping the optimal daly production of Vanilla ice cream unchanged at 375 gallo? AED per gallon pounds 3. The company is interested in buying an additional pound of sugar. What is the maximum price that the company would be willing to pay? ALD b) How many more pounds of sugar can be purchased at this price? 4. The company has the opportunity to buy an additional 25 pounds of sugar at a total cost of 300 AED Compute the minimum additional profit or loss associated with taking this decision. AED by is the value calculated above a profit or loss? 5. The company is considering adding 0.20 gallons of condensed milk to the ingredient for making each pation of the three types of ice cream, where the total wable gallons et condensed miks to gallons per day. Assume th-V, and representatos of chocolate vanila and banana ice cream produced, respectively indicate whether the following statements are True (Tor False a) The new constraint may be algebraically represented as 0.2 0.02V+0.20 100 The new constraint may be algebrakally represented as 02C+02.0206-100 Adding the new constraint to the model will affect the optimal mix because the original optimal solution over tires the resource Adding the new constraint to the model will not affect the optimal mit because the convainis non Adding the new constraint to the model will not affect the optimal mix because the orgnal optimal solution saistes the new constraint 6. The company has decided to simultaneously reduce the daily available Sugar and Cream by 5% each a) Will this decision result in a change in optimal solution (Yes/No? by What will be the value of the total profit after this decision? AED 7. The company is considering raising the profit per gallon for Chocolate and Banana ke creams by 1 AED each indicate whether the following statements are True (T) or False () a) When applying the 100% rule, the sum of percentage changes 0.90 b) When applying the 100% rule, the sum of percentage changes 0.11 c) The 100% rule is not satisfied for this case and the problem needs to be resolved to find the new optimal solution d) The 100% rule is satisfied for this case and there will be no changes in the optimal solution e) Producing additional units of Chocolate and Banana ice cream would increase the total profit Producing additional units of Chocolate and Banana ice cream would reduce the total profit 8. The company has decided to enforce daily production of one gallon of Chocolate and one gallon of Banana ice cream. This decision will reduce total profit by AED