Once you have stock turn, the other related metric is Days in Stock.
What Is Days in Stock?
Days in stock (also called days inventory outstanding, days sales of inventory, or DSI) is a financial metric that measures how long, on average, a company holds inventory before selling it. It answers one of the most important questions in operations: how efficiently is your business converting stock into revenue?
Whether you run a retail shop, a manufacturing plant, or an e-commerce store, days in stock is a core indicator of working capital efficiency and supply chain health.
Days in Stock Formula
The most common formula for calculating days in stock is:
Days in Stock = (Average Inventory ÷ Cost of Goods Sold) × Number of Days
Where:
- Average Inventory = (Opening Inventory + Closing Inventory) ÷ 2
- Cost of Goods Sold (COGS) = total direct costs of producing or purchasing goods sold during the period
- Number of Days = the length of the period (365 for annual, 90 for quarterly, etc.)
Alternative Formula
Some analysts calculate it as the inverse of inventory turnover:
Days in Stock = Number of Days ÷ Inventory Turnover Ratio
Where Inventory Turnover = COGS ÷ Average Inventory
Both methods produce the same result.
Days in Stock Example Calculation
Suppose a business has:
- Opening inventory: $120,000
- Closing inventory: $80,000
- Annual COGS: $800,000
Step 1 — Average Inventory: ($120,000 + $80,000) ÷ 2 = $100,000
Step 2 — Days in Stock: ($100,000 ÷ $800,000) × 365 = 45.6 days
This means, on average, the business holds each item in stock for approximately 46 days before selling it.
Why Days in Stock Matters
Days in stock is not just a theoretical number — it has real, direct consequences for your business’s profitability, cash flow, and competitiveness.
1. Cash Flow Impact
Inventory sitting in a warehouse is cash that isn’t working for you. A high days-in-stock figure means capital is tied up in unsold goods rather than being reinvested in growth, marketing, or operations. Reducing days in stock frees up liquidity.
2. Storage and Holding Costs
Every additional day inventory sits in your facility, it incurs costs: warehousing fees, insurance, labour, and the risk of damage or theft. These holding costs typically run between 20–30% of inventory value annually, according to supply chain experts.
3. Obsolescence and Spoilage Risk
For industries dealing in perishable goods, fashion, technology, or seasonal products, slow-moving inventory carries serious risk of becoming unsaleable. A lower days-in-stock figure dramatically reduces this exposure.
4. Supplier Relationships and Buying Power
Companies with efficient inventory turnover often negotiate better terms with suppliers because they order more frequently and reliably, demonstrating demand predictability.
5. Investor and Lender Confidence
Analysts and lenders use days in stock alongside other metrics to assess operational efficiency. A rising days-in-stock trend can signal trouble ahead, while a declining figure suggests improving management.
What Is a Good Days in Stock Number?
There is no universal “good” days-in-stock figure — it varies significantly by industry, business model, and product type.
| Industry | Typical Days in Stock |
|---|---|
| Grocery / Food Retail | 5–15 days |
| Fast Fashion / Apparel | 30–60 days |
| Electronics Retail | 25–50 days |
| Automotive (Dealerships) | 45–90 days |
| Manufacturing (Industrial) | 60–120 days |
| Pharmaceuticals | 30–60 days |
| Luxury Goods | 90–180+ days |
Key insight: A lower number is generally better, but too low can indicate stockout risk — where you don’t have enough inventory to meet demand, leading to lost sales and customer dissatisfaction.
Days in Stock vs. Inventory Turnover: What’s the Difference?
These two metrics are inverses of each other and measure the same thing from different angles:
- Inventory Turnover tells you how many times per year you cycle through your inventory. Higher is generally better.
- Days in Stock tells you how many days each unit sits before being sold. Lower is generally better.
A business with an inventory turnover of 8 has a days-in-stock figure of approximately 45.6 days (365 ÷ 8).
Both are useful — turnover is often preferred for annual comparisons, while days in stock is more intuitive for operational planning.
How to Reduce Days in Stock
Reducing your days-in-stock figure requires a combination of demand forecasting, purchasing discipline, and operational execution. Here are the most effective strategies:
1. Improve Demand Forecasting
Accurate forecasting is the single most powerful lever. By understanding seasonal trends, customer behaviour, and promotional impact, you can align purchasing more closely with actual demand — reducing both overstock and stockouts.
Tools to consider: AI-powered demand planning software, historical sales analysis, and point-of-sale data integration.
2. Implement Just-in-Time (JIT) Inventory
JIT purchasing involves ordering stock only when it’s needed, rather than maintaining large safety buffers. While it requires reliable suppliers and lead time visibility, it can dramatically cut average inventory levels.
3. Conduct Regular ABC Analysis
ABC analysis categorises inventory into three tiers:
- A items: High-value, high-velocity — prioritise availability
- B items: Mid-range — moderate management
- C items: Low-value, slow-moving — candidates for reduction or discontinuation
Focusing clearance and purchasing strategy on C items often yields the fastest improvements in days-in-stock performance.
4. Optimise Reorder Points and Safety Stock
Using data-driven reorder points — rather than gut feel or arbitrary buffers — ensures you replenish just enough stock to meet demand during lead time, without over-ordering.
5. Run Promotions on Slow-Moving Stock
Discounting, bundling, or running targeted promotions on aged inventory converts dead stock into cash, preventing write-offs and improving your days-in-stock average.
6. Strengthen Supplier Lead Times
Negotiate faster, more frequent deliveries with key suppliers. Shorter lead times mean you can maintain smaller inventory buffers while still meeting customer demand.
7. Adopt Inventory Management Software
Modern inventory platforms provide real-time visibility, automated reorder alerts, and performance dashboards — making it far easier to monitor and manage days in stock across multiple SKUs, locations, or channels.
Days in Stock in Different Business Contexts
E-commerce
Online retailers face intense price competition and high customer expectations for availability. Monitoring days in stock by SKU and channel allows e-commerce businesses to prevent both costly overstock and damaging stockouts.
Retail
Brick-and-mortar retailers must balance floor space (a limited and expensive resource) with stock availability. Days in stock at the category level helps buyers make faster markdown decisions and smarter replenishment calls.
Manufacturing
Manufacturers track raw material, work-in-progress (WIP), and finished goods separately. Each stage has its own days-in-stock benchmark, and bottlenecks at any stage can inflate the overall figure.
Distribution and Wholesale
Distributors operate on thin margins, making inventory efficiency critical. Reducing days in stock directly improves return on investment and allows for more competitive pricing.
Days in Stock and the Cash Conversion Cycle
Days in stock is one of three components of the Cash Conversion Cycle (CCC) — a broader measure of how efficiently a business converts its investments in inventory and other resources into cash flows:
CCC = Days in Stock + Days Sales Outstanding (DSO) − Days Payable Outstanding (DPO)
- DSO: How long it takes to collect payment from customers after a sale
- DPO: How long the business takes to pay its own suppliers
A lower CCC indicates a more efficient, cash-generative operation. Improving days in stock is often the fastest way to reduce the CCC, since it’s the component most directly under operational control.
Common Mistakes When Interpreting Days in Stock
1. Ignoring seasonal variation Comparing days in stock across seasons without adjustment can be misleading. A retailer in December may carry more stock than in February — this is intentional, not inefficient.
2. Averaging across all SKUs A blended average can hide serious problems. A single slow-moving product category can inflate your overall figure, masking strong performance elsewhere. Always analyse at the category or SKU level.
3. Chasing low numbers at the expense of service levels Obsessing over days in stock without tracking stockout rates or customer service levels can lead to under-stocking — which damages revenue and customer satisfaction.
4. Using outdated data Days in stock calculated from quarterly snapshots can lag reality. Real-time or weekly data gives a far more actionable picture, especially in fast-moving categories.
Key Takeaways
- Days in stock measures how long inventory is held before being sold — a core indicator of operational efficiency and cash flow health.
- The formula is: (Average Inventory ÷ COGS) × Days in Period
- Benchmarks vary significantly by industry — always compare within your sector.
- Lower is generally better, but excessively low figures can signal stockout risk.
- The most effective ways to reduce days in stock include better demand forecasting, JIT purchasing, ABC analysis, and investing in inventory management tools.
- Days in stock is one component of the Cash Conversion Cycle — improving it has a direct, positive impact on your overall financial efficiency.