Abstract
Monthly sales data for products whose sales fluctuate regularly according to the day of the week may be subject to a source of variation which makes model fitting and forecasting more difficult. This problem is described and illustrated within the context of the ARIMA class of univariate models. Procedures to recognize and account for the problem are presented, and improvements in the ability to forecast future sales are noted in the sample series examined.
Similar content being viewed by others
References
Bell, W.R. and Hillmer, S.C. 1981. “Modeling Time Series with Calendar Variation.” University of Kansas School of Business Working Paper.
Box, George E.P. and Jenkins, Gwylim 1970.Time Series Analysis: Forecasting and Control, San Francisco: Holden-Day.
— 1975. “Intervention Analysis with Applications to Economic and Environmental Problems.”Journal of the American Statistical Association, 70 (March) 70–79.
Cleveland, William and Devlin, Susan 1980. “Calendar Effects in Monthly Time Series: Detection by Spectrum Analysis and Graphical Methods,”Journal of the American Statistical Association, 75 (September) 487–496.
Dalrymple, Douglas J. 1978. “Using Box-Jenkins Techniques in Sales Forecasting.”Journal of Business Research 6 (May) 133–145.
Eisenpress, Harry 1956. “Regression Techniques Applied to Seasonal Corrections and Adjustments for Calendar Shifts.”Journal of the American Statistical Association, 51 615–620.
Geurts, Michael D. and Ibrahim, I.B. 1975. “Comparing the Box-Jenkins Approach with the Exponentially Smoothed Forecasting Model with an Application to Hawaii Tourists.”Journal of Marketing Reserch 12 (May) 182–187.
Granger, C.W.J. and Newbold, Paul 1977.Forecasting Economic Time Series, New York: Academic Press.
Helmer, Richard M. and Johansson, Johny K. 1977. “An Exposition of the Box-Jenkins Transfer Function Analysis with an Application to the Advertising-Sales Relationship.”Journal of Marketing Research 14 (May) 227–239.
Kapoor, S.G., Madhok, P. and Wu, S.M. 1981. “Modeling and Forecasting Sales Data by Time Series Analysis.”Journal of Marketing Research 18 (February) 94–100.
Liu, Lon-Mu 1980. “Analysis of Time Series with Calendar Effects”Management Science, 26 (January) 106–112.
Makridakis, Spyros and Wheelwright, Steven C. 1977. “Forecasting: Issues and Challenges for Marketing Management.”Journal of Marketing 41 (October) 24–38.
Moriarty, Mark and Adams, Arthur 1979. “Issues in Sales Territory Modeling and Forecasting Using Box-Jenkins Analysis.”Journal of Marketing Research, 16 (May) 221–232.
Nelson, Charles R. 1973.Applied Time Series Analysis, San Francisco: Holden-Day.
— 1976. “Gains in Efficiency from Joint Estimation of Systems of Autoregressive-Moving Average Processes.”Journal of Econometrics, 4 (July) 331–348.
Neter, John and Wasserman, William 1974.Applied Linear Statistical Models, Homewood, Illinois: Richard D. Irwin.
Pfefferman, D. and Fisher J. 1980. “Festival and Working Days Prior Adjustments in Economic Time Series” inTime Series, O.D. Anderson (ed.) New York: North Holland.
Pierce, David 1971. “Least Squares Estimation in the Regression Model with Autoregressive-Moving Average Errors.”Biometrika, 58, 299–312.
Plosser, Charles I. 1979. “Short-Term Forecasting and Seasonal Adjustment,”Journal of the American Statistical Association, 74 (March) 15–24.
Shiskin, Julius Young, Allan H. and Musgrave, John C. 1967. “The X-Il Variant of the Census Method II Seasonal Adjustment Program.” Bureau of the Census Technical Paper, Department of Commerce.
Author information
Authors and Affiliations
Rights and permissions
About this article
Cite this article
Adams, A.J. Using the calendar to improve sales forecasts. JAMS 12, 103–112 (1984). https://doi.org/10.1007/BF02739322
Issue Date:
DOI: https://doi.org/10.1007/BF02739322