Development of a Database Management System for Reducing Time to Prepare Documents of Procurement Spare Parts and Maintenance: A Case Study in a Logistic Industry

Main Article Content

Athakorn Kengpol Kringkrai Perngkarm

Abstract

The research aims to reduce the time required for documentation of spare part procurement and documentation of maintenance and to develop the maintenance management system of a company. According to the case study company, it takes long to find documents and information on documentation of purchase and maintenance. This causes delays in searching, risk of damage or loss during work. In the study, a computer program was applied to design and develop a database management system. After web applications were designed and developed, it was found that the time required for documentation was reduced by 55.83%, or 39,631.35 baht per year. The use of paper and ink was reduced up to 68.49%, or 61,634.15 baht per year. Therefore, the designed web applications can reduce the documentation time of the company.

Keywords

Article Details

Section
Engineering Research Articles

References

[1] A. Kengpol, Management Information System, 5th ed. Bangkok: Textbook publishing center. King Mongkut's University of Technology North Bangkok, 2016 (in Thai).

[2] C. Supaarthakorn, Create a PHP + MySQL Web Application for Beginners. Samutprakarn: Simplifly, 2015 (in Thai).

[3] K. Ploypanichcharoen, FMEA (Failure Mode and Effect Analysis), 1st ed. Bangkok : Technology Promotion Association (Thailand–Japan), 2008 (in Thai).

[4] S. Deeleard, Management Information System. Bangkok: Faculty of Management Science, Silpakorn University, 2015 (in Thai).

[5] S. Chunhaprasert, Principle of Information System, Faculty of Management Science. Chandrakasem Rajabhat University, 2005 (in Thai).

[6] 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).

[7] 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).

[8] 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 King Mongkut’s University of Technology North Bangkok, vol. 26, no. 1, pp. 75–84, 2016 (in Thai).