(College meal selection problem) Kathy Roniger,

campus dietitian for a small Idaho 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; (2) 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,

Ronigers food stock includes seven items that can be

prepared and served for supper to meet these requirements.

The cost per pound for each of the seven food

items and the contribution of each to the five nutritional

requirements are given in the table on this page.

What combination and amounts of food items

will provide the nutrition Roniger requires at the

least total food cost?

(a) Formulate as an LP problem.

(b) What is the cost per meal?

(c) Is this a well-balanced diet?

Format must be done as in example excel table below

ta for Problem 8.12 FOOD VALUES CALORIES IRON FOOD ITEM Milk Ground me at Chicken Fish Beans Spinach Potatoes FAT (GW PROTEIN CARBOHYDRATES COST LB (S) 0.60 2.35 1.15 LB MGOLB) 0.2 0.2 4.3 3.2 3.2 14.1 LB) 16 96 GWLB) 16 81 74 83 (GWLB) 295 1,216 394 358 128 118 279 0.5 0.8 1.4 0.5 28 19 63 0.58 1.17 0.33 14 ta for Problem 8.12 FOOD VALUES CALORIES IRON FOOD ITEM Milk Ground me at Chicken Fish Beans Spinach Potatoes FAT (GW PROTEIN CARBOHYDRATES COST LB (S) 0.60 2.35 1.15 LB MGOLB) 0.2 0.2 4.3 3.2 3.2 14.1 LB) 16 96 GWLB) 16 81 74 83 (GWLB) 295 1,216 394 358 128 118 279 0.5 0.8 1.4 0.5 28 19 63 0.58 1.17 0.33 14