What Is an Erlang Calculator?


An Erlang calculator is one of the most useful 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.

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 – see this article for more details: http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm

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)

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.

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.

Do you use an Erlang calculator to work out how many advisors you need in the contact centre? If so, what have been your experiences with it?

Please leave your thoughts and responses in the comments section below.

Published On: 29th Mar 2017 - Last modified: 19th May 2017
Read more about - Call Centre Management,Essential Call Centre Tools , , , , ,


4 Comments
  1. 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 7:29 am
  2. 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 4:58 pm
  3. 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 9:11 am
  4. 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 pm
Leave a Comment
Leave a Comment

Your email address will not be published. Required fields are marked *

 
css.php