MinimizingOperatingExpenses.xlsx

	B	C	D	E	F	G	H	I	J	L	M	N
1
2
3
4
5
6
7
8			Per unit Dist. Cost from DC to Retail Region
9	Potential DC Location	Fixed Costs if DC opened	East	South	Midwest	West	DC Capacity		Fixed Cost
10	New York	$ 6,000.00	$ 206.00	$ 225.00	$ 230.00	$ 290.00	150		$ 6,000.00
11	Atlanta	$ 5,500.00	$ 225.00	$ 206.00	$ 221.00	$ 270.00	150		$ 5,500.00
12	Chicago	$ 5,800.00	$ 230.00	$ 221.00	$ 208.00	$ 262.00	150		$ -
13	Los Angeles	$ 6,200.00	$ 290.00	$ 270.00	$ 262.00	$ 215.00	150		$ 6,200.00
14		Demand in each retail region	100	150	110	90
15
16		Dist Cost	$ 20,600.00	$ 30,900.00	$ 27,220.00	$ 19,350.00
17
18	Objective: Minimize Total Cost
19	$ 115,770.00
20
21	DVs: Locate a DC in this city?					Big M	100000
22	New York	1	Constraint: These are binary
23	Atlanta	1
24	Chicago	0
25	Los Angeles	1
26
27	DVs: How many units?						Constraint: Can't have more units than capacity			Constraint: Only can assign DC to a city if an DC exists there!
28		New York	100	0	50	0	150	<=	150	150	<=	100000
29		Atlanta	0	150	0	0	150	<=	150	150	<=	100000
30		Chicago	0	0	0	0	0	<=	150	0	<=	0
31		Los Angeles	0	0	60	90	150	<=	150	150	<=	100000
32
33		Constraint: Satisfy Demand
34			100	150	110	90
35			>=	>=	>=	>=
36			100	150	110	90
37
38		Constraint: Every region needs to be assigned a DC
39			100	150	110	90
40			>=	>=	>=	>=
41			1	1	1	1
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