estion 1 10 points Save Answer H&S desserts supplies its ice cream shops with three flavors of ice cream: chocolate, vanilla, 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 fill all the orders received from the ice cream stores. The chocolate, vanilla, 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 many gallons of ice cream should the company produce of each flavor in order to maximize the total profit, along with its corresponding sensitivity report. Chocolate Vanilla Banana Unit Proft (AED) 20 18 16 Requirements / Gallon of Ice Cream Used Available Milk 0.45 0.5 0.4 187 5 200 Sugar 0.5 0.4 0.4 150 150 Cream 0.1 0.15 02 56.25 60 Gallons Produced 0 375 0 Total Profit (AED) 6750 Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $C$8 Chocolate 0 -2.5 20 2.5 16+30 $D$8 Vanilla 375 18 1E+30 2 $E$8 Banana 0 -2 16 1E+30 Constraints Final Shadow Constraint Allowable Allowable Cell Name Value Price R.H. Side Increase Decrease $F$4 Milk Used 187.5 0 200 1E+30 12.5 $F$5 Sugar Used 150 45 150 10 150 $F$6 Cream Used 56.25 0 60 1E+30 3.75