Inventory Optimization of Work Tool Availability at an Automotive Workshop

Authors

  • Hariyo P. S. Pratomo Petra Christian University
  • Ivan Christian Hernando Petra Christian University
  • Matthew Jeffrey Rudijanto Petra Christian University
  • Joseph Wicaksono Tandio Eindhoven University of Technology

DOI:

https://doi.org/10.56862/irajtma.v4i3.342

Keywords:

Automotive workshop, Cost-benefit analysis, Inventory optimization, Safety stock.

Abstract

Automotive workshops commonly face inefficiencies in special-tool availability due to manual and non-transparent tracking systems. This study addresses this challenge by examining the impact of limited tool quantities on operational performance, particularly the low average service level (86.18% vs. the 95% target). This study is among the first to integrate a digital tool management system with quantitative inventory-optimization methods, i.e., Safety Stock and Cost-Benefit Analysis (CBA), in an automotive workshop context. Borrowing-transaction records collected over 60 days were analyzed to identify critical tools with the highest demand variability. Although most tools achieved full availability, 15 high-demand tools contributed to reduced overall service level and were therefore prioritized in the optimization process. Application of Safety Stock analysis recommended ideal inventory quantities, while CBA revealed diminishing-return thresholds, preventing unnecessary investment. Key improvements include increasing service level from 71.27% to 99.51% and enhancing cost efficiency to 89.04%. The combined digital recording system and quantitative optimization framework have proved highly effective in improving tool availability and reducing operational costs. This approach offers a scalable model for automotive workshops seeking to enhance efficiency and sustainability through data-driven tool-management strategies.

References

Abdelaoui, F. Z. E., Jabri, A., and Barkany, A. E. 2023. “Optimization techniques for energy efficiency in machining processes—a review.” International Journal of Advanced Manufacturing Technology, 125, 2967–3001. https://doi.org/10.1007/s00170-023-10927-y

Allal, A., Sahnoun, M., Adjoudj, R., Benslimane, S. M., and Mazar, M. 2021. “Multi-agent based simulation-optimization of maintenance routing in offshore wind farms,” Computers & Industrial Engineering, 157, 107342. https://doi.org/10.1016/j.cie.2021.107342.

Arasteh, E. 2022. “Optimization of inventory costs in multi-echelon supply chains under safety stock placement,” Applied Mathematical Modelling, 106, 446–463. doi: 10.1016/j.apm.2021.12.040.

Ariana, A. 2025. “Penerapan metode EOQ untuk pengendalian persediaan pada UMKM Widi Putra Motor,” Jurnal Sistem dan Manajemen Industri, 9(2), 201–210.

Asplund, T. 2022. “Learning to use workshop tools and machines in vocational education,” Vocations and Learning, 15(3), 411–432. doi: 10.1007/s12186-021-09277-0.

Castilla, R. 2023. “Mobile application for tool inventory management in coast guard aviation maintenance,” International Journal of Emerging Trends in Engineering Research, 11(4), 256–262. doi: 10.30534/ijeter/2023/051142023.

Chen, C. 2022. “Design of electric tool management system based on RFID,” Journal of Physics: Conference Series, 2322(1), 012015. doi: 10.1088/1742-6596/2322/1/012015.

Fa’iz, A. 2025. “Implementasi long range RFID dalam manajemen inventory tools pada PLTA Sutami,” Jurnal Teknik Elektro dan Komputer (JTEK), 10(1), 33–40.

Gentili, A., Failla, G., Melnyk, A., Puleo, V., Tanna, G. L. D., Ricciardi, W., and Cascini, F. 2022. “The cost-effectiveness of digital health interventions: a systematic review of the literature.” Frontiers in Public Health 10:787135. doi: 10.3389/fpubh.2022.787135

Kirmizi, M. 2024. “Hybrid safety stock strategies using service level and ABC–XYZ classification,” Operations Research Perspectives, 11, 100302. doi: 10.1016/j.orp.2023.100302.

Luan, F., Zhao, H., Liu, S. Q., He, Y., and Tang, B. 2023. “Enhanced NSGA-II for multi-objective energy-saving flexible job shop scheduling,” Sustainable Computing: Informatics and Systems, 39, 100901. https://doi.org/10.1016/j.suscom.2023.100901.

Maheshwari, P., Kamble, S., Pundir, A., Belhadi, A., Ndubisi, N. O., and Tiwari, S. 2025. “Internet of things for perishable inventory management systems: an application and managerial insights for micro, small and medium enterprises.” Annals of Operations Research, 350, 395–423. https://doi.org/10.1007/s10479-021-04277-9

Momeni, M. A., Mostofi, A., Jain, V., and Chan, F. T. S. 2025. “A novel multi-objective optimization model for designing a reverse supply chain network,” Journal of Cleaner Production, 499, 145249. doi: 10.1016/j.jclepro.2025.145249

Okwelle, P. C., and Kilechukwu, A. B. 2022. “Managerial strategies for proper handling of workshop tools by building technology education students in Rivers State,” British Journal of Contemporary Education, 2(1), 1–16. doi: 10.52589/BJCE-UEI6ZFX8

Rahmadani, D. A., and Arvitrida, N. I. 2025. “Inventory management for electricity distribution materials,” Jurnal Teknik Industri: Jurnal Keilmuan dan Aplikasi Teknik Industri, 27(2), 151-162. doi: 10.9744/jti.27.2.151-162

Ramalingam, M., Manoharan, G., and Puviarasi, R. 2021. “Web-Based Car Workshop Management System—A Review.” In: Kumar, R., Mishra, B.K., Pattnaik, P.K. (eds) Next Generation of Internet of Things. Lecture Notes in Networks and Systems, 201, Springer. https://doi.org/10.1007/978-981-16-0666-3_25

Seyedan, M., Mafakheri, F., and Wang, C. 2023. “Order-up-to-level inventory optimization model using time-series demand forecasting with ensemble deep learning,” Supply Chain Analytics, 3, 100024. https://doi.org/10.1016/j.sca.2023.100024

Teng, X., Wu, Z., and Yang, F. 2022. “Impact of the Digital Transformation of Small- and Medium-Sized Listed Companies on Performance: Based on a Cost-Benefit Analysis Framework,” Journal of Mathematics, 2022, 1504499. https://doi.org/10.1155/2022/1504499

Vaughan, J. L., Leming, M. L., Liu, M., and Jaselskis, E. 2012. “Cost-Benefit Analysis of Construction Information Management System Implementation: Case Study.” Journal of Construction Engineering and Management, 139(4). https://doi.org/10.1061/(ASCE)CO.1943-7862.0000611

Xiucai, X. 2021. “Design of digital workshop equipment management system based on cloud platform,” Journal of Physics: Conference Series, 1754(1), 012048. doi: 10.1088/1742-6596/1754/1/012048

Yusuf, L. A., Popoola, K., and Musa, H. 2021. “A review of energy consumption and minimisation strategies of machine tools in manufacturing process.” International Journal of Sustainable Engineering, 14(6), 1826–1842. https://doi.org/10.1080/19397038.2021.1964633

Downloads

Published

2025-12-28

How to Cite

Pratomo, H. P. S., Hernando, I. C., Rudijanto, M. J., & Tandio, J. W. (2025). Inventory Optimization of Work Tool Availability at an Automotive Workshop. IRA Jurnal Teknik Mesin Dan Aplikasinya (IRAJTMA), 4(3), 171–183. https://doi.org/10.56862/irajtma.v4i3.342

Issue

Section

Scientific Article