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

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

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.

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.

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.

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

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

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)

Adjusted Arrival Rate0.91.10.890.77

Adjusted Average Waiting Time

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