Mastering Reorder Quantities: The Key to Balanced Retail Inventory

Walk into any apparel store and you will notice something that looks effortless: the popular shirt size is always on the rack, the fast-selling colour rarely runs out, and yet the shelves are not overflowing with stock that never moves. This balance is not luck. It is the result of reorder quantity planning, a system that tells a retailer exactly how much to order, at the SKU level, so that stock stays available without tying up money in dead inventory. In this post we will break down how reorder quantities work, the formula for maximum quantity, and how to calculate order quantities step by step using simple worked examples.

What are reorder quantities in retail? 🔗

Reorder quantity is the part of unit planning where retailers take actual inventory counts at the SKU level and decide how much fresh stock to order. SKU stands for Stock Keeping Unit, the most granular level of a product, for example a specific shirt in a specific size and colour. Planning at this level matters because it ensures the right breakup of quantities across sizes and styles, rather than just ordering a lump sum of “shirts” and hoping the mix works out.

The process is built on periodic stock counts. At fixed intervals, a store physically counts how much of each SKU it has. After each count, an order is placed to bring inventory back up to a predetermined maximum level. This is known as a periodic review or “order-up-to” system, one of the most widely used inventory replenishment methods in retail. The goal is steady availability: enough stock to cover sales until the next delivery arrives, but not so much that capital and shelf space are wasted.

Why size and style breakup matters 🔗

Imagine ordering 100 shirts of a popular style without thinking about sizes. If the middle sizes like M and L sell fastest but you order equal quantities across XS to XXL, you will run out of M and L quickly while the extreme sizes pile up. Forecasting at the style level and then splitting by a historical size ratio tends to under-order the popular middle sizes every time. SKU-level reorder planning prevents this by treating each size and colour as its own unit to be counted and replenished.

Key terms in a reorder system 🔗

Before working through the maths, it helps to define the building blocks. Each of these terms feeds into the formulas that follow.

Order Quantity (OQ): The number of units you actually place an order for after a stock count. It is calculated as Maximum minus On Hand minus On Order.

Reorder Period (RP): The number of weeks between two stock counts. If you count every two weeks, the reorder period is 2 weeks.

Delivery Period (DP): The number of weeks from when you place an order to when the goods are received and ready on the sales floor. This is essentially the supplier’s lead time.

Rate of Sale (RS): The average number of units sold per week. This is your sales velocity for that SKU.

Reserve (R): A buffer of stock kept aside to cover sudden sales spikes or delivery delays. This is the same idea as safety stock, an extra buffer kept on hand to cover unexpected demand increases or supplier delays.

On Hand (OH): The units physically available at the time of the stock count.

On Order (OO): Units that have already been ordered but not yet received.

Maximum Quantity (M): The order-up-to level, that is the target inventory you want to reach. It represents the combination of stock on hand plus stock on order needed to comfortably cover the period ahead.

The formula for maximum quantity 🔗

The maximum quantity is not a guess. It is calculated so that stock lasts through the entire waiting time between counts and deliveries, with a buffer on top. The formula is:

Maximum = Rate of Sale × (Reorder Period + Delivery Period) + Reserve

The logic is straightforward. The sum of the reorder period and the delivery period is the total time during which you cannot influence stock arriving on the floor. You count, you order, and then you wait for delivery, all while sales continue. Multiplying the rate of sale by this combined period tells you how many units will sell during that window. Adding the reserve protects you against demand that runs higher than average or a delivery that arrives late. This mirrors the standard lead time demand plus safety buffer approach used across inventory planning.

Here is a worked example. Suppose a SKU sells at a rate of 8 units per week (RS = 8). You count stock every 3 weeks (RP = 3) and your supplier takes 1 week to deliver (DP = 1). You want to keep a reserve of 16 units (R = 16).

Maximum = 8 × (3 + 1) + 16 = 8 × 4 + 16 = 32 + 16 = 48 pieces

So your order-up-to level for this SKU is 48 pieces. After every stock count, you will order enough to bring on hand plus on order back to 48.

Calculating order quantity from maximum 🔗

Once you know the maximum, the order quantity is simple to find at each stock count:

Order Quantity (OQ) = Maximum − On Hand − On Order

Continuing the example above, suppose your maximum is 48, you count 24 units on hand, and nothing is currently on order.

OQ = 48 − 24 − 0 = 24 pieces

You would place an order for 24 pieces. This logic of ordering up to a target level matches the standard “stock-in” calculation, where the quantity to order equals the target level minus current inventory and goods already in transit.

How the numbers adjust over time 🔗

The real strength of this system is that it self-corrects. Suppose that on the last cycle you ordered 24 pieces but only 20 were actually received, and meanwhile sales were higher than expected at 25 units. Your new on-hand position would be:

