Linear Programming Sensitivity Analysis - Interpreting Excel's Solver Report

This brief video explains the components of LP Sensitivity Analysis using an Excel Solver Report. A few questions were also answered based on the following Linear Programming model.
Max 50A + 60B + 55C
s.t.
A + B + C ≤ 100
2A + 3B + 2C ≤ 300
2A + 3B + 2C ≥ 250
A + 2C ≥ 60
1. State the optimal solution
2. What is the optimal objective function value?
3. What would happen to the optimal solution if
a) the unit profit on B decreases by 20?
b) the unit profit on C decreases to 45?
c) the unit profits on A & C change to 53 (Simultaneous Changes-100% Rule)?
4. Interpret the reduced cost for A
5. What would happen to the objective function if
a) the RHS of constraint 1 increases by 5?
b) the RHS of constraint 2 decreases to 250?
c) the RHS of constraint 4 changes to 44?
6. Which constraints are binding?
7. What are the slack/surplus values?

[@user-qg2tj4ib6i]

Exceptional !! You summarized a 2 hour lecture in less than 10 min and it was to the point. Not a single non relevant word spoken. Simply Brilliant. Keep up the good work.

[@llillard1]

This is the clearest explanation of LP sensitivity that I've seen so far. Thanks for posting this. It helped me with my homework without needing to read 20 pages of dry textbook material. Great work Josh.

[@nikolu9560]

If it takes 5 minutes on average to understand 40 minutes long lecture. You will have to walk to class when you can sit tight at home to watch videos. What is the optimal length of youtube videos you should watch per week?

[@SequinBrain]

yeah, it's like schools today are trying to make sure you DON'T get any education.

[@sharanyashyamdas]

I have my exam tomorrow and I was totally clueless. But this video makes me confident now. Precise, to the point and covers my total syllabus as well. Thank you so much!

[@breezemount8425]

Me too!!!

[@durgapshibu-lm5xr]

how was the exa,m?

[@yashverma9924]

30k a year for 2 hour lectures twice a week and I still understand nothing. Watched this 6 minute video and understand everything that was covered for the past two weeks. Why am I still in school?

[@T0N1-k7t]

Very straightforward and helpful. Thank you from the bottom of my heart.

[@joshemman]

You're welcome!

[@dhanashreebadhe9711]

amazing! to the point, crisp and clear! Thank you so much Joshua!

[@phd-prospect7294]

Josh is the GOAT, I have been struggling to get to understand this for a while, and this whole thing just took me 6min. Meen, I love you, Josh

[@AhmedShakir1991]

I sat 4 hours trying to understand this, you simplified it in less than 10 minutes.....thank you!

[@Jessica-uv4lt]

You are a life saver. I will have an exam on two days from now, that is the first time that I understand the LP sensitivity which will be part of my exam. Thanks a lot

[@umasreeram9217]

I am going to pass midterm in 2 hrs from now becoz of u...god bless u

[@fruitlessXorchid]

Before watching this, I was so confused about sensitivity analysis but this has made sooo much more sense. thank you so much, this was amazing.

[@M3no0osh]

this is the best instructional video i have ever watched . on point and straight forward. thank you so so so much joshua.

[@hassanshahzad9912]

This is known as TO THE POINT LECTURE. NO FANTASY WORDS AND JARGON OF TECHNICAL LANGUAGE.

[@timianalytics7150]

Thank you so much, I've been on this thing for 2 days, I didn't understand. Thank you once again

[@vaibhavkaushik8813]

This is explained really well. Thankyou Joshua !

[@ayusuryaningsih7680]

Thank you SOOOO much. Your explanation so clear. This is much better the my lecture.

[@nurulhikmah2342]

super helpful N really helps me understand for my exam tomorrow

[@dia896]

you are a exceptional professor, you simplified the content exceptionally well, pl. uploading more such videos

[@ritujatripathi3075]

