AwardFlagship wins the 2026 Hilldun Business Innovation Award Read the announcement
Loading...
Inventory Management

How to Forecast Inventory That Actually Matches Demand: A Planner’s Guide to Fewer Stockouts

How to Forecast Inventory

Most forecasts don’t fail because the math is wrong. They fail because demand doesn’t behave.

You’re not modeling a clean signal. You’re dealing with something that shifts constantly. Promotions hit unevenly. Weather pulls demand forward or pushes it out. A late influencer post can wipe out a size run in two days. Even payday cycles can skew weekly patterns more than most models expect.

At SKU level, it gets messier. Especially in the long tail. Demand is intermittent—flat for days, then a spike, then nothing again. Try forcing a smooth trend line onto that. It doesn’t stick.

This is where the idea of “forecast accuracy” starts to break down. You can improve accuracy and still stock out. You can improve accuracy and still end up with dead inventory.

Because the forecast isn’t the decision.

Two things most teams underestimate:

  • Demand volatility is structural
  • Forecasts are inputs, not answers

You might forecast 20 units next week for a SKU. Fine. That number alone doesn’t tell you what to order, where to allocate, or how much risk to carry.

And that’s usually where things start to slip.

Most teams treat the forecast as something to finalize and move on from. In reality, it’s the starting point of a decision system.

The shift sounds simple, but it’s uncomfortable:

Stop trying to be precisely right Start building systems that work when you’re wrong

Because you will be wrong.

The teams that manage this well think in a chain:

Forecast → Inventory Policy → Business Outcome

If that middle layer is weak, it doesn’t matter how good the forecast is. You’ll still stock out of core sizes and overbuy fringe ones.

Forecasting isn’t about precision. It’s about handling uncertainty without blowing up cash flow.

Forecasting Demand the Right Way: Beyond Historical Sales

Move from Time-Series to Causal Forecasting

If you’re only using historical sales, you’re already lagging.

Sales tell you what happened. Not why.

And retail demand is driven by things you already know are coming:

  • Price changes
  • Promotions and markdowns
  • Weather shifts
  • Macro pressure on spending

Ignore those, and you’re just projecting the past forward—and hoping it repeats.

Example: last March you ran a 30% promo and saw a spike. This year, the model expects the same lift. But marketing runs 20% instead, and inventory is tighter. Demand doesn’t show up the same way. Now your forecast is inflated, and your buys follow it.

Causal forecasting forces you to model drivers, not just outcomes.

It won’t be perfect. But it’s at least grounded in reality.

Match Forecast Granularity to Decisions

This is where control quietly breaks.

Finance plans at category level. Merchandising might sit at style level. But execution happens at SKU and location.

That gap matters.

You can hit your category forecast and still stock out of medium in your top stores while sitting on excess smalls elsewhere.

Inventory Forecasting

Aggregation smooths variability. That’s useful for budgeting. It’s dangerous for replenishment.

Inventory decisions happen at the edge:

  • SKU
  • Size
  • Store

If your forecast doesn’t exist there, your decisions won’t either.

This isn’t a model problem. It’s a structure problem.

Translating Forecasts into Inventory Decisions (Where Most Teams Fail)

A forecast doesn’t tell you what to buy. It tells you what might happen.

Outcomes come from how you respond.

That’s inventory policy:

  • Safety stock
  • Reorder points
  • Service levels

Most teams separate forecasting from these decisions—different tools, different owners. That separation is where things break.

Forecast error should shape your policy.

If demand is volatile, safety stock should reflect it. If lead times move, reorder points need to absorb that.

Instead, what usually happens:

  • Safety stock gets set once and forgotten
  • Reorder points rely on averages
  • Service levels are implied, not defined

Two teams can run the same forecast and get very different results.

One builds buffers around uncertainty. The other plans to the average.

The second one stocks out first. Every time.

Take a basic tee. Average weekly demand is 100 units. Sounds stable. But actuals swing between 70 and 140 depending on traffic and promos.

If you plan to 100 with a thin buffer, you miss sales in high weeks. Push inventory too high, and you tie up cash in slow ones.

