Dieter: "Padcha, I have this problem related to the nutrition of my animals. I know the nutritional content of the feeds I have available (see the Daily Nutritional Requirements for Animals table). I also know the cost of a kilogram of each feed (see table). I would love to have a way of selecting a mix of Corn, Tankage, and Alfalfa that minimizes my daily cost of providing good nutrition for my animals." Daily Nutritional Requirements for Animals Padcha: "Dieter, I think I might be able to help. In LP optimization, there is a problem that is called the nutrition problem. Of course, it is not only about nutrition, it's also about allocating available resources, in an optimal way (minimal cost), to satisfy requirements. You can image, that there are a lot of problems like that in business. A typical constraint, say for carbohydrates, would read- the number of kilos of Corn times 90, plus the number of kilos of Tankage times 20, plus the number of kilos of Alfalfa times 40 must equal a minimum 200 units of carbohydrates. The constraint shows how we use the resources/decision variables (kilos of Corn, etc.) to satisfy nutritional needs. Tankage Kg. Alfalfa Min. Dail 40 60 60 $25 Corn Carbohydrates90 20 80 20 30 200 180 150 Protein 30 Vitamins 10 SCost of feed/Kg. $35 a) What is the LP for the nutrition problem? b) Solve the problem using Solver. What is the value of the optimal solution? What is the number of kilos of Corn, Tankage, and Alfalfa? (Place the Answer Report below) c) What if the requirements were raised by 1 unit for carbohydrates (from 200 to 201). Without re-solving the problem, what is the new optimal solution value and the units of carbohydrates? (Provide the logic for your answer d) What is the allowable range of values for the coefficient of the Tankage in the objective function, for whicha change of the optimal decision variables will not occur? Dieter: "Padcha, I have this problem related to the nutrition of my animals. I know the nutritional content of the feeds I have available (see the Daily Nutritional Requirements for Animals table). I also know the cost of a kilogram of each feed (see table). I would love to have a way of selecting a mix of Corn, Tankage, and Alfalfa that minimizes my daily cost of providing good nutrition for my animals." Daily Nutritional Requirements for Animals Padcha: "Dieter, I think I might be able to help. In LP optimization, there is a problem that is called the nutrition problem. Of course, it is not only about nutrition, it's also about allocating available resources, in an optimal way (minimal cost), to satisfy requirements. You can image, that there are a lot of problems like that in business. A typical constraint, say for carbohydrates, would read- the number of kilos of Corn times 90, plus the number of kilos of Tankage times 20, plus the number of kilos of Alfalfa times 40 must equal a minimum 200 units of carbohydrates. The constraint shows how we use the resources/decision variables (kilos of Corn, etc.) to satisfy nutritional needs. Tankage Kg. Alfalfa Min. Dail 40 60 60 $25 Corn Carbohydrates90 20 80 20 30 200 180 150 Protein 30 Vitamins 10 SCost of feed/Kg. $35 a) What is the LP for the nutrition problem? b) Solve the problem using Solver. What is the value of the optimal solution? What is the number of kilos of Corn, Tankage, and Alfalfa? (Place the Answer Report below) c) What if the requirements were raised by 1 unit for carbohydrates (from 200 to 201). Without re-solving the problem, what is the new optimal solution value and the units of carbohydrates? (Provide the logic for your answer d) What is the allowable range of values for the coefficient of the Tankage in the objective function, for whicha change of the optimal decision variables will not occur
