Call center demand forecasting : improving sales calls prediction accuracy through the combination of statistical methods and judgmental forecast
Name
659558470-MIT.pdf
Description
Full printable version
Size
11.13 MB
Format
Adobe PDF
Checksum (MD5)
a3901e36a62166c58fff73f2b51c746a
Author(s)
Boulin, Juan Manuel
Advisor(s)
Roy E. Welsch and David Simchi-Levi.
Date Issued
2010
Publisher
Massachusetts Institute of Technology
Abstract
Call centers are important for developing and maintaining healthy relationships with customers. At Dell, call centers are also at the core of the company's renowned direct model. For sales call centers in particular, the impact of proper operations is reflected not only in long-term relationships with customers, but directly on sales and revenue. Adequate staffing and proper scheduling are key factors for providing an acceptable service level to customers. In order to staff call centers appropriately to satisfy demand while minimizing operating expenses, an accurate forecast of this demand (sales calls) is required. During fiscal year 2009, inaccuracies in consumer sales call volume forecasts translated into approximately $1.1M in unnecessary overtime expenses and $34.5M in lost revenue for Dell. This work evaluates different forecasting techniques and proposes a comprehensive model to predict sales call volume based on the combination of ARIMA models and judgmental forecasting. The proposed methodology improves the accuracy of weekly forecasted call volume from 23% to 46% and of daily volume from 27% to 41%. Further improvements are easily achievable through the adjustment and projection processes introduced herein that rely on contextual information and the expertise of the forecasting team.
Description
Thesis (M.B.A.)--Massachusetts Institute of Technology, Sloan School of Management; and, (S.M.)--Massachusetts Institute of Technology, Engineering Systems Division; in conjunction with the Leaders for Global Operations Program at MIT, 2010.
Cataloged from PDF version of thesis.
Includes bibliographical references (p. 79-81).
Subjects
Sloan School of Management.
Engineering Systems Division.
Leaders for Global Operations Program.
MIT Department
Leaders for Global Operations Program at MIT
Massachusetts Institute of Technology. Engineering Systems Division
Sloan School of Management
Terms of Use
M.I.T. theses are protected by
copyright. They may be viewed from this source for any purpose, but
reproduction or distribution in any format is prohibited without written
permission. See provided URL for inquiries about permission.
copyright. They may be viewed from this source for any purpose, but
reproduction or distribution in any format is prohibited without written
permission. See provided URL for inquiries about permission.
Persistent DSpace Link