Forecasting

[Portuga]

I work in a call centre and I was asked to do some forecasting for call
offered for the next 6 months. I have historical data since 2002.
Colums A wil have the "month" and Column B will have the number o
calls offered. How can I do the forecasting using "moving averages"
(need exaple of the formulas in the cells). thank

 

[Frank Kabel]

Hi
a little bit more detail would be helpful
- how many months do you want to include in your moving average. e.g.
if you want two months simply enter the following in C3 (assumption:
row 1 is a header and your data starts in B2)
=AVERAGE(B2:B3)
and copy this down
- Forecasting could be complex depending on the algorithmn you want to
use

 

[Portuga]

Thanks Frank. Detalied info:
Cell A5 has the header "Month". Cells A6:A31 have the months sinc
March 2002 - til April 2004 .

Cell B5 has the header "calls offered". Cells B6:B31 Have the number o
calls for each correspondent month.

I need to forecast the number of calls offered for the next 6 month
(Cells A32:A37) and (B32:B37).

Using which forecasting method is irrelevant (only chose movin
averages because i heard of it and I know that there is that functio
in Excell).

Thanks

 

[Portuga]

Thanks Frank. Detalied info:
Cell A5 has the header "Month". Cells A6:A31 have the months sinc
March 2002 - til April 2004 .

Cell B5 has the header "calls offered". Cells B6:B31 Have the number o
calls for each correspondent month.

I need to forecast the number of calls offered for the next 6 month
(Cells A32:A37) and (B32:B37).

Using which forecasting method is irrelevant (only chose movin
averages because i heard of it and I know that there is that functio
in Excell).

Thanks!

 

[Frank Kabel]

Hi
you may use for example the following formula to get the average of the
last 6 months as assumed value for your next months. Enter this for
example in C1
=AVERAGE(OFFSET($B$1,COUNTA(B:B)-6,0,6))