Reference no: EM133199019

Problem:

Calories	Iron	Protein	Carbohydrates	Fat	Cholesterol	$/lb
(per lb)	(mg/lb)	(g/lb)	(g/lb)	(g/lb)	(mg/lb)
Chicken	520	4.4	17	0	30	180	3.44
Fish	500	3.3	85	0	5	90	3.99
Ground beef	860	0.3	82	0	75	350	4.99
Dried beans	600	3.4	10	30	3	0	1.1
Lettuce	50	0.5	6	0	0	0	0.9
Potatoes	460	2.2	10	70	0	0	0.59
Milk (2%)	240	0.2	16	22	10	20	0.83

1. Linear Programming

1. You are asked to make two meals: a vegetarian and a non-vegetarian. They each must meet the following criteria:

• Between 1500 and 2000 calories
• At least 5 mg of iron
• At least 25 but no more than 60 g of fat
• At least 30 g of protein
• At least 40 g of carbohydrates
• No more than 140 mg of cholesterol
• The vegetarian meal may have no chicken, fish, or beef.
• The non-veg meal must be at least one third meat (chicken, fish, or beef) by weight.

1. What is the vegetarian meal? How much does it cost?

Nutrition and cost information are found in the excel file.

You are asked to find the meals that meet these criteria at the absolute lowest cost. Use Excel and Solver to find them.

1. What is the non-vegetarian meal? How much does it cost?

2. What is the range of optimality for the price of milk in the vegetarian meal? Explain what it means.

3. What is the shadow price of the Calories minimum in the non-vegetarian meal? If the minimum Calories went up to 1600, what would you expect to happen to the price per serving of lunch? (Hint: You do not have to use Solver again to answer this.)