# Infor M3 Item Planning Parameter Worksheet: Safety Stock and Reorder Point

> Source: https://netray.co/tools/infor-m3-item-planning-parameter-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Work out safety stock and reorder point for each item and warehouse before loading planning parameters into M3.

## Category

infor-cloudsuite

## Erp

Infor M3

## Audience

- M3 planner
- M3 consultant
- Inventory manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Item number

**Key:** item

**Type:** text

#### Warehouse

**Key:** whlo

**Type:** text

#### Planning method

**Key:** policy

**Type:** select

**Options:**

- Reorder point
- MRP planned
- Min-max
- Manual

#### Average daily demand

**Key:** avg_daily

**Type:** number

**Unit:** units

#### Std dev of daily demand

**Key:** sd_daily

**Type:** number

**Unit:** units

#### Lead time

**Key:** lead_days

**Type:** number

**Unit:** days

#### Service factor (Z)

**Key:** z

**Type:** number

**Help:** 1.28 = 90%, 1.65 = 95%, 2.33 = 99%

#### Safety stock

**Key:** ss

**Type:** number

**Expr:** ceil(z * sd_daily * sqrt(lead_days))

**Format:** integer

#### Reorder point

**Key:** rop

**Type:** number

**Expr:** ceil(avg_daily * lead_days + z * sd_daily * sqrt(lead_days))

**Format:** integer

#### Order multiple

**Key:** lot

**Type:** number

**Rows:**

**Item:** AB1001

**Whlo:** A01

**Policy:** Reorder point

**Avg daily:** 40

**Sd daily:** 12

**Lead days:** 14

**Z:** 1.65

**Lot:** 100

**Item:** AB1002

**Whlo:** A01

**Policy:** MRP planned

**Avg daily:** 15

**Sd daily:** 6

**Lead days:** 28

**Z:** 1.65

**Lot:** 50

**Item:** AB2010

**Whlo:** A02

**Policy:** Min-max

**Avg daily:** 8

**Sd daily:** 3

**Lead days:** 7

**Z:** 1.28

**Lot:** 25

**Item:** AB3100

**Whlo:** A01

**Policy:** Reorder point

**Avg daily:** 120

**Sd daily:** 35

**Lead days:** 10

**Z:** 2.33

**Lot:** 500

**Item:** AB4500

**Whlo:** A03

**Policy:** MRP planned

**Avg daily:** 3

**Sd daily:** 2

**Lead days:** 45

**Z:** 1.65

**Lot:** 10

**Totals:**

#### Total safety stock (units)

**Key:** ss

**Agg:** sum

**Format:** integer

**Notes:** Safety stock uses the standard formula Z x sigma x sqrt(lead time) and assumes independent daily demand and a fixed lead time. Load the resulting values into the item warehouse planning fields in your own test environment, and review items with lumpy or intermittent demand separately.

## Content

**Intro:** Before you load planning parameters into M3, you need a defensible safety stock and reorder point per item and warehouse. This worksheet computes both from demand variability, lead time and your target service level, and gives you a table ready for Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per item and warehouse. Enter average daily demand and its standard deviation from your history, the replenishment lead time in days, and a service factor. The worksheet calculates safety stock and reorder point and totals the safety stock so you can see the inventory investment. Export to Excel and use it as the source for a data load or a review with the planners.

**Bullets:**

- Use at least 6 to 12 months of demand history
- Match the lead time to the real supplier or production time
- Pick the service factor by item class, not one value for all

#### The method

**Body:** Safety stock is Z times the standard deviation of daily demand times the square root of lead time in days. The reorder point is average daily demand times lead time plus the safety stock. Z comes from the normal distribution: about 1.28 for 90 percent, 1.65 for 95 percent and 2.33 for 99 percent cycle service level. The result is rounded up to whole units.

#### Using the results in M3

**Body:** In M3 the item warehouse record holds planning values such as reorder point and safety stock, and the planning method decides how they are used. Reorder point items trigger when balance falls below the point, while MRP planned items use safety stock inside the net requirements calculation. Review the output by planner before loading, and avoid applying a formula to items with sporadic demand.

**Cta:** If you want planning parameters recalculated regularly from your M3 history instead of by hand, we can discuss a read-only analysis agent.

**Faq:**

#### Which service factor should I use?

**Answer:** Use higher values for critical or long lead time items and lower values for cheap, quickly replenished items. A common starting point is 1.65 for 95 percent, then adjust by ABC class and the cost of a stockout.

#### Does this work for MRP planned items?

**Answer:** Yes for the safety stock value, which MRP uses when calculating net requirements. The reorder point is mostly relevant for items planned by reorder point, but it is still a useful check on cover.

#### What if demand is intermittent?

**Answer:** The normal-distribution formula assumes steady demand. For intermittent items use a different approach, such as a service-based fixed quantity or a forecasting method designed for sporadic demand, and review manually.

#### How often should I recalculate?

**Answer:** Review at least quarterly and after major demand or supplier changes. Lead times and variability drift, and stale parameters are a common cause of both stockouts and excess stock.

## Search terms

m3 safety stock, m3 reorder point calculation, infor m3 mrp parameters, m3 planning parameters excel, mitbal reorder point, m3 item warehouse planning template, safety stock reorder point worksheet

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json