Download the Free Forecasting Excel Template

resource image
We have developed a free forecasting template in Excel to help you with your Call Centre Planning.

This tool needs you to have 24 previous months of data available. You add these to the spreadsheet and it will calculate the next 12 months' predicted values for you. You can then used these reports for capacity planning purposes. The forecasting template has been designed to work with call volumes, but could easily be adapted for other types of monthly forecast.

Our forecaster works using the Holt-Winters, or triple exponential smoothing, method, which assumes that there are three components to any forecast:

•   A seasonal adjustment - based on previous data for the same months, e.g. you might expect customer calls to go down in December or rise in July.
•   A trend - whether your values are generally growing or shrinking over time.
•   A level - a baseline for your values once the other components have been removed.

Please enter your details to download the free Excel Forecasting Spreadsheet.

Terms and Conditions

Use of the Forecasting Spreadsheet is subject to our standard terms and conditions.
Download This Tool

We may use your personal information to send you information you have requested. Permission lasts for 24 months. Permission can be withdrawn at any time.