Re: SYS21 - Key Performance Indicators / Measurements

[ Converted text/html to text/plain ]

Dan,

We could use a report writer like Crystal Reports or IQ Objects to build the
reports - especially since you mentioned the external data source for your
error data.

Joseph H. Savage Jr
Technical Manager
jsavage@infoalt.com
office: 513-793-2929 x218 or 800-513-9194
fax: 513-936-4040
wireless: 513-604-4620
www.infoalt.com
CONFIDENTIALITY NOTICE: This e-mail message is intended only for the person or
entity to whom it is addressed and may contain confidential and/or privileged
material. Any unauthorized review, use disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the sender
by return-reply e-mail and delete the original message and any copies. If you
are the intended recipient, but do not wish to receive future electronic
communications, please advise the sender by return e-mail.
Thank you.
Information Alternatives, Inc.
http://www.infoalt.com[1].


Dan Thomas <dthomas@mdimail.net>
Sent by: jbausers-l-admin@midrange.com
08/01/2002 09:39 AM AST
Please respond to jbausers-l
To: "'JBAUSers-L@midrange.com'" <JBAUSers-L@midrange.com>
cc:
bcc: Joe Savage/CIN/IAI
Subject: SYS21 - Key Performance Indicators / Measurements

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
_______________________________________________
This is the GEAC/JBA System 21 Users (JBAUSERS-L) mailing list
To post a message email: JBAUSERS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/jbausers-l[2]
or email: JBAUSERS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/jbausers-l[3].

===References:===
  1. http://www.infoalt.com
  2. http://lists.midrange.com/cgi-bin/listinfo/jbausers-l
  3. http://archive.midrange.com/jbausers-l