Re: Days of cover based on historical usage

Daniel is right...there is no vanilla BPCS report.
but
The Average Monthly Useage field ( IAVEU) in the Item Master (IIM)
MAY be accurate enough to give you a historical useage....
Then the On Hand divided by Ave Useage = Months on hand.....
I would not "buy" to that qty but might use is as a "reasonableness" check
against suggested planned order qtys. 

Peace
Jim Barry
Belchertown, MA

---- Daniel Warthold <daniel.warthold@xxxxxxxxxxxx> wrote: 
> 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
> >
> 
> -- 
> 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: ZZBPCS@xxxxxxxxxxx