Set Covering And Location Assignment Model (Learn under DR. TAN CHIN LUNG).xlsx

	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2		Potential hub
3	City	AT	BO	CH	DE	HO	LA	NO	NY	PI	SL	SF	SE
4	AT	1	0	1	0	1	0	1	1	1	0	0	0
5	BO	0	1	0	0	0	0	0	1	1	0	0	0
6	CH	1	0	1	0	0	0	1	1	1	0	0	0
7	DE	0	0	0	1	0	0	0	0	0	1	0	0
8	HO	1	0	0	0	1	0	1	0	0	0	0	0
9	LA	0	0	0	0	0	1	0	0	0	1	1	0
10	NO	1	0	1	0	1	0	1	0	0	0	0	0
11	NY	1	1	1	0	0	0	0	1	1	0	0	0
12	PI	1	1	1	0	0	0	0	1	1	0	0	0
13	SL	0	0	0	1	0	1	0	0	0	1	1	1
14	SF	0	0	0	0	0	1	0	0	0	1	1	1
15	SE	0	0	0	0	0	0	0	0	0	1	1	1
16
17		AT	BO	CH	DE	HO	LA	NO	NY	PI	SL	SF	SE
18	Decision variable	1	1	0	0	0	0	0	0	0	1	0	0
19
20	Objective, Min (No. hub)	3
21
22	Constraint	LHS	Sign	RHS
23	AT	1	>=	1
24	BO	1	>=	1
25	CH	1	>=	1
26	DE	1	>=	1
27	HO	1	>=	1
28	LA	1	>=	1
29	NO	1	>=	1
30	NY	2	>=	1
31	PI	2	>=	1
32	SL	1	>=	1
33	SF	1	>=	1
34	SE	1	>=	1
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100