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.