Forum Discussion

ammesaros's avatar
ammesaros
Copper Contributor
May 13, 2020

Excel Solver - Sensitivity Analysis

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. ...
excel
wumolad's avatar
wumolad
Iron Contributor
May 13, 2020

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

 

ammesaros's avatar
ammesaros
Copper Contributor
May 13, 2020

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 

Resources