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.

Free Download for Newsletter Subscribers

As a Subscriber to Call Centre Helper you get free access to our calculators and a range of Free Contact Centre Tools and other Goodies

If you are not a Call Centre Helper newsletter subscriber click here where you can subscribe and get the Unlock Code.
Download This Tool

(The Unlock Code can be found at the bottom of the Call Centre Helper Weekly Newsletter. If you are not a subscriber click here).
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.