Use Solver Kathy Roniger campus dietitian for a small Idaho

(Use Solver) 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 mealcontent requirements should be met: (1) between 900 and 1,500 calories; (2) at least 4 miligrams 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, Roniger’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 the contribution to each of the five nutritional requirements are given in the table below.

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) What is the optimal solution?

d) Generate the sensitivity report in excel and explain how would an increase in milk price by 10 cents/lb impact your decision.

e) How much can you change the milk price before the optimal corner switches?

Table of Food Values and Costs Fat ProteinCarbohydrates Cost/ Calories/ Iron LB 295 Food item Milk Ground meet1216 Chicken Fish Beans Spinach Potatoes MG/LB) (GM/LB) (GM/LB) (GM/LB 0.2 0.2 4.3 3.2 3.2 14.1 2.2 LB (S 0.6 2.35 1.15 2.25 0.58 1.17 0.33 16 96 16 81 74 83 394 358 128 118 279 0 0 0 28 19 63 0.5 0.8 0.5

Solution