8 C c D E F G H K M N R Oat Corn A cattle needs at least 4000 calories, 10000 units of minerals and 5000 units of vitamins per day. It can be fed with either oat or corn. The nutrient and cost for each pound of oat and porn is giveni alongside. The objective here is to minimize the cost to feed the cattle Use solver to answer the following 5 questions and make sure that you have included the sensitivity report generated by Excel. Please write few lines of explanation for each of your answers 100 200 200 $1.25 100 400 100 $0.75 Nutrient Consumed Minimum Required 4000 10000 5000 A 1 Feeding Cattle 2 3 pounds to feed 4 5 6 7 Calories/pound & Mineral units/pound 9 Vitamin units/pound 70 Cost/pound 11 12 Total Consumed 73 Calories 14 Mineral 15 Vitamin 16 17 Total Cost objective 18 19 20 21 22 23 24 25 26 27 29 29 30 21 32 1) Determine how many pounds of oat and corn should be fed to minimize cost, yet satisfy the minimum nutrient requirements. 2) What is the minimum cost required to feed the cattle while satisfying all the constraints? 3) Will your optimal solution (pounds of oat and com to feed) change if the cost of oat increases to 3 $1.6 per pound? Why 4) Find the range of cost per pound for com within which your optimal solution will not change. 5) How will the total cost change if the minimum required units of vitamins was sodo units per day