Excel Solver - Sensitivity Analysis

New Contributor

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?

3 Replies

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

 

 
 

Solver.JPG

 

Cheers

 

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 

You are welcome

@ammesaros