Ethan Steel, Inc. has two factories that manufacture steel components for four different rail projects located at four different sites. The demand for the steel components for the four projects, Project A, Project B, Project C, and Project D, are 3220, 3675, 4125, and 2975, respectively. The shipping details are as below: Production details:
Factory Maximum capacity
1 2000
2 5000
Shipping details:
Project
Factory A B
1 7 8
2 6 5
1.What is the optimal (cost minimizing) distribution plan for this transportation problem?
2. Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem.