Maintenance Planner & Resource Leveling Excel Workbook

This tool is designed for any business that does any type of scheduled maintenance.

Already have a maintenance system? If so, there is a good chance the utility capability provided by our planning worksheet will still be of use. Your existing system may not support a view of your resources and tasks with endless what-if scenarios that our tool provides.

If you have a maintenance system where all information is entered manually (a paper system), then this tool will work for you as well. This planning worksheet is all about the task. How often you perform the task and the total budgeted time to perform the task. We just know you will get to see your scheduled work from a different perspective by using our worksheet tool.

• Focusing on task scheduling against critical systems and critical assets without being overwhelmed by data.
• Balancing annual preventive maintenance task scheduling against actual technician available wrench time based on goals, efficiency, staffing, holidays, etc.
• Pie chart representation of the annual hours resulting from your preventive maintenance task schedule on a critical system or critical asset.
• Clearly analyzing staffing parameters and maintenance task labor at an annual level to show insufficient or excess staffing.

The implementation of a successful maintenance program requires that the supervisor pay close attention to the preparatory steps. 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.

For those not possessing Microsoft Office or Microsoft Excel, both LibreOffice and Apache OpenOffice are excellent alternatives that are readily downloadable.