Free to Use

Inventory Turnover Calculator

How many times do you sell through your inventory each year? Calculate your inventory turnover ratio, days in inventory, and compare against industry benchmarks.

Real-World Inventory Turnover Examples

๐Ÿช Retail Clothing Store

A boutique clothing store has COGS of $240,000 per year, with beginning inventory of $60,000 and ending inventory of $70,000.

Average Inventory: ($60,000 + $70,000) รท 2 = $65,000

Turnover Ratio: 3.69x

Days in Inventory: 365 รท 3.69 โ‰ˆ 99 days

This is typical for clothing retailers. A turnover of 3โ€“4x means the store holds inventory for about 3โ€“4 months before selling through.

๐Ÿฅฌ Grocery Supermarket

A regional grocery chain has COGS of $5,000,000, beginning inventory of $350,000, and ending inventory of $420,000.

Average Inventory: ($350,000 + $420,000) รท 2 = $385,000

Turnover Ratio: 12.99x

Days in Inventory: 365 รท 12.99 โ‰ˆ 28 days

Grocery stores turn over inventory rapidly โ€” about every 4 weeks โ€” because perishable goods must sell quickly. A ratio of 10โ€“15x is standard for this industry.

๐Ÿš— Auto Dealership

A car dealership has COGS of $3,200,000, beginning inventory of $520,000, and ending inventory of $580,000.

Average Inventory: ($520,000 + $580,000) รท 2 = $550,000

Turnover Ratio: 5.82x

Days in Inventory: 365 รท 5.82 โ‰ˆ 63 days

Auto dealerships typically turn inventory 5โ€“6 times per year, meaning vehicles sit on the lot for about 2 months on average before being sold.

Understanding Inventory Turnover

Inventory turnover measures how efficiently a business sells and replaces its stock of goods over a period. A higher ratio indicates strong sales and effective inventory management, while a lower ratio may suggest overstocking or weak demand.

The Inventory Turnover Formula

Inventory Turnover = COGS รท Average Inventory
COGS = Cost of Goods Sold (annual)
Average Inventory = (Beginning Inventory + Ending Inventory) รท 2
Days Inventory Outstanding = 365 รท Turnover Ratio

How to Calculate Step by Step

1
Calculate Average Inventory: Add beginning and ending inventory, then divide by 2
2
Divide COGS by Average Inventory: This gives your inventory turnover ratio
3
Calculate Days in Inventory: Divide 365 by the turnover ratio to see how many days you hold inventory
4
Compare to Benchmarks: Evaluate your ratio against industry averages to assess performance

Key Terms to Know

๐Ÿ“ฆ COGS

The direct costs of producing goods sold, including materials and labor. Does not include overhead, marketing, or distribution costs.

๐Ÿ“Š Average Inventory

The midpoint value of inventory over a period, calculated as (Beginning + Ending) รท 2. Smooths out seasonal fluctuations.

๐Ÿ“… Days in Inventory

Also called Days Inventory Outstanding (DIO). Shows how many days on average it takes to sell through your inventory.

๐Ÿ“ˆ Turnover Ratio

How many times per year you completely sell and replace your inventory. Higher is generally better, but varies by industry.

๐Ÿ“Š
Turnover Ratio
Calculate exactly how many times per year you sell through your entire inventory, with precise COGS and average inventory inputs.
๐Ÿ“…
Days in Inventory
See how many days on average your inventory sits before being sold. Lower DIO means faster stock turnover and better cash flow.
๐Ÿญ
Industry Benchmarks
Compare your turnover ratio against industry averages โ€” from grocery stores (10โ€“15x) to auto dealerships (5โ€“6x) to clothing retailers (3โ€“4x).
๐Ÿ”„
COGS from Sales
Don't have COGS directly? Use the sales-based mode to estimate COGS from your total revenue and cost percentage.

Inventory Turnover Benchmarks by Industry

Inventory turnover ratios vary significantly across industries. What qualifies as a "good" ratio depends entirely on your business sector, product type, and business model. Below is a benchmark table showing average inventory turnover ratios for common retail and wholesale industries.

Industry Avg Turnover Ratio Avg Days in Inventory Description
Grocery & Supermarkets 10โ€“15x 24โ€“37 days Perishable goods require rapid turnover; high volume, low margin
Auto Dealerships 5โ€“6x 61โ€“73 days High-value items with moderate turnover; vehicles sit 2 months on average
Clothing & Apparel 3โ€“4x 91โ€“122 days Seasonal fashion cycles; slower turnover due to trend-driven demand
Electronics & Appliances 6โ€“8x 46โ€“61 days Fast-paced product cycles; quickly obsolete inventory
Furniture & Home Goods 2โ€“4x 91โ€“183 days Bulky items with longer shelf life; lower turnover expected
Pharmaceuticals 4โ€“6x 61โ€“91 days Regulated with expiry dates; moderate turnover with strict controls
Hardware & Building Materials 3โ€“5x 73โ€“122 days Seasonal demand; bulky items with slower movement
Jewelry & Luxury Goods 1โ€“2x 183โ€“365 days High-value, slow-moving items; low turnover but high margins

Understanding where your business falls relative to these benchmarks helps identify potential issues. A turnover ratio significantly below the industry average may indicate excess inventory, poor demand forecasting, or pricing problems. Conversely, a ratio far above average could mean you're understocked and missing sales opportunities.

How to Improve Your Inventory Turnover

