RE: more on forecasting

Last year we customized BPCS to automate feeding a forecast to MRP.  First
we did a lot of analysis to determine which items to include, how much and
how often...  We ended up forecasting our standard stock items (items we
sell - pretty regularly -- to many different customers), once a month based
on historical sales.  We also automated calculating the min bal on these
items and there components where the lead times were very long...  Once we
developed the logic/program to produce a forecast we fed it to BPCS by
updating the KMR file, i.e., replacing  forecast (Typ F) records once a
month.  We borrowed the "Sys Gen" field from the KMR file to separate the
automated forecast from what the users still enter in ...  Hope this helps

DeeDee Virgei
Project Leader

Nelson Stud Welding, Inc.

Forgot to mention we are still on 4.05 CD; I don't think much has changed w/
forecasting in 6.01

 -----Original Message-----
From:   Steve Segerstrom [mailto:SSegerstrom@xxxxxxxxxxxxxx] 
Sent:   Tuesday, March 02, 2004 9:06 AM
To:     bpcs-l@xxxxxxxxxxxx
Subject:        FW: more on forecasting

> We are on version 6.01.04; heavily modified.  
> 
> I am currently spending some time reviewing forecasting  and would like to
know what you all feel about BPCS forecasting. Bottom line is that I am
looking to see if someone has modified bpcs or created a package that
supplements bpcs so that it supports the capturing of sales intelligence,
assists with the sales and operation planning and handles multiple demand
signals (point of sales from customers, orders, invoices, etc).
> 
> Frame of reference: 
> *     We forecast about 350 million/year.
> *     We are ok forecasting Product families; not so good at item level
(no surprise). 
> *     We want to start measuring better.
> *     basically we key, re-key, re-key, re-key and by the time we get
done; we're so tired no one wants to analyze. Details: I have our sales
people collecting intelligence on napkins, toilet paper, notebooks, pda's
and over the phone; they key it in excel spreadsheets  and pass selected
information to our marketing department who re-key it, slice it dice it and
add their own intelligence to their own spreadsheet. They pass it along to
their marketing secretaries - who re-key it to BPCS. they then print a
forecast for use in the sales and operation planning and after the meeting
they make changes to their own spreadsheet so they can pass it along to a
marketing secretary to, re-key it.
>   
> Steve
> Intermatic Inc
> (815) 675-7469
> 

_______________________________________________
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.