# Can sensitivity analysis and limits report be done on an BILP problem?

I am not that experienced with Operations Research yet. I have become familiar with what Sensitivity Analysis and Limits Reports are in general and through the use of Excel.

I know that they can only be performed by Excel on non integer variable problems, but I read somewhere online that you can also do it on Integer Linear Programming models.

I'm curious to learn whether they can be done on an ILP problem with binary variables. From what I understand, sensitivity analysis the allowed reduction or augmentation of a variable's value, as well as does the same for the constraints, whereas limits report gives us the upper and lower limit of the objective function's values. But the first one seems to not be feasible since our variables will either be 1 or 0 and I'm unsure how the same can be done on the constraints and as far as the second one goes I'm clueless as well.

So, can we apply those two on a BILP problem or is the nature of the problem not allowing us to?

• Sensitivity analysis relies on dual variables, which you can only access when variables are continuous. Jan 7, 2023 at 12:59
• I never head of Limits Report before, but I'm not an Excel solver user., so thanks for posting and getting me to google it. Per solver.com/excel-solver-create-solver-reports "If Solver finds a (locally or globally) optimal solution, and there are no integer constraints, two additional reports are available: the Sensitivity Report and the Limits Report." So Excel solver will not produce these reports if there are any binary or integer variables. Binary variable is an integer variable. I'll let other people answer what can be done and how when there are binary or integer variables. Jan 7, 2023 at 16:01
• @Kuifje Thank you!
– Tita
Jan 7, 2023 at 17:33
• @MarkL.Stone Thank you for your input!
– Tita
Jan 7, 2023 at 17:33