Inventory Forecasting Methods for DTC Brands: What Actually Works

The honest answer first, because most guides to inventory forecasting bury it: the majority of DTC brands under $20M do not need machine learning, statistical exotica or a data science hire. They need a weeks-of-cover model, a weighted moving average, a handful of judgment overlays, and a calendar that makes someone look at all three every week. The method is rarely the constraint. The discipline around it is.

This guide covers the five methods that matter, which one fits which stage, the two formulas that do most of the work, and the uncomfortable truth about forecast accuracy that every vendor demo skips.

Why DTC forecasting is its own problem

Forecasting theory was built for supermarkets and factories: thousands of steady SKUs, decades of history, demand that behaves. A DTC brand has none of that. Sales histories are short and polluted by stockouts, which read as demand disappearing when it was actually you disappearing. Marketing does not smooth demand, it spikes it: one creator post can triple a SKU's run rate for a fortnight. Catalogues turn over fast, so half your range has no history at all. And replenishment lead times from Asia run 60 to 100 days door to door, which means today's forecast error becomes a stockout you cannot fix for a quarter.

So the job is not predicting the future precisely. It is holding a defensible view of demand, refreshing it fast, and sizing your buffers to the error you know you will make. Every method below is a different way of doing that.

Method one: weeks of cover

The workhorse, and where every brand should start. Take each SKU's current rate of sale, divide stock on hand plus stock on order by it, and you get weeks of cover: how long until you run out at the current pace. Set a target band per SKU based on lead time plus a buffer, reorder when cover falls toward the bottom of the band.

Its strength is that it is self-correcting and impossible to misunderstand. Its weakness is that it assumes tomorrow sells like last month, so it lags trends, ignores seasonality, and gets blindsided by promotions. Fine for stable repeatable SKUs. Dangerous on its own for anything growing, seasonal or about to be marketed.

Method two: weighted moving averages

The first real upgrade. Instead of one flat rate of sale, blend the last 30, 60 and 90 days with heavier weight on recent weeks, so the forecast leans toward where demand is going rather than where it has been. Add a simple growth factor if the trend is consistent. This is still spreadsheet arithmetic, it takes an afternoon to build, and for most brands between $1M and $10M it captures the large majority of the accuracy that any method will ever deliver.

Method three: seasonal indices

If your demand has a shape, Q4 gifting, summer apparel, January fitness, you need last year's shape in this year's forecast. Build an index per month from prior-year sales (December sells at 1.8x the average month, July at 0.6x), then multiply your baseline forecast through it. Two years of history makes it respectable; one year makes it better than nothing. The trap: if last year's December was suppressed by a stockout, the index inherits the injury. Correct the history first, which brings us to the overlays.

Method four: test and react

The method that does not look like forecasting, and the one behind the best public numbers in DTC. Buy new styles shallow, read sell-through weekly, cut the winners deep and let the losers die at test volume. Reformation just filed to IPO on the back of exactly this machine, holding roughly 80% of sales at full price for five straight years by testing styles twice a week and reordering the proof. Zara built an empire on it. The requirement is not software, it is a supply chain that can reorder inside the season, which is a supplier and lead-time problem before it is a planning one. If your winners can be replenished in four to six weeks, test and react beats prediction, because reading demand is easier than guessing it.

Method five: statistical and AI forecasting

Exponential smoothing, seasonal decomposition, and the machine learning engines inside the modern planning tools. These genuinely help when you have hundreds of SKUs, a few years of clean history and demand too complex for spreadsheets to hold. They are also the most oversold layer in the stack: an algorithm fed history full of uncorrected stockouts and unlabelled promotions produces confident nonsense at scale. The tooling question is covered honestly in our guide to inventory planning tools; the one-line version is that software multiplies the planning function you have, including a missing one.

The overlays that beat any algorithm

Whatever method sits underneath, five adjustments separate real forecasts from arithmetic. Correct the history for stockouts, because a month you spent out of stock is not a month of low demand. Feed the marketing calendar in, because your team already knows November doubles and the algorithm does not. Use true supplier lead times, measured from your own POs, not the ones quoted at onboarding, and re-measure them quarterly because they drift. Plan around Chinese New Year, which removes three to five weeks of production capacity every year on a known date. And forecast size curves, not just styles, because being out of medium while sitting on XXL is a stockout wearing an overstock costume.

The two formulas

Reorder point = (average daily demand × lead time in days) + safety stock. When available stock touches this number, you order. Everything else in replenishment is refinement of this line.

Safety stock, the simple version most brands should use: average daily demand × buffer days, where the buffer reflects how wrong your forecast tends to be and how much a stockout costs you on that SKU. The statistical version scales the buffer to your measured demand variability and lead time (a service-level factor multiplied by demand deviation over the lead time); it is worth adopting once you have clean data and someone who will maintain it, and not before. A best seller with volatile demand and a 90-day lead time deserves weeks of buffer. A slow steady SKU on a 30-day lead time deserves days.

Which method for which brand

Under roughly 50 SKUs and $1M: weeks of cover in a disciplined spreadsheet, reviewed weekly. Do not buy anything.

$1M to $10M: weighted moving averages plus seasonal indices plus the overlays, still spreadsheet-viable, with test and react for new product if your suppliers can replenish in-season.

$10M and beyond, or multichannel: the same logic moved into a planning tool so it survives SKU count and channel complexity, with statistical forecasting where the data has earned it.

At every stage the constant is the cadence: a weekly forecast review someone owns, with the authority to place and change orders off it. That sentence is doing more work than any method on this page.

The uncomfortable truth about accuracy

Every forecast is wrong. The question that decides your stockout rate and your cash position is not how wrong, it is how fast you find out and how fast you can act. A brand with a mediocre forecast, weekly reads and suppliers who replenish in five weeks will outperform a brand with a brilliant forecast reviewed monthly and a 100-day supply chain, every single time. Which is why forecasting work inside our engagements is never just a model: it is the model, the review cadence, the reorder authority and the supplier lead times, built as one function. That is the substance of what an inventory management consultant actually does, and it is why the fix for chronic stockouts usually starts two steps upstream of the forecast itself.

Common questions

What is the most accurate inventory forecasting method?

For most DTC brands, a weighted moving average with seasonal indices and judgment overlays, reviewed weekly. More sophisticated methods add accuracy only when fed more history and cleaner data than most brands under $20M possess.

How do I forecast a product with no sales history?

Anchor to the closest comparable SKU you already sell, adjusted for price point and audience, then treat the first buy as a test: shallow, with a reorder pre-agreed with the supplier if week-one sell-through clears a threshold. This is test and react, and it beats guessing.

What is the reorder point formula?

(Average daily demand × lead time in days) + safety stock. Use lead times measured from your own purchase orders, not the supplier's quoted figure.

How often should I reforecast?

Weekly for your top SKUs, monthly for the tail. The refresh matters more than the method: a simple forecast updated weekly beats a sophisticated one updated quarterly.

Can I just let my planning software forecast for me?

The good tools automate the arithmetic well. They cannot correct your history, know your marketing calendar, or chase your supplier's real lead time. Software plus an owned planning function is the answer; software instead of one automates the guesswork.

Where Onflair fits

Building this function, the forecast, the cadence, the reorder logic and the supplier lead times that make it actionable, is core work inside our engagements. If stockouts on best sellers or cash trapped in slow stock is a live problem, the supply chain and operations audit quantifies exactly what it is costing and what the fix is worth. Fixed fee, credited in full against whatever engagement follows.