The table on the Problem 5 worksheet presents 4 foods (8 oz. steak; I oz cheese, 1 apple and 8 oz of milk) and the nutritional characteristics (calories, fat, protein and carbohydrates) for each food. The cost of each food is also shown in the table. The objective is to minimize the cost of a meal prepared from these 4 foods, subject to the constraints listed on the worksheet. Use SOLVER to determine the quantity of each food to include in a meal to minimize cost subject to the constraints listed on the worksheet. What is the value of the objective function (cost, $'s)?

Food Calories Fat, grams Protein, grams Carbs, grams Cost/ unit, $'s Maximum Units of food Steak, 8 oz. 692 51 57 0 10 1.5 Objective Cheese , 1 oz 110 9 6 1 0.25 4 Apple 81 1 1 22 0.5 2 Milk, 8 oz 150 8 8 12 0.2 1 Constraints: Steak, 8 oz. 1 Calories : <=1600 >= 1200 Cheese , 1 oz 1 Protein: >= 100 grams Apple 1 Carbs: <= 45 grams Milk, 8 oz 1 Fat: <= 100 grams <= Maximum units