An easy video to learn using Microsoft Excel Solver for Linear Programming
Пікірлер: 239
@airsofter229 жыл бұрын
This 5 minute video just taught me more than my professor could in 40 minutes! Just save me, thanks!
@piyushashah19 жыл бұрын
Thanks for the comment Soldier. In the classroom we sometimes focus on the detailed understanding of the concept and the logic of the method. Here I have been functional. So if you link this to what your professor was teaching, maybe you will see more sense in his methods.
@kodomochan325 жыл бұрын
Very true!
@loveforpunjab3 жыл бұрын
@@piyushashah1 hello can you teach me
@jjkhris3 ай бұрын
Thank you so much for this video. 11 years later and it perfectly covers the content covered in my 300 level college course. I'm approaching finals, and I appreciate the conciseness and simplicity of your explanations.
@shrujanamsyama99404 жыл бұрын
Excellent tutorial. Crisp and to the point. Did not waste even a single second and every second had useful content.
@soham94968 ай бұрын
Thank you sir , revising this before my business maths practical
@vijayjangir702110 жыл бұрын
It is precise at the point, no confusion, no any thing hard, even it very use full those who think LP can not learn. it is so easy to learn LP with SOLVER.
@MrCLOWNBUNNY6 жыл бұрын
this legit taught me more than my lecturers did in a week. It took me 2 hrs looking through slides and notes and cannot find whats going on. but this 5min video made me understood everything. thank you so much!!!
@danklebanov75907 жыл бұрын
Attention all producers of youtube video tutorials. THIS is how it should be done. Short and effective. Very nice work, my friend. Thank you!
@piyushashah17 жыл бұрын
Thank you for this wonderful comment. Do have a look at the other videos in this series as well.
@aquacyanide4 ай бұрын
After 2 weeks of being lost on this topic, you taught me how to do it in 10 minutes. Thank you!
@dhananjaybomidi71844 жыл бұрын
This just felt like a blessed video. Entire complication summarized beautifully in one video. Very smooth, clear and wonderfully explained!!
@jinomaster8 жыл бұрын
Very useful video. Straight to the point, with all the emphasis being directed toward the subject matter. Professionally done and much appreciated.
@armysutherland81368 жыл бұрын
I have spend hours trying to find a simple easy to understand solver video. Thank you very much because this is one of the best videos I have found. It took me only 5 mins to solve a problem .
@vonneumannoperator5668 жыл бұрын
Best tutorial on excel solver with LP problems there is!
@piyushashah18 жыл бұрын
+VonNeumannOperator Thanks a lot for leaving the comment.
@yibeyibe3893 жыл бұрын
A nice explanation than any video I have seen.
@piyushashah111 жыл бұрын
Thanks Raju. The appreciation, and the fact that you propose to use it in your class makes all the effort worth it. As of now, I have not put any examples for project situations and will do so in the future. Please do check the other videos also - especially the one on Assignment and Production Planning, they might be of use.
@saffarinow16 жыл бұрын
Very useful video! I attended a lecture on this and although I found it useful and interesting, I didn't actually grasp how to do it. I can now use solver with ease!! Thanks
@piyushashah16 жыл бұрын
Thanks for leaving the comment. Did you check my other solver videos? Have a look, they might just make using solver even more easier.
@ntinakitsou82707 жыл бұрын
I have A.D.D. and as a dyslectic i met great difficulties in everything about Solver - the university book, youtube videos, excel help...that, till i saw this video and not only solved the problem right away but also i understood the methodology. I have to thank you. You must be one fine Professor.
@piyushashah17 жыл бұрын
Thank you very much Ntina for leaving this message. I am glad the video could help you. Now with problems related to solver out of the way, Operations Research should be much more fun.
@josephdouglas52427 жыл бұрын
When I saw that the video was only 5 minutes long, I thought that I had probably googled the wrong name for my problem. Turns out this isn't nearly as complicated as I thought after my buffoon of a teacher tried to explain it. Thanks so much!
@ujamokahmadu2 жыл бұрын
This video really helped my understanding of formulation of linear problems. Thank you for the knowledge!
@piyushashah12 жыл бұрын
Thanks for the comment. I'm happy that the video was helpful for you.
@FPrimeHD16188 жыл бұрын
Absolutely great video. It's nice having a simple way to check my answers in Linear Programming.
@piyushashah111 жыл бұрын
HI Lakshit, thanks for the feedback. Happy that the video helped you. Do have a look at the other videos as well
@FallenZero939 жыл бұрын
With this simple video you just made me completely understand this part. Thank you very much!
@ryankimble226510 жыл бұрын
Thank you for sharing this video. It was helpful in reminding me how to use solver. With respect, I must say that I think your formulation is incorrect. I think that you need four decision variables (# of chairs made on M1, # of chairs made on M2, # of tables made on M1, and # of tables made on M2). If you do it this way, then the constraint on M1 being less than or equal to 200 hours is dependent only on what M1 produces and not on all of the chairs and tables produced by both machines. I solved it with these extra two decision variables and found a solution of 50 chairs from M1 and 80 tables from M2 (0 tables for M1 and 0 chairs from M2), which results in $4700 in profit. If you check the constraints, you'll see that this is a feasible solution. Again, thank you very much for making this video. It really was very helpful!
@piyushashah110 жыл бұрын
HI Ryan, thanks for the feedback. I should have been more clear in the video. I had intended to mention that the chairs and tables have to sequentially go through both machines. So, they first go to M1 and then to M2. With this we need only two constraints. If we assume that either of the machines can make both the products we would surely need four constraints.
@MansfeldPlPlus6 жыл бұрын
I have the same solution.
@PatrickFrank225 жыл бұрын
That is what you did say, I understood it fine and agree with your solution@@piyushashah1
@TheBlessingchild8 жыл бұрын
This has been very helpful. It was clear to follow along. Thank you very much!
@gemmabourke23485 жыл бұрын
I just wanted to thank you for this video it was very easy to get my head around as I was really struggling with a bigger problem then this and it helped me enormously. I am so very grateful I was just about to give up and submit my assignment without doing the question and I hope to do well at it now.
@ashwinsaxena47347 жыл бұрын
A very clear (in its content) and precise video. Keep it up. Thank You for explaining the use of Excel solver in such a simple way.
@carolinalynch20876 жыл бұрын
Thank you soooo much. I was struggling with this topic in school. You explained it so simply.
@VinothArunM10 жыл бұрын
It was a simple and easy to understand beginner. Thank.
@piyushashah110 жыл бұрын
Thank you for viewing the video and leaving comments. Please do go through other videos on LP, they should help.
@ReactFli3 жыл бұрын
you are the best sir, may god bless you
@nca2937 жыл бұрын
thank you soo much...u just help me finished my final assignment...i don't have any idea to solve the question before i saw this video
@PeteZa929 жыл бұрын
Thanks for uploading the video! I'm learning this in class using a bigger problem so it's nice to see the breakdown on a simple one first.
@piyushashah19 жыл бұрын
Thanks for leaving a comment Peterson.
@mytzyrodriguez-kufner29128 жыл бұрын
Thanks Piyush, you are really clear in your explanation of how do solve problems!
@srashtigarg26472 ай бұрын
Thank you, you made it easier.
@piyushashah12 ай бұрын
Glad the video help, and thanks for leaving this comment.
@hsrsbxfhsr10 жыл бұрын
Great video, very sinple to understand and gets to the point, helped a lot with my schoolwork, found it just when I was about to give up lol, ty! :)
@barissimo1118 жыл бұрын
Couldn't have done this better. THANKS !
@piyushashah18 жыл бұрын
+barissimo111 Thanks a lot for leaving the comment. Did you see the other videos in this series? They may also be helpful.
@barissimo1118 жыл бұрын
+Piyush Shah yes the videos are great thank you ! Subscribed :D
@piyushashah110 жыл бұрын
Thank YOU LRJ. It was nice of you to leave this message.
@aakimowgli10 жыл бұрын
Nice video Sir I used to be your student really misss your lectures......I don't think anyone can teach Operations Management the way u taught us!!
@piyushashah110 жыл бұрын
Thanks a lot for the comment. Really appreciate it. .Where did I teach you?? Sorry can't make out from your screen name here.
@armybitch575 жыл бұрын
God bless you and your wisdom! Thank you!!!
@suhaibtarzan35247 жыл бұрын
I'm having more fun solving operation research problems lol Thanks for the help again.
@piyushashah17 жыл бұрын
OR is supposed to be fun, enjoy it.
@suhaibtarzan35247 жыл бұрын
Thank you for the great tutorial solving linear problem using Excel solver is the best for me :::::) Easy and quick.
@piyushashah111 жыл бұрын
The assumption here is that the viewer is convinced that the Linear Programming gives the best (optimum) solution. The video is just about the mechanics. Alternatively, it is possible to input different values of the decision variables (tables and chairs) and check if the contribution exceeds the value arrived at by MS Excel.
@wenukabandara61643 жыл бұрын
Great explanation. Thank you, this helped me.
@mathviolet6 жыл бұрын
Thank you. A clear explanation and a great video o refresh my memories.
@hezekiahseunadewinbi52113 жыл бұрын
Very helpful, thank you.
@samanthaeliote347210 жыл бұрын
Thank you very much, Nice work. Simple and direct!
@hdssntytb7 жыл бұрын
Thanks. This is really helpful. Two thumbs up!
@shwetasingh74944 жыл бұрын
Thank you sir....it is really helpful
@abodaher68088 жыл бұрын
Thank you very much for this beneficial and simple explanation
@DrPE-ow4pm5 жыл бұрын
Very helpful lesson! I'm searching for a lecture in how to test a validation of consistency of any LP model construct and results. I would appreciate if you provide any helpful source. Many Thanks.
@hondaxr400r78 жыл бұрын
Excellent explanation and very clear! Thank you
@rbalutps11 жыл бұрын
Piyush, its simple and made me so clear on the solver. Thanks a lot. A good start for solver...
@KST222222227 жыл бұрын
My concept got cleared . Huge thanks . thank you
@piyushashah17 жыл бұрын
Good job Kartik!
@TimosPatterson8 жыл бұрын
Great video! Big exam coming up, appreciate this a lot
@aadityanohar80768 жыл бұрын
thank you so much sir. Now I will get a good grade on my test !
@lakshitkuntal498411 жыл бұрын
this is awsome piyush i understood compeltely.... i have my xam tomorrow.... so thanx a ton for this one... really appreciate the effort
@juhik.99698 жыл бұрын
Good job Piyush!! We have the same question here in Canada except it's in CAD.
@piyushashah18 жыл бұрын
+Juhi K. Thanks for leaving the comment Juhi. What is CAD? Is it designing software you are referring to?
@piyushashah18 жыл бұрын
+Re Ma Opps...I hope with technology we can create videos so that they speak the currency in the native units.
@jasper2154 жыл бұрын
thank you so much! you've saved my day
@lydiademarek3 жыл бұрын
Great explanation of how to use it, but I don't think solver has truly optimised the contribution - you still have 150 hrs left to use on M2. If you think about the numbers alone, it's more efficient to make chairs on M1 (contribution per hour of tables is 5.7 rupees/hr vs 7.5 rupees/hr for chair), however it's more efficient to use machine m2 to make tables (tables 8 rupees/hr vs chairs 6 rupees/hr). Thought of in another way, if it takes M2 5 hours to make a table or a chair, and a table gives a greater contribution, you would pick tablets to make.
@lydiademarek3 жыл бұрын
Oh yep, I just scrolled further down in the comments. The furniture has to go through both machines, not just one. Thanks @Shrujanam Syama
@felicianeeley58018 жыл бұрын
Great video. Thanks!
@torimori2878 жыл бұрын
This probably just saved me from failing my midterm. Thank you!
@BlaZingDux9 жыл бұрын
This was a perfectly clear explanation, thank you!
@sevtiaanita53586 жыл бұрын
good
@sistasubramanyam22735 жыл бұрын
Thank you very much it helped me a lot...
@Maha8318 жыл бұрын
Many thanks to you.. it is very useful and helped me during my study :)
@joshmo246 жыл бұрын
Awesome vid. Thank you.
@kristinhaggard34899 жыл бұрын
This was a great help, thank you.
@xavierherrera65257 жыл бұрын
thank you, you explanations are very helpful.
@rosemuthee18028 жыл бұрын
Thank you very much. This really helped my friends and I. A tip: you may advise people how to download solver
@piyushashah18 жыл бұрын
+rose muthee Thanks for the tip Rose. I will try to include it in this video itself.
@omerhoca47748 жыл бұрын
+Piyush Shah sir i have a problem about lp and i couldnt solve it can u help me
@piyushashah18 жыл бұрын
What is it?
@omerhoca47748 жыл бұрын
Schurman Orchards has apple trees and cherry trees. The apples and cherries that are grown at Schurman Orchards are used to produce both apple cider and cherry cider. Weekly sales commitments by the owners of Schurman Orchards require at least 50 gallons of apple cider and at least 20 gallons of cherry cider. Schurman Orchards has the weekly capacity to produce at least 100 gallons of apple cider or at least 50 gallons of cherry cider or any linear combination of apple cider and cherry cider. Each gallon of apple cider cost Schurman Orchards $4; each gallon of cherry cider cost $6. a. Set up the appropriate linear program b. Solve the result of (a) using the simplex algorithm.
@nicktelsa34736 жыл бұрын
Can you solve this for us: A company makes two products (X and Y) using two machines (A and B). Each unit of X that is produced requires 50 minutes processing time on machine A and 30 minutes processing time on machine B. Each unit of Y that is produced requires 24 minutes processing time on machine A and 33 minutes processing time on machine B. At the start of the current week there are 30 units of X and 90 units of Y in stock. Available processing time on machine A is forecast to be 40 hours and on machine B is forecast to be 35 hours. The demand for X in the current week is forecast to be 75 units and for Y is forecast to be 95 units. Company policy is to maximise the combined sum of the units of X and the units of Y in stock at the end of the week. -Formulate the problem of deciding how much of each product to make in the current week as a linear program. -Solve this linear program graphically. Thank you
@piyushashah16 жыл бұрын
Interesting problem. It is very similar to the problem I have solved with a few changes - 1. Objective function is to maximise total production (X + Y) and not to maximise profits. There are two additional constraints for minimum production of X and Y so as to not have stockouts. This should solve it.
@lenny39849 жыл бұрын
Good explanation
@zjmuwsp2310 жыл бұрын
Very helpful video, thanks!!
@sonyatorres67310 жыл бұрын
THANK YOU!!! This helped me tremendously!
@userjuanjose8 жыл бұрын
Good Video. Thanks!!
@snehalsingh326110 жыл бұрын
its vry clear n simple.. thanks.. :)
@rajivmalhotra49918 жыл бұрын
Thank you very much, Mr. Shah!
@melme931111 жыл бұрын
Thank you for this. Right to the point.
@terrillchristians5 жыл бұрын
thank you great explanation
@markogeorgiev79338 жыл бұрын
Thank you! Very nice
@tiagotele17 жыл бұрын
Nice video! I helped me to do this on LP Solve. Not so different! max: 30 x1 + 7 x2; 4 x1 + 7 x2
@isaacogilvy91013 жыл бұрын
Piyush you are a god
@piyushashah13 жыл бұрын
Ha ha, glad the video helped you.
@BigBrother4Life2 жыл бұрын
Thumb rule: There is always an indian teacher who could save you from disaster.
@carlyhalliday69618 жыл бұрын
This helped my out a lot! Thank you so much!
@marhau23134 жыл бұрын
Maybe Ive missed a point, but how can the contribution be maximized when Machine 2 still has 150 available hours? Shouldnt Machine 1 produce 50 chairs and Machine 2 produce 80 tables?
@piyushashah14 жыл бұрын
Thanks for sharing this concern Marhau. In the case, the chairs and tables need both machines M1 and M2 and not either M1 or M2. So, even though M2 has slack capacity, we can;t produce more since M1 does not have slack capacity. Does this help?
@charudattajoshi50909 жыл бұрын
Piyush Sir, maybe I'm missing something. When I see that M2 can make a table or chair in the same 5 hours time, and table makes makes more money, then M2 should only make tables. 80 tables in 400 hours @ 5 hours each. Total contribution 3200. M1 is more efficient at chairs than tables. It makes 1.75 chairs in time it takes for 1 table. If table costs more than 1.75x of chair, then M1 should make tables as well, or else chairs. Since 40/30 = 1.33 < 1.75, M1 should make chairs. 50 chairs in 200 hours @ 4 hours each. Total contribution 1500. Grand total contribution 4700. Please correct if wrong. Or if I ended up looking at this in a non-linear way somehow. Thanks.
@piyushashah19 жыл бұрын
Tables and chairs needs to go through both M1 and M2 to be made. So, a product first goes to M1 and then to M2. If we assume that both the machines can individually make the products, your assertion is correct.
@charudattajoshi50909 жыл бұрын
Piyush Shah Should have focused on M1 'and' M2. Thanks :)
@k.chriscaldwell41417 жыл бұрын
Superb. Thanks.
@jimdro8 жыл бұрын
Thank you!that was really helpful!!
@salaman.h61735 жыл бұрын
Thank you so much for this
@abhinandan648210 жыл бұрын
Hello sir,i saw your solver video it was excelent,can you please help us with shortest route problem solver,if you can do a video i would really appreciate it.Thakyou sir
@piyushashah110 жыл бұрын
HI Abhi, will surely try to host that in the next 10 days.
@rajusvideos475911 жыл бұрын
Thanks Piyush - very clearly explained . I am going to use it in a class on project management .Do you have LP examples for resource optimization - project situations . Thanks once again - appreciate yr effort .
@Lemi3310 жыл бұрын
THANK YOU SO MUCH! THIS HELPED A LOT!
@matthewsoria71157 жыл бұрын
Awesome vid!!!!
@briankenor26345 жыл бұрын
Very well explained.
@muhammadrashid861510 жыл бұрын
sir thanks for the very useful video... sir can you upload a video of linear programming of variables having objective function like that.... 4(X1+X2+X3)+2(Y1+Y2+Y3), where X=X1+X2+X3 and Y=Y1+Y2+Y3
@markosiridzanski21817 жыл бұрын
Thank you! You just showed that i fail my university exam in vain doing problems of linear pogramming by hand using matrices, determinants and so on. What a wastage.
@avrostrategies862510 жыл бұрын
Thanks - video really helped!!
@StonedzZ10 жыл бұрын
Very Helpful video. All the way from SG!!!:)
@shaheryaralvi33533 жыл бұрын
Sir, the newer excel version asks to set an objective. What should that be regarding this problem?
@xalamukanibaloyi15006 жыл бұрын
clearly explained
@shadyengineer19887 жыл бұрын
Hello. Thanks for the video. You had made mistake in the problem definition. The clearest thing that proves this, that there are free 150 hours on machine M2, so why not to use them to increase contribution. The true answer will be 50 chairs on M1 and 80 tables on M2 to get 4700 Rs. contribution. Consider this equation system: T1*7+C1*4
@piyushashah17 жыл бұрын
Hi Shady, the idea here is that both products need both the machines. So, to produce a table, it has to first go to M1, get processed for 7 hours and then go to M2 and get processed for 5 hours. If I use your product mix (50 chairs and 80 tables) we would exceed our capacity. So 50 chairs will need 200 (50*4) hours on M1 and 250 (50*5) hours on M2. Similarly, 80 tables would need 560 (80*7) hours on M1 and 400 (80*5) hours on M2. Combining both we would need 760 hours (200+560) hours on M1 and 650 hours (400+250) on M2. This is beyond our capacity of 200 hours on M1 and 400 hours on M2 and hence not feasible. I hope I was able to explain the logic of the problem. Per se, sometimes we are forced to have some idle capacities as our manufacturing facilities are not balanced.
@cassiekasandr458510 жыл бұрын
Piyush Shah is there a little error? You are not maximizing the available capacity of machine M2? The constraint of this whole maximizing function will be always the machine with the lowest available hours and I believe we should separate those two constraints.