This video demonstrates how to format a Microsoft Excel spreadsheet for a model of a linear programming transportation problem.
Пікірлер: 73
@drcknight24plays Жыл бұрын
You get so much love from people because you solved the easiest problem that Excel Solver can possibly solve ?????
@pattycakeadventures7 жыл бұрын
Dr. Harrod, thank you so, so much for this. I have been trying to figure out a warehouse capacity problem for my MBA for the past 5 days and no tutorial has been as good as this. My gratefulness cannot be over expressed. I will now drink a toast to you. May all good things happen to you forever.
@rahulhans16 жыл бұрын
HI Patrice can you please share the problem you encountered on warehousing
@MrOlbbj59 жыл бұрын
This is 2015 and still the best video on transportation model. Thank you.
@miitomm5 жыл бұрын
BethelMedia cvvvbef cfrc13q4x4.444
@miitomm5 жыл бұрын
The first thing Can you help me rescue these trapped birds in Gummy Pop? gummypop.madovergames.com pic.fashionmia.com/catalog/products//medium/images/D86AC310A38A/3049816_3.jpg 3049816_3.jpg
@softwerksaol Жыл бұрын
Thank you so much. I never became a KZbin star or tried to monetize these videos, but it really makes me feel great to know that so many have benefited from this set of videos I uploaded fifteen years ago.
@rivercats108 жыл бұрын
Thank you so much for your video. I am trying to solve a problem for an online class that I am taking with little to no help from the professor. You made this very clear and easy to understand!
@SohailKhan-rw2gb8 жыл бұрын
WOOW , , This is a very good video because it contain three main topics. LINEAR PROGRAMMING , TRANSPORTATION and learning them through the excel.Also we can learn the relation of the LINEAR PROGRAMMING with TRANSPORTAION MODELING. Thank you sir
@jareau9 жыл бұрын
Well, I figured I'd thank you. 3 plus years later, and this is still relevant, and useful.
@TSFerlitto10 жыл бұрын
This was one of the best educational videos for 'how to' I have seen on here, thank you Mr. Harrod, that was excellent and helped me tremendously.
@cocoe2811 жыл бұрын
i love you i've got an exam tomorrow and had no idea how to do this
@thucdo18742 жыл бұрын
The video sound is pretty good, beyond my imagination
@richuxerxez6 жыл бұрын
Thanks you Steven, this is 2018. I was trying to solve warehouse optimisation problem, this helped me a lot. clear and objective explanation from zero level.
@ihbarddx6 жыл бұрын
Nice video. Must remark, however, that it is inadmissible to assign fractional students, so we would normally have to specify that all our decision variable values be integer. It is a property of transportation problems that minimum objective function values can be achieved (under broad constraints) with integer allocations - although it is sometimes the case that the same minimum value may also be achieved with fractional allocations. The Simplex method, used by Excel, finds the integer allocations.
@dkwteacher7 жыл бұрын
Many thanks! Well worth the time putting in watching - clear and objective explanation that just may help my wife get her degree (failed this once already)
@hafeitzonn2365 жыл бұрын
Its 2018 and your video is a huge help for me, thank you so much
@sherryb.c.19079 жыл бұрын
This video was AMAZINGLY HELPFUL. Will be sharing with classmates!
@zakkaya807510 жыл бұрын
Explains simply but effective:)
@marieg19424 жыл бұрын
Thank you this is so much helpful
@samueltobing868310 жыл бұрын
the world is brighter for me now! thankss..
@vrushaliaher54423 жыл бұрын
U just saved me!!! Thank u
@jayaramaprasad87845 жыл бұрын
Where did you define 'decisions'- (time stamp 5:45 approx)?
@mattiaricci15247 жыл бұрын
Very enjoyable and helpful tutorial. Thanks for your job.
@xtremes50311 жыл бұрын
thanks to teach us to solve the problem & to use the excel
@danielsmith34429 жыл бұрын
This was very insightful and enlightening. Thanks for posting.
@Zyhngvnc5 жыл бұрын
Thank you Steven, very usefull for my students
@danieladominguez-garcia72598 жыл бұрын
Thank you! This video was extremely helpful.
@fxhdhfth8 жыл бұрын
love you man i needed this problem solved for a final project
@giovannahurtado30415 жыл бұрын
Love it... hats off
@mnomanaziz11 жыл бұрын
Thank you so much for this useful video. really appreciate it. Do you have a video that distributes traffic to different area?
@6386est8 жыл бұрын
thanks for the video! finally there is an easy way to understand ;)
@tanmay0944 жыл бұрын
Hii Steven. It was a very informative explanation. Can you please tell me how to add constraints where solutions are not equal to zero??
@Savage09008 жыл бұрын
This video was of great assistance to me....so grateful =).
@demelashteshome32458 жыл бұрын
It's very helpful. I appreciate
@pacharinthaweekoon266011 жыл бұрын
Hi, thanks for sharing! but I wonder if we had variables in both sides how to solve them then? For example: x1 ≥ xs+xk+xn+xr ( x is quantities of product) and another one is xs+xk+xn+xr ≤ 1,080 y1(and Y is binary only 1 or 0) pls let me know how to solve the problem like this. thanks for your kindness!
@mirandarose55656 жыл бұрын
Thank you SO much for this video. It was incredibly helpful!!!
@sparkeyluv4 жыл бұрын
Does anyone know where this linear equation was first formulated and by who?
@jeremypotts61084 жыл бұрын
Thank you! Very helpful!
@sinharme10 жыл бұрын
Simple and effective!!
@MzTeeL11 жыл бұрын
I had to sign in and tell you that you are awesome. Thank you so much for this video!
@MegaPowerslide8 жыл бұрын
Awesome video, really helped me out, Thanks!
@soninikhil0810 жыл бұрын
thank you sir...... this vedeo was very helpfull in doing a similar kind assignment project!
@FrancescaTabor86 жыл бұрын
Hi Steven! How are you? I hope you are doing well. I am not sure if you can help me. I was wondering whether you would be free for a 1-2hrs consultation sometime soon, as I am trying to model a linear programming transportation problem for my business concept. The idea is to offer grocery deliveries from small shops, as opposed to supermarkets and warehouses. The benefit of delivery from small shops is that they are often closer to customers. However on the downside, you would need a courier in the area, and to pick up from multiple shops (as small shops don't have as much assortment). Thank you so much for taking a look at this. I can send you some more information over by email. All the best, F x
@sbh7149 жыл бұрын
Thank you so much, you're a real lifesaver!
@danielnyakundi98799 жыл бұрын
This is worth subscribing! I appreciate a lot. Thanks.
@mrbusdriversir10 жыл бұрын
Very nice. Thanks for the video, it helped a lot.
@Ghostrunner557 жыл бұрын
can i use this to calculate shortest distance in bus routes
@priyankasingh410 Жыл бұрын
Some constraints u too less than equal n some as equals why??
@Patrick-vu2gs4 жыл бұрын
Thank you
@stbi15348 жыл бұрын
Very helpful! Thanks for the video :)
@irroshnal8 жыл бұрын
Thank you. Good, detailed video. Very helpful :)
@MrSayan945 жыл бұрын
There should be one for supply and demand forecasting and Mixed Linear Programing
@bastienclarke18105 жыл бұрын
Thanks
@nickolasyakus58292 жыл бұрын
Thanks.Please , can you help me . Can you send me this ready solution on my postbox??
@rogzcorpuz8 жыл бұрын
Thanks a lot for this video.
@FarhodTuraev11 жыл бұрын
thanks a lot. I need it to solve using AMPL. Is it possible?
@obiorannene287610 жыл бұрын
Nice video, keep it up. Thanks
@Candysmakeover7 жыл бұрын
thank you sir, this was of great help
@isaacali99326 жыл бұрын
You're the best thanx a lot
@charmainnecheniecortez82449 жыл бұрын
is linear transportation problem and transportation model the same?
@jjsan2710 жыл бұрын
very clear. thanks.
@oxdhaoxt36949 жыл бұрын
Great Video
@feriel51410 жыл бұрын
thank you !
@MrAMerang9 жыл бұрын
needless to thank me for watching..just THANK YOU for sharing
@jessechen49717 жыл бұрын
Lol the first thing i think of when you said "walkers" is zombies