Inventory Turnover Calculator

Use this calculator to measure inventory turnover based on cost of goods sold and average inventory. Essential for evaluating stock management efficiency, identifying slow-moving inventory, improving cash flow, and benchmarking supply chain performance.

What this calculator does

The inventory turnover calculator helps you measure how many times your business sells and replaces its entire inventory during a period.

It uses:

• cost of goods sold
• average inventory value

This gives you inventory turnover ratio - a key efficiency metric for any business managing physical stock, showing how productively inventory is being converted into sales.

How to use the inventory turnover calculator

1. Enter your cost of goods sold - the total direct cost of all goods sold during the period, from your profit and loss statement
2. Enter your average inventory - the average value of inventory held during the period, typically calculated as opening inventory plus closing inventory divided by two
3. The calculator instantly shows your inventory turnover ratio

Both figures should cover the same time period - typically a full financial year or consistent quarter - for an accurate result.

Inventory Turnover Formula

Inventory Turnover = Cost of Goods Sold / Average Inventory

Where:

• Cost of Goods Sold = total direct cost of goods sold during the period
• Average Inventory = average inventory value during the same period
• Inventory Turnover = number of times inventory is sold and replaced

Example calculation

If:

• Cost of goods sold = 120,000
• Average inventory = 30,000

Then:

• Inventory turnover = 120,000 / 30,000
• Inventory turnover = 4.0

The business sold and replaced its entire inventory 4 times during the period - roughly once every 3 months. At an annual rate, the average item spends approximately 91 days in stock before being sold.

What is inventory turnover?

Inventory turnover is a ratio that measures how many times a business sells and replaces its inventory over a given period. It is one of the most widely used supply chain and operations metrics because it directly indicates how efficiently working capital is being deployed in inventory.

A higher turnover means stock is moving quickly - less capital is tied up in unsold goods and the business is converting inventory into cash more rapidly. A lower turnover means stock is moving slowly - more capital is locked in inventory, carrying costs accumulate, and the risk of obsolescence or spoilage increases.

What is a good inventory turnover?

Benchmarks vary significantly by industry and product type:

• Grocery and fast-moving consumer goods - typically 12 to 52 times per year
• Fashion and apparel - typically 4 to 8 times per year
• Electronics - typically 6 to 12 times per year
• Home and furniture - typically 3 to 6 times per year
• Industrial equipment and machinery - typically 2 to 4 times per year
• Luxury goods - often 1 to 3 times per year

A declining turnover over time is a warning sign - it means inventory is accumulating relative to sales, tying up working capital and increasing carrying costs. A rising turnover indicates improving efficiency.

Why inventory turnover matters for business performance

Tracking inventory turnover helps you:

• measure how efficiently the business converts inventory investment into sales
• identify slow-moving stock categories that are consuming working capital without proportional sales contribution
• benchmark supply chain performance against industry standards and prior periods
• improve purchasing decisions by understanding which product lines turn over quickly versus slowly
• assess the impact of pricing, promotions, or product mix changes on inventory velocity

Inventory turnover and cash flow

Inventory turnover has a direct relationship with cash flow - the faster inventory turns, the faster the business converts its purchasing investment into cash from sales. Slow-turning inventory locks up cash in the form of unsold stock, reducing liquidity and increasing the capital required to fund operations.

Improving inventory turnover - by selling faster, reducing overstock, or tightening purchasing - releases working capital without requiring additional revenue growth.

How to improve inventory turnover

Practical approaches for increasing how quickly inventory moves:

• Improve demand forecasting - better forecasts reduce over-purchasing and prevent slow-moving stock build-up
• Reduce safety stock levels where appropriate - excess buffer stock increases average inventory and reduces turnover
• Use promotional pricing on slow-moving items - discounting old or excess stock improves sell-through and improves turnover even if margin is compressed
• Tighten supplier lead times - faster replenishment allows lower standing stock levels for the same service level
• Discontinue poor performers - products that consistently show low turnover may not be worth carrying

When to use this calculator

Use this calculator when you want to:

• review inventory turnover as part of regular financial and operations reporting
• identify product categories with below-average turnover that warrant purchasing adjustments
• compare turnover performance across different periods, product lines, or locations
• benchmark your turnover against industry averages
• calculate days in inventory - divide 365 by inventory turnover to convert the ratio to days

Common mistakes when calculating inventory turnover

Common mistakes include:

• using revenue instead of cost of goods sold - using revenue inflates the ratio because selling price is higher than cost. COGS-based turnover is the standard approach.
• using end-of-period inventory rather than average inventory - period-end balances can be significantly higher or lower than the average held during the period, distorting the result
• comparing turnover ratios across businesses with very different cost structures or pricing models
• ignoring seasonality - turnover naturally fluctuates with demand patterns and should be compared to the same period in prior years

Inventory turnover vs days sales in inventory

These two metrics express inventory efficiency in different formats and are mathematically related.

• Inventory turnover is a ratio - how many times inventory is sold and replaced per period
• Days sales in inventory expresses the same concept in days - how long the average item sits in stock before being sold

DSI = 365 / Inventory Turnover. A turnover of 4 corresponds to approximately 91 days in inventory. Use the Days Sales in Inventory Calculator to express inventory efficiency in days.

