[Solved] ISyE65001 Homework 11-the diet problem

In the videos, we saw the diet problem. (The diet problem is one of the first large-scale optimization problems to be studied in practice. Back in the 1930s and 40s, the Army wanted to meet the nutritional requirements of its soldiers while minimizing the cost.) In this homework you get to solve a diet problem with real data. The data is given in the file diet.xls.

1. Formulate an optimization model (a linear program) to find the cheapest diet that satisfies the maximum and minimum daily nutrition constraints, and solve it using PuLP. Turn in your code and the solution. (The optimal solution should be a diet of air-popped popcorn, poached eggs, oranges, raw iceberg lettuce, raw celery, and frozen broccoli. UGH!)
2. Please add to your model the following constraints (which might require adding more variables) and solve the new model:
   1. If a food is selected, then a minimum of 1/10 serving must be chosen. (Hint: now you will need two variables for each food i: whether it is chosen, and how much is part of the diet.

Youll also need to write a constraint to link them.)

1. Many people dislike celery and frozen broccoli. So at most one, but not both, can be selected.
2. To get day-to-day variety in protein, at least 3 kinds of meat/poultry/fish/eggs must be selected. [If something is ambiguous (e.g., should bean-and-bacon soup be considered meat?), just call it whatever you think is appropriate I want you to learn how to write this type of constraint, but I dont really care whether we agree on how to classify foods!]

If you want to see what a more full-sized problem would look like, try solving your models for the file diet_large.xls, which is a low-cholesterol diet model (rather than minimizing cost, the goal is to minimize cholesterol intake). I dont know anyone whod want to eat this diet the optimal solution includes dried chrysanthemum garland, raw beluga whale flipper, freeze-dried parsley, etc. which shows why its necessary to add additional constraints beyond the basic ones we saw in the video! [Note: there are many optimal solutions, all with zero cholesterol, so you might get a different one.

It probably wont be much more appetizing than mine.]