Question: (g) O 3 5 110 2 o 4 48 4 2. 0.22 100 2 12 5 3 0.10 Cas 3 (A Diet Problem) Breath takers,

(g) O 3 5 110 2 o 4 48 4 2. 0.22 100 2 12 5 3

(g) O 3 5 110 2 o 4 48 4 2. 0.22 100 2 12 5 3 0.10 Cas 3 (A Diet Problem) Breath takers, a health and fitness center, operates a morning fitness program for senior citizens. The program includes aerobic exercise, either swimming or step exercise, followed by a healthy breakfast in the dining room. Breath takers' dietitian wants to develop a breakfast that will be high in calories, calcium, protein, and fiber, which are especially important to senior citizens, but low in fat and cholesterol. She also wants to minimize cost. She has selected the following possible food items, whose individual nutrient contributions and cost from which to develop a standard breakfast menu are shown in the following table: Breakfast Fat Cholesterol Iron Calcium Protein Fiber Food Calories (g) (mg) (mg) (mg) (g) Cost 1. Bran cereal 90 0 6 20 $0.18 (cup) 2. Dry cereal (cup) 3. Oatmeal o 2 (cup) 4. Oat bran o 3 (cup) 5. Egg 75 5 30 0.10 6. Bacon 3 O 0.09 (slice) 7. Orange 1 8. Milk2% 100 250 (cup) 9. Orange juice (cup) 10. Wheat 65 1 26 0.07 toast (slice) The dietitian wants the breakfast to include at least 420 calories, 5 milligrams of iron, 400 milligrams of calcium, 20 grams of protein, and 12 grams of fiber. Furthermore, she wants to limit fat to no more than 20 grams and cholesterol to 30 milligrams. a. Create the Linear Programming model to represent the problem. b. Create a spreadsheet model for this problem, and solve it. What is the optimal solution? 90 2 00 6 4 0.12 1 O 270 8 7 2 35 0 o 65 O o 52 1 1 0.40 0.16 12 o 9 o 120 o 0 0 3 1 0 0.50 O 1 3 3

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!