Re: Days of cover based on historical usage

The days on hand figure is a very handy one indeed, wether it is based on
past history or on forecast , or on open orders. In all cases, BPCS has no
native report that does this calculation. It has to be programmed.

The calculation, if it is based on history, will be dependent of what type
of usage in ITH you wish to include. EG; transaction codes B, M, MI, A, etc.

Daniel Warthold P. eng CPIM




----- Original Message -----
From: "Joe McCormick" <joemccormick@xxxxxxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, February 14, 2006 10:18 AM
Subject: [BPCS-L] Days of cover based on historical usage


Hi,
How can I tell how many days of cover I have for an item (parent or
component) based on historical usage. Eg if I have 10 of item x on hand and
4 were issued to shop orders in the last 50 days then based on historical
usage I have 125 days of cover.
Our forecasting is poor so I need to look at history before committing to
buy stock. I would prefer to dump into excel so that I can sort by days of
cover. We are currently using version 6.1

Thanks

Joe


----------------------------------------------------------------------------
----


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.15.7/259 - Release Date: 13/02/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: daniel.warthold@xxxxxxxxxxxx
>