Unit Stock Planning: Managing Inventory by SKU

Walk into any apparel store and you will notice something the cash register alone can never tell you: a shelf can hold ₹2 lakh worth of shirts and still be useless to the customer standing in front of it who wears size 42 in navy blue. If every navy 42 has sold out, that customer walks away empty-handed even though the inventory value looks perfectly healthy on paper. This is exactly the blind spot that unit stock planning is designed to fix. Instead of tracking inventory in rupees, it tracks inventory in physical pieces, broken down to the finest level of detail. For categories where size, colour and style decide whether a sale happens, counting units rather than value is what keeps the right products on the shelf at the right time.

What is unit stock planning? 🔗

Unit stock planning is a method of merchandise planning that uses physical units as the base for planning, rather than monetary value. Most retail planning systems start with money: how much to invest in a category, what margin to target, how much stock value to hold. That works well for broad financial control. But money hides the granular detail that variant-heavy categories live and die by.

Consider garments. A single style of trouser might come in five sizes and four colours. That is twenty distinct items, each of which a customer can ask for specifically. A value-based plan that says “hold ₹5 lakh of trousers” tells you nothing about whether you have stock of the 34-inch khaki or the 30-inch black. Unit planning answers that question directly because it counts pieces at the level of each variant, not the category as a whole.

The unit that makes this possible is the Stock Keeping Unit (SKU). An SKU is a unique identifier assigned to each distinct product variant, where every combination of attributes such as size, colour and style receives its own code. A red t-shirt in small and the same t-shirt in medium are two separate SKUs. This is the standard practice across fashion and apparel retail, because it lets a retailer track exactly which size and colour combinations are available and which have run dry.

Why value-based planning falls short for variant-heavy categories 🔗

The core problem is that inventory value does not reveal availability. A high stock value can sit entirely in slow-moving sizes while the popular ones are out of stock. Apparel brands manage huge SKU portfolios, with each style varying by size, colour and fit, and this multiplies the number of inventory points a planner must watch. When the fast-selling variants run out before they are replenished, the store loses sales it could easily have made. Unit planning prevents these lost sales by forcing visibility at the variant level, which is why it is considered essential for categories like garments, footwear and accessories.

The periodic replenishment system 🔗

At the heart of unit planning sits the periodic replenishment system. The principle is straightforward: at fixed, regular intervals, the retailer takes an actual physical count of inventory at the SKU level and reorders to bring stock back up to a target. This is different from continuous review, where stock is monitored constantly. In a periodic system, inventory levels are assessed only at specific scheduled times, and the reorder decision is made on the basis of that count.

The physical count is recorded on a dedicated form that lays out the inventory across every product dimension. Rather than a single number for “shirts”, the form breaks the count down by size, colour and style so that the planner can see the precise quantity of each variant on hand. This detailed breakdown is what makes accurate reordering possible. Without it, a reorder would be a guess; with it, the reorder can be calculated for each SKU individually.

This kind of SKU-level replenishment with periodic inspection is the standard approach studied in retail operations, where order quantities are set to return stock to a target level after each review. The discipline of counting on a schedule and reordering against a fixed benchmark is what keeps the system consistent across a season.

Key terms in unit planning 🔗

Before the calculations make sense, a handful of terms need to be clear. These appear repeatedly in unit planning and each represents a specific quantity or time period.

Unit OTB or Order Quantity (OQ): Open-To-Buy expressed in units. This is the quantity the retailer is free to order to refill stock to the target. In unit planning it is the same as the order quantity for the SKU.

Reorder Period (RP): The time gap between two stock counts. If the retailer counts every two weeks, the reorder period is two weeks. It defines how often replenishment decisions are made.

Delivery Period (DP): The lead time between placing an order and receiving the goods. This is sometimes called lead time, and it is the time the retailer must cover with existing stock while waiting for the next delivery.

Rate of Sale (RS): The average number of units of an SKU sold per unit of time, usually per week. It is the demand signal that drives the whole calculation.

Reserve (R): The safety cushion of extra stock held to cover unexpected demand spikes or supplier delays. This is the same idea as safety stock in reorder point theory, expressed in units.

Merchandise On Hand (OH): The current physical inventory of the SKU sitting in the store right now, taken from the count.

Merchandise On Order (OO): Stock that has already been ordered but not yet received. It is on its way but not yet counted as on hand.

Maximum Quantity (M): The target inventory level for the SKU, the ideal amount to have available when everything is running smoothly. It is the anchor that all reorders aim for.

Calculating maximum quantity 🔗

The Maximum Quantity is the benchmark that holds the whole system together. It is calculated with the formula:

M = RS × (RP + DP) + R

