Home › Learn › Inventory Demand Planning Explained: Formula and Example
Comparison

How Inventory Demand Planning Actually Works

Updated 2026-08-21 · 1365 words · Written against what currently ranked for “inventory demand planning”
The short answer

Inventory demand planning is forecasting how much customers will buy, then setting stock levels and reorder timing to match: reorder point = (average daily sales × lead time) + safety stock. Get that number right and you avoid both stockouts and cash stuck in unsold inventory.

The team behind Dr. Stock

$500M+
in Amazon revenue managed across 100+ brands — the operating experience sitting behind Dr. Stock
Full Circle group · approved public figures
70+
brands live across the Full Circle and reMKTR group right now, with their catalogues, fee structures and restock calendars
Full Circle group · approved public figures
$49M
in tracked group revenue in July, up 16.7% year over year
Full Circle group · approved public figures
Orbit
the inventory, finance and ASIN-profitability suite — plus the BSR, buy box, price and fee trackers — included at no additional cost
Full Circle group · approved public figures

What Inventory Demand Planning Actually Means

The phrase covers two jobs that get mashed together constantly. Demand planning is the forecast: how many units of a SKU will sell, and in what window. Inventory planning takes that forecast and turns it into a decision — how many units to hold, and when to trigger the next order. A third term, inventory management (sometimes called inventory control), is neither of those — it's tracking what you physically have, where it sits, and in what condition.

These three feed each other in one direction: the demand forecast sets the inventory plan, and the inventory plan sets what the day-to-day management system is supposed to be tracking against. When people ask about "demand planning and inventory optimization" or "inventory and demand planning" as if they're separate disciplines, they're usually really asking one question: how much should I be holding, and when do I reorder it. That's the reorder point, and it's a formula, not a guess.

The Formula, With a Worked Example

The core equation behind almost every inventory planning decision is this:

Reorder point = (average daily sales × lead time in days) + safety stock

Say a SKU sells 20 units a day on average, and the supplier's lead time — order placed to stock landing — is 45 days. You've decided to hold 15 days of extra demand as a buffer against variability. The math: (20 × 45) + (20 × 15) = 900 + 300 = 1,200 units. That's the level at which the next purchase order has to already be placed, not merely being discussed, or you run out before the replenishment arrives.

Now change one input. A promotion or a seasonal spike pushes daily sales to 30 units — a 50% jump that's common and easy to miss in a monthly review cycle. The same 1,200-unit buffer now covers roughly 40 days instead of 60. Nothing in the ledger looks wrong yet, but the safety margin is eroding fast, and by the time a manual review catches the change, the reorder may already be late. This is the entire argument for reviewing triggers more often than you review the plan.

When the Forecast Turns Out Wrong

A demand plan being wrong isn't a failure of the model — it's the normal case. What matters is what happens next.

  • Selling faster than forecast: confirm it's a real shift (a promotion, an ad push, a viral moment) and not a blip, then choose between expediting the existing PO at extra freight cost or accepting a short gap and protecting margin. Panic-ordering at any price is rarely the right call.
  • Selling slower than forecast: the cash is now sitting in stock that isn't moving. The decision becomes whether to hold it, discount it, or make the removal-versus-liquidation call before storage fees compound the loss.
  • The forecast says one thing, the physical count says another: stop and check the input before touching the model. One mistake we've made ourselves: trusting the inventory ledger over a physical check. The system showed adequate stock and no reorder due for three weeks — but the units were sitting in an unprocessed inbound shipment, received by the fulfillment center but not yet checked into sellable inventory. The forecast wasn't wrong. The number it was fed was.

Where This Gets Amazon-Specific

Generic demand planning treats a stockout as a lost-sales problem. On Amazon it's also a rank problem — a SKU that goes out of stock mid-campaign loses organic position and buy box share that doesn't come back the moment stock lands again. Inventory planning here has to account for restock limits, IPI-linked storage constraints, and FBA lead times that move around more than a standard supplier lead time, because inbound processing speed at the fulfillment center is its own variable.

