Integrated Inventory Planning Using Periodic Review and Discrete Event Simulation for Perishable Products in Retail
Year: 2026
Type: article
Abstract: Perishable products pose inventory management challenges in retail due to their limited shelf life and susceptibility to waste; inventory decisions must balance product availability against excessive stock and lost sales. This study develops an integrated inventory planning framework combining sales forecasting, periodic review inventory policies, and Discrete Event Simulation (DES) to evaluate inventory performance in retail operations. A quantitative simulation-based quasi-experimental design was employed using secondary data from ten retail stores in Indonesia. The dataset comprised daily sales from 1 October to 31 December 2025, shelf life, lead time, minimum order quantity, opening stock, and existing company inventory policies. The DES model simulated daily inventory movements, including replenishment, deliveries, sales, waste, and lost sales, enabling inventory performance evaluation at the product, department, and store levels. Across ten stores, the aggregated waste ratio was 5%, while the lost sales ratio was 4%. At the product level, Leafy A1 recorded waste and lost sales ratios of 2% each, whereas Salad Q14 recorded 13% and 11%, respectively. These variations across products highlight opportunities for improvement in inventory planning. Integrating periodic review policies with daily DES provides a practical framework for evaluating replenishment decisions and identifying inventory performance issues across multiple products and stores. Further research should investigate alternative review periods, dynamic safety stock, improved forecasting accuracy, and product-age tracking to further improve inventory performance and reduce waste.
Institution: Mercu Buana University
Language: English
Field: Decision Sciences
Domain: Social Sciences
Open Access status: diamond
Funder: Universitas Mercu Buana
OpenAlex ID: W7236393604
