New Exercise Bank Content Qu$.06-25$

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 next. 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. Finally, to maintain proper thickness, there must be exactly $15$ mg of thickeners in the beverage.

Ingredient Calories from Fat $($per tablespoon$)$ Total Calories $($per tablespoon$)$ Vitamin Content $($mg$/$tablespoon$)$ Thickeners $($mg$/$tablespoon$)$ Cost $(/$tablespoon$)$

Strawberry flavoring $15020310$

Cream $75100088$

Vitamin supplement $0050125$

Artificial Sweetener $01200215$

Thickening agent $30802256$

Click here for the Excel Data File

Formulate and solve a linear programming model for this problem on a spreadsheet.

Determine the quantity of each ingredient for the beverage.

Note: Leave no cells blank. Enter $"0"$ when necessary. Round your answers to $3$ decimal places.

Determine the total cost.

Note: Leave no cells blank. Enter $"0"$ when necessary. Round your answer to $2$ decimal places.