Inventory Turnover Ratio Calculator
Measure how many times your business sells and replaces its inventory over a period. Use it to spot slow-moving stock, optimize reorder schedules, and benchmark against industry peers.
About this calculator
Inventory turnover measures how efficiently a company converts stock into sales. The core formula is: Inventory Turnover Ratio = COGS / Average Inventory, where Average Inventory = (Beginning Inventory + Ending Inventory) / 2. A higher ratio generally indicates strong sales or lean stock management, while a low ratio can signal overstocking or weak demand. A related metric, Days Inventory Outstanding (DIO), is calculated as: DIO = Analysis Period (days) / Turnover Ratio. For example, an annual period uses 365 days. Retail businesses often target turnovers of 4–6×, while grocery operations may run 20×+. Comparing your ratio against industry benchmarks reveals whether capital is being tied up unnecessarily in unsold goods.
How to use
Assume annual COGS of $500,000, beginning inventory of $80,000, and ending inventory of $120,000. Step 1 — calculate average inventory: ($80,000 + $120,000) / 2 = $100,000. Step 2 — compute the turnover ratio: $500,000 / $100,000 = 5.0×. This means inventory was fully cycled 5 times during the year. Step 3 — calculate days in inventory: 365 / 5.0 = 73 days. So on average, goods sat in stock for 73 days before being sold. If your industry benchmark is 60 days, this signals a modest overstocking issue worth investigating.
Frequently asked questions
What is a good inventory turnover ratio for a retail business?
A good ratio varies significantly by industry. Grocery and convenience stores often achieve 15–30× because of perishable, fast-moving goods, while furniture or luxury goods retailers may see 2–4×. For general retail, a ratio between 4× and 8× is commonly considered healthy. Rather than chasing a universal benchmark, compare your ratio to direct competitors and track your own trend over time to identify improvements or warning signs.
How does inventory turnover ratio help with cash flow management?
Inventory ties up cash until it is sold, so a low turnover means money is sitting on shelves instead of being reinvested in the business. By increasing turnover, companies free up working capital, reduce storage and insurance costs, and lower the risk of stock becoming obsolete or spoiled. Monitoring turnover alongside days-in-inventory helps procurement teams time reorders more precisely, avoiding both stockouts and costly overstocking situations.
Why is average inventory used instead of ending inventory in the turnover formula?
Using only ending inventory can be misleading if stock levels fluctuate significantly throughout the year — for example, after a holiday sales surge. Averaging beginning and ending inventory smooths out those seasonal swings and provides a more representative picture of how much capital was typically tied up in stock over the period. For businesses with highly variable inventory, some analysts go further and average monthly balances to get an even more accurate denominator.