Inventory turnover vs gross margin

These metrics measure different dimensions of product performance.

• Inventory turnover measures how quickly products sell - operational efficiency
• Gross margin measures how profitably products sell - financial efficiency

The most valuable products combine both: high turnover and strong margin. A product with high turnover but very low margin may not be worth carrying if it generates minimal gross profit relative to the working capital consumed. Use the Gross Margin Calculator to assess margin alongside turnover.

Related calculations

Once you know your inventory turnover, you may also want to:

• Use the Days Sales in Inventory Calculator to express the same metric in days
• Use the Inventory Carrying Cost Calculator to quantify the cost of holding slow-turning inventory
• Use the Reorder Point Calculator to set stock replenishment triggers based on sales velocity
• Use the Gross Margin Calculator to analyse margin alongside inventory efficiency

Useful resources

• Shopify - ecommerce platform with inventory performance reporting and stock level tracking
• Cin7 - inventory management software with turnover analysis and stock efficiency reporting
• QuickBooks - accounting software with COGS reporting and inventory valuation for turnover calculation
• Linnworks - multi-channel inventory management platform with velocity and turnover analytics

FAQs

What is inventory turnover?

Inventory turnover measures how many times a business sells and replaces its entire inventory during a period. A higher ratio indicates faster-moving, more efficient inventory management.

How do you calculate inventory turnover?

Inventory Turnover = Cost of Goods Sold / Average Inventory.

Why use cost of goods sold rather than revenue?

COGS represents the actual cost of inventory - the same basis as the inventory valuation on the balance sheet. Using revenue mixes selling price with cost, producing an inflated and misleading ratio.

What is a good inventory turnover ratio?

It depends on the industry. Grocery businesses typically see turnover of 12 to 52 times per year. Fashion and apparel typically 4 to 8 times. Industrial goods often 2 to 4. Compare against industry benchmarks and your own historical trend.

Is a higher inventory turnover always better?

Generally yes, but extremely high turnover - achieved by holding very minimal safety stock - increases the risk of stockouts. The goal is efficient turnover while maintaining sufficient stock to meet demand without disruption.

How does inventory turnover relate to days in inventory?

They are mathematically inverse: Days in Inventory = 365 / Inventory Turnover. A turnover of 4 means an average of 91 days in stock before selling.

How does inventory turnover affect cash flow?

Higher turnover means the business converts inventory investment into cash more quickly, reducing the working capital required to sustain operations at the same revenue level. Slower turnover locks up more cash in unsold stock.

How often should I calculate inventory turnover?

Quarterly is standard for most businesses. Monthly tracking is useful for businesses with fast-moving inventory, seasonal demand, or active stock management programmes. Annual calculation is a minimum for financial reporting purposes.

Interpreting your result

Your inventory turnover result should always be interpreted in context:

• compare it against your historical baseline
• review it alongside the main commercial or operational drivers behind the metric
• compare it across products, channels, periods, or segments where relevant
• avoid interpreting the result in isolation without checking the underlying input values

A single period can be noisy, so trend direction over several periods is usually more useful than one standalone result.

Data quality checklist

Before acting on this result, verify:

• the inputs use the same time period and reporting basis
• one-off anomalies are identified separately from steady-state performance
• discounts, refunds, taxes, or fees are handled consistently where relevant
• the underlying values are complete enough to support a meaningful conclusion

Small input inconsistencies can materially change the result.

How to improve this metric

Practical ways to improve this metric depend on the underlying business model, but often include:

• identify the main driver behind the result before making changes
• test one variable at a time so the impact is easier to measure
• compare performance by segment rather than only at an overall level
• review the metric regularly so changes can be caught early

Improvement is most reliable when measurement definitions remain stable over time.

Benchmarks and target setting

A good target depends on your industry, business model, and stage of growth.

When setting targets:

• compare against your own historical trend before relying on outside benchmarks
• define both minimum acceptable and aspirational target ranges
• review targets whenever pricing, cost, demand, or channel mix changes materially
• pair benchmark review with the underlying commercial context, not just the final number

Your own historical performance is usually the most practical benchmark.

Reporting cadence and decision workflow

For most teams, a simple cadence works best:

• Weekly: monitor the metric when trading conditions or campaign activity change quickly
• Monthly: compare the result against target and prior periods
• Quarterly: reassess assumptions, targets, and the main drivers behind the metric

A practical workflow is to calculate the metric, identify the primary driver of change, test one improvement, and then review the next comparable period before scaling.

Common analysis scenarios

You can use this metric in several practical scenarios:

• monthly performance reviews
• pricing, margin, or cost analysis
• planning and forecasting discussions
• investor, lender, or management reporting

In each scenario, pair the result with the underlying business context so decisions are not made on one number alone.

FAQ extensions

Should I compare this metric across channels?

Yes, but only when definitions and attribution rules are consistent.

How many periods should I review before making changes?

At least 3 comparable periods is a good baseline unless there is a clear data issue or one-off event.

What should I do if this metric improves but profit declines?

Check whether costs, discounts, conversion quality, or downstream profitability changed at the same time.