Inventory Reorder Planning for Private-Label Brands: A Practical Guide

In a steady-demand model: reorder point (units) = average demand (units per week) × replenishment lead time (weeks) + safety stock (units). Safety stock covers explicitly assessed uncertainty; it is not a universal percentage of sales.

For ecommerce, observed sales can understate demand during stockouts. Promotions can overstate the repeatable baseline. I separate those effects before choosing a rate. For a seasonal product, use forecast demand across the actual lead-time weeks rather than multiplying an annual average.

The threshold answers when to consider ordering. Batch size, supplier terms, cash and dated delivery feasibility answer how much to order. Inventory position can look healthy while the available stock runs out before a shipment lands.

Continuous review suits operations that can monitor movements reliably and react between planned buying meetings. A fixed reorder quantity may be used, but it still needs an economic and supplier rationale. Alerts based on stale stock create false urgency.

Periodic review suits scheduled buying decisions or consolidated supplier orders. Its protection period is lead time plus review interval: target stock (units) = expected demand over that period + justified buffer (units). Preliminary order = max(0, target − inventory position). This is an order-up-to model, not the continuous-review trigger formula.

Periodic review leaves a gap between checks. An exceptional change in demand, quality or ETA should trigger an earlier review. A fixed meeting schedule is not a reason to ignore a deteriorating supply position.

Start with the supplier's ready-to-ship assumption, then work through each handoff. Payment clearance, material availability and production slots may affect the start. Rework after a failed inspection or unavailable freight capacity can change the arrival date.

Some steps overlap. Build a dated critical path instead of adding overlapping quoted durations twice. Separate planned duration from uncertainty, and keep the supplier-ready date distinct from the warehouse's sellable date.

I review the evidence and constraints. China-based partners execute agreed field checks to my process; logistics and warehouse teams confirm their own milestones. This advisory work does not make me your freight forwarder or fulfilment operator.

Usable on-hand stock excludes damaged, quarantined, unavailable or already consumed units. If your stock export already subtracts allocations, do not subtract the same confirmed orders again. Confirm how your platform treats reserved units and backorders.

Inbound is confirmed supply, not a draft purchase order or an optimistic supplier promise. Record quantity, destination, quality status and expected sellable date. Distinguish stock on order from stock available today.

Expected returns are not usable stock until inspection and receiving make them sellable. Keep return uncertainty separate from demand assumptions. Either forecast net stock consumption consistently or track resellable returns as dated inflows; do not credit them twice.

These are teaching assumptions, not a customer result or a stock-policy recommendation. The 150-unit buffer is deliberately assumed for arithmetic; a real buffer must be justified by demand and lead-time uncertainty, service priorities and cash. The 100 unfilled orders are additional to future weekly demand and have not already been deducted from the 500 usable units.

At the review date, the target covers the eight-week replenishment wait plus the two-week interval until the next review. This aggregate calculation does not schedule deliveries or guarantee availability. The proposed new order only becomes sellable after replenishment lead time.

Timing changes the decision. If the existing 200 inbound units become sellable at the start of week 3, before that week's demand, the simplified opening usable balance after fulfilling 100 existing orders is 400 units. After demand in weeks 1 and 2, it is 200. After receiving 200 and meeting week-3 demand, it is 300. Without another receipt, it reaches zero at the end of week 6 and cannot cover weeks 7 and 8 before the new order arrives.

If those same 200 units arrive only at the end of week 6, the opening 400 is exhausted at the end of week 4. The delay creates an earlier shortage even though the total inventory position remains 600. Inbound outside the protection window is excluded from this simplified coverage position; inbound inside it still needs a dated feasibility check.

Ordering 550 now cannot repair demand missed before that order arrives. Review an earlier release, split delivery, feasible transport change, promotion timing or allocation priority, with the relevant owners. Recalculate costs and cash before selecting an option.

An MOQ is a supplier constraint, not evidence of customer demand. Check whether it applies by SKU, colour, material or total order. Ask whether a production commitment can be released in batches and document ownership, storage and payment terms before relying on that arrangement.

Map deposits, balance payments, freight, duty, import-tax cash and receiving costs by payment date. Compare those outflows with available cash and a conservative sell-through plan. Margin and cash timing are different tests; a profitable SKU can still be unaffordable at the proposed depth.

For seasonal or promotion-led products, replace the steady weekly rate with demand for each week of the protection period. Stock that arrives after the selling window has a different economic role. Recheck the buffer as conditions change rather than carrying it forward unchanged.

For the same illustrative periodic policy, demand of 120 units per week gives a target of 1,350 and a preliminary order of 750 against position 600. Demand of 80 gives target 950 and order 350. Lead time of ten weeks at the original 100-unit rate gives target 1,350 and order 750. These hold the assumed buffer constant solely to isolate each change.

Combined demand of 120 and lead time of ten weeks gives target 1,590 and preliminary order 990. These figures still require inbound timing, MOQ and cash review. In reality the buffer itself may need revision when uncertainty changes.

For each scenario, record the first shortage date, excess after the selling window and peak cash requirement. Demand lost during a stockout, resellable returns and marketplace receiving uncertainty deserve explicit notes. A single average hides those differences.

I challenge the next commitment when recent sales rely on a one-off campaign, the inbound date misses the season, existing stock is slow, contribution margin has weakened or the supplier constraint forces more inventory than the category can support.

A practical recommendation can be protect, cut or re-time. Record which SKUs deserve available cash, which quantities need reduction and which release dates should move. The recommendation must explain trade-offs, not promise that every stockout can be avoided.

Keep your evidence and decision log together: demand source, stock snapshot, dated receipts, scenario, constraint, owner and review point. That record makes it possible to revisit a decision without rewriting its history.

Useful AI work starts with a defined task and checkable inputs. I prefer a repeatable spreadsheet calculation for the arithmetic, with AI supporting research and reporting around it. Verify every formula and reconcile stock back to the original export.

Historical operating experience informs the questions I ask; this guide and its example are not AI client case studies. My original Outskill Generative AI Mastermind certificate records course completion, not an inventory-performance guarantee.

Confidentiality is part of the scope. NDAs are welcome. Agree what data may be used, minimise identifiers and confirm access before sharing supplier terms or customer information with any tool. A detailed diagnostic, workflow or ongoing advisory engagement is scoped separately from an introductory call.