Inventory planning for Asian retail: cover, cadence and the cash trap

1. Weeks of cover is a decision, not an outcome

Weeks of cover is closing stock divided by average weekly sales. Retailers treat it as a report line, but it is really the output of two choices: how often you can replenish, and how much variability you are willing to absorb with stock instead of with speed.

In markets where inbound lead time is short and predictable, Singapore, Malaysia, urban Thailand, cover of four to six weeks on core lines is normal. In markets where customs clearance or island freight adds unpredictable days, planners hold eight to twelve, and that difference is the single largest line in the working capital gap between two otherwise identical store networks.

2. Segment the range before you plan it

A single planning rule across a whole range guarantees you are wrong in two directions at once. Split the range into never-out-of-stock lines, seasonal lines and test lines, and plan each on its own logic.

• Never-out-of-stock: high service level, automated replenishment, cover set by lead time.
• Seasonal: buy to a plan with a defined markdown exit date before the first unit lands.
• Test: small, deliberately unhedged quantities; the purpose is information, not margin.
• Anything that cannot be placed in one of the three buckets is usually a range problem, not a planning problem.

3. Where the cash actually gets trapped

Three places, in order of size: goods in transit that nobody reviews because they are already paid for; residual seasonal stock held past its exit date in the hope of a better price; and duplicate SKUs held across store and e-commerce pools that cannot serve each other.

The last one is fixable without buying anything. Pooling store and online stock into one available-to-promise number typically releases several weeks of cover on overlapping lines, which is why fulfilment-from-store projects are often justified on inventory rather than on delivery speed.

4. The weekly trading rhythm

The operating routine matters more than the tooling. A workable weekly rhythm: sales and stock review Monday, replenishment and reorder decisions Tuesday, markdown and range actions Wednesday, and a short exception list carried into the next week rather than a full re-plan.

• Review by exception: only SKUs outside the cover band get discussed.
• Every markdown decision gets a date and a target sell-through, not just a percentage.
• One owner per decision. Shared ownership of stock is how residual builds.