1. Calculation functions
  2. All functions
  3. Call center planning functions
  4. AVGWAIT

The AVGWAIT function calculates the average waiting time for a request or call to be processed.

Syntax

AVGWAIT(Number of servers, Arrival rate, Average duration)

Arguments

ArgumentData typeDescription
Number of servers (required)NumberThe number of servers (for example, call center agents) available to process requests.
Arrival rate (required)NumberThe interval between the arrival of each request.
Average duration (required)NumberThe average duration it takes to process each request.

The AVGWAIT function returns a number. This is the average waiting time for a request to be processed, using the same time unit as the Arrival rate and Average duration arguments.

Additional information

How the AVGWAIT function is calculated

The ANSWERTIME function calculates the solution to this equation:

AVGWAIT(x,y,z)=(ERLANGC(x,a)z)x(1p)\text{AVGWAIT}(x,y,z) = \dfrac{(\text{ERLANGC}(x,a)*z)}{x * (1 - p)}

In this equation:

  • x is the Number of servers.
  • y is the Arrival rate.
  • z is the Average duration.
  • a is the offered load, which is y multiplied by z.
  • p is the offered load per server, which is a divided by x.

Constraints

Time unit for arguments

The Arrival rate and Average duration arguments do not have to use a specific time unit. For example, they can use seconds or minutes. However, both arguments must use the same time unit.

Maximum number of servers

The maximum number you can use for the Number of servers argument is five million.

Calculation engine functionality differences

Call center planning functions are unavailable in Polaris. Learn more about the differences between Anaplan calculation engines.

Related Anaplan functions

Examples

In this example, the Call Centers list is on columns, and line items on rows. The first three line items contain the data for the AVGWAIT function for each call center:

  • The scheduled number of servers to process requests
  • The arrival rate, or interval between each request arriving
  • The average duration it takes to complete requests

The fourth line item uses the AVGWAIT function to calculate what the average waiting time for a request to be processed given the number of servers, arrival rate, and average duration to process requests.

The fifth line item enables you to adjust the arrival rate of requests. The formula in the sixth line item uses the adjusted arrival. This enables you to see how the average waiting time changes given a different arrival rate. A value of Infinity is given for Call Center 2 because the rate of incoming requests is higher than the ability to process them, which means that calls have to wait indefinitely.


Call Center 1Call Center 2Call Center 3Call Center 4
Scheduled Number of Servers25455039
Request Arrival Rate0.840.930.690.68
Average Duration25464545

Average Waiting Time

AVGWAIT(Scheduled Number of Servers, Request Arrival Rate, Average Duration)

1.921306313.46415120.002704530.53752576
Adjusted Arrival Rate0.91.10.890.77

Adjusted Average Waiting Time

AVGWAIT(Scheduled Number of Servers, Adjusted Arrival Rate, Average Duration)

5.07923029Infinity0.400008753.82731801

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.