RE: Number of times out of stock

["Roy Luce" <lwl@xxxxxxxxxxxxx>]

Tony:

I suspect you have a small challenge in attempting to count number of times
an item was out of stock.

But more importantly, are your planners interested in knowing the out of
stock condition for customer orders or for raw materials?

I'm going to assume customer orders, which brings up another issue:  out of
stock when the order is booked or when the order is picked?
And if it's "when booked" is this count of any real value?  If a customer
provides a blanket purchase order with release dates in the future you
probably want to be out of stock for those release dates beyond your end to
end replenishment lead time at order booking time.  If this is the count
they are after then the count is the number of times an order is booked and
the Available balance is/went negative.  You'll need a mod to capture the
count.

And if the count they're interested in is "out of stock at pick time" it
would indicate they are attempting to set safety stock levels based on the
frequency of the out of stock conditions.  If this is the count the planners
are after then this the number of times a pick list line item is printed and
the balance on hand is negative, or would go negative if you picked this
line.  You need a mod that simulates the picking transaction when
determining this count.


Roy Luce

Main:   847-540-9635
Cell:   847-910-0884
Fax:    208-330-9032
Email:  lwl@ix.netcom.com

-----Original Message-----
From: bpcs-l-admin@midrange.com [mailto:bpcs-l-admin@midrange.com]On Behalf
Of Hunter, Tony
Sent: Friday, October 25, 2002 8:45 AM
To: Bpcs-L (E-mail)
Subject: Number of times out of stock

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
--
[ Picked text/plain from multipart/alternative ]
We have been on BPCS 6.0.04 since 1/1/01 and our Production Planners still
have some screens from a homegrown legacy system.  To create inventory
balances they review sales history and they look at the number of times we
were out of stock.  I am looking to move them out of the legacy system and I
need help with the number of times we were out of stock.  Has anyone ever
tried to get this type of information from BPCS before?

Thank you for any assistance that you can provide,
Tony Hunter
Mohawk Paper Mills, Inc.

_______________________________________________
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/bpcs-l
or email: BPCS-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.