Please give a step by step solution in excel with the excel formulas. And answer all the parts of the question. Will give it an upvote.

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: Nutrient Corn Grain Minerals Cost per kilogram Feed 1 20% 25% 30% $0.25 Percent of Nutrient Feed 2 Feed 3 15% 20% 30% 25% 20% 20% $0.18 $0.22 Feed 4 10% 15% 20% $0.15 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 20% corn; at least 15% grain; and at least 25% 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 4 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; Feed 3; and Feed 4 for which the current optimal solution is valid? (4 marks) (ii) What do the shadow prices for the corn 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. 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: Nutrient Corn Grain Minerals Cost per kilogram Feed 1 20% 25% 30% $0.25 Percent of Nutrient Feed 2 Feed 3 15% 20% 30% 25% 20% 20% $0.18 $0.22 Feed 4 10% 15% 20% $0.15 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 20% corn; at least 15% grain; and at least 25% 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 4 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; Feed 3; and Feed 4 for which the current optimal solution is valid? (4 marks) (ii) What do the shadow prices for the corn 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