Inventory Turnover Ratio Calculator
Measures how many times a business sells and replaces its inventory over a period. Use it to spot slow-moving stock, benchmark against industry peers, or optimize reorder cycles.
About this calculator
The inventory turnover ratio tells you how efficiently a company converts its inventory into sales. It is calculated as: Turnover = COGS / ((Beginning Inventory + Ending Inventory) / 2). The denominator represents average inventory held during the period. A higher ratio generally signals strong sales or lean inventory management, while a low ratio may indicate overstocking or weak demand. Days Sales in Inventory (DSI) is the inverse metric: DSI = 365 / Turnover Ratio, showing how many days it takes to sell through average inventory. Retailers often target ratios of 4–12 depending on sector, while manufacturers may run lower due to longer production cycles. Tracking this metric quarterly helps identify seasonal trends and guides purchasing decisions.
How to use
Suppose a retailer has annual COGS of $500,000, beginning inventory of $80,000, and ending inventory of $120,000. Average inventory = ($80,000 + $120,000) / 2 = $100,000. Turnover = $500,000 / $100,000 = 5.0 times per year. That means the company sells and replenishes its entire stock five times annually. DSI = 365 / 5.0 = 73 days — inventory sits on shelves roughly 73 days before being sold. Enter your own COGS and inventory values above to get your ratio instantly.
Frequently asked questions
What is a good inventory turnover ratio for retail businesses?
A healthy inventory turnover ratio for retail typically falls between 4 and 12, though it varies significantly by industry. Grocery stores may exceed 20 due to perishable, fast-moving goods, while furniture retailers may hover around 3–4 because items sell slowly. The best benchmark is your industry average, which you can find in sector-specific financial databases. Consistently below-average ratios suggest excess stock tying up working capital, while unusually high ratios may signal stockouts and lost sales.
How does inventory turnover ratio affect cash flow?
A higher turnover ratio means you convert inventory into cash more quickly, reducing the amount of working capital tied up in stock at any given time. This improves liquidity and can lower storage, insurance, and obsolescence costs. Conversely, a low turnover ratio means cash is locked in unsold goods, potentially forcing businesses to rely on credit lines for day-to-day operations. Improving turnover — through better demand forecasting, promotional markdowns, or tighter reorder points — directly strengthens cash flow.
What is the difference between inventory turnover ratio and days sales in inventory?
Inventory turnover ratio counts how many complete cycles of selling and restocking occur in a period, expressed as a number (e.g., 6 times per year). Days Sales in Inventory (DSI) converts that figure into days: DSI = 365 / Turnover Ratio. DSI is often easier to communicate operationally — telling a warehouse manager that inventory sits for 45 days is more actionable than saying turnover is 8.1. Both metrics measure the same underlying efficiency; choose whichever resonates best with your audience.