Why the formula gives the wrong answer

The standard safety stock formula — Z × σd × √L — is elegant and widely used. It assumes demand variability is normally distributed, lead times are independent of demand, stockouts don't affect future demand, and replenishment is instantaneous once the reorder point is reached. None of these assumptions hold in real supply chains.

In practice, demand is lumpy — a few large orders arrive unpredictably between periods of quiet. Lead times cluster around the average most of the time and then occasionally spike — and the spikes correlate with demand peaks, when you most need the stock. Stockouts create backorders that inflate the next order, creating bullwhip effects that a formula cannot see.

The result: Formula-based inventory policies are either over-stocked (because analysts add buffers to compensate for distrust in the formula) or under-stocked when the formula's assumptions break down during demand spikes. Simulation replaces the assumptions with actual distributions fitted to your data.

What inventory simulation answers

Safety stock levels

How much buffer stock is needed to achieve a target service level — 95%, 98%, 99.5% — under your actual demand variability and lead time distribution, not the formula's assumed normal distribution.

Reorder point & quantity

When to trigger a replenishment order and in what quantity — balancing order frequency (transaction cost), holding cost, and the risk of running out between the order and its arrival.

Supplier lead time risk

Which suppliers' lead time variability contributes most to your stock risk — and what additional buffer is required per supplier to maintain your service level target under their specific delivery pattern.

Multi-echelon inventory

For distribution networks with central warehouse and regional DCs, how to split inventory between echelons to minimise total network stock while maintaining service levels at each point in the chain.

Seasonal & promotional demand

How much to pre-build before a demand surge — seasonal ramp-up, promotional events, new product launches — so that the surge doesn't exhaust safety stock before replenishment can respond.

Supply disruption scenarios

What stock level survives a specific supplier disruption — 2-week delay, 40% capacity reduction, complete stoppage — without service level failure. Used for supply chain risk assessment and business continuity planning.

Monte Carlo vs discrete-event: which approach?

Both methods have their place — and we use both, depending on what the question requires:

ApproachBest forTypical use
Monte Carlo simulationPure inventory policy questionsSafety stock & reorder point when inventory is independent of operational flow
Discrete-event (Simio / AnyLogic)Inventory + operations togetherWhen replenishment interacts with warehouse capacity, receiving dock throughput, or production scheduling
System dynamicsNetwork-level bullwhip & policyMulti-echelon networks, demand amplification analysis across supply chain tiers
Spreadsheet formulaSimple, stable environmentsSuitable when demand is genuinely normal and lead times are stable — rare in practice

For most inventory policy questions, we start with Monte Carlo and upgrade to discrete-event when the operational context matters — for example when the question is "how much safety stock do we need if our receiving dock is also processing returns during peak?"

Our process

1

Data fit & distribution analysis

We fit statistical distributions to your demand data and lead time records — testing normality, identifying heavy tails and seasonality, and flagging outliers that should be modelled separately. This step often reveals that demand is far more variable than the formula assumes, and explains why current safety stock levels feel wrong.

2

Model build & baseline validation

The simulation model is built and validated against historical performance: given the actual demand and lead times you experienced, does the model reproduce the stockout frequency and inventory levels you observed? A validated model provides confidence that the policy recommendations will hold in real operation.

3

Policy scenario matrix

We test the policy variations you want to evaluate — different safety stock levels, different reorder points, different order quantities — against your historical demand and lead time distributions, plus stress scenarios (demand spikes, supply disruptions). Each scenario runs thousands of simulated periods to produce stable service level and stock level estimates.

4

Recommendation & cost analysis

You receive a policy recommendation with the specific safety stock and reorder point for each SKU group or product family, a service level vs holding cost trade-off curve showing where the optimal operating point is, a supplier risk ranking, and the simulation model — yours to rerun when demand patterns change or new suppliers are added.

What you get at the end

Policy table
Specific safety stock and reorder point for each SKU or product group, ready to load into your ERP
Trade-off curve
Service level vs inventory value trade-off — the full picture for each policy option, not just one point
Your model
Simulation model handed over — rerun when demand patterns shift, new SKUs arrive, or suppliers change

Connection to digital twin & production planning

Inventory simulation answers the strategic question: what policy should we run? A digital twin answers the operational question: given today's stock levels and incoming orders, what should we do right now? These are complementary, not competing.

We often build both: the simulation study establishes the target safety stock and reorder parameters, and the digital twin consumes live ERP/WMS data to monitor whether those parameters are holding up in real operation and flags when demand patterns are drifting away from the model assumptions.

If you already have a digital twin, a simulation-based inventory study can be run as a parallel project and its output loaded directly into the digital twin's replenishment logic. If you don't have a digital twin yet, the inventory model is still fully useful on its own.

Tools & technology

Monte Carlo inventory studies are built in Python with fitted statistical distributions and parallel scenario execution. Discrete-event inventory models — when operational interaction matters — are built in Simio or AnyLogic. For network-level, multi-echelon, or demand amplification studies, we use AnyLogic's system dynamics capabilities. All models are delivered with documented assumptions and a Python or Excel interface for reruns without specialist software.

Python (Monte Carlo) Simio AnyLogic Statistical distribution fitting

