1. Calculation functions
2. All Functions
3. Call Center Planning Functions
4. ERLANG-B

Calculates the probability a call will be blocked entirely, assumes there are no calls on queue.

## Equation:

ERLANG-B is the solution to this equation:

where:

• call arrival rate multiplied by the average of call duration = y * z

## Syntax

`ERLANGB(x, y, z) `

where:

• x: number of servers, telephone lines, or agents
• y: arrival rate of calls or the number of calls per unit of time
• z: average call duration

## Format

Input Format Output Format

x: number

y: number (time unit)

z: number (time unit)

Number

## Arguments

The function uses the following arguments:

• x: Number - Numeric line item, property, or expression.
• y: Number - Numeric line item, property, or expression - Must match the unit used for argument z.
• z: Number - Numeric line item, property, or expression - Must match the unit used for argument y.

## Constraints

The function has the following constraints:

• All parameters are mandatory.
• All parameters must be a numeric line item, property, or expression.
• Time unit used for the y and z parameters must be the same.
• Result line item must be numeric.
• Maximum number of agents is five million.

## Excel equivalent

• No Excel equivalent

## Example

In this example, we have four call centers each covering a separate geographical area:

• Each call center is modeled under the assumption that no queuing is available—if all agents are occupied when a call arrives, then the call will be blocked.
• Agent staffing levels for each call center are known.
• The arrival rate of incoming calls and the average call duration are known for each call center from historical monitoring of operational performance.

With the baseline metrics entered for each call center in numeric source line items for Agent Numbers,Arrival Rate (calls/sec), and Average Call Duration (sec), we can use ERLANG-B function in a Blocking Probability numeric result line item to calculate the probability a call will be blocked:

`ERLANGB(Agent Numbers, 'Arrival Rate (calls/sec)','Average Call Duration(sec)')`

If we want to improve on the blocking probability for incoming calls—perhaps to bring it down closer to a 0.06 probability—then we can add an alternative numeric source line item for Surplus Agents and then introduce a second ERLANG-B calculation for a Reduced Blocking Probability numeric result line item, allowing us to perform what-if analysis by entering a number of extra agents until we reach the desired blocking probability:

`ERLANGB(Surplus Agents, 'Arrival Rate (calls/sec)','Average Call Duration(sec)')`