How to Calculate Product Turnover: Tips

Last updated: October 3, 2026

The inventory turnover ratio is one of the most important sales performance indicators that every store or chain manager should track. It shows how quickly inventory is converted into sales, and it directly affects profitability, cash flow, and how much money sits frozen in stock.

Why Analyze the Inventory Turnover Ratio?

A clear read on the turnover ratio brings several practical benefits to a retail business:

• It shows how long it takes to sell through a product.
• It proves whether a product is worth keeping in the assortment or should be dropped.
• It flags when stock norms in a warehouse or store need adjusting.
• It helps optimize logistics and cut delivery and storage costs.
• It reflects the performance of individual stores and the whole chain.
• It helps increase profit by clearing out products that don't earn their shelf space.

How to Calculate the Inventory Turnover Ratio

There are two groups of indicators used to analyze turnover:

• Turnover ratio shows how many full turnovers (from purchase to sale) a product completed during the period studied.
• Days sales in inventory (DSI) shows how many days it takes to complete one turn.

For an individual product, the inventory turnover formula is:

Product Turnover = COGS ÷ Average Inventory

Here, COGS (cost of goods sold) is the cost of the product sold during the period, and Average Inventory is the average inventory value for the same period.

There are two ways to calculate turnover in monetary units. Use Turnover ÷ Average Inventory when goods are valued at selling price (with markup) or when you need to account for expected profit. Use COGS ÷ Average Inventory when goods are valued at purchase cost (without markup) and expected profit isn't part of the calculation.

Together, these indicators show how quickly goods are sold and how fast the money invested in them comes back, or they flag problem areas where money is tied up in stock.

Step 1: Turnover Ratio by Product, Category, or Brand

Start by analyzing the turnover ratio for each individual product. The indicators that matter here:

• Turnover / cost of sales.
• Margin, %.
• Average inventory.
• Turnover ratio (turns).
• Days sales in inventory (days).

These let you identify the most profitable products in the store, and the ones to remove from the assortment because they aren't earning their keep. At this stage you can also compare turnover ratios across identical product groups or brands, or run a comparative analysis between stores.

It helps to plot products on a turnover ratio quadrant, split into four groups:

• Group 1: low margin, low turnover. Products that sell poorly and don't turn a profit.
• Group 2: high margin, low turnover. Products that generate solid profit, just over a longer stretch of time.
• Group 3: high margin, high turnover. The most valuable group for a retailer. Expand it where you can.
• Group 4: low margin, high turnover. Products that move fast but don't bring in much profit per unit.

The most problematic group is low margin / low turnover. The usual fix is to move it into a better group: raise the price and watch the turnover ratio (if it doesn't drop, the product now earns more per sale), or raise the turnover ratio itself through promotions and advertising.

Step 2: Turnover Ratio Over Time

Track turnover rates against previous periods. The two indicators move in opposite directions when things improve:

• A rising turnover ratio (turns) means sales are accelerating.
• A falling days sales in inventory (days) means products sell in fewer days.

The situation you want: turnover ratio going up and days sales in inventory going down. Together, that means goods are moving faster and money is coming out of stock and back into circulation.

Step 3: Frozen and Released Money in Inventory

Comparing turnover ratios across periods shows whether money was released from stock or frozen in it. Calculate the amount with this formula:

E = (Turnover for the period ÷ Days) × (DSI for the period − DSI for the previous period)

If E is greater than 0, that amount of money is frozen in stock. If E is less than 0, that amount was released.

Example: Product A sold for $10,000 in April. Days sales in inventory was 7.8 days in April and 6.4 days in March.

E = ($10,000 ÷ 30) × (7.8 − 6.4) = $466.67 frozen in stock during April.

For a product in this situation, the usual fixes fall into two categories: increase sales (price reduction, promotions) or decrease inventory (return stock to the supplier, cut future orders for that item).

How Margin and Markup Affect Turnover

Turnover alone doesn't say whether a fast-selling product is actually profitable. Pairing it with margin and markup fills in the gap.

Margin is the share of the selling price that is profit: the difference between the selling price and the cost price, shown as a percentage of the selling price. Markup is how much gets added on top of the cost price to set the selling price, shown as an amount or as a percentage of the cost price.

Example: a product costs $500 and sells for $1,000. Markup is $500, or 100% of the cost price. Margin is $500 divided by $1,000, or 50% of the selling price. For a closer look at how the two differ, read margin vs. markup.

A high turnover ratio paired with a weak margin can bring in less cash than a lower turnover ratio with a strong margin, which is exactly what the quadrant in Step 1 is built to catch. A few ways to balance the three:

• Review product costs. Lowering production or purchasing costs raises margin without changing what the customer pays.
• Price against the market. A markup set without reference to competitors either kills demand (too high) or leaves profit on the table (too low).
• Adjust markup across the product lifecycle. New products can usually carry a higher markup. Older ones need a lower markup to keep moving.
• Use promotions deliberately. Discounts can lift turnover, but only when the extra volume covers what the margin gives up.

You can track turnover ratio, margin, and markup together, broken down by region, store, category, or product, using reports and dashboards on the Datawiz BI analytics platform. They calculate the values automatically and let you track how they change over time.

FAQ

What is a good inventory turnover ratio?

It depends on the category and the business model. A higher ratio generally means faster sales and less money tied up in stock, but what counts as "good" varies by industry, so compare your ratio against your own history and similar categories rather than a single universal number.

What is the difference between inventory turnover ratio and days sales in inventory?

The turnover ratio shows how many times inventory was sold and replaced during a period. Days sales in inventory shows the same thing expressed in days: how long it takes to sell through the stock on hand. The two are directly related: ITR = Days ÷ DSI.

How do you calculate the inventory turnover ratio?

Divide the cost of goods sold by the average inventory for the same period: ITR = Turnover ÷ Average inventory, or Cost of goods ÷ Average inventory, depending on whether the goods are valued at selling price or purchase cost.

How does margin affect inventory turnover?

A product can have a high turnover ratio and still generate little profit if its margin is low. Plotting products by margin and turnover together, as in the four-group quadrant, shows which items are genuinely valuable (high margin, high turnover) and which only look productive because they sell fast.

What should you do with a low margin, low turnover product?

Either raise the price and watch whether turnover holds (if it does, the product now earns more per sale), or raise the turnover ratio through promotions and targeted advertising. If neither works, it's usually a candidate for removal from the assortment.