This video tutorial is about solving a basic profit maximization problem using solver in excel
Пікірлер: 78
@fitgirlkoa37538 жыл бұрын
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.
@MelidaWillox52247 жыл бұрын
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.
@justStardust9408 жыл бұрын
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!
@estefaniagallardo45056 жыл бұрын
Best tutorial I have found and I have been watching video after video. THANK YOU SO MUCH!
@tcg41115 жыл бұрын
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.
@MsWill81588 жыл бұрын
This homework problem took me hours to figure it out. Using your video cut the time to minutes. Thank you very much
@petermokoena351310 жыл бұрын
You have made this Solver so simple! Thank you- hope to see some more of your videos
@michaeljones58766 жыл бұрын
Many thanks for this. I used it as a template and it gave me the same result as my manual matrix calculations.
@GERRARD20838 жыл бұрын
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)))
@MohammedAnsariRiz8 жыл бұрын
So nicely explained. The best video on this topic!
@onasvickie50103 жыл бұрын
So simple and straight forward
@sinantuncer10 жыл бұрын
Thank you for updating this video, it was really helpfull and easy to understand.
@emperoy88 жыл бұрын
Hi Afsham. You are pretty capable to deliver your knowledge to your a audiences, the quality a few people possess. With such great ability , I wonder why you dont make more videos?
@afshamkhan8 жыл бұрын
+emperoy8 Thank you. I am humbled by your kind words and encouragement. But, honestly this was done as a part of an MBA class as an example of conducting tutorials. I am happy to know that it was helpful and people are benefiting from it. I am more caught up on setting up a responsible social business now and hope to bring some positive change. Perhaps in the future I may :).
@alfredomatias55497 жыл бұрын
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.
@LolaLindaaa10 жыл бұрын
Thanks for making this video.. You have the most updated Excel I've found, really helpful and you explained everything well.
@afshamkhan10 жыл бұрын
Thank you I am glad you found it helpful. It was done as part of a class project :).
@archanabadarkhe89805 жыл бұрын
Thank you for your help, this is exactly the issue I was facing. Thanks a lot again.
@nadjamalvares75637 жыл бұрын
I finally figured out after watching your video Thanks
@selenaliu60829 жыл бұрын
very clear and helpful, thank you so much for your effort!
@bowencai62958 жыл бұрын
Thank you very much! I think I can finish my assignment today!
@kistnaalper38237 жыл бұрын
Thank you so much for this! It was very helpful.
@davidwilson192010 жыл бұрын
Thank you very much. I have learned something new.
@skvijay25376 жыл бұрын
Very Helpful Video .Thank you
@jcs09848 жыл бұрын
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...
@afshamkhan8 жыл бұрын
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
@petsanimals68648 жыл бұрын
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
@solace0194 жыл бұрын
Great job!
@douginalabama28457 жыл бұрын
Very helpful, thanks!
@ovigeria7 жыл бұрын
Good tutorial, thank you.
@iramnaeem4526 жыл бұрын
Thank you, This really helped me alot
@afshamkhan6 жыл бұрын
iram naeem awesome! I am happy it was helpful.
@tomtb547510 жыл бұрын
Crystal clear! Thanks a lot!
@paulkaburia20628 жыл бұрын
It was so helpful thank you.
@theapexpredator1573 жыл бұрын
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?
@cecilm37203 жыл бұрын
I'm trying to follow along, but I'm stuck. What are the formulas for column G, demand constraints? Thank you.
@Runsheeg536333 жыл бұрын
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".
@sourabhkumarsaini88726 жыл бұрын
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)
@hn55269810 жыл бұрын
Thank you so much!! Very useful!!
@morganreid80846 жыл бұрын
Thank you so so much, it really helped!
@kylescott46986 жыл бұрын
This helped me so much, thank you!!!!!!!!!!!
@apap-fg9rp6 жыл бұрын
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 "
@tcg41115 жыл бұрын
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 "=").
@samarhabib8 жыл бұрын
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..://
@samprime31803 жыл бұрын
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.
@marlourentucan90235 жыл бұрын
the best
@Tripsandcoffee6 жыл бұрын
Fantastic
@samogx864 жыл бұрын
Thank you!
@albashtawi10010 жыл бұрын
great job thank you
@davidmunkyala87687 жыл бұрын
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)?
@yaboyblakeh58896 жыл бұрын
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?
@marilynman6 жыл бұрын
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.
@tcg41115 жыл бұрын
+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 "=").
@Keybladestrike9 жыл бұрын
Thank you so much!!!!!!!!
@CraigHatmakerBXL8 жыл бұрын
Thanks.
@flop92657 жыл бұрын
Thank u for the vid!
@kArnAgePT8 жыл бұрын
Thanks!
@jcso110 жыл бұрын
Very nice, thank you... Solver seems to be a very powerful tool, tough it has some pitfalls I can't find how to solve: Let's suppose I have in Sheet 1 of Workbook "A" an objective function that i want to maximize changin' cells in othe Sheet in anothar Workbook. A seemengly easy task couldn't be performed as long as I get am annoying message 'Changing cells must be in the active sheet'. I mean, I can try this using VBA macros and the so, and is OK, but what I wan is to solve this interactively. Anyone has a hint on how to do this? Thanks in advance....
@ankushzap8 жыл бұрын
solver is giving solution but in decimals. Is there any option in solver to get whole number units?
@afshamkhan8 жыл бұрын
+ankushzap right click on that cell, go to "format cell" and change the setting there.
@samarhabib8 жыл бұрын
+afshamkhan what setting to change?
@Sushi445608 жыл бұрын
Thank you!!
@Nokipoki_7 жыл бұрын
Thanks
@miljanakovacevic42845 жыл бұрын
"solver could not find a feasible solution" What to do?
@parineesartwong44818 жыл бұрын
thanks :)
@ganeshgore98325 жыл бұрын
sir, please provide the same complete excel sheet to us.
@fati34427 жыл бұрын
I need help with my homework can you help?
@iamdinesh89047 жыл бұрын
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.
@G_70710 жыл бұрын
Thank you sooo much
@xphuangsg61987 жыл бұрын
What is the meaning of LP?
@afshamkhan7 жыл бұрын
Linear Programming :)
@flop92657 жыл бұрын
How does a company maximize their profit by producing deez nuts?