# Oracle Fusion Min-Max and Safety Stock Calculator

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

## Short answer

Work out the min and max quantities and safety stock to load into Oracle Fusion item organization attributes, with a lead time what-if chart.

## Category

oracle

## Erp

Oracle Fusion Cloud SCM

## Audience

- Oracle Cloud consultant
- Inventory planner
- Supply chain analyst

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Average daily demand

**Key:** daily_demand

**Type:** number

**Default:** 120

**Min:** 0

**Step:** 5

**Unit:** units/day

**Help:** Average consumption per working day over a recent stable period.

#### Std deviation of daily demand

**Key:** demand_sd

**Type:** number

**Default:** 35

**Min:** 0

**Step:** 1

**Unit:** units/day

**Help:** Standard deviation of daily usage, from issue transactions or a forecast error report.

#### Replenishment lead time

**Key:** lead_time

**Type:** slider

**Default:** 21

**Min:** 1

**Max:** 90

**Step:** 1

**Unit:** days

**Help:** Supplier or manufacturing lead time, in days.

#### Review period

**Key:** review

**Type:** slider

**Default:** 7

**Min:** 1

**Max:** 30

**Step:** 1

**Unit:** days

**Help:** How often the min-max plan is run and reviewed.

#### Order cycle to cover above min

**Key:** cycle

**Type:** number

**Default:** 14

**Min:** 0

**Step:** 1

**Unit:** days

**Help:** Days of demand added above the min to set the max, which drives order size.

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

**Outputs:**

#### Z score

**Key:** z

**Expr:** normsinv(service)

**Format:** decimal

**Description:** Standard normal factor for the chosen service level.

#### Demand std dev over lead time plus review

**Key:** sigma

**Expr:** sqrt((lead_time + review) * demand_sd * demand_sd)

**Format:** decimal

#### Safety stock

**Key:** ss

**Expr:** z * sigma

**Format:** integer

**Description:** Buffer held against demand variability.

#### Min quantity

**Key:** min_qty

**Expr:** daily_demand * (lead_time + review) + ss

**Format:** integer

**Primary:** true

**Description:** Reorder trigger: demand over lead time plus review, plus safety stock.

#### Max quantity

**Key:** max_qty

**Expr:** min_qty + daily_demand * cycle

**Format:** integer

**Primary:** true

**Description:** Order-up-to level; the gap between available supply and max sets the order.

#### Typical order size

**Key:** order_qty

**Expr:** max_qty - min_qty

**Format:** integer

**Chart:**

#### Min and safety stock vs lead time

**Type:** line

**X:** lead_time

**From:** 1

**To:** 90

**Steps:** 30

**Series:**

- min_qty
- ss

**Disclaimer:** Assumes normally distributed daily demand and a constant lead time. Validate against your own usage history before loading values into item attributes.

## Content

**Intro:** Min-max planning in Oracle Fusion Inventory Management compares available supply to a minimum and a maximum quantity held on the item organization. This calculator turns demand, variability and lead time into defensible values for both, so you are not loading round numbers someone guessed.

**Sections:**

#### How to use the calculator

**Body:** Pull average daily usage and its standard deviation from your inventory issue history, usually a rolling 6 to 12 months with one-off spikes removed. Enter the replenishment lead time and how often min-max planning is run. Choose a service level that matches the item class: A items often justify 97.5% or 99%, C items 90%. The result gives safety stock, the min and the max. Load the min and max into the planning attributes of the item for the inventory organization, then test one planning run on a few items before mass loading through a file-based import.

#### The formula behind the result

**Body:** Safety stock is Z multiplied by the standard deviation of demand over the exposure window. The window is lead time plus review period, because stock must survive both the wait for supply and the gap until the next check. Standard deviation scales with the square root of time, so doubling lead time raises safety stock by about 41%, not 100%. The min equals expected demand over that window plus safety stock. The max adds the demand for your chosen order cycle, which fixes the average order size.

**Bullets:**

- Safety stock = Z x demand std dev x sqrt(lead time + review)
- Min = daily demand x (lead time + review) + safety stock
- Max = min + daily demand x order cycle days

#### Reading the chart and common mistakes

**Body:** The chart sweeps lead time and shows how the min and the safety stock grow, which helps when negotiating shorter supplier lead times: cutting lead time often frees more stock than lowering the service level. Typical mistakes are using monthly standard deviation with a daily demand figure, ignoring the review period, leaving supplier lead time at the quoted value rather than the observed one, and applying the same service level to every item. Revisit values after any change in supplier, season or forecast method.

**Cta:** If you want min-max values recalculated from live Oracle usage data on a schedule, with a human approving each change, we can build that. It is optional; the calculator works on its own.

**Faq:**

#### Is this the same method Oracle uses for min-max planning?

**Answer:** Oracle compares on-hand plus incoming supply to the min and max you store on the item and creates replenishment when supply falls below the min. It does not derive the min and max for you. This tool provides a standard statistical way to choose those two values.

#### Which service level should I choose?

**Answer:** Pick by item importance and cost. High-value or line-stopping parts usually justify 97.5% to 99%, while cheap, easily substituted items are fine at 90% to 95%. Higher service levels raise safety stock sharply, so apply them selectively.

#### What if demand is intermittent or lumpy?

**Answer:** The normal approximation breaks down for items with many zero-demand days. For those, use a larger review window such as weekly or monthly demand, or set the stock by a fixed number of orders of cover instead of a statistical buffer.

#### Does it include supplier lead time variability?

**Answer:** Not directly. If lead time varies a lot, add the variance in quadrature outside this tool or use the worst credible lead time as the input. Many planners use the 90th percentile of observed receipt lead times.

## Search terms

oracle fusion min max planning, oracle fusion safety stock calculation, min max quantity calculator, oracle inventory min-max planning setup, safety stock formula service level, reorder point calculator, oracle fusion inventory planning attributes, min max replenishment calculator

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