MRO Inventory and Purchasing Performance Indicators

Inactive Stock Showing No Movement in the Last Twelve Months

Source: Strategic Maintenance Management Series

This indicator is used to find spare parts that are no longer needed. These items may have been purchased as spare parts for equipment that is no longer in the plant.

Occasionally, items are purchased in large quantities on a one-time basis, possibly for construction or a project, but were not used and have no further use at the plant or facility. Eliminating these items reduces inventory value and the subsequent holding cost the company must pay.

Inactive Stock Line Items

As the formula shows, this indicator measures the number of line items that are inactive, divided by the total number of line items carried in inventory. The percentage shows the opportunity for improvement by eliminating line items from the store inventory.

A second way the indicator can be used is to divide the dollar value of the inactive stock items by the total inventory valuation. This percentage gives the percentage of value that is possible to achieve through inventory reduction.


This indicator is useful for highlighting opportunities to reduce the overall inventory valuation. In companies where equipment and processes are rapidly outdated by technology changes, this indicator is critical to monitor.


This indicator does not differentiate between a disposable spare and one that is kept on hand due to lead time and delivery issues. Some equipment spares are kept in stock because the equipment is produced in another country and lead time to obtain a spare may be months or even a year. In these instances, keeping the spare is wise, even if it does not move for several years.

Another time this indicator is used to highlight items for possible removal from inventory, careful research should be done to ensure the part does not have a long lead time or is not difficult to obtain. Parts should never be arbitrarily removed from inventory.

Certified Maintenance Manager Workshop Body of Knowledge

This material is excerpted from the Strategic Maintenance Management Series which is also used as the Body of Knowledge for the Certified Maintenance Manager Workshop and Optional CMM Certification Exam. You can upcoming Certified Maintenance Manager Workshop and Optional CMM Certification Exam dates in the events calendar here

Terrence O'Hanlon

Upcoming Events

August 9 - August 11 2022

MaximoWorld 2022

View all Events
80% of newsletter subscribers report finding something used to improve their jobs on a regular basis.
Subscribers get exclusive content. Just released...MRO Best Practices Special Report - a $399 value!
Conducting Asset Criticality Assessment for Better Maintenance Strategy and Techniques

Conducting an asset criticality assessment (ACA) is the first step in maintaining the assets properly. This article addresses the best maintenance strategy for assets by using ACA techniques.

Harmonizing PMs

Maintenance reliability is, of course, an essential part of any successful business that wants to remain successful. It includes the three PMs: predictive, preventive and proactive maintenance.

How an Edge IoT Platform Increases Efficiency, Availability and Productivity

Within four years, more than 30 per cent of businesses and organizations will include edge computing in their cloud deployments to address bandwidth bottlenecks, reduce latency, and process data for decision support in real-time.

MaximoWorld 2022

The world's largest conference for IBM Maximo users, IBM Executives, IBM Maximo Partners and Services with Uptime Elements Reliability Framework and Asset Management System is being held Aug 8-11, 2022

6 Signs Your Maintenance Team Needs to Improve Its Safety Culture

When it comes to people and safety in industrial plants, maintenance teams are the ones who are most often in the line of fire and at risk for injury or death.

Making Asset Management Decisions: Caught Between the Push and the Pull

Most senior executives spend years climbing through the operational ranks. In the operational ranks, many transactional decisions are required each day.

Assume the Decision Maker Is Not Stupid to Make Your Communication More Powerful

Many make allowances for decision makers, saying some are “faking it until they make it.” However, this is the wrong default position to take when communicating with decision makers.

Ultrasound for Condition Monitoring and Acoustic Lubrication for Condition-Based Maintenance

With all the hype about acoustic lubrication instruments, you would think these instruments, once turned on, would do the job for you. Far from it!

Maintenance Costs as a Percent of Asset Replacement Value: A Useful Measure?

Someone recently asked for a benchmark for maintenance costs (MC) as a percent of asset replacement value (ARV) for chemical plants, or MC/ARV%.