1. Write a linear optimization model (i.e., identify decision variables, objective function and constraints)
2. UseSolver in EXCELto solve the following problems and highlight the optimal solutions in your Excel files.

1. Fertilizing the Lawn. The facilities manager at Oxbridge University 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. There is virtually unlimited supply of each kind of fertilizer.

   Fertilizer	Nitrogen Content (lb)	Phosphorus Content (lb)	Potash Content (lb)	Price ($)
   A	20	10	5	10
   B	10	5	15	8
   C	15	10	5	7

   How much of each fertilizer should be purchased to satisfy the requirements at minimum cost?

please include formula and screenshots of excel