Inventory Turnover Calculator
Calculate how many times a business sells and replaces its inventory over a period, using COGS divided by average inventory. A key gauge of operational and sales efficiency.
Last updated: May 2026
Compare with similar
About this calculator
Inventory turnover measures how many times a company sells through and replaces its average inventory during a period, revealing how efficiently it manages stock. The formula is inventory turnover = cost of goods sold (COGS) / average inventory, where average inventory is (beginning inventory + ending inventory) / 2. Using COGS rather than revenue in the numerator is important because inventory is carried at cost, so both figures are on a cost basis and the ratio is not distorted by markup. A higher turnover means inventory moves quickly — goods are selling well and little capital is tied up in unsold stock — while a low turnover suggests overstocking, weak sales, or obsolete goods. The metric directly affects cash flow and storage costs: every unit sitting in inventory ties up money and may require warehousing, insurance, and risk of spoilage or obsolescence. From turnover you can derive days inventory outstanding (365 / turnover), the average number of days an item sits before selling. Edge cases and context: the ideal turnover varies enormously by industry — grocery and fast fashion turn inventory many times a year, while jewelry, machinery, or luxury goods turn slowly by nature — so the figure is only meaningful against industry peers and the company's own trend. Extremely high turnover can also be a warning sign of insufficient stock causing lost sales (stockouts), so faster is not always better. Average inventory smooths out seasonal swings, but for highly seasonal businesses a more granular average across several periods gives a truer picture.
How to use
Example 1 — COGS of $300,000, beginning inventory $50,000, ending inventory $70,000. Enter Cost of Goods Sold = 300000, Beginning Inventory = 50000, Ending Inventory = 70000. Average inventory = (50000 + 70000) / 2 = $60,000, so turnover = 300000 / 60000 = 5 times. Verify: the company sold and replaced its stock five times in the period, equivalent to about 73 days of inventory on hand (365 / 5). Example 2 — COGS of $500,000, beginning $80,000, ending $120,000. Enter 500000, 80000, 120000. Average inventory = $100,000, turnover = 500000 / 100000 = 5 times. Verify: despite higher absolute COGS and inventory, the turnover is also 5, showing the ratio reflects efficiency relative to stock held, not absolute size.
Frequently asked questions
Why use COGS instead of revenue in the formula?
Inventory is recorded on the balance sheet at cost, not at the price it eventually sells for, so the numerator should also be on a cost basis to make a fair comparison. Cost of goods sold is the cost of the inventory that was actually sold, which matches the cost-based inventory figure in the denominator. Using revenue instead would inflate the ratio by the amount of the markup, making turnover look higher than it really is and distorting comparisons. Some older formulas do use sales, but the COGS version is the accepted, more accurate standard. Always confirm which version a reported figure uses before comparing.
What is a good inventory turnover ratio?
It depends heavily on the industry. Grocery stores, fast fashion, and perishable-goods sellers may turn inventory a dozen or more times a year because their goods sell quickly and cannot sit, while jewelers, car dealers, and heavy-equipment makers turn over far more slowly by the nature of their products. So a turnover of 5 might be excellent for a furniture store but alarming for a supermarket. The right benchmark is the average for the specific industry and the company's own historical trend. Compare like with like, and watch the direction of change over time as much as the absolute level.
Can inventory turnover be too high?
Yes. While high turnover usually signals strong sales and efficient stock management, an excessively high ratio can mean inventory levels are too low, leading to stockouts where you cannot fulfill demand and lose sales to competitors. It may also force expensive, frequent reordering and leave no buffer for supply disruptions. So the goal is an optimal turnover that balances minimizing tied-up capital against maintaining enough stock to meet demand reliably. A ratio far above the industry norm warrants checking whether you are missing sales. Faster is generally better, but only up to the point where service levels start to suffer.
How does turnover relate to days inventory outstanding?
Days inventory outstanding (DIO) is simply the turnover ratio expressed in days: DIO = 365 / inventory turnover. It tells you the average number of days an item sits in inventory before being sold. A turnover of 5 corresponds to about 73 days, while a turnover of 12 means roughly 30 days. Many managers find DIO more intuitive than the turnover ratio because it speaks in calendar terms. The two are just different views of the same efficiency, and lowering DIO (raising turnover) frees up cash. Use whichever framing communicates better to your audience.
When should I NOT rely on inventory turnover?
Avoid comparing turnover across different industries, since normal levels vary so widely that cross-industry comparisons mislead. It is also distorted for highly seasonal businesses if you use only beginning and ending inventory, which can miss large mid-period swings — averaging more frequent snapshots gives a truer figure. The ratio says nothing about profitability or margin, so high turnover on low-margin goods may still be unprofitable. It can also be skewed by inventory accounting methods (FIFO versus LIFO) that change reported COGS and inventory values. Use it alongside margin, days inventory outstanding, and stockout data, and always interpret it against industry norms and your own trend.