Question

A diet needs to be created that contains not less than 2146 calories, not more than 58 grams of protein, not less than 10 grams of carbohydrates and not less than 13 grams of fat. Also, the diet should haveminimal cost. In addition the diet should include at least 1 Units of fish and at least 1.2 cup of milk.

The diet will consist of the six different foods: Bread, Milk, Cheese, Fish, Potato and Yogurt. The following table lists the cost per unit of each item and the number of grams of protein, fat, and carbohydrates per unit as well as the calories that will be supplied by each food unit.

	Bread	Milk	Cheese	Potato	Fish	Yogurt
Cost, (cents)	12	30	33	15	59	20
Protein, g	6	9	11	1.3	11	12.2
Fat, g	2	9	10	0.1	12	2
Carbohydrates, g	22	11.7	0.4	23.6	0	19
Calories, Cal	120	154	155	157	133	356

Find a diet that meets the requirements above while keeping the cost at an absolute minimum. Make sure that your Food Units are all Integers.

Minimum Cost=

Min Cost value is between 263 and 279

Bread =

Milk=

Cheese=

Potato=

Fish=

Yogurt=

Answer 1

Excel LP formulation

Solving the Solver Output is

Minimum Cost = 271

Optimal Solution

Bread =	1
Milk=	2
Cheese=	0
Potato=	8
Fish=	1
Yogurt=	1