AgentsFTE in CallCenter Helper Excel Calc jumps

Topic Views - 1792

AgentsFTE in CallCenter Helper Excel Calc jumps from 6 to 8

I'm using the call-centre-helper-erlang-calculator-v5.5.xlsm and noticed that the FTE with shrinkage(=AgentsFTE) will jump by 2 agents. For example:

Reporing Period:60
Required Service Level:80%
Target Answer Time:60
= Agents FTE of 6

If I increase the AHT to: 578
then Agents FTE jumps to 8.

How should I interpret this?

Kind Regards,


Call Centre Helper

You are seeing the effects of Shrinkage
What you are seeing here is the effect of 35% shrinkage and a particular threshold.

It's easier to see this using the Online Erlang calculator

So 14 number of calls per 60 minutes = 2.244 Erlangs - AHT 577 secs - 80% Answered in 60 secs - Shrinkage 35% - Max Occupancy 85%.
Gives 4 Agents before Shrinkage = 6 agents after shrinkage

Increase the AHT by one second takes you over a threshold
14 number of calls per 60 minutes = 2.248 Erlangs - AHT 578 secs - 80% Answered in 60 secs - Shrinkage 35% - Max Occupancy 85%.
Gives 7 Agents before Shrinkage = 7.5 agents after shrinkage
In the case of The Excel calculator this rounds it up to 8.

Looking at the chart at the bottom of the Online Calculator if you had 4 agents before shrinkage (6 agents after shrinkage) you would have a service level of 79.9% which is just below the 80% threshold which is why it adds one agent before shrinkage.

So the issue is around how you round the number of agents with shrinkage.
4 Agents before 35% shrinkage = 4 / ( 1 - 0.35) = 6.15 Agents after shrinkage
5 Agents before 35% shrinkage = 5 / ( 1 - 0.35) = 7.69 Agents after shrinkage

One agent before shrinkage will add 1.54 agents after shrinkage. So depending on how you round up the number of agents will give different results.

So the calculator is working as intended, but that is one of the challenges with Erlang as it works in increments of 1 agent before shrinkage.

You should find that the Online Caclulator will give better results.

Thank you very much for the explanation. I thought it was something like that but the confirmation was super helpful as my experience here is limited. Yes, the Excel function can only return one thing vs the On-Line Calculator can return the table
Very much appreciated.

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