please use excel and solver with steps and formulas applied step wise.

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