In: Operations Management
Question 1: You manage the cost of a meal for a shelter. You have three menu items to serve: chicken, carrot and potato. You must meet minimum nutritional requirements for the meal while managing cost:
Chicken Carrot Potato
Cost $/kg $8.25 $2.85 $3.75
Calories cal/kg 1430 410 1990
Fiber g/kg 5.0 37.0 28.0
Protein g/kg 170 9 29
You are to decide how many kg of chicken, carrots and potato to serve to minimize the cost to the shelter.
You are constrained by each meal must provide a minimum of 650 calories, 15 grams of fiber and 35 grams of protein.
Each meal must include at least 0.05 kg of each item.
What is the cost? Use Solver to to optimize this related set of equations.
This is a linear programming/optimization problem. Follow the pattern of solution shown in the lesson to solve this problem. PLEASE USE EXCEL!
We will setup Excel to solve using Solver as shown in below Excel screenshots.
Click on Solve to get the optimal solution.
Optimal meal plan would be (number of kgs of each chicken, carrots and potato per meal)
Chicken | Carrot | Potato | |
# of Kgs included in each meal | 0.165713 | 0.26768 | 0.152403 |
Optimal cost per meal is $2.70153
Please give thumbs up/ likes if you consider my answer useful.
Thank you!