Chapter 6

Integer Programming: Binary Choice Models

An integer programming model is a linear program with the requirement that some or all of the decision variables must be integers. In principle, we could distinguish between linear and nonlinear programs with integer variables, but the latter are extremely difficult and generally beyond the capability of Solver. We focus on the role of integer variables in what would otherwise be linear programming models. Thus far, we have not paid much explicit attention to whether the decision variables take on integer values. In Chapter 3, we pointed out that in special network models, integer solutions are guaranteed. In other cases, we often encountered integer solutions without explicitly requiring integers, so there seemed to be no need to discuss integrality. In still other cases, we seemed to be content with fractional solutions, especially when the decision variables were scaled. In this chapter, the role of integer values takes center stage.

This chapter first describes how Solver handles integer programs. Next, we explore the basic capital budgeting model as a way of introducing binary variables and developing some intuition for the effects of integer requirements on decision variables. Then, in the remainder of the chapter, we look at models characterized by binary choice. In these optimization models, all decisions are of a yes/no variety. Other uses of binary variables are covered in the next chapter.

Before we discuss how to ...

Get Optimization Modeling with Spreadsheets, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.