1- The manager of a hospital wishes to develop a computerized menu planning syst
ID: 372082 • Letter: 1
Question
1- The manager of a hospital wishes to develop a computerized menu planning system. The menu is divided into three major categories: vegetables, meat, and dessert. At least one equivalent serving of each category is desired. The cost per serving of some suggested items as well as their content of carbohydrates, vitamins, protein, and fats is summarized below CARBO- HYDRATES COSTIN VITAMINS PROTEIN FATS S/SERVING Vegetables Peas Green beans Okra Corn Macaroni Rice 0.10 0.12 0.13 0.09 0.10 0.07 Meat Chicken Beef Fish 0.70 1.20 0.63 Dessert Orange Apple Pudding Jello 0.28 0.42 0.15 0.12 Suppose that the minimal requirements of carbohydrates, vitamins, protein, and fats per meal are respectively 5,10, 10, and 2. A) Formulate the menu-planning problem as a linear program. B) Calculate the optimum total cost and the optimal serving amount for each one of the items listed above by using M.S EXCEL solver.Explanation / Answer
The Optimum total cost per serving is found to be $ 0.965
Let the decision variables and objective function be:
Subjected to Constraints:
The model is solved in excel and output is shown along with solver screen:
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.