 |
Erlang Library for Excel Function Reference |
|
Erlang Library for Excel Function Reference |
Returns the number of servers needed to carry a specified traffic load with a specified service level.
ErlcNsrvFromFractionOk5( secondsPerPeriod, callsPerPeriod, ahtSeconds, okWaitSeconds, fractionOk)
secondsPerPeriod is the period length in seconds.
callsPerPeriod is the number of calls arriving in the period.
ahtSeconds is the average handle time (average duration of service).
okWaitSeconds is the maximum acceptable wait time for customers.
fractionOk is the fraction of customers who begin service after a wait that does not exceed okWaitSeconds.
| Formula | Description | Return Value |
|---|---|---|
| =ErlcNsrvFromFractionOk5( 1800, 936, 180, 10, 0.90) | Returns the number of agents (servers) required to carry 936 calls during period of length 1800 seconds, with 90% of callers beginning service after a wait of less than 10 seconds. Assumes the Erlang C queueing model assumptions apply. | 104.679 |
| =ErlcNsrvFromFractionOk5( 1800, 936, 180, 10, 0.95) | Same as the preceding, except we require that 95% of callers begin service after a wait of less than 10 seconds. | 107.502 |
ErlcNsrvFromFractionOk5(secondsPerPeriod As Double,
callsPerPeriod As Double, ahtSeconds As Double, okWaitSeconds As Double, fractionOk
As Double) As Double This is one of the most popular of the Erlang functions. You use ErlcNsrvFromFractionOk5 to estimate number of agents required to staff a call center (see the Case Study below).
Also see the closely related function ErlcNsrvFromFractionOk, which computes the same quantity, but uses a different argument list.
If this function is not available, and returns the #NAME? error, then you must install and load the Erlang Library for Excel from Abstract Micro Systems.
How?
Suppose that during a certain period of the day, a call center has these characteristics:
| Maximum number of calls that can be waiting: | Very large |
| Period length: | 30 minutes |
| Incoming calls offered during the period: | 1234 |
| Average handle time: | 323 seconds |
| Service Level Goal | 90% answered within 20 seconds |
How many agents are needed to achieve the service level goal?
Suppose further that calls arrive in a Poisson process, that service times are exponential, and that callers who must wait are infinitely patient and will stay on the line until their call is answered (i.e., that no callers abandon). Then the call center satisfies the assumptions of the Erlang C queueing model, so we can make a staffing calculation using ErlcNsrvFromFractionOk5.
The required number n of agents to achieve the service level goal is
n = ErlcNsrvFromFractionOk5(
1800, 1234, 323, 20, 0.90)
= 235.88
We conclude that we need about 236 agents to achieve the desired quality of service.