Call Center Staffing Model Excel Template

It was very much ahead of its time and is still going strong almost 100 years later.

Call center staffing model excel template. 21 posts related to call center staffing model excel template. The staffing calculator uses a very clever statistical calculation called the erlang c formula. Filed under essential call centre tools downloads excel forecasting staffing workforce management wfm now free to download is our new excel call centre forecasting template which will assist your call centre s capacity planning demand and call volume forecasting processes. Buy and download now if your job is to analyse your call center s staffing and operational performance then cc excel can make life easier by adding call center functions to your workbooks.

The cost worksheet is used to manage your cost data. You just need to enter your call volume and the service level that you would like to achieve. Sample objective for customer service call center. It is the basis of queueing theory and was developed by a danish mathematician called ak erlang in 1917.

The spreadsheet incorporates support for staffing based on hourly call rates target call answer times required service levels and staff shrinkage using. Practical staffing with excel in the previous sections we have seen how to compute useful indicators to analyze the call center activity. Workload fte cost calculation workbook guide. Call center kpi excel template.

Staffing plan template 7 hrs x 22 we have specialized staffing plans for insurance and banking. Nine call center staffing functions for microsoft excel that help you model your call center performance using your own workbooks. Call center excel dashboard templates. This is a simple excel spreadsheet tool that allows you to work out how many agents you will need.

The computation is using the function erlangcsrv which takes 4 arguments. First m the number of agents second u the traffic intensity third t the average call duration and fourth tt the target time. Contact us for them. The tables allow you to modify costs as they change without modifying any cost formulas in the workload fte sheet.

December 4 2019 by admin. This staffing plan template calculates workload fte full time equivalent requirements and process activity costs. Call center disaster recovery plan template. The call center version of the scheduling spreadsheet allows you to enter daily projected call volumes and to derive a weekly staffing plan directly from these numbers.

We have developed a free erlang calculator in handy excel based spreadsheet format to help with your call centre staff planning.