Data mining from CMMS shows how well you’re doing

Computerized maintenance management system (CMMS) software package schedules maintenance checks, captures data from work orders, issues reports for various scenarios to decisions on capital budgets, new hires, outsourced repairs, and spare parts budgets, and other areas.

08/07/2012



It doesn’t take much to satisfy the maintenance team. Once the department takes the plunge and invests in a computerized maintenance management system (CMMS), and the system starts cranking out work orders and scheduled preventive maintenance tasks with daily alerts reminding technicians to check a gear box or change a belt, the team will be happy as clams.

But managing maintenance and repairs is just the tip of the iceberg. CMMS is also your decision support buddy. A decent CMMS package not only schedules maintenance checks, it also captures data from work orders and issues reports for all kinds of scenarios to help you make decisions about capital budgets, new hires, outsourced repairs, and spare parts budgets, to name just a few.

Let’s say you’re thinking about retiring a 10-year-old air conditioner. But when you analyze the machine’s work order history your CMMS shows fewer repairs were made in the last 5 years than the newer cooler in another building. That frees up working capital for a more pressing need.

If you outsource much of your repair work, pull a CMMS report to show you the frequency, quality, and cost of actual work that got completed in the last 12 months by your contracted vendors. Then make an informed decision about whether to negotiate, replace, or renew their maintenance contracts.

What about replacing the tires on your truck fleet, rather than relying on your drivers to keep track of their odometer readings? Run a CMMS report that shows you vehicle repair and invoice history, when new tires were last purchased, and whether it’s time to replace them.

Need to justify new hires? Run a downtime analysis report that shows the number of hours of machine downtime versus the number of available human resource hours for repairs. Prove to upper management that it makes more sense to hire more staff than to buy a new machine.

Need to do an “apples to apples” comparison for the same asset across multiple facilities? Generate a report that shows average repair expenses were higher for the HVAC in Boston than for the same unit in Chicago. Armed with your report, complete with illustrations, confront your maintenance contractor, then negotiate the same lower rate for all facility HVACs.

Have a budget request for a new piece of equipment? Show your director a report with key performance indicators, including age, frequency of failures, and rising/falling repair cost factors.

Have a disgruntled technician who’s been asking for a raise? Show him a report with on-time versus late work orders, then advise him how to shore up productivity and you’ll reconsider that pay increase.

Want to avoid the wrath of an OSHA auditor next time he checks a machine that’s out of compliance? Show him a chronology of preventive maintenance repairs completed in the past 12 months and prove you’re on top of the situation.

Even in organizations that have successfully implemented CMMS, it still surprises me that the use of CMMS stops with the basic use of PMs and corrective work orders. Obviously operational improvements through CMMS are critical, but data gained from these fundamental features takes the guesswork out of important maintenance decisions. Your CMMS is a great decision-making ally.



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.
October 2018
Tools vs. sensors, functional safety, compressor rental, an operational network of maintenance and safety
September 2018
2018 Engineering Leaders under 40, Women in Engineering, Six ways to reduce waste in manufacturing, and Four robot implementation challenges.
July/Aug
GAMS preview, 2018 Mid-Year Report, EAM and Safety
October 2018
2018 Product of the Year; Subsurface data methodologies; Digital twins; Well lifecycle data
August 2018
SCADA standardization, capital expenditures, data-driven drilling and execution
June 2018
Machine learning, produced water benefits, programming cavity pumps
Spring 2018
Burners for heat-treating furnaces, CHP, dryers, gas humidification, and more
October 2018
Complex upgrades for system integrators; Process control safety and compliance
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