Integer Constraints in Linear Programming

Basics of using integer constraints in Linear Programming with Solver.

[dsci]

Sensitivity analysis requires extrapolation. When you impose an integer constraint the decision variables are step functions, not straight lines, so the slopes toggle between zero and infinity and no extrapolation is possible. That doesn't mean you can't do sensitivity analysis on your own, it just doesn't fall out of the Simplex algorithm used in Solver.

[spaces]

Thank you. You saved me. I had no idea how to approach this.

[codygleason]

Thank you. The ignore integer constraint check box was what I was missing, and why I could not get the solution.

[donjr]

Hi sir, would you be kind enough to explain why Sensitivity Analysis would not be generated if there are integer constraints? Don't quite catch that still... Appreciate if you could :)

[gracelks]

How if the constraints for each items must be at least 5

[daniellerosales]

What formulas were used for the yellow cells?

[edgarchang]

Hi Sir, can I ask for excel files. Thanks