Basic Excel Business Analytics #60: Excel Solver: Minimize Transportation Costs, Integer Variable
HTML-код
- Опубликовано: 29 сен 2024
- Download files: people.highlin...
Learn:
1) (00:11) Intro to Transportation Problem and Network Graph
2) (02:08) Set up Decision Variables and Formula Inputs
3) (04:56) Set up Constraint Functions
4) (06:48) Set up Objective Function
5) (09:48) Use Excel Solver to find Minimize Shipping Costs
Download Excel File Not: After clicking on link, Use Ctrl + F (Find) and search for “Highline BI 348 Class” or for the file name as seen at the beginning of the video.
I don't understand why professors can't teach the way you do. Great job, thank you. This was extremely helpful.
You are welcome! Thanks for your support with your comment, Thumbs Up and Sub : )
Wow, I've never noticed that' Cell reference' and 'Constraint' field support ranges! So cool!
+pmsocho , Yes!!! It makes it easier...
This is exactly the info I was looking for . Thank you
Glad this helps!!!
Great video as always. Thank you!
You are welcome!
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.
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 : )
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.
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
Glad it helps!
This is the best explanation I have ever seen. You're an incredible communicator. Thanks.
You are welcome! Thanks for the kind words! Thanks for the support with your comment, Thumbs Up an Sub : )
Great video! Question: What do you do if you need a dummy destination? (Supply > Demand) How would you incorporate that into the problem?
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!
This was so entertaining to watch and really well done. Thanks a lot
You are welcome a lot!
Thanks 🙏
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!
Yes!!!!!! #60 is so much fun : )
Extremely well explained. Thanks for a straightforward tutorial. New subscriber
You are welcome, Angelo!!!
Thank you! I don't know why I have such a problem using solver, but this really helped!!!
I post so the vids can help! Thanks for your support with your comment, thumbs up and your Sub : )
Thank you thank you thank you Best explanation I ve seen so far . Clear concise and straight to the point .
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 : )
This is so well taught.... Thanks heaps... u have a gift and u r passionate about it....
Glad it helps!
what if we have also a number of different vehicles?
You can have different number of vehicles. These are just unit costs in transporting goods from production factories to distribution centers.
Nicely Explained. Superb!!
Glad it was superb for you, Parthy!!! Thanks for your support with your comment, thumbs up and your Sub : )
Always awesome...
Great job
I'm impressed sir thank u
Glad it helps you!!!
Speechless that was awesome
Glad that it helps!
I wanted to learn from the besic how??
Basic what? Excel, Statistics?
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.
Please help support this free content at excelisfun by clicking that Thumbs Up and leaving comments and subscribing : )
ExcelIsFun talking about statistics
great, thanks