Question: I need an answer for question 5 from a to e H&S desserts supplies its ice cream shops with three flavors of ice cream:chocolate, vanilla,
I need an answer for question 5 from a to e
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 17. 15, 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. Unit Proft (AED) Milk Sugar Cream Chocolate Vanilla Banana 17 15 16 Requirements / Gallon of Ice Cream 0.45 05 0.4 04 0.4 0.4 0.1 02 250 0 0 Used 1125 100 25 Available 150 100 50 0.15 GA Total Profit (AED) 4250 Gallions Produced Variable Cells Cell $C$8 $D$8 $E$8 Name Chocolate Vanilla Banana Final Value 250 0 0 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 0 17 1E+30 1 -2 15 2 1E+30 -1 16 1 1E30 Constraints Cell $754 $F$5 $F$6 Name Milk Used Sugar Used Cream Used Final Value 112.5 100 25 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0 150 1E+30 37.5 42.5 100 33 0 50 1E+30 25 100 S. The company is considering adding 0.30 gallons of condensed milk to the ingredient for making each gallon of the three types of ice cream, where the total available gallons of condensed milk is 90 gallons per day. Assume that "CV, and "B" represent gallons of chocolate, vanilla, and banana ice cream produced, respectively. Indicate whether the following statements are True (T) or False (F). a) The new constraint may be algebraically represented as 0.3 C +0.3 V +0.38 >90 b) The new constraint may be algebraically represented as 0.3 C +0.3 V+0.3 B 90 c) Adding the new constraint to the model will affect the optimal mix because the original optimal solution over-utilizes the resource. d) Adding the new constraint to the model will not affect the optimal mix because the original optimal solution satisfies the new constraint. e) Adding the new constraint to the model will not affect the optimal mix because the constraint is non-binding
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
