Hierarchical Demand Forecasting for Factory Production of Perishable Goods

Can Chen,Yijun Wang,Guoan Huang,Hui Xiong
DOI: https://doi.org/10.1109/bigdata47090.2019.9006161
2019-12-01
Abstract:Demand forecasting factory production is of particular importance for retailers of perishable goods, as they are produced daily with a fixed production lead time. Over- or underestimating demand can result in loss of profits due to stock-outs or overstock. However, demand forecasting and production planning for perishable goods represent a significant challenge due to factors such as high volatility, significant variation, the dynamics of store-level product demand, and the need for L day ahead forecasting that allows enough time for production planning. By collaborating with a leading perishable product retailer, we have analyzed (1) detailed internal supply chain data, including sales transaction records and day-end inventories, along with (2) environmental factors, including temperature, weather conditions and wind speed. With the aim of minimizing loss of profit caused by inaccurate forecasting, we propose the following three-stage hierarchical demand forecasting model that leverages the combined data for perishable goods production planning: 1. Identification of store-level demand patterns, 2. store clustering for aggregated production, and 3. a recurrent dynamic network based on a nonlinear autoregressive network with exogenous inputs (NARX) for L-day ahead demand forecasting. Finally, we validate the proposed approach by comparing the loss of profits using this model with other baselines along with the industry standard model used in the perishable goods industry. Our proposed model successfully reduces lost profits to 3.30% of total sales, representing a reduction of 1.71% when compared with the industry standard production system.
What problem does this paper attempt to address?