Answer Happy

STAT 2112 13 ASSIGNMENT 2 13 Anne Chang is the dietician for Humber College women's soccer team, and she is attempting to determine a nutritious lunch menu for the team. She has set the following nutritional guidelines for each lunch serving. . . Between 1500 and 2000 calories At least 5 mg of iron At least 20 but no more than 60 g of fat At least 30 g of protein At least 40 g of carbohydrates No more than 30 mg of cholesterol . . . She selects the menu from seven basic food items as follows, with the nutritional contribution per pound and the cost as given. $/1b Chicken Fish Ground beef Dried beans Lettuce Potatoes Milk (2%) Calories (per lb) 520 500 860 600 50 460 240 Iron (mg/lb) 4.4 3.3 0.3 3.4 0.5 2.2 0.2 Protein Carbohydrates (g/lb) (g/lb) 17 0 85 0 82 0 10 30 6 0 10 70 16 22 Fat (g/lb) 30 5 75 3 0 0 10 Cholesterol (mg/lb) 180 90 350 0 0 0 20 3.44 3.99 4.99 1.10 0.90 0.59 0.83 Anne wants to select a menu to meet the nutritional guidelines while minimizing the total cost per serving. Please help Anne to formulate a linear programming model and solve it using Excel Solver.