Transport Cost Optimization Using Solver in Excel

#SolverAddin #CostOptimization
Hello Friends,

In this video, You will learn how to use Solver Tool in Excel to solve the Magic Squire Puzzle and to Optimize the Transport Cost in Logistic use case.

Download the practice files from below given link:

Download the Free Project Management Dashboard

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Pinterest:

Visit our Amazon Store

[morganbutton]

This was most helpful when it came to setting up my tables. The magic square puzzle plus your problem set up simplifies how to set up basically any problem in clean and functional tables.

[attarjalal]

The best video I have come across for Solver.
Amazing

[hlahlakhonziwe]

Yoho, I don't know what I can say but u really make genious, this so clear, u my lecture. This was super helpful; I'll go and share this information.

[lampsizgod]

Brilliant example. Appreciate that you have shared this.

[JUNIOR]

Great explanation and straight to the point, tysm!

[chukwuebukaobetta]

Thanks very much for this video. It is very helpful

[anupama]

Brilliant explanation. Crisp and to the point, cleared all my doubts.

[TheZombie]

This is some advanced stuff lol.
It wouldn't get used much by me but it still as hell amazing

[shyjumathew]

Excellent, your topics are very useful, appreciate

[RajatKumar-wwte]

its really helpful. Thanks for sharing the video.

[iftekharraju]

Excellent sir..i learned lot from you.. Thanks

[prasadpimpale]

Really unique and amazing videos..
Thanks for sharing 😊

[kalyanbasak]

Wonderful tutorial....never knew how to use it....now I can...thanks PK. Can you please teach what if analysis as well?

[imannaji]

thank you for the explanation, but I think we need to select the simplex LP method not GRG Nonlinear

[pritikulkarni]

Thanks PK.. Bless You.. Just give us excel example sheet..

[achmadzaed]

Hi Pk,
Many thanks for your support if you could fix the problem for the download link that you share 🙏

[bradtavares-vdhz]

1 question, does the solver require adding enough constraints that it can only provide only 1 unique solution? or could it also solve problems where there are few constraints, but there could be many possible solutions?

[aymanazab]

Thanks very much
Can you design user form to enter transactions of daily journal and a button to print this transaction and a button to post this transaction to appear to general ledger and other financial statements

[by]

Hi thanks for the update i need to solve problem like this from plant to wherehouse (distance is 60) freight is rs 700 where as direct orders with in distance slab is higher and lower .. how can find and I optimize

[ikpemosiumezurike]

Please how did you create the magic square, like did you draw it on Excel. The rows and columns also