1. Other
  2. Other
  3. problem coneheads supplies its ice cream parlors with three flavors...

Question: problem coneheads supplies its ice cream parlors with three flavors...

Question details

Problem: Coneheads supplies its ice cream parlors with three flavors of ice cream: chocolate, vanilla, and banana. Due to extremely hot weather and a 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 of the orders received from their retail outlets, the ice cream parlors. 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 chocolate, vanilla, and banana lavors generate, respectively, $1.00, $0.90, and $0.95 of profit per gallon sold. The company only has 200 gallons of milk, 150 pounds of sugar, and 60 gallons of cream left in its inventory. A gallon of each of the different flavors of ice cream requires the amounts of each of the main ingredients shown in the table below. Chocolate Vanilla Ingredient Milk (gallons) Sugar (pounds) Cream (gallons) Banana 0.40 0.40 0.20 0.45 0.50 ,10-01 0.50 0.40 Solve a linear program to determine the profit-maximizing quantities of each flavor to produce subject to the available ingredients. [20 points) b. Suppose the profit per gallon of banana ice cream changes to $1.00. Will the optimal solution change? What can be said about the effect on total profit? [10 points) c. Suppose the company discovers that three gallons of cream have gone sour and must be thrown out. Will the optimal solution change? What can be said about the effect on total profit? [10 points d. Suppose the company has the opportunity to buy an additional 15 pounds of sugar at a total cost of $15. Should it do so? Explain your recommendation. [10 points NOTE: Answer parts (b)-(d) using the sensitivity report generated by Solver when you analyze the initial linear program. Answers that are found by resolving the model after changing the parameters as specified will receive at most 50% of the maximum points for each part. Each of the parts in (b)-(d) is independent (i.e., any change in one part does not apply to the other parts)
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution