How to balance your PM workload

Are you tired of that month, quarter or year-end crunch to get your preventive maintenance (PM) work done? Minimize the chance of this happening again with the steps below.


Develop a balanced PM work schedule. Courtesy: Daniel Penn AssociatesAre you tired of that month, quarter or year-end crunch to get your preventive maintenance (PM) work done? Minimize the chance of this happening again with the steps below.

Before you begin, here are some fundamentals:

  • Be comfortable with linking cells in formulas within a spreadsheet program, such as Excel
  • Have the right people with the right skills available to do the work
  • Develop a balanced PM work schedule based on the shop's capacity to make sure the work can be completed in a timely manner.

Step 1. Include these elements:

a. Priority of the equipment—Use established criteria, such as criticality, to prioritize the equipment or systems that feed into your PM plan.

b. The labor hours by shop or skill for performing each PM event—Example: A monthly air handler PM task at a pharmaceutical[VS2] requires three hours for HVAC mechanics. These labor hours constitute the workload. The workload refers to labor hours, not task duration. If two HVAC mechanics work on PM for one and a half hours, the total labor still equals three hours.

c. Equipment availability based on the production schedule. Some PM tasks may have to be assigned to the off shifts in order to get access, or wait [VS3] for breaks in the production schedule. Conflicts over availability should be resolved through an existing protocol (which means you should work this out in advance).

d. Materials, such as filters, gaskets, etc., required for completing the PM tasks. These need to be available when the PM is scheduled for execution, so a link between PM scheduling and procurement and inventory should be established to assure PM completion

Step 2. Identify the following:

a. The labor hours required by skill or shop for every PM work order planned for the year based on the OEM recommendations, or prior experience (what happened last time you did this PM) or the current plan

b. The OEM or regulatory prescribed frequency interval (monthly, annually, etc.)

c. The capacity in man-hours of each shop or department required to complete the work. These are the hours that can be devoted to real work, aka wrench time, net of meetings and training, etc. A balanced PM schedule supports a dedicated PM crew's timely completion of PM activities. That's why maintenance staffing should always begin with allocating resources to completing PM tasks.

Step 3. Create the schedule spreadsheet

Create a spreadsheet for the shop that will show 52 weeks across the top and each piece of equipment down the left side. Load the labor hours required for each PM in each week per the original frequency interval or the way it is now.

1. Create a fixed table or location for the hours per piece of equipment, and enter a cell reference formula in the row for the week to pull them in. This formula can be easily moved from week to week at a later date for balancing.

2. Next, the PM scheduler will need to calculate and enter the available capacity of the shop and include it for each week of the spreadsheet in a row across the bottom. Create a simple formula to compare it to the sum total of workload demand for all equipment served by this skill for each week.

3. Set up your spreadsheet to color-highlight cells that flag the PM workload exceeding (or falling below) the shop's capacity. This will help you recognize which PM activities to reschedule to balance the workload.

Step 4. The balancing act

Now that your spreadsheet contains all the PM and shop-capacity information, the scheduler can move PM tasks from week to week to reduce the variance between workload and shop capacity, producing as balanced a workload as possible. PM tasks can usually be rescheduled for a shorter time interval, or be "pulled in" for the purposes of balancing. Be sure to work with production control in advance to adjust the production schedule accordingly.

Engineering staff or the OEM should be consulted if tasks are to be "pushed out" to make sure there are no negative consequences for equipment. From a Lean perspective, tasks that can be performed at an interval best suited to the equipment's performance will help reduce operating costs. In regulated environments, such as hospitals or pharmaceuticals, care must be taken to ensure that frequency changes are in compliance with health care equipment regulations.

Continue assessing each week's workload and shop capacity until all PM tasks for the shop have been scheduled to produce the best balance possible.

After balancing the annual PM work, it is wise to try to shadow PM. One example of shadowing would be to include the monthly PM tasks in the quarterly PM job plan so the CMMS does not generate two separate work orders when the quarterly PM is released. In this case, the monthly PM tasks are in the quarterly PM's shadow.

Daniel Penn Associates is a CFE Media Content Partner ( 5. Load the new PM schedule

To complete the balancing process, the new frequencies must be transferred to the work orders in the CMMS.

Steve Mueller is director of commercial operations for Daniel Penn Associates. Daniel Penn Associates is a CFE Media content partner. Edited by Erin Dunne, production coordinator, CFE Media,

Top Plant
The Top Plant program honors outstanding manufacturing facilities in North America.
Product of the Year
The Product of the Year program recognizes products newly released in the manufacturing industries.
System Integrator of the Year
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
September 2018
2018 Engineering Leaders under 40, Women in Engineering, Six ways to reduce waste in manufacturing, and Four robot implementation challenges.
GAMS preview, 2018 Mid-Year Report, EAM and Safety
June 2018
2018 Lubrication Guide, Motor and maintenance management, Control system migration
August 2018
SCADA standardization, capital expenditures, data-driven drilling and execution
June 2018
Machine learning, produced water benefits, programming cavity pumps
April 2018
ROVs, rigs, and the real time; wellsite valve manifolds; AI on a chip; analytics use for pipelines
Spring 2018
Burners for heat-treating furnaces, CHP, dryers, gas humidification, and more
August 2018
Choosing an automation controller, Lean manufacturing
September 2018
Effective process analytics; Four reasons why LTE networks are not IIoT ready

Annual Salary Survey

After two years of economic concerns, manufacturing leaders once again have homed in on the single biggest issue facing their operations:

It's the workers—or more specifically, the lack of workers.

The 2017 Plant Engineering Salary Survey looks at not just what plant managers make, but what they think. As they look across their plants today, plant managers say they don’t have the operational depth to take on the new technologies and new challenges of global manufacturing.

Read more: 2017 Salary Survey

The Maintenance and Reliability Coach's blog
Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
One Voice for Manufacturing
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Maintenance and Reliability Professionals Blog
The Society for Maintenance and Reliability Professionals an organization devoted...
Machine Safety
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
Research Analyst Blog
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Marshall on Maintenance
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
Lachance on CMMS
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
Material Handling
This digital report explains how everything from conveyors and robots to automatic picking systems and digital orders have evolved to keep pace with the speed of change in the supply chain.
Electrical Safety Update
This digital report explains how plant engineers need to take greater care when it comes to electrical safety incidents on the plant floor.
IIoT: Machines, Equipment, & Asset Management
Articles in this digital report highlight technologies that enable Industrial Internet of Things, IIoT-related products and strategies.
Randy Steele
Maintenance Manager; California Oils Corp.
Matthew J. Woo, PE, RCDD, LEED AP BD+C
Associate, Electrical Engineering; Wood Harbinger
Randy Oliver
Control Systems Engineer; Robert Bosch Corp.
Data Centers: Impacts of Climate and Cooling Technology
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
Safety First: Arc Flash 101
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
Critical Power: Hospital Electrical Systems
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
Design of Safe and Reliable Hydraulic Systems for Subsea Applications
This eGuide explains how the operation of hydraulic systems for subsea applications requires the user to consider additional aspects because of the unique conditions that apply to the setting
click me