Improving your inventory turnover ratio directly impacts cash flow and profitability. When inventory sits on shelves or in warehouses, it ties up capital that could be used for growth, marketing, or new product development. Here are proven strategies to increase turnover:

๐Ÿ“ฆ Demand Forecasting

Use historical sales data, seasonal trends, and market analysis to predict demand more accurately. Better forecasting means ordering the right quantities at the right time, reducing excess stock that slows turnover.

๐Ÿท๏ธ Dynamic Pricing

Implement markdowns and promotions for slow-moving items before they become obsolete. Time-limited discounts, bundle deals, and clearance sales can clear aged inventory and improve your turnover ratio.

โšก Just-in-Time (JIT)

Adopt JIT inventory management where stock arrives exactly when needed for production or sale. This minimizes holding costs and keeps inventory levels lean, though it requires reliable suppliers.

๐Ÿ”„ ABC Analysis

Classify inventory into A (high-value, low-turnover), B (moderate), and C (low-value, high-turnover) categories. Focus management effort on A items while optimizing reorder points for C items.

Regularly reviewing your inventory turnover ratio โ€” at least quarterly โ€” helps you catch problems early. If you notice a declining trend, investigate whether it's due to changing market conditions, seasonal effects, or operational issues. Remember that the optimal turnover ratio balances minimizing holding costs against avoiding stockouts that lose sales.

LIFO vs FIFO: Impact on Inventory Turnover

The cost flow assumption you use โ€” LIFO (Last-In, First-Out) or FIFO (First-In, First-Out) โ€” can significantly affect your COGS calculation and therefore your inventory turnover ratio. Understanding this impact is crucial for accurate analysis and cross-period comparisons.

FIFO (First-In, First-Out): Assumes the oldest inventory items are sold first. During periods of rising prices, FIFO results in lower COGS (because older, cheaper inventory is expensed first) and higher ending inventory values. This lowers the inventory turnover ratio because COGS is understated relative to current costs.

LIFO (Last-In, First-Out): Assumes the newest inventory items are sold first. During inflation, LIFO produces higher COGS (newer, more expensive inventory is expensed) and lower ending inventory values. This raises the inventory turnover ratio compared to FIFO under the same economic conditions.

FIFO Turnover < LIFO Turnover (during inflation)
Higher COGS under LIFO increases the turnover ratio, while FIFO's lower COGS reduces it

For accurate benchmarking, always use the same cost flow assumption consistently and note which method you're using when comparing to industry averages. Most external financial reports use FIFO or weighted average cost, while LIFO is primarily used for tax purposes in jurisdictions where it's permitted.

Frequently Asked Questions

What is a good inventory turnover ratio?
A "good" inventory turnover ratio varies by industry. Grocery stores typically aim for 10โ€“15x because they deal with perishable goods. Clothing retailers average 3โ€“4x, while auto dealerships target 5โ€“6x. In general, a higher ratio indicates efficient inventory management, but an extremely high ratio could also mean you're understocked and missing sales opportunities. Compare your ratio to industry benchmarks rather than an absolute number.
How do I calculate inventory turnover if I only have sales revenue?
If you don't have direct COGS figures, you can estimate it by multiplying your total sales revenue by your cost percentage. For example, if your gross margin is 35%, then COGS is 65% of sales. Our calculator includes a "COGS from Sales" mode that lets you input sales revenue and your COGS percentage to estimate the turnover ratio. However, for the most accurate results, use actual COGS from your financial statements.
What is Days Inventory Outstanding (DIO)?
Days Inventory Outstanding (DIO), also called days in inventory, measures the average number of days it takes to sell your entire inventory. It's calculated as 365 divided by the inventory turnover ratio. A DIO of 30 means you sell through your inventory roughly once per month, while a DIO of 90 means inventory sits for about three months. Lower DIO is generally better as it means faster conversion of inventory to cash.
Can inventory turnover be too high?
Yes, an extremely high inventory turnover ratio can indicate problems. If you're turning over inventory too quickly, you may be frequently running out of stock, which leads to lost sales, dissatisfied customers, and emergency restocking costs. This is particularly common in retail businesses that underestimate demand for popular items. The ideal turnover ratio balances minimizing carrying costs with maintaining adequate stock levels to meet customer demand consistently.
How does seasonality affect inventory turnover?
Seasonality can significantly distort inventory turnover ratios if measured over short periods. Retailers often build inventory ahead of peak seasons (holidays, back-to-school, etc.) and then sell through it rapidly. This means a quarterly turnover calculation might show very low turnover during the buildup phase and very high turnover during the sales period. For the most accurate picture, calculate turnover over a full 12-month period to smooth out seasonal fluctuations.
What is the difference between inventory turnover and asset turnover?
Inventory turnover specifically measures how efficiently a company sells its inventory (COGS รท Average Inventory). Asset turnover is a broader metric that measures how efficiently a company uses all its assets to generate revenue (Revenue รท Total Assets). Inventory turnover is a subset of asset turnover and focuses specifically on one of the most important current assets for retail and wholesale businesses. Both are important efficiency metrics but measure different things.

โš ๏ธ Important Disclaimer: This Inventory Turnover Calculator is for informational and educational purposes only. It provides estimates based on the inputs you provide and standard inventory turnover formulas. Results should be verified with your accounting records and financial advisor before making business decisions. Industry benchmarks are averages and may not reflect your specific business circumstances. This calculator does not provide financial or accounting advice.