WUWU Problem1 Manufacturing Plan Plant - DC

Mfg Plan Prod 1 Prod 2 Prod 3 Total ATL BOS

Objective Function Chicago 125 200 50 375 0 375
$ 6,525.00 Dallas 100 25 75 200 125 75
Miami 0 0 75 75 75 0

Plant to DC
C_A1 C_B1 D_A1 D_B1 M_A1 M_B1 C_A2 C_B2 D_A2 D_B2
Dec Vars 0 125 100 0 0 0 0 200 25 0
Cost $/unit $ 6 $ 5 $ 4 $ 7 $ 6 $ 9 $ 6 $ 5 $ 4 $ 7

Supply Constraints for each Plant

Chicago 1 1 1
Dallas 1 1 1
Miami 1 1 1
Chicago 2 1 1
Dallas 2 1 1
Miami 2
Chicago 3
Dallas 3
Miami 3
Dallas ALL 1 1 1 1

Demand Constraints for each Region

NY 1
VA 1
PA 1
NY 2
VA 2
PA 2
NY 3
VA 3
PA 3

Capacity at Distribution Centers

ATL DC
BOS DC

Conservation of Flow Constraints at DCs

Atlanta DC 1 1 1 1
Boston DC 1 1 1 1
Atlanta DC 2 1 1
Boston DC 2 1 1
Atlanta DC 3
Boston DC 3
 Flow by Product DC-Region
Prod 1 Prod 2 Prod 3 NY VA PA
ATL DC 100 25 75 0 125 75
BOS DC 125 200 125 175 50 225

M_A2 M_B2 C_A3 C_B3 D_A3 D_B3 M_A3 M_B3 A_NY1 A_VA1 A_PA1 A_NY2
0 0 0 50 0 75 75 0 0 100 0 0
$ 6 $ 9 $ 6 $ 5 $ 4 $ 7 $ 4 $ 7 $ 8 $ 5 $ 6 $ 7

1 1
1 1
1 1
1 1
1 1

1
1
1
1

1 1 1 1
 -1 -1 -1

1 -1
1
1 1 1
1 1 1
 DCs to Regions
A_VA2 A_PA2 A_NY3 A_VA3 A_PA3 B_NY1 B_VA1 B_PA1 B_NY2 B_VA2
0 25 0 25 50 50 0 75 100 50
$ 8 $ 5 $ 7 $ 4 $ 4 $ 9 $ 7 $ 6 $ 3 $ 8

1
1
1
1
1 1
1
1
1
1

1 1 1 1 1
1 1 1 1 1
 -1 -1 -1
-1 -1
-1 -1
-1 -1 -1
B_PA2 B_NY3 B_VA3 B_PA3
50 25 0 100
$ 6 $ 4 $ 5 $ 4

LHS RHS
125 ≤ 200
100 ≤ 125
0 ≤ 50
200 ≤ 200
25 ≤ 200
0 ≤ 50
50 ≤ 50
75 ≤ 150
75 ≤ 200
200 ≤ 250

50 ≥ 50 50
100 ≥ 100 100
75 ≥ 75 75
100 ≥ 100 100
50 ≥ 50 50
1 75 ≥ 75 75
1 25 ≥ 25 100
1 25 ≥ 25 50
1 150 ≥ 150 75

200 ≤ 200
1 1 1 1 450 ≤ 500
 0 = 0
0 = 0
0 = 0
-1 0 = 0
0 = 0
-1 -1 -1 0 = 0
WUWU Problem 2 Manufacturing Plan Plant - DC
Mfg Plan Prod 1 Prod 2 Prod 3 Total ATL BOS
Objective Function Chicago 225 0 0 225 0 225
$ 6,625.00 Dallas 0 225 0 225 25 200
Miami 0 0 200 200 175 25

Plant to DC
C_A1 C_B1 D_A1 D_B1 M_A1 M_B1 C_A2 C_B2 D_A2 D_B2
Dec Vars 0 225 0 0 0 0 0 0 25 200
Cost $/unit $ 6 $ 5 $ 8 $ 7 $ 6 $ 9 $ 6 $ 9 $ 4 $ 5

Supply Constraints for each Plant

Chicago 1 1 1
Dallas 1 1 1
Miami 1 1 1
Chicago 2 1 1
Dallas 2 1 1
Miami 2
Chicago 3
Dallas 3
Miami 3
Dallas ALL 1 1 1 1

Demand Constraints for each Region

NY 1
VA 1
PA 1
NY 2
VA 2
PA 2
NY 3
VA 3
PA 3

Capacity at Distribution Centers

ATL DC
BOS DC

Conservation of Flow Constraints at DCs

 Atlanta DC 1 1 1 1
Boston DC 1 1 1 1
Atlanta DC 2 1 1
Boston DC 2 1 1
Atlanta DC 3
Boston DC 3

Data DC_ATLDC_BODC_ATL2 DC_BOSDC_ATL3DC_BOS3

Chicago $ 6 $ 5 $ 6 $ 5 $ 6 $ 5
Dallas $ 4 $ 7 $ 4 $ 7 $ 4 $ 7
Miami $ 6 $ 9 $ 6 $ 9 $ 4 $ 7
NY $ 8 $ 9 $ 7 $ 3 $ 7 $ 4
VA $ 5 $ 7 $ 8 $ 8 $ 4 $ 5
PA $ 6 $ 6 $ 5 $ 6 $ 4 $ 4
 Flow by Product DC-Region
Prod 1 Prod 2 Prod 3 NY VA PA
ATL DC 0 25 175 0 25 175
BOS DC 225 200 25 175 150 125

M_A2 M_B2 C_A3 C_B3 D_A3 D_B3 M_A3 M_B3 A_NY1 A_VA1 A_PA1 A_NY2
0 0 0 0 0 0 175 25 0 0 0 0
$ 6 $ 9 $ 6 $ 9 $ 4 $ 9 $ 4 $ 7 $ 8 $ 5 $ 6 $ 7

1 1
1 1
1 1
1 1
1 1

1
1
1
1

1 1 1 1
 -1 -1 -1

1 -1
1
1 1 1
1 1 1
 DCs to Regions
A_VA2 A_PA2 A_NY3 A_VA3 A_PA3 B_NY1 B_VA1 B_PA1 B_NY2 B_VA2
0 25 0 25 150 50 100 75 100 50
$ 8 $ 5 $ 7 $ 4 $ 4 $ 9 $ 7 $ 6 $ 3 $ 8

1
1
1
1
1 1
1
1
1
1

1 1 1 1 1
1 1 1 1 1
 -1 -1 -1
-1 -1
-1 -1
-1 -1 -1
B_PA2 B_NY3 B_VA3 B_PA3
50 25 0 0
$ 6 $ 4 $ 5 $ 4

LHS RHS
225 ≤ 250
0 ≤ 125
0 ≤ 50
0 ≤ 200
225 ≤ 250
0 ≤ 50
0 ≤ 50
0 ≤ 150
200 ≤ 250
225 ≤ 250

50 ≥ 50 50
100 ≥ 100 100
75 ≥ 75 75
100 ≥ 100 100
50 ≥ 50 50
1 75 ≥ 75 75
1 25 ≥ 25 100
1 25 ≥ 25 50
1 150 ≥ 150 75

200 ≤ 200
1 1 1 1 450 ≤ 500
 0 = 0
0 = 0
0 = 0
-1 0 = 0
0 = 0
-1 -1 -1 0 = 0