Linear Programming (LP) Optimization with Excel Solver 

Man thank you I wish I could give you my money instead of my professors. I’ll repay you one day

It baffles me that Matt made this problem so easy to understand. Why can’t my Professor break it down like this? Thanks Matt!

Thank you!!! So much better than my prof at explaining, especially since you use much clearer terms.

Interesting. ... going to school in the early 70s, we did all of this by hand... with the use of a slide rule to estimate the answer and then draw a couple of graphs by hand to zero in on the better answer. Them were the days!! Enjoyed the clip.

You are a god among men. This is the best explanation of this I have heard. Thank you.

I think I watched about 5 videos before I found one that has the best example on what to do. Thanks!!! Short and Simple!!

Extremely good video. I was pulling my hair in class because my teacher was confusing everyone. Thank you!

Edit: I found it! I had to go to Data/Solver and then go through the set-up there and the "Limits Report" showed up! Thank you so much for the video again! Thank you for the insightful video! Only thing I was unable to do on my own when following your video was to find the "Limits Report" which didn't show up anywhere in my Excel document. I'm using the newest versions of things, so it probably is just somewhere I don't know where to look for it

Saved me for my Quantitative Analytics module! My lecturer explained this so badly, thank you!

Matt, thank you for taking the time to produce this video. It has helped me a lot.

Great video. My professor took 2 hours to teach this method and i did not understand a thing. whereas you made me understand it in 10 mins. :)

easy way to learn ,good work to the developers of the video

I don’t understand why professors make so difficult huhhh thanksss a lot man❤

Thank you so much. I was struggling to solve LP with excel solver and your video helped me a lot.

Wow man, you are a LEGEND; the way you explain.... just wow. I wish I could trade you with my professor.

Let me tell you. You definitely aleviated a headache and got me out of a tough spot. You explained and showed me this in a manner that was easy to pick up thanks a ton.

Easy to understand and so much easier than doing the simplex method by hand 🙏🙌 Thank you!

Using this in a business merger and acquisition deal in the Midwest. Its a maximization problem of how much capital to allocate to acquisition 1 vs acquisition 2. Its tricky in that the constraints are sensative to changes and are somewhat subjective. For example, we are using return on investment (ROI) as our maximization goal - similar to the "profits goal" in the video. However, the characteristics used as inputs on ROI have some nuances - i.e, capitalization rates, time horizon, standard deviation of cash flows, industry betas and overall risk profiles. Nevertheless, it does provide a methodology to analyze capital allocations to different investments. I saw the other comments about how Linear Programming is taught at the university level. I experienced the same issue at both the undergraduate and graduate level. It was the most time intensive class I took and most of the learning I received was from my own investigation as the Prof didn't seem to care much about what we absorbed or was so far advanced that he had a difficult time bringing down to an introductory level. Stay with it though - its good real world usage your getting.

My professor literally gave us a link to this video instead of just teaching it himself, I wish I can just take back the money I gave to my professor and give it to you instead. Have my like and sub cuz idk how else to repay u back

Thank you for posting this! you explained it in a easy but clear way. Now, I know how to solve my assignment problem. Thank you!

Thank you so much!!!! I had so much trouble with understanding this and you explained it perfectly. I now understand this. THANK YOU!!!

This is the best explanation I've seen so far💯 ,Thank you Sir☺️

Back in the days, we used simplex method, and I wrote C program to solve the opimization... now there is an excel solver.... People have forgotten the importance of solving problems on their own.

You're awesome for replying to every comment. Good video!

You saved my ass. I have an assignment on this and I had no idea before I watched this video.

Thorough and clear explanation. THANKS so much :)

it was easy to learn and certainly very helpful to me. Thank you so much for making this video!

THANK YOU! This helped me finally understand Solver.

Explained clearly. Thank You, Matt!

thanks, gonna use this to find probable missing amounts

Hi Matt! Thanks for your video, this really helped me to find the LP for my problem.

Saved me a lot of time and stress, can't thank you enough!!

