Development of a Database System for Managing Spare Parts in Engineering and Maintenance Department: A Case Study in Coil Center Industry
Main Article Content
Abstract
The objective of this research is to develop a database management system in the engineering and maintenance department by improving inventory parts data collection methods. It aims to improve working performance, improve searching time of the parts and reduce the mean time to repair machine. Presently, the parts disbursement controlling problems found at the case study factory are caused from the data management and the data record which is complicated and double searching. According to double ordering parts waiting, the average searching time for parts is 34 minutes. The Management Information System (MIS) is applied by using Microsoft Access 2010 program to develop and solve the problem. Referring to the program, comparing with the previous system, it can be concluded that the new developed database system can reduce the working time by 31.99 minutes to 1.44 minutes or 95.69 percent. As a result, the database system can increase the performance of maintenance section.
Article Details
The articles published are the opinion of the author only. The author is responsible for any legal consequences. That may arise from that article.
References
[2] C. Onlert, “Reduction of repair and maintenance costs by improving spare parts: a case study of automotive parts manufacturing company,” Special problem, Department of Industrial Engineering, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, 2011 (in Thai).
[3] C. Buakaew, “Inventory system for maintenance parts: a case study of cement plant,” M.S. thesis, Department of Industrial Engineering, Faculty of Engineering, Chulalongkorn University, 1998 (in Thai).
[4] T. Chusakul, “Development of database management system for engineering management of engineering and maintenance division: A case study of a evaporator production line,” Special Problem, Department of Industrial Engineering, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, 2011 (in Thai).
[5] S. Boonterm, “Development of maintenance database for history data recording a case in electrical maintenance unit of a power plant,” Special problem, Department of Industrial Engineering, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, 2012 (in Thai).
[6] E. Thongsri, “Application of management information system for managing spare parts and calculating maintenance operation cost,” Special problem, Department of Industrial Engineering, Faculty of Engineering, King Mongkut’s University of Technology North Bangkok, 2008 (in Thai).
[7] B. R. Adhikari, “Computerized information system for small manufacturing company,” Research paper Master of Science Degree, Technology Management, University of Wisconsin-Stout, 2010.
[8] R. Mathur, “Management information system in clothing industry,” International Referred Research Journal, 2011.
[9] O. A.Syggeridou and M. G.Ioannides, “Induction motors’ faults detection and diagnosis by using Dedicated Software,” Journal of Materials Processing Technology, vol. 181, no. 1–3, pp. 313–317, 2007.
[10] S. Abdulloh and A. Kengpol, “The development of database management program to reduce searching time of the machine: A case study in a stamping press manufacturer,” The Journal of KMUTNB, vol. 26, no. 1, pp. 75–84, 2016 (in Thai).
