Transparent method
The formula
Worked example
Example inputs
How to interpret the result
A turnover number on its own can't say whether it's good: six turns a year is fast for furniture and slow for a grocery cooler, so an identical figure means opposite things depending on what's on the shelf. What the number is genuinely useful for is watching your own trend. A turnover ratio sliding down quarter over quarter means cash is getting tied up in stock that used to move faster, well before that shows up anywhere else.
Before you rely on it
What to check
Compare this period's turnover against your own prior periods and your specific category's norm, never against a generic benchmark pulled from somewhere else.
The common error
Where people go wrong with inventory turnover calculator
Chasing turnover higher without limit. Push it too far and stockouts start costing sales, so the goal is matching turnover to actual demand, not maximizing the ratio for its own sake.
Sensitivity evidence
How annual cost or sales flow changes the annual turnover
| Annual cost or sales flow | Annual turnover | Days represented |
|---|---|---|
| $960,000 | 4.80× | 76.0 days |
| $1,080,000 | 5.40× | 67.6 days |
| $1,200,000worked example | 6.00× | 60.8 days |
| $1,320,000 | 6.60× | 55.3 days |
| $1,440,000 | 7.20× | 50.7 days |
Every input, tested
Which input moves the annual turnover most
| Input | Tested from | To | Annual turnover at each end | Swing |
|---|---|---|---|---|
| Average inventory or receivable balance | $180,000 | $220,000 | 6.67× to 5.45× | 1.21× (20%) |
| Annual cost or sales flow | $1,080,000 | $1,320,000 | 5.40× to 6.60× | 1.20× (20%) |
Two variables at once
Annual turnover by annual cost or sales flow and average inventory or receivable balance
| Annual cost or sales flow \ Average inventory or receivable balance | $160,000 | $200,000 | $240,000 |
|---|---|---|---|
| $960,000 | 6.00× | 4.80× | 4.00× |
| $1,080,000 | 6.75× | 5.40× | 4.50× |
| $1,200,000 | 7.50× | 6.00× | 5.00× |
| $1,320,000 | 8.25× | 6.60× | 5.50× |
| $1,440,000 | 9.00× | 7.20× | 6.00× |
Step by step
The worked example, input by input
| Input | Value used |
|---|---|
| Annual cost or sales flow | $1,200,000 |
| Average inventory or receivable balance | $200,000 |
| Annual turnover | 6.00× |
| Days represented | 60.8 days |
Where the inputs come from
Annual cost or sales flow is the yearly cost of goods sold for inventory turnover, or credit sales for receivable turnover, since the tool serves both. Average balance is the mean of opening and closing inventory, or better, a monthly average. Use cost of goods sold for inventory, because inventory is carried at cost and using sales inflates the result. Make sure inventory excludes items you no longer intend to sell.
When the result stops applying
Seasonal businesses show misleading averages, and using only the year-end balance can distort the figure. Turnover targets differ by industry: grocers turn inventory dozens of times, while furniture stores turn it a few times. A sudden improvement may come from a stock shortage. Obsolete items lower the real turnover of the goods that matter.
What to compare it with
Connect the days held to cash with the cash conversion cycle page, and see the reorder point and economic order quantity calculators for setting stock levels. The inventory carrying cost page shows what slow turnover costs. Review slow-moving items monthly and mark them down before they age.
People also ask
Frequently asked questions
What is a good inventory turnover?
It depends on the industry. Fast-moving goods may turn 10 to 50 times a year, while durable goods turn 3 to 6 times.
Should I use sales or cost of goods sold?
Use cost of goods sold for inventory turnover, because inventory is valued at cost, and using sales would overstate the number of turns.
What does low turnover tell me?
That inventory is sitting too long, tying up cash and risking obsolescence and markdowns. It can also mean prices are too high or purchasing is over-optimistic.