SRJ LOGISTICS CASE STUDY
akrish
SRJLogisticsCaseStudyDataSets.xlsx
Overall
| Date |
Slotter Errors |
Keying Errors |
Letdown Errors |
ITR ADJ Errors |
Putaway Errors |
Other Errors |
Total Errors |
Total Slots Checked |
| 6/1 |
4 |
1 |
1 |
1 |
0 |
3 |
10 |
800 |
| 6/2 |
11 |
2 |
1 |
2 |
2 |
7 |
25 |
800 |
| 6/3 |
11 |
2 |
0 |
2 |
4 |
4 |
23 |
800 |
| 6/4 |
6 |
6 |
0 |
0 |
2 |
11 |
25 |
800 |
| 6/5 |
6 |
0 |
0 |
1 |
3 |
4 |
14 |
800 |
| 6/6 |
19 |
0 |
0 |
0 |
1 |
5 |
25 |
800 |
| 6/7 |
11 |
0 |
0 |
0 |
2 |
2 |
15 |
800 |
| 6/8 |
3 |
1 |
2 |
0 |
1 |
16 |
23 |
800 |
| 6/9 |
3 |
0 |
3 |
0 |
1 |
3 |
10 |
800 |
| 6/10 |
3 |
0 |
3 |
0 |
0 |
5 |
11 |
800 |
| 6/11 |
5 |
0 |
3 |
0 |
0 |
7 |
15 |
800 |
| 6/12 |
0 |
1 |
1 |
0 |
1 |
22 |
25 |
800 |
| 6/13 |
4 |
1 |
3 |
0 |
4 |
5 |
17 |
800 |
| 6/14 |
2 |
0 |
2 |
0 |
0 |
19 |
23 |
800 |
| 6/15 |
0 |
2 |
2 |
0 |
0 |
1 |
5 |
800 |
|
|
|
|
|
|
|
| page 373 |
| 6/16 |
2 |
2 |
0 |
0 |
1 |
0 |
5 |
800 |
| 6/17 |
4 |
0 |
1 |
0 |
2 |
0 |
7 |
800 |
| 6/18 |
3 |
1 |
4 |
2 |
0 |
0 |
10 |
800 |
| 6/19 |
4 |
0 |
3 |
0 |
2 |
1 |
10 |
800 |
| 6/20 |
7 |
2 |
2 |
0 |
3 |
3 |
17 |
800 |
| 6/21 |
13 |
0 |
2 |
0 |
1 |
9 |
25 |
800 |
| 6/22 |
7 |
0 |
2 |
0 |
2 |
5 |
16 |
800 |
| 6/23 |
4 |
0 |
4 |
0 |
1 |
6 |
15 |
800 |
| 6/24 |
7 |
0 |
0 |
0 |
2 |
7 |
16 |
800 |
| 6/25 |
2 |
0 |
1 |
0 |
4 |
2 |
9 |
800 |
| 6/26 |
2 |
0 |
1 |
0 |
4 |
1 |
8 |
800 |
| 6/27 |
2 |
0 |
2 |
0 |
0 |
8 |
12 |
800 |
| 6/28 |
8 |
1 |
1 |
0 |
0 |
6 |
16 |
800 |
| 6/29 |
7 |
1 |
1 |
0 |
0 |
7 |
16 |
800 |
| 6/30 |
1 |
1 |
1 |
0 |
1 |
4 |
8 |
800 |
| 7/1 |
10 |
0 |
2 |
0 |
1 |
8 |
21 |
800 |
| 7/2 |
7 |
0 |
2 |
0 |
2 |
4 |
15 |
800 |
| 7/3 |
4 |
0 |
1 |
0 |
6 |
1 |
12 |
800 |
| 7/4 |
6 |
0 |
2 |
0 |
1 |
1 |
10 |
800 |
| 7/5 |
3 |
0 |
1 |
0 |
0 |
2 |
6 |
800 |
| 7/6 |
0 |
2 |
2 |
0 |
0 |
1 |
5 |
800 |
| 7/7 |
1 |
0 |
5 |
0 |
0 |
19 |
25 |
800 |
| 7/8 |
5 |
0 |
2 |
0 |
0 |
3 |
10 |
800 |
| 7/9 |
5 |
2 |
2 |
0 |
1 |
6 |
16 |
800 |
| 7/10 |
6 |
0 |
0 |
0 |
1 |
2 |
9 |
800 |
| 7/11 |
9 |
0 |
3 |
0 |
0 |
8 |
20 |
800 |
| 7/12 |
9 |
0 |
3 |
0 |
0 |
8 |
20 |
800 |
| 7/13 |
4 |
0 |
2 |
0 |
5 |
0 |
11 |
800 |
| 7/14 |
0 |
0 |
3 |
0 |
8 |
1 |
12 |
800 |
| 7/15 |
0 |
0 |
2 |
0 |
0 |
5 |
7 |
800 |
| Total |
230 |
28 |
78 |
8 |
69 |
242 |
655 |
36000 |
Module 1
| Date |
Slotter Errors |
Keying Errors |
Letdown Errors |
ITR ADJ Errors |
Putaway Errors |
Other Errors |
Total Errors |
Total Slots Checked |
| 6/1 |
1 |
0 |
1 |
0 |
0 |
0 |
2 |
400 |
| 6/2 |
10 |
2 |
1 |
2 |
1 |
1 |
17 |
400 |
| 6/3 |
9 |
1 |
0 |
2 |
4 |
2 |
18 |
400 |
| 6/4 |
6 |
6 |
0 |
0 |
2 |
7 |
21 |
400 |
| 6/5 |
3 |
0 |
0 |
1 |
3 |
0 |
7 |
400 |
| 6/6 |
1 |
0 |
0 |
0 |
0 |
1 |
2 |
400 |
| 6/7 |
7 |
0 |
0 |
0 |
1 |
2 |
10 |
400 |
| 6/8 |
1 |
1 |
2 |
0 |
1 |
16 |
21 |
400 |
| 6/9 |
3 |
0 |
3 |
0 |
1 |
1 |
8 |
400 |
| 6/10 |
3 |
0 |
3 |
0 |
0 |
3 |
9 |
400 |
| 6/11 |
5 |
0 |
3 |
0 |
0 |
3 |
11 |
400 |
| 6/12 |
0 |
1 |
1 |
0 |
1 |
21 |
24 |
400 |
| 6/13 |
4 |
1 |
3 |
0 |
3 |
5 |
16 |
400 |
| 6/14 |
2 |
0 |
2 |
0 |
0 |
0 |
4 |
400 |
| 6/15 |
0 |
2 |
2 |
0 |
0 |
1 |
5 |
400 |
| 6/16 |
2 |
2 |
0 |
0 |
0 |
0 |
4 |
400 |
| 6/17 |
1 |
0 |
1 |
0 |
1 |
0 |
3 |
400 |
| 6/18 |
3 |
1 |
4 |
2 |
0 |
0 |
10 |
400 |
| 6/19 |
3 |
0 |
3 |
0 |
2 |
1 |
9 |
400 |
| 6/20 |
7 |
2 |
2 |
0 |
2 |
2 |
15 |
400 |
| 6/21 |
13 |
0 |
2 |
0 |
0 |
8 |
23 |
400 |
| 6/22 |
7 |
0 |
2 |
0 |
2 |
1 |
12 |
400 |
| 6/23 |
4 |
0 |
4 |
0 |
1 |
4 |
13 |
400 |
| 6/24 |
5 |
0 |
0 |
0 |
1 |
5 |
11 |
400 |
| 6/25 |
2 |
0 |
1 |
0 |
4 |
2 |
9 |
400 |
| 6/26 |
1 |
0 |
1 |
0 |
3 |
1 |
6 |
400 |
| 6/27 |
2 |
0 |
2 |
0 |
0 |
5 |
9 |
400 |
| 6/28 |
6 |
0 |
1 |
0 |
0 |
4 |
11 |
400 |
| 6/29 |
5 |
0 |
1 |
0 |
0 |
5 |
11 |
400 |
| 6/30 |
1 |
0 |
1 |
0 |
0 |
4 |
6 |
400 |
| 7/1 |
8 |
0 |
2 |
0 |
1 |
7 |
18 |
400 |
| 7/2 |
7 |
0 |
2 |
0 |
2 |
4 |
15 |
400 |
| 7/3 |
2 |
0 |
1 |
0 |
6 |
1 |
10 |
400 |
| 7/4 |
4 |
0 |
2 |
0 |
1 |
1 |
8 |
400 |
| 7/5 |
2 |
0 |
1 |
0 |
0 |
1 |
4 |
400 |
| 7/6 |
0 |
2 |
2 |
0 |
0 |
0 |
4 |
400 |
| 7/7 |
0 |
0 |
5 |
0 |
0 |
15 |
20 |
400 |
| 7/8 |
2 |
0 |
2 |
0 |
0 |
3 |
7 |
400 |
| 7/9 |
3 |
2 |
1 |
0 |
0 |
2 |
8 |
400 |
| 7/10 |
3 |
0 |
0 |
0 |
1 |
2 |
6 |
400 |
| 7/11 |
7 |
0 |
3 |
0 |
0 |
8 |
18 |
400 |
| 7/12 |
7 |
0 |
3 |
0 |
0 |
8 |
18 |
400 |
| 7/13 |
2 |
0 |
2 |
0 |
5 |
0 |
9 |
400 |
| 7/14 |
0 |
0 |
3 |
0 |
8 |
0 |
11 |
400 |
| 7/15 |
0 |
0 |
2 |
0 |
0 |
1 |
3 |
400 |
| Total |
164 |
23 |
77 |
7 |
57 |
158 |
486 |
18000 |
Module 3
| Date |
Slotter Errors |
Keying Errors |
Letdown Errors |
ITR ADJ Errors |
Putaway Errors |
Other Errors |
Total Errors |
Total Slots Checked |
| 6/1 |
3 |
1 |
0 |
1 |
0 |
3 |
8 |
400 |
| 6/2 |
1 |
0 |
0 |
0 |
1 |
6 |
8 |
400 |
| 6/3 |
2 |
1 |
0 |
0 |
0 |
2 |
5 |
400 |
| 6/4 |
0 |
0 |
0 |
0 |
0 |
4 |
4 |
400 |
| 6/5 |
3 |
0 |
0 |
0 |
0 |
4 |
7 |
400 |
| 6/6 |
18 |
0 |
0 |
0 |
1 |
4 |
23 |
400 |
| 6/7 |
4 |
0 |
0 |
0 |
1 |
0 |
5 |
400 |
| 6/8 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 6/9 |
0 |
0 |
0 |
0 |
0 |
2 |
2 |
400 |
| 6/10 |
0 |
0 |
0 |
0 |
0 |
2 |
2 |
400 |
| 6/11 |
0 |
0 |
0 |
0 |
0 |
4 |
4 |
400 |
| 6/12 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
400 |
| 6/13 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
400 |
| 6/14 |
0 |
0 |
0 |
0 |
0 |
19 |
19 |
400 |
| 6/15 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
400 |
| 6/16 |
0 |
0 |
0 |
0 |
1 |
0 |
1 |
400 |
| 6/17 |
3 |
0 |
0 |
0 |
1 |
0 |
4 |
400 |
| 6/18 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
400 |
| 6/19 |
1 |
0 |
0 |
0 |
0 |
0 |
1 |
400 |
| 6/20 |
0 |
0 |
0 |
0 |
1 |
1 |
2 |
400 |
| 6/21 |
0 |
0 |
0 |
0 |
1 |
1 |
2 |
400 |
| 6/22 |
0 |
0 |
0 |
0 |
0 |
4 |
4 |
400 |
| 6/23 |
0 |
0 |
0 |
0 |
0 |
2 |
2 |
400 |
| 6/24 |
2 |
0 |
0 |
0 |
1 |
2 |
5 |
400 |
| 6/25 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
400 |
| 6/26 |
1 |
0 |
0 |
0 |
1 |
0 |
2 |
400 |
| 6/27 |
0 |
0 |
0 |
0 |
0 |
3 |
3 |
400 |
| 6/28 |
2 |
1 |
0 |
0 |
0 |
2 |
5 |
400 |
| 6/29 |
2 |
1 |
0 |
0 |
0 |
2 |
5 |
400 |
| 6/30 |
0 |
1 |
0 |
0 |
1 |
0 |
2 |
400 |
| 7/1 |
2 |
0 |
0 |
0 |
0 |
1 |
3 |
400 |
| 7/2 |
0 |
0 |
0 |
0 |
0 |
0 |
0 |
400 |
| 7/3 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 7/4 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 7/5 |
1 |
0 |
0 |
0 |
0 |
1 |
2 |
400 |
| 7/6 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
400 |
| 7/7 |
1 |
0 |
0 |
0 |
0 |
4 |
5 |
400 |
| 7/8 |
3 |
0 |
0 |
0 |
0 |
0 |
3 |
400 |
| 7/9 |
2 |
0 |
1 |
0 |
1 |
4 |
8 |
400 |
| 7/10 |
3 |
0 |
0 |
0 |
0 |
0 |
3 |
400 |
| 7/11 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 7/12 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 7/13 |
2 |
0 |
0 |
0 |
0 |
0 |
2 |
400 |
| 7/14 |
0 |
0 |
0 |
0 |
0 |
1 |
1 |
400 |
| 7/15 |
0 |
0 |
0 |
0 |
0 |
4 |
4 |
400 |
| Total |
66 |
5 |
1 |
1 |
12 |
84 |
169 |
18000 |