My problem looks like this, how can I organize it like this in excel "NEC Computer Company in Japan is preparing two products: tablet and computers. The production process for each product is similar in that both require a certain number of hours of electronic work and a certain number of labor hours in the assembly shop. Each tablet requires 4 hours of electronic work and 3 hours in the assembly department. And each computer takes 2 hours in electronics and 1 hours in assembly. During the manufacturing process, 240 hours of electronic time are available and 102 hours of assembly time are available. The profit for a tablet is USD 70 and USD 50 for a computer. Calculate how many units of each type should be produced for the maximum possible profit. Using graphical solution method, please explain the nature of the problem as clear as possible. Besides that, please compare your graphical calculation with MS-Excel result".
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
Hi afshamkhan, what are the formula for supply and demand constraints formula, because I cannot get the production units correctly. i tried for 1 hour in different ways. please tell me.
Great video! One helpful tip is that you can just copy and paste the sumproduct formulas instead of typing it out each time; which is basically the whole point of using the absolute reference function (Fn+F4) which you DID enter, but didn't take advantage of by copying and pasting the sumproduct formula instead of typing it separately each time.
Thanks for the helpful tutorial. However, 1. Using the exact same figures, functions, etc.. gives me a different result altogether 2. Why do we have the first 2 demand constraints as ">=" in the constraints section of the solver window (ref: at 9.52)? Shouldn't all the demand constraints be same " <=" the available mentioned in Column "H"? Please explain. TIA.
No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "<=") and the other constraint requires you to produce AT LEAST a certain amount (which is when you use ">=").
Great appreciate work. first question was very great explanation but i m facing to solve second question. i m not getting the right ans as you are. my answer around 2600. m new follower from INDIA (IIT Rookee)
It's the demand, if you place less than or equal to signs, you can produce less that the demand. Placing greater than or equal to signs, you can produce more or equal to the demand. So basically you can sell as much as your customers want, and more. For a different problem, they should put another constraint for the cost of inventory of the excess of units. But that's another story.
+YaBoyBlake h No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "<=") and the other constraint requires you to produce AT LEAST a certain amount (which is when you use ">=").
This was an absolutely perfect video for what I was needing; quick tutorial on Solver in Excel! Thank you so much! I'm actually looking forward to my next assignment.
I love this video and the algorithm that they used to answer the problem but it could be greatest if you could show us how do you took the constraint of the problem. So, thank you very much this lesson will be very useful to acquire a skill.
Dear Afshamkhan, I appreciate the video but whenever I try to do my work.... The results become with negative values!! is there anything wrong or do i need to change something in the options (setting)?
you mean to get the max profit i should not make tables?? are you sure?? if somebody wana make maximum profit by having varieties of products i.e having both tables as well as chairs then your method seems go wrong. so please give the example ...of that one also.
concise and clear! thank you so much. i learned this skill in less than 15 minutes thanks to you! and my prof was making a huge fuss about me not knowing it too. ha!
I appreciate the video, but I can't seem to get the same results as you do. I think I put in everything correctly as I've checked it multiple times, but I keep getting values over the max for the first 2 rows of demand constraints and I can't seem to figure out what I did wrong. Hmm...
hmmm..... you might want to re-check to make sure you have put in the constraints parameter correctly like the appropriate greater then, less then signs perhaps
Oooh my, thank you very much Lady, was stuck with my assignement and after a long day or reading material on the internet, I somehow landed on this video. Off to sleep now. But thanks a lot)))
The video is really simple and yet really helpful. very nice tutorial :D Please do work on transportation and assignment, Game Theory, Goal programming, Markov analysis and other similar Excel based solutions :D
in demand constraints in the second option it is exceeding the maximum limit? solver suggeted 500 usage where max limit is 400?? moreover my answer is coming in decimel u suggested one of the user to change the cell setting.but what setting to change for that we need to ask God i guess... did not help much infact confused a lot..://
AAAAAAAAH
My problem looks like this, how can I organize it like this in excel "NEC Computer Company in Japan is preparing two products: tablet and computers. The production process for each product is similar in that both require a certain number of hours of electronic work and a certain number of labor hours in the assembly shop. Each tablet requires 4 hours of electronic work and 3 hours in the assembly department. And each computer takes 2 hours in electronics and 1 hours in assembly. During the manufacturing process, 240 hours of electronic time are available and 102 hours of assembly time are available. The profit for a tablet is USD 70 and USD 50 for a computer. Calculate how many units of each type should be produced for the maximum possible profit. Using graphical solution method, please explain the nature of the problem as clear as possible. Besides that, please compare your graphical calculation with MS-Excel result".
I'm trying to follow along, but I'm stuck. What are the formulas for column G, demand constraints? Thank you.
I need Solver to accept formulas in the Variable Cells Line so that it can select only certain cells within a range. Is this possible? If not, is there an alternate method to achieve my goal?
So simple and straight forward
Hi afshamkhan, what are the formula for supply and demand constraints formula, because I cannot get the production units correctly. i tried for 1 hour in different ways. please tell me.
Great job!
Thank you!
the best
sir, please provide the same complete excel sheet to us.
"solver could not find a feasible solution" What to do?
Thank you for your help, this is exactly the issue I was facing. Thanks a lot again.
Thank you!
Great video! One helpful tip is that you can just copy and paste the sumproduct formulas instead of typing it out each time; which is basically the whole point of using the absolute reference function (Fn+F4) which you DID enter, but didn't take advantage of by copying and pasting the sumproduct formula instead of typing it separately each time.
Very Helpful Video .Thank you
Best tutorial I have found and I have been watching video after video. THANK YOU SO MUCH!
Thanks for the helpful tutorial. However, 1. Using the exact same figures, functions, etc.. gives me a different result altogether 2. Why do we have the first 2 demand constraints as ">=" in the constraints section of the solver window (ref: at 9.52)? Shouldn't all the demand constraints be same " <=" the available mentioned in Column "H"? Please explain. TIA.
No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "<=") and the other constraint requires you to produce AT LEAST a certain amount (which is when you use ">=").
Great appreciate work. first question was very great explanation but i m facing to solve second question. i m not getting the right ans as you are. my answer around 2600. m new follower from INDIA (IIT Rookee)
This helped me so much, thank you!!!!!!!!!!!
Why are your greater than less signs different for some constraints in solver? Shouldn't they all be less than or = to the amount available?
It's the demand, if you place less than or equal to signs, you can produce less that the demand. Placing greater than or equal to signs, you can produce more or equal to the demand. So basically you can sell as much as your customers want, and more. For a different problem, they should put another constraint for the cost of inventory of the excess of units. But that's another story.
+YaBoyBlake h No, the signs used in a constraint totally depends on the question, which can have multiple types of constraints. In this case, there were two types of constraints; one requires you to not GO OVER the maximum available amount (which is when you use "<=") and the other constraint requires you to produce AT LEAST a certain amount (which is when you use ">=").
Thank you so so much, it really helped!
Many thanks for this. I used it as a template and it gave me the same result as my manual matrix calculations.
Fantastic
your voice bothers me
Why? I found her voice pretty sexy actually.
Thank you, This really helped me alot
iram naeem awesome! I am happy it was helpful.
Nice tutorial, horrible data...
Thank you so much for this! It was very helpful.
This was an absolutely perfect video for what I was needing; quick tutorial on Solver in Excel! Thank you so much! I'm actually looking forward to my next assignment.
you have very sexy voice!
Good tutorial, thank you.
I love this video and the algorithm that they used to answer the problem but it could be greatest if you could show us how do you took the constraint of the problem. So, thank you very much this lesson will be very useful to acquire a skill.
Thank u for the vid!
How does a company maximize their profit by producing deez nuts?
I finally figured out after watching your video Thanks
Dear Afshamkhan, I appreciate the video but whenever I try to do my work.... The results become with negative values!! is there anything wrong or do i need to change something in the options (setting)?
I need help with my homework can you help?
Thanks
What is the meaning of LP?
Linear Programming :)
Very helpful, thanks!
you mean to get the max profit i should not make tables?? are you sure?? if somebody wana make maximum profit by having varieties of products i.e having both tables as well as chairs then your method seems go wrong. so please give the example ...of that one also.
concise and clear! thank you so much. i learned this skill in less than 15 minutes thanks to you! and my prof was making a huge fuss about me not knowing it too. ha!
So nicely explained. The best video on this topic!
I honestly did not even try to see if I got the same calculations, I just needed some questions answered and you answered them. So thank you.
I appreciate the video, but I can't seem to get the same results as you do. I think I put in everything correctly as I've checked it multiple times, but I keep getting values over the max for the first 2 rows of demand constraints and I can't seem to figure out what I did wrong. Hmm...
hmmm..... you might want to re-check to make sure you have put in the constraints parameter correctly like the appropriate greater then, less then signs perhaps
This homework problem took me hours to figure it out. Using your video cut the time to minutes. Thank you very much
Thank you very much! I think I can finish my assignment today!
Oooh my, thank you very much Lady, was stuck with my assignement and after a long day or reading material on the internet, I somehow landed on this video. Off to sleep now. But thanks a lot)))
The video is really simple and yet really helpful. very nice tutorial :D Please do work on transportation and assignment, Game Theory, Goal programming, Markov analysis and other similar Excel based solutions :D
in demand constraints in the second option it is exceeding the maximum limit? solver suggeted 500 usage where max limit is 400?? moreover my answer is coming in decimel u suggested one of the user to change the cell setting.but what setting to change for that we need to ask God i guess... did not help much infact confused a lot..://
Thank you!!