Using Excel Solver to solve a LP problem

[@fitgirlkoa3753]

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.

[@justStardust940]

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!

[@tcg4111]

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.

[@MsWill8158]

This homework problem took me hours to figure it out. Using your video cut the time to minutes. Thank you very much

[@MelidaWillox5224]

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.

[@estefaniagallardo4505]

Best tutorial I have found and I have been watching video after video. THANK YOU SO MUCH!

[@GERRARD2083]

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)))

[@michaeljones5876]

Many thanks for this. I used it as a template and it gave me the same result as my manual matrix calculations.

[@emperoy8]

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?

[@afshamkhan]

+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 :).

[@petermokoena3513]

You have made this Solver so simple! Thank you- hope to see some more of your videos

[@alfredomatias5549]

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.

[@jcs0984]

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...

[@afshamkhan]

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

[@MohammedAnsariRiz]

So nicely explained. The best video on this topic!

[@nadjamalvares7563]

I finally figured out after watching your video Thanks

[@sinantuncer]

Thank you for updating this video, it was really helpfull and easy to understand.

[@LolaLindaaa]

Thanks for making this video.. You have the most updated Excel I've found, really helpful and you explained everything well.

[@afshamkhan]

Thank you I am glad you found it helpful. It was done as part of a class project :).

[@Runsheeg53633]

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".

[@onasvickie5010]

So simple and straight forward

[@cecilm3720]

I'm trying to follow along, but I'm stuck. What are the formulas for column G, demand constraints? Thank you.

[@archanabadarkhe8980]

Thank you for your help, this is exactly the issue I was facing. Thanks a lot again.

[@bowencai6295]

Thank you very much! I think I can finish my assignment today!

[@theapexpredator157]

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?

[@skvijay2537]

Very Helpful Video .Thank you

[@selenaliu6082]

very clear and helpful, thank you so much for your effort!

[@petsanimals6864]

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

[@samarhabib]

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..://

[@samprime3180]

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.

[@apap-fg9rp]

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 "

[@tcg4111]

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 "=").

[@solace019]

Great job!

[@davidmunkyala8768]

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)?

[@kistnaalper3823]

Thank you so much for this! It was very helpful.

[@davidwilson1920]

Thank you very much. I have learned something new.

[@sourabhkumarsaini8872]

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)

[@yaboyblakeh5889]

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?

[@marilynman]

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.

[@tcg4111]

+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 "=").

[@iramnaeem452]

Thank you, This really helped me alot

[@afshamkhan]

iram naeem awesome! I am happy it was helpful.

[@douginalabama2845]

Very helpful, thanks!

[@tomtb5475]

Crystal clear! Thanks a lot!

[@Tripsandcoffee]

Fantastic

[@hn552698]

Thank you so much!! Very useful!!

[@paulkaburia2062]

It was so helpful thank you.

[@kylescott4698]

This helped me so much, thank you!!!!!!!!!!!

[@marlourentucan9023]

the best

[@morganreid8084]

Thank you so so much, it really helped!

[@ovigeria]

Good tutorial, thank you.

[@ankushzap]

solver is giving solution but in decimals. Is there any option in solver to get whole number units?

[@afshamkhan]

+ankushzap right click on that cell, go to "format cell" and change the setting there.

[@samarhabib]

+afshamkhan what setting to change?

[@samogx86]

Thank you!

[@miljanakovacevic4284]

"solver could not find a feasible solution" What to do?

[@Keybladestrike]

Thank you so much!!!!!!!!

[@albashtawi100]

great job thank you

[@kArnAgePT]

Thanks!

[@jcso1]

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....

[@CraigHatmakerBXL]

Thanks.

[@ganeshgore9832]

sir, please provide the same complete excel sheet to us.

[@iamdinesh8904]

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.

[@flop9265]

Thank u for the vid!

[@fati3442]

I need help with my homework can you help?

[@Sushi44560]

Thank you!!

[@Nokipoki_]

Thanks

[@parineesartwong4481]

thanks :)

[@xphuangsg6198]

What is the meaning of LP?

[@afshamkhan]

Linear Programming :)

[@G_707]

Thank you sooo much

[@flop9265]

How does a company maximize their profit by producing deez nuts?

[@michimelk299]

AAAAAAAAH

[@thisApex3D]

Nice tutorial, horrible data...

[@cassiec1697]

Thank you!