Integrated Inventory Planning Using Periodic Review and Discrete Event Simulation for Perishable Products in Retail

Authors

  • Yulida Intani Dewi Industrial Engineering, Faculty of Engineering, Mercu Buana University, Indonesia
  • Zulfa Fitri Ikatrinasari Industrial Engineering, Faculty of Engineering, Mercu Buana University, Indonesia

DOI:

https://doi.org/10.38035/gijes.v4i3.1525

Keywords:

Discrete-event simulation, inventory control, periodic review, perishable products, retail, waste

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.

References

Cano-Olivos, P. (2021). Forecast Methods and Periodic Review Inventory Model for Supply Planning to Reduce Food Waste. Asian Journal of Economics, Business and Accounting, 21(5), 24–40. https://doi.org/10.9734/AJEBA/2021/v21i530378

Clarkson. (n.d.). The periodic review model with independent age-dependent lifetimes. Production and Operations Management, 32(8). https://doi.org/10.1111/poms.13900

DataMarketView. (2026). Retail industry in Indonesia 2025-2033 overview: Trends, competitor dynamics, and opportunities. https://www.datamarketview.com/reports/retail-industry-in-indonesia-18725

van Donselaar, K., & Broekmeulen, R. (2025). Easy-to-use estimators for waste, on shelf availability and number of orders in a periodic review inventory system with perishable items. International Journal of Production Economics, 284. https://doi.org/10.1016/j.ijpe.2025.109608

Hasiloglu-Ciftciler, M., & Kaya, O. (2025). Dynamic inventory sharing, ordering, and pricing strategies for perishable foods to maximize profit and minimize waste. Computers & Industrial Engineering, 205(February), 111158. https://doi.org/10.1016/j.cie.2025.111158

Hendrix, E. M. T., Pauls-Worm, K. G. J., & van de E. Jong, M. (2023). On Order Policies for a Perishable Product in Retail. 34(2), 271–283. https://doi.org/10.15388/23-INFOR520

Hübner, A., & Kuhn, H. (2024). Decision support for managing assortments, shelf space, and replenishment in retail. Flexible Services and Manufacturing Journal, 36(1). https://doi.org/10.1007/s10696-023-09492-z

Kementerian Keuangan Republik Indonesia. (2025). Pemerintah perkuat industri ritel. https://www.kemenkeu.go.id/informasi-publik/publikasi/berita-utama/pemerintah-perkuat-industri-ritel

Kusomrosananan & Phumchusri. (2024). Inventory Policy Improvement with Periodic Review for Perishable Goods: A Case Study of a Retail Coffee Shop in Thailand. Engineering Journal, 28(6). https://doi.org/10.4186/ej.2024.28.6.59

Maidana-Aquino, G., Valenzuela-Galván, J., Gamboa-Cruzado, J., García, C. E. J., Delgado, F. D. C., Carhuamaca, A. D., Meza, Á. N., & Chanona-Hernández, L. (2026). Discrete Event Simulation for Intelligent Supply Chains: A Data-Driven Systematic and Bibliometric Review. Computacion y Sistemas, 30(1), 783–803. https://doi.org/10.13053/cys-30-1-6343

Pathom, N. (2023). Using Simulation to Determine the Reorder. 22, 199–210.

Solari, F., Lysova, N., & Montanari, R. (2025). Reordering Perishables: Identifying the Shelf Life Threshold That Simplifies Inventory Management Decisions. Procedia Computer Science, 274, 865–874. https://doi.org/10.1016/j.procs.2025.12.085

Staff, M. E., & Mustafee, N. (2023). Discrete-Event Simulation to Support the Management of Perishable Inventory—A Review. 75–85. https://doi.org/10.36819/SW23.026

Sugiyono. (2025). Metode Penelitian Kuantitatif, Kualitatif, dan R&D (2nd ed.). Alfabeta.

Downloads

Published

2026-11-18

How to Cite

Dewi, Y. I., & Ikatrinasari, Z. F. (2026). Integrated Inventory Planning Using Periodic Review and Discrete Event Simulation for Perishable Products in Retail. Greenation International Journal of Engineering Science, 4(3), 353–368. https://doi.org/10.38035/gijes.v4i3.1525