# Inventory Turnover & DSI Calculator Calculate inventory turnover ratio, days sales in inventory, and carrying costs to see how efficiently stock moves through your business. --- - **Canonical URL:** https://dothecalculation.com/calculators/inventory-turnover-calculator - **Category:** Business tools - **Publisher:** Do The Calculation (https://dothecalculation.com) - **Cost:** Free, no account or sign-up required - **Privacy:** Runs entirely in the browser; inputs are never sent to a server - **Methodology:** https://dothecalculation.com/methodology --- ## Analyze inventory turnover and days sales in inventory (DSI) Input your cost of goods sold (COGS) and inventory levels to estimate your turnover ratio, stock holding days, and annual carrying costs. - Inventory turnover ratio calculation - Days Sales in Inventory (DSI) - Carrying cost percentage estimates ## The Importance of Inventory Turnover in Operations For retailers, wholesalers, and supply chain managers, monitoring inventory performance is essential for maintaining liquidity. Inventory turnover measures how many times a business sells and replaces its stock over a given period, typically a year. A high inventory turnover ratio indicates that products are selling quickly, minimizing capital tied up in warehouses. Conversely, a low turnover ratio suggests slow sales, weak market demand, or poor inventory buying strategies. To calculate the inventory turnover ratio, divide the Cost of Goods Sold (COGS) by the average inventory level. COGS represents the wholesale cost of products sold, which is used instead of retail revenue to avoid price markup distortions. ## Calculating Days Sales in Inventory (DSI) and Working Capital Days Sales in Inventory (DSI), also known as inventory holding days, measures the average number of days it takes for a business to convert its inventory into sales. It represents the liquidity timeline of physical stock assets. DSI is calculated by dividing 365 by the inventory turnover ratio. For example, a retail shop with an inventory turnover of 6.0 has a DSI of approximately 61 days, meaning it keeps about two months of sales in stock. A high DSI ties up critical business cash flow in unpaid stock. Companies can use a [working capital calculator](/calculators/working-capital-calculator) to evaluate how DSI impacts total liquidity, or run a [break-even calculator](/calculators/break-even-calculator) to plan target sales volume. ## Managing the True Carrying Cost of Inventory Keeping excess inventory in a warehouse is not free. Inventory carrying costs represent the hidden expenses of holding unsold stock, including warehouse rent, utility bills, insurance, logistics labor, depreciation, and obsolescence. Historically, the annual cost of carrying inventory ranges from 20% to 30% of its average value. A standard industry baseline of 25% is used to estimate carrying costs. If you hold $100,000 of average stock, it costs about $25,000 annually. To minimize carrying costs, businesses adopt lean inventory management, drop-shipping models, or just-in-time (JIT) ordering. By increasing turnover, you can release cash for marketing or product development without increasing sales. ## How to Use This Calculator Enter your annual cost of goods sold (COGS), beginning inventory value, and ending inventory value. Adjust the carrying cost rate if you know your actual annual holding cost percentage (the default is the 25% industry baseline). The calculator averages your beginning and ending inventory, divides COGS by that average for your turnover ratio, converts turnover into days sales in inventory (DSI), and multiplies average inventory by the carrying cost rate for your annual holding cost. ## Worked Example: $240,000 COGS A retailer reports $240,000 in annual COGS, with $35,000 of beginning inventory and $25,000 of ending inventory, using the default 25% carrying cost rate. Average inventory: ($35,000 + $25,000) ÷ 2 = $30,000. Turnover ratio: $240,000 ÷ $30,000 = 8x per year. DSI: 365 ÷ 8 ≈ 45.6 days. Annual carrying cost: $30,000 × 25% = $7,500 — the yearly cost of holding that stock on top of what it cost to buy. ## Related Calculators See the full cost breakdown behind that 25% carrying rate with the [inventory carrying cost calculator](/calculators/inventory-carrying-cost-calculator), and combine DSI with receivables and payables timing in the [cash conversion cycle calculator](/calculators/cash-conversion-cycle-calculator). ## Frequently asked questions ### What is inventory turnover? A financial ratio showing how many times a company has sold and replaced its inventory over a specific period, usually a year. ### How is inventory turnover ratio calculated? It is calculated by dividing Cost of Goods Sold (COGS) by Average Inventory. ### What is Days Sales in Inventory (DSI)? The average number of days it takes to turn inventory into sales, calculated as 365 divided by the inventory turnover ratio. ### Why is COGS used instead of revenue for inventory turnover? Revenue includes retail profit markups, while inventory is recorded at cost. Using COGS ensures an accurate cost-to-cost comparison. ### What is a good inventory turnover ratio? A good ratio varies by industry. For grocery stores, 12 to 20 is typical, while for luxury watchmakers, 1 to 2 is standard. ### What are inventory carrying costs? The total expenses of storing unsold stock, including warehousing fees, insurance, labor, damage, and capital opportunity cost. ### How is average inventory calculated? It is the average of the beginning inventory and ending inventory values for a given period: (Beginning + Ending) / 2. ### What does a low inventory turnover ratio mean? It indicates slow sales, overstocking, or obsolete inventory, which ties up cash and increases warehousing costs. ### What does a high inventory turnover ratio mean? It suggests strong sales or tight inventory management. However, extremely high turnover can lead to stockouts and lost customers. ### How is DSI related to cash flow? Lower DSI means stock converts to cash faster, shortening the cash conversion cycle and freeing up working capital. ### Does inventory depreciation affect turnover? Yes, if you write down obsolete stock, ending inventory values drop, which increases the reported turnover ratio. ### How often should businesses run this calculation? Product managers should compute inventory turnover quarterly or annually, and review fast-moving SKU metrics monthly. ## Related concepts - **Average Inventory** — The average value of stock held during a specific time interval. - **Cost of Goods Sold (COGS)** — The direct costs of purchasing or manufacturing the products sold by a business. - **Days Sales in Inventory (DSI)** — The average time in days required to convert inventory into sales. ## Related guides - [Break-Even Analysis: Formula, Example, and Calculator](https://dothecalculation.com/blog/business/break-even-analysis) — Calculate break-even units and revenue from fixed costs, selling price, and variable cost, then test how pricing or cost changes affect the result. ## Related calculators - [Days Sales Outstanding (DSO) Calculator](https://dothecalculation.com/calculators/days-sales-outstanding-calculator) — Calculate Days Sales Outstanding and accounts receivable turnover ratio to measure how efficiently your business collects customer payments. - [Working Capital & Liquidity Calculator](https://dothecalculation.com/calculators/working-capital-calculator) — Measure business liquidity with working capital, current ratio, quick ratio, cash ratio, and Days Inventory Outstanding calculations. - [Retail Open-to-Buy (OTB) Planner](https://dothecalculation.com/calculators/open-to-buy-calculator) — Plan monthly inventory purchasing budgets from sales forecasts, markdowns, and inventory targets to avoid overstock and stockouts. - [Break-Even Calculator](https://dothecalculation.com/calculators/break-even-calculator) — Calculate the exact units or revenue needed to cover fixed and variable costs and find your break-even point before turning a profit. - [Depreciation Calculator](https://dothecalculation.com/calculators/depreciation-calculator) — Estimate annual and accumulated depreciation of business assets using straight-line or declining balance methods for accurate accounting. - [Debt Service Coverage Ratio (DSCR) Calculator](https://dothecalculation.com/calculators/dscr-calculator) — Calculate Debt Service Coverage Ratio and surplus cash flow to analyze your ability to repay loans and qualify for new financing. --- _This calculator is for educational and business planning purposes only and does not constitute professional financial, tax, or legal advice. Verify all rates, margins, and contract terms before making operational business decisions._ --- _Source: [Do The Calculation](https://dothecalculation.com/calculators/inventory-turnover-calculator). Quote freely with attribution and a link to this page._