ERP & MRP Planning calculator
Economic Order Quantity Calculator
Economic Order Quantity (EOQ) is the planning lot size that balances how often you order or produce against how much you hold each time. In an ERP or MRP setting, planners use a practical variant: take annual demand, divide it across the number of order cycles you intend to run per year, and scale by a lot-size adjustment factor that reflects minimums, multiples, or packaging rounding. The result is a starting order quantity you then reconcile against your ERP's min, max, fixed, and multiple lot-size rules. This calculator gives material planners and buyers a defensible base lot size before those system constraints round it.
What this calculator does
- Estimate a practical manufacturing order quantity from annual demand, planned order cycles, and lot-size adjustment.
- a materials planner needs a quick production or purchase lot-size check
- It divides annual demand by planned order cycles per year and applies a lot-size adjustment factor to return a planning order quantity.
Formula used
- Planning order quantity = annual demand quantity ÷ planned order cycles per year × lot-size adjustment factor
- Compare the result with ERP minimum, maximum, fixed, and multiple lot-size rules.
Inputs explained
- Annual demand quantity: Use forecast plus firm demand for the item, customer group, or production family.
- Planned order cycles per year: Use the number of replenishment or production orders expected in a year.
- Lot-size adjustment factor: Use 1.0 for a straight average lot, or adjust for MOQ, pack quantity, yield, or batching policy.
How to use the result
- Use it when setting or reviewing lot-sizing parameters in ERP/MRP for a part, before applying min, max, fixed, or multiple lot-size rules.
- This is a cycle-based planning lot size, not the classic square-root EOQ; it does not directly weigh ordering cost against holding cost, so validate the order-cycle count against those economics separately.
Current U.S. benchmarks
- Manufacturing hourly earnings average $30.27 (BLS, Jun 2026), up 4.4% from a year earlier. Median machinist pay is $28.24/hr (OEWS 2025), with state medians on each state page. Manufacturers have 529k open positions nationally (BLS JOLTS).
- U.S. manufacturing runs at 75.6% of capacity (Federal Reserve, May 2026). New factory orders are up 2.3% year over year (Census).
Common questions
- How do you calculate economic order quantity here? Divide annual demand by planned order cycles per year, then multiply by the lot-size adjustment factor. With 24,000 units/yr over 48 cycles at a 1.1x factor, the base is 500 units per cycle and the adjusted EOQ is 550 units.
- What is a good economic order quantity? A good EOQ orders often enough to keep inventory low without triggering excessive setup or ordering cost. The 550-unit result here implies roughly weekly replenishment (48 cycles a year) — a reasonable cadence for steady demand parts; very slow-moving parts justify fewer, larger cycles.
- What does the lot-size adjustment factor do? It scales the raw per-cycle quantity to account for minimum order quantities, pack multiples, yield loss, or a safety buffer. The 1.1x factor here lifts the 500-unit base to 550, adding a 10% cushion above pure demand division.
- How is this different from the classic EOQ square-root formula? The textbook EOQ uses the square root of (2 x demand x order cost / holding cost). This planner-oriented version starts from a target number of order cycles instead, which is how most ERP systems actually parameterize lot sizing — then you cross-check it against cost economics.
- Why use planned order cycles instead of just a fixed lot size? Driving lot size from cycle count keeps replenishment cadence consistent as demand changes. If annual demand rises to 36,000 at the same 48 cycles, the base lot scales to 750 automatically, rather than your fixed lot causing stockouts.
Last reviewed 2026-05-12.