# D365 Item Coverage Min/Max and Safety Stock Calculator

> Source: https://netray.co/tools/d365-item-coverage-min-max-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compute reorder point style minimum, maximum and safety stock values to enter on D365 item coverage, using demand variability and service level.

## Category

microsoft-dynamics

## Erp

Microsoft Dynamics 365 Finance and Supply Chain Management

## Audience

- Master planner
- D365 supply chain consultant
- Inventory manager

## Tool

**Kind:** calculator

**Inputs:**

#### Average daily demand

**Key:** demand

**Type:** number

**Default:** 40

**Min:** 0

**Step:** 1

**Unit:** units/day

#### Standard deviation of daily demand

**Key:** sd

**Type:** number

**Default:** 12

**Min:** 0

**Step:** 0.5

**Unit:** units/day

**Help:** Calculate from history, ideally 6 to 12 months of daily or weekly data.

#### Replenishment lead time

**Key:** lead

**Type:** slider

**Default:** 14

**Min:** 1

**Max:** 90

**Step:** 1

**Unit:** days

#### 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

#### Order quantity (lot size)

**Key:** order_qty

**Type:** number

**Default:** 600

**Min:** 1

**Step:** 10

**Unit:** units

**Help:** Standard order quantity or multiple on the item.

**Outputs:**

#### Z score for service level

**Key:** z

**Expr:** normsinv(service)

**Format:** decimal

#### Safety stock

**Key:** ss

**Expr:** z * sd * sqrt(lead)

**Format:** integer

**Primary:** true

**Description:** Buffer against demand variation over the lead time, assuming a fixed lead time.

#### Demand during lead time

**Key:** ltd

**Expr:** demand * lead

**Format:** integer

#### Minimum (reorder point)

**Key:** min_qty

**Expr:** ltd + ss

**Format:** integer

**Primary:** true

#### Maximum

**Key:** max_qty

**Expr:** min_qty + order_qty

**Format:** integer

#### Safety stock coverage

**Key:** cover_days

**Expr:** ss / max(demand, 0.0001)

**Format:** days

**Chart:**

#### Minimum and safety stock vs lead time

**Type:** line

**X:** lead

**From:** 1

**To:** 90

**Steps:** 30

**Series:**

- min_qty
- ss

**Disclaimer:** Assumes roughly normal demand and constant lead time. Intermittent or lumpy demand needs a different method.

## Content

**Intro:** Min/max coverage in D365 master planning needs numbers someone has to choose. This calculator derives minimum, maximum and safety stock from demand, variability, lead time and the service level you want to hold.

**Sections:**

#### How to use it

**Body:** Pull daily or weekly demand for the item, compute the average and the standard deviation, and enter them with the replenishment lead time. Choose a service level that fits the item's importance. Enter the standard order quantity. The minimum can go on the item coverage record, with the maximum set above it. In a min/max coverage code, planning creates a planned order when projected stock falls below the minimum.

#### The method

**Body:** Safety stock is the Z score for the service level times the standard deviation of daily demand times the square root of lead time days. The square root reflects that independent daily variations partly cancel out. The minimum is lead time demand plus safety stock. The maximum here is the minimum plus one order quantity, a common simplification.

**Bullets:**

- Safety stock = Z x sigma x sqrt(lead time)
- Minimum = demand x lead time + safety stock
- Maximum = minimum + order quantity

#### Reading the results

**Body:** Raising service from 95 to 99 percent increases the Z score from about 1.64 to 2.33, so safety stock rises by around 40 percent. That is a good argument for segmenting items: hold 99 percent on critical parts and 90 percent on easy-to-replace ones. The chart shows how lead time drives the minimum; shortening supplier lead time is often cheaper than holding stock.

#### Common mistakes

**Body:** Using monthly standard deviation with daily demand is the classic unit error, so keep periods consistent. Another is ignoring lead time variability, which makes this formula optimistic for unreliable suppliers. Finally, do not leave the values static for years: schedule a review so minimums follow demand, and be careful that safety stock is not double counted if you also use a time fence or a safety margin on the coverage group.

**Cta:** If you want safety stock recalculated automatically from live D365 demand history and reviewed by planners before changes, Netray can build that with your partner.

**Faq:**

#### Which D365 fields does this feed?

**Answer:** The minimum and maximum feed the item coverage record when the coverage code is min/max. Safety stock can also be maintained as a minimum quantity on the coverage setup. Check how your coverage group treats it.

#### What if demand is intermittent?

**Answer:** Normal-distribution methods overstate or understate buffers for spare parts with sporadic demand. Use a bootstrapping or Croston-type approach, or set parts manually based on criticality and cost of a stockout.

#### Is the service level the fill rate?

**Answer:** No. It is the probability of not stocking out during a replenishment cycle, often called cycle service level. Fill rate, the share of demand met from stock, is higher for the same safety stock.

#### How often should I recalculate?

**Answer:** Quarterly is a reasonable default for stable items and monthly for fast movers or seasonal items. Recalculate immediately when a supplier or lead time changes.

## Search terms

d365 item coverage min max, d365 safety stock calculation, dynamics 365 master planning minimum maximum, d365 coverage group min/max, d365 reorder point calculation, d365 safety stock service level, d365 f&o inventory planning

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