There isn’t a single “true” number to find. The job is to handle the range.

That means:

  • Using forecast error to size safety stock
  • Adjusting reorder points for lead-time variability
  • Defining acceptable stockout risk upfront

Design for variability, not averages.

Safety Stock, Lead Times, and Service Levels: The Real Levers Behind Stockouts

Planners don’t control demand. They control the response.

And most of that sits in three levers:

  • Safety stock
  • Lead times
  • Service levels

Safety stock is a risk decision.

Too low, and you protect cash but lose sales. Too high, and you protect availability but invite markdowns.

The mistake is treating it as fixed.

In practice, it should flex with:

  • Demand variability
  • Forecast error
  • Supplier reliability

Lead times make this harder—especially when they’re inconsistent.

If a supplier quotes 30 days but delivers anywhere from 25 to 45, planning to 30 isn’t realistic. You need to plan for the spread.

Reorder points should reflect:

Expected demand during lead time Plus a buffer for variability

Yet many teams still rely on simple averages.

That’s how you end up here:

Core sizes stocked out mid-season Fringe sizes piling up in the back

Not because the forecast failed—but because variability wasn’t accounted for.

Then there’s service level. Most retailers don’t define it clearly.

What percentage of demand are you trying to fulfill without a stockout? 90%? 95%? Higher for core SKUs?

Without that, safety stock becomes guesswork.

And the trade-off is unavoidable:

Higher service level → more inventory → more capital tied up Lower service level → less inventory → more lost sales

inventory stocking

There’s no perfect answer. It depends on margin, lifecycle, and markdown risk.

Overstocking feels safe—until it shows up in aging inventory. Understocking protects cash—until your best stores miss weeks of sales.

The job isn’t to eliminate either. It’s to choose the balance intentionally.

When Advanced Forecasting (ML & AI) Actually Helps

There’s a lot of noise around machine learning in forecasting. Some of it’s fair. A lot isn’t.

ML isn’t automatically better. For stable SKUs, traditional models are often enough.

Where it actually adds value:

  • Large catalogs with messy demand
  • Nonlinear relationships (price, promo, seasonality)
  • Interactions across regions and channels

It’s useful when patterns get too complex to manage manually.

It also helps with stockout prediction—not just demand, but the likelihood of running out based on current inventory and inbound supply. That’s often more actionable.

But most implementations stop at a better point forecast.

No range. No connection to inventory policy.

That’s the miss.

Hybrid approaches tend to work better. Use statistical models for baseline stability, then layer ML on top for pattern detection.

More importantly, include uncertainty.

Not just “100 units,” but “100 units, likely between 70 and 140.”

That range is what drives better safety stock decisions.

Without it, even a better forecast doesn’t change outcomes.

Building a Forecasting System That Actually Reduces Stockouts

What works isn’t a better forecast. It’s a better system.

Static forecasts don’t hold in retail. You need something that adapts.

Start with feedback loops:

  • Track forecast vs. actual at SKU level
  • Segment error patterns
  • Identify consistent bias (over vs. under)

Not all SKUs behave the same. Treating them that way gets expensive fast.

Segment your inventory:

Stable SKUs → simpler models, lower buffers Volatile SKUs → higher buffers, more frequent updates

Then build a cadence around that.

Weekly updates are the minimum—but not full re-plans. Focus on exceptions:

Where did demand meaningfully deviate? Where are you at risk right now?

That’s where planners should spend time. Not updating spreadsheets line by line.

Safety stock should move too. Not once a season—continuously.

Example: a fashion SKU starts slow, then spikes after social traction. If your system doesn’t adjust, you stock out right as demand builds.

Or the reverse. Early hype fades, but replenishment keeps going. Now you’re carrying excess into markdown season.

The goal isn’t to predict every shift. It’s to respond faster when things change.

The teams that get this right accept uncertainty as part of the system—and build around it.

The ones that struggle keep chasing accuracy as the finish line.

It isn’t.

Better outcomes come from connecting:

Forecasts Inventory policies Execution cadence

Do that well, and you won’t eliminate stockouts.

But you’ll have fewer of them—and a lot less cash trapped in inventory you didn’t need.