# QAD EOQ and Reorder Point Calculator

> Source: https://netray.co/tools/qad-order-policy-eoq-reorder-point-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Calculate economic order quantity, safety stock and reorder point for an item, with a lead-time sweep, to set QAD item planning values on evidence.

## Category

other-erp

## Erp

QAD Adaptive ERP

## Industry

Discrete Manufacturing

## Audience

- Planner
- Buyer
- Inventory manager

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual demand

**Key:** annual_demand

**Type:** number

**Default:** 24000

**Min:** 0

**Step:** 500

**Unit:** units

#### Cost per order or setup

**Key:** order_cost

**Type:** number

**Default:** 85

**Min:** 0

**Step:** 5

**Unit:** $

**Help:** Purchasing or changeover cost incurred each time you order.

#### Unit cost

**Key:** unit_cost

**Type:** number

**Default:** 12

**Min:** 0

**Step:** 0.5

**Unit:** $

#### Annual carrying cost rate

**Key:** carry_pct

**Type:** number

**Default:** 22

**Min:** 1

**Max:** 60

**Step:** 1

**Unit:** % of unit cost

**Help:** Capital, storage, insurance, obsolescence.

#### Replenishment lead time

**Key:** lead_time

**Type:** slider

**Default:** 21

**Min:** 1

**Max:** 120

**Step:** 1

**Unit:** days

#### Std deviation of daily demand

**Key:** sigma

**Type:** number

**Default:** 18

**Min:** 0

**Step:** 1

**Unit:** units per day

**Help:** Measure from recent daily or weekly history.

#### Cycle 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:**

#### Economic order quantity

**Key:** eoq

**Expr:** sqrt(2 * annual_demand * order_cost / (unit_cost * carry_pct / 100))

**Format:** integer

**Primary:** true

**Description:** Order size that balances ordering and carrying cost.

#### Orders per year

**Key:** orders_per_year

**Expr:** annual_demand / eoq

**Format:** decimal

#### Z score

**Key:** z

**Expr:** normsinv(service)

**Format:** decimal

#### Safety stock

**Key:** ss

**Expr:** z * sigma * sqrt(lead_time)

**Format:** integer

**Primary:** true

**Description:** Buffer against demand variation during lead time.

#### Reorder point

**Key:** rop

**Expr:** annual_demand / 365 * lead_time + ss

**Format:** integer

**Description:** Average lead-time demand plus safety stock.

#### Annual ordering plus carrying cost

**Key:** annual_cost

**Expr:** annual_demand / eoq * order_cost + (eoq / 2 + ss) * unit_cost * carry_pct / 100

**Format:** currency

**Chart:**

#### Safety stock and reorder point vs lead time

**Type:** line

**X:** lead_time

**From:** 1

**To:** 90

**Steps:** 30

**Series:**

- ss
- rop

**Disclaimer:** Assumes normally distributed demand and constant lead time. Validate against your own history and review lot-size and minimum order constraints.

## Content

**Intro:** Item planning data in QAD, such as order policy, safety stock and order quantity, is often set once and left for years. This calculator derives defensible starting values from demand, cost and lead time so planners can revisit them with evidence.

**Sections:**

#### How to use it

**Body:** Enter annual demand, the cost of placing one order, the unit cost and your carrying cost rate. Then enter the replenishment lead time and the standard deviation of daily demand taken from recent history. Choose the cycle service level you want to hit: it is the probability of not stocking out during a replenishment cycle. The results give an order quantity, a safety stock and a reorder point you can compare with what the planning record holds today. Drag the lead time slider to see how a slower supplier inflates the buffer.

**Bullets:**

- Use demand history from the same period for mean and deviation
- Treat lead time as receipt to receipt, not order to ship
- Round order quantity to supplier pack sizes afterwards
- Review high-value items first

#### Formulas used

**Body:** Economic order quantity is the square root of two times annual demand times order cost, divided by unit cost times carrying rate. Safety stock is the Z score for the service level times the daily demand deviation times the square root of lead time. Reorder point is average daily demand times lead time plus safety stock. Annual cost adds ordering cost, cycle stock carrying cost for half the order quantity, and carrying cost on safety stock.

#### Reading the result

**Body:** Safety stock grows with the square root of lead time, so halving the lead time cuts the buffer by roughly 30 percent, not 50. Raising service level from 95 to 99 percent increases the Z score from about 1.64 to 2.33, a large step in stock for a small gain in availability. If safety stock dwarfs cycle stock, the better lever is usually supplier reliability or demand visibility rather than more inventory. Class items by value before applying one policy to all.

#### Common mistakes

**Body:** Using monthly deviation as if it were daily inflates safety stock, so convert units first. Applying EOQ where a supplier imposes minimums or price breaks gives a quantity you cannot buy. Ignoring lead time variability understates risk for imported parts. Finally, a formula is a starting point: lumpy or project-driven demand does not follow the normal assumption, and these items often need time-phased planning instead.

**Cta:** If you would like item planning parameters analysed across your whole item master rather than one part at a time, Netray can help build that from your ERP data.

**Faq:**

#### Where do these values go in QAD?

**Answer:** Item planning data such as safety stock, order quantity and order policy is maintained on the item planning record. Menu names differ by release, so confirm the program in your own menu before loading values in bulk.

#### What service level should I pick?

**Answer:** Match it to item importance. Many plants use 95 to 99 percent for critical or long lead items and 90 to 95 percent for low-value commodity parts, then review cost against stockout impact.

#### How do I get demand deviation?

**Answer:** Export daily or weekly usage for the past 6 to 12 months, compute the standard deviation, and convert to a daily figure if you used weekly buckets by dividing by the square root of days in the bucket.

#### Is EOQ still relevant for MRP-driven items?

**Answer:** For stable, continuous-demand items it is a sound starting point. For items planned lot for lot against firm requirements, safety stock still helps but EOQ matters less.

## Search terms

QAD safety stock calculation, QAD reorder point, QAD order policy EOQ, economic order quantity calculator, safety stock calculator service level, QAD item planning data, reorder point formula, QAD MRP safety stock

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