# Oracle EBS Item Lead Time Calculator (Fixed and Variable)

> Source: https://netray.co/tools/oracle-ebs-item-lead-time-calculator
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

Compute total planning lead time for a make or buy item from preprocessing, fixed, variable and postprocessing days.

## Category

oracle

## Erp

Oracle E-Business Suite

## Industry

Discrete Manufacturing

## Audience

- EBS MRP planner
- EBS functional consultant
- Master data owner

## Tool

**Kind:** calculator

**Inputs:**

#### Preprocessing lead time

**Key:** pre_days

**Type:** number

**Default:** 2

**Min:** 0

**Step:** 1

**Unit:** work days

**Help:** Time to prepare a PO or job before it starts (buy items usually).

#### Fixed lead time

**Key:** fixed_days

**Type:** number

**Default:** 3

**Min:** 0

**Step:** 0.5

**Unit:** work days

**Help:** Time that does not depend on order quantity (setup, queue).

#### Variable lead time

**Key:** var_days

**Type:** number

**Default:** 0.02

**Min:** 0

**Step:** 0.005

**Unit:** days per unit

**Help:** Additional time per unit of order quantity.

#### Order quantity

**Key:** order_qty

**Type:** slider

**Default:** 150

**Min:** 1

**Max:** 1000

**Step:** 1

**Unit:** units

#### Postprocessing lead time

**Key:** post_days

**Type:** number

**Default:** 1

**Min:** 0

**Step:** 1

**Unit:** work days

**Help:** Receiving, inspection and putaway after completion.

#### Working days per week

**Key:** work_days_wk

**Type:** select

**Default:** 5

**Options:**

##### 5 days

**Value:** 5

##### 6 days

**Value:** 6

##### 7 days

**Value:** 7

**Outputs:**

#### Processing lead time

**Key:** processing

**Expr:** ceil(fixed_days + var_days * order_qty)

**Format:** days

**Description:** Fixed plus variable times quantity, rounded up to whole days.

#### Total lead time (work days)

**Key:** total_work

**Expr:** pre_days + processing + post_days

**Format:** days

**Primary:** true

#### Approximate calendar days

**Key:** calendar

**Expr:** ceil(total_work * 7 / work_days_wk)

**Format:** days

**Primary:** true

**Description:** Converted using your working days per week. Holidays and shop calendar exceptions are not included.

#### Approximate weeks

**Key:** weeks

**Expr:** calendar / 7

**Format:** weeks

#### Variable portion of processing

**Key:** var_share

**Expr:** var_days * order_qty / max(1, fixed_days + var_days * order_qty) * 100

**Format:** percent

**Chart:**

#### Total lead time vs order quantity

**Type:** line

**X:** order_qty

**From:** 1

**To:** 1000

**Steps:** 40

**Series:**

- total_work
- calendar

**Disclaimer:** Approximation for planning discussions. Oracle schedules against the manufacturing calendar and the lead time source (item attributes or routing), so real dates will differ around weekends and holidays.

## Content

**Intro:** Oracle MRP offsets a planned order start date from the due date by the item's lead time, which is built from preprocessing, processing (fixed plus variable) and postprocessing days. This calculator shows the effect of each component and of order quantity on the total.

**Sections:**

#### How to use it

**Body:** Take the values from the Lead Times region of the Item Attributes: Preprocessing, Processing, Postprocessing, Fixed and Variable lead time. Enter the order quantity you plan to use. The tool adds fixed time to variable time multiplied by quantity, then adds preprocessing and postprocessing. Switch the working days per week to see the calendar effect of a six day shop. Use the chart to find the quantity where lead time starts to climb enough that splitting the order into two jobs would help.

**Bullets:**

- Check the Make or Buy flag: buy items use preprocessing and postprocessing
- Compare the result to the supplier's quoted lead time
- Reflect the value in the Planning attributes before the next plan run

#### How Oracle uses lead time

**Body:** For make items, MRP derives lead time from fixed and variable lead time and the order quantity, which makes lead time sensitive to lot size. For buy items, preprocessing and postprocessing cover internal handling before the order is placed and after it is received. Cumulative lead time, which adds up the longest path through the bill, is what customers actually wait for when material is not on the shelf. This tool covers a single level, so add your sub assembly paths when you quote a delivery date.

#### Worked example

**Body:** With the defaults, processing is 3 plus 0.02 times 150, which is 6 days. Adding two days preprocessing and one day postprocessing gives 9 work days. On a five day week that is about 13 calendar days, close to two weeks. Increase the order quantity to 500 and processing becomes 13 days, total 16 work days, 23 calendar days. That is a useful conversation with sales when someone asks for a large lot with the same promise date.

#### Common mistakes

**Body:** Lead time values copied from a legacy system are often wrong: too long, padded for old problems, or too short based on the best case. Padding on top of padding at each level of the bill inflates cumulative lead time and drives excess inventory. Measure actual lead times from receipt history and WIP completion dates, then update the item attributes. Also check that lead times are in days, not hours, and that variable lead time is per unit and not per batch.

**Cta:** Netray can compare the lead times on your EBS item master with actual receipt and completion history, and list the items where they disagree.

**Faq:**

#### What is the difference between fixed and variable lead time?

**Answer:** Fixed lead time applies regardless of quantity, for example setup and queue. Variable lead time is the extra time per unit, so a bigger order takes longer. Processing lead time is the fixed part plus variable multiplied by the order quantity.

#### Does MRP use calendar days or work days?

**Answer:** MRP schedules against the manufacturing calendar, so lead times in the item attributes are treated as working days and skip non working days. This tool converts to approximate calendar days only to give you an easy comparison.

#### Where do I set preprocessing and postprocessing?

**Answer:** They are on the Item Attributes lead times region of the Master Item form in Oracle Inventory. Preprocessing and postprocessing mainly matter for buy items, and processing lead time for make items.

#### How do I find real lead times?

**Answer:** Compare PO approval or need by dates with actual receipt dates for buy items, and job release dates with completion dates for make items. Take a median across recent orders and update item attributes with that rather than a worst case.

## Search terms

oracle ebs item lead time, oracle fixed lead time variable lead time, preprocessing lead time oracle, postprocessing lead time oracle mrp, oracle ebs planned order start date, mrp lead time calculation oracle

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