Excel Forecast

Topic Views - 6644


hi,

i have been assign to forecast call volume in our new RTM team. for the momment im currently using a simple method by combining trend and average.

any one can share with me an excel template to forecast call volume? really appreciate.



yeah, simple forecasting will not work, you need to include seazonality in many cases, but i do not know simple templates to do it with excel.


Helper

Call Centre Helper


We have a free erlang calculator that could help you on your way

https://www.callcentrehelper.com/erlang-c-calculator-2473.htm

Kind regards

Jonty



Maxim, yes I did include seasonal data together but this is done manually.

Jonty, thanks for sharing but as per my understanding erlang is to forevast service level. We currently are using erlang c.

What I want to forecast right now is the call volume.

Fyi now average of our forecast is about 90%..plus and minus.


Contact Centre Manager


Suggest as Seasonal that you work with a rolling 6week demand data and use that to forecast your coming 4 weeks.

Depending on how effective your First Contact Resolution is, you may have repeat contact in your demand (failure demand) which will inflate your actual incoming volumes.

Find a month period where your contact was "comfortable" and where performance was good and get a view contacts per customer to get your best view on "what good looks like" and compare to current contacts per customer to see if you have failure demand.



i actually using excel forecast formula - which combination average and trend..

and after that manually change the volume base on historical data..

as per now success rate 90%...


Want to add a comment?

Not found what you were looking for?

1. Try searching through our site.
2. Still not got an answer?

Why not ask the Call Centre Helper Community? Click here to ask your question