|
Hello Michael Although your company's use of the MAPICS date fields may not conform to the MAPICS precise definition the more important factor, for measurement, is that they are used consistently to represent what your company wants. The 'date inconsistency problem' is common at my company. For example, many customers are given promise dates of week commencing Monday..... I cannot differentiate these orders from those customer orders which actually require a delivery on a Monday. Other customers may specify any date in the week as long as it is Tuesday, or later, etc. One way round this is to apply a tolerance. In my case I calculate the Sunday date of the end of the week in which the Customer Order Line was promised. I measure by complete customer order LINES as opposed to complete customer orders. I also calculate what I call a 'Manufacturing Due Date' Performance for each customer order line to distinguish between Manufacturing's Performance and Finished Goods Warehousing & Distribution. Basically, I calculate what the on hand inventory would have been at each customer order line's manufacturing due date to see if sufficient stock existed to cover that customer order line. It is a complex calculation because of early shipments of other customer order lines, stock adjustments, etc. All these metrics measure events after they should have happened. Have you thought about measuring planned performance before the due dates / promise dates have elapsed? I have a number of queries which calculate planned customer order line performance based on Manufacturing and Purchase Orders for finished goods. This can be more useful than the MRP perspective on consolidation by item. I remember a while back the methodology of 'Reality Based Priority Management' being mentioned by Dave Turbide. This may be something you wish to investigate as a more proactive tool to meeting due dates & promise dates. On a cautionary note, be aware of placing too much emphasis on these order line measures alone. My company was regularly achieving 95%+ due date adherence, by customer order line, and 92%+ promise date adherence. However, that didn't stop us going into Administrative Receivership!! I think measuring customer satisfaction is far more complex than a few metrics based on order lines - as all Quality Gurus will no doubt tell us. Cheers Paul -----Original Message----- From: Michael.Huber@xxxxxxxxxxxxxxxxx [mailto:Michael.Huber@xxxxxxxxxxxxxxxxx] Sent: 21 July 2003 20:28 To: MAPICS ERP System Discussion Subject: Re: Customer Order Fill Rate / On Time Reporting I guess I should have added more detail to the original message. What our management is looking for is what percent of customer orders have been shipped complete for a specific request date. The problem that I am having is meshing the open orders with the historical orders and filtering out the back orders. One of the biggest stumbling blocks is that we do not use alot of the date fields in MAPICS properly. For example the request date is used as the date the product leaves our docks, not when it should arrive on the customer's docks. All of our COs receive an arbitrary lead time of four days, if I would enter an order today the request date would be four days from today. Request Date = Ship Date AND Line Item Fill 100% - scores as 100% Request Date > Ship Date AND Line Item Fill 100% - scores as 0% Request Date = Ship Date AND Line Item Fill < 100% - scores as 0% Request Date AND not Shipped - scores as 0% etc etc ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------- Michael K. Huber Applications Development & AS/400 Operations Pentair/Plymouth Products, Inc 502 Indiana Ave - Sheboygan, WI 53081 Phone: (920) 451-9417 FAX: (920) 803-3541 Cellular: (920) 698-0013 Mobile Messaging: 9206980013@xxxxxxxxxxxxxx ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------- Confidentiality Note: This e-mail message and any attachments to it are intended only for the named recipients and may contain confidential information. If you are not one of the intended recipients, please do not duplicate or forward this e-mail message and immediately delete it from your computer. Michael.Huber@xxxxxxxxxxxxxxxxx Sent by: mapics-l-bounces@xxxxxxxxxxxx 07/21/2003 01:20 PM Please respond to MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx> To MAPICS-L@xxxxxxxxxxxx cc Subject Customer Order Fill Rate / On Time Reporting Does any one do any of this type of reporting? I am trying to determine a good method of doing such, but I keep hitting road blocks. I guess I am looking for examples or suggestions on how others might report these numbers. ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------- Michael K. Huber Applications Development & AS/400 Operations Pentair/Plymouth Products, Inc 502 Indiana Ave - Sheboygan, WI 53081 Phone: (920) 451-9417 FAX: (920) 803-3541 Cellular: (920) 698-0013 Mobile Messaging: 9206980013@xxxxxxxxxxxxxx ---------------------------------------------------------------------------- ---------------------------------------------------------------------------- ----------------------------------------------- Confidentiality Note: This e-mail message and any attachments to it are intended only for the named recipients and may contain confidential information. If you are not one of the intended recipients, please do not duplicate or forward this e-mail message and immediately delete it from your computer. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-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.
midrange.com
