please include formulas used in cells

Two men supply its ice cream parlors with four flavors of ice cream: chocolate, vanilla, strawberry, and butter pecan. 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 the orders received from their ice cream parlors. Due to these circumstances, the company has decided to choose the amount of each flavor to produce that will maximize profit. The profit contribution per gallon for each product is as follows: Chocolate =$1.00, Vanilla =$0.90, Strawberry =$0.95, and Butter Pecan =$1.10 The company only has 200 gallons of milk, 150 pounds of sugar, and 60 gallons of cream left in inventory. The following table provides the product resource requirements per gallon of ice cream. a. What is the optimal solution and total profit? b. Make a copy of your model from Part A, check whether the optimal production mix remains the same if the unit profit per gallon Strawberry changes to $1.00. If not, what is the new solution and profit? c. Make a copy of your model from Part A, check whether the optimal production mix remains the same if the unit profit per gallon Strawberry changes to $0.92. If not, what is the new solution and profit? Two men supply its ice cream parlors with four flavors of ice cream: chocolate, vanilla, strawberry, and butter pecan. 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 the orders received from their ice cream parlors. Due to these circumstances, the company has decided to choose the amount of each flavor to produce that will maximize profit. The profit contribution per gallon for each product is as follows: Chocolate =$1.00, Vanilla =$0.90, Strawberry =$0.95, and Butter Pecan =$1.10 The company only has 200 gallons of milk, 150 pounds of sugar, and 60 gallons of cream left in inventory. The following table provides the product resource requirements per gallon of ice cream. a. What is the optimal solution and total profit? b. Make a copy of your model from Part A, check whether the optimal production mix remains the same if the unit profit per gallon Strawberry changes to $1.00. If not, what is the new solution and profit? c. Make a copy of your model from Part A, check whether the optimal production mix remains the same if the unit profit per gallon Strawberry changes to $0.92. If not, what is the new solution and profit