Transcript TulsaSparesWarehouseProcesses

Tulsa Spares Warehouse Processes
Receiving
Shipping
Special Projects
Teamwork
Spares Warehouse Metrics

Receiving



Receive all inbound shipments from vendors
within 24 hours of delivery on dock 95% of
the time.
Receive all inbound shipments from field sites
within 24 hours of delivery on dock 95% of
the time.
Expectation: same day receipt of product
when reasonably possible.
Warehouse Receipt Compliance - Spares
Receipt in CCL within 24 Hrs of Physical Receipt
100%
2000
80%
1500
PR Count
60%
1000
40%
500
0
20%
Jun-08
Jul-08
Aug-08
Sep-08
Oct-08
Nov-08
Dec-08
Jan-09
Feb-09
Mar-09
Apr-09
May-09
ON TIME
478
1717
1610
1778
1925
1485
1614
1727
1621
2082
2257
2098
LATE
951
47
36
39
29
132
56
72
34
26
30
22
56
66
94
51
50
56
60
46
47
40
55
% ON TIME
33%
94%
94%
93%
96%
89%
94%
93%
95%
97%
97%
96%
% LATE
67%
3%
2%
2%
1%
8%
3%
4%
2%
1%
1%
1%
3%
4%
5%
3%
3%
3%
3%
3%
2%
2%
3%
NOT RECEIVED IN CCL
% NOT RECEIVED IN CCL
Business Month
0%
Spares Warehouse Metrics

Shipping



Ship all Replenishments, Replacements, and
RMA’s within 24 hours of dispatch to queue
95% of the time.
Measured form dispatch to the queue to
logically “shipping” the order and recording
the tracking number
Expectation: Ship all products same day as
they are dispatched to the queue
Warehouse Shipping Compliance - Spares
Shipping “Replacement" PR's Within 24 HRS Of Order Date
1,400
100%
90%
1,200
80%
70%
60%
800
50%
600
40%
30%
400
20%
200
10%
0
Jun-08
Jul-08
Aug-08
Sep-08
Oct-08
Nov-08
Dec-08
Jan-09
Feb-09
Mar-09
Apr-09
May-09
1069
1187
1018
1129
1171
1070
925
1014
1160
1395
1277
1274
8
53
47
23
13
56
8
21
25
20
37
28
ON TIME
99%
96%
96%
98%
99%
95%
99%
98%
98%
99%
97%
98%
LATE
1%
4%
4%
2%
1%
5%
1%
2%
2%
1%
3%
2%
ON TIME
LATE
Business Month
0%
% Compliant
Count of PR's Shipped
1,000
Timely Shipment to Vendor - Tulsa
Within 24 Hrs of Dispatch to Repair Queue
100%
90%
80%
% Compliant
70%
60%
50%
40%
30%
20%
10%
0%
Jul-08
Aug-08
Sep-08
Oct-08
Nov-08
Dec-08
Jan-09
Feb-09
Mar-09
Apr-09
May-09
Ready to Ship to Vendor
1365
1089
1100
1031
824
786
664
728
691
386
334
Shipped Timely
521
249
614
762
316
505
338
677
675
357
277
% Compliant
38%
23%
56%
74%
38%
64%
51%
93%
98%
92%
83%
Business Month
Jun-09
Receiving Process
Vendor Receipts
Inbound Field Receipts
Good Cards
Hold for RMA
Bad Cards
AWR
Unload and Sort UPS Delivery
Sorting Inbound Product
Move to visual queues
Spares Receipts from Vendor Shipments
• Issues: Missing PR #, Missing RMA, Missing Serial Numbers,
Missing (or confusing paperwork)
Verifying Level 3 Part Numbers
Update the C-Spares Database
Query the PR
Defective Card Processing
•Issues: Make serial number a required field for line #2.
Make Pick-Fulfill and ship on line #2 Mandatory
Verify correct e-label on inbound boxes
Eliminate inbound parts without Pr or Part numbers in CCL.
Mandatory use of e-packie labels. No independent labels.
Good Card Processing
Move from RMA Holding to AWR
Issues: Constant churning of products from inbound to RMA,
from RMA to AWR, from AWR back to RMA, etc., etc., etc.
Shipping: The Picking Position
Issues: Inventory that is incorrect or not in consolidated
locations. Warehouse issue.
Having to “unpick” inventory.
PR number on repair queue e-mails.
Timeliness of information required to work PR’s already in
queue.
Shipping: The Processing Position
Issues: Inaccuracies in using Word database. Is it necessary to
use this workaround in order to produce Packing letters.
Add contact information to Replenishments (automatically).
Shipping: The “Shipper” Position
Issues: Inadvertent errors in shipping product to incorrect
addresses.
Other Warehouse Projects




Consolidation Count
Gaylord Reduction
AWR Retrieval
Cisco Return