Farm HappyChicken is revisiting current feed formulation for their poultry. The feed is obtained by mixing various ingredients. Common ingredients, their costs, and nutrition facts are presented below. The nutrition facts of the resulting mix must fall inside the provided min/max values. For example, Calories of the mix should be at least 1400 but no more than 1750:

1675*Ma + 1550*W + 1150*R + 1275*So + 1100*Su + 1340*Me >=1400

1675*Ma + 1550*W + 1150*R + 1275*So + 1100*Su + 1340*Me

where Ma, W, R, So, Su, and Me are the ingredient amounts (in lb). The model must include constraints for all the listed nutrients. Since the mix weighs 1 lb, Ma + W + R + So + Su + Me = 1 lb.

Farm HappyChicken is revisiting current feed formulation for their poultry. The feed is obtained by mixing various ingredients. Common ingredients, their costs, and nutrition facts are presented below. The nutrition facts of the resulting mix must fall inside the provided min/max values. For example, Calories of the mix should be at least 1400 but no more than 1750: 1675*Ma + 1550*W + 1150*R + 1275*50 + 1100*5u + 1340*Me >=1400 1675*Ma + 1550*W + 1150*R + 1275*50 + 1100*5u + 1340*Me (=1750, where Ma, W, R, So, Su, and Me are the ingredient amounts (in lb}. The model must include constraints for all the listed nutrients. Since the mix weighs 1|b,Ma+w+R+So+Su+Me=1|b. : Jngredient Maize Wheat Rice Soybean Sunflower Oil Meat Cost (Sflb} 0.10 0.15 0.07 0.22 0.15 0.23 : Jngredient Maize Wheat Rice Soybean Sunflower Oil Meat Nutrient Requirements _ Min Value Max Value _ Calories (Kcal/lb) 1675 1550 1150 1275 1100 1340 1400 1750 _ Protein (98} 13.6 13 7.9 48 46.8 50.4 15 40 _ Fat (96} 2.1 2.3 1.7 21.2 10.9 10 1 4.5 _ Calcium {'36} 0.22 0.05 0.11 0.2 0.3 10.3 0.15 1.5 _ Phosphorous {96} 0.35 0.2 0.48 0.37 0.5 5.1 0.1 0.7 _ Lysine {'38} 1.01 0.5 0.06 3.2 1.6 2.6 0.5 2.5 _ Methionine {'36} 0.2 0 0 0.72 0 0.71 0.2 0.7 _ Sodium (96} 0.1 0.6 0 2.9 0.2 7 0.02 0.3 Chloride (98} 0.7 0.8 0.3 0.3 1.9 14 0.05 0.7 'The objective is to determine the amount of each ingredient to be used in the mix (1 lb} that will minimize total cost :2 points :Set up the problem on a different sheet :2 points :Solve the problem using SOLVER, making sure to generate the Answer Report and Sensitivity Report :1 point :How much is the total cost? _What is the optimal solution? _ IMaize IWheat Rice Soybean Sunflower Oil IMeat Sum should total 1 lb _1 point 0_lb :2 points :Assume Maize cost (S/lb} goes up by .02, from .10 to .12 AND Max Chloride can be 0.8 instead of 0.7. _ Make the above changes, rerun SOLVER, and generate the Answer and Sensitivity Report. :1 point :How much is the new total cost? _What is the new optimal solution? _ IMaize IWheat Rice Soybean Sunflower Oil IMeat Sum should total 1 lb _1 point 0_lb