Inventory Turnover Ratio Calculator โ Stock Efficiency Metric
Calculate your inventory turnover ratio and days of inventory on hand. Identify slow-moving stock, optimize reorder points and free up working capital.
๐ Inventory Turnover Ratio Calculator
How to Use This Calculator
- Enter annual COGS โ cost of goods sold โ not revenue. Use your income statement.
- Calculate average inventory โ add opening and closing inventory values and divide by 2.
- Review turnover โ compare to industry benchmarks. Grocery: 20โ30x. Industrial: 3โ6x. Fashion: 4โ8x.
Worked Example
A distributor has $2,400,000 COGS and average inventory of $400,000.
- Turnover: $2,400,000 รท $400,000 = 6.0x
- Days in stock: 365 รท 6 = 60.8 days
- Holding cost: $400,000 ร 25% = $100,000/year
Improving turnover from 6x to 8x by reducing average inventory to $300,000 would save $25,000/year in holding costs and free up $100,000 in working capital.
Frequently Asked Questions
Benchmarks vary by industry. Food/grocery: 15โ30x. Automotive parts: 5โ10x. Industrial distribution: 4โ8x. Electronics: 8โ15x. Fashion: 4โ6x. Compare to your industry peers, not a universal standard.
Overstocking, poor demand forecasting, slow-moving SKUs, seasonal products held too long, minimum order quantities forcing excess buys, and supply chain disruption buffer stock. Address root causes rather than just reducing safety stock.