Erlang Calculators Explained


132,655

An Erlang calculator is one of the most useful Workforce Management (WFM) tools in the call centre toolkit.

An Erlang Calculator is a mathematical calculation that allows you to calculate the number of staff that you need for a given number of calls, to meet a given service level. 

It is based on the Erlang C formula (a derivative of the Poisson distribution) that was designed by the Danish Mathematician A.K. Erlang around 100 years ago.  The formula is quite involved, but is relatively easy to follow if you studied maths to a reasonable level at school.

You simply enter in the number of phone calls that you receive in a period of time (say per half hour), along with the average duration of the calls and also the service level that you are looking for.

Typical Inputs

  • Number of phone calls
  • Time period (e.g. per half hour)
  • Average Call Duration (Average Handling Time)
  • Service Level (Percentage of calls answered within a period of time, e.g. 80% of calls in 20 seconds)
  • Some Erlang calculators also include a shrinkage input.

Typical Outputs

  • Number of agents (advisors) needed to meet the service level target

Formats of Erlang C Calculators

There are two main formats for Erlang calculators.

1. Excel-based Erlang Calculators

This Excel-based worksheet uses macros, automated input sequences or add-ins, to perform the calculations due to the complexity of the mathematics.

Whilst there are some examples where people have been able to perform the function without using macros (using the Poisson function), these tend to need multiple rows or columns to obtain the required results.

For more information on the Poisson Distribution, read our article: How Is Average Handling Time Distributed? It is not how you think!

Pros

  • Easy to build a mini workforce management system.
  • Flexible – easy to perform what-if type functions and compare whole days or weeks of calls.

Cons

  • Requires macros to be enabled.
  • Many do not take account of shrinkage.
  • Typically only work up to around 200 agents (700 agents tends to be the absolute limit for double precision floating point numbers).
  • Many handmade spreadsheets often contain between 20% and 40% errors

Follow the link for our: Free Erlang C Calculator Excel – Including Shrinkage

Worked Example

Work out the total number of agents (FTE) required for a call volume (including shrinkage)

Calls Reporting Period (mins) Average Call Duration (secs) Required Service Level (%) Target Answer Time (secs) Shrinkage (%) Agents (FTE)
1000 60 180 80% 20 35% 86

This uses the Excel Formula:

=AgentsFTE(Calls, Reporting_period, Average_Call_duration, Service_level_percent, Service_level_time, Shrinkage)

For example =AgentsFTE(B30,C30,D30,E30,F30,G30)

This formula is more accurate as it includes shrinkage (holidays, training, meetings, etc.) and therefore gives a more realistic staffing requirement.

For a full explanation of shrinkage, read our article: How to Calculate Shrinkage 

2. Online Erlang Calculators

A new generation of Erlang calculators has emerged that are available online.

Watch this video, where Jonty Pearce, the Director of Call Centre Helper explains how the Contact Centre Erlang Online Calculator works:

Pros

  • These are freely available online and are easy to test.
  • Great for what-if type calculations.
  • Some can perform calculations in excess of 700 agents.
  • Do not require any software download or potentially harmful macros to be installed on your PC.

Cons

  • Most calculators do not take account of shrinkage.
  • Limited quality checking.
  • Errors over 700 agents. Many online Erlang calculators produce wrong results for large number of agents (see below for how to check this).

Follow the link for our: Call Centre Erlang Staffing Calculator – including Shrinkage

Results

The number of agents needed is 86 agents including 35% shrinkage (56 agents before shrinkage)

This would give a Service Level of 82.3% answered in 20 seconds

The Average Speed of Answer (ASA) would be 12.2 seconds

How to spot if your Erlang calculator is giving the wrong results

STEP 1: Enter the following details into an Erlang calculator

14,200 calls per hour, 180-second call duration, 80% of calls handled in 20 seconds (with no shrinkage if the calculator provides it).

STEP 2: Check that the number of agents equals 721

The correct answer should be 721 agents.  Many calculators will confidently predict 711 advisors (often with a Service Level Prediction of nan [not a number]).

STEP 3: Put in 100 fewer calls

So, enter: 14,100 calls per hour, 180-second call duration, 80% of calls handled in 20 seconds (with no shrinkage if the calculator provides it).

Every calculator will then give the right answer of 716 advisors.

This tells you that despite putting in a lower call volume, and keeping all of the other variables the same, the number of advisors has actually increased from 711 to 716, so something must be wrong.

