https://mobirise.com/

Maintenance Planner

The implementation of CMMS software requires that the maintenance supervisor pay close attention to the preparatory steps required to ensure a successful implementation. What are these steps? Successful implementation requires a plan for organizing the staff, identifying and prioritizing the equipment based on needs, documenting and estimating the time required to complete each task, and most importantly, establishing the frequency for how often the tasks are to be performed.
We developed our Excel-based automated maintenance planner to assist you in developing your plan for success. We hope you agree that prior planning drastically increases your likelihood of a successful maintenance software system implementation.

Maintenance Planner - How it Works!

1.

How many maintenance employees do you have?

i.e. 20 employees * 40hrs/week = 41,600 hrs/year
   

EQUALS

41,600 annual employee hours
<1,200> vacation hours
<1,600> holiday hours

38,800 net hours

MINUS
  • Vacations (40 - 160hrs/employee) * 20 employees
  • Holidays (10 ea. @ 8hrs) * 20 employees
  • Sick Leave (24-30hrs/employee) * 20 employees
  • Special Projects (?)
   
MINUS
Employee efficiency (We are not machines - 66% proficient is reasonable).
38,800 * .66 = 25,608
25,608 hours
available for corrective and preventive maintenance annually.


2.

Your P.M. vs. C.M. Budget?

P.M. C.M Breakdown

80% --- P.M.
20% --- C.M.
   
20,486 hours for P.M.

5,122 hours for C.M.
CALCULATIONS

P.M.
.80 * 25,608 = 20,486

C.M.
.20 * 25,608 = 5,122 hours


3.

HOW MUCH CAN BE SCHEDULED?

   

20,486 hours budgeted

   
RANK EQUIPMENT BY
  1. Required to produce revenue.
  2. Is stand-by available?
  3. Can equipment be easily isolated?
   
CREATE PRIORITY
  1. Must Do
  2. Would Like To Do
  3. Not Required For Revenue


4.

IT IS ALL ABOUT TASKS!

   
HOW MANY TASKS & HOW MANY TIMES PER YEAR?
  • 20hr Task Count/Year?
  • 15hr Task Count/Year?
  • 10hr Task Count/Year?
  • 5hr Task Count/Year?
  • 3hr Task Count/Year?
  • 2hr Task Count/Year?
  • 1hr Task Count/Year?
  • Checks?
   
Critical Equipment First!

i.e. A compressor is required for generating revenue.
Annual maintenance is:
Type Qty/Year Importance Hours/Year
40hr 1 time major 40hrs
20hr 2 times major 40hrs
3hr 6 times minor 40hrs
.5 check 50 times major 40hrs
    TOTAL 123 hours
  ↓ ↑  

UPDATE BUDGET REMAINING!

20,486 - 123hrs = 20,363 hours remaining

Repeat previous step for additional equipment.


5.

LEVEL RESOURCES

Equipment Jan. Feb. colums for Mar. - Nov. Dec.
G-1050 5 5 ... 5
G-1050   20 ...  
G-1050 40   ... 40
         
Total/month 45 25 ... 45
Total/year     ... 115


Why spend time planning your maintenance without a straightforward automated solution? 

Professionally written automated Maintenance Planner in friendly Microsoft Excel format.