Inventory Turnover Ratio: Formula, DIO & Examples

Inventory turnover compares the cost of goods sold during a period with the average inventory held over that period. The common formula is cost of goods sold divided by average inventory. Both amounts should use a consistent cost basis. Dividing sales revenue by inventory cost produces a different ratio and makes the result harder to compare with a standard turnover calculation.

The ratio helps show how quickly inventory moves through the business, but it does not identify which products are slow, obsolete or unavailable. A useful review combines turnover with stock age, service levels, supplier lead times and margin. A high overall result can hide dead stock in one category and repeated shortages in another.

A simple average uses beginning inventory plus ending inventory, divided by two. In a hypothetical year with beginning inventory of $100,000 and ending inventory of $140,000, average inventory is $120,000. If annual cost of goods sold is $600,000, turnover is five times. The company sold goods with a cost equivalent to five average inventory balances during the year.

Beginning-and-ending averages can be misleading for a seasonal business. A retailer might hold substantial stock before a holiday and much less at year end. Monthly or more frequent inventory balances provide a more representative average when the data are reliable. Record the averaging method and use it consistently before comparing periods or making purchasing decisions.

Days inventory outstanding, or DIO, expresses the relationship as an estimated number of days. For an annual period, a common calculation is average inventory divided by cost of goods sold, multiplied by 365. With $120,000 average inventory and $600,000 annual cost of goods sold, DIO is seventy-three days. The equivalent calculation is 365 divided by five turns.

Use the actual period length when working with a shorter interval. A ninety-day quarter should not automatically use 365 while retaining only that quarter's cost of goods sold. Label the measure clearly and distinguish a period calculation from an annualized presentation. The result is an aggregate estimate, not the actual age of each item in the warehouse.

Higher turnover can indicate efficient movement, but it can also reflect insufficient stock. If customers frequently encounter unavailable products, the business may lose contribution that the ratio does not capture. Emergency purchases and expedited shipping can also reduce margin. Compare turnover with order-fill rates, stockout days and the cost of replenishment before describing an improvement.

Lower turnover can reflect a deliberate seasonal build, a long supplier lead time or a problem with excess stock. The reason determines the action. A business should not liquidate a necessary buffer solely to improve a ratio before a reporting date. Review the stock's purpose, expected demand and funding cost together, with a documented decision for material exceptions.

Group products by sales pattern, margin, replenishment time and age. A steady high-volume item deserves a different policy from a low-volume spare part that supports an important customer. Review the date of the last sale, quantities on hand, open purchase orders and realistic demand. A product can appear available in the system even when the remaining units are damaged or unsuitable for sale.

Create an exception list for items with no recent movement, unusual returns or repeated forecast misses. Assign an owner to investigate each significant balance. Check whether a substitute product, packaging change or obsolete specification explains the issue. Do not assume a price reduction will solve a product that no longer fits customer needs.

Inventory consumes cash before the customer pays, subject to supplier terms. A hypothetical additional $30,000 stock purchase may improve availability, but it also creates a funding requirement. The decision should include expected contribution, replenishment alternatives and the time until the cash is recovered. Inventory value is not equivalent to accessible money in a reserve account.

Review purchasing commitments alongside on-hand stock. A team can reduce visible inventory while leaving large incoming orders unchanged. Include open orders, cancellation conditions and expected delivery dates in the review. For long lead times, use a demand range rather than one precise forecast that assumes every customer order arrives as expected.

Inventory valuation and cost-of-goods-sold policies affect the ratio. Keep the method consistent and identify significant write-downs or adjustments separately. An accounting reduction in inventory can improve a turnover calculation without a corresponding improvement in sales or cash generation. Explain what changed so management does not reward a ratio movement that reflects a loss.

Tax inventory rules and management reports serve different purposes. Use current accounting guidance and professional advice for the financial and tax treatment. The operating worksheet is a planning tool, not a substitute for the company's books. Reconcile physical counts and the inventory system before relying on a ratio whose denominator may include missing or incorrectly recorded stock.

Review turnover by meaningful category, compare actual sales with purchasing assumptions and inspect material exceptions. Record the decision: replenish, maintain, reduce, return where permitted or investigate. Assign a review date and include the expected cash effect. A concise action list is more useful than a dashboard that changes color but leaves every purchasing decision untouched.

The downloadable worksheet includes cost of goods sold, average inventory, period days, turnover and DIO, followed by an exception register. Use comparable definitions and keep the underlying balances. The goal is reliable availability with an affordable cash commitment, rather than maximizing turnover at the expense of customers or carrying stock indefinitely because its original purchase price looks recoverable.