Abstract:
Maintenance management is an indispensable activity for machines and
equipments which are fundamental facilities of production process. This study focuses
on the preventive maintenance of a case study of a boiler manufacturing company. Due
to lack of an information system, the maintenance section of the case study company
had problems in data retrieving, maintenance reporting, also lack of information for
machine breakdown analysis and maintenance planning . This study therefore proposes
a database management system to support the maintenance activities of this company.
It studies the system work flow of maintenance section. Then it is written in the forms of
data flow diagram (DFD) and entity relationship diagram (ERD) of the system. It applies
MS Access as an application to develop a relational database and user interfaces. The
results after implemented the system show that it can enhance the performance of the
maintenance section in term of data retrieving, maintenance order documenting,
preventive maintenance planning, maintenance order tracking, maintenance backlog
tracking, and other reports e.g. down time losses, MTTR, MTBF, etc. In other words, it
can reduce the duration of maintenance data management more than 80 % in
comparison with the previous approach.