Inventory Turnover Calculator
Calculate inventory turnover ratio to measure supply chain efficiency.
What this calculator does
This inventory turnover calculator measures how many times a year you sell and replace your stock. Enter cost of goods sold and average inventory, and it returns the turnover ratio along with days sales of inventory — the same measurement expressed as the number of days a typical item sits before selling.
Turnover is really a question about capital efficiency rather than about stock. Every dollar in inventory is a dollar unavailable for payroll, marketing, or debt reduction. The ratio tells you how hard that capital is working, and the days figure tells you how long each dollar is trapped before it comes back.
When to use it
The routine use is quarterly monitoring, because turnover degrades gradually and invisibly. Slow items accumulate one purchase order at a time, and by the time the effect appears in the cash position it represents a year of accumulated decisions.
The more decisive use is when cash is tight and you need to find money inside the business rather than borrowing it. Inventory is usually the largest pool of trapped capital available, and improving turnover from six to eight releases real cash without new financing. It is also the right calculation before a seasonal buy, to test whether last year's assumptions actually held.
Understanding the inputs
Cost of goods sold should be the annual figure at cost, matching how inventory is valued on your balance sheet. Using revenue instead inflates the ratio by your full gross margin, which is the most common error in this calculation.
Average inventory is conventionally beginning plus ending divided by two. For a seasonal business that method is unreliable — measuring at a post-season low overstates turnover considerably — so average monthly balances if your system supports it. Both figures must cover the same period, and if you use a quarterly COGS figure, annualize it or the days calculation will be wrong by a factor of four.
How is this calculated?
Inventory Turnover = COGS / Average Inventory. Days Sales of Inventory (DSI) = 365 / Turnover.
A worked example
A distributor reports $2.4 million in cost of goods sold against average inventory of $400,000. Turnover is 6 times a year and days sales of inventory is about 61 — meaning a typical item sits for two months before it sells.
Lifting turnover to 8 times would mean carrying only $300,000 of average inventory to support the same sales, releasing $100,000 of cash permanently and cutting DSI to about 46 days. At a 25 percent annual carrying cost, the reduced stock also saves roughly $25,000 a year in storage, insurance, and obsolescence — a return that compares favorably to most capital projects.
Limitations and assumptions
A single blended ratio conceals the distribution that matters. Most inventories follow a pattern where a minority of items turn rapidly and a long tail barely moves, so an acceptable aggregate can coexist with substantial dead stock. Calculate by category or SKU wherever your system allows.
The simple two-point average also distorts badly for seasonal businesses, and the ratio says nothing about stockouts — the cost of a sale you could not fulfil appears in no inventory metric. Read turnover alongside fill rate, aged stock reports, and your full cash conversion cycle rather than treating the number as a standalone verdict.
Common Questions
- What is a good inventory turnover ratio?
- It varies dramatically by sector, so treat any single figure loosely. As common rules of thumb, grocery runs 12 to 20 times a year, apparel 4 to 6, industrial distribution 4 to 8, and auto parts 3 to 5. The useful comparison is against your own sector and your own prior year.
- How does turnover relate to days sales of inventory?
- They are the same measurement expressed differently. DSI is 365 divided by turnover, so 6 turns a year means about 61 days of stock on hand. Days are usually more intuitive for operational conversations, while turnover is the format used in benchmarking and financial analysis.
- Why use COGS rather than revenue in the numerator?
- Because inventory is carried at cost, and dividing a retail-priced number by a cost-based one inflates the ratio by your entire gross margin. A business at 40 percent margin would report turnover roughly 67 percent too high. Some sources still use revenue, which is why comparisons across published benchmarks can mislead.
- Can inventory turnover be too high?
- Yes. Very high turnover often means stockouts, lost sales, and expensive expedited replenishment. If turnover is well above your sector norm, check your fill rate and backorder data before treating it as a success — the cost of a missed sale rarely appears anywhere in the inventory numbers.
- How do I calculate average inventory correctly?
- Beginning plus ending inventory divided by two is the standard approach and works for stable businesses. For anything seasonal it distorts badly — a retailer measuring at a January low will overstate turnover substantially. Averaging monthly balances gives a far more representative figure where the data exists.
- How much cash does slow inventory tie up?
- More than most owners realize, because the carrying cost extends well beyond the purchase price. Storage, insurance, shrinkage, obsolescence, and the cost of capital typically add 20 to 30 percent of inventory value annually. A $400,000 average inventory carries roughly $80,000 to $120,000 of annual cost to hold.
- Should I calculate turnover by SKU or across the business?
- By SKU or category wherever you can. A blended figure hides the pattern that actually matters: a small share of items usually turns quickly while a long tail sits for a year or more. The aggregate looks acceptable while a substantial portion of your capital is effectively dead.
- What is the cash conversion cycle and how does inventory fit?
- It is days of inventory plus days of receivables minus days of payables — the time your cash is tied up between paying a supplier and being paid by a customer. Inventory is usually the largest component, which makes turnover the most powerful lever most businesses have on working capital.
- What is the fastest way to improve turnover?
- Deal with the slow tail first. Discounting aged stock feels like accepting a loss, but that capital is already impaired and every month it sits adds carrying cost. Beyond that, tighter reorder points, shorter supplier lead times, and consignment arrangements on slow-moving lines all shift the ratio.