OnSumo Tools

Inventory Turnover Calculator

This calculator finds your inventory turnover ratio and days of inventory on hand, then shows what a higher turnover rate would mean for your cash flow and annual carrying costs. Enter your annual cost of goods sold, average inventory value, holding cost percentage, and industry to benchmark your turnover against industry norms and quantify the cash freed by reaching your target rate.

100% client-side. Inventory and COGS figures never leave this browser.

Turnover, days on hand, holding cost, and cash you might free by hitting a higher target turnover rate.

Inventory turnover

4.0x| 91 days on hand

More than 20% below typical 6-12x

Industry guide: E-commerce 6-12x (benchmarks vary by sub-category).

Turnover ratio

4.00x

Days on hand

91.3 days

Annual holding cost

$15,000

Holding cost per day

$41.10

Cash flow impact (what-if)

Reaching 9x turnover frees about $33,333 in cash and saves about $8,333/year in holding costs.

Cash freed (one-time)

$33,333.33

Annual holding savings

$8,333.33

Inventory at target

$26,666.67

Current vs target inventory (cash tied up)

Total inventory cost sold in the period.

(Beginning + ending inventory) / 2.

Storage, insurance, obsolescence, financing; often 20-30%.

How does the Inventory Turnover Ratio Calculator work step by step?

Enter your cost of goods sold for the period (annual COGS for yearly turnover, or quarterly COGS for quarterly turnover). Input your average inventory value, calculated as (beginning inventory + ending inventory) / 2. The calculator divides COGS by average inventory to return turnover ratio and days of inventory on hand (365 divided by turnover ratio). If your COGS is $2 million and average inventory is $500,000, turnover is 4, and days of inventory is 91 days. This means you hold roughly three months of inventory at current sales rates.

What does a typical Inventory Turnover Ratio Calculator result look like?

COGS: $240,000/year. Average inventory: $60,000. Holding cost: 25%. Industry: E-commerce. Inventory turnover: $240,000 / $60,000 = 4.0x. Days on hand: 365 / 4.0 = 91 days. E-commerce benchmark: 6-12x. Current 4.0x is below the low end. If you improve to 6x: target inventory = $240,000 / 6 = $40,000. Inventory reduction: $20,000. Cash freed: $20,000 (one-time working capital release). Holding cost savings: $20,000 x 25% = $5,000/year.

Frequently asked questions

  • What is a good inventory turnover ratio?

    Good turnover varies by industry and business model. Grocery and perishable goods businesses target 15 to 30 turns per year. Apparel and fashion retail aim for 4 to 6 turns. Industrial distributors and B2B wholesalers often run 3 to 5 turns due to longer sales cycles and customer order patterns. Compare your turnover to industry-specific benchmarks rather than universal targets. Within your own company, track turnover trends over time; improving turnover indicates better inventory management regardless of absolute level.

  • How do I improve inventory turnover without losing sales?

    Focus on slow-moving SKUs that account for low sales volume but high inventory value. Use ABC analysis to classify items by revenue contribution, and apply markdown or liquidation strategies to C-items (low revenue, high stock). Improve demand forecasting accuracy to align purchasing with actual sales velocity. Implement vendor-managed inventory or consignment for slow movers to shift holding costs to suppliers. Reduce lead times through supplier partnerships or domestic sourcing so you can hold less safety stock without increasing stockout risk.

  • Can inventory turnover be too high?

    Yes. Turnover above industry norms may indicate insufficient stock to meet demand, causing lost sales and customer dissatisfaction. If turnover is high but fill rates are below 95 percent, you are running too lean. High turnover with frequent expedited shipping or rush orders to cover stockouts erodes the working capital benefit. Optimal turnover balances capital efficiency with service level; the goal is the highest turnover that maintains target fill rates and does not require constant firefighting to cover inventory gaps.

  • How does seasonality affect inventory turnover calculations?

    Seasonal businesses show fluctuating turnover across the year. Calculate turnover on a rolling 12-month basis to smooth seasonal peaks and troughs, or compute separate turnover for peak and off-peak periods to understand seasonal performance. For annual turnover, use year-end inventory values to avoid distortions from mid-season buildup. If you hold $1 million in inventory at year-end but $3 million during peak season, year-end turnover overstates efficiency because the denominator omits the peak holding period.

  • Should I use COGS or revenue to calculate inventory turnover?

    Always use COGS, not revenue. Revenue includes markup and does not reflect the actual cost basis of inventory. Using revenue inflates turnover and distorts comparisons across companies with different margin structures. COGS matches the valuation basis of inventory (cost, not selling price) and provides an apples-to-apples efficiency metric. Financial reporting standards require COGS for turnover calculations.

  • How do I calculate average inventory if my business is growing rapidly?

    Use a weighted average that reflects inventory held across the period rather than a simple average of beginning and ending balances. If you start with $200,000 in inventory and end with $800,000 due to rapid growth, the simple average of $500,000 understates the typical inventory level if most of the growth occurred late in the period. For precise turnover, use monthly ending inventory values and calculate the average across all 12 months. This method smooths growth distortions and yields a more representative turnover figure.

Related tools