Profession Calculators
Business Finance

Inventory Turnover Calculator

Calculate inventory turnover ratio and days sales of inventory from COGS and inventory values.

Share:
Inventory Data

Enter to calculate GMROI and stock-to-sales ratio.

Storage, insurance, depreciation. Typically 20-30% of inventory value.

Turnover Analysis

Enter COGS and inventory values, then click calculate.

Download Your Results

Includes formulas & explanations

A 10-second preparation delay applies before each download begins.

Embed This Calculator on Your Website

Add this free calculator to your blog, website, or CMS with a simple copy-paste embed code.

Introduction

Dead inventory is dead capital. Every unit sitting in a warehouse that is not selling represents cash that was spent but not yet recovered -- and until it sells, it cannot fund payroll, supplier payments, or growth. The National Retail Federation reports that US retailers hold an estimated $1.43 in inventory for every $1 in sales, with overstocking and shrink costing the industry billions annually. Inventory turnover measures how many times a business sells and replaces its inventory stock over a period -- typically one year. A high turnover signals efficient inventory management and strong demand. A low turnover signals slow-moving stock, over-purchasing, or demand forecasting errors. This calculator computes your inventory turnover ratio, average days inventory outstanding (DIO), and the cost of capital tied up in slow-moving stock -- giving you a precise view of inventory health rather than a feeling.

What This Calculator Does

This inventory turnover calculator takes your annual cost of goods sold (COGS) and average inventory value (beginning plus ending inventory divided by 2) to produce the inventory turnover ratio and days inventory outstanding (DIO). Optionally enter your cost of capital rate to calculate the annual cost of holding your current inventory level, and enter an industry benchmark turnover ratio to see how your performance compares.

The Formula

Inventory Turnover = COGS / Average Inventory | Days Inventory Outstanding (DIO) = 365 / Inventory Turnover

COGS is used in the numerator rather than revenue because inventory is recorded at cost, not at selling price. Using revenue would inflate the apparent turnover rate. Average inventory is calculated as (Beginning Inventory + Ending Inventory) / 2 to smooth out seasonal fluctuations in stock levels. DIO expresses the same ratio in days: how many days of COGS-worth of inventory is held on average. A DIO of 45 means the business holds 45 days' worth of inventory at current consumption rates.

Step-by-Step Example

1

Gather COGS and inventory figures

An electronics retailer reports annual COGS of $4,800,000. Beginning inventory (January 1): $620,000. Ending inventory (December 31): $740,000. Average inventory: ($620,000 + $740,000) / 2 = $680,000.

2

Calculate inventory turnover

Inventory turnover: $4,800,000 / $680,000 = 7.06 times per year.

3

Calculate days inventory outstanding

DIO: 365 / 7.06 = 51.7 days. The business holds approximately 52 days of inventory on hand at any given time.

4

Benchmark and calculate holding cost

Industry benchmark for electronics retail: 8 to 12 turns. At 7.06 turns, the business is below benchmark. With a 6% cost of capital, the annual holding cost of $680,000 in inventory is $40,800. Improving to 9 turns would reduce average inventory to $533,000 and save $8,820 in annual holding cost -- plus freeing $147,000 in cash.

Real-World Use Cases

Identifying Slow-Moving SKUs Before Year-End

A hardware distributor calculates turnover at the SKU level, not just the aggregate. 80% of SKUs turn at 8 to 14 times per year. The bottom 15% turn fewer than 3 times annually. Running the DIO calculation on the slow movers reveals $148,000 in stock with an average DIO of 187 days. Management implements a clearance pricing strategy for these SKUs before the year-end inventory audit, recovering $112,000 in cash and reducing storage costs.

Evaluating a New Supplier's Minimum Order Requirement

A supplier offers a 12% price discount for orders of 2,000 units minimum versus the current 500-unit orders. The current turnover on this SKU is 9 times per year (DIO 41 days). At 2,000 units, the inventory would last approximately 146 days before depletion at current sales velocity -- a DIO of 146, well above the acceptable threshold. The discount is rejected because the carrying cost and cash lock-up outweigh the price benefit.

Working Capital Line of Credit Sizing

A manufacturer applies for a revolving credit facility. The lender uses DIO as one input in collateral-based lending. With a DIO of 60 days and monthly COGS of $350,000, the average inventory eligible as collateral is approximately $700,000. The lender advances 50% against eligible inventory, supporting a $350,000 credit line. Understanding DIO helps the owner understand and optimize their borrowing capacity.

Comparison

IndustryTypical Inventory TurnoverTypical DIO (Days)Notes
Grocery / Food Retail15 - 25x15 - 24 daysPerishables drive high frequency
Consumer Electronics8 - 12x30 - 45 daysShort product cycles increase risk
Apparel Retail4 - 6x60 - 90 daysSeasonal patterns create spikes
Automotive Parts3 - 5x73 - 120 daysWide SKU range; tail is slow
Industrial / B2B Distribution4 - 7x52 - 90 daysMRO items turn slower
Manufacturing4 - 8x45 - 90 daysWIP adds to holding time

Common Mistakes to Avoid

  • Using revenue instead of COGS in the numerator. Inventory is valued at cost, so comparing it to revenue introduces a margin-distorted ratio. A business with 60% gross margins using revenue would appear to turn inventory nearly 2.5 times faster than the COGS-based calculation -- which overstates inventory efficiency. Always use COGS.

  • Using ending inventory only instead of average inventory. Ending inventory may be artificially low (after year-end clearance) or high (before seasonal buildup), making the turnover ratio look better or worse than the true operational reality. Average inventory smooths these distortions.

  • Optimizing turnover at the expense of stockout risk. Pushing inventory turnover too high without improving demand forecasting or lead time management increases the frequency of stockouts. The goal is the optimal turnover for your service level, not the maximum possible turnover.

Frequently Asked Questions

Accuracy and Disclaimer

Inventory turnover calculations use COGS and average inventory values as provided. Actual inventory holding costs vary by product type, storage conditions, insurance, and financing structure. Industry benchmarks cited are general estimates; actual benchmarks for specific industries and business sizes should be sourced from applicable trade associations or financial data providers. Results are for planning purposes only.

Conclusion

Inventory turnover is a leading indicator of cash flow health, not a lagging one. If turnover is declining while revenue is stable or growing, the problem is upstream: over-purchasing, expanding SKU count without demand validation, or supplier minimum order quantities that exceed actual usage. To see how inventory performance affects your short-term liquidity position, use the Working Capital Calculator. For businesses modeling reorder decisions to optimize turnover, the Inventory Reorder Point Calculator provides the demand-based reorder framework.