Modeling and Forecasting Sales Data by Time Series Analysis

Abstract

Time series modeling technique is used to model a series of sales data in which seasonality causes distinct spike peaks. The analysis of actual sales data shows that the seasonality in the data can be approximated by a deterministic function and the stochastic component is a sixth-order autoregressive moving average model. Use of the combined deterministic and stochastic models to derive the minimum mean squared forecast yields reliable results.

Get full access to this article

View all access options for this article.

References

Box

G. E. P.

and Jenkins

G. M.

(1970), Time Series Analysis, Forecasting, and Control. San Francisco: Holden-Day.

Brown

R. G.

(1962), Smoothing, Forecasting, and Prediction of Finite Time Series. Englewood Cliffs, New Jersey: Prentice Hall, Inc.

Geurts

M. 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 Research, 12 (May), 182–7.

Helmer

R. M.

and Johansson

J. 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–39.

Mabert

V. A.

and Radcliffe

R. C.

(1974), “A Forecasting Methodology as Applied to Financial Time Series,” Accounting Review (January), 61–75.

Moriarty

and Adams

(1979), “Issues in Sales Territory Modeling and Forecasing Using Box-Jenkins Analysis,” Journal of Marketing Research, 16 (May), 221–32.

Pindyck

R. S.

and Rubenfeld

D. L.

(1976), Econometric Models and Economic Forecasts. New York, McGraw-Hill Book Company.

Slutsky

(1927), “The Summation of Random Causes as the Source of Cyclic Processes” (Russian with English summary), Problems of Economic Conditions (Institute of Economic Conjecture, Moscow), 3, revised English ed. in Econometrika, 5, 105 (1937).

Tiao

G. C.

and Pack

D. J.

(1975), “Modeling the Consumption of Frozen Concentrated Orange Juice: A Case Study of Time Series Analysis,” Academic Economic Papers, 3 (February).

10.

S. M.

(1977), “Dynamic Data System—A New Modeling Approach,” ASME Transactions, Series B, 99, 708–14.