How can computerization streamline spare parts inventory? This paper describes the design and analysis of a computer-based information system for managing spare parts inventory in a computer service company, aiming to improve efficiency and control. The research involved studying the existing manual system, identifying user requirements, and defining system components. The parts were classified into four categories for better control. Quantitative models for demand forecast, economic order quantity, and safety stock were considered, with appropriate models selected based on the importance of each part type. The information system was implemented in a modular form, using dBASE III PLUS for the database and CLIPPER tools for the control programs. The developed system offers an extensive user interface to ensure user-friendliness, enhancing the efficiency of inventory management. This project demonstrates the potential of computerization to optimize inventory processes. Future research could explore the integration of cloud-based solutions and real-time data analytics to further enhance the system's capabilities.
This article is published in Industrial Management & Data Systems, this article fits well with the journal's concentration of information management. The research demonstrates the benefits of a computer-based system to support the effective management of spare parts. By referencing data systems to the application of the problem being assessed, this article strengthens its contribution to the field.