Across more than $500M in managed revenue across 100+ brands, the same pattern shows up repeatedly: the forecast was fine, but the reorder trigger didn't account for one of these Amazon-specific frictions — a longer-than-usual check-in time, a storage limit that blocked a full replenishment, or aged-inventory surcharges eating the margin on stock that was technically "in the plan." A cookware brand carrying seasonal spikes around holiday gifting, for instance, needs safety stock sized for that window specifically, not an annual average that smooths the peak away.

Where Dr. Stock Fits

Dr. Stock, a managed product from Fable 5 at Full Circle, works the inventory side of this: the reorder timing behind stockouts, cash trapped in slow SKUs, storage and aged-inventory fees, FBA fee errors, and the shipment discrepancies that make a ledger disagree with the warehouse. Inventory purchasing decisions always go to a human, regardless of how much autonomy the client sets elsewhere, and Orbit's trackers come with it at no extra cost. If the actual leak is on the ad side — spend driving demand faster than the forecast expected — that's a Dr. PPC problem, not an inventory one. Either way, the formula above is the same one any tool you use should be running.

Side by side — inventory demand planning
StageQuestion it answersKey inputsTypical output
Demand forecastHow many units will customers want, and when?Historical sales, promotion/ad calendar, seasonality, market trendsProjected demand by SKU and period
Inventory planHow much stock do we need, and when do we reorder?Demand forecast, supplier lead time, safety stock policy, holding costReorder point and order quantity per SKU
Replenishment triggerIs it time to place the PO now?Stock on hand, open POs in transit, reorder pointPurchase order date and quantity
Review and adjustDid the forecast hold up?Actual sell-through vs. forecast, stockout or overstock incidentsUpdated forecast and safety stock for next cycle

Which one you should actually pick

A spreadsheet and a fixed reorder-point formula suit a seller with a handful of stable SKUs. A dedicated EPM platform like Pigment suits a multi-channel business planning production and finance, not just Amazon stock. Sellers whose real problem is Amazon-specific — stockouts killing rank, storage fees, FBA errors — need someone watching the account daily, not another forecasting model.

What to do with this

Shortlist on the job, not the feature grid. Total three numbers first: storage and aged-inventory surcharges for the last twelve months, lost sales on days your best sellers were out of stock, and cash sitting in SKUs that have not moved in 180 days. Then ask each vendor what they would do about those three in week one.

Common questions

Is demand planning the same thing as inventory management?

No. Demand planning predicts what customers will want and when. Inventory management (also called inventory control) tracks what you actually have on hand — quantity, location, condition. The demand plan feeds the inventory plan, which sets the reorder point that inventory management then executes against day to day.

What's the difference between demand planning and inventory optimization?

Demand planning produces the forecast. Inventory optimization is what you do with it — deciding safety stock levels, reorder timing, and the trade-off between holding cost and stockout risk. Optimizing without a decent forecast just optimizes around the wrong number.

How often should a demand forecast be updated?

At minimum, whenever an input changes: a promotion starts or ends, ad spend on the SKU shifts meaningfully, a supplier's lead time moves, or actual sales diverge from forecast by more than roughly 15-20%. A fixed monthly review with nothing touched in between is how a forecast goes stale mid-quarter.

Can I run demand planning in a spreadsheet, or do I need software?

Spreadsheets are fine for a handful of SKUs with stable demand. Past that, the lead-time math and the need to catch a stockout before it happens outgrow manual review — that's when a dedicated system, or someone checking the account daily, starts earning its keep.

What's the most common reason a demand forecast turns out wrong?

Usually an input changed after the forecast was built and nobody fed it back in — a lead time that stretched, a promotion that got pulled early, or an ad campaign that moved velocity faster than the review cycle caught.

Dr. Stock runs Amazon inventory and supply chain — reorder timing, stockout risk, storage and aged-inventory fees, FBA fee errors and dimensional-weight misclassification, shipment discrepancies and reimbursement recovery — with operators from a $500M+ Amazon team supervising. Purchasing decisions always come to a human. Orbit is included. First 30 days free, priced on the call.

Book a Dr. Stock demo
Written against what currently ranked for “inventory demand planning”, checked 2026-08-21: www.fuseinventory.com, www.lightspeedhq.com, www.pigment.com. Vendor prices change without notice — check the vendor's own page before you budget. Our own figures are labelled with the scope and period they came from.