Implementation of FSN Analysis and Periodic Review System for Inventory Management Improvement in Spare Parts Warehouse

Leo Rama  Kristiana; Gisti Ayu Pratiwi; Putu Giri Artha Kusuma; Grass Aditya  Pringgodani; Irza Farhand; Theresia Jeremia Purba

doi:10.5281/zenodo.21533846

Authors

Leo Rama Kristiana Telkom University, Indonesia Author
Gisti Ayu Pratiwi Telkom University, Indonesia Author
Putu Giri Artha Kusuma Telkom University, Indonesia Author
Grass Aditya Pringgodani Telkom University, Indonesia Author
Irza Farhand Telkom University, Indonesia Author
Theresia Jeremia Purba Telkom University, Indonesia Author

DOI:

https://doi.org/10.5281/zenodo.21533846

Keywords:

Community Service, Inventory Management, FSN Analysis, Periodic Review System, Dashboard Monitoring

Abstract

Effective inventory management is essential for maintaining spare parts availability and ensuring high service levels in the automotive industry. PT IAMI, particularly the PSM Dept. and PC Dept. Bekasi, identified inventory management issues at its Medan Depot as a pilot project for inventory improvement. The depot initially achieved a fill rate of only 60%, below the company’s target of 70%, due to the absence of standardized spare parts classification, review period policies, replenishment planning, and an integrated monitoring system. To address these issues, a community service program was conducted by Telkom University through technical assistance in developing an inventory management framework. The program integrated Fast-Slow-Non Moving (FSN) Analysis, the Periodic Review System (R,s), and a dashboard-based inventory monitoring system using Microsoft Excel. The implementation stages included field observation, focus group discussion, operational data analysis, spare parts classification, inventory parameter calculation, dashboard development, and validation with the partner. The results showed that the proposed inventory policy improved the fill rate from 60% to 99%, exceeding the company target. In addition, the dashboard improved inventory visibility by displaying stock status, fill rate, safety stock, reorder warnings, and other operational indicators.

Downloads

Download data is not yet available.

References

Abideen, A. Z., Sorooshian, S., Sundram, V. P. K., & Mohammed, A. (2023). Collaborative insights on horizontal logistics to integrate supply chain planning and transportation logistics planning: A systematic review and thematic mapping. Journal of Open Innovation: Technology, Market, and Complexity, 9(2), 100066. https://doi.org/10.1016/j.joitmc.2023.100066

Ameer, T., & Fatahi Valilai, O. (2025). Cloud-native causal AI for supply chain KPI monitoring: A GCP framework to diagnose out-of-stock events. Machine Learning with Applications, 22, 100765. https://doi.org/10.1016/j.mlwa.2025.100765

Babiloni, E., & Guijarro, E. (2020). Fill rate: From its definition to its calculation for the continuous (s, Q) inventory system with discrete demands and lost sales. Central European Journal of Operations Research, 28(1), 35–43. https://doi.org/10.1007/s10100-018-0546-7

Chopra, S., & Meindl, P. (2022). Supply Chain Management: Strategy, Planning, and Operation (8th ed.). Pearson.

Demiray Kırmızı, S., Ceylan, Z., & Bulkan, S. (2024). Enhancing inventory management through safety-stock strategies: A case study. Systems, 12(7), 260. https://doi.org/10.3390/systems12070260

Destro, I. R., Staudt, F. H., Somensi, K., & Taboada, C. (2023). The impacts of inventory record inaccuracy and cycle counting on distribution center performance. Production, 33, e20220077. https://doi.org/10.1590/0103-6513.20220077

Filani, O. M., Olajide, J. O., & Osho, G. O. (2020). Designing an integrated dashboard system for monitoring real-time sales and logistics KPIs. International Journal of Multidisciplinary Research and Growth Evaluation, 1(5), 77–83. https://doi.org/10.54660/IJMRGE.2020.1.5.77-83

Govindan, K., Soleimani, H., & Kannan, D. (2015). Reverse logistics and closed-loop supply chain: A comprehensive review to explore the future. European Journal of Operational Research, 240(3), 603–626. https://doi.org/10.1016/j.ejor.2014.07.012

Ivanov, D. (2023). Supply Chain Management in the Era of Industry 4.0. Springer.

Nahmias, S., & Olsen, T. L. (2015). Production and Operations Analysis (7th ed.). Waveland Press.

Pournader, M., Shi, Y., Seuring, S., & Koh, S. C. L. (2020). Blockchain applications in supply chains, transport and logistics: A systematic review. International Journal of Production Research, 58(7), 2063–2081. https://doi.org/10.1080/00207543.2019.1650976

Queiroz, M. M., Wamba, S. F., & Fosso Wamba, S. (2021). Digital supply chain management: A systematic review and future research agenda. International Journal of Information Management, 58, 102245. https://doi.org/10.1016/j.ijinfomgt.2020.102245

Raut, R. D., Mangla, S. K., Narwane, V. S., Dora, M., & Liu, M. (2021). Big data analytics as a mediator in Lean, Agile, Resilient, and Green supply chain practices. International Journal of Production Economics, 237, 108199. https://doi.org/10.1016/j.ijpe.2021.108199

Roda, I., Macchi, M., Fumagalli, L., & Viveros, P. (2014). A review of multi-criteria classification of spare parts. Journal of Manufacturing Technology Management, 25(4), 528–549. https://doi.org/10.1108/JMTM-07-2012-0063

Silver, E. A., Pyke, D. F., & Thomas, D. J. (2017). Inventory and Production Management in Supply Chains (4th ed.). CRC Press.