6 The company has decided to simultaneously decrease the daily available Sugar and Cream by 5 each a) Will this decision result in a change in optimal solution (Yes No) b) What will be the value of the total profit after this decision AED 7 The company is considering raising the profit per gallon for Vanilla and Banana ice creams by 1 AED each Indicate whether the following statements are True (T) or False (F) a) When applying the 100 rule, the sum of percentage changes 1 b) When applying the 100 rule, the sum of percentage changes 1 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 ice cream would increase the total profit f) Producing additional units of Chocolate ice cream would reduce the total profit 8 The company has decided to enforce daily production of one gallon of Chocolate ice cream This decision will reduce total profit by AED Unit Proft (AED) Used Chocolate Vanilla Banana 14 14 14 Requirements Gallon of Ice Cream 0 45 0 5 0 4 0 4 0 3 0 15 0 1 0 4 Milk Sugar Cream 130 Available 150 100 50 A A A 100 50 0 2 Gallons Produced 0 100 200 Total Profit (AED) 4200 Variable Cells Cell $C$8 $D$8 $E$8 Name Chocolate Vanilla Banana Final Value 0 100 200 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease 1 4 14 1 4 1E 30 0 14 4 67 2 0 14 3 5 14 Constraints Cell $F$4 $F$5 $F$6 Name Milk Used Sugar Used Cream Used Final Value 130 100 50 Shadow Constraint Allowable Allowable Price R H Side Increase Decrease 0 150 1E 30 20 100 16 7 28 50 16 7 25 28 25

The Answer is in the image, click to view ...

Question: 6. The company has decided to simultaneously decrease the daily available Sugar and Cream by 5% each. a) Will this decision result in a change

6. The company has decided to simultaneously decrease the daily available Sugar and Cream by 5% each.

a) Will this decision result in a change in optimal solution (Yes/No)?

b) What will be the value of the total profit after this decision? AED

7. The company is considering raising the profit per gallon for Vanilla and Banana ice creams by 1 AED each. Indicate whether the following statements are True (T) or False (F).

a) When applying the 100% rule, the sum of percentage changes 1
b) When applying the 100% rule, the sum of percentage changes 1
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 ice cream would increase the total profit.
f) Producing additional units of Chocolate ice cream would reduce the total profit.

8. The company has decided to enforce daily production of one gallon of Chocolate ice cream. This decision will reduce total profit by AED

6. The company has decided to simultaneously

Unit Proft (AED) Used Chocolate Vanilla Banana 14 14 14 Requirements / Gallon of Ice Cream 0.45 0.5 0.4 0.4 0.3 0.15 0.1 0.4 Milk Sugar Cream 130 Available 150 100 50 A A A 100 50 0.2 Gallons Produced 0 100 200 Total Profit (AED) 4200 Variable Cells Cell $C$8 $D$8 $E$8 Name Chocolate Vanilla Banana Final Value 0 100 200 Reduced Objective Allowable Allowable Cost Coefficient Increase Decrease -1.4 14 1.4 1E+30 0 14 4.67 2 0 14 3.5 14 Constraints Cell $F$4 $F$5 $F$6 Name Milk Used Sugar Used Cream Used Final Value 130 100 50 Shadow Constraint Allowable Allowable Price R.H. Side Increase Decrease 0 150 1E+30 20 100 16.7 28 50 16.7 25 28 25