Consolidated ARInvoices vs. Backlog vs. Forecast View

I should expound that if you keep your forecast in your live ( we did
for a time then we quit, now were bringing it back again) you need to
have one kick ass server running Vantage or depending on the forecast
you put into Vantage MRP/Global can turn into quite a marathon. We take
our forecast out at least six months. For us this translates into
approximately 4,000 forecast suggested jobs. This is all fine and good
except for the sheer amount of process time required. Our current
server choked on this and took 18 hours to run a regenerative MRP. We
subsequently moved the forecast to a test server which then took that
out of the loop. The crummy part about that was that everyone had to
look to a different server for the info. Tonight my IT guy and I are
installing a brand new server with interstellar travel capabilities that
will take care of this and Monday morning the forecast will be returning
to the live server. So this may not even be a factor for you depending
on how far you want your forecast out and how many jobs will be created
during the forecast period you run. Typically our MRP cut off date is
120 days to capture our longest lead time items...



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast
View





You must have been sitting in my office because we just had the
conversation about loading forecasts and enabling planners to
distinguish between forecast-driven suggestions and job-driven
suggestions.

Can you expand on what you do and what you developed a bit?

Thanks!

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Friday, August 28, 2009 6:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast
View

We use forecast intensively to predict and plan for operational needs
(work center hours/loads). Because forecast results in MRP suggested
jobs it wouldn't be much of a stretch to make a correlation to sales
dollars. This works very well for us. We even take it to the level of
using it for capacity planning for predicted sales as well as an
accurate tool to know whether or not to accept a customer order(s) so we
don't oversell our capability to produce..

There are several tools I had to develop in order to help purchasing
distinguish between purchase suggestions due to forecast vs firm sales
orders, and some for work order control in firming and releasing jobs
for print (forecast vs firm orders).

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 2:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast View

My management team is looking for better visibility of past
performance vs. backlog vs. forecast to try to understand where things
are heading from a sales perspective.

This information is scattered around Vantage in various places, unless
I'm not looking in the right places.

How are folks supporting these needs?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
My management team is looking for better visibility of past
performance vs. backlog vs. forecast to try to understand where things
are heading from a sales perspective.



This information is scattered around Vantage in various places, unless
I'm not looking in the right places.



How are folks supporting these needs?



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
We use forecast intensively to predict and plan for operational needs
(work center hours/loads). Because forecast results in MRP suggested
jobs it wouldn't be much of a stretch to make a correlation to sales
dollars. This works very well for us. We even take it to the level of
using it for capacity planning for predicted sales as well as an
accurate tool to know whether or not to accept a customer order(s) so we
don't oversell our capability to produce..



There are several tools I had to develop in order to help purchasing
distinguish between purchase suggestions due to forecast vs firm sales
orders, and some for work order control in firming and releasing jobs
for print (forecast vs firm orders).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 2:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast View





My management team is looking for better visibility of past
performance vs. backlog vs. forecast to try to understand where things
are heading from a sales perspective.

This information is scattered around Vantage in various places, unless
I'm not looking in the right places.

How are folks supporting these needs?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
You must have been sitting in my office because we just had the conversation about loading forecasts and enabling planners to distinguish between forecast-driven suggestions and job-driven suggestions.

Can you expand on what you do and what you developed a bit?

Thanks!

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Friday, August 28, 2009 6:10 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast View

We use forecast intensively to predict and plan for operational needs
(work center hours/loads). Because forecast results in MRP suggested
jobs it wouldn't be much of a stretch to make a correlation to sales
dollars. This works very well for us. We even take it to the level of
using it for capacity planning for predicted sales as well as an
accurate tool to know whether or not to accept a customer order(s) so we
don't oversell our capability to produce..



There are several tools I had to develop in order to help purchasing
distinguish between purchase suggestions due to forecast vs firm sales
orders, and some for work order control in firming and releasing jobs
for print (forecast vs firm orders).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 2:20 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast View





My management team is looking for better visibility of past
performance vs. backlog vs. forecast to try to understand where things
are heading from a sales perspective.

This information is scattered around Vantage in various places, unless
I'm not looking in the right places.

How are folks supporting these needs?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]



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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
The operations side was easy..BAQ searches in the appropriate forms when
selecting jobs (i.e. Job status maintenance, job entry etc..). I can
send you a copy of the BAQ, I simply tied the forecast table, job part,
prod, head, and customer together. When a customer name shows that
tells them it's a forecast job and to ignore it. We dump and reload
weekly for this function. We do not use or allow forecast to fulfill
supply; too messy. This has worked very well. For purchasing, embedded
dashboards in time phase inquiry and a few other forms show what
materials are being driven from forecast suggestions in a very similar
manner. Now within a half day we can run a full MRP/global run on a
test platform when a customer approaches us with a large order and tell
them with absolute certainty whether or not we have the capacity to
fulfill their order on time. For us this usually means blanket orders
that span months, not just plunking in one order that results in a
simple one job run.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 5:17 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast
View





You must have been sitting in my office because we just had the
conversation about loading forecasts and enabling planners to
distinguish between forecast-driven suggestions and job-driven
suggestions.

Can you expand on what you do and what you developed a bit?

Thanks!

-bws

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich%40advancedphotonix.com> ~ 734-864-5618 ~
www.advancedphotonix.com

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of Rob Bucek
Sent: Friday, August 28, 2009 6:10 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast
View

We use forecast intensively to predict and plan for operational needs
(work center hours/loads). Because forecast results in MRP suggested
jobs it wouldn't be much of a stretch to make a correlation to sales
dollars. This works very well for us. We even take it to the level of
using it for capacity planning for predicted sales as well as an
accurate tool to know whether or not to accept a customer order(s) so we
don't oversell our capability to produce..

There are several tools I had to develop in order to help purchasing
distinguish between purchase suggestions due to forecast vs firm sales
orders, and some for work order control in firming and releasing jobs
for print (forecast vs firm orders).

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Brian W. Spolarich
Sent: Friday, August 28, 2009 2:20 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Consolidated ARInvoices vs. Backlog vs. Forecast View

My management team is looking for better visibility of past
performance vs. backlog vs. forecast to try to understand where things
are heading from a sales perspective.

This information is scattered around Vantage in various places, unless
I'm not looking in the right places.

How are folks supporting these needs?

--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich@...
<mailto:bspolarich%40advancedphotonix.com>
<mailto:bspolarich%40advancedphotonix.com> > ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]

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

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





[Non-text portions of this message have been removed]