How To Calculate And Set Minimum Reorder Quantities For Retail SKUs

Minimum Reorder Quantity is the smallest quantity that may be ordered when replenishing a product. Setting MRQs requires balancing supplier constraints with demand variability, lead time, storage capacity, and cash flow. Retailers should use a mix of mathematical calculation and commercial negotiation to define MRQs per SKU or supplier lot.

MRQ-setting is not a one-time activity. It should be part of the replenishment policy review and integrated into your WMS or procurement system so that purchase orders and reorder alerts respect both demand-driven targets and supplier minima.

Inputs Needed To Set Practical MRQs

• Average Demand: Weekly or monthly pull rate per location and aggregated across the chain.
• Lead Time: Supplier lead time and its variability — longer or uncertain lead times favor larger lots.
• Carrying Cost: Cost to hold inventory per unit per year (storage, insurance, capital).
• Ordering Cost: Administrative and freight costs per order.
• Supplier Constraints: Pack sizes, minimum spends, and freight minimums.

Step-by-Step Calculation Approach

1) Start with a demand-based lot size such as EOQ or a multiples-of-pack-size figure. Use your forecasting tool to find the optimal replenishment quantity ignoring MRQ.

2) Compare that result to supplier MRQ. If supplier MRQ is lower or equal, you can adopt the calculated lot. If supplier MRQ is higher, quantify the cost of ordering at MRQ versus the calculated lot:

• Compute Additional Holding Cost: (MRQ - ideal lot) × holding cost per unit × average holding period.
• Compute Per-Unit Savings: Any discounts or freight savings when ordering MRQ.

Policy Options When MRQ Is Binding

• Use Mixed-SKU Pallets: Combine different SKUs to meet pallet-level MRQs without inflating each SKU's inventory.
• Time-Based Accumulation: Accumulate demand across a planning horizon (e.g., monthly) so a single larger order serves multiple replenishments.
• Safety-Stock Adjustment: Raise safety stock minimally rather than maintain high base stock from MRQ.
• Vendor-Managed Inventory (VMI): Move accountability to the supplier who can manage their production runs and lower MRQs for you.

Operational Controls And Systems

Enforce MRQs in your procurement and WMS so purchase orders automatically round up to supplier minima. Flag SKUs where MRQ causes overstock and add review workflows. Use inventory analytics to monitor turnover and aging for MRQ-affected SKUs, and set automated alerts for potential obsolescence.

Practical Example And Formulaic Check

Suppose weekly demand is 50 units (2,600/year), ordering cost $40 per order, holding cost $3/unit-year. EOQ = sqrt( (2 × demand × ordering cost) / holding cost ). Calculate EOQ, then compare to supplier MRQ of 500 units. If EOQ is 200, the MRQ forces you to carry an extra 300 units per order. Translate that into annual holding cost and compare with any supplier discount at 500. If discount or freight savings cover the extra holding cost, accept MRQ; otherwise renegotiate or find alternative packaging.

Checklist For Retail Buyers

• Track MRQ Impact: Maintain a register of SKUs where MRQ exceeds EOQ and quantify annual holding cost impact.
• Negotiate On Forecasts: Use customer forecasts to secure smaller runs or phased deliveries.
• Leverage Technology: Configure ERP/WMS to round orders to MRQ and report exceptions.
• Review Quarterly: Reassess MRQs as demand, supplier capability, and freight economics change.

In short, the Minimum Reorder Quantity must be calculated and managed with both numerical analysis and supplier strategy. Treat MRQ as a controllable constraint: measure its cost, negotiate where profitable, and adapt replenishment policies so MRQ supports—rather than undermines—retail performance.