top of page
Transportation Model
I made a transportation model using Excel for minimizing the costs of shipping goods from factories to warehouses and customers, while not exceeding the supply available from each factory.
-
Each warehouse has different requirements to be met by the factories having fixed production capacity with minimum transportation cost
-
The first table shows the requirements of each warehouse, the production capacity of each factory & transportation costs to transport from every factory to every warehouse
-
The succeeding table is about the weekly transportation schedule of which factory to fulfill the requirements of which warehouses to have minimum transportation cost
Transportation Model
bottom of page