By Elie Dufeu, CTO & Co-Founder, Metreecs. Published 12 November 2026.
There is no single good DIO for retail: a grocer turning stock in under a month and a furniture retailer holding four months of stock can both be well run. The useful answer is a range for your sub-sector, adjusted for your margin and seasonality, and then a trend line that keeps moving in the right direction.
Ask a search engine what is a good DIO for retail and you get a confident "30 to 60 days," a table of sector averages that contradicts the next table, and very little about where any of it comes from. Those numbers rarely survive a board meeting. A CFO asks which companies are in the sample, whether inventory was measured at cost, and whether the figure includes the peak before the holidays.
This guide uses official US Census Bureau data to give a sourced starting point by sub-sector, explains why published benchmarks disagree, and sets out five checks to decide whether your own number is healthy. If you would rather test it on your own stock data, you can review your DIO with our planning team.
Key Takeaways
- US clothing and accessory stores held inventory equal to 2.02 months of sales in August 2026, about 61 days, according to US Census Bureau data published through FRED.
- Food and beverage stores held 0.82 months of sales (about 25 days), while building materials and garden dealers held 2.53 months (about 77 days), so retail DIO benchmarks spread by a factor of three between sub-sectors.
- Census ratios compare inventory with sales, which include margin. A 50% gross margin roughly doubles the days when you convert to a DIO based on cost of goods sold.
- The Hackett Group's 2025 US Working Capital Survey found that days inventory outstanding worsened slightly across large companies even as payables improved.
- IHL Group estimates retail inventory distortion (overstocks plus out-of-stocks) at about $1.73 trillion a year, which is why the mix behind the DIO matters as much as the average.
What DIO measures and how to calculate it
Days inventory outstanding (DIO) is the average number of days a retailer holds inventory before selling it. It is calculated as average inventory at cost divided by cost of goods sold (COGS) for the period, multiplied by the number of days in the period. A lower DIO means stock turns into cash faster.
The formula is:
DIO = (average inventory at cost / COGS) x number of days
For a full year, a retailer with €6M of average inventory at cost and €24M of COGS has a DIO of 6 / 24 x 365 = about 91 days. You will also see the same metric called days sales of inventory (DSI), days in inventory, or inventory days. They measure the same thing.
DIO is the mirror image of inventory turnover. Turnover is COGS divided by average inventory (4.0 in the example above), and DIO is 365 divided by turnover. If your team reports turnover, our guide to improving inventory turnover covers that side of the equation.
Two inputs make or break the number. Inventory must be valued at cost, the same basis as COGS, and the average should be built from monthly or weekly balances rather than just the opening and closing figures. A retailer that measures only at year end, after the January clearance, will report a DIO that looks better than any day it actually traded.
Retail DIO benchmarks by sub-sector
The most reliable public benchmark is the US Census Bureau's Monthly Retail Trade Survey, which publishes an inventories/sales ratio for each kind of business every month. The ratio divides month-end inventory by that month's sales, so multiplying it by 30.4 (the average number of days in a month) gives the number of days of sales held in stock.
Retail sub-sector (US)Inventories/sales ratio, Aug 2026Days of sales in stock (ratio x 30.4)Food and beverage stores0.82about 25Retail trade, excluding motor vehicles and parts1.19about 36General merchandise stores1.39about 42Furniture, home furnishings, electronics, and appliance stores1.80about 55Clothing and clothing accessory stores2.02about 61Building materials and garden equipment dealers2.53about 77Department stores2.60about 79
Source: US Census Bureau, Monthly Retail Trade Survey, seasonally adjusted ratios retrieved from FRED (Federal Reserve Bank of St. Louis). Days column is our own arithmetic.
These figures describe the whole US sub-sector, from national chains to independents, so treat them as a reference point rather than a target. The spread is the first lesson: what counts as a good DIO for retail grocery would be alarming in a garden center, and a normal department store figure would sink a convenience chain.
Converting the Census figure to a cost-based DIO
The Census ratio compares inventory with sales, and sales include your margin. COGS does not. To compare the table with your own DIO, divide the days figure by (1 minus your gross margin).
An illustrative example: a fashion retailer with a 50% gross margin, sitting exactly on the clothing average of 61 days of sales, has a cost-based DIO of about 61 / 0.5 = 122 days. A grocer with a 28% margin on the food store average of 25 days lands at about 25 / 0.72 = 35 days. Skip this step and a perfectly ordinary fashion business will look like it is drowning in stock.
Why published DIO benchmarks disagree
If you have searched before, you have seen clothing benchmarks anywhere from about 60 to well over 140 days. Most of the gap comes from four differences in method, not from retailers getting worse or better.
Cost or sales basis. As the conversion above shows, the same stock reads as 61 days against sales or 122 days against COGS for a 50% margin business. Tables rarely say which basis they used.
Who is in the sample. A median of a dozen listed direct-to-consumer brands will look nothing like a national survey that includes thousands of independent stores. Vertically integrated brands also hold raw materials and work in progress, which a pure reseller does not.
Point in the season. A DIO measured in October, with holiday stock already in the building, can run weeks higher than one measured in February. Year-end balance sheets often land just after clearance, which flatters the figure.
What counts as inventory. Some retailers include goods in transit and consignment stock, others exclude them. For businesses that import, in-transit stock can represent several weeks of supply on its own.
One mistake we repeatedly see is a planning team comparing its cost-based DIO with a sales-based industry figure and concluding it holds twice as much stock as its peers. The finance director then sets a reduction target that the business could only hit by cutting availability on its best sellers. Check the basis before you check the gap.
How to judge your own DIO
A benchmark tells you which neighborhood you live in. Whether your own number is good depends on five checks that no published table can make for you.
- Compare with your own trend first. A DIO that moved from 130 to 115 days over two years is a good sign even if it still sits above a sector table. One that crept from 80 to 95 days deserves a look, whatever the benchmark says. Compare the same month year on year, not consecutive months.
- Adjust for margin and model. Use the conversion above to put your number and the benchmark on the same basis. Then account for structural differences: a brand that owns its manufacturing, or that sells mostly through wholesale, will carry a different profile from a pure retailer.
- Separate seasonal peaks from structural excess. Plot DIO monthly. A peak that rises before your selling season and falls after it is planned stock. A floor that rises year after year is excess that never clears.
- Break it down by product and location. A company-wide DIO of 90 days can hide fast basics at 30 days and slow lines at 300. Across Metreecs' work with multi-store retailers, finance teams often underestimate how much of the total sits in a small group of slow products in a few stores, because the company average never shows it.
- Read it next to service level. A falling DIO paired with rising stockouts on core products is not an improvement. Track availability or fill rate for your top sellers alongside DIO, and treat any reduction that hurts them as a cost.
Nadia runs merchandise planning for a 35-store home décor retailer. Her board compared the company DIO of 140 days with a furniture and home furnishings figure of about 55 days and asked why the business carried nearly three times the industry level of stock. Once she converted the benchmark to cost at her 55% margin (about 120 days) and removed the decorative lighting range bought for a store refit, the gap shrank to a few weeks, concentrated in two slow-moving product families she could act on. (Nadia is an illustrative example.)
Once you know where the excess sits, track DIO next to sell-through and service level so it cannot improve at the expense of availability. Our article on the inventory KPIs worth tracking across a store network shows how they fit together. This article stays on the diagnosis.
When a high DIO is fine, and when a low DIO is a problem
A high DIO is not automatically a failure. Some reasons to hold more stock are deliberate and worth their cost.
- Long or uncertain lead times. A retailer importing from Asia with 12 to 16 weeks of lead time needs more stock in the pipeline than a regional grocer restocked twice a week.
- Wide assortments with size and color depth. Every variant needs at least a minimum presentation in each store, so assortment breadth raises DIO before a single unit is excess.
- Pre-season builds. Garden, outdoor, toys, and gifting all build stock ahead of a short peak. A high DIO in the month before the season is the plan working.
- High-value, slow categories. Fine jewelry and furniture sell slowly by nature, and the margin on each sale pays for the time on the shelf.
A high DIO becomes a problem when it grows faster than sales over several periods, when the same products show up as aged stock season after season, or when the cash tied up starts to limit buying for the next season. Our article on working capital tied up in inventory shows how to put a cash figure on that.
A very low DIO can also hurt. Cutting stock below what demand variability requires shows up as empty shelves, lost sales, and customers who stop trusting your availability. Marc runs operations for a regional chain of garden centers. After a push to cut working capital, his spring DIO fell sharply, and so did availability on bedding plants and compost during the four weekends that make his year. The following season he set stock by expected demand and variability for each product family instead of a single days-of-cover target, and held more stock in March in exchange for fewer gaps in April. (Marc is an illustrative example.)
In our experience deploying product-level forecasting, the healthiest DIO movements come from putting depth where demand actually is rather than cutting everywhere at once. Forecasting each product in each store, then setting safety stock by variability, lowers the average without starving the lines that drive sales. That is the principle behind Metreecs' approach to inventory optimization.
Statistic callout: Retail inventory distortion, the combined cost of overstocks and out-of-stocks, reached about $1.73 trillion a year, per IHL Group's September 2025 study.
FAQ
What is a good DIO for a retailer?
It depends on the sub-sector. US Census data for August 2026 put food and beverage stores at about 25 days of sales in stock, clothing stores at about 61, and department stores at about 79. Convert those to a cost basis using your gross margin, then judge your number on its trend and on service level, not on a single target.
Is a higher or lower DIO better?
Lower is usually better because stock turns into cash faster and carries less risk of markdowns. It stops being better when it comes from cutting stock on products that sell, because stockouts on best sellers cost more than the inventory saved. Look for a falling DIO with stable or rising availability.
What is the average days inventory for clothing retailers?
US clothing and accessory stores held inventory equal to 2.02 months of sales in August 2026, or about 61 days measured against sales, according to the Census Bureau. Measured against cost of goods sold, a retailer with a 50% gross margin would see roughly double that, around 120 days.
How is DIO different from inventory turnover?
They are two views of the same ratio. Inventory turnover is COGS divided by average inventory, and DIO is 365 divided by turnover. A turnover of 4 equals a DIO of about 91 days, and a turnover of 6 equals about 61 days.
Why does my DIO change so much during the year?
Because stock and sales do not move together. Inventory builds before your selling season while sales are still low, which pushes DIO up, and falls quickly once the season peaks. Compare the same month year on year, or use a rolling 12-month average, to see the real trend.
Conclusion
A good DIO for retail is a range set by your sub-sector, converted to your margin, and confirmed by a trend that improves without hurting availability on the products that sell. Start by putting your own monthly DIO on the same basis as the Census figures, then break it down by product and store to find where the excess sits. When you want to see how Metreecs builds that breakdown from your own data, book a demo of product-level inventory planning.
Sources
- US Census Bureau, Monthly Retail Trade Survey, inventories/sales ratios by kind of business, seasonally adjusted, August 2026, via FRED, Federal Reserve Bank of St. Louis: clothing 2.02, department stores 2.60, furniture, home furnishings, electronics, and appliances 1.80, general merchandise 1.39, food and beverage 0.82, building materials and garden 2.53, retail excluding motor vehicles 1.19.
- The Hackett Group, 2025 US Working Capital Survey (August 2025), as reported by Textile World: days sales outstanding and days inventory outstanding worsened slightly while payables improved.
- IHL Group, Retail Inventory Crisis Persists Despite $172 Billion in Improvements (September 2025): about $1.73 trillion in annual inventory distortion.





































































