Download the Free Forecasting Excel Template
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.
If you are not a Call Centre Helper newsletter subscriber click here where you can subscribe and get the Unlock Code.
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 GoodiesIf you are not a Call Centre Helper newsletter subscriber click here where you can subscribe and get the Unlock Code.
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.