After consulting with nutritionists, we decree that a satisfactory diet has at least 2000 kcal of energy, 55 g of protein, and 800 mg of calcium (vitamins and iron are supplied by pills). We have decided to impose variety by having a limit on the number of servings/day for each of our six foods.
What is the least cost satisfactory diet?
a) Formulate an LP to answer this question.
b) Solve this model using Excel Solver. Provide:
I. The optimal solution and the optimal objective function value.
II. Answer and Sensitivity reports.
III. What are the binding constraints?
IV. What are the shadow prices corresponding to energy, protein and calcium constraints?