Re: Customer Order Fill Rate / On Time Reporting

Michael, Presence is a MAPICS-certified partner that provides business
activity monitoring software. I am in the early stages of developing a suite
of  Presence-based "On-Time Shipment" alerts that address your reporting
needs and much more.

In Presence, preventing late shipments from happening is the first priority.
There is an alert monitors the progress of customer-related manufacturing
orders against request and  promise dates. If analysis of routing times and
operations claimed indicates that the order is going to be late, Presence
e-mails an alert to the people that you designate.

Minimizing the consequences of late shipments is the second priority. When
an item is not ready for shipment on the request or promise date, Presence
e-mails people that you designate. They can react by expediting the order so
it ships on time or having Presence send an e-mail to the customer advising
of the late shipment and giving the new promise date. When they do this
Presence automatically updates MAPICS with the new promise date.

Presence automatically "keeps score" of on time and late shipments (or any
other alert). You can capture this information for any time interval (day,
week, month) and have Presence report performance. Downloading to Excel is
and showing performance info as graphs is a snap.


Bob Tenney
Bob Tenney Solutions, LLC
MAPICS - FRx - Presence - Crystal Reports
828-526-8976

Visit www.tenneypubs.com for books about
IFM, COM, G/L Interfaces
Info WorkPlace, Cost Accounting,
FRx, and PRESENCE
----- Original Message -----
From: <Michael.Huber@xxxxxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Sent: Monday, July 21, 2003 3:28 PM
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.
>
>