RE: more on forecasting

I suggest you build a couple of programs through which you can upload
spreadsheet data reliably to the AS/400.  We do this through a combination
of saving the spreadsheet in dif format, uploading to the AS/400,
reconstituting the columns and rows on the AS/400 into a simple flat file
and then using another program to update budget information.

The programming for any one of these steps is not that complicated.  A more
modern approach would be to use VBA and ODBC.  Learning how to use VBA and
spreasheets seems to be of strategic importance for the future.

Mindaugas Bielskus

-----Original Message-----
From: Steve Segerstrom [mailto:SSegerstrom@xxxxxxxxxxxxxx] 
Sent: Tuesday, March 02, 2004 8: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.

DISCLAIMER: This e-mail transmission is strictly confidential. If you are
not the intended recipient, you must not copy, distribute or take any action
in reliance on it. If you have received this e-mail in error, please notify
us as soon as possible and delete it. 
E-mail transmission cannot be guaranteed free from viruses, secure or error
free. No liability is accepted by the sender for any loss or damage which
may be caused as a result of the transmission of this e-mail. If
verification is required, please ask for a hard copy version.