Calculate days sales of inventory to measure how long stock sits before being sold. Track inventory holding periods and identify slow-moving products.
The Days Sales of Inventory (DSI) Calculator measures the average number of days your business holds inventory before selling it. Also known as days inventory outstanding (DIO) or average age of inventory, DSI is a critical efficiency metric that directly impacts cash flow and carrying costs. A lower DSI means faster inventory turnover and less capital tied up in stock.
This calculator provides both the standard DSI formula and category-level analysis, helping you identify which product segments move quickly and which are dragging down overall performance. By understanding your holding period, you can optimize purchasing, reduce obsolescence risk, and improve working capital management.
DSI is a key component of the cash conversion cycle (CCC) alongside days sales outstanding (DSO) and days payable outstanding (DPO). Together, these three metrics reveal how efficiently your business converts investments in inventory and receivables into cash.
Entrepreneurs, finance teams, and small-business owners gain a competitive edge from accurate days sales of inventory (dsi) data when setting prices, forecasting revenue, or managing operational costs. Save this tool and revisit it each quarter to keep your financial plans aligned with current market realities.
Every day inventory sits unsold, it costs money in storage, insurance, depreciation, and opportunity cost. A DSI reduction from 60 to 45 days on $1M average inventory frees up approximately $250K in working capital. This calculator helps you quantify the financial impact of inventory speed improvements and set actionable reduction targets.
Days Sales of Inventory = (Average Inventory / COGS) × Days in Period For Annual: DSI = (Average Inventory / COGS) × 365 For Quarterly: DSI = (Average Inventory / Quarterly COGS) × 90 Daily COGS = Annual COGS / 365 Inventory Turnover = Days in Period / DSI
Result: 50.7 days
With $1.8M in annual COGS and $250K average inventory, DSI = ($250,000 / $1,800,000) × 365 = 50.7 days. This means inventory sits an average of about 51 days before being sold. At a typical carrying cost rate of 25%, holding $250K for 51 days costs approximately $62,500 per year in carrying expenses.
DSI is a primary driver of working capital requirements. Every day of inventory carrying requires capital investment. Reducing DSI by 10 days on $1M average inventory frees up approximately $27K in cash (at cost). For companies with thin margins or high growth, this freed capital can be the difference between profitable scaling and cash crunches.
Aggregate DSI masks the performance of individual categories. A retailer with 45-day overall DSI might have fast-moving consumables at 15 days and slow-moving specialty items at 120 days. Identify and address the tail of slow movers through targeted promotions, markdowns, or discontinuation to bring overall DSI down efficiently.
Benchmark DSI against publicly traded competitors using their annual reports (COGS and inventory are both reported). Track the trend over 3-5 years to understand whether the industry is improving. Be cautious comparing across business models — a drop-shipper will always have lower DSI than a traditional warehouse retailer.
DSI benchmarks vary widely by industry. Grocery stores target 15-30 days, general retail 45-75 days, industrial distributors 60-90 days, and heavy equipment dealers 90-180 days. The key is improvement over time and comparison to direct competitors rather than a universal ideal.
DSI and inventory turnover are inverses. Turnover = 365 / DSI, and DSI = 365 / Turnover. A turnover of 6x equals DSI of about 61 days. Many people find DSI more intuitive because it translates directly to "how many days of stock do I have."
Common causes include slowing sales demand, over-ordering, poor forecasting, supplier minimum order quantities that force excess purchases, seasonal inventory build-up, and product obsolescence. Investigate the specific cause before taking action, as the remedy differs for each.
DSI is one-third of the cash conversion cycle (CCC = DSI + DSO − DPO). Reducing DSI directly shortens the CCC, meaning you convert your investment to cash faster. If DSI drops from 60 to 45 days, you recover your cash 15 days sooner on every unit sold.
Average inventory provides the most accurate result. Using only beginning or ending inventory can be misleading if there's a significant change during the period. For best accuracy, use the average of monthly ending balances rather than just beginning and ending for the year.
Seasonal businesses naturally have higher DSI during inventory build-up periods and lower DSI during peak selling seasons. Track both the in-season and off-season DSI separately, and use rolling 12-month averages for trend analysis. Budget for higher carrying costs during build-up periods.