Inventory Turnover Calculator — Ratio & Days on Hand
Inventory turnover = COGS ÷ average inventory. See how many times stock sold and replaced, plus days inventory outstanding. Free, in-browser, no sign-up.
About Inventory Turnover Calculator
An inventory turnover calculator is a tool that divides the cost of goods sold (COGS) by average inventory — the mean of your beginning and ending inventory valued at cost — to show how many times you sold and replaced your stock over a period. From that ratio it also derives days inventory outstanding, which is 365 divided by the turnover, telling you roughly how long stock sits before selling. A high turnover suggests lean, fast-moving inventory; a low one can point to overstocking or slow sales. The math runs in your browser, and the result is an operational indicator, not financial advice — compare it within your own industry, because healthy norms vary widely.
Use cases
- Gauge how efficiently stock is moving. Turnover answers a practical question: how many times did you sell through and restock your inventory in a period? A higher number means capital is not sitting idle on shelves. Entering your COGS and beginning and ending inventory gives the ratio at a glance, so you can tell whether a season, product line, or store is converting stock into sales at a healthy pace.
- Spot overstocking that ties up cash. Slow-moving inventory quietly locks up cash and risks obsolescence, spoilage, or markdowns. A low turnover ratio, or a high days-inventory-outstanding figure, is an early signal that you are holding more than you sell. Watching the ratio each period helps you catch a build-up before it becomes dead stock, so you can adjust purchasing, run promotions, or discontinue lines that are not earning their shelf space.
- Benchmark against your industry. A turnover of 4 is excellent for heavy machinery and alarming for fresh produce. Because healthy norms differ enormously by sector, the ratio is most meaningful compared with businesses like yours. Use the tool to compute your figure, then line it up against published industry averages or your own past periods — a number in isolation says far less than a trend or a peer comparison.
- Track the trend across periods. One ratio is a snapshot; several in a row tell a story. Calculating turnover each month or quarter reveals whether stock is moving faster or slower over time, which is often more useful than the absolute value. A steadily rising ratio can mean tighter buying or stronger demand; a falling one warrants a look at purchasing, pricing, or shifting customer interest.
- Support purchasing and cash-flow decisions. Knowing how quickly inventory turns feeds directly into how much to reorder and when. Pairing turnover with days inventory outstanding tells you roughly how long a purchase sits before it sells, which helps you time orders, negotiate terms, and free up working capital. The calculator gives both figures instantly so the numbers can inform your next buying cycle.
How it works
- Enter cost of goods sold. Provide COGS for the period you are analysing — the direct cost of the inventory you actually sold, not its retail value.
- Enter beginning inventory. Add the inventory value at cost at the start of the period.
- Enter ending inventory. Add the inventory value at cost at the end of the same period; the tool averages the two.
- Read the turnover ratio. The calculator divides COGS by the average inventory to show how many times stock was sold and replaced.
- Check days inventory outstanding. It also divides 365 by the turnover to estimate how many days, on average, stock sat before selling.
Examples
Input: COGS $600,000; beginning $90,000; ending $110,000
Output: Turnover 6.0×; days inventory ≈ 61
Average inventory is $100,000, so $600,000 ÷ $100,000 = 6, and 365 ÷ 6 ≈ 61 days.
Input: COGS $1,200,000; beginning $180,000; ending $220,000
Output: Turnover 6.0×; days inventory ≈ 61
Different scale, same efficiency: average inventory of $200,000 turns six times a year.
Input: COGS $300,000; beginning $140,000; ending $160,000
Output: Turnover 2.0×; days inventory ≈ 183
A ratio of 2 means stock sits about half a year — worth checking whether that is normal for the industry.
Frequently asked questions
What is inventory turnover?
It is the number of times a business sells and replaces its inventory in a period, calculated as cost of goods sold divided by average inventory. It measures how efficiently stock is converted into sales.
Why use average inventory instead of ending inventory?
Inventory levels fluctuate, so a single point can be misleading. Averaging the beginning and ending values smooths out those swings and gives a more representative denominator for the period.
Should I use COGS or sales revenue?
Use cost of goods sold. Inventory is carried at cost, so dividing by COGS keeps both sides of the ratio on a cost basis. Using retail sales inflates turnover because it mixes cost with margin.
What is days inventory outstanding?
It is 365 divided by the turnover ratio, estimating the average number of days an item sits in stock before it sells. A turnover of 5 means roughly 73 days on hand.
Is a high turnover always good?
Not necessarily. High turnover usually means lean, fast-selling stock, but a very high ratio can signal understocking and lost sales from stockouts. Balance is the goal, judged against your industry.
What is a good inventory turnover ratio?
It depends entirely on the industry. Grocery and fashion turn stock many times a year; furniture, jewellery, or industrial goods turn far less often. Compare your figure with sector benchmarks and your own history, not a universal target.
Is my data uploaded anywhere?
No. The calculation runs entirely in your browser and nothing you enter is transmitted or saved.
Pro tips
- Value both inventory figures at cost, matching the COGS basis, for a correct ratio.
- Use the same period length for COGS and the inventory figures (a full month, quarter, or year).
- Compare your turnover with industry benchmarks, not a one-size-fits-all target.
- Watch the trend over several periods — direction matters more than a single number.
- Read a very high ratio with care: it can mean stockouts, not just efficiency.
Reviewed by Ahsan Mahmood · Last updated 2026-07-08 · Part of ZTools.
For the full,
formatted version of this page, please enable JavaScript and reload
https://ztools.zaions.com/inventory-turnover-calculator.