Inventory Turnover Calculator

Calculate inventory turnover to measure how efficiently your stock is sold and replaced over a period.

What Is Inventory Turnover?

Inventory turnover measures how many times a business sells and replaces its stock over a specific period. It is a core efficiency metric for retailers, wholesalers, and manufacturers. A higher turnover rate generally indicates strong sales and effective inventory management, while a low rate may suggest overstocking or weak demand.

The standard formula is:

Inventory Turnover = Cost of Goods Sold (COGS) ÷ Average Inventory

Average inventory is typically calculated as (Beginning Inventory + Ending Inventory) ÷ 2 for the same period.

How to Use This Calculator

Enter your total Cost of Goods Sold (COGS) for the period and your average inventory value. The calculator returns the turnover ratio and the average number of days it takes to sell through your stock.

Enter COGS — the direct costs attributable to the goods sold during the period.
Enter Average Inventory — the mean value of inventory over the same period.
Select a time period — monthly, quarterly, or annually.

The result updates instantly. No data is stored or transmitted.

Understanding Your Results

The output includes two key figures:

Turnover Ratio — the number of times inventory was sold and replaced. For example, a ratio of 5 means the entire stock turned over five times during the period.
Days to Sell Inventory — the average number of days it takes to sell the current stock. Calculated as Days in Period ÷ Turnover Ratio.

Interpretation depends heavily on industry. A grocery store may have a turnover of 20+ per year, while a luxury car dealership may be below 2. Compare your result against industry benchmarks rather than arbitrary targets.

Common Mistakes When Calculating Inventory Turnover

Using sales revenue instead of COGS. COGS reflects the actual cost of inventory sold. Using revenue inflates the ratio and gives a misleading picture.
Mismatched time periods. COGS and average inventory must cover the same period. Using annual COGS with monthly inventory produces an incorrect result.
Ignoring inventory valuation method. FIFO, LIFO, and weighted average produce different inventory values. Consistency matters more than the method itself.
Using a single point for inventory. Average inventory smooths seasonal fluctuations. A single month-end figure may not represent typical stock levels.

Limitations of the Metric

Inventory turnover is a useful diagnostic, but it has constraints:

It does not account for stockouts or lost sales. A very high turnover may indicate insufficient inventory and missed revenue.
It treats all inventory as homogeneous. A business selling both fast-moving and slow-moving items gets a blended number that may obscure problems.
Seasonal businesses see wide fluctuations. Comparing a single month against an annual benchmark can be misleading.

Practical Use Cases

Retail buyers evaluating whether stock levels align with sales velocity.
Warehouse managers identifying slow-moving items that tie up capital.
Financial analysts assessing operational efficiency as part of a broader financial review.
E-commerce sellers optimizing reorder points and storage costs.

FAQ

What is a good inventory turnover ratio?

There is no universal number. A good ratio depends on your industry, business model, and product type. High-volume, low-margin businesses like supermarkets often have ratios above 10. Low-volume, high-margin businesses like jewelry stores may have ratios below 2. Compare against industry averages rather than a fixed target.

Can inventory turnover be too high?

Yes. A very high turnover can indicate that you are frequently running out of stock, which leads to lost sales and customer dissatisfaction. It may also mean you are ordering in quantities too small to qualify for volume discounts. Balance turnover with adequate stock availability.

What is the difference between inventory turnover and days sales of inventory (DSI)?

They are two sides of the same metric. Inventory turnover is the number of times inventory is sold in a period. Days sales of inventory (DSI) is the average number of days it takes to sell that inventory. DSI = Days in Period ÷ Turnover Ratio. Both measure efficiency, just in different units.

Should I use average inventory or ending inventory?

Use average inventory. Ending inventory alone can be distorted by seasonal fluctuations or one-time purchases. Average inventory smooths these variations and gives a more accurate picture of typical stock levels.

Does this calculator work for any time period?

Yes. Enter COGS and average inventory for any period — month, quarter, or year. The calculator adjusts the days-to-sell calculation based on the period you select. Just ensure both inputs cover the same time frame.