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.

Transportation Model.png