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...

Пікірлер: 79

  • @morganbutton6880
    @morganbutton68802 жыл бұрын

    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.

  • @attarjalal805
    @attarjalal8052 жыл бұрын

    The best video I have come across for Solver. Amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback🙏

  • @JUNIOR43950
    @JUNIOR43950 Жыл бұрын

    Great explanation and straight to the point, tysm!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks for your valuable feedback

  • @lampsizgod
    @lampsizgod Жыл бұрын

    Brilliant example. Appreciate that you have shared this.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks🙏

  • @anupama990
    @anupama9902 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks for your valuable feedback

  • @TheZombie2415
    @TheZombie2415 Жыл бұрын

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

  • @alexrosen8762
    @alexrosen87623 жыл бұрын

    Very very useful tutorial! Thanks 😁

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @arjasarkar13
    @arjasarkar133 жыл бұрын

    Too Good. Much appreciated 🙏

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @rahulshewale9206
    @rahulshewale92063 жыл бұрын

    Thank you so much for great tutorial.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @prasadpimpale4698
    @prasadpimpale46983 жыл бұрын

    Really unique and amazing videos.. Thanks for sharing 😊

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @phanindra99biologyvideos
    @phanindra99biologyvideos3 жыл бұрын

    U r like a god... Thank you

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @DigitalSimba
    @DigitalSimba Жыл бұрын

    Thanks for this tutorial!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Most welcome

  • @hlahlakhonziwe2240
    @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

    @PKAnExcelExpert

    Жыл бұрын

    Thanks for your valuable feedback.

  • @iftekharraju318
    @iftekharraju3183 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @438harleenkaur7
    @438harleenkaur78 ай бұрын

    Thank You, Perfect explanation

  • @PKAnExcelExpert

    @PKAnExcelExpert

    8 ай бұрын

    You're welcome!

  • @ireneogcanete5492
    @ireneogcanete54923 жыл бұрын

    wow!!! many thanks!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @chukwuebukaobetta6326
    @chukwuebukaobetta6326 Жыл бұрын

    Thanks very much for this video. It is very helpful

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Glad it was helpful!

  • @RajatKumar-ww1te
    @RajatKumar-ww1te Жыл бұрын

    its really helpful. Thanks for sharing the video.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    You are most welcome

  • @bashirmoustafa6116
    @bashirmoustafa61163 жыл бұрын

    Amazing,,, thanks 👍

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @nicolo.pistis
    @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

  • @achmadzaed6401
    @achmadzaed64013 жыл бұрын

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

  • @VijayRamaraju-uu7mo
    @VijayRamaraju-uu7mo9 ай бұрын

    Most helpful video, thank you sir

  • @PKAnExcelExpert

    @PKAnExcelExpert

    9 ай бұрын

    Most welcome

  • @shyjumathew07
    @shyjumathew07 Жыл бұрын

    Excellent, your topics are very useful, appreciate

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Glad you like them!

  • @shyjumathew07

    @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...

  • @korikalam
    @korikalam Жыл бұрын

    Very useful, thanks

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Most welcome🙏

  • @abdofeduconsult
    @abdofeduconsult2 жыл бұрын

    Thanks . This video is helpful

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Glad it was helpful!

  • @kyototower1173
    @kyototower1173 Жыл бұрын

    you legend

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks

  • @kalyanbasak5344
    @kalyanbasak53443 жыл бұрын

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

  • @josip.harasic

    @josip.harasic

    3 жыл бұрын

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

  • @josip.harasic

    @josip.harasic

    3 жыл бұрын

    kzread.info/dash/bejne/eIyVuJalk87PntI.html

  • @aymanazab8864
    @aymanazab88643 жыл бұрын

    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

  • @chinesecultureinessence1534
    @chinesecultureinessence15346 ай бұрын

    great simple video nice thanks

  • @PKAnExcelExpert

    @PKAnExcelExpert

    6 ай бұрын

    Most welcome

  • @KhalilAhmad74036
    @KhalilAhmad740363 жыл бұрын

    amazing Sir!

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @mhknowledgeacademy6420
    @mhknowledgeacademy6420 Жыл бұрын

    Well explained.

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks

  • @bradtavares-vd3hz
    @bradtavares-vd3hz9 ай бұрын

    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?

  • @jaypalsuitspvtltd9320
    @jaypalsuitspvtltd93203 жыл бұрын

    Very good...

  • @PKAnExcelExpert

    @PKAnExcelExpert

    3 жыл бұрын

    Thanks for your valuable feedback

  • @dataguy3553
    @dataguy3553 Жыл бұрын

    Amazing

  • @PKAnExcelExpert

    @PKAnExcelExpert

    Жыл бұрын

    Thanks🙏

  • @tranngocbaotran9389
    @tranngocbaotran93892 жыл бұрын

    Could you solve it by QM for windows?

  • @shivraj2bn
    @shivraj2bn2 жыл бұрын

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

  • @pritikulkarni1197
    @pritikulkarni11977 ай бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    7 ай бұрын

    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.

  • @finansowyexcel1966
    @finansowyexcel19662 жыл бұрын

    brilliant movie

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Thanks

  • @ikpemosiumezurike9679
    @ikpemosiumezurike96792 жыл бұрын

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

  • @PKAnExcelExpert

    @PKAnExcelExpert

    2 жыл бұрын

    Have explained in the video. Please complete video

  • @omkarkelshikar7484
    @omkarkelshikar74842 жыл бұрын

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

  • @by7991
    @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

    @PKAnExcelExpert

    Жыл бұрын

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

  • @by7991

    @by7991

    Жыл бұрын

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

  • @avinayakchoudhary4172
    @avinayakchoudhary41723 жыл бұрын

    Can you teach in hindi also