Forecast Formula

  • Thread starter Thread starter hughes4709
  • Start date Start date
H

hughes4709

Problems with the formula try to forecast future call
volumes.

# of calls 2003 vs # calls 2004.

The volume of calls is by day and trying to predict the
number of calls in advance for staffing needs.

Any Help or suggestions welcome
 
=A1*(1+n%)

where A1 is 2003 numbers, n is predicted growth rate?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Look at the Forcast worksheet function if you think the data is linear.
Generally data such as this has several components. This would give you the
trend component.
 
Back
Top