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?

[qgtjibi]

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.

[nikolu]

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?

[llillard]

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.

[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!

[yashverma]

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?

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

[dhanashreebadhe]

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

[AhmedShakir]

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

[umasreeram]

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

[danielyin]

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

[pm-dxfs]

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

[bobbobbysman]

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

[arnav]

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

[Jessica-uvlt]

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

[squirtle]

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

[fatmaahmed]

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

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

[sartaajs]

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

[anniemeee]

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

[cactusfroth]

this is so much better than the half hour that the lecturer uses to try and confuse us with. amazing.