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. The formula is quite involved, but is relatively easy to follow if you studied maths to a reasonable level at school. See this article for a worked example of the Erlang C formula.

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)

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.

**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 |

</div

Published On: 29th Mar 2017 - Last modified: 18th Dec 2018

Read more about - Call Centre Management, Editor's Picks, Erlang, Scheduling, Service Level, Shrinkage, Staffing

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.

The Erlang calculator only applies to inbound calls as these are the types of calls that have queuing applied to them.

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

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