# SyteLine Reorder Point and Safety Stock Calculator > Source: https://netray.co/tools/syteline-reorder-point-safety-stock-calculator > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer Work out statistically sound safety stock and reorder point values for SyteLine items from demand variability, lead time and service level. ## Category syteline ## Erp Infor SyteLine ## Audience - Inventory planner - SyteLine administrator - Materials manager ## Tool **Kind:** calculator **Currency:** $ **Inputs:** #### Average daily demand **Key:** avg_daily **Type:** number **Default:** 120 **Min:** 0 **Step:** 5 **Unit:** units/day **Help:** Mean usage per working day from your demand history. #### Std deviation of daily demand **Key:** sd_daily **Type:** number **Default:** 35 **Min:** 0 **Step:** 1 **Unit:** units/day **Help:** Standard deviation of daily usage over the same period. #### Replenishment lead time **Key:** lead_time **Type:** slider **Default:** 14 **Min:** 1 **Max:** 90 **Step:** 1 **Unit:** days **Help:** Working days from order release to stock availability. #### Target service level **Key:** service **Type:** select **Default:** 0.95 **Options:** ##### 90% **Value:** 0.9 ##### 95% **Value:** 0.95 ##### 97.5% **Value:** 0.975 ##### 99% **Value:** 0.99 #### Unit cost **Key:** unit_cost **Type:** number **Default:** 18.5 **Min:** 0 **Step:** 0.5 **Unit:** $ **Help:** Used only to value the safety stock. **Outputs:** #### Z score for service level **Key:** z **Expr:** normsinv(service) **Format:** decimal #### Demand during lead time **Key:** lt_demand **Expr:** avg_daily * lead_time **Format:** integer #### Safety stock **Key:** ss **Expr:** ceil(z * sd_daily * sqrt(lead_time)) **Format:** integer **Primary:** true **Description:** Value to consider for the item safety stock field. #### Reorder point **Key:** rop **Expr:** lt_demand + ss **Format:** integer **Primary:** true **Description:** Lead time demand plus safety stock. #### Safety stock coverage **Key:** ss_days **Expr:** ss / avg_daily **Format:** days #### Safety stock value **Key:** ss_value **Expr:** ss * unit_cost **Format:** currency **Chart:** #### Safety stock and reorder point vs lead time **Type:** line **X:** lead_time **From:** 1 **To:** 60 **Steps:** 30 **Series:** - ss - rop **Disclaimer:** Assumes normally distributed daily demand and a constant lead time. Validate against your own history before changing item parameters. ## Content **Intro:** Safety stock and reorder point values on SyteLine items are often set once at implementation and never revisited. This calculator gives a defensible number from demand variability, lead time and the service level you want to hold. **Sections:** #### How to use the calculator **Body:** Pull average and standard deviation of daily usage for the item from your transaction history, for example an export of inventory issues for the last 6 to 12 months. Enter the replenishment lead time in working days, choose a service level and the unit cost. The result is a safety stock quantity, a reorder point and the cash tied up in the buffer. Compare the output with what is currently on the item record before you change anything. **Bullets:** - Use working days consistently for demand and lead time - Exclude one off spikes such as a single large project order - Run it per item, or per ABC class with a representative item #### The formula behind it **Body:** Safety stock equals Z multiplied by the standard deviation of daily demand multiplied by the square root of lead time. Z comes from the inverse normal distribution at your target cycle service level, about 1.64 for 95% and 2.33 for 99%. The reorder point is average daily demand times lead time plus safety stock. The square root term means doubling lead time raises the buffer by about 41%, not 100%, which the chart makes visible. #### Reading the results and common mistakes **Body:** A high safety stock coverage in days for a slow item often means demand is lumpy and the normal assumption is weak; consider a min order policy or make to order instead. Variability of the lead time itself is not included, so add a margin for unreliable suppliers. Remember that MRP in SyteLine nets safety stock like any other demand, so an inflated value inflates planned orders. **Bullets:** - Do not apply one service level to every item, tier by ABC class - Recalculate after a supplier or lead time change - Check units of measure match between demand and lead time **Cta:** If you want these values recalculated across thousands of items directly from live SyteLine data, with the proposed changes reviewed before anything is written back, we can set that up. **Faq:** #### Which service level should I choose? **Answer:** Start with 95% for regular items and 98 to 99% only for critical or long lead parts where a stockout stops production. Each step up in service level increases the buffer more than the last, so price it using the value output. #### Does this replace MRP planning parameters? **Answer:** No. It only produces a number for the safety stock and reorder point fields. Your lot sizing rule, planning time fences and order policies still drive what MRP creates. #### What if demand is not normally distributed? **Answer:** For intermittent or lumpy demand the formula can understate risk. Use a larger sample, an empirical percentile of lead time demand, or manage the item with a min and max policy instead. #### How often should I recalculate? **Answer:** Quarterly for A items and at least annually for the rest, or whenever lead times, supplier or demand patterns change materially. ## Search terms syteline safety stock, syteline reorder point, syteline item safety stock calculation, safety stock calculator excel, reorder point formula, cloudsuite industrial safety stock, mrp safety stock setup, service level safety stock --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json