Definition
Days in Inventory (DII) is an inventory efficiency metric that estimates the average number of days a company holds inventory before it is sold. It is used to evaluate how efficiently a business converts inventory into sales and, ultimately, cash. NetSuite describes DII as a metric that measures how long it takes a business to generate sales equal to the value of its inventory.
DII is closely related to Days Inventory Outstanding (DIO), Days Sales of Inventory (DSI), Days of Inventory (DOI), Days on Hand (DOH), and Inventory Days of Supply. In many business contexts, these terms are used interchangeably, although different teams may use slightly different wording depending on whether they are working in finance, operations, supply chain, retail, or inventory planning. APQC notes that inventory days of supply is also known as “days cost-of-sales in inventory” and “days sales in inventory.”
In marketing, DII matters because inventory efficiency affects product availability, campaign readiness, merchandising, promotional planning, fulfillment promises, and customer experience. Marketing can create demand, but DII helps determine whether the company has the right amount of inventory to meet that demand without creating excess stock. Inventory has a habit of turning a confident campaign plan into a very quiet meeting.
How Days in Inventory Relates to Marketing
Days in Inventory connects demand creation with inventory reality. If DII is too high, inventory may be moving slowly, which can tie up working capital and increase the risk of markdowns, obsolescence, or storage costs. If DII is too low, inventory may be moving quickly, but the business may also be exposed to stockouts, missed sales, and poor customer experiences.
DII supports marketing in several ways:
- Campaign planning: DII helps determine whether inventory can support planned demand from promotions, launches, paid media, email campaigns, retail media, or seasonal events.
- Promotion targeting: High DII may indicate products that need additional demand generation, bundling, merchandising, or discounting.
- Product suppression: Low DII can signal that products should be removed from campaigns or shown only to limited audiences to avoid stockouts.
- Customer experience: DII helps reduce the risk of canceled orders, backorders, delayed fulfillment, and support inquiries.
- Margin management: DII can help marketers avoid unnecessary discounts on fast-moving products and apply targeted offers to slow-moving inventory.
- Merchandising: DII can identify products that need better placement, improved content, revised pricing, or assortment review.
- Lifecycle marketing: DII can inform low-stock messages, back-in-stock alerts, replenishment campaigns, cross-sell recommendations, and win-back offers.
- Omnichannel planning: DII by location can guide local promotions, ship-from-store decisions, store pickup availability, and inventory transfers.
Corporate Finance Institute describes DIO as a measure of inventory management effectiveness and inventory liquidity, noting that a shorter DIO means inventory is converted to cash more quickly, while a higher DIO can indicate weaker inventory liquidity.
How to Calculate Days in Inventory
The standard formula for Days in Inventory is:
DII = Average Inventory ÷ Cost of Goods Sold × Number of Days in Period
For an annual calculation:
DII = Average Inventory ÷ Annual COGS × 365
| Variable | Meaning |
|---|---|
| Average Inventory | Average inventory value during the period |
| Cost of Goods Sold | Cost of inventory sold during the same period |
| Number of Days | Number of days in the measurement period, commonly 365, 90, or 30 |
APQC calculates inventory days of supply as average inventory value at standard cost divided by annual COGS divided by 365. This is equivalent to dividing average inventory by average daily COGS.
Example:
| Input | Value |
|---|---|
| Beginning inventory | $800,000 |
| Ending inventory | $1,000,000 |
| Average inventory | $900,000 |
| Annual COGS | $4,500,000 |
| Days in period | 365 |
| DII calculation | $900,000 ÷ $4,500,000 × 365 |
| DII result | 73 days |
In this example, the company holds approximately 73 days of inventory.
DII can also be calculated using inventory turnover:
DII = Number of Days in Period ÷ Inventory Turnover
Where:
Inventory Turnover = Cost of Goods Sold ÷ Average Inventory
Investopedia describes DSI as the reciprocal of inventory turnover multiplied by 365, and notes that it measures the average time in days a company takes to sell its inventory.
How to Interpret Days in Inventory
DII should be interpreted in context. A high DII may indicate slow-moving inventory, excess production, weak demand, poor forecasting, or planned seasonal buildup. A low DII may indicate strong sales velocity, efficient inventory management, or potential stockout risk.
| DII Pattern | Possible Interpretation | Marketing Implication |
|---|---|---|
| DII is decreasing | Inventory is moving faster | Monitor stockout risk before increasing campaign spend |
| DII is increasing | Inventory is moving more slowly | Consider targeted promotions, bundles, or merchandising changes |
| DII is very low | Inventory may be constrained | Suppress products, limit audiences, or promote substitutes |
| DII is very high | Overstock or slow-moving inventory may exist | Consider offers, markdowns, channel expansion, or product repositioning |
| DII varies by SKU | Product-level demand differs significantly | Manage campaigns and recommendations at the product level |
| DII varies by location | Inventory is unevenly distributed | Use localized promotions, transfers, or fulfillment adjustments |
| DII rises after a campaign | Demand response was weaker than forecast | Review offer, audience, creative, pricing, or product-market fit |
| DII falls sharply after a campaign | Demand exceeded expectations | Replenish, manage expectations, or prepare substitute recommendations |
NetSuite notes that DII requires context and other metrics to be useful because it does not capture every factor needed for inventory decisions. Investopedia similarly notes that DSI standards vary by industry, so comparisons should be made within the same sector rather than across unlike businesses.
How to Utilize Days in Inventory
Days in Inventory can be used by marketing, merchandising, supply chain, finance, commerce, and operations teams.
Common use cases include:
- Campaign readiness: Confirm that inventory can support expected demand before launching a major campaign.
- Promotion planning: Identify high-DII products that may need offers, bundles, email placement, paid media, or retail media support.
- Product suppression: Reduce visibility of low-DII products to avoid overselling or customer disappointment.
- Markdown planning: Use high DII to identify products that may require discounting before they become obsolete or out of season.
- Assortment management: Identify products that should be expanded, repositioned, discontinued, or replaced.
- Localized marketing: Promote products in regions where DII is high and avoid driving demand where inventory is constrained.
- Back-in-stock campaigns: Trigger campaigns when replenishment improves inventory coverage.
- Low-stock messaging: Use low DII as a signal for urgency messaging when inventory levels are accurate.
- Retail media governance: Avoid spending media dollars on products that lack enough inventory to support demand.
- Customer journey orchestration: Use DII as an input for next-best-action, product recommendations, substitute offers, replenishment reminders, and service recovery.
- Supplier planning: Use DII trends to inform purchase quantities, reorder timing, and supplier negotiations.
- Working capital management: Identify inventory that is tying up cash and may require commercial action.
For example, if a retailer has 130 DII on a seasonal item with 40 days left in the season, marketing may need to accelerate demand through targeted offers or bundling. If a hero product has 6 DII and a large campaign is planned, the campaign may need to be delayed, geographically limited, or redirected toward alternatives.
Comparison to Similar Metrics
| Metric | Definition | Formula | Relationship to DII | Marketing Relevance |
|---|---|---|---|---|
| Days in Inventory | Average number of days inventory is held before sale | Average Inventory ÷ COGS × Days | Core inventory duration metric | Helps align campaigns with inventory depth |
| Days Inventory Outstanding | Average number of days inventory remains before sale | Average Inventory ÷ COGS × Days | Often used interchangeably with DII | Useful for liquidity and operational efficiency |
| Days Sales of Inventory | Average time required to sell inventory | Average Inventory ÷ COGS × Days | Often used interchangeably with DII | Helps evaluate sales and inventory efficiency |
| Days of Inventory | Number of inventory days represented by current or average stock | Average Inventory ÷ COGS × Days | Often used interchangeably with DII | Supports inventory planning and campaign readiness |
| Days on Hand | Number of days current inventory can support demand or usage | Inventory ÷ Average daily usage or COGS | Similar, often more operational | Helps evaluate supply coverage |
| Inventory Days of Supply | Inventory expressed in days of sales | Inventory ÷ Average daily COGS | Similar to DII | Used for benchmarking and supply planning |
| Inventory Turnover | Number of times inventory is sold and replaced during a period | COGS ÷ Average Inventory | Inverse of DII | Identifies fast- and slow-moving inventory |
| Sell-Through Rate | Share of received inventory sold during a period | Units Sold ÷ Units Received × 100 | Unit-based complement to DII | Useful for campaign and merchandising analysis |
| Stockout Rate | Frequency of inventory unavailability | Stockout Events ÷ Demand Events × 100 | Low DII may increase stockout risk | Measures lost sales and customer friction |
| Reorder Point | Inventory level that triggers replenishment | Demand During Lead Time + Safety Stock | Helps manage future DII | Supports campaign and fulfillment reliability |
Best Practices
- Calculate DII at the right level. Company-wide DII can be useful for finance, but marketers usually need DII by SKU, category, location, channel, or campaign.
- Use average inventory. Average inventory provides a better period view than a single ending inventory balance.
- Use COGS, not revenue. DII is typically based on inventory cost and cost of goods sold, not sales revenue.
- Compare similar categories. A suitable DII for grocery will differ from apparel, electronics, furniture, luxury goods, or industrial equipment.
- Account for seasonality. High DII may be intentional before a seasonal peak and problematic after that peak has passed.
- Connect DII to campaign calendars. Marketing should know whether inventory levels can support planned demand before campaigns launch.
- Pair DII with service levels. Lower inventory is not automatically better if it leads to stockouts, delayed delivery, or poor customer experience.
- Use DII with lead times. A product with 20 DII and a 90-day supplier lead time may still be at risk.
- Monitor trends over time. Direction and rate of change are often more useful than a single DII value.
- Segment by margin and strategic value. High-margin, strategic, or customer-acquisition products may justify different DII targets.
- Coordinate with replenishment teams. Campaign plans should reflect purchase orders, inbound inventory, supplier capacity, and fulfillment constraints.
- Use supporting metrics. Combine DII with inventory turnover, sell-through rate, stockout rate, gross margin, forecast accuracy, return rate, and customer satisfaction.
Future Trends
- Inventory-aware marketing automation: Marketing platforms will increasingly use DII to suppress constrained products, prioritize overstocked products, and trigger lifecycle messaging.
- AI-assisted demand planning: AI models will use DII alongside seasonality, campaign calendars, supplier performance, and demand signals to recommend inventory and marketing actions.
- Real-time DII by location: Retailers will calculate DII across stores, warehouses, suppliers, 3PLs, and fulfillment partners.
- Dynamic campaign optimization: Campaign budgets, audiences, offers, and product recommendations will adjust based on inventory depth and replenishment timing.
- Retail media inventory controls: Retail media programs will increasingly check inventory availability before serving ads.
- Integration with distributed order management: DII will inform available-to-promise, ship-from-store logic, pickup availability, and order routing.
- Sustainability-focused inventory planning: DII will support efforts to reduce overproduction, spoilage, markdown waste, storage waste, and emergency replenishment.
- Scenario planning for promotions: Teams will model conservative, expected, and high-demand outcomes before major campaigns.
- More granular working capital analysis: DII will be evaluated by SKU, supplier, channel, market, customer segment, and fulfillment node.
- Customer-experience-linked inventory metrics: DII will be analyzed alongside cancellations, delivery delays, substitutions, support contacts, reviews, and repeat purchase behavior.
Related Terms
- Economic Order Quantity (EOQ)
- Inventory Management System (IMS)
- Days in Inventory (DII)
- Days of Inventory (DOI)
- Days on Hand (DOH)
- Days Inventory Outstanding
- Days Sales of Inventory
- Inventory Days of Supply
- Inventory Turnover
- Sell-Through Rate
- Stockout Rate
- Safety Stock
- Reorder Point
Sources
- NetSuite. “Days in Inventory (DII) Defined: How to Calculate.” https://www.netsuite.com/portal/resource/articles/inventory-management/days-in-inventory.shtml
- Corporate Finance Institute. “Days Inventory Outstanding.” https://corporatefinanceinstitute.com/resources/accounting/days-inventory-outstanding-dio/
- Corporate Finance Institute. “Days Sales in Inventory.” https://corporatefinanceinstitute.com/resources/financial-modeling/days-sales-in-inventory/
- APQC. “Inventory days of supply.” https://www.apqc.org/resources/benchmarking/open-standards-benchmarking/measures/inventory-days-supply
- Investopedia. “Days Sales of Inventory (DSI): Definition, Formula, and Importance.” https://www.investopedia.com/terms/d/days-sales-inventory-dsi.asp
- Investopedia. “Average Age of Inventory: Overview, Calculations.” https://www.investopedia.com/terms/a/average-age-of-inventory.asp
- DCL Logistics. “Days in Inventory (DII): How to Calculate & More.” https://dclcorp.com/blog/inventory/days-in-inventory-dii/