Superb! This was the most crisp, comprehensive and clear solution for sensitivity analysis! Thank you so much! Please make more videos on other topics too since you explain really well:)

[@mr-joshi]

Thanks for this video, I found it very useful.

[@95abhinav]

Crisp and comprehensive!

[@codplayer123erz]

thank you! you just saved my final exam grade!

[@mertyldz9010]

I have to give your right. This is the most excellent video ı have ever seen about researchıng methods lecture. Keep ıt up!

[@AyeshaKhan-ro6rp]

Amazing!!! You taught soo well!! Thank you!

[@lisongyuan4348]

Thank you for your clear explaination !!!!! I have sloved my long term problem with sensitivity report interpret!!!!!

[@axeli589]

a well-built efficient explanation. Thank you!

[@ShashankNagaraja]

Thank you Joshua, this explanation was very clear!

[@102lalitgautam5]

Thank you so much, know I will perform good in my practical exam

[@winnieooko]

Impressive explanation now i really understand the sensitivity report

[@fatmaahmed6024]

This is soooo amazing thank you SO SO SO much!!! I didn’t understand this topic at all but after this video it makes complete sense! Thank you so much for taking the time to make this, we all appreciate it! :)

[@a.p3959]

you are my new favorite..

[@faresmajed50]

Thanks man, I wish you are my Professor.

[@mikemike-vo7df]

Awesome video sir....this will help me a lot...kudos to you good Sir

[@dattaram1015]

One query: During analysis of constraint changes, in the first two instances it is - (original RHS values - new value) * shadow price given that the delta change is allowed. But for the last instance, it's shown as (new value-original value) i.e. 44-60=-16. Why is this inconsistency? If the process is (original RHS - new value) * shadow price then it would be -40 and not +40. Which process is correct? Am i missing something?

[@joshemman]

Yes, you're missing the difference between Increase and Decrease.

[@pabitraasubramaniam2339]

this is very helpfull and easy for me to understand. thank you so much for this video

[@fatmaahmed6024]

Amazing video!!!! This helped my friends and I a LOT! Thank you so so much!!!:)

[@jaked5651]

and just before my final. THANK YOU!!!!!!!

[@pm-dx2fs]

This is a very useful video for people to understand the sensitivity analysis. Thank you for making such an excellent explanation video！

[@nishitdarji6446]

Thank you, it really helped❤

[@joshemman]

You're welcome 😊

[@chaithanyatutorial3845]

Excellent!!!!! Video
Thank You

[@stevenmucyo7377]

Best video I've seen! Thanks man!

[@anitachaudhary5827]

Thanks so much sir for your valuable time. Best

[@Batuta-ys7ri]

great explanation, but how do we calculate the allowable increase and decrease in the first place from the final simplex tableau

[@yiw9438]

thanks! it's very clearly explained

[@AlimFazle]

Thank you so much for the clear and concise video. You cleared the concept in 7 minutes, when I could not understand it in class for 2 hours. Very Much Appreciated.

[@tehbpop]

summarizes my entire course into a 7 minute video lmao

[@harishganesan622]

Agreed

[@jmoney5705]

aye bro that was so helpful thank you

[@olivermackenzie8022]

this guys blessed

[@Anonymous-zw8ql]

Thank you!

[@joshemman]

Thank you so much! Much appreciated.

[@zakikrey3816]

thank you, GREAT VIDEO!

[@karthickganeshramakrishnan4448]

Excellent!

[@raahatkhizer1559]

Very useful! Thank you :)

[@Claudia-lq3ns]

This was very helpful. Thank you! 🙏⭐️

[@derejehordofa4557]

great job

[@mercyshimray8637]

My Professor gave this lecture in 1 hrs 45 min and left me so confused, you did an exceptional job in just 7 min. Thanks so much, keep it up!!

[@joshemman]

Glad it was helpful!

[@durgapshibu-lm5xr]

are you a management student?

[@mercyshimray8637]

