How to Measure Inventory Performance with Inventory Management Metrics
Answered July 03 2019
Utilizing key performance indicators (KPIs) throughout inventory control systems helps drive more effective decisions and strategies. With valuable insight from inventory performance metrics, businesses are able to improve cash flow, reduce operating costs, and increase customer satisfaction.
Calculating how fast the inventory is moving provides valuable insight into how efficiently it is managed. While having sufficient stock on hand is crucial to keep your supply chain moving smoothly, purchasing and storing items generate also generate costs. Optimizing inventory levels keeps a healthy balance between managing costs and maintaining enough inventory to sustain operations.
Determining Inventory Performance Metrics to Monitor
It’s important to measure how your business operates, in order to create more transparency into profits over time. If you are coming up with a KPI strategy from scratch, it can be daunting to know exactly which inventory management metrics to assess for your business.
For example, if you own a hardware store, you might first consider measuring whether you have enough stock items on hand to meet the needs of customers. However, let’s say you want to understand the availability of your items. A different metric, such as sell-through rate, could give you a better sense of the percentage of units sold, compared to available units.
We recommend identifying the key functions of your business to determine the best inventory performance metrics to adopt for your business. First, look at what value your business brings to customers.
For example, if you are a freight company, the value you bring is how many containers you have in supply to meet the needs of customers. Quantity in stock, as well as time, are two factors you should consider in this situation. Let’s take a look at examples KPIs to consider for your business.
Difference Between Qualitative and Quantitative KPIs
Just like any other measurements, KPIs can be either qualitative or quantitative.
Qualitative measurements do not have a numeric value and can include things like milestone charts, project plans, and critical analysis.
Milestone charts help businesses and organizations visually illustrate a timeline that shows the schedule and intervals for a major project. These are useful to track progress and plan upcoming steps. Project plans can serve as the primary organizational tool that outlines the individual components with deadlines and necessary labor and resources required. Critical analysis can show the specific path, as well as track completions throughout the process.
Quantitative measurements frequently use formulas to determine starting points, set goals, and track measurable progress toward those goals. Let’s consider six quantitative inventory management KPIs.
Six Quantitative Inventory Management KPIs
While these metrics provide an extended view of the stocking performance of a plant, the number of inventory turns is most commonly used to measure the success of inventory levels.
1. Inventory Turnover
To measure performance in inventory management, one of the most common metrics to use is the “number of inventory turns.” This number is calculated using the ratio of the value of purchased stock to the value of stock on hand. The metric, number of inventory turns, aims to measure the movement of stock. The higher the turnover, the less time your inventory spends sitting in storage.
The number of inventory turns, also known as stock turn, is calculated by taking the value of stock purchased, divided by the value of stock on hand.
Calculating inventory turns
Inventory turns = Value of stock purchased/Value of stock on hand
Where: Value of stock purchased = the total value of inventory items purchased over a period of time and Value of stock on hand = the current value of inventory that is in stock
For example, if over a period of one month the total value of purchases amounted to $5,000 while the current value of stock on hand is $2,500, then inventory turns can be calculated as:
Inventory turns = $5,000,000/$2,500,000 = 2
What is a good Inventory turn ratio? Target value of 1.0
As a rule of thumb, the Society for Maintenance & Reliability Professionals (SMRP) suggests an inventory turn value greater than 1.0 when accounting for the total inventory, and a value greater than 3.0 when accounting for inventory without critical spares.
Note that target values are expected to vary across different industries. Values may also vary depending on the maintenance strategy used by an organization.
2. Stock outs
The metric “stock outs” is the frequency of inventory requests without available stock. Most frequently, stock outs impact the entire supply chain of your business. For customers, it can be extremely frustrating when they have to wait on a business for available products, which can translate into reduced loyalty and business. Some causes of stock outs include failure to consistently manage inventory, or machine breakdowns that lead to delays.
Calculating Stock Outs
The number of stock outs, or frequency of inventory requests without available stock, is measured by taking the percentage of number of stock unable to be supplied in terms of monthly or annual sales volume
In equation form: Stock outs = Frequency of stock outs / Monthly sales volume Or Stock outs = Frequency of stock outs/ Annual sales volume For example, if 300 customer orders were not able to be fulfilled out of 1000 total orders for the month, the monthly stock out percentage would be 30%.
3. Inactive Stock
Inactive stock is the amount of non-critical stock that remains unused over a period of time.
Appropriate levels of inventory, as measured using the number of inventory turns, allow plant personnel to take steps towards lowering costs (reducing spend on unneeded inventory) while increasing operational productivity (preventing stock outs).
4. Lost Sales
Another great metric for your business is lost sales, which looks at the frequency a customer asks for an item, but you do not have it in stock, so they go elsewhere. Factors that are important in this calculation include average daily demand, forecasted amount, and customer demand. Having a strong inventory management program prevents businesses from incurring lost sales over time. However, lost sales happen to even the best of business owners.
Calculating Lost Sales
Average daily demand = Current period seasonalized Forecast / number of days in the period Lost Sales Quantity = Average daily demand X # Days out of Stock
5. Carrying Cost of Inventory
An invaluable metric for measuring how much of a manufacturer’s working capital is tied up in inventory, this metric provides insights into the hard-to-find costs of handling items. These include put-away, costs of obsolescence and how effective warehouse management systems (WMS) are in reducing fulfillment costs.
As discussed in the sections above, comparing carrying cost and inventory turnover with your contribution margins is a great way to see which items are worth the extra time in your warehouse.
6. Order Cycle Time
Order cycle time is the time gap between placing one order and the next order. This metric is also referred to as order lead time, but order cycle time is the more popular iteration. Order cycle time measures the time from when a customer places an order to when they receive their purchased product. This metric reflects how effective your inventory management, supply chain, production and fulfillment operations are.
Order cycle time also sometimes refers to the time between the placement of two back-to-back orders or the successful delivery of two consecutive orders. Regardless of how your company defines these metrics, you should still measure them to get a comprehensive view of your order fulfillment process and where you could improve.
Calculating order cycle time
To calculate the order cycle time, you need to first figure out the time order demand is met, and then figure out backorders.
Time during which demand is met= (Optimal order quantity-optimal amount to be backordered)/ Average demand Backorder time = Optimal amount to be backordered/Average Demand Order cycle = time during which demand is met + back order time
Inventory Management Software Can Help
The key to a meaningful inventory metric is collecting accurate data, and doing so efficiently. Gathering accurate inventory data, while exerting minimal manual effort, is best achieved using inventory management software.
Using inventory management software can keep track of your inventory purchases and usages, as your purchase orders and/or work orders are issued. This relieves individual workers from a lot of manual tracking. This allows for a consolidated database of and easy access to metrics about the flow of inventory.
Effectively Managing an MRO Storeroom
A good inventory management program is critical to being able to effectively manage an MRO storeroom. Best practices indicate that overall inventory accuracy should be 95% of total cycle counts. This requires that all tools and parts are ready to be used as soon as they are needed.
One way to improve the efficiency of a storeroom is to move consumables to the areas where they will be used. For example, safety glasses or protective gloves should be available in multiple areas where employees require them. One study noted that a company estimated they could save $75,000 per year if staff stopped going all the way to a storeroom for batteries.
KPIs outlined earlier in this article including inventory value and turns as well as measures on the accuracy of cycle count and scheduled preventive maintenance compliance can help an MRO storeroom better streamline its work processes and inventory management.
Further Inventory Statistics
Although managing inventory is an important job for many manufacturing and distribution organizations, it’s sometimes easy to underestimate the effect that inventory has in our world as a whole. For example, items in inventory as well as in accounts receivable and payable make up about 7 percent of the US gross domestic product alone. In the retail sector, businesses carry about $1.43 in inventory for every dollar of sales.
Inventory management supply chain issues are often top of mind for management teams. For instance, nearly three-fourths of supply chain management professionals believe they can improve their inventory management practices and nearly half hope to reevaluate their warehouse locations.
Automation of inventory management continues to rise with roughly two-thirds of warehouses planning to implement mobile devices in the near future. Studies show that nearly half of all warehouses cite a major issue involving human error.
Dispelling Inventory Management Myths
Many organizations have continued age-old practices when it comes to inventory management because “that’s the way it’s always been done.” However, some of these practices are simply myths and not helpful in making your inventory management system more efficient and effective.
For example, many organizations believe that buying in bulk will reduce costs. In some cases, this can be true. For frequently used consumable items such as paper or cleaning products, buying in bulk can be a good practice. However, components and parts that are replaced or changed infrequently do not benefit from bulk purchases. In fact, the costs of storage and management of infrequently used items can be higher than the bulk savings realized.
Other companies believe that frequent counting of stock can lead to better inventory management and using a simple spreadsheet can track inventory adequately. However, if you’re managing many items, physical counting can take several days and manual recording can result in errors. That said, investing in the newest inventory software system may not be the best answer either.
The reality is that while computerized systems can certainly help manage inventory more efficiently, the critical factors are the quality and accuracy of the information. Training your employees on how to update the inventory system properly and why it’s critical on an ongoing basis is really the key to an accurate and complete inventory management system.
This article was updated with more information in May, 2020
Latest Maintenance Articles
- Root Cause Analysis Techniques and FundamentalsHow to Use eBay to Save Money and Time on ProcurementThe Ultimate Guide to Programmable Logic Controllers (PLCs)How to Respond to an FDA Warning LetterWhat Is Maintenance Process Mapping?Checking for Fever: A Comprehensive Guide to Implementing a Temperature Screening System
Fleet Management and GPS
Oil & Gas
Asset Management Questions & Answers
Root Cause Analysis Techniques and Fundamentals
Root cause analysis (RCA) is key to a successful maintenance program. But to conduct one effectively, it’s critical to understand the components required.
What Is Maintenance Process Mapping?
Without effective maintenance process mapping, an organization will never achieve stable maintenance processes. Learn what you need to know here.
CMMS vs. Asset Management: A Guide to Bridging the Gap
Without a strong background in CMMS and asset management, there is a good chance that you'll only end up with an expensive work order ticket system.
8 Steps to Implementing SOPs in Your Maintenance Team
Implementing standard operating procedures (SOPs) may be a challenge. In this article, we’ll discuss various aspects of how to tackle this challenge.
What Is a Standard Operating Procedure (SOP)?
A standard operating procedure, or SOP, is a document that lays out the steps to do something in a clear and concise way.
SCADA Systems Explained | Onupkeep.com
SCADA is a computer control system used to monitor and control plant processes. It uses data communications and more to monitor systems.
What are different types of food and beverage processing equipment?
We've compiled every type of food and beverage processing equipment out there in a list with everything you need to know.
What Is Straight Line Depreciation, and Why Does It Matter?
Straight Line Depreciation is an accounting method, and accounting is not the first thing you might associate with maintenance.
7 Metrics You Should Be Tracking for Maintenance Inventory
To get the very most out of your MRO (maintenance, reliability, and operations) inventory, you need to track data that reflects costs, turnover, etc.
What is Asset Management & ISO 55000?
An asset is any item that has potential or actual value to the company. Asset management is an approach to achieve the most asset value.
What’s a function and what’s functional failure?
A function describes the intention of a piece of equipment, while functional failures detail conditions that would prevent equipment from peak operation.
What is asset management? What are the top asset management certifications?
Asset management is generally defined as a system of activities that an organization performs to gain value from assets, including design and maintenance.
What are maintenance tasks to perform on indoor cycling bikes?
Maintenance tasks for indoor cycling bikes include daily, weekly and monthly cleaning, inspection, and adjustments to ensure strong durability.
What are some types of assistive devices and how are they used?
Assistive devices help individuals with disabilities live a more independent life by using technology and increasing everyday accessibility.
What is a Purchase Order and What to Include?
Purchase orders (POs) are created to start a purchasing relationship with an outside vendor. POs include quantity, delivery schedule, and payment terms.
What is maintenance management?
Maintenance management is the process of maintaining a company’s resources. It ensures efficient production and effective use of resources.
What are the most common ISO standards for manufacturing facilities to follow?
The most common ISO standards to follow for manufacturing facilities are ISO 55000, 55001, and 55002. All require an asset management system.
What is a bathtub curve?
A bathtub curve is a visual of a product's failure rate over time that maps out three periods that an asset experiences within its lifetime.
6 Interesting Facts About Equipment Failure
When it comes to equipment failure, there are a few interesting trends that we see. We can see some of the challenges effective reliability planning.
What are the phases of a turnaround maintenance procedure?
In maintenance, a turnaround is an event where one or more assets are temporarily removed from service so that maintenance tasks can be performed.
How much should I budget for maintenance for my equipment?
You should budget approximately 2% to 5% of your total RAV. This metric, known as %RAV, is calculated as a proportion of your facility's value and spending.
What is a fixed asset?
A fixed asset is one of two major categories of physical property for a company and includes those items that remain in one location during business operation.
What are the most common root cause analysis (RCA) mistakes and how do I avoid them?
Some of the most common root cause analysis mistakes involve poor definitions, focusing on the wrong thing, or ignoring root causes entirely.
How do I conduct a thorough root cause analysis?
For root cause analysis to be effective, you need to dig deep, have the right resources, and ask “Why?” until you get to a root cause.
What is the importance of collecting equipment failure data?
The collection of equipment failure data over time determines the reliability of your facility and enables proper asset management and life-cycle analysis.
Which root cause analysis (RCA) method should I use?
Of the numerous RCA methods used, the one you choose depends on the depth and nature of the problem, as well as the number of contributing causes.
When should I repair or replace an asset?
In order to decide if it is time to repair or replace an asset, you must compare the current value of the asset with the cost of repair.
What is Equipment Depreciation? Why it Matters + How to Calculate
Equipment depreciation is a measure of how much a piece of equipment drops in value each year. Using depreciation, you can make wiser maintenance decisions.
What is an asset life cycle?
An asset life cycle refers to the stages involved in the management of an asset. The life cycle of an asset starts with the planning stages.
What is the difference between availability and reliability?
Availability measures equipment's ability to operate, while reliability measures the ability of equipment to perform without failure.
What’s idle time and how does it differ from downtime?
Idle time is the time in which an asset is either waiting to run or isn’t scheduled to run and downtime is when the asset is incapable of running.
What is the difference between criticality and risk analysis with regards to maintenance and reliability?
Criticality is a measure of how important an asset is to your process. The more critical the asset, the more of an impact it will have if fails.
What is the difference between total effective equipment performance (TEEP) and overall equipment effectiveness (OEE)?
Overall equipment effectiveness (OEE), the most common metricperformance of a plant, is expressed as a percentage of the total production time.
What are leading and lagging metrics in maintenance?
Indicators are classified according to whether they predict future performance or describe past performance –- referred to as leading or lagging indicators.
What are ways to improve my equipment uptime?
There are numerous ways to improve your equipment uptime, each of which has to do with streamlining your maintenance processes.
What are the best metrics and KPIs for manufacturing companies?
Downtime and uptime are the heartbeats of a manufacturer - when the facility has too much downtime, the health of the organization suffers.
What’s the difference between downtime and breakdown time?
Breakdown time is downtime that results from the equipment breaking down. Equipment downtime is any time a piece of equipment is offline.
What are the maintenance costs associated with one unit of production?
The maintenance unit cost is a snapshot of the total maintenance cost required to manufacture a standard unit of production during a set period of time.
How would I implement a total productive maintenance program?
When implementing total productive maintenance (TPM), I think it’s best to gradually phase it in. It will enable an organization-wide adjustment over time.
What is the best way to use failure codes for root cause analysis?
Use failure codes systematically: start with analyzing the reasons for failures, code this information in a consistent way, and make it accessible.
What are the five pillars of maintenance and reliability?
The SMRP identified five pillars of maintenance and reliability to help facility managers create a framework for their businesses.
How much should I be spending on maintenance for industrial equipment and assets?
One such goal is to strive for spending 3 percent or less of your replacement asset value (RAV) annually on maintenance costs. Here are the details.
Should I use barcodes or RFID tags to track my equipment and assets?
Both bar codes and RFID tags can help you track your assets and equipment; and each has its own unique advantages and disadvantages.
Useful life of an Asset: Definition & Examples
IRS Publication 946, Appendix B, lists useful life estimates by industry and application. These estimates can be used as a baseline.
What do I do with old industrial equipment?
Either you replace old equipment, or you keep it around. The route you choose depends on your facility’s current demands.
What is the difference between PLC and SCADA?
The primary difference between a PLC (or Programmable Logic Controller) and SCADA is the fact that a PLC is hardware and SCADA is generally software
What are the dangers of using the mean time between failure (MTBF) metric?
When MTBF is presented you cannot instantly ascertain whether the metric is being influenced more by the uptime duration or by the number of breakdowns.
Is maintenance cost to asset value ratio a good maintenance metric?
The short answer to the question is generally “no”. However, asking the question sets into motion the bigger issue of how to evaluate any metric in facilities management.
What does a good electric motor testing program look like?
Implementing a good electric motor testing (EMT) program can be a massive positive investment in the reliability of a facility's equipment.
Am I spending too much (or too little) on maintenance activities?
A common metric is taking the total maintenance cost (MC) as a percentage of the estimated plant replacement value (PRV).
When do I need to hire a reliability engineer? How does reliability affect safety?
If you want to take proactive steps towards maintenance and you have enough data to analyze, you can benefit from hiring a reliability engineer.
How do you implement an asset life cycle management program?
Implementing a stellar asset life cycle management program requires alignment with your business strategy, data-driven decisions, and the right culture.
What are the 8 kinds of waste in Lean Six Sigma?
All continuous improvement programs and computerized maintenance systems strive for the common goal of reducing this waste as much as possible.
How can you achieve world class manufacturing reliability?
World-class manufacturing facilities successfully stay ahead of breakdowns, achieve higher asset utilization, reduce maintenance costs, and increase safety.
How can you make rotating equipment operate better, for longer?
To answer that, we should first understand exactly what causes rotating equipment to fail. The majority of failures come down to unbalance and misalignment.
What mistakes do maintenance teams make when lubricating bearings?
Overall, the main mistakes I’ve seen with lubricating bearings have to do with either too much lubrication or too little.
What makes a reliability engineer great?
Finding causes of problems can be tricky, and convincing maintenance technicians to accept new practices can be even trickier. Here are some ideas to help:
What are common mistakes reliability engineers make?
Reliability engineering is a complex process with lots of room for potential errors, lost time, and wasted money. Stay forward thinking and proactive.
What are common misconceptions about plant maintenance?
More people on maintenance staff doesn't necessarily reduce problems. In fact, it creates another kind of problem in terms of ineffective resource use
What are the benefits of infrared imaging?
Infrared analysis is actually super useful for checking temperatures, especially when you're comparing the temperature of an asset to another asset.
What mistakes are common with reliability-centered maintenance?
While RCM seems simple on its face, there are a huge number of moving parts within any solid reliability-centered maintenance plan that could go wrong.
When should I perform preventive maintenance on equipment?
Begin by checking the OEM manual. This will typically provide you with preventive maintenance guidelines. dffdadfdsfasdfasdfasdf
How do you track asset depreciation?
In order to track asset depreciation, you'll use its annual depreciation. The formula is (Initial Cost - Salvage Value) ÷ Useful Life = Annual Depreciation.
How do you determine which machines should receive preventive maintenance?
Selecting machines for preventive maintenance is a matter of finding which ones would benefit most from PM while keeping maintenance costs down.
Where should you store equipment manuals and warranties?
A CMMS is a great way to organize user manuals and warranties by asset. Upload them and they’re ready to view by anyone with access.