Inventory Turnover: How Fast Your Stock Becomes Cash
Last updated: February 10, 2026
The warehouse was 80% full with last season's styles. Meanwhile, the bestselling items showed "out of stock" on the website every other week. The store had an inventory problem, but no one could quantify it until they calculated turnover by category. The slow movers turned 1.2 times per year. The stockouts happened on items turning 18 times annually that should have had triple the safety stock.
Inventory turnover measures how many times you sell and replace stock over a period. Days on hand shows how long each item sits before selling. This calculator converts your cost of goods sold and inventory levels into these metrics so you can spot overstocks, prevent stockouts, and free up cash trapped in slow-moving goods.
Turnover and Days on Hand Explained
These two metrics are inversely related. Higher turnover means fewer days on hand. Together they tell the complete story of inventory efficiency.
Core Formulas:
Average Inventory = (Beginning + Ending Inventory) / 2
Inventory Turnover = Cost of Goods Sold / Average Inventory
Days on Hand = Period Days / Inventory Turnover
| Industry | Typical Turnover | Days on Hand |
|---|---|---|
| Grocery / Supermarket | 12-20x | 18-30 days |
| Fast Fashion | 6-12x | 30-60 days |
| General Retail | 4-6x | 60-90 days |
| Furniture / Appliances | 2-4x | 90-180 days |
| Heavy Equipment | 1-2x | 180-365 days |
COGS vs Sales as Numerator
Use Cost of Goods Sold for accurate turnover since inventory is valued at cost, not selling price. Using Net Sales inflates turnover because sales include profit margin. Only use sales-based turnover if COGS is unavailable, and never compare COGS-based ratios to sales-based ratios.
Seasonality Adjustments
Simple average inventory can mislead seasonal businesses. A Halloween costume retailer with $50,000 inventory in February and $500,000 in September has an "average" of $275,000 that represents neither reality.
Monthly Average Method
Sum ending inventory for each of the 12 months, then divide by 12. This captures seasonal peaks and troughs. More accurate than beginning-plus-ending divided by two, especially for businesses with holiday spikes or summer slowdowns.
Quarterly Turnover Analysis
Calculate turnover separately for each quarter using that quarter's COGS and average inventory. Compare Q4 turnover to Q1 turnover to see seasonal patterns. A holiday retailer might show 15x turnover in Q4 and 2x in Q1.
Year-Over-Year Comparison
Compare same periods across years rather than sequential quarters. Q2 2026 turnover compared to Q2 2025 reveals whether efficiency improved. Sequential Q2-to-Q3 comparison just shows seasonal patterns you already expect.
Build-Up and Drawdown
Seasonal businesses deliberately increase inventory before peak periods and draw it down after. Low turnover during build-up months is intentional, not inefficient. Evaluate full-year turnover to get the complete picture, and judge quarterly turnover in the context of seasonal planning.
Signals: Overstock vs Stockouts
Inventory turnover signals which problem you face. Neither extreme is healthy.
Low Turnover Warning Signs
- Days on hand exceeding industry average by 50%+
- Aging inventory requiring markdowns
- Storage costs rising as percentage of COGS
- Cash tied up in unsold goods
- Risk of obsolescence or spoilage
High Turnover Warning Signs
- Frequent stockouts on popular items
- Lost sales due to unavailable inventory
- Rush orders with premium shipping costs
- Small order quantities missing bulk discounts
- Customer frustration and defection
Category-Level Analysis
Aggregate turnover hides problems. A store with 6x overall turnover might have staples turning 20x (causing stockouts) and specialty items turning 0.5x (dead inventory). Calculate turnover by category to find the imbalances that aggregate numbers mask.
ABC Classification
A items (top 20% of SKUs, 80% of revenue) deserve different turnover targets than C items (bottom 50% of SKUs, 5% of revenue). Accept lower turnover on long-tail items while optimizing A items for maximum efficiency and availability.
Reorder Point Calculation
Use days on hand to set reorder points. If an item has 30 days on hand and lead time is 14 days, reorder when stock hits 14 days worth plus safety stock. Multiply daily sales rate by lead time plus buffer to get reorder quantity.
Example Store Calculations
Example 1: Sporting Goods Retailer Annual Analysis
COGS (annual): $2,400,000
Beginning Inventory: $380,000
Ending Inventory: $420,000
Period: 365 days
Average Inventory: ($380,000 + $420,000) / 2 = $400,000
Turnover: $2,400,000 / $400,000 = 6.0x
Days on Hand: 365 / 6.0 = 60.8 days
Result: Stock sits about 2 months before selling. Within normal range for general retail.
Example 2: Coffee Roaster Quarterly Comparison
Q1 COGS: $180,000 | Q1 Avg Inventory: $15,000
Q4 COGS: $240,000 | Q4 Avg Inventory: $30,000
Q1 Turnover: $180,000 / $15,000 = 12x quarterly (48x annualized)
Q1 Days on Hand: 90 / 12 = 7.5 days
Q4 Turnover: $240,000 / $30,000 = 8x quarterly (32x annualized)
Q4 Days on Hand: 90 / 8 = 11.25 days
Result: Perishable product turns fast year-round. Q4 buildup for holiday gift sales shows lower turnover but is planned.
Sources
For Educational Purposes Only - Not Financial Advice
This calculator provides estimates for informational and educational purposes only. It does not constitute financial, tax, investment, or legal advice. Results are based on the information you provide and current tax laws, which may change. Always consult with a qualified CPA, tax professional, or financial advisor for advice specific to your personal situation. Tax rates and limits shown should be verified with official IRS.gov sources.