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.
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.
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!!!
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 .
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.
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.
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.
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.
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
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!
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.
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!
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.
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.
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.
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.
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
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.
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 .
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.
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.
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.
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.
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?
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?
By contribution you mean the amount of money need to pay in order to produce table or chair ? also I am using 2010 Excel, in the solver options shall I change it from GRG Nonlinear to Simple LP ?
Hello, I have a lot more complex problem than the one you showed me. I would be glad if you could help me out on this. Lets take an analogy of some Ores. a,b,c,d,e. These Ores have minerals A,B,C,D,E in them. For Example 500 Units of a will have 100 units of A and 50 Units of B and so on. In the end I know how much minerals A,B,C,D,E I want. And I wan't to know what ores I should obtain to get those minerals and how many units of those ores. How would I calculate that?
HI Sarthak, these videos are an introduction to using Excel Solver for LP and thats why simple problems have been used. For your problem, I guess minimising the cost or Ores a,b,...would be the objective. The decision variables would be the units of each of the Ores to purchase. The constraints would be to have the minimum or maximum units or minerals. So, for example Each Ore 'a' has 0.2 units of 'A', and each Ore 'b' has 0.3 units of A then 0.2a+0.3b is the units of the Mineral 'A'. This you have to compare with the condition in the problem for the Mineral A.
sir...just wondering...why the solver did not suggest we make any table since the question objective is to optimize the mix of chair and table?is there anything need to be adjusted in the solver so that both chair and table can be produced and at the same time maximize its profits?
+Farahin Hanani The solver always suggests ways to maximise the contribution. In this case, if you produce tables, your contribution is likely to come down. If you have to make tables, add it as a constraint. I think the third video in this series does this. Check it.
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
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.
Create a constraint for the mix ratio. Say the mix ratio is 1:r, where for every 1 chair we need r tables. If c is the number of chairs made and t is the number of tables made then cr = t, or cr - t = 0. Does this help?
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
in this video or tutorial, could it be identified also as Computer solution since it uses MS Excel? or it simplified the problem using the excel but not actualy the Computer Solution for Linear Programming?? thanks..
Great video! I just had a question, if we utilize the entire 400 hours on M2, we will get more contribution, but why didn't solver take this into consideration?
+Gabriela Hernandez Are you referring to the graphical methods for solving an LP? I don't think we can use these tables to create the graphs. But, I am sure there would be some software (possibly free) that would allow you to apply the graphical method.
This 5 minute video just taught me more than my professor could in 40 minutes! Just save me, thanks!
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.
Very true!
@@piyushashah1 hello can you teach me
Excellent tutorial. Crisp and to the point. Did not waste even a single second and every second had useful content.
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.
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!!!
Attention all producers of youtube video tutorials. THIS is how it should be done. Short and effective. Very nice work, my friend. Thank you!
Thank you for this wonderful comment. Do have a look at the other videos in this series as well.
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 .
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.
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.
Thank you sir , revising this before my business maths practical
Very useful video. Straight to the point, with all the emphasis being directed toward the subject matter. Professionally done and much appreciated.
This just felt like a blessed video. Entire complication summarized beautifully in one video. Very smooth, clear and wonderfully explained!!
After 2 weeks of being lost on this topic, you taught me how to do it in 10 minutes. Thank you!
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.
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.
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
Thanks for leaving the comment. Did you check my other solver videos? Have a look, they might just make using solver even more easier.
This video really helped my understanding of formulation of linear problems. Thank you for the knowledge!
Thanks for the comment. I'm happy that the video was helpful for you.
Best tutorial on excel solver with LP problems there is!
+VonNeumannOperator Thanks a lot for leaving the comment.
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!
Thank you sir....it is really helpful
Thank YOU LRJ. It was nice of you to leave this message.
A nice explanation than any video I have seen.
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.
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!
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.
I have the same solution.
That is what you did say, I understood it fine and agree with your solution@@piyushashah1
With this simple video you just made me completely understand this part. Thank you very much!
Absolutely great video. It's nice having a simple way to check my answers in Linear Programming.
you are the best sir, may god bless you
Thank you soooo much. I was struggling with this topic in school. You explained it so simply.
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.
Thanks for leaving a comment Peterson.
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
this is awsome piyush i understood compeltely....
i have my xam tomorrow.... so thanx a ton for this one... really appreciate the effort
It was a simple and easy to understand beginner. Thank.
Thank you for viewing the video and leaving comments. Please do go through other videos on LP, they should help.
This has been very helpful. It was clear to follow along. Thank you very much!
Piyush, its simple and made me so clear on the solver. Thanks a lot. A good start for solver...
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!!
Thanks a lot for the comment. Really appreciate it. .Where did I teach you?? Sorry can't make out from your screen name here.
Thanks Piyush, you are really clear in your explanation of how do solve problems!
Very helpful, thank you.
Couldn't have done this better. THANKS !
+barissimo111 Thanks a lot for leaving the comment. Did you see the other videos in this series? They may also be helpful.
+Piyush Shah yes the videos are great thank you ! Subscribed :D
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.
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.
Thank you, you made it easier.
Glad the video help, and thanks for leaving this comment.
Great explanation. Thank you, this helped me.
My concept got cleared . Huge thanks .
thank you
Good job Kartik!
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! :)
Good job Piyush!! We have the same question here in Canada except it's in CAD.
+Juhi K. Thanks for leaving the comment Juhi. What is CAD? Is it designing software you are referring to?
+Re Ma Opps...I hope with technology we can create videos so that they speak the currency in the native units.
Excellent explanation and very clear! Thank you
HI Lakshit, thanks for the feedback. Happy that the video helped you. Do have a look at the other videos as well
Thank you. A clear explanation and a great video o refresh my memories.
Thanks. This is really helpful. Two thumbs up!
Thank you for the great tutorial solving linear problem using Excel solver is the best for me :::::)
Easy and quick.
Thank you very much for this beneficial and simple explanation
I'm having more fun solving operation research problems lol Thanks for the help again.
OR is supposed to be fun, enjoy it.
thank you so much sir. Now I will get a good grade on my test !
God bless you and your wisdom! Thank you!!!
Great video! Big exam coming up, appreciate this a lot
Good explanation
Thank you very much. This really helped my friends and I. A tip: you may advise people how to download solver
+rose muthee Thanks for the tip Rose. I will try to include it in this video itself.
+Piyush Shah sir i have a problem about lp and i couldnt solve it can u help me
What is it?
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.
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.
Oh yep, I just scrolled further down in the comments. The furniture has to go through both machines, not just one. Thanks @Shrujanam Syama
Great video. Thanks!
This probably just saved me from failing my midterm. Thank you!
Many thanks to you.. it is very useful and helped me during my study :)
thank you so much! you've saved my day
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
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.
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 .
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.
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.
Thank you very much, Nice work. Simple and direct!
its vry clear n simple.. thanks.. :)
Sir, the newer excel version asks to set an objective. What should that be regarding this problem?
This was a great help, thank you.
Very well explained.
Very helpful video, thanks!!
Thank you very much it helped me a lot...
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.
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.
Piyush Shah Should have focused on M1 'and' M2. Thanks :)
Thank you for this. Right to the point.
Awesome vid. Thank you.
This was a perfectly clear explanation, thank you!
Thank you very much, Mr. Shah!
Superb.
Thanks.
Very Helpful video. All the way from SG!!!:)
Awesome vid!!!!
thank you, you explanations are very helpful.
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?
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?
Piyush you are a god
Ha ha, glad the video helped you.
By contribution you mean the amount of money need to pay in order to produce table or chair ? also I am using 2010 Excel, in the solver options shall I change it from GRG Nonlinear to Simple LP ?
Hani Albarni Contribution is the subtraction of variable cost from selling price. In 2010 Excel, use Simplex LP.
good
Good Video. Thanks!!
thank you great explanation
Hello, I have a lot more complex problem than the one you showed me. I would be glad if you could help me out on this. Lets take an analogy of some Ores. a,b,c,d,e. These Ores have minerals A,B,C,D,E in them. For Example 500 Units of a will have 100 units of A and 50 Units of B and so on. In the end I know how much minerals A,B,C,D,E I want. And I wan't to know what ores I should obtain to get those minerals and how many units of those ores. How would I calculate that?
HI Sarthak, these videos are an introduction to using Excel Solver for LP and thats why simple problems have been used. For your problem, I guess minimising the cost or Ores a,b,...would be the objective. The decision variables would be the units of each of the Ores to purchase. The constraints would be to have the minimum or maximum units or minerals. So, for example Each Ore 'a' has 0.2 units of 'A', and each Ore 'b' has 0.3 units of A then 0.2a+0.3b is the units of the Mineral 'A'. This you have to compare with the condition in the problem for the Mineral A.
sir...just wondering...why the solver did not suggest we make any table since the question objective is to optimize the mix of chair and table?is there anything need to be adjusted in the solver so that both chair and table can be produced and at the same time maximize its profits?
+Farahin Hanani The solver always suggests ways to maximise the contribution. In this case, if you produce tables, your contribution is likely to come down. If you have to make tables, add it as a constraint. I think the third video in this series does this. Check it.
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
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.
THANK YOU!!! This helped me tremendously!
clearly explained
how to compute if its required to make both tables and chair and no binding on qty ? optimum mix of both.. tx for sharing
Create a constraint for the mix ratio. Say the mix ratio is 1:r, where for every 1 chair we need r tables. If c is the number of chairs made and t is the number of tables made then cr = t, or cr - t = 0. Does this help?
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
HI Abhi, will surely try to host that in the next 10 days.
so well explained :)
Thanks a lot for the comment Ragini.
in this video or tutorial, could it be identified also as Computer solution since it uses MS Excel? or it simplified the problem using the excel but not actualy the Computer Solution for Linear Programming?? thanks..
I would say it is an MS Excel based tutorial. The problem is solved using the Solver addin of MS Excel. Did you find the video useful?
Great video! I just had a question, if we utilize the entire 400 hours on M2, we will get more contribution, but why didn't solver take this into consideration?
You can't use entire capacity on M2 as M1 capacity is limited. A process needs both M1 and M2 together
You are the best
Thanks for the wonderful comment Asim.
How does one show the results graphically from the tables you created in this video?
+Gabriela Hernandez Are you referring to the graphical methods for solving an LP? I don't think we can use these tables to create the graphs. But, I am sure there would be some software (possibly free) that would allow you to apply the graphical method.
+Piyush Shah i just wondering if u do an assignment for student. email me at mariamawiw@gmail.com
Tatek Dinku No I Don't Tatek. Best wishes.
Thank you! Very nice
You're the best!!