Days in Inventory Calculator

Enter your inventory value and annual cost of sales to calculate days in inventory, turnover rate, weekly stock cycle, and capital efficiency metrics.

Created by Luis GonzalezLast updated: June 21, 2026

How to Use This Calculator

1
Enter Inventory Value
Input the total dollar value of your current inventory on hand. This should be at cost, not retail price.
2
Enter Annual Cost of Sales
Provide the total annual Cost of Goods Sold (COGS) for your business. This is the direct cost attributable to the production of goods sold.
3
Review Inventory Metrics
The calculator displays Days in Inventory (DII), Inventory Turnover, Weeks in Inventory, Daily COGS, Inventory-to-Sales Ratio, and Capital Efficiency. The Insights panel shows carrying cost estimates, cash conversion analysis, and optimal stock level targets.

Example Calculation

A small business has $10,000 worth of inventory on hand and an annual Cost of Goods Sold (COGS) of $5,000. They need to assess their inventory efficiency.

Inventory Value

$10,000

Cost of Sales (Annual)

$5,000

Results

Days in Inventory

730.0 days

Inventory Turnover

0.50x per year

Weeks in Inventory

104.3 weeks

Daily COGS

$13.70

Inventory-to-Sales Ratio

2.00x

Capital Efficiency

50.0%

Tips

Benchmark Against Industry

Compare your Days in Inventory (DII) to industry averages. Grocery targets 10-20 days, fashion retail 45-90 days, automotive parts 120-180 days. A DII significantly higher than competitors indicates overstocking.

Monitor Seasonal Fluctuations

DII can naturally fluctuate with seasonality. Analyze your DII over different periods (e.g., pre-holiday vs. post-holiday) to understand normal cycles and identify abnormal inventory build-ups.

Impact on Cash Flow

High DII ties up capital, reducing cash flow. At a typical 22% carrying cost, $10,000 in inventory costs $2,200/year to hold. Aim to optimize inventory levels to free up cash for other operational needs.

Optimizing Stock Management: The Days in Inventory Calculator

The Days in Inventory Calculator is a vital financial tool for businesses seeking to optimize their inventory management and enhance cash flow. It rapidly computes key metrics like Days in Inventory (DII), inventory turnover, and daily Cost of Goods Sold (COGS), providing actionable insights into stock efficiency. By understanding how long inventory sits before being sold, businesses can reduce carrying costs, minimize waste, and improve liquidity, crucial for maintaining competitiveness and profitability in 2026.

The Business Imperative of Inventory Efficiency

Efficient inventory management is a cornerstone of business profitability, directly impacting cash flow, operational costs, and customer satisfaction. Holding too much inventory (high Days in Inventory) ties up valuable capital that could be used for other investments, incurs storage costs, and increases the risk of obsolescence or damage. Conversely, holding too little inventory can lead to stockouts, lost sales, and dissatisfied customers. Striking the right balance ensures that products are available when needed without incurring excessive expenses, optimizing the entire supply chain from procurement to final sale.

The Days in Inventory Formula Explained

The Days in Inventory (DII) calculator uses a fundamental accounting formula to assess how quickly a business sells its stock. It relates the value of current inventory to the annual Cost of Goods Sold (COGS).

Days in Inventory (DII) = (Inventory Value / Annual Cost of Sales) × 365
Inventory Turnover = Annual Cost of Sales / Inventory Value
Daily COGS = Annual Cost of Sales / 365
Weeks in Inventory = DII / 7
Capital Efficiency = (Annual Cost of Sales / Inventory Value) × 100

Here, Inventory Value is the total cost of goods currently on hand, and Annual Cost of Sales (or COGS) represents the direct costs attributable to the production of goods sold over a year. The result indicates the average number of days inventory remains in stock before being sold.

💡 Efficient inventory management directly impacts profitability. For a broader view of your company's financial health, our Owner's Equity Calculator helps assess the residual claim on assets after liabilities are paid.

Assessing Inventory Efficiency: A Small Business Case Study

Let's consider a small retail business with the following financial data:

