Inventory is “healthy” when the most important products don’t run short and no more money is invested in stock than actual consumption and replenishment time require. A single number won’t show you that. You need a set of KPIs that you read together: one that shows how much money is tied up in stock, another that shows whether customers get what they need, and a few more that show where something is going wrong with your inventory.
In practice, we often see that before implementation, our clients are lost in a range of reports and figures that each show something. That is exactly why we give our clients only a few KPIs for inventory management: the ones that are most needed and enough to manage inventory effectively:
- Inventory turnover
- Availability or lost sales
- Overstock (write-offs for short shelf-life goods)
- Slow-moving and non-moving stock
- Buffer status over time at company, warehouse and SKU level
- Supplier reliability
The first KPI is the one finance usually watches. The others explain why it is where it is.
This article is part of our series:
- Inventory and working capital: is inventory a company investment?
- Where does working capital get tied up in inventory?
- How does managing inventory with dynamic buffers help release cash tied up in stock?
Why can’t one number tell you whether inventory is “healthy”?
Most companies look at inventory through its total value. It’s the figure on the balance sheet, and it’s the one that gets discussed when cash runs short. The total shows what the stock is worth on paper. But it doesn’t tell you whether it’s the right products, in the right places, in the right quantities.
A company can hold a lot of stock and still be short of the products customers want. As we explain in Inventory and working capital: is inventory a company investment?, surplus and shortages can exist at the same time, because stock is spread unevenly across products and warehouses. A total that looks normal can hide a warehouse full of slow movers and empty shelves where the best sellers should be.
That’s why inventory health has two sides, and both need to be measured:
- Money: how much capital is tied up in stock and how quickly it comes back through sales.
- Availability: whether the most important products are there when customers or production need them.
If you look at only one side, you can end up going in the wrong direction. Cutting stock frees up cash, but products may start to run short. And the other way round: if you hold larger quantities so that products don’t run out, you tie up more cash in stock as a result. That’s why we use KPIs that stop you from judging only one situation or the other in isolation.
Which inventory management KPIs matter most?
Based on our more than 15 years of experience, the list is short. Below are the main KPIs we measure, and why each one matters.
| KPI | What does it show? | Read it together with |
| Inventory turnover | How quickly stock turns into cash, in other words how long money stays in stock before it comes back through sales | Availability of key products (lost sales) |
| Availability or lost sales | Whether the most important products are there when they’re needed | Inventory turnover |
| Overstock (and write-offs for short shelf-life goods) | How much stock exceeds what consumption calls for, taking the replenishment cycle into account | Shortages at the same time |
| Slow-moving and non-moving stock | Which stock is no longer turning into cash | Overstock |
| Buffer status over time (company, warehouse, SKU level) | Whether the target stock level is still the right size, and where surplus or shortages are building up | Supplier reliability |
| Supplier reliability | The share of orders over 6 or 12 months delivered on time and accurately | Buffer status / lost sales and overstock |
1. Inventory turnover
Inventory turnover shows how many times a year the stock is replaced; in other words, how quickly the money invested in it comes back through sales:
Inventory turnover = cost of sales / inventory
The same ratio can be expressed in days. ACCA describes the inventory holding period as a measure of how long a company holds inventory before it is sold, and calculates it as follows (ACCA, Ratio analysis):
Inventory days = (inventory / cost of sales) × 365
or
Inventory days = 365 / inventory turnover
So a turnover of five times a year equals 73 inventory days. Both use cost of sales rather than revenue, because inventory is carried at cost. We recommend using average inventory for the period rather than the closing balance, so that one unusually high or low month-end doesn’t distort the result. Whichever option you choose, agree it with finance and don’t change it from one period to the next.
The weakness of turnover is that it’s an average. A company-wide figure can be made up of best sellers that run out after two weeks and slow movers with enough stock for a year. That’s why the KPI is far more useful when it’s calculated by product group, warehouse, and supplier rather than as a single number.
2. Availability or lost sales
This KPI stops inventory reduction from going too far. Availability can be measured in two ways: cycle service level, which shows whether demand is met during each replenishment cycle, and fill rate, the share of demand met from stock across all periods (NC State University, Supply Chain Resource Cooperative).
Whichever measure you choose, apply it to the most important products rather than averaging it across the whole range. A 98% average looks good, but not when the missing 2% are your best sellers.
Lost sales need to be discussed with care. A stockout doesn’t necessarily mean a completely lost sale: a customer may wait, choose a substitute, or buy next time. Others may go elsewhere, and the accounts don’t record a sale that never happened. Track how many days the most important products were out of stock and, where possible, estimate lost sales. Urgent orders and express deliveries are also a signal: they show what it costs to avoid a lost sale.
3. Overstock (and write-offs for short shelf-life goods)
Overstock is stock above what actual consumption calls for, taking the replenishment cycle into account. In TOC inventory management, that line is the buffer: the stock deliberately held of a specific product at a specific location so that it doesn’t run short before the next replenishment (StockM, TOC buffer zones). Anything above the buffer is overstock.
Measure overstock not only in units but also in value at cost, because that’s what turns into cash. And look at why it’s there. Some of it may have been bought on purpose, for example, to meet a supplier’s minimum order quantity or to prepare for a season. That isn’t necessarily a mistake, but every deliberate surplus should have a reason and an end date.
For short shelf-life goods, we do not calculate overstock. Whatever isn’t sold before its expiry date is written off, so for these goods, write-offs are a direct measure of overstock. Track them by value, product group and reason. Write-offs reduce profit directly, so a rise in write-offs is one of the clearest signs that more is being ordered than consumed. For short shelf-life goods, StockM calculates buffers taking expiry dates and the expected pace of sales into account (StockM, Retail and perishable goods).
4. Slow-moving and non-moving stock
This KPI shows which stock is no longer turning into cash. Set clear thresholds, for example 90 or 180 days without consumption, and track what share of inventory value falls into each group. The exact threshold depends on the sector: 90 days without a sale means something completely different for fresh food than for car spare parts.
The longer stock sits, the fewer options remain to sell it and release the money invested in it. If you spot slow movers early, there’s still time to transfer them, return them to the supplier, reprice them or stop replenishing them.
5. Buffer status over time: company, warehouse and SKU level
This is the KPI most characteristic of TOC inventory management and, in our view, the most useful for day-to-day decisions. Each buffer is divided into green, yellow, and red zones. Products in the red zone may run short, products in the yellow zone are being consumed as expected, and products in the green zone have enough stock (StockM, TOC buffer zones).
Buffer status is worth assessing at three levels:
- SKU level: the product’s situation today and which zone its stock is in. If stock keeps staying in the green zone, it’s time to reduce the buffer. If it is constantly in the red zone or even runs out, that’s a clear signal the buffer needs to be increased.
- Warehouse level: buffer status at warehouse level shows how effectively products are managed in that warehouse. A steadily shrinking red zone and a growing green zone show that inventory is being managed well. Even so, the lost sales and overstock reports should be read alongside it, to check that a shrinking red zone doesn’t mean surplus is building up. And, the other way round, to check whether the shrinking red zone really does protect against lost sales.
- Company level: what share of products is in the red zone and what share is above green, and how these zones change from month to month. This shows the overall situation across the company’s warehouses.
One day’s status tells you where to act today. Several months of status tell you whether the buffer itself is right. StockM recommends looking at the pattern rather than at individual events: if a product is often in the red zone, the buffer may be too small, the lead-time data may be inaccurate, or the order cycle may be too long; if it is mostly in the green zone, the buffer may be too big, or the product may no longer be as important as it was; if it moves between green and yellow and only occasionally drops into red, the buffer is the right size.
The value of this KPI is that it changes earlier than the financial KPIs. Turnover, lost sales, and overstock show what has already happened. Buffer status shows where surplus and shortages are building up right now.
6. Supplier reliability
We assess supplier reliability by the share of orders over the last 6 or 12 months that were fulfilled on time and accurately, meaning that exactly what was actually ordered was delivered, in exactly the quantities that were ordered.
The buffer has to cover the product’s consumption over the order cycle and the replenishment time (StockM, TOC buffer zones). If a supplier is late, or delivers the wrong products or the wrong quantities, the buffer is built on a false assumption and the product will keep dropping into the red zone. The opposite situation matters just as much: when a supplier becomes more reliable, the extra stock held because of its past delays is no longer needed. As we showed in an earlier article in this series, that stock often stays in the warehouse long after the reason for it has gone (StockM, Where does working capital get tied up in inventory?).
In our experience, this KPI is also an important argument in negotiations with suppliers. When you have 6 or 12 months of data on every order and on delivery terms, you talk to the supplier in facts rather than sharing opinions or gut feelings.
What do these KPIs mean in financial terms?
It’s easy to read too much into inventory KPIs in financial terms. When you present them to management, it’s worth keeping a few things clearly apart:
- Fewer inventory days release cash once. If average inventory falls, the cash tied up in it comes back once. It doesn’t recur every year the way a cost saving does.
- Holding costs are the recurring part. Lower stock can mean lower storage, insurance and handling costs and a lower risk of obsolescence. How much you save depends on your cost structure.
- Higher turnover doesn’t automatically mean higher profit. If turnover improved because surplus was sold off below cost, the cash comes back, but margin falls and a loss may appear in the accounts.
- A stockout doesn’t necessarily mean a completely lost sale. Some customers wait or choose a substitute. So this KPI should be treated as indicative; in other words, as how much more the company could earn if it always had the products it needs. Effective inventory management doesn’t mean zero lost sales, because ensuring every product is always available would cost the business too much. What matters is the trend and real revenue growth as lost sales come down.
How does StockM measure inventory health?
StockM is an assortment and inventory management system based on TOC and Dynamic Buffer Management (DBM). Every product in every warehouse has a buffer that is continuously adjusted to actual consumption (StockM, Where does working capital get tied up in inventory?). The system assesses how far each buffer has been used up, suggests the quantity needed to replenish it, flags red-zone products that need attention, and builds a list of products to order by priority (StockM, Buffer-based inventory management).
StockM works alongside the company’s ERP or accounting system, which needs to provide product data every day, such as stock balances, sales, replenishments, and write-offs (StockM system). The implementation manager helps the client’s team build an inventory management routine based on this data. The software lets you see the KPIs every day, but they only improve when the team acts on them, and the figures are only as good as the data coming in.
Hypothetical example
The example below shows clearly how the KPIs work together. It is not a client case. To keep the calculations simple, we assume all three products have the same unit cost, so units can be added up and inventory days can be calculated in units. Each product is ordered every two weeks, and the agreed lead time is one week.
A wholesale company calculates about 59 inventory days for one product group. Finance sees no cause for concern. But broken down by product, the picture changes:
| Product | Consumption over the last year (units) | Average stock (units) | Inventory days | Buffer status over the last 26 weeks |
| A | 5,200 (about 100 a week) | 300 | 21 | In the red zone for 9 weeks |
| B | 2,600 (about 50 a week) | 900 | 126 | Above the green zone for all 26 weeks |
| C | 520 (all in the first 39 weeks) | 140 | 98 | No consumption in the last 13 weeks |
| Group total | 8,320 | 1,340 | 59 |
Inventory days are calculated as average stock ÷ consumption × 365; for example, for product A: 300 ÷ 5,200 × 365 = 21.
The 59-day average hides three different problems:
- Product A moves fast but keeps dropping into the red zone. The supplier’s delivery data shows the goods arriving in two to three weeks rather than the agreed one. The buffer is too small for the lead time the supplier actually works to, so the first step is to correct the lead-time data and negotiate with the supplier.
- Product B sells regularly, but there is far more stock than needed. With a two-week order cycle, a one-week lead time, and sales of 60 units in the busiest week, a three-week buffer would be 3 × 60 = 180 units. Average stock is 900, so about 720 units sit above the buffer. If you stop reordering these units, selling 50 a week, they will sell through in about 14 to 15 weeks and release the cash tied up in them.
- Product C hasn’t sold for the last three months. If we calculated inventory days from average sales over the year, its 98 days would look no worse than product B’s 126. But the average hides something else: this stock isn’t turning into cash at all right now. The product should go on the non-moving list, and someone has to decide whether to transfer it, return it to the supplier, reprice it, or stop replenishing it.
When we look at overall KPIs in a report, we don’t see the deeper problems happening in the stock. The situation becomes clear when inventory days, buffer status, supplier lead times and slow-moving stock are assessed together, for each product separately.
StockM client: car spare parts supplier
This is experience from a StockM implementation project. The client’s name is not disclosed, and no figures are published.
The client supplies and sells car spare parts. After implementing the system and adjusting the supply flows, we presented the progress of the project to the client, with the results we could already see and our recommendations on where to go next and how to manage inventory more effectively.
The client had a sizeable share of excess stock, which, once the system was in place, they worked through quite effectively.
But the company also had another goal: to expand its range and compete not only in its home market but in neighboring countries too. In terms of the numbers, expanding the range brought no noticeable benefit: inventory grew, and it was good inventory, within its buffers, but sales didn’t. At the same time, inventory turnover fell.
We presented the figures to the client and pointed out specifically that this could become a problem. Even so, the client accepted the risk and took responsibility for it, because expanding the range was one of the company’s strategic goals.
That is why you always have to look at the whole picture. As implementers of inventory management systems, we always focus on the numbers and set aside actions driven by emotion or gut feeling. Yet while we watch the numbers, we also have to weigh what the numbers don’t show us: the company’s goals, customer satisfaction, and so on.
This case also shows why the KPIs described above need to be read together. Buffer status showed that the stock level of each product was justified. Sales and inventory turnover showed that the wider range wasn’t increasing sales. Both were true, and the decision about what to do about it was a business question, not a calculation.
How can you start measuring inventory health in your company now?
- Choose a short list. Start with the six KPIs described above.
- Agree the definitions with finance. Average or closing inventory, the cost basis, the thresholds for slow-moving stock, how lost sales are estimated. Write them down and don’t change them.
- Measure at the product and warehouse level. Average turnover or total inventory value is fine for management reports, but it doesn’t tell you what to do. So make decisions for each product separately.
- Always assess money together with product availability. Never present inventory turnover without the availability of the most important products alongside it.
- Assess buffer status over months, not days. Daily status tells you what to do today. The pattern over several months tells you whether the buffer is the right size.
- Set an end date for every temporary increase in stock. Seasonal and promotional stock should come down when the season or promotion ends.
- Report released cash and recurring savings separately. Management needs to know which part comes back once and which part recurs.
Frequently asked questions
There isn’t one. If your company usually calculates and evaluates inventory turnover, you should read it together with lost sales and overstock. A high turnover rate with significant lost sales indicates a shortage of the items that drive revenue. Conversely, a low turnover rate combined with a large overstock suggests that capital is tied up in goods that are not selling or are selling very slowly.
No. Turnover can rise because stock has been cut so far that customers can’t find what they need, or because surplus has been sold off below cost. Higher turnover is good news only when availability holds, and margin doesn’t fall as a result.
Buffer status and shortages should be reviewed daily, as immediate decisions may be required, especially when lost sales occur. Overstock and slow-moving stock suit a weekly or monthly review. Inventory turnover is usually reported monthly or quarterly, and supplier reliability is assessed over 6 or 12 months.
Partly. If your ERP holds stock balances, sales, receipts, and write-offs, you can calculate inventory turnover from it. Buffer status needs one more thing: a target stock level for each product in each warehouse, calculated from its consumption and lead time. StockM provides these reports alongside the ERP without replacing it (StockM system).
Yes, when they manage stocks of materials, components, and finished goods. The same KPIs apply, and supplier reliability is often the most important one (read more in Manufacturing).
Sources
- StockM: Inventory and working capital: is inventory a company investment?
- StockM: Where does working capital get tied up in inventory?
- StockM: Buffer zones of TOC in practice: green, yellow, red
- StockM: Buffer-based inventory management
- StockM: StockM system
- StockM sector pages: wholesale and distribution, retail and perishable goods, manufacturing
- ACCA: Ratio analysis
- NC State University, Supply Chain Resource Cooperative: Reorder point formula: Inventory management models: a tutorial
Inventory is “healthy” when the most important products don’t run short and no more money is invested in stock than actual consumption and replenishment time require. A single number won’t show you that. You need a set of KPIs that you read together: one that shows how much money is tied up in stock, another that shows whether customers get what they need, and a few more that show where something is going wrong with your inventory.
In practice, we often see that before implementation, our clients are lost in a range of reports and figures that each show something. That is exactly why we give our clients only a few KPIs for inventory management: the ones that are most needed and enough to manage inventory effectively:
- Inventory turnover
- Availability or lost sales
- Overstock (write-offs for short shelf-life goods)
- Slow-moving and non-moving stock
- Buffer status over time at company, warehouse and SKU level
- Supplier reliability
The first KPI is the one finance usually watches. The others explain why it is where it is.
This article is part of our series:
- Inventory and working capital: is inventory a company investment?
- Where does working capital get tied up in inventory?
- How does managing inventory with dynamic buffers help release cash tied up in stock?
Why can’t one number tell you whether inventory is “healthy”?
Most companies look at inventory through its total value. It’s the figure on the balance sheet, and it’s the one that gets discussed when cash runs short. The total shows what the stock is worth on paper. But it doesn’t tell you whether it’s the right products, in the right places, in the right quantities.
A company can hold a lot of stock and still be short of the products customers want. As we explain in Inventory and working capital: is inventory a company investment?, surplus and shortages can exist at the same time, because stock is spread unevenly across products and warehouses. A total that looks normal can hide a warehouse full of slow movers and empty shelves where the best sellers should be.
That’s why inventory health has two sides, and both need to be measured:
- Money: how much capital is tied up in stock and how quickly it comes back through sales.
- Availability: whether the most important products are there when customers or production need them.
If you look at only one side, you can end up going in the wrong direction. Cutting stock frees up cash, but products may start to run short. And the other way round: if you hold larger quantities so that products don’t run out, you tie up more cash in stock as a result. That’s why we use KPIs that stop you from judging only one situation or the other in isolation.
Which inventory management KPIs matter most?
Based on our more than 15 years of experience, the list is short. Below are the main KPIs we measure, and why each one matters.
| KPI | What does it show? | Read it together with |
| Inventory turnover | How quickly stock turns into cash, in other words how long money stays in stock before it comes back through sales | Availability of key products (lost sales) |
| Availability or lost sales | Whether the most important products are there when they’re needed | Inventory turnover |
| Overstock (and write-offs for short shelf-life goods) | How much stock exceeds what consumption calls for, taking the replenishment cycle into account | Shortages at the same time |
| Slow-moving and non-moving stock | Which stock is no longer turning into cash | Overstock |
| Buffer status over time (company, warehouse, SKU level) | Whether the target stock level is still the right size, and where surplus or shortages are building up | Supplier reliability |
| Supplier reliability | The share of orders over 6 or 12 months delivered on time and accurately | Buffer status / lost sales and overstock |
1. Inventory turnover
Inventory turnover shows how many times a year the stock is replaced; in other words, how quickly the money invested in it comes back through sales:
Inventory turnover = cost of sales / inventory
The same ratio can be expressed in days. ACCA describes the inventory holding period as a measure of how long a company holds inventory before it is sold, and calculates it as follows (ACCA, Ratio analysis):
Inventory days = (inventory / cost of sales) × 365
or
Inventory days = 365 / inventory turnover
So a turnover of five times a year equals 73 inventory days. Both use cost of sales rather than revenue, because inventory is carried at cost. We recommend using average inventory for the period rather than the closing balance, so that one unusually high or low month-end doesn’t distort the result. Whichever option you choose, agree it with finance and don’t change it from one period to the next.
The weakness of turnover is that it’s an average. A company-wide figure can be made up of best sellers that run out after two weeks and slow movers with enough stock for a year. That’s why the KPI is far more useful when it’s calculated by product group, warehouse, and supplier rather than as a single number.
2. Availability or lost sales
This KPI stops inventory reduction from going too far. Availability can be measured in two ways: cycle service level, which shows whether demand is met during each replenishment cycle, and fill rate, the share of demand met from stock across all periods (NC State University, Supply Chain Resource Cooperative).
Whichever measure you choose, apply it to the most important products rather than averaging it across the whole range. A 98% average looks good, but not when the missing 2% are your best sellers.
Lost sales need to be discussed with care. A stockout doesn’t necessarily mean a completely lost sale: a customer may wait, choose a substitute, or buy next time. Others may go elsewhere, and the accounts don’t record a sale that never happened. Track how many days the most important products were out of stock and, where possible, estimate lost sales. Urgent orders and express deliveries are also a signal: they show what it costs to avoid a lost sale.
3. Overstock (and write-offs for short shelf-life goods)
Overstock is stock above what actual consumption calls for, taking the replenishment cycle into account. In TOC inventory management, that line is the buffer: the stock deliberately held of a specific product at a specific location so that it doesn’t run short before the next replenishment (StockM, TOC buffer zones). Anything above the buffer is overstock.
Measure overstock not only in units but also in value at cost, because that’s what turns into cash. And look at why it’s there. Some of it may have been bought on purpose, for example, to meet a supplier’s minimum order quantity or to prepare for a season. That isn’t necessarily a mistake, but every deliberate surplus should have a reason and an end date.
For short shelf-life goods, we do not calculate overstock. Whatever isn’t sold before its expiry date is written off, so for these goods, write-offs are a direct measure of overstock. Track them by value, product group and reason. Write-offs reduce profit directly, so a rise in write-offs is one of the clearest signs that more is being ordered than consumed. For short shelf-life goods, StockM calculates buffers taking expiry dates and the expected pace of sales into account (StockM, Retail and perishable goods).
4. Slow-moving and non-moving stock
This KPI shows which stock is no longer turning into cash. Set clear thresholds, for example 90 or 180 days without consumption, and track what share of inventory value falls into each group. The exact threshold depends on the sector: 90 days without a sale means something completely different for fresh food than for car spare parts.
The longer stock sits, the fewer options remain to sell it and release the money invested in it. If you spot slow movers early, there’s still time to transfer them, return them to the supplier, reprice them or stop replenishing them.
5. Buffer status over time: company, warehouse and SKU level
This is the KPI most characteristic of TOC inventory management and, in our view, the most useful for day-to-day decisions. Each buffer is divided into green, yellow, and red zones. Products in the red zone may run short, products in the yellow zone are being consumed as expected, and products in the green zone have enough stock (StockM, TOC buffer zones).
Buffer status is worth assessing at three levels:
- SKU level: the product’s situation today and which zone its stock is in. If stock keeps staying in the green zone, it’s time to reduce the buffer. If it is constantly in the red zone or even runs out, that’s a clear signal the buffer needs to be increased.
- Warehouse level: buffer status at warehouse level shows how effectively products are managed in that warehouse. A steadily shrinking red zone and a growing green zone show that inventory is being managed well. Even so, the lost sales and overstock reports should be read alongside it, to check that a shrinking red zone doesn’t mean surplus is building up. And, the other way round, to check whether the shrinking red zone really does protect against lost sales.
- Company level: what share of products is in the red zone and what share is above green, and how these zones change from month to month. This shows the overall situation across the company’s warehouses.
One day’s status tells you where to act today. Several months of status tell you whether the buffer itself is right. StockM recommends looking at the pattern rather than at individual events: if a product is often in the red zone, the buffer may be too small, the lead-time data may be inaccurate, or the order cycle may be too long; if it is mostly in the green zone, the buffer may be too big, or the product may no longer be as important as it was; if it moves between green and yellow and only occasionally drops into red, the buffer is the right size.
The value of this KPI is that it changes earlier than the financial KPIs. Turnover, lost sales, and overstock show what has already happened. Buffer status shows where surplus and shortages are building up right now.
6. Supplier reliability
We assess supplier reliability by the share of orders over the last 6 or 12 months that were fulfilled on time and accurately, meaning that exactly what was actually ordered was delivered, in exactly the quantities that were ordered.
The buffer has to cover the product’s consumption over the order cycle and the replenishment time (StockM, TOC buffer zones). If a supplier is late, or delivers the wrong products or the wrong quantities, the buffer is built on a false assumption and the product will keep dropping into the red zone. The opposite situation matters just as much: when a supplier becomes more reliable, the extra stock held because of its past delays is no longer needed. As we showed in an earlier article in this series, that stock often stays in the warehouse long after the reason for it has gone (StockM, Where does working capital get tied up in inventory?).
In our experience, this KPI is also an important argument in negotiations with suppliers. When you have 6 or 12 months of data on every order and on delivery terms, you talk to the supplier in facts rather than sharing opinions or gut feelings.
What do these KPIs mean in financial terms?
It’s easy to read too much into inventory KPIs in financial terms. When you present them to management, it’s worth keeping a few things clearly apart:
- Fewer inventory days release cash once. If average inventory falls, the cash tied up in it comes back once. It doesn’t recur every year the way a cost saving does.
- Holding costs are the recurring part. Lower stock can mean lower storage, insurance and handling costs and a lower risk of obsolescence. How much you save depends on your cost structure.
- Higher turnover doesn’t automatically mean higher profit. If turnover improved because surplus was sold off below cost, the cash comes back, but margin falls and a loss may appear in the accounts.
- A stockout doesn’t necessarily mean a completely lost sale. Some customers wait or choose a substitute. So this KPI should be treated as indicative; in other words, as how much more the company could earn if it always had the products it needs. Effective inventory management doesn’t mean zero lost sales, because ensuring every product is always available would cost the business too much. What matters is the trend and real revenue growth as lost sales come down.
How does StockM measure inventory health?
StockM is an assortment and inventory management system based on TOC and Dynamic Buffer Management (DBM). Every product in every warehouse has a buffer that is continuously adjusted to actual consumption (StockM, Where does working capital get tied up in inventory?). The system assesses how far each buffer has been used up, suggests the quantity needed to replenish it, flags red-zone products that need attention, and builds a list of products to order by priority (StockM, Buffer-based inventory management).
StockM works alongside the company’s ERP or accounting system, which needs to provide product data every day, such as stock balances, sales, replenishments, and write-offs (StockM system). The implementation manager helps the client’s team build an inventory management routine based on this data. The software lets you see the KPIs every day, but they only improve when the team acts on them, and the figures are only as good as the data coming in.
Hypothetical example
The example below shows clearly how the KPIs work together. It is not a client case. To keep the calculations simple, we assume all three products have the same unit cost, so units can be added up and inventory days can be calculated in units. Each product is ordered every two weeks, and the agreed lead time is one week.
A wholesale company calculates about 59 inventory days for one product group. Finance sees no cause for concern. But broken down by product, the picture changes:
| Product | Consumption over the last year (units) | Average stock (units) | Inventory days | Buffer status over the last 26 weeks |
| A | 5,200 (about 100 a week) | 300 | 21 | In the red zone for 9 weeks |
| B | 2,600 (about 50 a week) | 900 | 126 | Above the green zone for all 26 weeks |
| C | 520 (all in the first 39 weeks) | 140 | 98 | No consumption in the last 13 weeks |
| Group total | 8,320 | 1,340 | 59 |
Inventory days are calculated as average stock ÷ consumption × 365; for example, for product A: 300 ÷ 5,200 × 365 = 21.
The 59-day average hides three different problems:
- Product A moves fast but keeps dropping into the red zone. The supplier’s delivery data shows the goods arriving in two to three weeks rather than the agreed one. The buffer is too small for the lead time the supplier actually works to, so the first step is to correct the lead-time data and negotiate with the supplier.
- Product B sells regularly, but there is far more stock than needed. With a two-week order cycle, a one-week lead time, and sales of 60 units in the busiest week, a three-week buffer would be 3 × 60 = 180 units. Average stock is 900, so about 720 units sit above the buffer. If you stop reordering these units, selling 50 a week, they will sell through in about 14 to 15 weeks and release the cash tied up in them.
- Product C hasn’t sold for the last three months. If we calculated inventory days from average sales over the year, its 98 days would look no worse than product B’s 126. But the average hides something else: this stock isn’t turning into cash at all right now. The product should go on the non-moving list, and someone has to decide whether to transfer it, return it to the supplier, reprice it, or stop replenishing it.
When we look at overall KPIs in a report, we don’t see the deeper problems happening in the stock. The situation becomes clear when inventory days, buffer status, supplier lead times and slow-moving stock are assessed together, for each product separately.
StockM client: car spare parts supplier
This is experience from a StockM implementation project. The client’s name is not disclosed, and no figures are published.
The client supplies and sells car spare parts. After implementing the system and adjusting the supply flows, we presented the progress of the project to the client, with the results we could already see and our recommendations on where to go next and how to manage inventory more effectively.
The client had a sizeable share of excess stock, which, once the system was in place, they worked through quite effectively.
But the company also had another goal: to expand its range and compete not only in its home market but in neighboring countries too. In terms of the numbers, expanding the range brought no noticeable benefit: inventory grew, and it was good inventory, within its buffers, but sales didn’t. At the same time, inventory turnover fell.
We presented the figures to the client and pointed out specifically that this could become a problem. Even so, the client accepted the risk and took responsibility for it, because expanding the range was one of the company’s strategic goals.
That is why you always have to look at the whole picture. As implementers of inventory management systems, we always focus on the numbers and set aside actions driven by emotion or gut feeling. Yet while we watch the numbers, we also have to weigh what the numbers don’t show us: the company’s goals, customer satisfaction, and so on.
This case also shows why the KPIs described above need to be read together. Buffer status showed that the stock level of each product was justified. Sales and inventory turnover showed that the wider range wasn’t increasing sales. Both were true, and the decision about what to do about it was a business question, not a calculation.
How can you start measuring inventory health in your company now?
- Choose a short list. Start with the six KPIs described above.
- Agree the definitions with finance. Average or closing inventory, the cost basis, the thresholds for slow-moving stock, how lost sales are estimated. Write them down and don’t change them.
- Measure at the product and warehouse level. Average turnover or total inventory value is fine for management reports, but it doesn’t tell you what to do. So make decisions for each product separately.
- Always assess money together with product availability. Never present inventory turnover without the availability of the most important products alongside it.
- Assess buffer status over months, not days. Daily status tells you what to do today. The pattern over several months tells you whether the buffer is the right size.
- Set an end date for every temporary increase in stock. Seasonal and promotional stock should come down when the season or promotion ends.
- Report released cash and recurring savings separately. Management needs to know which part comes back once and which part recurs.
Frequently asked questions
There isn’t one. If your company usually calculates and evaluates inventory turnover, you should read it together with lost sales and overstock. A high turnover rate with significant lost sales indicates a shortage of the items that drive revenue. Conversely, a low turnover rate combined with a large overstock suggests that capital is tied up in goods that are not selling or are selling very slowly.
No. Turnover can rise because stock has been cut so far that customers can’t find what they need, or because surplus has been sold off below cost. Higher turnover is good news only when availability holds, and margin doesn’t fall as a result.
Buffer status and shortages should be reviewed daily, as immediate decisions may be required, especially when lost sales occur. Overstock and slow-moving stock suit a weekly or monthly review. Inventory turnover is usually reported monthly or quarterly, and supplier reliability is assessed over 6 or 12 months.
Partly. If your ERP holds stock balances, sales, receipts, and write-offs, you can calculate inventory turnover from it. Buffer status needs one more thing: a target stock level for each product in each warehouse, calculated from its consumption and lead time. StockM provides these reports alongside the ERP without replacing it (StockM system).
Yes, when they manage stocks of materials, components, and finished goods. The same KPIs apply, and supplier reliability is often the most important one (read more in Manufacturing).
Sources
- StockM: Inventory and working capital: is inventory a company investment?
- StockM: Where does working capital get tied up in inventory?
- StockM: Buffer zones of TOC in practice: green, yellow, red
- StockM: Buffer-based inventory management
- StockM: StockM system
- StockM sector pages: wholesale and distribution, retail and perishable goods, manufacturing
- ACCA: Ratio analysis
- NC State University, Supply Chain Resource Cooperative: Reorder point formula: Inventory management models: a tutorial
Read more articles
- Lower margin or faster turnover? A practical financial dilemma
Read more articles - What are the most important inventory management KPIs?
Inventory is “healthy” when the most important products don’t run short and no more money is invested in stock than actual consumption and replenishment time require. A single number won’t show you that. You need a set of KPIs that you read together: one that shows how much money is tied up in stock, another that shows whether customers get what they need, and a few more that show where something is going wrong with your inventory. - How does managing inventory with dynamic buffers help release cash tied up in stock?
Managing inventory with dynamic buffers frees up cash in a fairly simple way: you order only what current demand calls for. So if you have too much of a product, even one that sells well, you order only enough to last until the next replenishment. Every product at every location gets a target stock level that covers actual sales until the next delivery arrives. Anything above that level is simply not reordered. That stock sells over the following weeks, and the cash comes back with it. Any money you didn’t spend on ordering surplus stock is available straight away to order other products or to put toward other business goals.