# Oracle Fusion EOQ and Fixed Lot Multiple Calculator

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

## Short answer

Compute the economic order quantity, round it to the supplier pack size, and see what the rounding costs per year.

## Category

oracle

## Erp

Oracle Fusion Cloud SCM

## Audience

- Oracle Cloud consultant
- Supply planner
- Buyer

## Tool

**Kind:** calculator

**Currency:** $

**Inputs:**

#### Annual demand

**Key:** annual_demand

**Type:** number

**Default:** 24000

**Min:** 0

**Step:** 500

**Unit:** units/year

#### Cost per order

**Key:** order_cost

**Type:** number

**Default:** 85

**Min:** 0

**Step:** 5

**Unit:** $

**Help:** Buyer time, receiving, invoice matching and freight per order, not item price.

#### Unit cost

**Key:** unit_cost

**Type:** number

**Default:** 12.5

**Min:** 0

**Step:** 0.5

**Unit:** $

#### Annual holding cost rate

**Key:** hold_rate

**Type:** number

**Default:** 22

**Min:** 0

**Max:** 80

**Step:** 1

**Unit:** %

**Help:** Capital, storage, insurance and obsolescence as a share of unit cost.

#### Fixed lot multiple / pack size

**Key:** multiple

**Type:** number

**Default:** 250

**Min:** 1

**Step:** 10

**Unit:** units

**Help:** Supplier pallet, case or standard pack quantity.

**Outputs:**

#### Holding cost per unit per year

**Key:** hold_unit

**Expr:** unit_cost * hold_rate / 100

**Format:** currency

#### Economic order quantity

**Key:** eoq

**Expr:** sqrt(2 * annual_demand * order_cost / hold_unit)

**Format:** integer

**Description:** Unrounded optimum lot.

#### Lot after rounding to multiple

**Key:** lot

**Expr:** max(multiple, ceil(eoq / multiple) * multiple)

**Format:** integer

**Primary:** true

**Description:** Value to use as order quantity respecting the multiple.

#### Orders per year

**Key:** orders

**Expr:** annual_demand / lot

**Format:** decimal

#### Annual ordering plus holding cost

**Key:** annual_cost

**Expr:** orders * order_cost + lot / 2 * hold_unit

**Format:** currency

**Primary:** true

#### Cost at unrounded EOQ

**Key:** eoq_cost

**Expr:** sqrt(2 * annual_demand * order_cost * hold_unit)

**Format:** currency

#### Cost of rounding

**Key:** penalty

**Expr:** annual_cost - eoq_cost

**Format:** currency

**Description:** Extra yearly cost caused by the lot multiple.

**Chart:**

#### EOQ and rounded lot vs cost per order

**Type:** line

**X:** order_cost

**From:** 10

**To:** 300

**Steps:** 30

**Series:**

- eoq
- lot

**Disclaimer:** Classic EOQ assumes constant demand, instant replenishment and no quantity discounts. Treat the result as a starting point.

## Content

**Intro:** The economic order quantity balances ordering cost against holding cost. In Oracle Fusion planning you then express the answer through item order modifiers such as a fixed lot multiple or minimum order quantity. This calculator gives the optimum and the cost of rounding it to a real pack size.

**Sections:**

#### How to use it

**Body:** Enter yearly demand, the fully loaded cost of placing one order, the unit cost and an annual holding rate. Most companies use 15% to 30% for holding. Then enter the supplier pack size or pallet quantity. The tool returns the pure EOQ, the lot rounded up to a whole multiple, orders per year and the cost penalty from rounding. If the penalty is small, set the rounded lot as the order modifier on the item. If it is large, negotiate a smaller pack or consolidate orders across items.

#### The math

**Body:** EOQ equals the square root of two times demand times order cost, divided by holding cost per unit. Total annual cost is orders per year times order cost plus average inventory, half the lot, times holding cost per unit. At the true EOQ the two cost parts are equal, and total cost is flat near the optimum, so rounding by 10% to 20% costs very little. Rounding by 100% or more can matter. The calculator shows both numbers so you can judge it.

**Bullets:**

- EOQ = sqrt(2 x D x S / H)
- H = unit cost x holding rate
- Annual cost = (D / Q) x S + (Q / 2) x H

#### Common mistakes

**Body:** People often put the item price in the order cost field, or use a holding rate that omits capital cost. Others forget that EOQ ignores volume discounts, shelf life and storage limits. For perishable or high-obsolescence items, cap the lot at a few weeks of demand regardless of the formula. In a planning system, also remember a minimum order quantity and a fixed lot multiple interact: the system first applies the minimum, then rounds up to the multiple.

**Cta:** If you want lot sizes recalculated across thousands of items from your Oracle cost and demand data, we can build that review as an optional project. The calculator stands alone.

**Faq:**

#### Should I use EOQ for every item?

**Answer:** No. EOQ suits stable, independent demand with meaningful ordering cost. For dependent demand in MRP, lot-for-lot or period-of-supply sizing is often better, and for tiny or very cheap items a simple min-max rule is enough.

#### What holding rate should I use?

**Answer:** Add your cost of capital, storage and handling, insurance, shrinkage and obsolescence. Between 15% and 30% of unit cost per year is common in manufacturing. Use a higher figure for electronics or items that age quickly.

#### What does the cost of rounding mean?

**Answer:** It is the extra annual ordering plus holding cost you pay because supply comes only in whole multiples. A small figure means the pack size is not a problem. A large figure suggests negotiating pack size or order frequency.

#### How do minimum order quantity and lot multiple combine?

**Answer:** Generally the quantity is first raised to the minimum, then rounded up to the next whole multiple. This tool enforces at least one multiple. If you also have a minimum, take the larger of that and the result shown.

## Search terms

oracle fusion fixed lot multiple, oracle fusion fixed order quantity, eoq calculator, economic order quantity formula, oracle supply planning order modifiers, lot size calculator, ordering cost holding cost calculator, eoq with order multiple

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