SAPFree calculatorPDF, Excel, Word exportSAP PMManufacturing

Spare Parts Reorder Point and Safety Stock Calculator for SAP PM

Maintenance spares behave differently from production components: demand is lumpy, lead times are long and a stockout stops a line. This calculator gives a defensible reorder point, safety stock and order quantity for the parts that actually move.

Your numbers

units
units
30 days
per unit
per order
%

Your results

Safety stock
5
Enter in the Safety stock field of the MRP 2 view.
Reorder point
11
Enter in the Reorder point field for MRP types VB or VM.
Average daily demand
0.2
Z score
1.6449
Economic order quantity
15
Maximum stock level
26
Use as the target ceiling when replenishing by a fixed lot.
Safety stock value
$925

Assumes normally distributed demand and constant lead time. Critical insurance spares with very low usage need a risk-based decision instead.

Save results:

Safety stock and reorder point vs lead time (days)

Sweeps Replenishment lead time from 5 to 120, holding your other inputs fixed.

Spare parts parameter review

Optional expert review of your MRO reorder points against actual consumption in SAP.

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

How to use it

Take twelve months of goods issues from reservations against maintenance orders for the material, and compute the monthly average and standard deviation. Enter the vendor lead time including receiving, a service level and the cost figures. Copy the safety stock and reorder point into the material master MRP view for the plant, and set an MRP type such as VB for manual reorder point planning.

  • Use consumption statistics, not purchase history, for demand.
  • Strip out one-off shutdown consumption before taking the mean.
  • Use the lead time that includes inspection and put-away.

The formulas

Safety stock equals the Z score for the service level times daily demand deviation times the square root of lead time. Reorder point equals daily demand times lead time plus safety stock. Economic order quantity equals the square root of two times annual demand times order cost divided by unit cost times holding rate. Maximum stock is reorder point plus order quantity, a common ceiling for fixed-lot replenishment.

Where this does and does not apply

This method suits fast and medium moving consumables such as bearings, filters, belts and seals. It is a poor fit for insurance spares like a motor or gearbox, where you stock on criticality and lead time rather than average demand. For those, use a risk review and a one-line min-max of one. Check also whether your vendor offers consignment or a vendor-managed stock.

  • Revisit parameters after every large change in demand or lead time.
  • Use rounded vendor pack sizes when setting the lot size.
  • Flag parts with no movement in 24 months for review.

Frequently Asked Questions

Which SAP MRP types use a reorder point?

Manual reorder point planning uses MRP type VB, and automatic reorder point planning uses VM, where the system calculates the reorder point from consumption and forecast. Both read the safety stock and reorder point on the MRP view.

How do I get demand standard deviation?

Export monthly goods issues for the material over at least 12 months and use the sample standard deviation in Excel. Remove outliers such as one-off projects before calculating.

Does safety stock cover lead time variability?

This tool covers demand variability only. If vendor lead times vary a lot, increase the lead time input toward the realistic late case, or use a combined variance formula.

Should every spare use this calculator?

No. Critical, low usage insurance spares are best chosen by consequence of failure and replacement lead time, not average demand. Use criticality ranking first, then calculate only for consumables.

If you want safety stock and reorder points recalculated from live consumption and written back for approval, Netray can build that with a human approval step.

Talk to an ExpertExplore More Free Tools

Related Tools

SAP

SAP PM Equipment Criticality Ranking Worksheet

Score each equipment item for consequence and likelihood, get a weighted criticality percentage, and use it to assign an ABC indicator in SAP PM.

SAP

SAP PM MTBF, MTTR and Availability Calculator

Feed in operating hours, failure count and breakdown hours from SAP PM notifications. Get MTBF, MTTR, inherent availability and reliability over a mission time.

SAP

SAP PM Repair vs Replace Equipment Calculator

Compare yearly maintenance plus downtime cost of an old asset to the equivalent annual cost of a replacement, with a sweep of rising repair cost.

SAP

SAP PM Wrench Time Loss Calculator

Enter minutes lost per shift to permits, parts, travel, meetings and breaks. See wrench time percent and the yearly labor cost of the losses.

More SAP tools

See all
Back to All Tools