Days in Stock Explained — Formula, Benchmarks, Mistakes & Real-World Examples
The number that tells you how long your cash sits on the shelf before it sells — definition, formula, worked example, and how three different retail businesses use it.
Days in stock — also called stock cover or days of inventory — measures how long, on average, a unit of inventory sits before it sells. Where stockturn tells you how many times inventory cycles over a year, days in stock translates that same information into a number planners can act on day-to-day: how many days of cover do I currently have, and is that too much or too little?
This guide covers the days in stock formula, a worked example, how to interpret the result, benchmark ranges by category, the most common mistakes planners make, and three real-world examples showing how days in stock looks different depending on the type of retail business.
For the full formula set, see the retail maths formula reference. Days in stock is the direct inverse of stockturn — if you haven't read that guide yet, it's a useful companion to this one.
01 — Definition
What Is Days in Stock?
Days in stock measures the average length of time, in days, that a unit of inventory remains on hand before it sells. It's the same information as stockturn, expressed in a unit that's easier to plan around.
Stockturn answers "how many times does my stock cycle in a year?" Days in stock answers a more intuitive question: "if I bought nothing else, how many days would my current stock last?" Both describe the same underlying relationship between inventory and sales — they're simply two different units for the same measurement, the way kilometres and miles describe the same distance.
Days in stock is particularly useful for operational planning. A buyer might struggle to act on "stockturn is 4.4×" — but "we're holding 83 days of stock" immediately translates into a concrete planning question: does 83 days line up with our reorder lead time, our season length, and our cash position?
02 — The Formula
The Days in Stock Formula
There are two equivalent ways to calculate it — directly from inventory and COGS, or by converting from stockturn.
Days in Stock — direct method
Days in Stock = (Average Inventory ÷ COGS) × 365
Both figures at cost. Multiplying by 365 converts the ratio into a number of days. Use 366 in a leap year if precision matters, though 365 is the standard convention.
$100,000 avg inventory ÷ $440,000 COGS × 365 = 83 days
Days in Stock — from stockturn
Days in Stock = 365 ÷ Stockturn
If you already have a stockturn figure, this is the fastest conversion. Useful for quickly translating a category's stockturn into a planning-friendly number in a meeting.
Stockturn 4.4× → 365 ÷ 4.4 ≈ 83 days
Average Inventory
Avg Inventory = (Opening Stock + Closing Stock) ÷ 2
Same calculation used in the stockturn formula. For more accuracy across longer periods, some businesses average 12 monthly closing figures rather than just opening and closing.
Days in Stock — for a shorter period
Days in Stock = (Avg Inventory ÷ COGS for period) × Days in Period
For a month rather than a year, replace 365 with the number of days in that month and use the period's COGS — not the annual figure. Mixing an annual COGS with a monthly average inventory produces a meaningless result.
03 — Worked Example
Worked Example — Calculating Days in Stock
Using the same womenswear category from the stockturn worked example, converted into days in stock.
| Opening inventory (at cost), 1 Jan | $120,000 |
| Closing inventory (at cost), 31 Dec | $80,000 |
| Average inventory ($120k + $80k) ÷ 2 | $100,000 |
| COGS for the year | $440,000 |
| Days in Stock = (Avg Inventory ÷ COGS) × 365 | ($100,000 ÷ $440,000) × 365 |
| Days in Stock | 83 days ✓ |
| Cross-check: Stockturn (COGS ÷ Avg Inventory) | 4.4× |
| Cross-check: 365 ÷ 4.4 | ≈ 83 days ✓ |
83 days of stock means this category holds, on average, about 12 weeks of inventory at any point in time. Whether that's appropriate depends on the category's reorder lead time, sell-through pattern, and season length — covered next.
04 — Interpretation
What Does the Days in Stock Number Actually Mean?
A days-in-stock figure is only useful when read against something — a lead time, a season length, or a trend over time.
Compare against reorder lead time
If your supplier lead time is 60 days and you're holding 83 days of stock, you have a 23-day buffer before you'd stock out while waiting for a reorder. If days in stock falls below your lead time, you're at risk of running out before replacement stock arrives.
Compare against season length
A seasonal category with a 16-week (112-day) selling window holding 83 days of stock at the start of the season is on track to sell through close to the end of the season — assuming a steady sell-through rate. The same 83 days at the season's midpoint signals a likely overhang.
Rising days in stock
More days of cover building up over time — inventory is growing faster than sales. This is the early-warning signal for markdown risk, and the same underlying movement as falling stockturn, just expressed in the opposite direction.
Falling days in stock
Cover is shrinking — sales are outpacing the rate stock is being replenished. Good news if intentional and matched by replenishment orders in the pipeline; a stockout risk if it's happening faster than the supply chain can respond.
05 — Benchmark Ranges
Days in Stock Benchmark Ranges by Category Type
These are the same categories from the stockturn benchmark table, expressed as days in stock — the inverse relationship means high-stockturn categories show low days in stock, and vice versa.
| Category / business type | Typical days in stock | Equivalent stockturn |
|---|---|---|
| Fast fashion / trend apparel | 30–45 days | 8–12× |
| Core / basics apparel | 60–90 days | 4–6× |
| Seasonal fashion (mid-market) | 75–120 days | 3–5× |
| Premium / occasionwear | 120–240 days | 1.5–3× |
| Footwear | 90–180 days | 2–4× |
| Homewares / furniture | 90–180 days | 2–4× |
| Supermarket / grocery (general) | 18–30 days | 12–20×+ |
As with stockturn, the most useful benchmark is usually your own category's trend over time or your closest comparable competitor — not a blanket industry figure. A premium category sitting at 150 days isn't automatically a problem; a core basics category sitting at 150 days almost certainly is.
06 — Live Calculator
Days in Stock Calculator
Enter your inventory and COGS figures (all at cost) to calculate days in stock and the equivalent stockturn.
07 — Case Study
Case Study: Fast Fashion — Operating With 30–45 Days of Stock
For fast fashion retailers, low days in stock isn't a side effect — it's a deliberate operating target enabled by short supplier lead times.
Fast fashion operators are widely reported to run trend categories with very low days in stock — often in the 30–45 day range, corresponding to the 8–12× stockturn range covered in the stockturn case studies. This is only possible because supplier lead times in fast fashion are also short, frequently in the 2–6 week range for regionally-sourced product.
| Average inventory (cost) | $240,000 |
| Annual COGS | $2,400,000 |
| Days in stock = ($240,000 ÷ $2,400,000) × 365 | 36.5 days ✓ |
| Typical supplier lead time | 28 days |
| Buffer (days in stock − lead time) | +8.5 days |
An 8.5-day buffer between days in stock and lead time is tight by most retail standards — but it's workable because the business has built real-time sell-through monitoring that triggers reorders the moment a style shows early sales velocity, rather than waiting for a scheduled review. The low days-in-stock figure is the output of that system, not something achieved by simply ordering less.
08 — Case Study
Case Study: Furniture Retailer — Why 120+ Days in Stock Can Be Normal
Big-ticket, low-frequency-purchase categories naturally carry far more days of stock than fashion apparel — and that's expected, not a problem on its own.
Consider a hypothetical furniture retailer selling sofas with a typical retail price of $1,800–3,500 and long supplier lead times — often 12–16 weeks for imported product, longer again for made-to-order ranges. Customers also frequently order ahead of need (e.g. for a house move 2–3 months away), meaning some "inventory" exists specifically to be held for a confirmed sale.
| Average inventory (cost) | $420,000 |
| Annual COGS | $1,050,000 |
| Days in stock = ($420,000 ÷ $1,050,000) × 365 | 146 days |
| Supplier lead time | 98 days |
| Buffer (days in stock − lead time) | +48 days ✓ |
At 146 days, this category sits well above the fashion apparel benchmark of 60–90 days — but against a 98-day lead time, the 48-day buffer is reasonable rather than excessive. If this retailer were evaluated against a generic apparel benchmark, the category would be incorrectly flagged as carrying too much stock. The lead time is the context that makes the days-in-stock figure meaningful.
09 — Case Study
Case Study: Multi-Store Chain — Using Days in Stock to Flag Stores Needing Stock Transfers
For retailers with multiple physical locations, days in stock at the store level can reveal imbalances that a chain-wide average completely hides.
Consider a hypothetical fashion chain with stores across metro and regional locations. A particular knitwear style sells well chain-wide on average — but a store-by-store days-in-stock review during a routine stock check reveals a significant imbalance between two specific stores.
| Store A (regional) — units on hand | 48 units |
| Store A — average daily sales | 0.6 units/day |
| Store A — days in stock (48 ÷ 0.6) | 80 days ✗ |
| Store B (metro) — units on hand | 9 units |
| Store B — average daily sales | 1.8 units/day |
| Store B — days in stock (9 ÷ 1.8) | 5 days ✗ |
Store A is carrying 80 days of stock for a style selling at a rate that would normally suggest 20–30 days is appropriate — significant overstock for this location. Store B, at just 5 days of cover, is at imminent risk of stocking out on a style that's clearly performing well there. The chain-wide average days in stock for this style might look perfectly healthy — masking the fact that stock is sitting in the wrong location entirely.
The immediate action is a stock transfer: moving units from Store A to Store B addresses both problems simultaneously without waiting for a supplier reorder. This kind of store-level days-in-stock check is a routine part of regional merchandising for multi-store retailers, particularly for styles showing strong but geographically uneven sell-through.
10 — Mistakes Planners Make
Common Days in Stock Mistakes Planners Make
Days in stock is a simple conversion from stockturn — but these mistakes are common enough to be worth checking for specifically.
Mistake 01 — Mismatched time periods
Using annual COGS with a monthly average inventory (or vice versa) produces a days-in-stock figure that's off by a factor of 12. Always confirm both the inventory figure and the COGS figure cover the same period before calculating.
Mistake 02 — Reading days in stock without a lead time reference
As both case studies show, 146 days can be fine or 36 days can be risky — entirely depending on supplier lead time. A days-in-stock figure presented without its corresponding lead time is missing the context needed to interpret it.
Mistake 03 — Using a chain-wide average when location-level data is needed
As the multi-store case study shows, an average across locations can hide a simultaneous overstock-and-stockout situation. When investigating a specific style's performance, check location-level days in stock, not just the aggregate.
Mistake 04 — Applying one benchmark across all categories
The furniture case study shows a 146-day figure that's appropriate for that category but would be a red flag for fashion basics. Set category-specific days-in-stock targets based on lead time and purchase frequency, not a single company-wide number.
Mistake 05 — Treating rising days in stock as automatically bad
Rising days in stock ahead of a known demand increase (e.g. building stock ahead of a key trading period) can be entirely intentional. Check whether the increase aligns with a planned event before treating it as a markdown signal.
Mistake 06 — Forgetting the leap year / 366-day edge case
A minor point, but using 365 vs 366 days in a leap year creates a small discrepancy when comparing year-over-year figures precisely. Usually immaterial, but worth being consistent about in formal reporting.
FAQ
Frequently Asked Questions — Days in Stock
What is a good days in stock figure?
For fashion apparel, 60–90 days is generally considered healthy, with 90–150 days acceptable depending on category. However, the right figure depends heavily on your supplier lead time and category type — a furniture retailer with a 98-day lead time might appropriately carry 146 days of stock, while a fast fashion retailer with a 28-day lead time might target 36 days.
How is days in stock different from stockturn?
They're mathematically the inverse of each other — Days in Stock = 365 ÷ Stockturn. Stockturn expresses inventory efficiency as "how many times per year", while days in stock expresses the same thing as "how many days of cover do I currently hold". Use whichever is more intuitive for the conversation — both describe the same underlying number.
Should days in stock be calculated at cost or retail?
Cost is preferred — using COGS and average inventory at cost keeps the figure consistent with stockturn and GMROI. As with stockturn, never mix cost and retail values in the same calculation.
What should I compare days in stock against?
Primarily your supplier lead time — if days in stock falls close to or below your lead time, you risk stocking out before a reorder arrives. Secondarily, compare against season length for seasonal categories, and against the same period last year to spot trends.
Why might two stores have very different days in stock for the same product?
Different local sales velocity. A style selling faster in one location than another will show lower days in stock there for the same unit count. This is a common reason for stock transfers between stores — moving inventory from a low-velocity location to a high-velocity one improves overall sell-through without any new buying, as covered in the multi-store case study above.
Is rising days in stock always a bad sign?
Not necessarily. If it aligns with a planned build ahead of a known demand increase (e.g. stocking up before a key trading period), it can be intentional and healthy. The concern is when days in stock rises unexpectedly or without a corresponding plan to sell through that additional cover — that's the pattern that precedes markdown activity.
Related tools & reading
Further reading: Shopify AU — GMROI and inventory efficiency explained · Australian Retailers Association