DESIGNING ENGINEERING STORAGE INVENTORY SYSTEM USING SYSTEM DEVELOPMENT LIFE CYCLE METHOD IN THE AUTOPARTS MANUFACTURING

Abstract

This project has been completed at a manufacturing company that assists other businesses in maintaining their warehouses. The company under consideration is operating on an inventory system engineering storage project in the Engineering Department. The current inventory system was handled manually and another issue that surfaced was data integration, which might lead to errors such as unsynchronized and updated data. The existing system is obviously manual, from the data entry of items to the stocking of items, the taking of items, and the generating of item data reports. The objective of this research is to use the development life cycle (SDLC) method to design an inventory information system to solve the problems. The improvements used in this project are to make it more systematic and make the management process and time for administrator or users who use the new inventory engineering storage system more efficient. The first stage of the SDLC planning process begins with observations to determine the user's requirements. The current system and the planned system are compared for the second time. A new inventory information system has been built using methodologies in warehouse management system, database, Data Flow Diagram (DFD), information system, and other supporting literatures with the goal of reducing error appearance and unsynchronized issues in inventory system engineering storage. Ms. Access was used to successfully implement this research. The data will be immediately updated, and a report will be generated. By applying new application, the process has been able to reduce the time from 397 seconds to 159 seconds for the admin process with the percentage performance is 42% and reduce the time from 210 seconds to 67 seconds for user process time required to finish one document request with the percentage performance is 51% and the response from the users are good after the system is tested.