Ethan Steel, Inc. has two factories that manufacture steel components

Question:

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:

What is the optimal (cost minimizing) distribution plan for this transportation problem?

Implement a spreadsheet model and use Excel Solver to obtain a solution to the problem. Submit your Excel Solver file.

Answer:

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.