Days In Inventory Formula: How To Calculate & Improve It

Days in inventory—also known as average days in inventory—is a critical metric for fashion brands aiming to balance stock levels, reduce overstock, and stay responsive to fast-changing trends. It tells you how long, on average, it takes for your inventory to sell, directly impacting cash flow, warehousing costs, and profitability.

In the fashion industry, where styles shift quickly and seasonal demand can make or break a collection, holding inventory for too long can lead to markdowns or dead stock. In fact, according to McKinsey, fashion retailers that optimize inventory turnover see up to 10% higher margins compared to slower-moving peers.

In this blog, we’ll break down:

• What days in inventory really means
• The formula to calculate it
• A simple fashion-specific example
• And how to improve it to stay ahead in a competitive retail space

‍

What Is Days in Inventory?

Days in inventory is a financial and operational metric that shows the average number of days it takes for a business to sell its entire inventory during a specific period. It reflects how efficiently a company is managing its stock.

In simpler terms, it answers the question:
"How long does it take for your products to sell once they arrive in stock?"

For fashion brands, this metric is especially crucial. Unlike other industries, fashion deals with perishable demand—styles go out of trend quickly, and unsold stock often leads to markdowns or waste. A high days in inventory value can indicate slow-moving items, overstocking, or inaccurate demand forecasting.

On the other hand, a lower number means faster turnover, which is often a sign of efficient inventory management and stronger alignment with customer demand.

Stat to consider: Research by Edited found that fashion retailers discount over 40% of their products due to poor sell-through rates—often caused by holding inventory too long.

‍

Days in Inventory Formula

To calculate how many days it takes to sell your average inventory, use this standard formula:

Days in Inventory = (Average Inventory ÷ Cost of Goods Sold) × 365

Let’s break it down:

• Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2
• COGS (Cost of Goods Sold) = The total cost to produce or purchase the products sold during the period
• 365 = Days in a year (or use 90 for a quarterly view)

‍

How to Calculate Days in Inventory (Step-by-Step with An Example)

To calculate days in inventory, follow this two-step process using your inventory and COGS data. Here’s a fashion-specific example to guide you.

Example Scenario:

You operate a direct-to-consumer fashion brand that sells seasonal collections. For the last financial year, here’s the data:

• Beginning Inventory: $120,000
• Ending Inventory: $80,000
• Cost of Goods Sold (COGS): $600,000

Step 1: Calculate Average Inventory

Use this formula:

Average Inventory = (Beginning Inventory + Ending Inventory) ÷ 2

Substitute the values:

Average Inventory = ($120,000 + $80,000) ÷ 2
Average Inventory = $200,000 ÷ 2 = $100,000

‍

Step 2: Use the Days in Inventory Formula

Days in Inventory = (Average Inventory ÷ COGS) × 365

Substitute the values:

Days in Inventory = ($100,000 ÷ $600,000) × 365
Days in Inventory = 0.1666 × 365
Days in Inventory ≈ 60.8 days

Final Result - Days In Inventory:

Your fashion brand takes approximately 61 days to sell through its average inventory.

Fashion Industry Insight: According to a McKinsey report, fashion retailers that reduce inventory days below 45 can see up to 30% higher EBIT margins, due to faster sell-through and lower discounting.

‍

How to Reduce Days in Inventory

Lowering your days in inventory helps brands become more agile, cut holding costs, and reduce end-of-season markdowns. Here are five actionable strategies to improve inventory turnover without sacrificing product availability.

‍1. Use Data-Driven Demand Forecasting

Fashion demand is unpredictable — trends, seasons, and even viral moments can spike or kill product interest overnight. Use a mix of historical sales, seasonal trends, and customer behavior data to forecast demand more accurately.

Modern fashion retailers integrate AI tools and predictive analytics to align purchasing with likely demand. These tools analyze POS data, returns, website behavior, and even social media signals to forecast demand at the SKU or style level.

For example, fast-fashion brands like Zara use data from retail stores and e-commerce daily to adjust supply decisions within days, keeping inventory days low.

‍

2. Improve Inventory Turnover with Smaller, More Frequent Orders

Large seasonal buys may feel cost-efficient but often lead to dead stock. Instead, shift to smaller, more frequent ordering cycles based on rolling sales data.

This agile approach allows brands to test what sells, restock only the winners, and avoid long holding periods. It’s especially effective for online fashion retailers or those managing drops and capsule launches.

This strategy reduces the risk of holding outdated or unsellable inventory for too long, which directly lowers your average days in inventory.

‍

3. Launch Capsule or Limited Collections

Short-run, trend-driven capsule collections generate urgency among shoppers and help maintain high sell-through rates. They also limit the risk of overproducing styles that may fall out of trend mid-season.

By launching 4–6 smaller drops annually instead of 2–3 large seasonal collections, you can reduce idle inventory and respond faster to trend changes. It’s also great for building hype and customer engagement.

Brands like Supreme and Fear of God Essentials use limited drops not just for branding — but also to keep inventory cycles lean and fast-moving.

‍

4. Adopt Fashion-Focused Inventory Management Software

Manual spreadsheets can’t keep up with today’s fast-paced fashion cycles. Use inventory management software tailored for fashion that helps track inventory by size, color, SKU, and location in real time.

Features like automated reorder points, dead stock alerts, and sales velocity dashboards give you visibility into what’s moving and what’s not. Some tools even integrate with eCommerce platforms and supply chain systems for seamless stock coordination.

This ensures you're only holding what you need — reducing both excess stock and average days in inventory.

‍

5. Optimize Replenishment Based on Real-Time Sales

Instead of reordering all products equally, focus your replenishment strategy on high-performing SKUs and trending styles. Set up rules to replenish only the items that meet certain sales velocity or profit thresholds.

Regularly review stock performance on a weekly basis, and use A/B testing to optimize depth and width across categories. Paired with smart markdowns or bundling for slower SKUs, this helps keep your inventory moving consistently.

Stat Insight: According to Boston Consulting Group, fashion retailers who optimize their replenishment strategies can cut inventory-related costs by up to 25% and improve working capital.

‍

Why Days in Inventory Matters (Especially for Fashion Brands)

Days in inventory is a crucial key performance indicator (KPI) for both financial health and operational efficiency. The importance of this metric can be understood through the following points:

1. Impacts Cash Flow and Working Capital

Excess inventory ties up capital that could otherwise be allocated to marketing initiatives, product development, or launching new collections. The longer inventory remains unsold, the more it restricts cash flow and consumes valuable warehouse space.

For example, a luxury fashion retailer with an average of 90 days in inventory may have millions of dollars tied up in unsold stock, whereas a more efficient brand maintaining an average of 40 days in inventory can reinvest capital more rapidly.

‍

2. Improves Sell-Through Rates and Reduces Markdowns

Fashion is a highly trend-sensitive industry where styles can become obsolete within weeks. Reducing days in inventory decreases reliance on discounting or clearance sales to move products, thus protecting margins.

According to industry data, over 40% of fashion items are eventually sold at a discount due to slow inventory turnover (source: Edited, 2023).

‍

3. Enables Agile Merchandising

A lower days in inventory allows brands to respond swiftly to emerging consumer trends and real-time sales data. This agility is particularly important for direct-to-consumer and fast-fashion brands, where speed-to-market is a competitive advantage.

‍

4. Reduces Holding Costs and Storage Risks

Longer inventory cycles increase warehousing costs, heighten the risk of product damage or obsolescence, and compress profit margins. Maintaining a tighter inventory turnover improves operational efficiency and reduces overhead expenses.

‍

5. Strengthens Investor and Stakeholder Confidence

Investors, retail buyers, and other stakeholders closely monitor inventory metrics. A low days in inventory figure signals an efficient, demand-responsive operation, which is vital for securing investment and establishing retail partnerships.

‍

Conclusion

Now that you understand how to calculate and interpret days in inventory, it’s time to apply this knowledge to your fashion business. Start by analyzing your current inventory metrics and identifying areas for improvement. Implement data-driven forecasting and agile replenishment strategies to reduce inventory holding times. Taking these steps will help you optimize cash flow, minimize markdowns, and enhance overall operational efficiency.

‍

Advanced FAQs for Days in Inventory (Fashion Focus)

Q1. How does days in inventory affect supply chain efficiency in fashion?

Days in inventory directly impacts supply chain speed and flexibility. Lower days mean faster turnover, enabling brands to respond quickly to trends and reduce lead times in production and distribution.

‍

Q2. What’s the difference between days in inventory and inventory turnover ratio?

Days in inventory measures the average days items remain in stock, while inventory turnover ratio shows how many times inventory is sold and replaced over a period. Both metrics help evaluate inventory efficiency but from different angles.

‍

Q3. How do seasonal fashion cycles impact days in inventory calculations?

Seasonality can cause fluctuations in inventory levels and sales velocity, so days in inventory should be analyzed within the context of peak and off-peak periods to get accurate insights.

‍

Q4. How can AI and machine learning improve days in inventory management?

AI models analyze vast datasets including sales trends, consumer behavior, and external factors to predict demand more accurately, optimize stock levels, and reduce days in inventory.

‍

Q5. What role does product assortment planning play in managing days in inventory?

Effective assortment planning ensures the right mix of SKUs to meet demand without overstocking, helping fashion brands maintain lower days in inventory by focusing on high-velocity items.

‍

Q6. Can dropshipping or just-in-time manufacturing lower days in inventory for fashion brands?

Yes, dropshipping and just-in-time production reduce the need to hold large stock, lowering days in inventory by syncing supply closely with actual demand.

‍

Q7. How do return rates influence days in inventory in fashion retail?

High return rates increase inventory holding as returned items need processing and restocking, which can inflate days in inventory if not managed efficiently.