In: Operations Management
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=
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 |