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

No video

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

Рет қаралды 10,449

4 жыл бұрын

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:
Buy me a coffee: www.buymeacoff...
Buy complete spreadsheet: www.buymeacoff...
Buy me an item from my wishlist: www.buymeacoff...
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.
Link to transshipment problem video: • Linear Programming: Tr... .

Пікірлер: 12

@glscott3535 3 жыл бұрын

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 3 жыл бұрын

You are welcome! Glad to hear it was helpful.

@KyuubiSam 2 жыл бұрын

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

@TallysYunes 2 жыл бұрын

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

@KyuubiSam 2 жыл бұрын

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

@TallysYunes 2 жыл бұрын

That's great to hear! Congratulations!

@apasajaada23 4 жыл бұрын

Thank you, the knowledge is very useful

@dawneabdulal-bari9313 Жыл бұрын

🎉

@joseluiscuervolopez-mora1814 2 жыл бұрын

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 2 жыл бұрын

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: kzfaq.info/get/bejne/irJxjLmYptWco3U.html). 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 2 жыл бұрын

@@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 2 жыл бұрын

Then I'd go with OpenSolver.