Question: please show step by step how to get solution in excel , as many details as possible A company manufactures a product at its plants

please show step by step how to get solution in excel , as many details as possible please show step by step how to get solution in
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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!