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.

Ready to turn inventory
metrics into smarter actions?

Style levelSell-through with OOS days —
adjusted,Gross margin, ageing etc.

Start for Free →

No credit/debit card required • Cancel anytime

‍

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.

Ready to turn inventory
metrics into smarter actions?

Style levelSell-through with OOS days —
adjusted,Gross margin, ageing etc.

Start for Free →

No credit/debit card required • Cancel anytime

‍

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.

Ready to turn inventory
metrics into smarter actions?

Style levelSell-through with OOS days —
adjusted,Gross margin, ageing etc.

Start for Free →

No credit/debit card required • Cancel anytime