How to indentify needed Call Duration based on a Service Level Target

Im looking for a way to indentify needed Call Duration when I have the following information.
Calls per Interval = 437
Interval Seconds = 1800
Number of people = 98
Target Answer Time = 40secs
Service Level = 80%
How do I indentify the highest possible call duration for that interval and answer 80% of those calls (437) within 40secs?
I'm looking of an excel formula if possible.....
redrpAsked:
Who is Participating?
 
J79123Commented:
I don't think there is a "highest possible", or maximize sort of thing here, because there is no variable you can change. You have a target of 80%, so it would just be a straight formula.
 So if I'm understanding your question this is just a math question with a straight formula answer. Is this a homework problem? :)

This is what I came up with = 468 seconds/call

I broke it down on the attached spreadsheet as little formulas and one big one as well.

Number of Calls       437       calls
Number of Phones or People       98       phones
Time to answer (Lost Time)       40       seconds
Interval in Seconds       1,800       seconds
Target % of Calls to answer      80%      
            
Total Seconds available=Phones x Interval
=176,400.00 seconds
            
Time to Answer (Lost time) = Number of Calls x Time to answer x Target % of calls to answer       =13,984.00 seconds
            
Available time for call duration = Total Seconds avail. - Time to Answer targeted calls      
=162,416      seconds
            
Calls Answered = Target % x # of Calls
=349.60 calls
            
Duration of each answered Calls
= 464.58       seconds
            
Duration as one formula:
((Phone x Interval) - (Number of Calls x Time to Answer x Target %))/(# of Calls x Target %)       


phones.xls
0
 
Patrick MatthewsCommented:
redrp,

Native Excel functions cannot handle Erlang C queuing calculations.  You would need a UDF.

That said, there are numerous free-to-cheap Erlang C calculators available on the web.  I would simply take one and start fiddling with it until your answers start to converge.

J79123,

This question is about queuing using the Erlang C algorithm, which assumes that calls arrive randomly in a Poisson distribution, and for which a certain service level is the goal.  It is typically used to determine the number of agents required to handle the call volume given the expected volume, the avg handle time, and the service level, but of course it can be turned around to output one of the input parameters instead if we make the number of agents a given.

:)

Patrick
0
 
redrpAuthor Commented:
Hey Guys,

I am sorry I haven't responded. I am looking at this and will close out the question today, for the record, this is not a homework question :)  

Thanks,

John
0
 
TracyVBA DeveloperCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.