op research

Use OM excel software to find the optimal solution of the following problem: Breakertakers, a health and fitness center operates a morning fitness program for senior citizens. The program includes aerobic exercise, either swimming or step exercise, following by a healthy breakfast in the dining room. Breaktakers 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 known in the following table: Breakfast food Calories Fat(g) Cholesterc Iro(mg) Calcium(n Protein(g) Fiber(g) Cost Bran cereal (cup) 90 6 20 0.18 Dry cereal 110 48 0.22 Oatmeal (cup) 100 12 0.1 Oat (cup) 90 8 0.12 Egg 75 270 30 0.1 Bacon 35 0.09 Orange 65 52 0.4 Milk 100 250 0.16 Orange juice 120 0.5 Wheat toast 65 HO POWUNNNO HOOKOFWNA 26 WOOHOOAWNU 0.07