Find some other examples that will enable you to check your Erlang Calculator below.

Calls Per Hour Other Inputs Correct result Faulty Erlang Calculators Result
1410 Call duration 180 secs, 80% of calls handled in 20 seconds (no shrinkage) 716 Advisors 716 Advisors
1420 Call duration 180 secs, 80% of calls handled in 20 seconds (no shrinkage) 721 Advisors 711 Advisors
1500 Call duration 180 secs, 80% of calls handled in 20 seconds (no shrinkage) 761 Advisors 751 Advisors
2000 Call duration 180 secs, 80% of calls handled in 20 seconds (no shrinkage) 1011 Advisors 1001 Advisors

This process is vital, to ensure that your staffing calculations are as accurate as possible – with overstaffing causing great financial problems and understaffing risking both customer and advisor satisfaction.

With this in mind, we hope that this has been a great introduction to the Erlang Calculator and that we have inspired you to read more of our content – including the three articles below – so you can do the best possible job in staffing your contact centre.

Follow the link for our: Free Erlang Calculator

To find out more about applying Erlang mathematics to the contact centre, read our articles: 

Author: Robyn Coppell
Reviewed by: Megan Jones

Published On: 29th Mar 2017 - Last modified: 18th Mar 2024
Read more about - Erlang, , , , , ,

Follow Us on LinkedIn

Recommended Articles

A picture of the Erlang A formula
A Beginner’s Guide to the Erlang A Formula
The Erlang C Formula
Erlang C Formula - Made Simple With an Easy Worked Example
Erlang Calculator v6 Featured Image
Excel Based Erlang Calculator for Contact Centres – with Maximum Occupancy
4 Comments
  • Hi Call Centre Helper,

    Does the Erlang Calculator “Amount of Calls” refer to Inbound and Outbound calls. Would you consider doing to seperate calculations on Inbound and Outbound calls?

    Thank you.

    Adri Visser 31 Mar at 07:29
  • The Erlang calculator only applies to inbound calls as these are the types of calls that have queuing applied to them.

    Jonty Pearce 3 Apr at 16:58
  • Best results if you use this tool if you calculate per interval.

    Please correct my statement if this is incorrect.

    i tried to compare the calculation of a day overview and per interval on a day overview.

    placing same values such as the below

    Day Overview
    Incoming Calls – 2120
    In a period of – 780 minutes (8 hours hoop)
    AHT – 629 seconds
    Required Service Level – 80%
    Target Answer Time – 600 seconds

    Max Occupancy – 90%
    Shrinkage – 30%

    Downloaded the free erlang calculator file on this same site which can calculate per interval view(Day Calculator), placing same data, differs only in time period:

    AHT – 629
    Reporting Period – 15 minutes
    Required Service Level – 80%
    Target Answer Time – 600
    Shinkage – 30%

    The Day overview stated i need 47 agents to be able to achieve the following
    Service level at 99.6% answered in 600 seconds
    ASA at 44.4 seconds

    but the file where i calculated the per interval stated i needed more than 44 agents on 41 intervals if i divided the overall forecast base on 6 weeks trend such as below:

    6:00 4
    6:15 2
    6:30 5
    6:45 6
    7:00 24
    7:15 35
    7:30 46
    7:45 44
    8:00 47
    8:15 61
    8:30 58
    8:45 59
    9:00 60
    9:15 60
    9:30 54
    9:45 57
    10:00 53
    10:15 64
    10:30 61
    10:45 64
    11:00 63
    11:15 61
    11:30 68
    11:45 52
    12:00 64
    12:15 63
    12:30 61
    12:45 66
    13:00 62
    13:15 67
    13:30 59
    13:45 65
    14:00 58
    14:15 56
    14:30 60
    14:45 56
    15:00 48
    15:15 42
    15:30 33
    15:45 31
    16:00 19
    16:15 16
    16:30 11
    16:45 14
    17:00 12
    17:15 10
    17:30 10
    17:45 9
    18:00 7
    18:15 8
    18:30 3
    18:45 2

    would the result differ base on the time period of the calls that will be coming in or is it because the calculator have a much deeper view on the calls per interval giving a higher staffing requirements than the results in the day view?

    i guess the calculation on the day view considered same volume

    CherryBlossom 14 Apr at 09:11
  • Hi, is there available an erlang calculator tool that considers the period in months. My necessity is to calculate how many agents I need per month.
    Thanks in advance!
    Rita

    rita 15 Jun at 12:02