PLEASE SIMPLEX LP TO SOLVE! Please Solve on Excel using Excel solver.

A company buys liquid material for its three manufacturing facilities from several suppliers. - Facility K requires 2,200 gallons of liquid material per month, - Facility L requires 3,500 gallons of liquid material per month, - Facility M requires 2,800 gallons of liquid material per month, The unit purchase cost and supply capacity from each supplier are shown below. Supplier A charges $19.40 per gallon and can supply up to 3,500 gallons per month, Supplier B charges $18.65 per gallon and can supply up to 4,200 gallons per month, Supplier C charges $17.45 per gallon and can supply up to 3,900 gallons per month, Supplier D charges $19.03 per gallon and can supply up to 4,500 gallons per month, Supplier E charges $19.71 per gallon and can supply up to 3,100 gallons per month, The company must also pay the shipping costs of the liquid. The shipping costs per gallon ($/gal) from suppliers to manufacturing facilities are shown below. - from supplier A to facility K, L, and M are 2.72, 2.67, and 2.29 dollars per gallon, respectively, - from supplier B to facility K, L, and M are 3.96, 4.20, and 3.56 dollars per gallon, respectively, - from supplier C to facility K, L, and Mare 3.51, 3.75, and 2.53 dollars per gallon, respectively, - from supplier D to facility K, L, and Mare 3.08, 3.51, and 1.85 dollars per gallon, respectively, - from supplier E to facility K, L, and M are 3.77, 3.45, and 3.19 dollars per gallon, respectively, The company would like to select suppliers that will minimize its total purchase and shipping costs. You must show the optimal solution and SOLVER setup on Excel spreadsheets. The optimal solution suggests: [1] The total monthly purchasing and transportation cost is dollars. [2] The company should purchase gallons per month from supplier A. [3] The company should purchase gallons per month from supplier B. [4] The company should purchase gallons per month from supplier C. [5] The company should purchase gallons per month from supplier D. [6] The company should purchase gallons per month from supplier E. You must type your final answer on the given space below and label your answer clearly