Chapter 6 - Integer Programming (Part 1)
Chapter 6 - Integer Programming (Part 1)
Chapter 6 - Integer Programming (Part 1)
CHAPTER 6:
INTEGER PROGRAMMING
(PART 1)
nzah@utm.my-20232024(S1)
• When the decisions variables are integer, we have integer programming problem.
o Pure integer programming (IP)- All decision variables required to have integer solution values.
o Binary integer programming (BIP)-All decision variables required to have integer values of zero or one.
o Mixed integer programming (MIP)-Some of the decision variables (but not all) required to have integer
values.
2
Integer Programming Model
3
Example 1
§ Machine shop obtaining new presses and lathes.
§ Marginal profitability: each press $100/day; each lathe $150/day.
§ Resource constraints: $40,000, 200 sq. ft. floor space.
§ Machine purchase prices and space requirements:
Required Floor
Machine Purchase
Space
Price
(sq. ft.)
Press 15 $8,000
Lathe 30 4,000
§ How many of each type of machine to purchase to maximize the daily increase in
profit?
4
Example 1 (cont’d)
𝑥1 = number of presses
𝑥2 = number of lathes
Integer Programming Model:
Maximize 𝑍 = 100𝑥1 + 150𝑥2
Subject to:
8000𝑥1 + 4000𝑥2 £ 40000
15𝑥1 + 30𝑥2 £ 200
𝑥1, 𝑥2 ³ 0 and integer
5
Example 1 (cont’d)
§ Optimal Solution:
Z = 1,055.56
𝑥1 = 2.22 presses
𝑥2 = 5.55 lathes
6
Example 1 (cont’d)
7
Integer Programming using Excel Solver
8
Integer Programming using Phython
9
Integer Programming using Python (cont’d)
10
Integer Programming using Python (cont’d)
11
Exercise 1
A textbook publishing company has developed two new sales regions and is planning to transfer
some of its existing sales force into these two regions. The company has 10 salesperson available for
the transfer. Because of the different geographic configurations and the location of schools in each
region, the average annual expenses for a salesperson differ in the two regions:
§ The average is $10,000 per salesperson in region 1; $7,000 per salesperson in region 2.
The total annual expense budget for the new regions is $72,000. It is estimated that a salesperson in
region 1 will generate an average of $85,000 in sales each year, and a salesperson in region 2 will
generate $60,000 annually in sales. The company wants to know how many salesperson to transfer
into each region to maximize increased sales.
12
Example 2
§ Recreation facilities selection to maximize daily usage by residents.
§ Resource constraints: $120,000 budget; 12 acres of land.
§ Selection constraint: either swimming pool or tennis center (not both).
§ Data:
13
Example 2 (cont’d)
Binary Integer Programming Model:
14
Example 2 (cont’d) Binary Integer Programming Model – in Excel Solver
C5*C12+D5*C13+E5*C14+F5*C15
15
Example 2 (cont’d) Binary Integer Programming Model – in Excel Solver
16
Example 2 (cont’d) Binary Integer Programming Model – in Python
17
Example 2 (cont’d) Binary Integer Programming Model – in Python
18
Example 2 (cont’d) Binary Integer Programming Model – in Python
19
Mix Integer Programming Model
In a mixed integer model, some solution values for decision variables are
integers and others can be non-integer.
Example 3:
Nancy Smith has $250,000 to invest in three alternative investments—condominiums, land,
and municipal bonds. She wants to invest in the alternatives that will result in the greatest
return on investment after 1 year. Each condominium costs $50,000 and will return a profit of
$9,000 if sold at the end of 1 year; each acre of land costs $12,000 and will return a profit of
$1,500 at the end of 1 year; and each municipal bond costs $8,000 and will result in a return
of $1,000 if sold at the end of 1 year. In addition, there are only 4 condominiums, 15 acres of
land, and 20 municipal bonds available for purchase.
20
Example 3 (cont’d)
𝑥1 = condominiums purchased
𝑥2 = acres of land purchased
𝑥3 = bonds purchased
Maximize 𝑍 = 9000𝑥1 + 1500𝑥2 + 1000𝑥3
Subject to:
50000𝑥1 + 12,000𝑥2 + 8,000𝑥3 £ 250,000
𝑥1 £ 4 𝑐𝑜𝑛𝑑𝑜𝑚𝑖𝑛𝑖𝑢𝑚𝑠
𝑥2 £ 15 𝑎𝑐𝑟𝑒𝑠
𝑥3 £ 20 𝑏𝑜𝑛𝑑𝑠
𝑥2 ³ 0
𝑥1, 𝑥3 ³ 0 𝑎𝑛𝑑 𝑖𝑛𝑡𝑒𝑔𝑒𝑟
21
Example 3 (cont’d)
22