How To Calculate Reorder Quantity For A Warehouse: EOQ, Demand-Based Steps

Reorder Quantity The quantity purchased or produced when inventory reaches its reorder point. Calculating it requires combining demand data, cost parameters, supplier constraints, and practical warehouse considerations.

Warehouse planners use several calculation methods depending on SKU characteristics and business priorities. The most common quantitative approach is the Economic Order Quantity (EOQ), which minimizes combined ordering and holding costs. Other practical approaches include demand-based lot-for-lot ordering, fixed-order quantities aligned to pallet or case packs, and constrained optimization when suppliers impose minimums or production requires batch runs.

Step-By-Step Calculation Using EOQ

EOQ is a starting point for many warehouses because it gives a cost-optimal lot size when assumptions hold (steady demand, known costs). The EOQ formula is Q* = sqrt((2 × D × S) / H), where D = annual demand, S = ordering cost per order, H = annual holding cost per unit. After calculating Q*, round to practical pack or pallet sizes and check supplier MOQs and transport economics.

When To Use Demand-Based Lot-For-Lot

Lot-for-lot orders match production or purchasing to true demand during a replenishment period. This minimizes holding costs and is appropriate for perishable items or high-value goods. Implement lot-for-lot when frequent ordering is affordable and suppliers can support frequent, small deliveries.

Accounting For Constraints And Real-World Factors

• Supplier Constraints: MOQs, case packs, and lead-time variability often require rounding EOQ to supplier-friendly quantities.
• Transport Economics: LTL vs FTL pricing can make larger orders cheaper per unit; include freight when calculating ordering cost.
• Warehouse Limits: Rack space, cube utilization, and FIFO requirements (especially for perishables) influence feasible reorder quantities.
• Production Batches: For manufacturing, align reorder quantity to run sizes that minimize setup and holding costs.

Practical Calculation Example

Warehouse B sells 24,000 units of a SKU annually (D = 24,000). Ordering cost (S) is $60 per order and annual holding cost per unit (H) is $3. EOQ = sqrt((2 × 24,000 × 60) / 3) = sqrt((2,880,000) / 3) ≈ sqrt(960,000) ≈ 980 units. If the supplier packs in cartons of 50 and pallet loads of 1,000, the planner might round the EOQ to 1,000 units to match pallet quantity. They then verify lead time, safety stock, and whether the warehouse has the space to store incoming pallets.

Implementation Steps For Warehouses

• Collect Accurate Inputs: Use recent sales history, measured lead times, real ordering costs (including freight and receiving), and true holding costs (space, capital cost, shrinkage).
• Run Multiple Scenarios: Calculate EOQ, then adjust for MOQs, transport tiers, and storage constraints to see total cost impacts.
• Integrate With Systems: Configure ERP/WMS reorder rules to trigger automatic POs at the reorder point with the chosen reorder quantity.
• Monitor KPIs: Track stockouts, service levels, carrying cost, and order frequency to validate the quantity and refine assumptions.

When To Recalculate

Recalculate reorder quantities after significant changes: demand trend shifts, supplier lead-time changes, new freight pricing, or when you introduce new packaging that changes palletization. For seasonal products, maintain separate calculations per season or use dynamic rules tied to forecasted demand.

In short, the Reorder Quantity is the purchase or production amount placed when inventory hits its reorder point; calculate it using EOQ where appropriate, then adapt for supplier, transport, and warehouse constraints so replenishment is both cost-effective and operationally practical.