Inventory Turnover Ratio: Formula, Supply Chain Velocity and Working Capital

What Inventory Turnover Tells You

Turnover helps identify changes worth investigating. It does not prove lean operations or low obsolescence risk. A company may raise turnover by selling successfully, running short of goods, or reducing the inventory carrying amount. A planned build ahead of a seasonal peak can lower turnover without a demand problem.

How to Calculate Inventory Turnover

Match the period, entity, and inventory scope. Financial-statement turnover uses costs and carrying amounts; it is distinct from a warehouse calculation based on individual units.

• Retrieve COGS for the selected period. Revenue includes selling margins and creates a different ratio; do not substitute it silently.
• Obtain beginning and ending inventory, and start with their arithmetic average. For seasonal or rapidly changing balances, use more frequent observations or a documented time-weighted average; four quarter-end snapshots are not automatically exact.
• Inspect inventory valuation and write-downs. IAS 2 measures inventory at the lower of cost and net realizable value, so carrying amounts need not equal original purchase costs.
• Divide period COGS by average inventory. Positive inventory with zero COGS gives zero turnover, but a finite DIO cannot be calculated by dividing by zero. Zero average inventory makes turnover undefined. Investigate negative inputs instead of ranking them normally.
• Calculate DIO using the same period’s days. Review receivables and payables separately before drawing conclusions about cash conversion.

Hypothetical Annual and Quarterly Examples

These invented examples show the effect of period matching. They are not sector benchmarks or observations of a particular business.

Turnover, DIO, and GMROI Answer Different Questions

DIO is the inverse turnover calculation scaled to period days, so it is not an independent validation of turnover. It approximates days of inventory under the ratio’s assumptions, not the exact age of every item. Gross margin return on inventory (GMROI) uses gross profit / average inventory cost. For example, hypothetical gross profit of $3 million on $1 million average inventory gives GMROI of 3.0× before operating overhead, financing, and taxes—not a net investment return.

• Compare turnover with gross margin: discounting can increase sales movement while reducing profit.
• Check stockouts and fulfillment performance. A high ratio caused by shortages is not automatically good management.
• A sale on credit can increase COGS and reduce inventory before cash is collected. Turnover alone does not establish cash release.
• Use dated peers with comparable product categories, accounting policies, and seasonality. Avoid universal grocery, apparel, or manufacturing ranges without a specified dataset.