SAPFree calculatorPDF, Excel, Word exportSAP S/4HANA

SAP Safety Stock and Reorder Point Calculator

Safety stock in SAP is a single number in the material master, but the right number depends on how demand and lead time both vary. This calculator uses the standard combined variability formula and gives you the safety stock and reorder point ready to key into the MRP views.

Your numbers

units/day

Mean consumption per working day, for example from MC.9 or the consumption values in MM03.

units/day

Spread of daily demand around the mean. Use weekly data divided down if daily history is thin.

days

Planned delivery time plus goods receipt processing time for externally procured parts, or in-house production time for made parts.

days

How much actual lead time varies from the master data value.

Your results

Safety stock (MARC-EISBE)
631
Value to maintain as safety stock in the MRP 2 view.
Reorder point (MARC-MINBE)
2,311
Reorder point for MRP type VM. Stock plus receipts at or below this triggers a requisition.
Z score
1.6449
Standard normal quantile for the chosen service level.
Demand over lead time
1,680
Expected consumption while waiting for replenishment.
Combined variability over lead time
383.0796
Square root of the sum of demand variance and lead time variance effects.
Safety stock in days of demand
5.2583
Handy sanity check against SAP range of coverage settings.

Assumes roughly normal demand and independent demand and lead time variability. For lumpy or intermittent demand, validate with simulation or history before loading into the material master.

Save results:

Safety stock and reorder point vs lead time

Sweeps Replenishment lead time from 1 to 60, holding your other inputs fixed.

Safety stock review from your SAP data

Optional: send us a sample of materials and we will show how this calculation looks when fed from your own consumption and PO history.

Optional. The tool and every export work without this. No spam.

How to use this calculator

Enter average and standard deviation of daily demand, the replenishment lead time and its variability, and pick a cycle service level. The result shows safety stock and a reorder point. For externally procured parts, lead time is the planned delivery time plus goods receipt processing time. For in-house parts, use in-house production time or the scheduled lead time from the routing.

  • Pull demand history from MC.9 or the consumption view in MM03 and compute the standard deviation in Excel.
  • Pull actual lead times from purchase order history in ME2M or ME80FN, comparing delivery dates with order dates.
  • Start at 95% and raise service level only for critical or long lead parts.

The formula behind the result

Safety stock equals Z times the square root of (lead time times demand variance plus mean demand squared times lead time variance). Z comes from the normal distribution for the chosen service level. The reorder point equals mean demand during lead time plus safety stock. This is the classic combined formula used in inventory textbooks and is what most planners mean by statistical safety stock.

  • If lead time never varies, the second term drops out and the formula reduces to Z times demand sigma times root lead time.
  • If demand is constant, only lead time variability drives safety stock.

Where the numbers go in SAP

Safety stock is maintained in the MRP 2 view (field Safety Stock, MARC-EISBE). The reorder point is in the MRP 1 view (field Reorder Point, MARC-MINBE) and is only used by reorder point planning, MRP type VM and VB. MRP types PD use safety stock as a stock buffer against forecast or requirement error but ignore the reorder point. Dynamic safety stock can also be driven by the range of coverage profile, which is a different method that scales buffer with future requirements.

Common mistakes

Planners often set safety stock once and never revisit it. Others add safety time and safety stock together, buffering the same uncertainty twice. A third mistake is using the lead time from master data when real lead times are longer, which understates the reorder point.

  • Review safety stock after any change in supplier, lot size or planned delivery time.
  • Use safety time for timing risk and safety stock for quantity risk, not both for the same risk.
  • Check that the unit of measure of the demand data matches the base unit of measure.

Frequently Asked Questions

Which SAP field holds safety stock?

Safety stock is in the MRP 2 view of the material master, field Safety Stock (MARC-EISBE). The reorder point sits in the MRP 1 view (MARC-MINBE) and applies only to reorder point planning procedures such as MRP type VM.

What service level should I choose?

Ninety five percent is a common starting point for regular A and B parts. Raise it for parts that stop a line, and lower it for cheap parts that are easy to expedite. Each step up costs disproportionately more stock.

Can SAP calculate safety stock automatically?

SAP can compute dynamic safety stock through a range of coverage profile, and S/4HANA also offers MRP Live based planning with safety stock settings. Statistical service level methods usually need a calculation outside the material master, like this one.

Does safety stock in SAP count as available stock?

MRP treats safety stock as stock that should not be consumed to cover normal requirements. If stock falls into the safety stock, MRP issues an exception message to rebuild it.

Netray can read consumption and lead time history directly from your SAP system and propose safety stock and reorder point values by material, for planner approval before anything is changed.