Linear Programming Sensitivity Analysis - Interpreting Excel's Solver Report
HTML-код
- Опубликовано: 5 фев 2025
- 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.
LP Sensitivity in Excel 2: • LP Sensitivity Analysi...
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?
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.
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.
The best LP Sensitivity Analysis video that I have seen so far. Thank you so much.
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!
Me too!!!
how was the exa,m?
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.
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?
yeah, it's like schools today are trying to make sure you DON'T get any education.
lmao, you're funny
Your videos are outstanding: crisp, articulate and easy to understand. Thanks a ton.
Thanks, Arnav.
amazing! to the point, crisp and clear! Thank you so much Joshua!
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
I sat 4 hours trying to understand this, you simplified it in less than 10 minutes.....thank you!
Another great explanation, you never let me down Joshua! Thank you so much for your no nonsense tutorials.
This is a very useful video for people to understand the sensitivity analysis. Thank you for making such an excellent explanation video！
LP Sensitivity in Excel 2: ruclips.net/video/J52iRkbrG1k/видео.html
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! :)
your explanations are consistently elegant; you are an exceptional teacher. thank you!!
You're welcome. Thank you!
you are much better than a top b-school professor in teaching
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..
Brilliant! That was a better explanation than the 3-hour lecture I just saw on the topic. Great voice too!
Simply brilliant ! You summarized the entire chapter beautifully and with clarity Keep up the good work.
Thank you! Will do!
This video explains so well the characteristics of the sensitivity report ! Thanks to share your knowledge and your time!
this is so much better than the half hour that the lecturer uses to try and confuse us with. amazing.
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?
This guy does a fantastic job with his youtube mini-lectures! Keep uploading!
5 lacs, 3 months of lectures did nothing for me but this 7 min free video did it
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.
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!!
Glad it was helpful!
are you a management student?
@@durgapshibu-lm5xr - No i am a working professional , undergiong a management course.
this is the best instructional video i have ever watched . on point and straight forward. thank you so so so much joshua.
Thank you so much, I've been on this thing for 2 days, I didn't understand. Thank you once again
Thank you so much for this ❤️ This is more easy to understand than my online class’ instructor.
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
Very straightforward and helpful. Thank you from the bottom of my heart.
You're welcome!
I am going to pass midterm in 2 hrs from now becoz of u...god bless u
This is the best video explaining sensitivity analysis BY FAR. Thanks so much!!!
I have to give your right. This is the most excellent video ı have ever seen about researchıng methods lecture. Keep ıt up!
thanks Joshua for making complex things easy . you are a magician
You're welcome, friend.
Finally I can say that I understand how LP Sensitivity Analysis works :D Thank you for this great video!!!!
Thank you so much!!!!!!!!!!! I really needed this for exams, you explained it so well and easily.
You summarized 4 lectures !! Thank you ...
This is explained really well. Thankyou Joshua !
This was amazing, thank you so much!!!!! I was completely lost and now understands it perfectly.
This is known as TO THE POINT LECTURE. NO FANTASY WORDS AND JARGON OF TECHNICAL LANGUAGE.
Thank you!
You save my life from tomorrow's final exam
Best video I have seen on this topic.
This was sooooooo HELPFUL! You did great at clarifying the concepts and breaking down the Excel report/analysis! Great GREAT video- thank you!!!
Thank you SOOOO much. Your explanation so clear. This is much better the my lecture.
Explained nicely, this covers most of the scenarios what one needs to know in sensitivity analysis. Thank you.
Great video. Helped me recall my 3 years old knowledge.
Excellent explanation with visual presentation. You have made it easy to understand. Thanks.
Thank you so much. Finally, I can visualize all the terminology.
Excellent! 🙏
SAVED MY LIFE THIS WEEK
this the best so far that i have watched
Thanks buddy, couldnt find anyone else to explain allowable increase or decrease, I thought it changed the final value. Tyvm
bro...............u r so gud at this......lots of love
Amazing video, thank you. I coudn't understand sensitivity anlysis before watching this
best video i've seen today
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:)
Couldn't have explained any better! Perfect! Thanks a lot
Brief, to the point and very well structured! Thank you, Mr. Emmanuel! This was really helpful!
Exceptional video. I feel so much more ready for my test tomorrow. Thank you Joshua!
Thank you, it really helped❤
You're welcome 😊
you are a exceptional professor, you simplified the content exceptionally well, pl. uploading more such videos
Last minute saviour 💫
Really appreciate your efforts and you covered all the important points.
You really helped a lot and saved many people. Keep making such an exciting videos.
thank you! you just saved my final exam grade!
Best video I've seen! Thanks man!
Clear and crisp...great video
Dear Joshua: excellent video! very well explained and a very clear english pronunciation!
Thanks for this video, I found it very useful.
Thank you for the video
tomorrow is my exam and it is really helpfull
super helpful N really helps me understand for my exam tomorrow
the best explanation, thank you so much.
This was very helpful. Thank you! 🙏⭐️
This is just the best explanation 🎉
Awesome Joshua, Very comprehensive explanation
i love you sir !!!!!!! you made my life easier
You're welcome, Khushi.
Amazing!!! You taught soo well!! Thank you!
good explanation
a well-built efficient explanation. Thank you!
Nice explaination of basics. Thanks Joshua Emmanuel.
you saved my exam tmr.
Glad to hear! 😄
you helped me with 15 marks, my test was of 50 marks, thanx man , waiting for the results
Crisp and comprehensive!
Such a succinct and brilliant video. Bravo!
Thank you Joshua, this explanation was very clear!
THANK YOU! for making it easy to understand.
This was supremely clear and helpful!! Thank you!
Thank you for your clear explaination !!!!! I have sloved my long term problem with sensitivity report interpret!!!!!
You've saved my MCQ🙌
Great explanation, Joshua. Thank you.
Bro, you just saved my life
thanks man! saved a lot of time with this :)
Such a great video. Awesome job!
this is art
Thank you so much, know I will perform good in my practical exam
Amazing video, thanks Joshua
My pleasure!
You're awesome Josh, keep it up and thanks for your effort!
Very clearly explained! Thanks!!
Impressive explanation now i really understand the sensitivity report
You teaches better than my teacher....
Thanks man, I wish you are my Professor.
you are my new favorite..