How this calculator works
Inventory turnover measures how efficiently a business converts inventory into sales over a period. It tells you how many times per year you sell through and replace your average inventory — a critical metric for retailers, wholesalers, and manufacturers. High turnover generally signals efficient inventory management and strong sales; low turnover suggests overstocking, obsolete inventory, or weak demand. Inventory that sits on shelves ties up capital, occupies space, and risks obsolescence — every day it doesn't sell, it costs you money.
This calculator computes inventory turnover ratio, days inventory outstanding (how many days it takes to sell inventory on average), and provides context for interpreting results. Enter your cost of goods sold (COGS) and average inventory (or beginning and ending inventory, which the calculator averages for you). The days inventory outstanding metric is often more intuitive — it tells you in plain English how long inventory sits before selling.
Ideal turnover varies enormously by industry. Grocery stores turn inventory 12-25 times per year (perishable goods, fast sales). Car dealerships turn 4-8 times. Furniture retailers 3-6 times. Luxury goods 1-3 times. Compare against your industry benchmark — a 'low' turnover of 4x might be excellent for jewelry and terrible for groceries. The right turnover balances carrying costs against stockout costs.
The formula
Inventory Turnover = Cost of Goods Sold / Average Inventory
Average Inventory = (Beginning Inventory + Ending Inventory) / 2
Days Inventory Outstanding (DIO) = 365 / Inventory Turnover
Inventory Holding Cost = Average Inventory x Carrying Cost Rate (typically 20-30%)
Worked example
A boutique has COGS of $180,000 for the year. Beginning inventory was $40,000, ending inventory $20,000. Average inventory = $30,000. Turnover = $180,000 / $30,000 = 6x per year. Days inventory outstanding = 365 / 6 = 61 days. Inventory sits on shelves for about 2 months on average — reasonable for a clothing boutique but slow for a high-volume retailer.
Compare to a grocery store with COGS $2,000,000 and average inventory $80,000: turnover = 25x, DIO = 15 days. The grocery store replenishes inventory every two weeks; the boutique every two months. Both are appropriate for their industries.
Methodology and sources
Inventory turnover is a standard efficiency ratio defined under GAAP and IFRS. The formula uses COGS (not sales) because both numerator and denominator should be at cost — using sales inflates the ratio because it includes markup. Average inventory smooths out seasonal fluctuations; for businesses with significant seasonality, average the inventory at the end of each quarter rather than just beginning and end of year.
Days inventory outstanding (DIO) is the inverse of turnover expressed in days. Together with days sales outstanding (DSO) and days payables outstanding (DPO), it forms the cash conversion cycle — a comprehensive measure of working capital efficiency.
Sources: Managerial Accounting by Garrison, Noreen, Brewer; Retail Industry Leaders Association benchmarks; APICS supply chain methodology.
Industry benchmarks
Typical inventory turnover by industry:
- Grocery stores: 12-25x (perishable, fast turnover)
- Convenience stores: 10-20x
- Fast fashion retailers: 6-12x
- General retail (apparel): 4-8x
- Electronics retail: 4-8x
- Car dealerships: 4-8x
- Furniture retailers: 3-6x
- Hardware stores: 3-5x
- Luxury goods: 1-3x
- Manufacturing: 4-8x (varies by product)
- Pharmaceuticals: 3-5x
Compare to industry benchmarks — turnover expectations differ dramatically by product type, perishability, and price point.
Common mistakes to avoid
Mistake 1: Using sales instead of COGS. Sales include markup, inflating turnover. Always use COGS to match the cost basis of inventory.
Mistake 2: Using ending inventory instead of average. Ending inventory may be depressed (just after holiday sales) or inflated (just before peak season). Average the inventory across the period.
Mistake 3: Comparing turnover across industries. A 4x turnover is great for jewelry, terrible for groceries. Always benchmark against your specific industry.
Mistake 4: Ignoring inventory composition. High turnover overall can hide slow-moving individual products. Use ABC analysis to identify which products drive (or drag) turnover.
Mistake 5: Maximizing turnover at the expense of stockouts. Extremely high turnover may mean you're understocked and losing sales. Balance turnover against stockout costs and customer satisfaction.
When to use this calculator
Track inventory turnover monthly for businesses with significant inventory. Quarterly, compare to industry benchmarks. Annually, review by product line to identify slow movers and growth opportunities.
For purchasing decisions, turnover informs order quantities — high turnover supports larger orders (better supplier terms); low turnover suggests smaller, more frequent orders. For pricing decisions, slow turnover justifies markdowns to free up capital.
For financing, lenders view inventory turnover as a measure of inventory quality — slow turnover may indicate obsolete inventory that secures loans at a discount.
Related metrics and alternatives
Days inventory outstanding (DIO): Same metric expressed in days rather than turns.
Gross margin return on investment (GMROI): Gross profit / average inventory cost. Measures profit per dollar invested in inventory.
ABC analysis: Categorizes inventory by value contribution to focus management on high-impact items.
Inventory aging report: Shows how long each item has been in stock, identifying slow movers.
Stockout rate: Percentage of demand unfulfilled due to inventory shortage. Pairs with turnover to find optimal inventory levels.
How to interpret the results
Turnover well above industry average: Efficient inventory management, strong sales, or understocking risk. Verify stockout rates aren't high.
Turnover at industry average: Healthy — typical for your business type.
Turnover well below industry average: Overstocked, slow-moving inventory, or weak demand. Risk of obsolescence and write-downs.
Days inventory outstanding trending up: Inventory accumulating relative to sales. Either sales slowing or purchasing too aggressive. Diagnose before cash ties up further.
Days inventory outstanding trending down: Inventory efficiency improving. Verify it's from better management, not understocking.