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:
www.pk-anexcelexpert.com/tran...
Download the Free Project Management Dashboard
www.pk-anexcelexpert.com/exce...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcelexpert.com/prod...
See our Excel Products:
www.pk-anexcelexpert.com/prod...
Visit to learn more:
Chart and Visualizations: www.pk-anexcelexpert.com/cate...
VBA Course: www.pk-anexcelexpert.com/vba/
Download useful Templates: www.pk-anexcelexpert.com/cate...
Dashboards: www.pk-anexcelexpert.com/exce...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
WWW.PK-AnExcelExpert.com
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/AAAAAE2OnviiEk5...
Pinterest:
/ pkanexcelexpert
Visit our Amazon Store
www.amazon.in/shop/pkanexcele...

[@morganbutton6880]

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.

[@JUNIOR43950]

Great explanation and straight to the point, tysm!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@attarjalal805]

The best video I have come across for Solver.
Amazing

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@lampsizgod]

Brilliant example. Appreciate that you have shared this.

[@PKAnExcelExpert]

Thanks🙏

[@anupama990]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@alexrosen8762]

Very very useful tutorial! Thanks 😁

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@rahulshewale9206]

Thank you so much for great tutorial.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@arjasarkar13]

Too Good. Much appreciated 🙏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@hlahlakhonziwe2240]

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.

[@PKAnExcelExpert]

Thanks for your valuable feedback.

[@chinesecultureinessence1534]

great simple video nice thanks

[@PKAnExcelExpert]

Most welcome

[@prasadpimpale4698]

Really unique and amazing videos..
Thanks for sharing 😊

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@phanindra99biologyvideos]

U r like a god... Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheZombie2415]

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

[@438harleenkaur7]

Thank You, Perfect explanation

[@PKAnExcelExpert]

You're welcome!

[@DigitalSimba]

Thanks for this tutorial!

[@PKAnExcelExpert]

Most welcome

[@chukwuebukaobetta6326]

Thanks very much for this video. It is very helpful

[@PKAnExcelExpert]

Glad it was helpful!

[@iftekharraju318]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ireneogcanete5492]

wow!!! many thanks!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@RajatKumar-ww1te]

its really helpful. Thanks for sharing the video.

[@PKAnExcelExpert]

You are most welcome

[@bashirmoustafa6116]

Amazing,,, thanks 👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@VijayRamaraju-uu7mo]

Most helpful video, thank you sir

[@PKAnExcelExpert]

Most welcome

[@abdofeduconsult]

Thanks . This video is helpful

[@PKAnExcelExpert]

Glad it was helpful!

[@achmadzaed6401]

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

[@shyjumathew07]

Excellent, your topics are very useful, appreciate

[@PKAnExcelExpert]

Glad you like them!

[@shyjumathew07]

@@PKAnExcelExpert Honestly, I learned lots of new items from your channel, most of which I have seen first time through your classes, Thanks PK...

[@nicolo.pistis]

Hello. Thanks for this great video. I wanted to ask you a question: I tried to solve a 4x4 magic square in Excel using Solver using the same procedure, but it does not work. How could it be? Thanks

[@dataguy3553]

Amazing

[@PKAnExcelExpert]

Thanks🙏

[@korikalam]

Very useful, thanks

[@PKAnExcelExpert]

Most welcome🙏

[@aymanazab8864]

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

[@kalyanbasak5344]

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

[@josip.harasic]

Well, the penultimate video, i.e. the video before this one was about that topic ... search.

[@josip.harasic]

czcams.com/video/FXaV4lckino/video.html

[@mhknowledgeacademy6420]

Well explained.

[@PKAnExcelExpert]

Thanks

[@KhalilAhmad74036]

amazing Sir!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pritikulkarni1197]

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

[@PKAnExcelExpert]

In order to access the download link, kindly refer to the description box accompanying the video presentation. Alternatively, please feel free to visit our website at www.PK-AnExcelExpert.com for further information and resources.

[@kyototower1173]

you legend

[@PKAnExcelExpert]

Thanks

[@jaypalsuitspvtltd9320]

Very good...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@finansowyexcel1966]

brilliant movie

[@PKAnExcelExpert]

Thanks

[@tranngocbaotran9389]

Could you solve it by QM for windows?

[@bradtavares-vd3hz]

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?

[@shivraj2bn]

Sir how can I formulate solver to identify qty to be ordered based on lead time

[@ikpemosiumezurike9679]

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

[@PKAnExcelExpert]

Have explained in the video. Please complete video

[@omkarkelshikar7484]

Solver is using bulk employees salary change or not
Please confirm sir

[@by7991]

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

[@PKAnExcelExpert]

You need to create your data accordinlgy with formula. I will try to create another video on this

[@by7991]

@@PKAnExcelExpert thanks ji 🙏 for the reply and waiting for your video subscribed 😊

[@avinayakchoudhary4172]

Can you teach in hindi also