SYS21 - Key Performance Indicators / Measurements

[Dan Thomas <dthomas@xxxxxxxxxxx>]

I'm wondering how other System 21 users are measuring the following things:

Order Fill rates
On-Time shipments
Order/picking/shipping turnaround time
Receiving turnaround time
Pick Accuracy
Receiving/putaway accuracy
Inventory accuracy

Our definitions:

Order fill rate (percent of order lines shipped complete by due date -or-
percent of order lines that never backordered).   The latter just measures
proper stock levels and the former is somewhat of a service rate.  We've
also been asked to provide fill rates at an order level (rather than line)
where all lines must be "filled" or the order is considered not filled.

On-Time shipments (percent of orders and/or order lines shipped by
(sometimes "on) the requested date.

Order turnaround time (average time between receipt of order and time to
pick -or- time to ship).  We normally consider only those orders requested
to ship same day for this measurement.

Pick accuracy (percent of order lines picked without an error, i.e. either
wrong item/lot or quantity)

Receiving accuracy (percent of lines received properly, i.e. correct item#,
lot#, quantity, unit of measure and expiration date and where warehouse
location recorded in system is actual location used - not necessarily what
system suggested)

Inventory accuracy (either percent of item/lot#s having correct balance
during physical inventories -or- percent having correct balance and being in
correct warehouse location).

We are on v3.5.0 and use the warehousing module.  We use System 21 requested
delivery dates (DTDRxx) as scheduled ship date.  It seemed to make more
sense to instruct people when to ship something explicitly rather than tell
them when it needed to arrive and just know transit times.  When given a
requested delivery date by a customer, we calculate the scheduled ship date
by considering the transportation transit time.  In our environment we don't
allow any over/under ships and most orders ship the same day from stock.

In my opinion, every one of these measurement have significant challenges in
being produced.  For one things, how in System 21 do you define errors?  We
record errors in an external system and use queries against System 21 to get
the totals and then calculate the percentages in a spreadsheet.   Some of
the timing measurements are difficult because either there is no date and/or
timestamp -or- it is indirect (have you tried getting from order lines to
warehouse activity files - it isn't simple).

Dan Thomas
Director of Information Technology
MDI
4500 Progress Blvd
Louisville, KY  40218
(502) 318-1208