Inventory Turnover Calculator
Inventory Turnover Calculator
What Is Inventory Turnover?
Inventory turnover (also called stock turn or inventory turns) is the number of times a business sells through and replaces its entire stock of goods during a period — typically one year. It is one of the most important efficiency metrics in inventory management because it connects directly to cash flow, holding costs, and demand health.
A higher ratio means you are converting inventory into sales quickly, keeping carrying costs low and cash flowing. A lower ratio means stock is sitting — tying up capital in warehousing, insurance, and obsolescence risk. The ideal ratio depends entirely on your industry, which is why the benchmark table below matters more than any single number.
How to Use This Inventory Turnover Calculator
Enter your Cost of Goods Sold (COGS) for the period and your Average Inventory for the same period. If you do not already know your average inventory, use the toggle to switch to the beginning/ending mode — the calculator will compute it for you as (Beginning + Ending) ÷ 2.
Always use COGS, not revenue. Revenue includes markup and will inflate the ratio, making your inventory appear to turn faster than it does. Only use revenue if COGS is unavailable, and note your result will not be comparable to standard benchmarks.
The result shows your Inventory Turnover ratio (how many times per year) and your Days Inventory Outstanding (DIO) — the same information expressed in days. DIO is easier to communicate to operations teams and non-financial stakeholders.
The Inventory Turnover Formula
The standard formula is:
Where Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2. Using average inventory rather than a single point-in-time value smooths out seasonal fluctuations and gives a more accurate view of how much stock you typically held.
To convert to days: DIO = 365 ÷ Inventory Turnover. For a full breakdown of formula variants and a step-by-step derivation, see the Inventory Turnover Formula guide.
Inventory Turnover Calculation Example
A mid-size retailer reports COGS of $500,000 for the year. Their inventory was $100,000 at the start of the year and $66,666 at the end.
What Is a Good Inventory Turnover Ratio? Industry Benchmarks
There is no universally "good" inventory turnover ratio — the right number depends on your industry, product type, and business model. Industries with low margins and fast-moving goods (grocery, FMCG) turn inventory very frequently. Industries with high margins and slow-moving goods (furniture, luxury) turn much less often — and that is expected.
Compare your result to your sector, not to a general number:
| Industry | Typical Range | DIO Range | Why |
|---|---|---|---|
| Grocery / FMCG | 12–14× | 26–30 days | Perishable goods, razor-thin margins, high volume |
| Electronics / Technology | 5–10× | 37–73 days | Fast product cycles, obsolescence risk drives lean stock |
| Apparel / Fashion | 4–6× | 61–91 days | Seasonal collections; markdowns clear slow movers |
| General Retail | 4–8× | 46–91 days | Wide product mix; varies by category |
| Manufacturing | 4–7× | 52–91 days | Raw materials + WIP + finished goods all included |
| Automotive Parts | 3–5× | 73–122 days | Wide SKU range; slow-movers must be stocked for service |
| Pharmaceuticals | 3–4× | 91–122 days | Regulatory constraints, safety stock requirements |
| Furniture / Home Goods | 2–4× | 91–183 days | High-margin, large items, longer selling cycle |
Key insight: high-margin sectors typically turn inventory slowly because they can afford the carrying cost. Low-margin sectors must turn fast or profitability collapses. A furniture store with a 3× ratio is healthy; a grocery store with a 3× ratio has a serious problem.
How to Interpret Your Result
- Strong sales relative to stock held
- Efficient inventory management
- Lower holding and storage costs
- Cash converting quickly from stock to revenue
- Excess stock or slow-moving SKUs
- Weak demand or pricing issues
- Higher holding, storage, and obsolescence costs
- Capital tied up in unsold goods
Inventory Turnover Assumptions and Limitations
Your COGS and average inventory figures must cover the same time period — annual COGS with annual average inventory, or quarterly COGS with quarterly average inventory. Mixing periods (e.g., annual COGS with a single month's inventory) produces a meaningless result.
Using only beginning and ending inventory to calculate the average can miss significant mid-year fluctuations. For highly seasonal businesses, use a monthly average (sum of 12 month-end balances ÷ 12) for a more accurate picture of average stock held.
Inventory turnover ratios should only be compared between companies in the same industry. Comparing a grocery retailer to a furniture manufacturer produces no useful insight — their turnover will differ by 4–5× for structural reasons unrelated to performance.
A portfolio-level turnover ratio hides product-level performance. A single ratio of 6× could mask a handful of fast-movers at 20× and a long tail of slow-movers at 1–2×. Analyse turnover by category or SKU to find and act on dead stock rather than relying on the overall average.
Frequently Asked Questions
What is the inventory turnover formula?
Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory. Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2. The result tells you how many times you sold and replaced your entire stock during the period.
What is a good inventory turnover ratio?
There is no universal good ratio — it varies significantly by industry. Grocery and FMCG businesses typically see 12–14×, apparel 4–6×, electronics 5–10×, manufacturing 4–7×, and furniture 2–4×. Compare your result to your industry average rather than a single benchmark number. A ratio of 4 may be excellent for a furniture retailer but poor for a grocery chain.
What is Days Inventory Outstanding (DIO)?
DIO = 365 ÷ Inventory Turnover. It converts your turnover ratio into days — the average number of days inventory sits before being sold. A turnover of 6× equals a DIO of approximately 61 days. DIO is sometimes called Days Sales of Inventory (DSI) or Days Inventory on Hand — they are the same metric expressed with slightly different names.
Should I use COGS or revenue in the formula?
Always use COGS — it is the standard and most accurate input. Using revenue inflates the ratio because it includes markup, making inventory appear to turn faster than it actually does. Using revenue also makes your results incomparable to published industry benchmarks, which are almost universally COGS-based. Only use revenue as a fallback if COGS is genuinely unavailable.
What does a low inventory turnover ratio mean?
A low ratio usually signals overstocking, slow sales, weak demand, or pricing issues. Inventory sitting longer than necessary increases holding costs (warehousing, insurance, spoilage) and ties up working capital that could be deployed elsewhere. However, always compare to your industry benchmark first — some sectors structurally have low turnover (luxury goods, pharmaceuticals) for reasons unrelated to poor performance.