Please solve using solver and excel. Please use as much detail when using solver as possible! Thanks!

State Farm Supply has just received an order for 10,000 pounds of chicken feed. The farmer has specified certain that the feed meet minimum requirements for Protein, Carbohydrate, Fat and Vitamins, State Farm can blend four different feeds to produce the required mix. The farmer would like to pay the lowest possible price for the feed. The data for the problem is summarized in the following table. Nutrient Feed 1 Feed 2 Feed 3 Feed 4 Req'd Amt Protein 15% 18% 20% 10% 30% 10% 15% 15% Carbohydrate 20% 12% Fat 20% 30% 15% 20% 20% Vitamin 1% 1.50% 0.50% 1% 0.75% $550 Cost/ 1,000 lbs $500 $600 $600 $550 $450 $450 Formulate the LP for this problem. State Farm Supply has just received an order for 10,000 pounds of chicken feed. The farmer has specified certain that the feed meet minimum requirements for Protein, Carbohydrate, Fat and Vitamins, State Farm can blend four different feeds to produce the required mix. The farmer would like to pay the lowest possible price for the feed. The data for the problem is summarized in the following table. Nutrient Feed 1 Feed 2 Feed 3 Feed 4 Req'd Amt Protein 15% 18% 20% 10% 30% 10% 15% 15% Carbohydrate 20% 12% Fat 20% 30% 15% 20% 20% Vitamin 1% 1.50% 0.50% 1% 0.75% $550 Cost/ 1,000 lbs $500 $600 $600 $550 $450 $450 Formulate the LP for this