How Periodic Forecast Updates Influence MRP Planning Parameters: A Simulation Study

Klaus Altendorfer,Wolfgang Seiringer,Thomas Felberbauer,Balwin Bokor,Fabian Brockmann

2024-03-17

Abstract:In many supply chains, the current efforts at digitalization have led to improved information exchanges between manufacturers and their customers. Specifically, demand forecasts are often provided by the customers and regularly updated as the related customer information improves. In this paper, we investigate the influence of forecast updates on the production planning method of Material Requirements Planning (MRP). A simulation study was carried out to assess how updates in information affect the setting of planning parameters in a rolling horizon MRP planned production system. An intuitive result is that information updates lead to disturbances in the production orders for the MRP standard, and, therefore, an extension for MRP to mitigate these effects is developed. A large numerical simulation experiment shows that the MRP safety stock exploitation heuristic, that has been developed, leads to significantly improved results as far as inventory and backorder costs are concerned. An interesting result is that the fixed-order-quantity lotsizing policy performs - in most instances - better than the fixed-order-period lotsizing policy, when periodic forecast updates occur. In addition, the simulation study shows that underestimating demand is marginally more costly than overestimating it, based on the comparative analysis of all instances. Furthermore, the results indicate that the MRP safety stock exploitation heuristic can mitigate the negative effects of biased forecasts.

General Economics

What problem does this paper attempt to address?

This paper discusses how periodic forecast updates affect Material Requirements Planning (MRP) parameters. The study evaluates how information updates impact the parameter settings of MRP in a rolling planning system through simulation experiments. The paper points out that forecast updates cause disruptions in production orders in MRP standards and develops an extended MRP method to mitigate these impacts. The study finds that, compared to the fixed order quantity policy, the fixed order period policy generally performs better in the case of periodic forecast updates. Additionally, the paper proposes an MRP safety stock utilization heuristic method, which can significantly reduce inventory and backlog costs as well as alleviate the negative effects of biased forecasts. The research also demonstrates that underestimating demand incurs higher costs than overestimating, and the utilization of safety stock can mitigate the negative effects of inaccurate forecasts. The paper mainly investigates three issues: the impact of demand forecast updates on the optimization of MRP parameters, performance improvements of rolling planning systems with a safety stock utilization heuristic, and the effects of temporary and permanent forecast biases on optimizing MRP planning parameters and costs.