Inventory Value: $10,000
Annual Cost of Sales (COGS): $5,000

Here's how the Days in Inventory Calculator processes these inputs:

Calculate Days in Inventory (DII): DII = ($10,000 / $5,000) × 365 DII = 2 × 365 = 730 days
Calculate Inventory Turnover: Turnover = $5,000 / $10,000 = 0.50x per year
Calculate Daily COGS: Daily COGS = $5,000 / 365 = $13.70

The primary result shows a DII of 730.0 days. This indicates a very slow inventory turnover, suggesting significant overstocking or slow-moving products. Such a high DII would signal to the business owner that a critical review of purchasing, sales, and product lifecycle is needed.

💡 Understanding inventory metrics is crucial for business strategy. For companies with multiple partners, our Partnership Profit Distribution Calculator can help allocate earnings fairly based on agreed-upon terms.

Industry Benchmarks for Days in Inventory

Days in Inventory (DII) benchmarks vary widely across different industries due to diverse product lifecycles, supply chain complexities, and demand patterns. For example, a grocery store might aim for a DII of 10-20 days due to perishable goods and high turnover. A fashion retailer might target 45-90 days to manage seasonal collections. In contrast, an automotive parts distributor, dealing with a vast catalog of slower-moving, high-value items, might have an acceptable DII of 120-180 days. Manufacturing often falls in the 30-60 day range, depending on production lead times. Comparing your DII against these specific industry averages, rather than a generic benchmark, provides a more accurate assessment of your operational efficiency.

Understanding Days in Inventory Formula Variants

While the most common formula for Days in Inventory (DII) uses annual Cost of Goods Sold (COGS), there are variations and related metrics that provide additional insights. Sometimes, instead of annual COGS, the calculation uses Average Daily COGS = (Annual COGS / 365), making the formula DII = Inventory Value / Average Daily COGS. Another related metric is the Inventory Turnover Ratio = Annual COGS / Inventory Value, which is the inverse of DII (excluding the 365 factor). A higher turnover ratio indicates faster sales. Some businesses might also calculate DII using Average Inventory (the average of beginning and ending inventory for a period) instead of just current inventory, which can smooth out fluctuations and provide a more representative average for a longer period. Each variant serves to offer a slightly different perspective on inventory efficiency.

Frequently Asked Questions

What is Days in Inventory (DII) and why is it important for businesses?

Days in Inventory (DII), also known as Days Sales of Inventory, is a financial metric that measures the average number of days it takes for a company to sell its inventory. It is important because it indicates how efficiently a business is managing its stock. A high DII can signal overstocking, slow-moving goods, or inefficient sales, tying up capital and increasing carrying costs. A low DII suggests efficient inventory management and strong sales, but too low could risk stockouts.

How does Days in Inventory relate to inventory turnover ratio?

Days in Inventory (DII) and the inventory turnover ratio are inversely related metrics that both assess inventory efficiency. Inventory turnover ratio measures how many times a company sells and replaces its inventory over a period (e.g., annually). DII translates this turnover into the average number of days inventory sits before being sold. A higher turnover ratio means a lower DII, indicating faster sales and more efficient inventory management. For example, a turnover of 6x per year equates to a DII of 60.8 days (365/6).

What is a good Days in Inventory number?

A 'good' Days in Inventory (DII) number varies significantly by industry. For perishable goods or high-fashion retail, a DII of 30-60 days might be excellent, indicating rapid sales. For industries with longer production cycles or higher-value, slower-moving items (e.g., automotive parts, luxury goods), a DII of 90-180 days might be acceptable. The key is to compare your DII against industry benchmarks and your company's historical performance to determine what is optimal for your specific business context, aiming for the lowest number without risking stockouts.

How does DII affect working capital?

Every day inventory sits unsold represents capital that cannot be used elsewhere. For a business with $5,000 annual COGS, each day of inventory represents $13.70 in tied-up capital. Reducing DII from 730 days to 60 days would free up approximately $9,178 in working capital that could be reinvested in growth, debt reduction, or other operational needs.