Moving averages of the sort that Gary's Student recommends are certainly one
possibility, but hardly the only one and depending on your baseline data
that approach could be entirely wrong. (BTW, you can find a moving averages
tool in the Analysis ToolPak [sic] which comes with Excel.)

Two other approaches are exponential smoothing and regression, both of which
are also included in the Analysis ToolPak. There are variations such as Holt
and Holt-Winters, but they're not offered directly in Excel -- you have to
do it yourself.

As Gary's Student recommends, you should track your forecasts against your
actuals, and perhaps choose your method on that basis. But the best method
is to use ARIMA analysis (Autoregressive Integrated Moving Averages, or
Box-Jenkins analysis), which is an objective method of determining whether
to use moving averages, smoothing, regression, or a combination of those
ingredients. It also informs you as to seasonality in your baseline.

And you should also investigate whether your baseline involves a trend,
whether up or down. If it does, you want to start by differencing the data
so that it becomes stationary.

--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


"Brisbane Rob" <Brisbane.Rob.1x9sya_1129928705.2682@excelforum-nospam.com>
wrote in message
news:Brisbane.Rob.1x9sya_1129928705.2682@excelforum-nospam.com...
>
> We budget to manufacture about 10 000 units per month and the daily
> production is recorded in a column along side the applicable date. The
> materials we use vary in quality which means production can sometimes
> run above or below budget for days at a time. What would be the best
> method to forecast production on an on-going basis?
>
> We work Monday to Friday but occassionally on Saturdays.
>
> Any ideas?
>
> Thanks
>
>
> --
> Brisbane Rob
> ------------------------------------------------------------------------
> Brisbane Rob's Profile:
http://www.excelforum.com/member.php...o&userid=25096
> View this thread: http://www.excelforum.com/showthread...hreadid=478360
>