# SyteLine EOQ and Lot Size Calculator

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

## Short answer

Find the economic order quantity for a SyteLine item and see what your current lot size costs per year compared with the optimum.

## Category

syteline

## Erp

Infor SyteLine

## Audience

- Production planner
- Buyer
- SyteLine administrator

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

**Type:** number

**Default:** 85

**Min:** 0

**Step:** 5

**Unit:** $

**Help:** Setup labor and machine time, PO handling, receiving and inspection per lot.

#### Unit cost

**Key:** unit_cost

**Type:** number

**Default:** 12.5

**Min:** 0

**Step:** 0.5

**Unit:** $

#### Annual carrying rate

**Key:** carry_rate

**Type:** slider

**Default:** 22

**Min:** 5

**Max:** 40

**Step:** 1

**Unit:** %

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

#### Current lot size

**Key:** current_lot

**Type:** number

**Default:** 2000

**Min:** 1

**Step:** 100

**Unit:** units

**Outputs:**

#### Holding cost per unit per year

**Key:** hold

**Expr:** unit_cost * carry_rate / 100

**Format:** currency

#### Economic order quantity

**Key:** eoq

**Expr:** ceil(sqrt(2 * annual_demand * setup_cost / hold))

**Format:** integer

**Primary:** true

#### Lots per year at EOQ

**Key:** orders

**Expr:** annual_demand / eoq

**Format:** decimal

#### Days between lots at EOQ

**Key:** interval

**Expr:** 365 / orders

**Format:** days

#### Annual cost at EOQ

**Key:** cost_eoq

**Expr:** annual_demand * setup_cost / eoq + eoq / 2 * hold

**Format:** currency

#### Annual cost at current lot

**Key:** cost_cur

**Expr:** annual_demand * setup_cost / current_lot + current_lot / 2 * hold

**Format:** currency

#### Annual saving available

**Key:** saving

**Expr:** cost_cur - cost_eoq

**Format:** currency

**Primary:** true

**Chart:**

#### EOQ vs cost per order or setup

**Type:** line

**X:** setup_cost

**From:** 10

**To:** 300

**Steps:** 30

**Series:**

- eoq

**Disclaimer:** Classic EOQ assumes steady demand and no quantity discounts. Treat the result as a starting point for lot size rules, then apply supplier minimums and shelf life limits.

## Content

**Intro:** Lot size is one of the most influential parameters on a SyteLine item, driving how many jobs and purchase orders MRP creates. This calculator finds the economic order quantity and shows what your current lot size costs per year.

**Sections:**

#### How to use it

**Body:** Enter annual demand, the true cost of a setup or purchase order, unit cost and your carrying rate. Then enter the lot size currently used on the item. The tool returns the EOQ, how often you would order at that size and the annual saving. The setup cost is the number people underestimate, so include machine downtime, first piece inspection, receiving and invoice matching, not only the buyer's time.

**Bullets:**

- Use standard cost for unit cost, not the latest PO price
- Carrying rates of 15 to 30% are typical for manufacturers
- Test both low and high setup cost to see sensitivity

#### The formula

**Body:** EOQ equals the square root of two times annual demand times setup cost divided by annual holding cost per unit. Total annual cost is ordering cost, demand divided by lot size times setup cost, plus holding cost, half the lot size times holding cost. The curve is flat near the optimum, so lots within 20% of EOQ cost only a few percent more. That is why rounding to pack sizes or order multiples is usually fine.

#### Applying it in SyteLine

**Body:** Use the result to inform the item lot size, minimum order and order multiple settings, then let MRP or APS honor them. Do not use EOQ for items with firm demand lumps, short shelf life, make to order parts or heavy volume discounts. For purchased items, compare the saving with the price break you would give up. A saving of a few dollars per item per year only matters if you multiply it across hundreds of items.

**Bullets:**

- Check supplier minimums and truckload economics first
- Cap lots by shelf life or tooling life
- Review annually when demand or setup times change

**Cta:** If you want lot sizes reviewed across your whole item master using real setup times and demand from SyteLine, we can build that analysis for you.

**Faq:**

#### Is EOQ valid for manufactured items?

**Answer:** Yes, the same logic applies with setup cost replacing order cost. For production, also consider the economic production quantity if the line produces while it is consuming, but EOQ is a reasonable first pass.

#### How do I estimate setup cost?

**Answer:** Multiply setup hours by the loaded work center rate and add scrap during changeover, inspection time and any admin cost per job. Use the job routing setup hours as a starting point.

#### Why is my saving small?

**Answer:** Because the EOQ cost curve is flat. If your current lot is already within a reasonable range of the optimum, the saving will be minor and other levers matter more.

#### Should I always order exactly EOQ?

**Answer:** No. Round to pack size, pallet or tool capacity. The cost of being slightly off is small, while awkward quantities create handling problems.

## Search terms

syteline lot size, economic order quantity calculator, eoq calculator excel, syteline lot sizing, mrp lot size rule, cost of ordering vs holding, optimal batch size, syteline order minimum multiple

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