An Empirical Comparison of the Sales Forecasting Performance for Plastic Tray Manufacturing Using Missing Data
Open Access
- 19 February 2022
- journal article
- research article
- Published by MDPI AG in Sustainability
- Vol. 14 (4) , 2382
Abstract
The problem of missing data is frequently met in time series analysis. If not appropriately addressed, it usually leads to failed modeling and distorted forecasting. To deal with high market uncertainty, companies need a reliable and sustainable forecasting mechanism. In this article, two propositions are presented: (1) a dedicated time series forecasting scheme, which is both accurate and sustainable, and (2) a practical observation of the data background to deal with the problem of missing data and to effectively formulate correction strategies after predictions. In the empirical study, actual tray sales data and a comparison of different models that combine missing data processing methods and forecasters are employed. The results show that a specific product needs to be represented by a dedicated model. For example, regardless of whether the last fiscal year was a growth or recession year, the results suggest that the missing data for products with a high market share should be handled by the zero-filling method, whereas the mean imputation method should be for the average market share products. Finally, the gap between forecast and actual demand is bridged by employing a validation set, and it is further used for formulating correction strategies regarding production volumes.Keywords
Funding Information
- Ministry of Science and Technology, Israel (110-2622-E-131 -008)
This publication has 48 references indexed in Scilit:
- A demand forecast model using a combination of surrogate data analysis and optimal neural network approachDecision Support Systems, 2013
- Technical Note: Comparing the effectiveness of recent algorithms to fill and smooth incomplete and noisy time seriesAtmospheric Chemistry and Physics, 2011
- Bias and efficiency of multiple imputation compared with complete‐case analysis for missing covariate valuesStatistics in Medicine, 2010
- SKU demand forecasting in the presence of promotionsExpert Systems with Applications, 2009
- Forecasting intermittent demand: a comparative studyJournal of the Operational Research Society, 2009
- A Comparison of Missing-Data Procedures for Arima Time-Series AnalysisEducational and Psychological Measurement, 2005
- Some properties of a simple moving average when applied to forecasting a time seriesJournal of the Operational Research Society, 1999
- Estimation, Prediction, and Interpolation for ARIMA Models with Missing DataJournal of the American Statistical Association, 1986
- Maximum Likelihood Fitting of ARMA Models to Time Series With Missing ObservationsTechnometrics, 1980
- Algorithm AS 154: An Algorithm for Exact Maximum Likelihood Estimation of Autoregressive-Moving Average Models by Means of Kalman FilteringJournal of the Royal Statistical Society Series C: Applied Statistics, 1980