Multivariate Time Series Analysis for Optimum Production Forecast: A Case Study of 7up Soft Drink Company in Nigeria

Abstract

This study focuses on the establishment of an optimum forecast model that predicts future production trends of 7UP Bottling company. Sixty (60)
months time series data of 7UP bottling company were used after ascertaining the presence of seasonal variation and trend components of the data to establish the multidimensional forecast model. Predictive Production rate model was developed using a general multivariate regression equation form. The monitoring schemes show values of MSE and MAD as 0.0177 and 0.0658 respectively giving a tracking signal of 0.0. These values established the multivariate forecast model as optimum approach in tracking demand and production trends in a production setup. The value of the standard deviation of distribution of errors of 0.0823 estimated with MAD also confirms the authenticity of this model. The responses shown in the graphics of this study clearly explains the mixed time series which definitely contains seasonal variation and trend components as established in this study. Also the coefficient of determination of 0.957956 explains about 97% fitness of the established model to production data. The trend component associated with time variable (Mtncod) causes production to increase by 0.002579KG/Month. Finally, this work adds to the growing body of literature on data-driven production and inventory management by utilizing historical data in the development of useful forecasting mathematical model.

Keywords: production model, inventory management, multivariate time
series, production forecast