I am currently developing the maintenance program for the company i work for (Pasta Factory), using excel to manage and record data. I want to set a KPI for Preventive vs Repair maintenance but before i get there i need to explain how i view the program. I have decided to categorize all my maintenance activity as below:
Maintenance Type
Preventive-O(PO) *Done based on observation seen beforehand
Preventive-S (PS)*Done based on Schedule
Corrective (CM)*Done but did not stop production ^
Breakdown (BM)*Production^ had to stop
Other *Routine Stoppages for Product Changeover & Power Changeover
Preventive = PO + PS
Repair = CM + BM
Currently, for the PS maintenance activity, i only enter in my excel when a problem is detected or change/repair is made. My PS is based on machine working hours. For eg. If i inspect a gearbox and its oil level is ok, i do not put in the calculation. However, if i had to change the oil or top up, then i would enter in excel. As a result, my %Repair > % preventive. Should i enter all the PS in excel for the calculation to be correct, or is it okay as it is. Also, say the line has 30 different grease points, will each area on the line constitute a single activity? Definitely if yes, it will far exceed % repair. I need some guidance on how to approach this.