Linear Programming Sensitivity Analysis with Excel Solver: An Amusement Park Example

Рет қаралды 26,280

3 жыл бұрын

Enjoyed this content & want to support my channel? You can get the spreadsheet I build in the video or buy me a coffee! Links below:
Buy me a coffee: www.buymeacoffee.com/tallysyunes
Buy complete spreadsheet: www.buymeacoffee.com/tallysyu...
Buy me an item from my wishlist: www.buymeacoffee.com/tallysyu...
If you're not familiar with Excel Solver's sensitivity report and basic sensitivity analysis concepts like shadow prices and reduced costs, watch this video first: • How to Read Excel Solv...
The purpose of this video is to give you more practice with reading and using Excel Solver's sensitivity report to answer certain types of what-if questions.

Пікірлер: 10

@sarahalgurashi8526 3 жыл бұрын

Thank you, both videos were very helpful to understand the sensitivity report.

@TallysYunes 3 жыл бұрын

You are welcome!

@Darkdivh 2 жыл бұрын

I have an exam from Operation Research next monday and your videos are helping me a lot to prepare, thank you Mr. Yunes

@TallysYunes 2 жыл бұрын

Awesome! Good luck with the exam!

@anggunamalia753 7 ай бұрын

Terimakasih banyak bapak

@TallysYunes 7 ай бұрын

You're welcome!

@mihaelazeger5705 2 ай бұрын

Hi sir, Can you tell me which video to watch to know how to model this problem in excel so I can solve it and follow through this video? Thanks in advance!

@TallysYunes 2 ай бұрын

I don't have a detailed video on that, but at the beginning of this video I show you the mathematical formulation and the setup of the Solver window (you can pause the video at that moment and look at what I did). The formulas in column F and in cell B12 are all the same: a SUMPRODUCT. If you watch and understand the Farmer Problem example I have on this channel, you should be able to do this one.

@Luna.93 2 жыл бұрын

Is anyway to do this analysis on Google Sheets?

@TallysYunes 2 жыл бұрын

I've never used the Solver in Google sheets, so I'm not sure if it provides a sensitivity report as an output. But you can probably....wait for it....Google this :-) If the report is provided, what I explain about reading the report and how to use the numbers still applies.