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:
Factory Maximum capacity
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.