Oracle EBS EOQ and Order Modifier Calculator
Economic order quantity gives a theoretical best lot size, but Oracle planning then applies order modifiers such as minimum order quantity and fixed lot multiplier. This calculator shows what lot size results and what the modifiers cost you in total annual cost.
Your numbers
Your results
Classic EOQ assumes constant demand, a fixed order cost and no quantity discounts. Real MRP lot sizing also reacts to dependent demand timing and supplier price breaks.
EOQ and planned quantity vs cost per order
Sweeps Cost per order (setup or PO) from 10 to 300, holding your other inputs fixed.
Review lot sizing across your item master
An optional review of order modifiers against real ordering and setup costs.
Optional. The tool and every export work without this. No spam.
How to use it
Enter annual demand, the cost to place or set up an order, the unit cost and your carrying cost rate as a percentage per year. Add the minimum order quantity and fixed lot multiplier set in the item attributes. The tool returns the EOQ, the quantity after the minimum, the final quantity rounded up to a multiple, the number of orders a year and the cost impact of the modifiers. Slide the cost per order to see how setup reduction changes the ideal lot size.
- Carrying rate usually covers capital, storage, insurance and obsolescence
- Use true setup cost including lost capacity for make items
- Compare the cost penalty to the supplier's price break value
The method
EOQ equals the square root of two times annual demand times order cost divided by annual carrying cost per unit, where carrying cost per unit is the carrying rate times unit cost. The annual cost is orders per year times order cost plus average inventory times carrying cost, where average inventory is half the lot size. In Oracle the Minimum Order Quantity sets the smallest planned order, and the Fixed Lot Multiplier makes order quantities multiples of a value, such as a pack or pallet, so the planner never proposes a part pack.
Worked example
Demand of 12,000 a year, 85 per order, 14 per unit and 22 percent carrying gives carrying cost of 3.08 per unit per year and an EOQ of about 812 units. The minimum of 500 does not bind. The lot multiplier of 250 rounds it up to 1,000, which means 12 orders a year. Annual cost rises by a small amount compared with the pure EOQ. The curve is flat near the optimum, so rounding to a pack size usually costs little, and the calculator confirms this with a number.
Common mistakes
Entering carrying cost as a fraction instead of a percent, ignoring the setup cost of a work center, and using EOQ for items with strongly dependent lumpy demand are the usual errors. EOQ also ignores price breaks, so a supplier discount at a higher quantity can beat the EOQ result. Use the tool for steady items and use MRP lot for lot with a multiple for items driven by the master schedule.
Frequently Asked Questions
What is the fixed lot multiplier in Oracle?
It is an item attribute that forces planned order quantities to be a multiple of a value. If the planned requirement is 620 and the multiplier is 250, MRP plans 750. It is typically set to a pack, pallet or tool capacity.
What does minimum order quantity do?
It sets the smallest quantity MRP will plan for an order. If net requirements are below it, MRP plans the minimum, and the excess carries into inventory until used.
How flat is the EOQ cost curve?
Very flat near the optimum. A lot 20 to 30 percent away from EOQ raises total cost only a few percent, which is why rounding to pack sizes usually does little harm.
Should I use EOQ for make items?
Yes if you can state the true setup cost, including lost capacity. For items with dependent demand from a master schedule, lot for lot or period order quantity usually fits better.
Netray can compare the order modifiers on your EBS items with the economics of actual order and setup cost, and list the ones that cost you money.
Related Tools
Oracle EBS Min-Max Planning Calculator
Calculate min and max quantities for Oracle min-max planned items from annual demand, lead time, variability and ordering cost.
OracleOracle EBS Item Lead Time Calculator
Compute total planning lead time for a make or buy item from preprocessing, fixed, variable and postprocessing days.
OracleOracle EBS Average Cost Receipt and PPV Calculator
See how a PO receipt moves weighted average cost, and what the same receipt would book as PPV under standard costing.
OracleOracle EBS Operation Yield and Start Quantity Calculator
Turn routing operation yields and component shrinkage into the start quantity and component requirement for a job.
More Oracle tools
See all- Oracle EBS Discrete Job Statuses Reference
- Oracle EBS Inventory Transaction Types Reference
- Oracle EBS Item Attribute Template Worksheet
- Oracle EBS MRP Exception Messages Reference
- Oracle EBS BOM Interface Load Worksheet
- Oracle EBS Inventory Period Close Checklist
- Oracle EBS WIP Accounting Class Reference
- Oracle EBS Cycle Count Setup Worksheet
- Oracle EBS WIP Job Close Variance Worksheet
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle Fusion EOQ and Fixed Lot Multiple CalculatorCompute the economic order quantity, round it to the supplier pack size, and see what the rounding costs per year.
- Oracle EBS Discrete Manufacturing Go-Live ChecklistA grouped go-live checklist for Oracle Inventory, BOM, WIP and Cost Management covering setup, data, testing and cutover for discrete manufacturers.
- Oracle EBS Item Lead Time CalculatorCompute total planning lead time for a make or buy item from preprocessing, fixed, variable and postprocessing days.
ERP fixes and how-tos
- Oracle EBS Outside Processing and Production SchedulingSet up outside processing in Oracle EBS WIP and Purchasing: OSP items, resources, departments, routing and requisitions, plus how discrete job scheduling works.
- How to Create an Item in Oracle EBSCreate an inventory item in Oracle EBS: Master Items form, master organization, templates, attributes, organization assignment, categories and common errors.
- How to Add a Private AI Layer to Oracle EBS 12.2 On-PremReference architecture for a private AI layer on Oracle EBS 12.2: Active Data Guard replica, ISG REST, MO and responsibility security, local GPUs and audit.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- BarTender and Oracle E-Business Suite: Label Printing from OracleHow BarTender prints labels from Oracle EBS using Oracle XML print requests and Integration Builder: methods, data flows, setup steps, pitfalls and AI help.
AI on your ERP
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to connect Claude to Oracle E-Business SuiteConnect Claude to Oracle E-Business Suite via MCP, the Anthropic API, AWS Bedrock or Vertex, and know when an on-prem open-weight model is the better fit.