Development Of Spreadsheet Based Programming For Maintenance Management Systems

Muhammad Jazmi , Ibrahim (2009) Development Of Spreadsheet Based Programming For Maintenance Management Systems. Project Report. UTeM, Melaka,Malaysia. (Submitted)

	PDF (24 Pages) Development_Of_Spreadsheet_Based_Programing_For_Maintenance_Management_System_Muhammad_Jazmi_Bin_Ibrahim_TS192.M52_2009_-_24_Pages.pdf - Submitted Version Download (3MB)
	PDF (Full Text) Development_Of_Spreadsheet_Based_Programing_For_Maintenance_Management_System_Muhammad_Jazmi_Bin_Ibrahim_TS192.M52_2009.pdf - Submitted Version Restricted to Registered users only Download (6MB)

Abstract

This paper examines the basis of vehicles maintenance management strategies used to date in JKR Mechanical in Kota Bharu, Kelantan which covers on Preventive Maintenance program only. These strategies assist the maintenance function and enable the process of maintenance to be optimized. The title of this project is, “Development of Spreadsheet Based Programming for Maintenance Management Systems” and special attention is given to Computerized Maintenance Management Systems (CMMS). The data was gathered through maintenance manual standard and has been compared with company visit, interview and the current system used in order to understand the Maintenance Management involved. The system was analyzed and the spreadsheet was developed. This program, made up of interconnected modules, can handle aspects of maintenance, including work order management; planned Preventive Maintenance; equipment costs and stock control; which connect from the data entry module and have been set by mileage. In order to improved system of maintenance at JKR, together with an enhanced Preventive Maintenance scheduling indicating precisely which maintenance work will be completed and providing parts available at that time to reduce time management. The spreadsheet have been develop by using Microsoft Excel as a tool and the project was focus on maintenance’s department which doing the vehicles service. Last but not least, this project elaborated the application of the spreadsheet developed and the importance of its usage in Maintenance Management System at JKR.

Actions (login required)

View Item