What if Analysis/Sensitivity Analysis The Mom and Pop Ice Cream Company makes three kinds of chocolate ice cream: regular, premium and super premium. The properties of 1 gallon (gal) of each type are shown in the table: Flavoring Milk-fat products Shipping weight Profit Regular 24 oz 12 oz 5 lbs $0.75 Premium 20 oz 20 oz 6 lbs $0.95 Super Premium 18 oz 24 oz 7 lbs $1.25 In addition, current commitments require the company to make at least 1 gal of premium for every 4 gal of regular. Each day, the company has available 725 pounds (lb) of flavoring and 425 lb of milk-fat products. If the company can ship no more than 3000 lb of product per day, how many gallons of each type should be produced daily to maximize profit? a) (5 points) Write the complete LP formulation for this problem: decision variables, objective function and constraints. b) (5 points) Create a model in Excel and find the optimal solution using Excel Solver. (Print your model, Answer Report and Sensitivity Report.) a. How many gallons of each type should be produced daily to maximize profit? b. What is the maximum profit? c) (10 points) Using only the Sensitivity Report answer the following questions: a. What is the effect on the optimal solution and total profit if the amount of flavoring available per day increases by 10 pounds? b. What is the effect on the optimal solution and total profit if the amount of milk-fat products available per day decreases by 5 pounds? c. What is the effect on the optimal solution and total profit if the company can ship no more than 2500 lb of product per day instead of 3000 lb? Corroborate your answers by solving the problem with the new information