Question: Problem 3. Diet Problem. Susan Cholette, campus dietitian for a small Florida college, is responsible for formulating a nutritious meal plan for students. For an

Problem 3. Diet Problem. Susan Cholette, campus

Problem 3. Diet Problem. Susan Cholette, campus dietitian for a small Florida college, is responsible for formulating a nutritious meal plan for students. For an evening meal, she feels that the following five meal- content requirements should be met: (1) between 900 and 1,500 calories; at least 4 milligrams of iron; (3) no more than 50 grams of fat; (4) at least 26 grams of protein; and (5) no more than 50 grams of carbohydrates. On a particular day, Susan's food stock includes seven items that can be prepared and served for supper to meet these requirements. The cost per pound for each food item and its contribution to each of the five nutritional requirements are given in the accompanying table: Table of Food Values and Costs Food Iron g/lb Fat g/lb Protein g/lb Item 0.2 Milk Ground Meat Chicken Fish Beans Spinach Potatoes Calories/ Pound/ 295 1,216 394 358 128 118 279 0.2 4.3 3.2 3.2 14.1 2.2 16 96 9 0.5 0.8 1.4 0.5 16 81 74 83 7 14 8 Carbohydrates g/lb 22 0 0 0 28 19 63 Cost/ Pound/$ 0.60 2.35 1.15 2.25 0.58 1.17 0.33 Notice that the last column contains the costs of the food items. Susan is looking for the combination and amounts of food items that will provide the nutrition required at the least total food cost. Answer the following questions. a. Formulate this problem as a linear programming problem. b. Setup and solve this problem in Excel

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!