Be sure to select Keep the Solver Solution and generate an Answer report. Determine: How much of each fertilizer should be purchased to satisfy the requirements at minimum cost? What is the minimum cost?

The facilities manager at Ontario Tech is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table: Mineral Minimum Weight (lb) Nitrogen 12 Phosphorus 14 Potash 18 Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. Nitrogen Phosphorus Potash Fertilizer Content {lb} Content lib) Content llbl Price (S) A 20 10 5 10 B 10 5 15 8 C 15 10 5 7 Using Excel Solver, determine how much of each fertilizer should be purchased to satisfy the requirements at minimum cost. Mike Famous Toys Input Area Processing Time (Hours) and Profit per Toy Delivery Truck Dump Truck Garbage Truck Gasoline Truck Matal Casting 2 2.5 2 2 Paint Spray 1 1.5 2 Packaging 0.5 0.5 1 1 Profit per Toy ($) $0.50 $1.00 $1.50 $2.00 UNKNOWN/DECISION VARIABLES Quantity Produced 0 0 200 800 Constraints Total Time Used Limitations Matal Casting 2000 4000 Paint Spray 1800