AutoSave OFF + 5 = Econ 3300 EP1 Spring '21 Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) 11 Paste BI U ' A Insert Wrap Text General Share 4 Comments Delete == Merge & Center $ % 9 .00 .00 0 Conditional Format Cell Formatting as Table Styles Sort & Find & Ideas Sensitivity Format Filter Select D46 fx B C D E F G H | J K L M 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 AutoSave OFF + 5 = Econ 3300 EP1 Spring '21 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert Calibri (Body) 11 Paste BI U ' A Wrap Text General Delete Merge & Center $ % 9 .00 .00 0 Conditional Format Cell Formatting as Table Styles Format Sort & Filter 28.0. Find & Select 4 Ideas Sensitivity D46 A fx B C D E F G H I J K L 45 46 222222233333332724144 The objective is to determine the amount of each ingredient to be used in the mix (1 lb) that will minimize total cost 25 26 2 points Set up the problem on a different sheet 28 2 points Solve the problem using SOLVER, making sure to generate the Answer Report and Sensitivity Report 29 30 1 point How much is the total cost? What is the optimal solution? Maize Wheat Rice Soybean Sunflower Oil Meat 35 1 point Sum should total 1 lb 0 lb 36 38 2 points 39 40 1 point How much is the new total cost? Assume Maize cost ($/lb) goes up by .02, from .10 to .12 AND Max Chloride can be 0.8 instead of 0.7. Make the above changes, re-run SOLVER, and generate the Answer and Sensitivity Report. What is the new optimal solution? Maize 1 point Wheat Rice Soybean Sunflower Oil Meat Sum should total 1 lb 0 lb Questions B + 179%