@@durgapshibu-lm5xr - No i am a working professional , undergiong a management course.

[@RainbowPaint]

Very helpful thank you so much!

[@pulkitthakuriya2686]

Thank you for the video
tomorrow is my exam and it is really helpfull

[@bobbobbysman]

Another great explanation, you never let me down Joshua! Thank you so much for your no nonsense tutorials.

[@danielyin969]

you are much better than a top b-school professor in teaching

[@appspare]

Thank you!
You save my life from tomorrow's final exam

[@mariam4174]

the best explanation, thank you so much.

[@anniemeee6796]

Thank you so much for this ❤️ This is more easy to understand than my online class’ instructor.

[@squirtle9990]

This is the first video I found from you and I’m impressed. This was super clear and you made what my prof explained in 2 lectures sound super easy..

[@redandgreenchristmasblues23]

your explanations are consistently elegant; you are an exceptional teacher. thank you!!

[@joshemman]

You're welcome. Thank you!

[@nishivasnik2838]

Thank you so much!!!!!!!!!!! I really needed this for exams, you explained it so well and easily.

[@anuradasenaratne5252]

beautiful man , thank you

[@thegprint_zm]

The < and > where are they coming from? How but if they are five

[@sartaajs]

Simply brilliant ! You summarized the entire chapter beautifully and with clarity Keep up the good work.

[@joshemman]

Thank you! Will do!

[@nikitadas9671]

best video i've seen today

[@iim-insidershow]

Wow, thanks

[@arnav3642]

Your videos are outstanding: crisp, articulate and easy to understand. Thanks a ton.

[@joshemman]

Thanks, Arnav.

[@sasideepbillakurthi57]

good explanation

[@sorahime06]

thank you.

[@retiredheadmaster2765]

love this

[@peppa2747]

perfect

[@varunsingh94]

Brilliant

[@ytbwatcherrr]

This video explains so well the characteristics of the sensitivity report ! Thanks to share your knowledge and your time!

[@luffydragneel5635]

this is art

[@EngineeringHooksets]

Thanks!!

[@dbxonthebeat]

thanks man! saved a lot of time with this :)

[@vickyrodriguez6668]

How do you identify if something is basic or non basic ?

[@raymond5259]

Amazing video, thanks Joshua

[@joshemman]

My pleasure!

[@bhaskarkolloju7851]

Explained nicely, this covers most of the scenarios what one needs to know in sensitivity analysis. Thank you.

[@monikakoritarova7685]

Finally I can say that I understand how LP Sensitivity Analysis works :D Thank you for this great video!!!!

[@priscaomugbe849]

Best video I have seen on this topic.

[@robertoperez4029]

Thanks!

[@joshemman]

Thanks for the SuperThanks, Roberto.
Much appreciated.

[@MHF-go9sd]

Amazing video, thank you. I coudn't understand sensitivity anlysis before watching this

[@DanielBogdanski]

Awesome explanation! Much appreciated, thank you!

[@thesachin1234567]

excellent video (y)

[@tarekh0]

This guy does a fantastic job with his youtube mini-lectures! Keep uploading!

[@mattsmith107]

THANK YOU! for making it easy to understand.

[@humaidshahid2467]

AMAZING! THANK YOU

[@joshemman]

Thank you too!

[@ekegodswill5130]

Please how can I find the upper bound and the lower bound values from the report

[@ericscorner9484]

hi just for asking
how to change the optimal solution at the time 1.54

[@riomorder]

finally I got it, my stupid professor had
complicated so much this part

[@HerbalSpirit]

thanks Joshua for making complex things easy . you are a magician

[@joshemman]

You're welcome, friend.

[@phd-prospect7294]

Imma hitting a subscribe button ASAP

[@jonasherman9195]

Very clearly explained! Thanks!!

[@chanavii]

How to equate allowable range

[@adityareal32]

bro...............u r so gud at this......lots of love