A manual method is the most popular choice for forecasting contact volumes in the contact centre.
Poll – “What method of Forecasting Contact Volumes do you use?” – answers
Manual – 49%
Home grown algorithm – 31%
Matching trends by eye – 15%
ARIMA – 3%
Holt Winters – 2%
Source: Call Centre Helper Webinar Poll – Webinar: Excel Masterclass – Designing a Better Forecasting Spreadsheet Sample size – 251 Date: April 2016
We have a Monthly Forecasting Excel Spreadsheet Template you might want to try
I’d be keen to understand why ARIMA and Holt Winters are not being used. We built a forecast based on Holt Winters, and it works very well for us. I’d also love to see some of the “home grown” algorithms used.