Linear Programming: Transportation with Excel Solver (Network Flows Part 1)

Enjoyed this content & want to support my channel? You can get the spreadsheet I build in the video or buy me a coffee! Links below:

This is our first and simplest version of a network problem. Given locations that can either be suppliers or consumers of a certain good or product, how to ship the goods from suppliers to consumers in the least expensive way possible. In later videos we will look at variations of this problem known as the assignment and transshipment problems.

[glscott]

Prof, I really like the way you set up the excel. I have been using a different setup with the DV's all in one line. But for these Supply/Demand problems your setup is really eye catching. Thanks for you videos.

[KyuubiSam]

You are an absolute legend and life saver!! Thank you!!!

[apasajaada]

Thank you, the knowledge is very useful

[joseluiscuervolopez-mora]

I am trying to do this with a 30x30 matrix, but solver has a cap of 200 variable cells. Is there any built in function in excel for this problems?