Excel Solver - Sensitivity Analysis

[ammesaros]

Hi friends! I am working on a linear optimization programming problem for school. I need to perform a sensitivity analysis on my models but the option is not coming up where it should under reports. Is there a solution for this?

[#2]

Hi @ammesaros 

I understand sensitivity report is not available if you have an integer constraint. A sensitivity analysis can be performed only for models with continuous variables.

Try and check Ignore Integer Constraints checkbox under Solver Options and see if it works

Cheers

[#3]

This did help but unfortunately, it changed the optimal solution. It will be good enough to show our professor though. Thank you so much. @wumolad 

[#4]

You are welcome

@ammesaros

[#5]

HI, I have the exact same problem, did you solve it?@ammesaros