Use Excel Solver Only. No Paperwork. make model on excel step wise to understand with formulas

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 Feed 4 Feed 3 30 10 15 Reqld Amt 18 12 15 Nutrient Protein Carbohydrate Fat Vitamin Cost/1.000 lbs Feed 1 15 20 20 1 $500 Feed 2 20 10 30 1.50 5600 15 20 20 1 0.75 $550 0.50 $450 Formulate and solve the LP with Solver