Name Solution Pistachio Solution Mango Solution Strawberry Name Milk Consumsion Sugar Consumsion Cream Consumsion Reduced Objective Allowable Cost Coefficient Increase 0 -0.226936937 0 Shadow Constraint Price R.H. Side 0 Allowable Decrease 6.5 0.943571429 0.257040816 5.07 0.226936937 1E+30 6.13 8.078078078 11.9009009 1.345 0.777058824 Allowable Allowable Increase Decrease 188 1E+30 54.83483483 145 23.3 24.47826087 66 13.4047619 9.137254902 A) Find out the optimal solution to this problem (Don't forget your conclusion)? (3 Pts.) B) Suppose the profit per gallon of strawberry changes to SAR5.4. Will the optimal solution change? (2 Pts.) C) Suppose the profit per gallon of mango changes to SAR5.3. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) D) Suppose the company discovers that 9 gallons of cream have gone sour and so must be thrown out. Will the optimal solution change, and what can be said about the effect on total

Q1. Solve the following question: F and M Inc, supplies its ice cream vans with three flavors of ice cream: pistachio, mango, and strawberry. Due to extremely hot weather and high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all the orders recelved from their customers, the ice cream vans. Due to these circumstances, the company has decided to choose the amount of each flavor to produce that will maximize total profit, given the constraints on the supply of the basic ingredients. The pistachio, mango, and strawberry flavors generate, respectively, SAR6.5, SAR5.07, and SAR6.13 of profit per gallon sold. The company has only 188 gallons of mill, 145kg of sugar, and 66 gallons of cream left in its inventory. To produce one gallon of ice cream the following resources will consume, 0.44 gallon of milk, 0.51kg of sugar, and 0.20 gallons of cream for the pistachio flavor. For the other two flavors, they will require 0.50 and 0.42 gallons of milk, 0.42kg of sugar for both of them, and 0.16 and 0.23 gallons of cream for the mango and strawberry flavors, respectively. The sensitivity analysis report is A) Find out the optimal solution to this problem (Don't forget your conclusion)? (3 Pts.) B) Suppose the profit per gallon of strawberry changes to SAR5.4. Will the optimal solution change? (2 Pts.) C) Suppose the profit per gallon of mango changes to SAR5.3. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) D) Suppose the company discovers that 9 gallons of cream have gone sour and so must be thrown out. Will the optimal solution change, and what can be said about the effect on total change, and what can be said about the effect on total profit? (2 Pts.) D) Suppose the company discovers that 9 gallons of cream have gone sour and so must be thrown out. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) E) Suppose the company has the opportunity to buy an additional 21kg of sugar at a total cost of SAR169. Should they? Explain. (2 Pts.) F) Suppose that, the last milk shipment was 185 gallons. At the same time/ the company had decided to change the pistachio ice cream profit to SAR7. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) Q1. Solve the following question: F and M Inc, supplies its ice cream vans with three flavors of ice cream: pistachio, mango, and strawberry. Due to extremely hot weather and high demand for its products, the company has run short of its supply of ingredients: milk, sugar, and cream. Hence, they will not be able to fill all the orders recelved from their customers, the ice cream vans. Due to these circumstances, the company has decided to choose the amount of each flavor to produce that will maximize total profit, given the constraints on the supply of the basic ingredients. The pistachio, mango, and strawberry flavors generate, respectively, SAR6.5, SAR5.07, and SAR6.13 of profit per gallon sold. The company has only 188 gallons of mill, 145kg of sugar, and 66 gallons of cream left in its inventory. To produce one gallon of ice cream the following resources will consume, 0.44 gallon of milk, 0.51kg of sugar, and 0.20 gallons of cream for the pistachio flavor. For the other two flavors, they will require 0.50 and 0.42 gallons of milk, 0.42kg of sugar for both of them, and 0.16 and 0.23 gallons of cream for the mango and strawberry flavors, respectively. The sensitivity analysis report is A) Find out the optimal solution to this problem (Don't forget your conclusion)? (3 Pts.) B) Suppose the profit per gallon of strawberry changes to SAR5.4. Will the optimal solution change? (2 Pts.) C) Suppose the profit per gallon of mango changes to SAR5.3. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) D) Suppose the company discovers that 9 gallons of cream have gone sour and so must be thrown out. Will the optimal solution change, and what can be said about the effect on total change, and what can be said about the effect on total profit? (2 Pts.) D) Suppose the company discovers that 9 gallons of cream have gone sour and so must be thrown out. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.) E) Suppose the company has the opportunity to buy an additional 21kg of sugar at a total cost of SAR169. Should they? Explain. (2 Pts.) F) Suppose that, the last milk shipment was 185 gallons. At the same time/ the company had decided to change the pistachio ice cream profit to SAR7. Will the optimal solution change, and what can be said about the effect on total profit? (2 Pts.)