OracleFree calculatorPDF, Excel, Word exportOracle E-Business SuiteDiscrete Manufacturing

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

units
85 $
$
%
units
units

Your results

Economic order quantity
814
Square root of 2DS over H, with H as carrying cost per unit per year.
After fixed lot multiplier
1,000
Rounded up to a multiple of the lot multiplier.
After minimum order quantity
814
Orders per year
12
Annual cost at EOQ
$2,507
Annual cost at planned quantity
$2,560
Ordering plus carrying cost at the adjusted quantity.
Cost of the modifiers
$53

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.

Save results:

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.

Talk to an ExpertExplore More Free Tools

Related Tools

Oracle

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.

Oracle

Oracle EBS Item Lead Time Calculator

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

Oracle

Oracle 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.

Oracle

Oracle 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
Back to All Tools