this is the full information

Question #3, Assignment #7. You have been hired to determine the least cost feed mix feed for a dairy farmer. The farmer purchases alfalfa hay and three types of grain for his total mixed ration (TMR) which he feed to his cows. The hay and grains contain different amounts of four nutritional elements. Together with a nutritional specialist the farmer has developed some requirements for the feed mixture. His objective is to minimize the cost of the mixture while meeting the nutritional requirements. The data is given in the Table below. Units of Nutritional Elements Contained in One Pound of: Nutritional Elements Minimum Number of Units Required Soybeans Corn Barley Alfalfa Hay 1 4 6 8 1 20000 2 5 7000 1 N 0.5 2 3 4 3 0 10000 0.7 0.3 0.8 4 1 3000 Cost per $0.14 $0.06 $0.08 $0.09 pound 900 lbs Availability 2800 lbs 350 lbs 2,000 lbs The nutritional specialist also insisted the ration contain at least 25% alfalfa hay. You have set up and solved the dairy farmer's problem using Excel and obtained the following output. The farmer has lots of questions about his ration. Some of them are listed below. (Remember, the farmer has hired you to solve his problem so, be informative and briefl). a. b. c. d. Describe the optimal use of the three grains. How much does the ration cost? An agricultural consultant predicts the price of corn is going to double next year. What do you predict will happen to our optimal solution as a result? A different agricultural consultant predicts the price of Soy will drop by 50% next year. What do you predict will happen to our optimal solution as a result? Your neighbour offer to sell you barley at 10 cents a pound. Your grandfather says you are crazy if you pay more than market price. Should you listen to your grandfather or is it worthwhile to buy some? If so how much? A different neighbour offers to purchase some corn off of you and is willing to pay 8 cents per pound. Should you sell some? If so how much would you sell? What would happen if we required 3100 units of nutrient 4 instead of 3000? What would happen if we required 11500 units of nutrient 3 instead of 10000? What would happen if we required 21000 units of nutrient I instead of 20000? In your opinion what is this solution MOST sensitive to? Show the calculation that explains the values of the coefficients in the minimum hay requirement constraint. e. f. g. h. i. j Question #3, Assignment #7. You have been hired to determine the least cost feed mix feed for a dairy farmer. The farmer purchases alfalfa hay and three types of grain for his total mixed ration (TMR) which he feed to his cows. The hay and grains contain different amounts of four nutritional elements. Together with a nutritional specialist the farmer has developed some requirements for the feed mixture. His objective is to minimize the cost of the mixture while meeting the nutritional requirements. The data is given in the Table below. Units of Nutritional Elements Contained in One Pound of: Nutritional Elements Minimum Number of Units Required Soybeans Corn Barley Alfalfa Hay 1 4 6 8 1 20000 2 5 7000 1 N 0.5 2 3 4 3 0 10000 0.7 0.3 0.8 4 1 3000 Cost per $0.14 $0.06 $0.08 $0.09 pound 900 lbs Availability 2800 lbs 350 lbs 2,000 lbs The nutritional specialist also insisted the ration contain at least 25% alfalfa hay. You have set up and solved the dairy farmer's problem using Excel and obtained the following output. The farmer has lots of questions about his ration. Some of them are listed below. (Remember, the farmer has hired you to solve his problem so, be informative and briefl). a. b. c. d. Describe the optimal use of the three grains. How much does the ration cost? An agricultural consultant predicts the price of corn is going to double next year. What do you predict will happen to our optimal solution as a result? A different agricultural consultant predicts the price of Soy will drop by 50% next year. What do you predict will happen to our optimal solution as a result? Your neighbour offer to sell you barley at 10 cents a pound. Your grandfather says you are crazy if you pay more than market price. Should you listen to your grandfather or is it worthwhile to buy some? If so how much? A different neighbour offers to purchase some corn off of you and is willing to pay 8 cents per pound. Should you sell some? If so how much would you sell? What would happen if we required 3100 units of nutrient 4 instead of 3000? What would happen if we required 11500 units of nutrient 3 instead of 10000? What would happen if we required 21000 units of nutrient I instead of 20000? In your opinion what is this solution MOST sensitive to? Show the calculation that explains the values of the coefficients in the minimum hay requirement constraint. e. f. g. h. i. j