The logic behind it is intuitive once the pieces are laid out. The stock you carry has to cover sales during two stretches of time. First, it must last through the reorder period, because you will not place another order until the next count. Second, it must last through the delivery period, because once you do place an order, the goods take time to arrive. Adding RP and DP gives the total time the current stock must survive. Multiplying that combined time by the Rate of Sale tells you how many units will sell during that window. Finally, you add the Reserve so that an unexpected rush or a late delivery does not empty the shelf.

This mirrors the standard approach to a maximum stock level, where the target is set to cover demand across the review and lead-time periods plus a safety margin. The difference in unit planning is that the calculation is done per SKU and expressed in pieces, not value.

Working through an example 🔗

Suppose a store sells a particular style of polo shirt in size medium, navy blue. The Rate of Sale is 10 pieces per week. The store counts stock every 2 weeks, so the Reorder Period is 2. The supplier takes 1 week to deliver, so the Delivery Period is 1. The store decides to keep a Reserve of 8 pieces.

Applying the formula: M = 10 × (2 + 1) + 8 = 10 × 3 + 8 = 30 + 8 = 38 pieces. So for this single SKU, the target maximum quantity is 38 pieces. The same calculation is repeated for every size and colour combination, each with its own rate of sale, because a slow-selling size will have a much lower maximum than a fast-selling one.

Calculating order quantity (Open-To-Buy) 🔗

Once the maximum is set, deciding how much to order is simple. The Order Quantity brings stock back up to the maximum, after accounting for what is already on hand and what is already on its way. The formula is:

OQ = Maximum Quantity (M) − Quantity On Hand (OH) − Quantity On Order (OO)

Continuing the polo shirt example, suppose the count shows 12 pieces on hand and 6 pieces already on order from a previous cycle. The order quantity is: OQ = 38 − 12 − 6 = 20 pieces. The retailer orders 20 pieces of this SKU to refill it to the target of 38.

Subtracting the On Order quantity is the step that protects against over-ordering. If the planner ignored stock already on the way, they would double up and end up with far more than the target. By taking both on-hand and on-order stock into account, the system returns stock to the target level precisely, neither short nor excessive. This is the practical meaning of unit Open-To-Buy: the freedom to buy exactly the gap between where stock is and where it should be.

Why this system works 🔗

The strength of unit planning lies in its use of a constant maximum benchmark for a given season and sub-category. Once the Maximum Quantity is fixed for an SKU, every reorder cycle simply tops the stock back up to that level. The planner does not have to re-decide the target every time; they only count, subtract and order. This makes the process repeatable and reduces the chance of human error during busy trading periods.

It also balances the two opposite risks that haunt retail. On one side is the stock-out, where a popular variant runs dry and the customer leaves; the Reserve and the lead-time cover in the maximum guard against this. On the other side is overstock, where capital sits frozen in unsold pieces; subtracting on-hand and on-order stock keeps orders tight. Reordering on a periodic schedule for each SKU keeps both risks in check at the variant level rather than at the blunt level of the whole category.

Because the maximum is tied to a specific season and sub-category, it stays relevant to current demand. A formal shirt’s maximum during the festive and wedding season will differ from its maximum in the off-season, and the rate of sale that feeds the formula adjusts accordingly. The framework is fixed, but the numbers inside it move with the market.

Putting unit planning into practice 🔗

For variant-heavy retail, the payoff is concrete. Tracking sales at the SKU level lets a retailer see which sizes and colours sell fastest, set a sensible target for each, and reorder against that target without guesswork. This visibility is what prevents the costly mismatch where total stock looks fine but the best-sellers are gone. In a market where a large share of fashion inventory can remain unsold each season while best-sellers run out quickly, the ability to plan at the unit level is the difference between a shelf that serves customers and one that merely looks full.

The method does demand discipline. It requires accurate physical counts on a fixed schedule, a reliable rate-of-sale figure for each SKU, and an honest reserve that reflects real demand variability rather than wishful thinking. When those inputs are sound, the formulas do the rest, and the store maintains the right depth of every size and colour through the season.

What do you think? If you were planning stock for a clothing store, would you set the same Reserve for a fast-moving size as for a slow-moving one, or would you let the rate of sale change your safety cushion for each SKU? And how often would you count stock before the cost of counting started to outweigh the benefit of tighter control?

References

1. https://www.shopify.com/in/blog/what-is-a-stock-keeping-unit
2. https://www.eshipz.com/sku-stockouts-indian-apparel
3. https://www.shipbob.com/blog/inventory-replenishment/
4. https://www.sciencedirect.com/science/article/abs/pii/S0957417424005931
5. https://en.wikipedia.org/wiki/Reorder_point
6. https://www.mecalux.com/blog/maximum-stock-level
7. https://www.inventory-planner.com/what-is-inventory-replenishment/
8. https://www.netsuite.com/portal/resource/articles/inventory-management/stock-replenishment.shtml