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,

The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
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.
Pipe fabrication and IIoT; 2017 Product of the Year finalists
The future of electrical safety; Four keys to RPM success; Picking the right weld fume option
A new approach to the Skills Gap; Community colleges may hold the key for manufacturing; 2017 Engineering Leaders Under 40
Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Power system design for high-performance buildings; mitigating arc flash hazards
VFDs improving motion control applications; Powering automation and IIoT wirelessly; Connecting the dots
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
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 Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me