Simple Inventory Turnover & Days on Hand Calculator
Estimate inventory turnover and approximate days of inventory on hand using cost of goods sold or net sales, beginning and ending inventory, and a chosen period length. Educational use only, not accounting or financial advice.
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
- SBA: Managing Business Finances and Inventory
- FASB: Inventory Valuation Standards (ASC 330)
- SEC: Financial Statement Analysis Guidance
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 rules, rates, and assumptions, which may change. Always consult a qualified professional for advice specific to your situation, and verify rates or limits with official IRS.gov and related public-source materials.
Common Questions
What inventory turnover is considered healthy?
It depends entirely on industry. Grocery stores target 12 to 20 times per year because perishables must move quickly. Furniture retailers accept 2 to 4 times annually because customers expect selection. Compare your turnover to industry benchmarks and your own historical performance, not to businesses in different sectors.
Why does my turnover look different using sales versus COGS?
Net sales includes your profit margin, so sales-based turnover is always higher than COGS-based turnover. If you sell a $100 item that cost you $60, sales-based turnover credits you $100 while COGS-based credits only $60. Use COGS for accurate analysis since inventory is valued at cost. Only use sales if COGS data is unavailable.
How do I handle seasonality when calculating annual turnover?
Simple beginning-plus-ending average can mislead seasonal businesses. Instead, sum monthly ending inventory values and divide by 12. Or calculate turnover quarterly and compare same quarters year-over-year. A holiday retailer's Q4 turnover will always exceed Q1, but Q4 2026 versus Q4 2025 shows real improvement or decline.
Can inventory turnover be too high?
Yes. Extremely high turnover often signals chronic understocking. You might be losing sales to stockouts, paying premium prices for rush orders, missing bulk discounts by ordering too frequently, or frustrating customers who cannot find what they need. Balance efficiency with service levels and availability.
How do I convert quarterly turnover to annual?
Multiply quarterly turnover by 4. If your Q3 turnover was 1.5 times, annualized turnover is approximately 6 times. However, if your business is seasonal, this annualization will be inaccurate. Better to calculate full-year turnover using annual COGS and true average inventory across all twelve months.
What is the relationship between turnover and days on hand?
They are mathematical inverses. Days on hand equals period days divided by turnover. Turnover of 6 times per year means 365 divided by 6 equals about 61 days on hand. As turnover increases, days on hand decreases proportionally. Both metrics convey the same information in different units.
Should I calculate turnover at the SKU level or aggregate?
Both. Aggregate turnover shows overall efficiency but hides SKU-level problems. A store with 6x overall turnover might have bestsellers turning 20x (risking stockouts) and slow movers at 0.5x (dead inventory). Calculate by category or individual SKU to identify what needs restocking versus markdown.
Was this calculator helpful?
Your rating helps us improve every EverydayBudd tool.
Need More Business & Startup Tools?
Explore our other calculators for pricing, cash flow, and more