Inventory Turnover & Days Sales Calculator
Calculate how efficiently your business sells and replenishes inventory using the turnover ratio and days sales in inventory. Useful for purchasing, warehousing, and cash flow optimization.
About this calculator
The inventory turnover ratio measures how many times a business sells and replaces its entire inventory stock over a given period. The standard formula uses average inventory to smooth out fluctuations: Inventory Turnover = COGS / ((Beginning Inventory + Ending Inventory) / 2). A higher ratio generally indicates efficient inventory management and strong sales, while a low ratio may signal overstocking or slow-moving goods. Days Sales in Inventory (DSI) converts the ratio into a more intuitive time measure: DSI = 365 / Inventory Turnover. For example, a turnover of 8 means inventory is held an average of about 46 days. Comparing your calculated turnover to a target turnover ratio shows whether current inventory investment is appropriate. Industry benchmarks vary widely — grocery retailers may turn inventory 20+ times per year, while machinery dealers may turn it 2–4 times.
How to use
Assume annual COGS = $240,000, beginning inventory = $30,000, and ending inventory = $50,000. Step 1 — Average inventory: ($30,000 + $50,000) / 2 = $40,000. Step 2 — Inventory Turnover: $240,000 / $40,000 = 6.0 times/year. Step 3 — Days Sales in Inventory: 365 / 6.0 ≈ 61 days. If the target turnover is 8.0, required average inventory = $240,000 / 8.0 = $30,000, meaning the business should reduce average stock by $10,000 to hit its efficiency goal.
Frequently asked questions
What does a high inventory turnover ratio mean for a business?
A high inventory turnover ratio means a business is selling through its stock quickly relative to the amount it holds on hand. This is generally positive — it suggests strong demand, efficient purchasing, and less capital tied up in unsold goods. However, an extremely high ratio can also indicate understocking, which risks stockouts and lost sales. The ideal ratio depends on your industry, lead times from suppliers, and seasonal demand patterns.
How do I use days sales in inventory to improve cash flow?
Days Sales in Inventory (DSI) tells you on average how long cash is locked up in inventory before it converts to a sale. Reducing DSI frees up working capital that can be used for other business needs. Practical ways to reduce DSI include tightening reorder points, negotiating faster supplier delivery, running promotions on slow-moving stock, or discontinuing low-velocity SKUs. Even shaving 10 days off DSI can meaningfully improve cash flow for a mid-sized retailer.
Why is average inventory used in the turnover formula instead of ending inventory?
Using only ending inventory can distort the ratio if stock levels fluctuate significantly across the year — for instance, after a holiday season or large supplier shipment. Averaging beginning and ending inventory provides a more representative snapshot of the typical stock level held during the period. For even greater accuracy, businesses with highly seasonal inventory sometimes calculate the average across 12 monthly balance points. The goal is to match the inventory denominator as closely as possible to the period over which COGS was incurred.