Abstract:PurposeThis study examines the relationship between demand forecasting error and retail inventory management in an uncertain supplier yield context. Replenishment is segmented into off-season and peak-season, with the former characterized by longer lead times and higher supply uncertainty. In contrast, the latter incurs higher acquisition costs but ensures certain supply, with the retailer's purchase volume aligning with the acquired volume. Retailers can replenish in both phases, receiving goods before the sales season. This paper focuses on the impact of the retailer's demand forecasting bias on their sales period profits for both phases.Design/methodology/approachThis study adopts a data-driven research approach by drawing inspiration from real data provided by a cooperating enterprise to address research problems. Mathematical modeling is employed to solve the problems, and the resulting optimal strategies are tested and validated in real-world scenarios. Furthermore, the applicability of the optimal strategies is enhanced by incorporating numerical simulations under other general distributions.FindingsThe study's findings reveal that a greater disparity between predicted and actual demand distributions can significantly reduce the profits that a retailer-supplier system can earn, with the optimal purchase volume also being affected. Moreover, the paper shows that the mean of the forecasting error has a more substantial impact on system revenue than the variance of the forecasting error. Specifically, the larger the absolute difference between the predicted and actual means, the lower the system revenue. As a result, managers should focus on improving the quality of demand forecasting, especially the accuracy of mean forecasting, when making replenishment decisions.Practical implicationsThis study established a two-stage inventory optimization model that simultaneously considers random yield and demand forecast quality, and provides explicit expressions for optimal strategies under two specific demand distributions. Furthermore, the authors focused on how forecast error affects the optimal inventory strategy and obtained interesting properties of the optimal solution. In particular, the property that the optimal procurement quantity no longer changes with increasing forecast error under certain conditions is noteworthy, and has not been previously noted by scholars. Therefore, the study fills a gap in the literature.Originality/valueThis study established a two-stage inventory optimization model that simultaneously considers random yield and demand forecast quality, and provides explicit expressions for optimal strategies under two specific demand distributions. Furthermore, the authors focused on how forecast error affects the optimal inventory strategy and obtained interesting properties of the optimal solution. In particular, the property that the optimal procurement quantity no longer changes with increasing forecast error under certain conditions is noteworthy, and has not been previously noted by scholars. Therefore, the study fills a gap in the literature.

A New Metric for Lumpy and Intermittent Demand Forecasts: Stock-keeping-oriented Prediction Error Costs

Mean-based error measures for intermittent demand forecasting

An Exponential Factorization Machine with Percentage Error Minimization to Retail Sales Forecasting

New Forecasting Metrics Evaluated in Prophet, Random Forest, and Long Short-Term Memory Models for Load Forecasting

Business Metric-Aware Forecasting for Inventory Management

A New Approach of Forecasting Intermittent Demand for Spare Parts Inventories in the Process Industries

Training Demand Prediction Models by Decision Error for Two-Stage Lot-Sizing Problems

Scaling-aware rating of count forecasts

An Adaptive Data-driven Model for Erratic Demand Forecasting

Demand forecasting errors in industrial context: Measurement and impacts

Demand Forecasting and Budget Planning for Automotive Supply Chain

Cost-oriented load forecasting

A Strategic Demand Forecasting: Assessing Methodologies, Market Volatility, and Operational Efficiency

Assessing the Performance of Remaining Time Prediction Methods for Business Processes

Creation and Evaluation of a Food Product Image Dataset for Product Property Extraction

Elasticity Based Demand Forecasting and Price Optimization for Online Retail

Inventory Control Strategy: Based on Demand Forecast Error

Dynamic Model Selection Based on Demand Pattern Classification in Retail Sales Forecasting

Residual Value Forecasting Using Asymmetric Cost Functions

Making forecasting self-learning and adaptive -- Pilot forecasting rack

Decision-Focused Forecasting: Decision Losses for Multistage Optimisation