Thank you so much for this video. It really helps a lot for my upcoming report with this kind of topic. Thanks a bunch!

Better than my professor explanation that took 6 classes and I did not understand a thing

so so so helpfull, gonna submit my semester project with t your spreadsheet. thank you so muchh

Thank you very much for your RU-vid video. I’ve subscribed to your channel.

you're really a good tutor. thank you so much. this helped a lot.

Great video! Thank you so much for the explanation.

Very clear and easily understood. Thank you

Thanks. You teach better than my prof. who teach in the most famous university in my country.... #youtuisbetterteacherthanteacherinclass

So helpful, thank you so much Matt!

man you are literally a god thank you so much !!!!!

im student from indonesia, thank youu this video really helpful :)

Saved my life homie. Much love.

thanks Matt, you're awesome

You are incredible thank you for your help 🙏🤗

Thank you! This helped a lot

Very clear and concise tutorial thank you!

Wow! well explained. Thanks.

Thank you! Awesome job btw, and very clearly and thoroughly explained :)

Thank you for making this video!

Very helpful and straight forward - thank you!

Thank you so much this was super helpful

Thank you! Very helpful

Thank you - very well explained!

Very easy to understand, thank you!

This sensitivity report is not clear. Can you make a detailed video on its analysis please

My Professor shared this Video with in class :)

Thank you Matt. It was very helpful for me 🙏

LIFESAVER THANK YOU SO MUCH

Thank you. Well explained. Great Job (thumbs up).

Thanks for the help! Definitely useful stuff

Video really helped me! Thank you!

Thank you so much, really helped a lot!! Awesome work

Very helpful! Thank you.

Thank you so much!! Now I understand a lot!

Thank you! Video was very helpful!! :)

Can you give me the same example (question, issue) Because I want to solve it on my own?

Do you have an example on linear programming to minimize interest payment? Example whether to get bank loan at the beginning of the year or monthly loan or combination of both types of loan. I can’t seem to find any examples online. Hope you can show an example. Thank you.

Thanks Matt - it was help in college

can you do it with multiple objective? and can we pick one thing from list with multiple objective problem with excel solver?

Thank you so much!!!

Thank you so much.

very helpful, thank you very much for sharing

Excellent Matt

hi- to define if i exceeding daily usage what would be my constraints?

Hello Matt, what keys did you press for you to change (B4:C4) to ($B$4:$C$4)??

Wonderful video... Can we use excel solver to solve goal programming?

I'm wondering if you can help set up the following question in Solver: I'm travelling 15000km. Each tire has travel a max distance of 10000km (assume I start with a set of 4 tires). What is the min number of tires I need to use to complete the trip?

Thank you so much. Can I share this youtube with my students?

perfect thanks!

How to avoid decimal number. I want natural number but i keep getting decimal numbers

when i add subj to constraints it says unequal number of cell ref and constraints, however they are equal, how do i fix this? thanks great video btw, just encountered some technical difficulties

Can you articulate the example in a paragraph or give the link of the example?

Your channel it s very helpful 👏👏 I just want to ask How we can use linear programming for asset allocation

How do you do a weight using your format? I have a problem that I set up just like you did, but one product cannot account for more than 50% of units produced and another has to account for at least 20%. Thanks for your help!

Thank you so much

how can i add a constraint to disable the use of decimal?

Hi. I have a question. I created a macro (VBA) that emulates the solver by clicking on a button. The problem is that sometime I have to click 3-4 times before getting the last results. Do you know how to avoid this and getting on solution with one click?

You are the man!

Hi! I am a little confused about 5:37 for the total profit function. Can you explain what you did? I tried sum product for the number to make * used numbers and got VALUE!.

Thank you very much. :-)

thank you!!!!

Thank you!

how did you do the absolute referencing

Thank you #Matt Macarty

When you start doing the SUMPRODUCT part you lose me. It doesn't show how you copied it down and I do not get the $ as you do. I only get the B3:C3 part and there is no explanation on the video as to how you did that since the cell you had already formatted

Awesome

THANKYOUUUUUU

Thank you!!!