Please, could you explain to me how to solve the attached question using SOLVER (Simplex method - Linear Programming) in EXCEL?

Thanks.

Attached: Question and file mentioned in the question (Ch 6_88 from Practical Management Science 5th Ed)

88.. Based on Angel et a1. (2003}. A fertilizer company}.r is trying to determine the cheapest fertilizer mix that provides desired amounts of nutrients. The mitt is made by combining the following fertilisers: SSA, SPO, GUR, TSP, KCI, FEET, and SPF. The mix can not contain both GUR and TSP. The percentage of potassium (K), sulfur {3), calcium (Ca), sodium (Na) and phosphorus (P) in each fertiliser is listed in the file Pll_38.rtlsit. For example, a pound of SSA is 16% K and 26% Na. The this must contain at least dill] pounds of K, 550 pounds of S, 750 pounds of Ca, QUIZ} pounds of Na, and 750 pounds of P. The mis cannot contain both GUR and TSP, because if both are present in the mix, the affect of other fertilisers is nullied. The cost per pound (in cents) of each fertiliser is listed in the same le. Doselop a linear integer model to find the minimum-cost fertiliser mixture that meets the stated chemical requirements. Fertilizer problem Percentages of chemicals (along top) in fertilizers (along side) K S Ca Na P SSA 16% 0% 0% 26% 0% SPO 15% 0% 0% 18% 0% GUR 0% 40% 0% 0% 20% TSP 0% 46% 20% 5% 0% KCI 60% 0% 0% 0% 0% FERT 0% 0% 33% 0% 0% SPF 0% 0% 0% 0% 20% Cost per pound of fertilizers (cents) SSA 25 SPO 35 GUR 45 TSP 35 KCI 50 FERT 43 SPF 30