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,

No comments
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.
The Engineering Leaders Under 40 program identifies and gives recognition to young engineers who...
Safer human-robot collaboration; 2017 Maintenance Survey; Digital Training; Converting your lighting system
IIoT grows up; Six ways to lower IIoT costs; Six mobile safety strategies; 2017 Salary Survey
2016 Top Plant; 2016 Best Practices on manufacturing progress, efficiency, safety
Future of oil and gas projects; Reservoir models; The importance of SCADA to oil and gas
Big Data and bigger solutions; Tablet technologies; SCADA developments
SCADA at the junction, Managing risk through maintenance, Moving at the speed of data
What controller fits your application; Permanent magnet motors; Chemical manufacturer tames alarm management; Taking steps in a new direction
Commissioning electrical systems; Designing emergency and standby generator systems; Paralleling switchgear generator systems
Package boilers; Natural gas infrared heating; Thermal treasure; Standby generation; Natural gas supports green efforts

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.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Motion control advances and solutions can help with machine control, automated control on assembly lines, integration of robotics and automation, and machine safety.
This article collection contains several articles on creating and enhancing a safe workplace in manufacturing.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
click me