# Tag Archives: call center formulas excel

## Call Center Service Level : Definition and Calculation

Call center service level is defined as the percentage of calls being answered in a specified time. Service level or SL as it is commonly known is the most basic and essential parameter to track a callcenter’s performance.
Most times you will get a service level target like 80-20 or 90-60 or any similar value which is a combination of two figures. Let’s understand what this means. When you get a SL target of 80-20 this means you are expected to answer 80% calls within 20 seconds, that is 80% calls offered on your callcenter should have a queue time of less than 20 seconds.
Similarly a service level of 90-60 would mean that 90% calls should be answered within 60 seconds.
Now that you understand the meaning of the term, let’s move to the calculation part of it.
Suppose you have been given a SL target of 85-15, that is answering 85% calls in 15 seconds. You will require the following values:
1. Total calls offered during the interval for which SL has to be calculated
2. Calls answered within 15 seconds (You will get this value from ACD report, that is the software you use to distribute calls across callcenter)

Now that you have these 2 values it is fairly simple to calculate SL. The formula is”
Call center Service Level = (Calls answered within said duration / Total calls offered_ * 100

For example in above case if the total calls offered were 1000 and the total calls answered within 15 seconds were 900 then the Service level would be:
Service Level = 900/1000 * 100 = 90%

Since the target given to us was 85-15 that is to answer 85% calls in 15 seconds and we have answered 90% calls in 15 seconds, hence the SL target is considered met.
Suppose we had answered 800 calls in 15 seconds then the service level would have been 800/1000*100= 80%, so the SL target was missed.
Hope this clarifies your doubts about this topic, if not just leave a comment below and I will get back to you with the solution.

Get your free excel template of daily performance report pre-loaded with Service level, AHT and other formulae in your mail by registering here