Re: Identifying slow moving stock

Joe:

>From working with clients over the past several years, I've learned that
using past usage figures to determine which inventory items will be slow
movers is like driving a car by watching the rearview mirror.  You can tell
what the road has done but not what it is going to do.

The most valuable numbers are those that indicate demand levels based on
backlogged customer orders (future demand) and those that may be required
based on forecasted demand.

Al Mac identifies summary data shown on the INV300 screen reflecting the
total of the demand for real and planned orders - that's the data I'd be
going after.

It may also be interesting to separate items with no demand of any type from
those with some demand and look at the supply versus demand.
To accomplish this feat it is necessary to peg each backlogged order or
forecasted quantity to its raw material and sum the demand by time periods.
You also need to time phase the supply quantities and match them to the
demand.

Several of my clients run this process once a week.  The result has been a
30% (or more) drop in raw and WIP inventory.
The process is embedded in OTTO, a "bolt-on" to BPCS.  To learn more contact
me off line.

Roy Luce
Systems Plus - Midwest

Main:   847-540-9635
Cell:   847-910-0884
Fax:    847-620-2799
Email:  lwl@xxxxxxxxxxxxx

-----Original Message-----
From: bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx
[mailto:bpcs-l-bounces+lwl=ix.netcom.com@xxxxxxxxxxxx]On Behalf Of Joe
McCormick
Sent: Tuesday, January 24, 2006 5:12 AM
To: SSA's BPCS ERP System
Subject: Re: [BPCS-L] Identifying slow moving stock

Thanks mate!
----- Original Message -----
From: "antwi, isaac a." <iantwi@xxxxxxxxxxxxxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Monday, January 23, 2006 4:06 PM
Subject: Re: [BPCS-L] Identifying slow moving stock


> Joe,
>
> For slow moving stock, query for all items that have moved within a
> specified period say 1 year or 2 years (from ITH) and compare the result
> to the item master (IIM) selecting items that do not have a match in the
> first file. Make sure their creation dates fall outside the period you
> specified.
>
> Isaac.
>
> -----Original Message-----
> From: bpcs-l-bounces+iantwi=anglogoldashanti.com.gh@xxxxxxxxxxxx
> [mailto:bpcs-l-bounces+iantwi=anglogoldashanti.com.gh@xxxxxxxxxxxx] On
> Behalf Of Joe McCormick
> Sent: 22 January 2006 12:39
> To: bpcs-l@xxxxxxxxxxxx
> Subject: [BPCS-L] Identifing slow moving stock
>
> How can I identify raw material inventory that is slow moving and raw
> material inventory that is not in any released or planned orders.
>
> Joe McCormick
> --
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: iantwi@xxxxxxxxxxxxxxxxxxxxxxx
>
> --
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
> Delivered-To: joemccormick@xxxxxxxxxxxxxx
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.375 / Virus Database: 267.14.22/238 - Release Date:
> 23/01/2006
>
>



--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.22/238 - Release Date: 23/01/2006
--
This is the SSA's BPCS ERP System (BPCS-L) mailing list
To post a message email: BPCS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
or email: BPCS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/bpcs-l.

Delivered-To: lwl@xxxxxxxxxxxxx