please show step by step how to get solution in excel , as many details as possible

A company manufactures a product at its plants in C and D; then ships the product to its four distribution centers in KL. M. and N The transportation costs per unit (in dollars per unit) are as follows: from C to K, L, M, and N: 7.5, 9, and 11. from D to K, L, M, and N: 9.4. 11. and 8. The monthly demand from K, L, M, and N are: 5500, 1400, 3100, and 5100 units, respectively On the other hand, the monthly capacity at plants C and D are: 5000 and 11000 units. respectively Develop a linear programming model that can be used to determine the distribution plan that will minimize total monthly transportation cost. Use Excel Solver to find the optimal solution The optimal solution shows that Plant D send units per month