Input
Output
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnEAABJxAfPceo4AAAASdEVYdFNvZnR3YXJlAEdyZWVuc2hvdF5VCAUAAA0cSURBVHhe7Z3fjhXHEYf9Bs4bxG+A38B+A/sN7DdI3sBccYcSKXBhCQkuLPliibGEfcNeJGKvFiFhNgoKijFai+BVEPJCIrAlS+TbU72V2uo/02dn5uyedX1qjU7XVPd0D1O/qZ4zZ3nrTRAEwUoIuQmCYEWE3ARBsCJORm7+8uQ/Nx7tp0qwDjx58uTu3bu7u7upHgTLs2q5efzi5/e/+PatP31DSaZgHQi5CcazUrm59+zVbz79m2jNsnLz40+/nN/eQ6oQrGQKVkjITTCelcrNJ9s/qNYsJTdWp1iIJWuwQkJugvGsh9y8/emOtgq5ORFCboLxrIfc2FYhNydCyE0wnpCboIuQm2A8ITdBFyE3wXhCboIuQm6C8YTcBF2E3ATjGZCbH3/65Y/fPPt48/v3v/jWvjJDeffzh9jZe+/Zq+Q9xMnKDeM8v733+9v/Yi5s+fzloxdpXzBEyE0wngG5+eCr72yo18o71x4QwIMv4C0lN3+49290gYKu2VZoHEphy6AAXX3w3GmlFuz0gKom1xLs/euT/0pJpsXvMES5RLySdQG71L/ds6JNrHbzWftJpgp2hDO9BhlyE4xnQG4+2tx18dkohG5qVmEpubGe7fLen/+Z2mQQh06tigWfhi5YzUUE8URi1CIluS6wdk5gstZBDdX/t9f+nqxH3zb63e0nyZrh5thzxGMQchOMZ0BuuOty0RPPhBxiYQsWGw9S2okGraxzslawnu3SkJtzn/8jd5bi7ERsapNhnZl1nii5AVh5GpRgsIPkFCXrIr9TO6V2blEi67bW2c3+/j6HAD4kU5PXr1+LPyRTnU43RQbDIVJ9wbKd7O3tuU7EwjbVSxR9BluBjNmdPSzWKNUexH9Cxj4qdgoyodzkSlErNkQt7nBUbQrDZxeotX5ybXLFJRQ3Hu3bve3fvqMO1tmJhT0JrFjzFIwTrg6U2hTGM6vcEAk3b968fPnyBQPVzc1NF+0Cxq2trStXriTXQ7Ds7OwkpwzxuXXrVqo3efjwofi7KYuR0aZ6k9u3b4u/7eSzzz7DwjbVSxR9Fj1duH//fqqXkCOyTfUF0lCNUu1BTsLFixcbMscucb5z504y1RkrN+5yn1BulKUOobgwJlNIO45iFYd4Ttaj5HJDWofEMJJ7z16xzVWANZE6t1c3NoVxWRLQv+6luCUVx2XMuhdtSjtmYD65IX7kei3Ctc5Fn1wXcH1jTLsXEJbWgugUwyPtvnBhMEeAS5cuiXNRbmDwVKCJOqoJ5aYd/NPKDc6Dox10sJxZubE6Yh+IOIhYdaMUO3dyQ1TbB7pFXN6U65Fihenqg+fJanAnzY7QHWVwVGOYSW64JS4u7AOIBxtIHIskAvvGxkYyHdUa9lp/UiR6kL3FmJRWMBgbVgFrcjPYiUS+MKHcAHpaTPpADqrKIkgrZ1QYmzgU/3E5q7K3mFXpiWoooOXMyo19rlRLbQSrJowwWQ3WgW57otrlVkUdAZu80HNNlYpLKndaiiOfkDnkhmtULtbGHRu7DS1dQLmUR8FfFAfPZDoEo0pVYyKalUiC4zwXrVM/jXVNo5ORciPd1lZzk8sNSJ+sbZ3G6Rw716dwNuXm2KP64KvvktVg5SZf79SwGlHsFmx60lhzuenIksr2T4rUSKAmYQ65kaCCznuj3ktrkSNo/Dg5ECOxwZbgSdYMiS7cZHhuygddLAbAttGJ5GVs806KUuIo+mABPQlFsZOBufMj/rWTpqer8Y8roul6kGOhOE6GGpxNuXHf6SRrBTuqopocT27s19uUohzYFKw9L7du+vDrx7bac05GMrncaJZeu1HnSGrTc303wlXvycVwlb1yCOmkKDfaSTGGZWo48CHvpDg2R9EHC/BBtAxymRYJcKMS5+JQoUdu1IcZiUX/+WppZpGzKTdkCrZJslaYSW7QF21FyddT9gusxtMlgd7sUx5bJNmZm8nlRu/SndcrES7+PfKkj4RSfYFaGrdliWSJzFwp4KCLRScy/mN0UpQSR9EHC/CBI4ry5gscmZpTlkW7UXIDGxsb+Fy/fl2qPbPI6ZIbrvUvH704v73HTVXeo9XiXqI7JXJjBYLixuyK/XJnQrkBq3ocKFkPsXt7JMOdBykrWEYJk8uNBAZ0rqQ0KmphYymGkFjkc3F1IHdsdkkMS0S5KR90cbQT9+RCU5taJz2BWvTBAvJZH1Fp/AtyVt28Fu3Gyg3zkiPipk002elkQG4ev/j5483v3SXeKKdTbvrLtHLjXsCx79S43Me9blPDLakoK/sPLeaTm1QfQi/xWthY1NkOWCzyWXMTGzByA9dFVq4UcNDFYSd6FNuJtNKXUPJOilLiKPpggVSpPMmSs+pOUe5mKZ6rIpIzMioZXs8/hKMlN+T/tZ8a1coccuMegswqN8XntceWG7ArIPsFmZ3Uue73ZZzy9ryyPBXzyU3nHVKjoucqL4aQWFLlMKR1aSZNSFikCuLgpnzQRdaJphg9nYiFbaqXKPpggVRZII+9QfuXs+pOkfjUzpuMGdxMi+g3g5oDLkVVbrjfOq0hKtALCndUrnst1odqal/ieHLjWrUPIViBYNg61MGS2h9ljNzYwdvfSdg+88c6NZiLtpJC/2nfzMwnN519snwQ/x65kddhwWqZWFLFhJms5mq64Ia3aPH/TnRU4iZNND+CWrdsU71E0QcLpMoh7vH53HKjJ3apJ8RKVW7sD3/aL5uoG6UWscKJyM34FGCM3LgXcGTR5IydD1/cedAy69t9yuRyoxduj3wI8qwkf6EmR277NsuAxdGOhKusnohqWZi48JaYd1M+6OJoJ/JgGGeJ28FO9KCpXkJaOR8skCqHoKfySEVOy9xys5RzTlVu7AXdfk3Oep5CuaEk63EZIzdgm8uZtN/TN163sdgXAl1p/Lh0QiaXG5A4aby94pDAHrzWuc9Lz7pQEqRtqiwgVsUo/u6hda4UsHD3nehE2Dr/vBNRBJqkegkR1qJqpIpBhRuRXUu5IaTtBd2O8H7PlcmNazLyu5uRcmMf08jPsuyaqPNZr21CsuleLGK+yW825pAbiQ2oRYJD1YE7eePBgaqSXUmBGFPlEH384bQJOuUGdCIuH4G8E11/2TWXRUPayZ8YU+UoOgtZW6233CRrBeu5lNwcbxHRIzdu/P0PR4qMlBumaV/ns+oz+LqN4MRFUiQ7KsrcS6o55EbTEKj9nphAskKggU1cOTUBOrx+/bo45B2KPVUOkTFA3lu/3CzbiRjxz88nEoOdvblyHRy4IjcgfQrrLTftCO/3PIZwgAu2nnTAfc2cv/OyFCPlBtxrh1p6Xrdxz+x1ANitis29pJpDbkCjC1iMoBEcQuCzLE9cGGvyAojL1tYWqwm22LWrPFUB2ZUqBsQCUsXQLzewVCdMR4fKFHZ2dhYz3t3c3BQje11qA7IrVTI4uva5ZnLjnhQ0sgP31LOtIPbGTul8bOG0r7OVi/AxCc54uXFT0CJPjtvYo6Mvtkkx65mJmeQGiCtZAhQhXPPAYxkiTzdysNcWKeKQKh0sJTc1ip1AY9ZMIZ8yyN5UKaFasGZyA/bO+c61B3lgIEn5G4DcY+XvB5NQ5BGeP+/EU3omH5EXl/NFgVM0iv5dZLb9rXArLt8ahxbGyw3kP0E41/G6jROU/BmNHRtJkJyWOZhPbgQyFFISgpNbNPHGB5ZR7cPRhBDa2NjAmS2fsaR9JXCDVOmAAeDvIn+SThSUkZGL7jBrPte0EnoOzRnIO5GGtZ4ZmzjUBmlZyjmnKjf5C6woiPwHBh9+/di++F8rxW+gaz/80TL4m+xiKS4l3NpNCp4yEflBhp1IbT0yidzkgxlMuNAOu4wqypNT1ZHLxgZzy03wa6AqN9zzB6WBgk9DC/J8obas0FIUqTwtyktyPUrtoUmtFNOfSeQmz7aKx7K4E1tLvpyQzbSkCrkJxlOVG+D6zl9jtYUMiJghkOzKS4t70KBwVy/6S6n9aZgbj/YbrRoLkzxNa5TigCeRG7D9DD6Bcs+50JS0o4T9Z5ppSRVyE4ynJTcC1z0SoJkOMU/YcAu1N2c+Ez/qw9VPkDcuevzpgW7pSjqkEFG1G7hQbMWBBr+rYiQMr6FWjLwxYAYmbdkOroAaMHI94uCYmalMUOaYrBU4b+pMaZ/G4xFyE4xnWG7OEsQhcY58SCGkWdzNkQvkcBTVGmQrWdeHkJtgPL8uuTlB7JpuMFs5hYTcBOMJuVkFLAPtd0yryaemJeQmGE/IzSpg4aZa896Ih80nSMhNMJ6Qm9m59+yVTW3aL16fWkJugvGE3MwIa6jz23tWa9Y0tYGQm2A8ITcTg6AgK+8e/YvxUt6u/8d1p5+Qm2A8ITcT4yRGC1ozx+swKyPkJhhPyM3EOJWR8tHm7vrmNULITTCekJuJ0fee2X6y/cPVB8/X8WvvnJcvXz59+jT/81FB0E/ITRAEKyLkJgiCFRFyEwTBSnjz5n+Bsg0wC+hiuAAAAABJRU5ErkJggg==
Weekly Challenge #14
A retail chain has 25 stores carrying variety of items. Not every store carries the same items and each has its own level of prioritization within the chain and different required stock levels. There is a central warehouse that contains all of the available items.
The Goal:
Distribute items from the warehouse to each store, filling the available stock at each store in order of the store's priority.
C:\Users\SYLVIA~1\AppData\Local\Temp\Engine_14564_c8f88656dbfd43dfa2c63fd440a4881e_\Engine_21060_812079683dc5425da54676bff7734b3c_.yxdb
Single
Profile
Main
1
824
Main
2
1145
Main
3
1354
Main
4
916
Main
5
1120
Main
6
635
Main
7
1056
Main
8
824
Main
9
616
Main
10
679
Warehouse
A
1
47
A
2
29
A
3
50
A
4
12
A
5
19
A
6
72
A
7
71
A
8
2
A
10
40
B
2
46
B
3
36
B
4
7
B
5
48
B
6
71
B
7
19
B
10
4
C
1
34
C
2
52
C
3
66
C
4
17
C
6
3
C
7
57
C
8
77
C
10
13
D
2
1
D
3
76
D
4
46
D
6
21
D
7
40
D
10
41
E
1
44
E
2
14
E
5
75
E
6
32
E
7
14
E
8
76
E
10
42
F
1
71
F
2
28
F
3
46
F
4
54
F
5
9
F
6
52
F
7
43
F
8
33
F
9
59
F
10
16
G
1
60
G
2
2
G
3
51
G
4
66
G
5
47
G
6
28
G
7
66
G
9
30
G
10
55
H
1
11
H
2
69
H
3
5
H
4
41
H
5
54
H
7
28
H
8
57
H
9
17
H
10
36
I
2
6
I
4
73
I
5
43
I
6
3
I
7
70
I
8
70
I
9
16
I
10
17
J
1
71
J
2
35
J
4
5
J
5
79
J
6
9
J
7
38
J
9
55
J
10
72
K
1
44
K
2
13
K
3
63
K
4
73
K
6
62
K
7
61
K
8
20
K
10
25
L
1
26
L
3
10
L
4
35
L
5
62
L
6
16
L
7
73
L
8
35
L
9
78
L
10
33
M
2
12
M
3
23
M
4
55
M
5
46
M
6
9
M
7
4
M
8
8
M
9
76
M
10
60
N
2
9
N
4
29
N
5
12
N
6
4
N
7
36
N
8
3
N
10
8
O
1
15
O
2
35
O
5
30
O
6
43
O
8
78
O
9
48
O
10
64
P
2
60
P
3
33
P
4
5
P
5
9
P
6
27
P
7
62
P
8
71
P
9
30
P
10
50
Q
2
22
Q
3
32
Q
4
11
Q
5
4
Q
6
46
Q
7
69
Q
8
46
Q
9
12
Q
10
53
R
2
76
R
3
15
R
4
13
R
5
69
R
6
41
R
7
49
R
8
50
R
10
9
S
1
23
S
2
9
S
4
27
S
5
31
S
6
31
S
7
17
S
8
69
S
9
53
S
10
21
T
1
19
T
2
66
T
3
76
T
4
56
T
5
78
T
6
53
T
7
62
T
8
2
T
9
12
U
1
71
U
2
54
U
4
3
U
5
54
U
6
3
U
7
48
U
8
6
V
1
65
V
2
30
V
3
4
V
4
12
V
5
50
V
7
37
V
8
10
V
9
76
W
1
76
W
2
68
W
3
10
W
4
48
W
5
65
W
7
60
W
8
15
W
9
31
X
1
8
X
2
49
X
3
57
X
4
23
X
5
25
X
7
39
X
8
45
X
9
68
Y
1
6
Y
2
47
Y
4
1
Y
5
26
Y
6
64
Y
7
33
Y
8
41
Y
9
33
Y
10
7
Z
1
60
Z
2
25
Z
3
39
Z
4
45
Z
5
75
Z
6
18
Z
7
18
Z
8
25
Z
9
2
Z
10
10
Store Requirements
C:\Users\SYLVIA~1\AppData\Local\Temp\Engine_14564_c8f88656dbfd43dfa2c63fd440a4881e_\Engine_21060_84e9cdb9fc264ed08195e0c7b32db884_.yxdb
Single
Profile
C:\Users\SYLVIA~1\AppData\Local\Temp\Engine_14564_c8f88656dbfd43dfa2c63fd440a4881e_\Engine_21060_8285f6a697a24ada8dfdf5fa51a94948_.yxdb
Single
Profile
A
26
Houston
TX
-95.562207
29.839187
B
4
Birmingham
AL
-86.625591
33.410321
C
25
Seattle
WA
-122.291399
47.603993
D
3
Detroit
MI
-83.255088
42.412144
E
5
Nashville
TN
-86.729174
36.135464
F
2
Chicago
IL
-87.597287
41.734
G
24
Lansing
IA
-91.228717
43.361018
H
1
Fayetteville
NC
-78.907738
35.024302
I
23
Miami
FL
-80.31047
25.792304
J
22
Tampa
FL
-82.539427
27.886595
K
21
Charleston
SC
-80.063175
32.931254
L
6
Los Angeles
CA
-118.386826
33.945722
M
20
Sacramento
CA
-121.40379
38.568865
N
7
Tucson
AZ
-110.845502
32.311728
O
8
Dallas
TX
-96.770293
32.84673
P
19
Austin
TX
-97.713678
30.19727
Q
9
Tulsa
OK
-95.861086
36.177745
R
16
New York
NY
-74.002527
40.734408
S
10
Baltimore
MD
-76.467296
39.3277
T
15
Portland
OR
-122.889658
45.563461
U
11
Philadelphia
PA
-75.171584
39.955317
V
12
Boston
MA
-71.066428
42.315352
W
13
Helena
MT
-112.00339
46.593143
X
14
Denver
CO
-104.943955
39.709101
Y
18
Milwaukee
WI
-87.925026
42.96156
Z
17
Las Vegas
NV
-115.242869
36.177034
A
26
Houston
TX
1
47
Main
47
A
26
Houston
TX
2
29
Main
29
A
26
Houston
TX
3
50
Main
50
A
26
Houston
TX
4
12
Main
12
A
26
Houston
TX
5
19
Main
19
A
26
Houston
TX
6
72
Main
0
A
26
Houston
TX
7
71
Main
13
A
26
Houston
TX
8
2
Main
0
A
26
Houston
TX
10
40
Main
40
B
4
Birmingham
AL
2
46
Main
46
B
4
Birmingham
AL
3
36
Main
36
B
4
Birmingham
AL
4
7
Main
7
B
4
Birmingham
AL
5
48
Main
48
B
4
Birmingham
AL
6
71
Main
71
B
4
Birmingham
AL
7
19
Main
19
B
4
Birmingham
AL
10
4
Main
4
C
25
Seattle
WA
1
34
Main
34
C
25
Seattle
WA
2
52
Main
52
C
25
Seattle
WA
3
66
Main
66
C
25
Seattle
WA
4
17
Main
17
C
25
Seattle
WA
6
3
Main
2
C
25
Seattle
WA
7
57
Main
57
C
25
Seattle
WA
8
77
Main
64
C
25
Seattle
WA
10
13
Main
13
D
3
Detroit
MI
2
1
Main
1
D
3
Detroit
MI
3
76
Main
76
D
3
Detroit
MI
4
46
Main
46
D
3
Detroit
MI
6
21
Main
21
D
3
Detroit
MI
7
40
Main
40
D
3
Detroit
MI
10
41
Main
41
E
5
Nashville
TN
1
44
Main
44
E
5
Nashville
TN
2
14
Main
14
E
5
Nashville
TN
5
75
Main
75
E
5
Nashville
TN
6
32
Main
32
E
5
Nashville
TN
7
14
Main
14
E
5
Nashville
TN
8
76
Main
76
E
5
Nashville
TN
10
42
Main
42
F
2
Chicago
IL
1
71
Main
71
F
2
Chicago
IL
2
28
Main
28
F
2
Chicago
IL
3
46
Main
46
F
2
Chicago
IL
4
54
Main
54
F
2
Chicago
IL
5
9
Main
9
F
2
Chicago
IL
6
52
Main
52
F
2
Chicago
IL
7
43
Main
43
F
2
Chicago
IL
8
33
Main
33
F
2
Chicago
IL
9
59
Main
59
F
2
Chicago
IL
10
16
Main
16
G
24
Lansing
IA
1
60
Main
60
G
24
Lansing
IA
2
2
Main
2
G
24
Lansing
IA
3
51
Main
51
G
24
Lansing
IA
4
66
Main
66
G
24
Lansing
IA
5
47
Main
47
G
24
Lansing
IA
6
28
Main
28
G
24
Lansing
IA
7
66
Main
66
G
24
Lansing
IA
9
30
Main
0
G
24
Lansing
IA
10
55
Main
55
H
1
Fayetteville
NC
1
11
Main
11
H
1
Fayetteville
NC
2
69
Main
69
H
1
Fayetteville
NC
3
5
Main
5
H
1
Fayetteville
NC
4
41
Main
41
H
1
Fayetteville
NC
5
54
Main
54
H
1
Fayetteville
NC
7
28
Main
28
H
1
Fayetteville
NC
8
57
Main
57
H
1
Fayetteville
NC
9
17
Main
17
H
1
Fayetteville
NC
10
36
Main
36
I
23
Miami
FL
2
6
Main
6
I
23
Miami
FL
4
73
Main
73
I
23
Miami
FL
5
43
Main
43
I
23
Miami
FL
6
3
Main
3
I
23
Miami
FL
7
70
Main
70
I
23
Miami
FL
8
70
Main
70
I
23
Miami
FL
9
16
Main
0
I
23
Miami
FL
10
17
Main
17
J
22
Tampa
FL
1
71
Main
71
J
22
Tampa
FL
2
35
Main
35
J
22
Tampa
FL
4
5
Main
5
J
22
Tampa
FL
5
79
Main
79
J
22
Tampa
FL
6
9
Main
9
J
22
Tampa
FL
7
38
Main
38
J
22
Tampa
FL
9
55
Main
21
J
22
Tampa
FL
10
72
Main
72
K
21
Charleston
SC
1
44
Main
44
K
21
Charleston
SC
2
13
Main
13
K
21
Charleston
SC
3
63
Main
63
K
21
Charleston
SC
4
73
Main
73
K
21
Charleston
SC
6
62
Main
62
K
21
Charleston
SC
7
61
Main
61
K
21
Charleston
SC
8
20
Main
20
K
21
Charleston
SC
10
25
Main
25
L
6
Los Angeles
CA
1
26
Main
26
L
6
Los Angeles
CA
3
10
Main
10
L
6
Los Angeles
CA
4
35
Main
35
L
6
Los Angeles
CA
5
62
Main
62
L
6
Los Angeles
CA
6
16
Main
16
L
6
Los Angeles
CA
7
73
Main
73
L
6
Los Angeles
CA
8
35
Main
35
L
6
Los Angeles
CA
9
78
Main
78
L
6
Los Angeles
CA
10
33
Main
33
M
20
Sacramento
CA
2
12
Main
12
M
20
Sacramento
CA
3
23
Main
23
M
20
Sacramento
CA
4
55
Main
55
M
20
Sacramento
CA
5
46
Main
46
M
20
Sacramento
CA
6
9
Main
9
M
20
Sacramento
CA
7
4
Main
4
M
20
Sacramento
CA
8
8
Main
8
M
20
Sacramento
CA
9
76
Main
76
M
20
Sacramento
CA
10
60
Main
60
N
7
Tucson
AZ
2
9
Main
9
N
7
Tucson
AZ
4
29
Main
29
N
7
Tucson
AZ
5
12
Main
12
N
7
Tucson
AZ
6
4
Main
4
N
7
Tucson
AZ
7
36
Main
36
N
7
Tucson
AZ
8
3
Main
3
N
7
Tucson
AZ
10
8
Main
8
O
8
Dallas
TX
1
15
Main
15
O
8
Dallas
TX
2
35
Main
35
O
8
Dallas
TX
5
30
Main
30
O
8
Dallas
TX
6
43
Main
43
O
8
Dallas
TX
8
78
Main
78
O
8
Dallas
TX
9
48
Main
48
O
8
Dallas
TX
10
64
Main
64
P
19
Austin
TX
2
60
Main
60
P
19
Austin
TX
3
33
Main
33
P
19
Austin
TX
4
5
Main
5
P
19
Austin
TX
5
9
Main
9
P
19
Austin
TX
6
27
Main
27
P
19
Austin
TX
7
62
Main
62
P
19
Austin
TX
8
71
Main
71
P
19
Austin
TX
9
30
Main
30
P
19
Austin
TX
10
50
Main
50
Q
9
Tulsa
OK
2
22
Main
22
Q
9
Tulsa
OK
3
32
Main
32
Q
9
Tulsa
OK
4
11
Main
11
Q
9
Tulsa
OK
5
4
Main
4
Q
9
Tulsa
OK
6
46
Main
46
Q
9
Tulsa
OK
7
69
Main
69
Q
9
Tulsa
OK
8
46
Main
46
Q
9
Tulsa
OK
9
12
Main
12
Q
9
Tulsa
OK
10
53
Main
53
R
16
New York
NY
2
76
Main
76
R
16
New York
NY
3
15
Main
15
R
16
New York
NY
4
13
Main
13
R
16
New York
NY
5
69
Main
69
R
16
New York
NY
6
41
Main
41
R
16
New York
NY
7
49
Main
49
R
16
New York
NY
8
50
Main
50
R
16
New York
NY
10
9
Main
9
S
10
Baltimore
MD
1
23
Main
23
S
10
Baltimore
MD
2
9
Main
9
S
10
Baltimore
MD
4
27
Main
27
S
10
Baltimore
MD
5
31
Main
31
S
10
Baltimore
MD
6
31
Main
31
S
10
Baltimore
MD
7
17
Main
17
S
10
Baltimore
MD
8
69
Main
69
S
10
Baltimore
MD
9
53
Main
53
S
10
Baltimore
MD
10
21
Main
21
T
15
Portland
OR
1
19
Main
19
T
15
Portland
OR
2
66
Main
66
T
15
Portland
OR
3
76
Main
76
T
15
Portland
OR
4
56
Main
56
T
15
Portland
OR
5
78
Main
78
T
15
Portland
OR
6
53
Main
53
T
15
Portland
OR
7
62
Main
62
T
15
Portland
OR
8
2
Main
2
T
15
Portland
OR
9
12
Main
12
U
11
Philadelphia
PA
1
71
Main
71
U
11
Philadelphia
PA
2
54
Main
54
U
11
Philadelphia
PA
4
3
Main
3
U
11
Philadelphia
PA
5
54
Main
54
U
11
Philadelphia
PA
6
3
Main
3
U
11
Philadelphia
PA
7
48
Main
48
U
11
Philadelphia
PA
8
6
Main
6
V
12
Boston
MA
1
65
Main
65
V
12
Boston
MA
2
30
Main
30
V
12
Boston
MA
3
4
Main
4
V
12
Boston
MA
4
12
Main
12
V
12
Boston
MA
5
50
Main
50
V
12
Boston
MA
7
37
Main
37
V
12
Boston
MA
8
10
Main
10
V
12
Boston
MA
9
76
Main
76
W
13
Helena
MT
1
76
Main
76
W
13
Helena
MT
2
68
Main
68
W
13
Helena
MT
3
10
Main
10
W
13
Helena
MT
4
48
Main
48
W
13
Helena
MT
5
65
Main
65
W
13
Helena
MT
7
60
Main
60
W
13
Helena
MT
8
15
Main
15
W
13
Helena
MT
9
31
Main
31
X
14
Denver
CO
1
8
Main
8
X
14
Denver
CO
2
49
Main
49
X
14
Denver
CO
3
57
Main
57
X
14
Denver
CO
4
23
Main
23
X
14
Denver
CO
5
25
Main
25
X
14
Denver
CO
7
39
Main
39
X
14
Denver
CO
8
45
Main
45
X
14
Denver
CO
9
68
Main
68
Y
18
Milwaukee
WI
1
6
Main
6
Y
18
Milwaukee
WI
2
47
Main
47
Y
18
Milwaukee
WI
4
1
Main
1
Y
18
Milwaukee
WI
5
26
Main
26
Y
18
Milwaukee
WI
6
64
Main
64
Y
18
Milwaukee
WI
7
33
Main
33
Y
18
Milwaukee
WI
8
41
Main
41
Y
18
Milwaukee
WI
9
33
Main
33
Y
18
Milwaukee
WI
10
7
Main
7
Z
17
Las Vegas
NV
1
60
Main
60
Z
17
Las Vegas
NV
2
25
Main
25
Z
17
Las Vegas
NV
3
39
Main
39
Z
17
Las Vegas
NV
4
45
Main
45
Z
17
Las Vegas
NV
5
75
Main
75
Z
17
Las Vegas
NV
6
18
Main
18
Z
17
Las Vegas
NV
7
18
Main
18
Z
17
Las Vegas
NV
8
25
Main
25
Z
17
Las Vegas
NV
9
2
Main
2
Z
17
Las Vegas
NV
10
10
Main
10
C:\Users\SYLVIA~1\AppData\Local\Temp\Engine_14564_c8f88656dbfd43dfa2c63fd440a4881e_\Engine_21060_4ccc6ebb62c945d6ae2dc9f7d2e3a2be_.yxdb
Single
Profile
Join the Store info with the store Requirements
Join with the warehouse
sort Item and Priority Ascending
Item - Ascending
Priority - Ascending
Create a Running Total for Required
Store
Assigned
Int32
4
Empty
IF [Count]>=[RunTot_Required] THEN [Required]
ELSE [Count]-[Row-1:RunTot_Required]
ENDIF
IF [Count]>=[RunTot_Required] THEN [Required]
ELSE [Count]-[...
If Assigned is negative then 0
C:\Users\SYLVIA~1\AppData\Local\Temp\Engine_14564_c8f88656dbfd43dfa2c63fd440a4881e_\Engine_21060_1870219d6bb2434d9110e67c9c08aa7c_.yxdb
Single
Profile
Horizontal
challenge_14_start_file