RE: Customer Order Fill Rate / On Time Reporting

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.