New On Hand = 24 (previous) + 20 (received) − 25 (sold) = 19 pieces

At the next count, the order quantity recalculates automatically:

New OQ = 48 − 19 − 0 = 29 pieces

Notice how the system reacts. Because sales ran hot and delivery fell short, the next order is larger to pull stock back up to the maximum. This dynamic adjustment keeps stock balanced without anyone needing to manually rethink the plan each time. Subtracting both on hand and on order also prevents over-ordering, because it accounts for stock that is already on its way.

Adjusting maximum quantity when delivery period exceeds reorder period 🔗

The standard formula assumes you wait through both the reorder period and the delivery period. But there is an important exception. What happens when you count stock very frequently, but deliveries take much longer?

Consider a case where you do weekly stock counts (RP = 1 week) but the supplier takes 3 weeks to deliver (DP = 3 weeks). Here, because you are counting and ordering every single week, the binding constraint is no longer the gap between counts. It is the delivery time. The lead time that actually matters is the delivery period alone. The formula adjusts to:

Maximum = Rate of Sale × Delivery Time + Reserve

For example, if RS = 5 units per week, delivery = 3 weeks, and reserve = 2 units:

Maximum = 5 × 3 + 2 = 15 + 2 = 17 pieces

Using the full formula here would inflate the maximum and lead to overstocking, because frequent counts already give you many chances to top up. Grouping SKUs by their actual lead time and recalculating buffers accordingly is a recognised best practice, since longer replenishment windows expose inventory to more demand uncertainty.

Calculating reorder period and rate of sale from raw data 🔗

In practice, you will rarely be handed neat values for reorder period and rate of sale. You usually have to derive them from store records. Here is how.

Finding the reorder period 🔗

The reorder period in weeks is simply the number of days between two stock counts divided by 7:

Reorder Period (weeks) = Days between stock counts ÷ 7

If your last two counts were 28 days apart, then RP = 28 ÷ 7 = 4 weeks.

Finding the rate of sale 🔗

Rate of sale measures how many units actually sold per week over that period. You work it out from opening stock, purchases received, and closing stock:

Rate of Sale = (Opening stock + Purchases − Closing stock) ÷ Reorder Period

The bracketed part tells you how many units left the store, that is what was sold. Dividing by the reorder period converts it into a weekly figure.

Putting it all together 🔗

Let us run a complete example for a shirt SKU. The opening stock was 95, the store received 45 during the period, the closing stock was 80, and the gap between counts was 28 days. The reserve is set at 24 units, and the delivery period is 2 weeks.

First, the reorder period: RP = 28 ÷ 7 = 4 weeks

Next, the rate of sale: RS = (95 + 45 − 80) ÷ 4 = 60 ÷ 4 = 15 shirts per week

Now the maximum quantity using the full formula: Maximum = 15 × (4 + 2) + 24 = 15 × 6 + 24 = 90 + 24 = 114 shirts

Finally the order quantity, with on hand at 80 (the closing stock) and nothing on order: OQ = 114 − 80 − 0 = 34 shirts

So at this count, the buyer would place an order for 34 shirts. Every figure traces back to real store data, which is what makes this method reliable rather than arbitrary.

Why this system works for retailers 🔗

This approach prevents the two classic retail problems at once. It stops over-ordering because the order quantity subtracts stock already on hand and on order, so you never double up on what is coming. It also protects against stockouts because the maximum is built to cover the entire lead time plus a reserve, keeping the right sizes and styles available. The result is steady product availability, lower carrying costs, and fewer lost sales, the same outcomes that well-designed replenishment strategies aim to deliver.

The wider lesson is that reorder quantity planning turns restocking from guesswork into arithmetic. Once the maximum is set correctly for each SKU, every stock count produces an order quantity almost automatically, and the system gently corrects itself when sales or deliveries deviate from plan.

What do you think? If a SKU suddenly started selling twice as fast as before, which inputs in the maximum quantity formula would you adjust first, and why? And for a fashion item with a short selling season, would you keep a larger reserve or count stock more frequently to stay balanced?

References

1. https://www.getnimbl.com/blog/inventory-replenishment
2. https://www.uphance.com/blog/replenishment-planning/
3. https://www.mrpeasy.com/blog/reorder-quantity/
4. https://www.ism.ws/logistics/reorder-point-formula-and-examples/
5. https://www.farseer.com/blog/inventory-replenishment/
6. https://www.invent.ai/blog/safety-stock-management-for-retail-moving-beyond-static-formulas
7. https://safetyculture.com/topics/retail-inventory-management/replenishment-planning