Question: with excel formulas please asap Slim-Down Manufacturing makes a line of nutritionally complete, weight-reduction beverages. One of its products is a strawberry shake that is

with excel formulas please asap
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 Calories from Fat (per tbsp.) Total Calo- ries (per tbsp.) Vitamin Content (mg/tbsp.) Thickeners (mg/tbsp.) Cost (/tbsp.) Ingredient Strawberry flavoring Cream Vitamin supplement Artificial sweetener Thickening agent 1 75 0 O 30 50 100 0 120 80 20 o 50 o 2. 3 8 1 2. 25 10 8 25 15 6 The nutritional requirements are as follows: The beverage must total between 380 and 420 calories (inclusive). No more than 20 percent of the total calories should come from fat. There must be at least 50 milligrams (mg) of vitamin content. For taste reasons, there must be at least two tablespoons (tbsp.) of strawberry flavoring for each tbsp. of artificial sweetener 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 requirements. a. Formulate and solve a linear programming model for this problem on a spreadsheet. b. Formulate a complete algebraic model for this problem c. Use the space below to comment on the final results using your own wordsStep by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
