Case Study 1 Due on: 11 Oct, 2021 Write your case in the following format: . Problem statement Solution approach / computer program used Results - presentation / analysis Overall recommendation . A Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of its products is a strawberry shake that is designed to be a complete meal. The strawberry shake consists of several ingredients. Some information about each of these ingredients is given in the following table. Calories From Fat (per tbsp.) 1 Total Calories (per tbsp.) 50 Vitamin Content (mg/tbsp.) 20 Thickeners (mg/tbsp.) 3 Cost ($/thsp.) 0.10 Ingredient Strawberry flavoring Cream 75 100 0 8 0.08 0 0 50 1 0.25 0 120 0 2 0.15 Vitamin supplement Artificial sweetener Thickening agent 30 80 2 25 0.06 The nutritional requirements are as follows. The beverage must have total calories between 380 and 420 calories (inclusive). The Calories from fat should be at most 76 calories. There must be at least 50 milligrams (mg) of vitamin content. Finally, to maintain proper thickness, there must be exactly 15 mg of thickeners in the beverage. Management would like to select the quantity of each ingredient for the beverage that would minimize cost while meeting the above requirement. a. Define your decision variables. b. Write this formulation in algebraic form. C. Solve the LP model on a spreadsheet