top of page
I made transportation model on excel. In this example, I worked with a scenario where there are 3 quarries and 5 warehouses:
-
Each warehouse has certain requirement of raw material to be transported each week. There are also capacity constraints for each quarry.
-
There is a matrix at top which maps how much it costs to transport one ton of limestone from one designated quarry to a designated warehouse.
-
Aim of this model is to design the weekly transportation schedule of warehouses which would minimize the overall cost.
bottom of page