**Please indicate the cell formulas you use**

Assignment Questions: PROBLEM 5: (30 Marks) Agri-Pro is a company that sells agricultural products to farmers in a number of provinces. One service that it provides to customers is custom feed mixing, for which a farmer can order a specific amount of livestock feed and specify the amount of corn, grain, and minerals that the feed should contain. This is an important service because the proper feed for various farm animals changes regularly depending upon the weather, and pasture conditions, for example. Agri-Pro stocks bulk amounts of four types of feeds that it can mix to meet a given customer's specifications. The following table summarizes the four feeds; their composition of corn, grain, and minerals; and the cost per kilogram for each feed type: Percent of Nutrient Nutrient Feed 1 Feed 2 Feed 3 Feed 4 Corn 10% 15% 20% 20% Grain 20% 30% 25% 25% Minerals 20% 20% 20% 30% Cost per kilogram $0.15 $0.20 $0.18 $0.25 Agri-Pro has just received an order from a local chicken farmer for 8,000 kilograms of feed. The farmer wants the feed to contain at least 10% corn; at least 25% grain; and at least 20% minerals. a) Develop the model in Excel. (10 marks) b) Solve the problem of finding the least-cost feed mix. Give the quantities of the individual feeds included and the total daily cost. (4 marks) c) In what nutritional elements will you have a surplus? In what quantities? (4 marks) d) Create a Sensitivity Report and answer the following questions: (i) Suppose we forced Feed 3 to be in the solution, what would happen to the objective function's value? (4 marks) (i) What are the max and min values of the objective function coefficients for Feed 1 and Feed 2 for which the current optimal solution is valid? (4 marks) (ii) What do the shadow prices for the grain and minerals constraints mean? What are the maximum and minimum values for the corn and grain constraints for which the current constraint value does not change? (4 marks) Hint: When you define your decision variables use thousands of kilograms as the units