Aldor-Noiman, Sivan; Feigin, Paul D.; Mandelbaum, Avishai Workload forecasting for a call center: methodology and a case study. (English) Zbl 1185.62204 Ann. Appl. Stat. 3, No. 4, 1403-1447 (2009). Summary: Today’s call center managers face multiple operational decision-making tasks. One of the most common is determining the weekly staffing levels to ensure customer satisfaction and meeting their needs while minimizing service costs. An initial step for producing the weekly schedule is forecasting the future system loads which involves predicting both arrival counts and average service times. We introduce an arrival count model which is based on a mixed Poisson process approach. The model is applied to data from an Israeli Telecom company call center. In our model, we also consider the effect of events such as billing on the arrival process and we demonstrate how to incorporate them as exogenous variables in the model. After obtaining the forecasted system load, in large call centers, a manager can choose to apply the QED (Quality-Efficiency Driven) regime’s “square-root staffing” rule in order to balance the offered-load per server with the quality of service. Implementing this staffing rule requires that the forecasted values of the arrival counts and average service times maintain certain levels of precision. We develop different goodness of fit criteria that help determine our model’s practical performance under the QED regime. These show that during most hours of the day the model can reach desired precision levels. Cited in 14 Documents MSC: 62P99 Applications of statistics 60K30 Applications of queueing theory (congestion, allocation, storage, traffic, etc.) 90B50 Management decision making, including multiple objectives 62M99 Inference from stochastic processes Keywords:call centers; QED regime; square-root staffing; forecasting arrival count; exogenous variables Software:DATA-MOCCA; R × Cite Format Result Cite Review PDF Full Text: DOI arXiv References: [1] Aksin, Z., Armony, M. and Mehrota, V. (2007). The modern call-center: A multi-disciplinary prespective on operations management research. Production and Operations Management 16 465-688. [2] Aldor-Noiman, S., Feigin, P. D. and Mandelbaum, A. (2009). Supplement to “Workload forecasting for a call center: Methodology and a case study.” DOI: 10.1214/09-AOAS255SUPP. · Zbl 1185.62204 · doi:10.1214/09-AOAS255 [3] Andrews, B. H. and Cunningham, S. M. (1995). L. L. Bean improves call-center forecasting. Interfaces 25 1-13. [4] Antipov, A. and Meade, N. (2002). Forecasting call frequency at a financial services call centre. J. Oper. Res. Soc. 53 953-960. · Zbl 1139.90361 · doi:10.1057/palgrave.jors.2601415 [5] Avramidis, A. N., Deslauriers, A. and L’Ecuyer, P. (2004). Modeling daily arrivals to a telephone call center. Management Science 50 896-908. · Zbl 1232.90268 · doi:10.1287/mnsc.1040.0236 [6] Borst, S., Mandelbaum, A. and Reiman, M. (2004). Dimensioning large call centers. Oper. Res. 52 17-34. · Zbl 1165.90388 · doi:10.1287/opre.1030.0081 [7] Brown, L. D., Gans, N., Mandelbaum, A., Sakov, A., Shen, H., Zeltyn, S. and Zhao, L. (2005). Statistical analysis of a telephone call center: A queueing-science prespective. J. Amer. Statist. Assoc. 100 36-55. · Zbl 1117.62303 · doi:10.1198/016214504000001808 [8] Brown, L. D., Zhang, R. and Zhao, L. (2001). Root un-root methodology for non parameteric density estimation. Techical report, The Wharton School, Univ. Pennsylvania. [9] Demidenko, E. (2004). Mixed Models: Theory and Applications . Wiley, Haifa, Israel. · Zbl 1055.62086 [10] Feigin, P., Mandelbaum, A., Ishay, E., and Trofimov, V. (2003). Data MOCCA-Data MOdel for Call Center Analysis. Technical report, Technion-Israel Institute of Technology. Available at http://iew3.technion.ac.il/ serveng/course2004/References/DataMOCCA.pdf. [11] Feldman, Z., Mandelbaum, A., Massey, W. A. and Whitt, W. (2008). Staffying of time-varying queues to achieve time-stable performance. Management Science 54 324-338. Available at http://iew3.technion.ac.il/serveng/References/FeldmanMMW020507.pdf. · Zbl 1232.90275 [12] Gans, N., Koole, G. and Mandelbaum, A. (2003). Telephone call centers: Tutorial, review, and research prospects. Manufacturing and Service Operations Management 5 79-141. [13] Gilson, K. A. and Khandelwal, D. K. (2005). Getting more from call centers. The McKinsey Quartely . Available at http://www.evolvondemand.com/download_file_684.pdf. [14] Henderson, C. R. (1975). Best linear unbiased estimation and prediction under a selection model. Biometrics 31 423-447. · Zbl 0335.62048 · doi:10.2307/2529430 [15] Holman, D., Batt, R. and Holtgrewe, U. (2007). The global call center report: International perspectives on managment and employment. ILR Collection, Research Studies and Reports, Cornell Univ. Available at http://www.ilr.cornell.edu/globalcallcenter/upload/GCC-Intl-Rept-US-Version.pdf. [16] Jongbloed, G. and Koole, G. (2001). Managing uncertainty in call centers using Poisson mixtures. Appl. Stoch. Models Bus. Ind. 17 307-318. · Zbl 1071.90012 · doi:10.1002/asmb.444 [17] Mandelbuam, A. (2004). Call centers (centres) research bibiliography with abstracts. Chapter two details Statistics and Forecasting related papers. Available at http://iew3.technion.ac.il/ serveng/References/references.html. [18] Manedelbaum, A. and Zeltyn, S. (2007). Staffing many-server queues with impatient customers: Constraint satisfation in call centers. Oper. Res. · Zbl 1233.90121 · doi:10.1287/opre.1080.0651 [19] McCullagh, P. and Nedler, J. A. (1989). Generalized Linear Models , 2nd ed. Chapman & Hall, Boca Raton, FL. · Zbl 0744.62098 [20] R Development Core Team (2005). R: A Language and Environment for Statistical Computing . R Foundation for Statistical Computing, Vienna, Austria. ISBN 3-900051-07-0. Available at http://www.R-project.org. [21] Sakamoto, Y., Ishiguro, M. and Kitagawa, G. (1999). Akaike Information Criterion Statistics . Springer, New York. · Zbl 0608.62006 [22] SAS (2004). SAS OnlineDoc \textregistered 9.1.3 . SAS Institute Inc., Cary, NC. [23] Shen, H. and Huang, J. Z. (2005). Analysis of call centre arrival data using singular value decomposition. App. Stoch. Models Bus. Ind. 21 251-263. · Zbl 1089.62155 · doi:10.1002/asmb.598 [24] Shen, H. and Huang, J. Z. (2008a). Forecasting time series of inhomogeneous poisson process with application to call center workforce management. Ann. App. Statist. 2 601-623. · Zbl 1400.62350 · doi:10.1214/08-AOAS164 [25] Shen, H. and Huang, J. Z. (2008b). Interday forecasting and intraday updating of call center arrivals. Manufacturing and Service Operations Management 10 391-410. [26] Soyer, R. and Tarimcilar, M. M. (2008). Modeling and analysis of call center arrival data: A Bayesian approach. Managment Science 54 266-278. [27] Tanir, O. and Booth, R. J. (1999). Call center simulation in Bell Canada. In Proceedings of the 1999 Winter Simulation Conference (P. A. Farrington, N. H. B. Nembhard, D. T. Sturrock and G. W. Evans, eds.) 1640-1647. IEEE Press, Piscataway, NJ. [28] Taylor, J. W. (2008). A comparison of univariate time series methods for forecasting intraday arrivals at a call center. Managment Science 54 253-265. · Zbl 1232.90214 · doi:10.1287/mnsc.1070.0786 [29] Weinberg, J., Brown, L. D. and Stroud, J. R. (2007). Bayesian forecasting of an inhomogeneous Poisson process with applications to call center data. J. Amer. Statist. Assoc. 102 1185-1199. · Zbl 1333.62297 · doi:10.1198/016214506000001455 [30] Whitt, W. (2005). Engineering solution of a basic call-center model. Managment Science 51 221-235. · Zbl 1232.90159 · doi:10.1287/mnsc.1040.0302 [31] Whitt, W. (2007). What you should know about queueing models to set staffing requirements in service systems. Naval Res. Logist. 54 476-484. · Zbl 1143.90322 · doi:10.1002/nav.20243 [32] Xu, W. (2000). Long range planning for call centers at Fedex. The Journal of Bussiness Forecasting Methods and Systems 18 7-11. [33] Zeltyn, S. (2005). Call centers with impatient customers: Exact analysis and many-server asymptotics of the M / M / N + G queue. Ph.D. thesis, Technion-Israel Institute of Technology. Available at http://ie.technion.ac.il/serveng/References/references.html. · Zbl 1085.60072 This reference list is based on information provided by the publisher or from digital mathematics libraries. Its items are heuristically matched to zbMATH identifiers and may contain data conversion errors. In some cases that data have been complemented/enhanced by data from zbMATH Open. This attempts to reflect the references listed in the original paper as accurately as possible without claiming completeness or a perfect matching.