We wish to prepare a daily diet containing different kinds of food such as oats, chicken,...

Transcribed Image Text:

We wish to prepare a daily diet containing different kinds of food such as oats, chicken, eggs, milk, kuchen and beans. This diet must contain at least 2,200 (Kcal), 60 grams of protein and 900 (mg) of calcium. Energy, proteins and calcium obtained from each portion of each kind of food are given in the table below. Also, to provide some variety in the diet, some limits are set for the daily portions of food which is given in the table. Food Oats Chicken Eggs Milk Kuchen Beans Portion Size 28 gr 100 gr 2 big ones 237 cc 170 gr 260 gr Energy (Kcal) 110 205 160 160 420 260 Proteins (Grams) 4 32 13 8 4 14 Calcium (mg) 2 12 54 285 22 80 Price (TL/portion) 30 240 130 90 200 60 Limit (portions/day) 4 3 2 8 2 2 Formulate the problem as a linear program to find a daily diet (number of portions for each kind of food) that has the lowest cost associated with meeting the above requirements. Use the model template discussed in the class to formulate the problem. Clearly define your objective, sets&indices if required, parameters, decision variables, objective function and constraints. Solve your model with excel solver. We wish to prepare a daily diet containing different kinds of food such as oats, chicken, eggs, milk, kuchen and beans. This diet must contain at least 2,200 (Kcal), 60 grams of protein and 900 (mg) of calcium. Energy, proteins and calcium obtained from each portion of each kind of food are given in the table below. Also, to provide some variety in the diet, some limits are set for the daily portions of food which is given in the table. Food Oats Chicken Eggs Milk Kuchen Beans Portion Size 28 gr 100 gr 2 big ones 237 cc 170 gr 260 gr Energy (Kcal) 110 205 160 160 420 260 Proteins (Grams) 4 32 13 8 4 14 Calcium (mg) 2 12 54 285 22 80 Price (TL/portion) 30 240 130 90 200 60 Limit (portions/day) 4 3 2 8 2 2 Formulate the problem as a linear program to find a daily diet (number of portions for each kind of food) that has the lowest cost associated with meeting the above requirements. Use the model template discussed in the class to formulate the problem. Clearly define your objective, sets&indices if required, parameters, decision variables, objective function and constraints. Solve your model with excel solver. We wish to prepare a daily diet containing different kinds of food such as oats, chicken, eggs, milk, kuchen and beans. This diet must contain at least 2,200 (Kcal), 60 grams of protein and 900 (mg) of calcium. Energy, proteins and calcium obtained from each portion of each kind of food are given in the table below. Also, to provide some variety in the diet, some limits are set for the daily portions of food which is given in the table. Food Oats Chicken Eggs Milk Kuchen Beans Portion Size 28 gr 100 gr 2 big ones 237 cc 170 gr 260 gr Energy (Kcal) 110 205 160 160 420 260 Proteins (Grams) 4 32 13 8 4 14 Calcium (mg) 2 12 54 285 22 80 Price (TL/portion) 30 240 130 90 200 60 Limit (portions/day) 4 3 2 8 2 2 Formulate the problem as a linear program to find a daily diet (number of portions for each kind of food) that has the lowest cost associated with meeting the above requirements. Use the model template discussed in the class to formulate the problem. Clearly define your objective, sets&indices if required, parameters, decision variables, objective function and constraints. Solve your model with excel solver.

Answer rating: 100% (QA)

Linear Programming Model for Optimal Daily Diet Objective Minimize Total Cost of Diet Sets F set of ... View the full answer