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. Is there a solution for this?

excel
  • wumolad's avatar
    wumolad
    Steel 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