please solve this using solver in excel and share

3. (10 points) Miramichi 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. Miramichi 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. Miramichi Farm Supply Percent of Nutrient in: Minimum Nutrient Feed 1 Feed 2 Feed 3 Feed 4 Req'd Amt 15 20 15 18 Protein Carbohydrate Fat 30 10 20 10 15 12 20 15 20 20 Vitamin 30 1.50 1 0.75 0.50 1 Cost/1,000 lbs $500 $600 $550 $450 Formulate and solve the LP with Solver 10