Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable

Поделиться
HTML-код
  • Опубликовано: 4 ноя 2024

Комментарии • 48

  • @damianh5451
    @damianh5451 7 лет назад +14

    I don't understand why professors can't teach the way you do. Great job, thank you. This was extremely helpful.

    • @excelisfun
      @excelisfun  7 лет назад +2

      You are welcome! Thanks for your support with your comment, Thumbs Up and Sub : )

  • @GeertDelmulle
    @GeertDelmulle 4 года назад

    This is the video -back in the day- that did it for me: this is the Excel-channel for me.
    Looking back at it now I feel a little blasé, having watched so many good videos on this channel by now.
    But I still remember the feeling: when you realize that your Excel knowledge is still stuck in the previous millennium!...
    And then you watch and learn a ton from ExcelisFun! :-)
    For ever grateful!

    • @excelisfun
      @excelisfun  4 года назад +1

      Yes!!!!!! #60 is so much fun : )

  • @vincinsplays
    @vincinsplays 2 года назад +1

    Man you don't know how thankful I am for this explanation here, I haven't been motivated to do any kinda school work in 2021 for some reason but you just saved my ass from failure

  • @pmsocho
    @pmsocho 9 лет назад +5

    Wow, I've never noticed that' Cell reference' and 'Constraint' field support ranges! So cool!

    • @excelisfun
      @excelisfun  9 лет назад

      +pmsocho , Yes!!! It makes it easier...

  • @dimphomokasinyane9003
    @dimphomokasinyane9003 2 года назад +1

    This is exactly the info I was looking for . Thank you

  • @joshmo24
    @joshmo24 6 лет назад +1

    This is the best explanation I have ever seen. You're an incredible communicator. Thanks.

    • @excelisfun
      @excelisfun  6 лет назад

      You are welcome! Thanks for the kind words! Thanks for the support with your comment, Thumbs Up an Sub : )

  • @bamakaze
    @bamakaze 2 года назад +1

    Excellent transportation video, Mike! I hope everything is ok with you your family. Haven't seen a new video in two weeks. Take care bud.

    • @excelisfun
      @excelisfun  2 года назад +1

      Yes, this is a fun one : ) I have had very bad health for a few weeks. I posted a comment in the Community tab at my channel. But I will boomerang back soon enough : )

  • @faloua1
    @faloua1 5 лет назад

    Thank you thank you thank you Best explanation I ve seen so far . Clear concise and straight to the point .

    • @excelisfun
      @excelisfun  5 лет назад

      You are welcome!!! Plus when you do it in Excel, even if it is clear and concise, it makes it MUCH more fun!!!!! Thanks for your support with your comment, Thumbs Up and Sub : )

  • @timmybone13
    @timmybone13 2 года назад +1

    Great video as always. Thank you!

  • @angelospano7419
    @angelospano7419 4 года назад

    Extremely well explained. Thanks for a straightforward tutorial. New subscriber

    • @excelisfun
      @excelisfun  4 года назад

      You are welcome, Angelo!!!

  • @hypeclothingreviews6690
    @hypeclothingreviews6690 3 года назад

    Great video! Question: What do you do if you need a dummy destination? (Supply > Demand) How would you incorporate that into the problem?

  • @gayleotherson
    @gayleotherson 5 лет назад

    Thank you! I don't know why I have such a problem using solver, but this really helped!!!

    • @excelisfun
      @excelisfun  5 лет назад

      I post so the vids can help! Thanks for your support with your comment, thumbs up and your Sub : )

  • @vram11
    @vram11 8 лет назад

    This is so well taught.... Thanks heaps... u have a gift and u r passionate about it....

  • @aaronmelian2570
    @aaronmelian2570 7 лет назад +1

    This was so entertaining to watch and really well done. Thanks a lot

  • @benr6548
    @benr6548 5 лет назад

    Wow man, great work. I've been hunting for a person with your level of understanding on this topic haha. If you are up for a bit of 1 on 1 tutoring on this subject, I could really use your help. Let me know if you're interested and what you're rate is. An hour of your expertise would go a long way to helping me understand my operations management exercises. My Transportation problem involves Linking Constraints, which I would love to see a video about if you already have one! Let me know! Thanks again!

  • @DiogoReis2201
    @DiogoReis2201 4 года назад

    Great job

  • @boldcautionproductions9203
    @boldcautionproductions9203 4 года назад

    Always awesome...

  • @parthy7563
    @parthy7563 5 лет назад

    Nicely Explained. Superb!!

    • @excelisfun
      @excelisfun  5 лет назад

      Glad it was superb for you, Parthy!!! Thanks for your support with your comment, thumbs up and your Sub : )

  • @greglouis5779
    @greglouis5779 2 года назад

    I hope you are doing well. I am a Computer science student and I have the task of doing a project which is route cost optimization whereby a country which is importing goods by shipping from its partners, the factors like terrorism index of the export country, the port index of the export country, unit cost of the product must, the distance between the two countries as well must be considered to know from the list of partners which one is better for the importing country to import goods from, and for that I have to use a Machine learning algorithm. Since you are good at python and you have a deep knowledge of Machine learning and Data Science that I greatly appreciate, I want to know if you can help me with that please. I would be very grateful dear. I hope to hear from you very soon.

  • @Clifffffffffford
    @Clifffffffffford 3 года назад

    Thanks 🙏

  • @gautamkhanna3743
    @gautamkhanna3743 6 лет назад

    Speechless that was awesome

  • @ismailismaili0071
    @ismailismaili0071 7 лет назад

    I'm impressed sir thank u

  • @anelakrstic9008
    @anelakrstic9008 5 лет назад

    what if we have also a number of different vehicles?

    • @markosiridzanski2181
      @markosiridzanski2181 4 года назад

      You can have different number of vehicles. These are just unit costs in transporting goods from production factories to distribution centers.

  • @syednabeel1091
    @syednabeel1091 6 лет назад

    I wanted to learn from the besic how??

    • @excelisfun
      @excelisfun  6 лет назад +1

      Basic what? Excel, Statistics?

    • @excelisfun
      @excelisfun  6 лет назад

      Here is Excel Basics class: ruclips.net/p/PLrRPvpgDmw0n34OMHeS94epMaX_Y8Tu1k
      Adavnced Excel class: ruclips.net/p/PLrRPvpgDmw0lcTfXZV1AYEkeslJJcWNKw
      Statistics class: ruclips.net/p/PLrRPvpgDmw0ngx_uPhvasTbOWLOztsaBj
      All three classes are prerequisites for this Analytics Class.

    • @excelisfun
      @excelisfun  6 лет назад

      Please help support this free content at excelisfun by clicking that Thumbs Up and leaving comments and subscribing : )

    • @syednabeel1091
      @syednabeel1091 6 лет назад

      ExcelIsFun talking about statistics