1. Set up problem on a different excel sheet

2. Solve the problem using SOLVER, generate the Answer report and Sensitivity report

3. How much is total Cost

4. what is the optimal solution for Maize, Wheat, Rice, Soybean, Sunflower oil, and Meat (sum should total 1 lb)

The objective is to determine the amount of each ingredient to be used in the mix (1 lb) that will minimize total cost

Ingredient Cost (5/1b) Maize 0.19 Wheat 0.15 Rice 0.07 Soybean 0.22 Sunflower Oil 0.15 Meat 0.23 Ingredient Maize Wheat Rice Soybean Sunflower Oil Meat # Calories (Kcal/lb) Protein (%) Fat (%) Calcium (%) Phosphorous (%) Lysine (%) Methionine (%) Sodium (%) Chloride (%) 1675 13.6 2.1 0.22 0.35 1.01 0.2 0.1 0.7 1550 13 2.3 0.05 0.2 0.5 1150 7.9 1.7 0.11 0.48 0.06 1275 48 21.2 0.2 0.37 3.2 0.72 2.9 1100 46.8 10.9 0.3 0.5 1.6 1340 50.4 10 10.3 5.1 2.6 0.71 7 14 Nutrient Requirements Min Value Max Value 1400 1750 15 40 1 4.5 0.15 1.5 0.1 0.7 0.5 2.5 0.2 0.7 0.02 0.3 0.05 0.7 ON . 0.6 0.8 0.2 1.9 0.3 Ingredient Cost (5/1b) Maize 0.19 Wheat 0.15 Rice 0.07 Soybean 0.22 Sunflower Oil 0.15 Meat 0.23 Ingredient Maize Wheat Rice Soybean Sunflower Oil Meat # Calories (Kcal/lb) Protein (%) Fat (%) Calcium (%) Phosphorous (%) Lysine (%) Methionine (%) Sodium (%) Chloride (%) 1675 13.6 2.1 0.22 0.35 1.01 0.2 0.1 0.7 1550 13 2.3 0.05 0.2 0.5 1150 7.9 1.7 0.11 0.48 0.06 1275 48 21.2 0.2 0.37 3.2 0.72 2.9 1100 46.8 10.9 0.3 0.5 1.6 1340 50.4 10 10.3 5.1 2.6 0.71 7 14 Nutrient Requirements Min Value Max Value 1400 1750 15 40 1 4.5 0.15 1.5 0.1 0.7 0.5 2.5 0.2 0.7 0.02 0.3 0.05 0.7 ON . 0.6 0.8 0.2 1.9 0.3