Inventory Management System Using Economic Order Quantity And Reorder Point
DOI:
https://doi.org/10.70609/gtech.v8i4.4780Keywords:
Car Repair Workshop, Economic Order Quantity, Inventory Management System, Reorder PointAbstract
The inventory management system for car workshops is still using Excel, which makes it inefficient and inaccurate for complex stock calculations. The solution is to design an inventory application that uses the Economic Order Quantity and Reorder Point methods. The application will provide timely stock replenishment information and optimize order quantities, increasing inventory management efficiency and accuracy. The Software Development Life Cycle used in this study is Rapid Application Development, a process emphasizing short development cycles. User Acceptance Test results show that users received the inventory management system very well, with an average satisfaction level of 98.44% for Admins and 97% for general users, indicating high satisfaction with the system's features and functionality.
References
Afrianto, I., Heryandi, A., Finadhita, A., & Atin, S. (2021). User Acceptance Test For Digital Signature Application In Academic Domain To Support The Covid-19 Work From Home Program. International Journal of Information System & Technology Akreditasi, 5(3), 270–280. https://ijistech.org/ijistech/index.php/ijistech/article/view/132
Al-Momani, H., Al Meanazel, O. T., Kwaldeh, E., Alaween, A., Khasaleh, A., & Qamar, A. (2020). The efficiency of using a tailored inventory management system in the military aviation industry. Heliyon, 6(7).
Angellin, K., Oetama, R. S., & Amri, M. (2023). Web-Based Inventory and Sales Information System: Indonesian Micro Small Medium Enterprise Case Study. JOINS (Journal of Information System), 8(1), 57–66.
Asana, I., Radhitya, M. L., Widiartha, K. K., Santika, P. P., & Wiguna, I. (2020). Inventory control using ABC and min-max analysis on retail management information system. Journal of Physics: Conference Series, 1469(1), 12097.
Baio, G., & Heath, A. (2017). When simple becomes complicated: why Excel should lose its place at the top table. In Global & Regional Health Technology Assessment (Vol. 4, Issue 1, p. grhta-5000247). SAGE Publications Sage UK: London, England.
Beheshti, H. M., Clelland, I. J., & Harrington, K. V. (2020). Competitive Advantage with Vendor Managed Inventory. Journal of Promotion Management, 26(6), 836–854. https://doi.org/10.1080/10496491.2020.1794507
De Giovanni, P. (2021). Smart Supply Chains with vendor managed inventory, coordination, and environmental performance. European Journal of Operational Research, 292(2), 515–531.
Farooq, U. (2019). Impact of Inventory Turnover on the Profitability of Non-Financial Sector Firms in Pakistan. Journal of Finance and Accounting Research, 01(01), 34–51. https://doi.org/10.32350/jfar.0101.03
Goli, A., Tirkolaee, E. B., & Weber, G.-W. (2020). A perishable product sustainable supply chain network design problem with lead time and customer satisfaction using a hybrid whale-genetic algorithm. Logistics Operations and Management for Recycling and Reuse, 99–124.
Gordon, S., Crager, J., Howry, C., Barsdorf, A. I., Cohen, J., Crescioni, M., Dahya, B., Delong, P., Knaus, C., Reasner, D. S., Vallow, S., Zarzar, K., & Eremenco, S. (2022). Best Practice Recommendations: User Acceptance Testing for Systems Designed to Collect Clinical Outcome Assessment Data Electronically. Therapeutic Innovation and Regulatory Science, 56(3), 442–453. https://doi.org/10.1007/s43441-021-00363-z
HR, G., & Aithal, P. S. (2020). Integrated inventory management control framework. International Journal of Management, Technology, and Social Sciences (IJMTS), 5(1), 147–157.
Huang, Y.-S., Fang, C.-C., & Lin, Y.-A. (2020). Inventory management in supply chains with consideration of Logistics, green investment and different carbon emissions policies. Computers & Industrial Engineering, 139, 106207.
James, A. T., & James, J. (2021). Service quality evaluation of automobile garages using a structural approach. International Journal of Quality & Reliability Management, 38(2), 602–627.
Jenvald, M., & Hovmöller, M. (2020). Reducing Delays for Unplanned Maintenance of Service Parts in MRO Workshops-A case study at an aerospace and defence company (p. 9). www.liu.se
Mittal, S. (2024). Framework for Optimized Sales and Inventory Control: A Comprehensive Approach for Intelligent Order Management Application. International Journal of Computer Trends and Technology, 72(3), 61–65.
Musa, F. H., & Ibrahim, R. (2021). Inventory Management System Olahan Hasrat Sdn. Bhd. Using Mobile Application. Applied Information Technology And Computer Science, 2(2), 1030–1045.
Nestorenko, T., Morkunas, M., Peliova, J., Volkov, A., Balezentis, T., & Streimkiene, D. (2020). A new model for determining the EOQ under changing price parameters and reordering time. Symmetry, 12(9), 1512.
Oetama, R. S., & Armando, F. J. (2023). Supplier Evaluation at Small-Medium Enterprise Using Simple Additive Weighting. Journal of Information Systems and Informatics, 5(2), 467–480.
Rafliana, T., & Suteja, B. R. (2018). Penerapan Metode EOQ dan ROP untuk Pengembangan Sistem Informasi Inventory Bengkel MJM berbasis Web. Jurnal Teknik Informatika Dan Sistem Informasi, 4(2), 349–358.
Ramos, E., Pettit, T. J., Flanigan, M., Romero, L., & Huayta, K. (2020). Inventory management model based on lean supply chain to increase the service level in a distributor of automotive sector. Int. J. Supply Chain Manag, 9(2), 113–131.
Saeed Osman, M. F. (2022). Modeling and simulation for inventory management of repairable items in maintenance systems. Simulation, 98(11), 1013–1037.
Subhiyakto, E. R., & Astuti, Y. P. (2019). Design and development meeting schedule management application using the rad method. 2019 International Conference of Artificial Intelligence and Information Technology (ICAIIT), 60–64.
Suryasari, Wiratama, J., & Desanti, R. I. (2022). The Development of Web-based Sales Reporting Information Systems using Rapid Application Development Method. Ultima Infosys : Jurnal Ilmu Sistem Informasi, 13(2), 110–116. https://doi.org/https://doi.org/10.31937/si.v13i2.3005
Taherdoost, H. (2023). The Role of Different Types of Management Information System Applications in Business Development: Concepts, and Limitations. Cloud Computing and Data Science.
Topal, O. (2023). Periodic Maintenance & Repair Approaches for Electric Vehicles. El-Cezeri, 10(1), 66–80.
Umry, T. F., & Singgih, M. L. (2019). Inventory management and reorder point (ROP) strategy using ABC analysis methods in textile manufacture. IPTEK Journal of Proceedings Series, 5, 1–7.
Vasilev, J., & Milkova, T. (2022). Optimisation Models for Inventory Management with Limited Number of Stock Items. Logistics, 6(3), 54.
Wanti, L. P., Maharrani, R. H., Adi Prasetya, N. W., Tripustikasari, E., & Ikhtiagung, G. N. (2020). Optimation economic order quantity method for a support system reorder point stock. International Journal of Electrical and Computer Engineering, 10(5), 4992–5000. https://doi.org/10.11591/ijece.v10i5.pp4992-5000
Wijaya, T. (2020). Penerapan Perpetual Inventory System dalam Perhitungan Laba Rugi Kotor Perusahaan Dagang. Creative Information Technology Journal, 5(4), 303–313.
Downloads
Published
Issue
Section
License
Copyright (c) 2024 Ignatius Ivan, Raymond Sunardi Oetama
This work is licensed under a Creative Commons Attribution 4.0 International License.
