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

[@glscott3535]

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.

[@TallysYunes]

You are welcome! Glad to hear it was helpful.

[@KyuubiSam]

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

[@TallysYunes]

Haha! You’re too kind! Glad the video was helpful.

[@KyuubiSam]

@@TallysYunes I ended up getting full marks on my assignment! I really appreciate you :) :)

[@TallysYunes]

That's great to hear! Congratulations!

[@apasajaada23]

Thank you, the knowledge is very useful

[@joseluiscuervolopez-mora1814]

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?

[@TallysYunes]

This rectangle layout can be a bit wasteful if there are a lot of arcs/arrows that don't exist in the problem. In your case, if it's not true that all 30 supply nodes can ship to all 30 demand nodes, then you may have fewer than 30x30 = 900 variables (gray cells). If that's the case, if you switch to a different layout, like the one I explain in the transshipment video, it can work (see here: kzbin.info/www/bejne/in2kiomddtRrqaM). However, if you do indeed have more than 200 shipment routes (i.e. arcs in the drawing of your network), then your best bet is to switch to a different solver add-in that has no size limitation. This add-in works very similarly to the default solver add-in in the way you add variables, constraints, etc. You can download it for free from the site below. There is also a page with installation instructions: opensolver.org/

[@joseluiscuervolopez-mora1814]

@@TallysYunes will try it, thanks for taking the time to answer this. My logistic task is to make reallocations among 30 distribution stocks to supply for daily demands, so any flow goes

[@TallysYunes]

Then I'd go with OpenSolver.

[@dawneabdulal-bari9313]

🎉