The demand for products in the retail industry is often characterized by intermittent and volatile patterns. Specifically, at the SKU level, the demand exhibits intermittent and lumpy behavior, which presents challenges for accurate forecasting due to demand fluctuations and interval uncertainty. This study proposes an exponential smoothing (ES)-based model, called ES-C-T, that incorporates contemporaneous and temporal aggregation to forecast intermittent and lumpy retail demand. The ES-C-T model consists of three stages. Firstly, the ES model predicts the sales of each product by aggregating contemporaneously across all stores, and the resulting predictions are allocated to the SKU level using a weight vector. Secondly, the ES model forecasts the sales of each SKU by aggregating temporally within each store. Finally, the ES-C-T model derives a weight coefficient based on the predictions from the first and second stages, adjusts the initial predictions, and utilizes this as the final forecast. To validate the effectiveness of the ES-C-T model, sales data from a large Chinese convenience store chain are employed. The results demonstrate that the proposed ES-C-T model outperforms the benchmark model in terms of MAE, RMSE, and WRMSSE, effectively predicting retail sales for intermittent and lumpy demand.
Read full abstract