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.