ASSIGNMENT 2 XXXXXXXXXXSTAT 2112
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 ca
ohydrates
· 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.
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.
a. What is the vegetarian meal? How much does it cost?
. What is the non-vegetarian meal? How much does it cost?
c. What is the range of optimality for the price of milk in the vegetarian meal? Explain what it means.
d. 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.)
Upload your excel sheet with your results.
Assignment XXXXXXXXXXSolution XXXXXXXXXXSTAT 2112 XXXXXXXXXX2
Meals
Calories Iron Protein Ca
ohydrates Fat Cholesterol $/l
(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