Inventory planning · Step 5 · Pressure-test your numbers
How fast does my stock move?
Two readings of the same thing: how many times a year you cycle your stock, and how many days the stock you hold will last. Put in your annual demand and your average inventory, set a target if you have one, and read both below.
Your result
How long your current stock lasts
73 days of supply
That works out to a turnover of 5 times a year.
At your normal rate of demand, the stock you hold on an average day covers about 73 days (10.4 weeks); you cycle through your inventory about 5 times a year. Your target is 60 days (8.6 weeks), so you are holding about 13 days above target.
Recommendation: you are holding more cover than your target, so cash and shelf space are tied up beyond what you decided this item needs. Check whether your order lots are larger than the economic order quantity, or your buffer larger than your service level requires, before trimming.
Your numbers
Inventory turnover
5× / year
Days of supply
73days
Equivalent in weeks
10.4weeks
Your stock, drawn down to scale
The navy line is your average stock running down at your normal rate of demand; where it hits the bottom is your days of supply, the point your current cover would run dry. The dashed line is the target you set: if the navy line crosses the floor to the right of it you are holding more cover than your target, to the left you are holding less.
Where these numbers come from, and how to read them
The formulas
Inventory turnover and days of supply are two readings of one ratio: the relationship between how much you sell and how much you hold:
Days of supply = 365 ⁄ turnover = (average inventory ⁄ annual demand) × 365
Both inputs are in the same units. Turnover comes out as a count of times per year; days of supply as a number of days. A high turnover is a low days of supply and the other way round; they always move in opposite directions because they are the same fraction read upside down.
Units or money
This tool works in units: annual unit demand over average units on hand. The accounting version of the same idea uses cost of goods sold over average inventory value, both measured at cost. Either is valid as long as the top and bottom of the fraction are on the same basis. The usual error is to put sales value on top and cost value on the bottom, which overstates how fast stock is really turning.
Why there is no benchmark here
A good turnover for fresh produce would be a disaster for a depot of slow-moving spares, and the reverse. The right figure depends on your lead times, your shelf life, your margins, and how much a stockout costs you, all of which are yours, not an industry average. That is why the status read on this page measures your result against a target you set yourself. Decide the cover that suits the item, enter it as your target days of supply, and read your number against that.
Where this sits in the chain
Turnover and days of supply are the scoreboard, not the lever. They show how fast stock is moving, but the figures you actually change to move them live elsewhere: your order quantity on the economic order quantity tool, and your buffer on the safety stock and reorder point tools. A low turnover with a lot of cash tied up usually traces back to ordering in lots that are too big, or carrying more buffer than your service level needs. Use this page to spot the items worth a second look, then go back to those tools to act on them.
Terms used on this page
- Inventory turnover
- How many times a year you cycle through your stock: annual demand divided by average inventory.
- Days of supply
- How many days your current average inventory would last at your normal rate of demand: the year divided by turnover.
- Average inventory
- The stock you hold on a typical day, often approximated as the average of opening and closing stock over a period.
- Target days of supply
- The cover you decide this item should hold, set from your own lead time and shelf life. The status read judges your result against this, not an outside figure.
Common questions
What is inventory turnover?
Inventory turnover is how many times a year you cycle through your stock: sell it, use it up, and replace it. It is annual demand divided by the average inventory you hold to meet that demand. A turnover of 8 means you work through your average stock eight times in a year; the same goods sit on your shelf, on average, for an eighth of a year.
What is days of supply?
Days of supply is how many days your current average inventory would last at your normal rate of demand. It is the year divided by your turnover, or equivalently average inventory divided by annual demand, times 365. A days-of-supply figure of 45 means the stock you hold on an average day covers about 45 days of selling or usage before it runs out.
How are turnover and days of supply calculated?
Turnover is annual demand divided by average inventory, both in the same units. Days of supply is 365 divided by that turnover, which is the same as average inventory divided by annual demand, multiplied by 365. The two are simply two ways of reading the same relationship: a high turnover is a low days of supply, and the other way round. This tool uses units for both demand and inventory; you can run the same arithmetic on cost figures using cost of goods sold and average inventory value.
Should inventory turnover use units or cost of goods sold?
Either works, as long as the top and bottom of the fraction are measured the same way. In units, turnover is annual unit demand divided by average units on hand, which is clean for a single item. In money, the standard accounting version is cost of goods sold divided by average inventory value, both at cost. Mixing the two (sales value on top, cost value on the bottom) inflates turnover and is the most common mistake. This calculator works in units; convert to a cost basis yourself if that is what your finance team reports.
What is a good inventory turnover or days of supply?
There is no universal good number; it depends entirely on your sector, your margins, and your supply lead times. Fresh food has to turn over in days; heavy spares may sit for months by design. A grocery turnover would be alarming for an aircraft-parts depot and the other way round. That is why this tool judges your result against a target you set yourself, not against an outside benchmark. Decide the days of supply that suits your lead times and shelf life, and read your number against that.
How does turnover relate to my other inventory decisions?
Turnover and days of supply are the scoreboard, not the lever. They tell you how fast stock is moving, but the figures you change to move them are your order quantity, your safety stock, and your reorder point. A low turnover with a lot of cash tied up usually traces back to ordering in lots that are too big or holding more buffer than the service level needs. Use this page to spot the items worth a closer look, then go back to the economic order quantity and safety-stock tools to act on them.
Where to go next
This is your starting number, not your final answer. Validate it against your own demand, lead times, and shelf life before you act on it.