|
[ 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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.