What data do we need?

  • Demand history — 12–24 months of order or consumption data per SKU, with dates and quantities (ERP or WMS export)
  • Lead time records — purchase order history showing order date and goods receipt date per supplier and SKU
  • Current inventory policy — existing safety stock levels, reorder points, and order quantities
  • Service level targets — your target fill rate or order completion rate by product group
  • Cost parameters — holding cost rate and order transaction cost, if a cost optimisation is needed (not required for service level studies only)
  • Planned changes — new suppliers, new SKUs, upcoming demand events, or supply chain restructuring plans
Related examples

See it in practice

Case study

Automotive parts distributor:
30% less stock, same 98.5% fill rate

Inventory simulation — automotive parts supply chain
Automotive · Python · Monte Carlo

ERP-recommended safety stock was 40% too high — simulation showed why

An automotive parts distributor was holding €4.2M in safety stock across 1,800 active SKUs. Their ERP system calculated reorder parameters using the standard formula with normal distribution assumptions. Service level was consistently meeting the 98.5% fill rate target, but working capital was under pressure and the operations team suspected significant overstocking.

SimulateFirst fitted actual demand distributions to 12 months of order history. 68% of SKUs had demand that was neither normal nor Poisson — they were negative binomial: mostly quiet, with occasional large orders. The ERP formula was calculating safety stock for a continuous demand process that didn't exist, holding excess stock against variability that clustered around predictable seasonal events.

€1.26M reduction in safety stock value — 30% of total inventory
98.5% fill rate maintained across all SKU groups after 9 months
14 high-risk SKUs identified where safety stock was actually too low
New reorder parameters loaded directly into the ERP in 2 weeks
View all examples →
AI-assisted modelling

New products, no history — still simulatable

New product launches, new suppliers, and new markets have no demand history. We use AI to generate synthetic demand profiles from product category benchmarks, comparable SKU behaviour, market size estimates, and seasonality patterns — calibrated to the level of variability typically seen in similar product types.

This allows inventory policy to be set before launch — how much to pre-build, what safety stock to allocate, and what reorder quantity to specify with the supplier — based on a stochastic model of what demand will likely look like, rather than a single forecast number. As real orders arrive, the synthetic demand is replaced and the model refits automatically.

Read the AI & simulation guide →
AI applies to this service
  • Synthetic demand profiles for new products without order history
  • Lead time distribution generation from supplier & market descriptions
  • Automated distribution fitting across large SKU catalogues
  • Batch policy testing — thousands of SKU-policy combinations overnight
FAQ

Common questions about
inventory simulation

Classical inventory formulas assume normally distributed demand and deterministic or normally distributed lead times. In practice, demand is lumpy — mostly quiet with occasional large orders — lead times vary by supplier and season, and stockouts affect future demand through backorders. Simulation replaces these assumptions with actual distributions fitted to your data, and runs thousands of periods to find policies that meet your service level target across the full variability you actually experience, not just on average.
Monte Carlo simulation samples from demand and lead time distributions thousands of times to estimate the probability of stockout under a given policy — fast, simple, and sufficient when inventory decisions are independent of operational flow. Discrete-event simulation (Simio, AnyLogic) adds the operational layer: replenishment orders interact with warehouse receiving capacity, dock throughput, and supplier lead time modelled as a process with queues, not just a distribution. We use Monte Carlo for pure inventory policy questions and discrete-event simulation when the inventory model needs to connect to warehouse or production operations.
ERP safety stock calculations use the standard formula with normal distribution assumptions. If your demand is actually lumpy, seasonal, or driven by large intermittent orders — which describes most B2B and industrial supply chains — the ERP formula is systematically wrong. It either overstocks (most common) or understocks when variability is higher than the formula's assumed distribution. Simulation fits the actual distribution from your order history and finds the policy that genuinely achieves your service level target. The result loads back into your ERP as updated reorder parameters.
A focused safety stock and reorder point study for a single product family or SKU group — fitting distributions, building the model, testing 10–20 policy scenarios — typically takes 2–4 weeks from data receipt to recommendation. Multi-echelon inventory studies covering a distribution network, or combined inventory and warehouse operation models, run 5–9 weeks. We scope the exact timeline and deliverables in the proposal phase before any commitment.
Yes — WIP buffer sizing between production stages is one of the most common use cases. The same stochastic modelling approach applies: instead of supplier lead time variability, you are modelling process time variability and machine downtime; instead of customer demand variability, you are modelling the pace of the downstream production stage. The simulation finds the WIP buffer size that prevents downstream starvation without over-accumulating in-process stock.
Yes — the model is handed over with full documentation and a rerun interface. When new SKUs are added, new suppliers are onboarded, or demand patterns shift, re-run the distribution fitting on the updated data and the model generates new policy recommendations. Many clients schedule an annual rerun as part of their inventory review cycle, and an immediate rerun when a major supplier change or new product launch is planned.
Free consultation

Let's set your inventory policy correctly

Tell us your service level targets and what's driving the stock concern — too much capital tied up, too many stockouts, or both. We'll confirm the right approach and scope the study before any commitment.

Response within 1 business day
Full NDA available as standard
Remote delivery worldwide
Transparent fixed-scope proposal

Germany — Dresden

Anton-Graff-Str. 24, D-01309
dresden@simulatefirst.com
+49 (0) 351 30906020

Poland — Wrocław

ul. Powstańców Śląskich 5, 53-332
polska@simulatefirst.com
+48 75 6406434

We respond within 1 business day · NDA available · No spam, ever

By submitting, your data will be used solely to respond to your enquiry. Privacy policy.