← Knowledge Hub

Inventory Planning

Inventory Forecasting Isn’t About Finding the Perfect Formula — It’s About Asking Better Questions

One expert tells you to calculate your reorder point with a simple formula. Another tells you that formula is outdated and fundamentally flawed. One says averages work. Another says averages are dangerous. So who’s right? The uncomfortable answer is both of them — and that’s precisely why so many sellers struggle.

AmazeBase 6 min read Inventory & Cash Flow

Forecasting turns one formula into a range of scenarios, not a single number

Most inventory articles fall into one of two camps. The first loves simplicity. The second reacts by rejecting almost everything. Both are making the same mistake — and it isn’t the one you’d expect.

Read the two sides first

This piece argues with our own earlier articles. If you want the case for the simple formula, read the reorder point guide. For the case against it, read why the classic formula is wrong.

The problem with inventory advice

The first group gives you formulas. It’s clean, easy to calculate, easy to explain. The problem? Businesses aren’t simple.

The second group argues averages are misleading, lead times are unpredictable, demand constantly changes, cash matters, risk matters, everything is dynamic. They’re also right. The problem? Sometimes they replace one oversimplification with another — complexity.

In defence ofSimplicity isn’t wrong

Let’s defend the humble reorder point formula for a moment. If you’re a new seller with:

  • one product
  • stable demand
  • predictable suppliers

…the classic formula works surprisingly well. In fact it’s infinitely better than what many businesses actually do: guess.

If you’re placing purchase orders because “it feels about right”, then even a basic formula is a major improvement.

The point

Simple systems often outperform sophisticated systems that nobody actually uses.

In defence ofComplexity isn’t wrong either

Now let’s defend the critics. Amazon isn’t a traditional retail business. Sales can double because of:

  • Prime Day
  • viral social media
  • ranking improvements
  • better reviews
  • PPC optimisation

And lead times can suddenly increase because of:

  • factory delays
  • customs inspections
  • port congestion
  • Amazon receiving bottlenecks

Meanwhile your cash flow changes every two weeks.

The point

If your spreadsheet ignores all of that, it isn’t forecasting reality. It’s forecasting a fantasy.

The real mistake: looking for one formula

Here’s the mistake I think both sides make. They assume inventory forecasting is a mathematical problem.

It isn’t. It’s a decision-making problem.

Formulas don’t make decisions. People do. The purpose of mathematics isn’t to replace judgment — it’s to improve it.

Every formula is based on assumptions

Consider these two approaches. Neither is universally correct, because both depend on assumptions.

Classic

average sales × lead time Assumes yesterday resembles tomorrow.

Modern

forecast demand during lead time Assumes you can accurately predict tomorrow.

Neither assumption is always true. Good operators understand the assumptions before trusting the numbers.

A better question than “which formula is best?”

Ask this instead

Which assumptions are most likely to be wrong in my business?

That’s where forecasting becomes interesting. Suppose your suppliers are incredibly reliable — lead time probably isn’t your biggest uncertainty. Maybe demand is.

Or perhaps demand is extremely stable, but your suppliers constantly miss production deadlines. In that case, improving demand forecasting won’t help much. You should focus on supply variability instead.

The shift

Forecasting starts by identifying uncertainty — not eliminating it.

The missing variable nobody talks about

Both traditional and modern discussions often overlook something surprisingly important: the cost of being wrong.

Product A

$12 Running out hurts.

Product B

$250 Running out could cost thousands in lost profit every day.

Likewise, over-ordering low-cost inventory may not be a big issue. Over-ordering expensive inventory can tie up enough cash to delay future growth.

Forecasting isn’t only about probability. It’s about consequences.

The most useful formula is often the simplest

Here’s a controversial opinion. Your spreadsheet doesn’t need to be perfect. It needs to help you notice when something changes.

  1. Are sales increasing?
  2. Has lead time changed?
  3. Is available cash decreasing?
  4. Has Amazon slowed receiving?
  5. Are promotions approaching?
  6. Has my supplier become less reliable?
The habit

If those answers change, your forecast should change. That habit is often more valuable than any equation.

Think in ranges, not single numbers

One of the best ideas from modern forecasting is abandoning precision.

  • “I’ll sell 48 units per day.” “I’ll probably sell somewhere between 42 and 58.”
  • “My shipment takes 45 days.” “It usually arrives between 42 and 58 days.”
Why it helps

Businesses operate inside ranges, not exact numbers. Say it that way and forecasting becomes much more realistic.

Build a forecast that matches your business

A small private-label seller doesn’t need the same forecasting system as a company managing 500 SKUs. Your process should grow with your business.

  1. Keep it simple

    Use the classic reorder formula. Review inventory weekly.

  2. Adjust for reality

    Account for seasonality and promotions. Track supplier performance. Update demand assumptions regularly.

  3. Model uncertainty

    Forecast multiple demand scenarios. Model cash flow. Measure lead-time variability. Review every week.

  4. Automate the watching

    Use software to automate calculations and monitor exceptions, instead of manually updating spreadsheets.

Notice something

None of these stages replaces the previous one. They build on it.

The best planners don’t worship formulas

Experienced operators rarely say “this formula is correct”. Instead they ask: “What has changed since I last made this decision?”

That mindset transforms forecasting. The spreadsheet becomes a conversation, not an answer.

The forecast is never the goal

Imagine two companies.

Company A

Produces an incredibly sophisticated forecast every month. Then ignores it.

Loses

Company B

Uses a much simpler model, but reviews it every Monday. Updates assumptions, adjusts purchase orders, talks to suppliers, plans promotions around inventory.

Wins
Why

Not because its forecast is more accurate. Because its decisions improve continuously.

A practical framework that takes the best from both worlds

If there’s one lesson worth taking from both schools of thought, it’s this: use formulas as a starting point, not a conclusion.

  1. Start with the classic reorder point. It gives you a baseline and prevents guesswork.
  2. Challenge the assumptions. Are sales accelerating? Is lead time still realistic? Has anything changed?
  3. Think in scenarios. Calculate what happens if demand is 20% higher or lead time is two weeks longer.
  4. Check your cash. A mathematically perfect order that drains your reserves may still be the wrong decision.
  5. Review frequently. A forecast created six weeks ago is no longer a forecast — it’s history.

Final thoughts

Inventory forecasting has been turned into a debate between simplicity and sophistication. It doesn’t need to be.

The simple formulas are useful because they create structure. The more advanced approaches are valuable because they acknowledge uncertainty. The best businesses don’t choose one side — they combine both. They start with mathematics. Then they apply experience. Then they question their assumptions. Then they update their decisions as reality changes.

Great inventory planning isn’t about having the smartest spreadsheet. It’s about building a process that helps you make better decisions, week after week, even when the future refuses to cooperate.