Head Count calculation

Topic Views - 733

Head Count calculation
dear all,
kindly i need to calculate the head count for queue get the below
-Calls = 40000 per month
-AHT = 180 sec per call
-Queue working hours = 15 hour from 11:00 till 02:00
- shift per agent 9 hour as 8 hour working and 1 hour breaks
-SLA 80% / 20 Sec
-official vacation = 14
- Annual = 21
-Sick = 9
Off = 104 as week 8 days

Thanks

FTE - 17
Work load = 40000*180 , =120000
Planned Shrinkage = 16.67%
FTE without shrinkage = 120000/480*18.33, =~14
FTE with shrinkage =+14/(1-16.67%) , =~17

Not considered SLA while calculation
Unplanned shrinkage considered as zero%
Queue working window is request while potting the shifts

Editor

Call Centre Helper

Use an Erlang calculator
You can't just spread the call volume across the month as it does not arrive evenly. You also have to factor in service level.

https://www.callcentrehelper.com/tools/erlang-calculator/

replay on Jonty Pearce
Have You an excel sheet like the online.
thanks

Editor

Call Centre Helper

Excel Erlang calculator
Here is an Excel Version

https://www.callcentrehelper.com/erlang-c-calculator-2473.htm

It does not have all of the advanced functions but it has the core ones.

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