The inventory turnover ratio shows how many times a business sells through and replaces its stock in a period. You calculate it by dividing cost of goods sold by average inventory. A higher figure means stock moves faster and less cash sits on shelves, while a lower one points to slow or excess stock.
What is the inventory turnover formula?
Inventory turnover equals cost of goods sold divided by average inventory, and days of inventory equals the days in the period divided by turnover. Both use the same definitions as the calculator.
Inventory turnover = cost of goods sold / average inventory
Average inventory = (beginning inventory + ending inventory) / 2
Days of inventory = days in period / inventory turnover
- Cost of goods sold (COGS): what the goods you sold cost the business, not what customers paid.
- Beginning and ending inventory: stock valued at cost at the start and end of the period.
- Days in period: 365 for a year, 90 for a quarter.
To skip the arithmetic, enter the figures in the inventory turnover calculator and read the ratio and days on hand directly.
Why does the ratio use cost of goods sold rather than sales?
Because inventory is carried at cost, the numerator should be at cost too. Sales revenue includes your margin, so using it inflates the ratio and makes stock look faster than it is.
Mixing the two is one of the most common errors. If a finance report shows revenue and gross profit but no COGS line, subtract gross profit from revenue to recover it. Keep the same valuation method (FIFO, average cost and so on) from period to period, otherwise the ratio moves for accounting reasons rather than operational ones.
Worked example
This is an illustration with round numbers. A parts distributor has annual COGS of $800,000, opened the year with $90,000 of inventory and closed it with $110,000.
- Average inventory = ($90,000 + $110,000) / 2 = $100,000.
- Inventory turnover = $800,000 / $100,000 = 8.0 times per year.
- Days of inventory = 365 / 8.0 = about 46 days.
On average, the distributor sells and replaces its stock roughly every six and a half weeks. Whether that is good depends on the business, which the next sections cover.
How do you read the result?
There is no universal good number. Turnover is meaningful only against your own history and against businesses that sell similar goods, because grocery, spare parts and fashion behave very differently.
| Result | Possible meaning | What to check |
|---|---|---|
| Rising turnover | Faster sales, leaner buying, or shrinking stock | Fill rate and stockouts, to confirm you are not losing sales |
| Falling turnover | Overbuying, slowing demand, or obsolete items | Aged stock report, recent forecast bias |
| Very high turnover | Efficient flow, or chronic shortages | Lost sales, expedited freight, backorders |
| Very low turnover | Cash tied up in slow stock | Items with no sales in many months |
Treat the ratio as a prompt for questions, not a verdict. A drop from 8 to 6 is only a problem if it was not intended, for instance because stock was bought ahead of a price rise or a supply risk.
What are the common mistakes?
Most bad turnover figures come from the inputs, not the division. Check these before you trust the number.
- Using revenue instead of cost of goods sold.
- Using only two end-points for a seasonal business. A company that stocks up before a peak and runs down afterwards can look very different depending on the two dates. Averaging twelve month-end balances is more representative.
- Mixing time periods, such as a quarter of COGS with a year-end inventory figure, or forgetting to change the days in the period.
- Including inventory that is not really available, such as goods in transit that are not yet owned, or leaving out consignment stock that is held.
- Reading a single company-wide average. One fast category can hide a pile of dead stock in another, so calculate by product class or location where you can.
When does the metric mislead, and what else should you look at?
Turnover is a blunt, backward-looking average. It does not say which items are slow, whether service levels are healthy, or whether the stock held is the right stock.
Pair it with fill rate or on-time-in-full, with an ageing report, and with the cost of holding stock. Turnover also ignores timing within the period, so a business with one huge sales month and eleven quiet ones can post a respectable annual ratio while holding too much for most of the year. For the financial side, the carrying cost calculator shows what the inventory costs to hold, and the inventory and warehousing guides cover related methods.
How can you improve turnover?
Improving turnover means holding less stock for the same sales, or selling more from the same stock. The first levers are usually forecast accuracy, reorder rules, supplier lead times and assortment size.
Cutting the tail of slow movers often beats squeezing the fast ones. Shorter lead times allow smaller buffers, and better reorder logic stops overbuying. Do not chase the ratio blindly: pushing turnover up by running lean on items customers expect to find in stock trades inventory cost for lost sales.
Analytics and machine learning can help in a narrow way, mainly by improving demand forecasts and flagging items whose sales have stalled. They depend on clean item history and do not fix a poor stocking policy by themselves.
Common questions
What is a good inventory turnover ratio?
There is no single good ratio. It depends on the product and industry: perishable goods turn many times a year, while capital equipment turns slowly. Compare your figure with your own past results and with similar businesses, and judge it alongside service levels.
Is a high inventory turnover always better?
No. A high ratio can mean efficient flow, but it can also mean the business is running out of stock and losing sales. Check fill rate, backorders and expedited shipments before treating a high figure as good news.
How do you convert turnover to days of inventory?
Divide the number of days in the period by the turnover ratio. With turnover of 8 over a 365-day year, days of inventory is about 46. The result estimates how long stock sits before it is sold.
Should I use average inventory or ending inventory?
Average inventory is the better choice because COGS accumulates over the whole period while the ending balance is one snapshot. For seasonal businesses, an average of monthly balances is more accurate than the simple two-point average.