Abstract:
The purpose of this master project is to apply of management information system for
repairing machine, managing spare parts and calculating maintenance operation cost for
maintenance division. The maintenance division lack of systematical machine historical data. It
has an effect on spare part inventory, which is sometimes higher or lower than demand.
Therefore, this system can collect historical data of machine, calculate reorder point, purchasing
order, appropriate safety stock and calculate maintenance cost of each job. The database was
developed by Microsoft Visual Studio.Net, Web Application and SQL Server which are simple to
use. The results were tested with actual system by comparing the old system with the new one. It
was found that the new system can reduce the inventory management cost.And it can conclude
each equipment maintenance cost, for example, reducing inventory management cost of brush
spring TP R from 390,000 Baht/Year to 195,000 Baht/Year (50%/Year), Skip PCS from 33,500
Baht/Year to 21,240 Baht/Year (36.6%/Year) and Pinch Roll from 94,520 Baht/Year to 54,210
Baht/Year (42.6%/Year). Moreover, the information of maintenance work is recorded and
convenient for searching. This shows that the new developing information system operated
workflow more efficiently the old system.