Key Takeaways
- Retail inventory planning starts before the first PO, not after sell-through data arrives.
- The first forecast needs pipeline fill, safety stock, reorder trigger, and production lead time.
- Most brands stock out in months four through six because the reorder clock starts too late.
- DTC demand smooths across days; retail demand lands in blocks by door, PO, and replenishment cycle.
- The model should be simple enough to run weekly and specific enough to trigger action.
Why DTC Inventory Planning Breaks in Retail
DTC inventory planning usually grows from daily order history. A founder watches sales velocity, seasonality, and reorder lead time. The model may be simple, but the demand signal is direct.
Retail changes the shape of demand. Instead of 100 orders per day, the brand gets a PO for thousands of units. Instead of replenishment happening when customers buy, replenishment depends on retailer systems, buyer cadence, store-level sell-through, and vendor compliance.
Retail compresses demand into blocks. That is why DTC brands can ship the first PO and still stock out later. The first shipment was planned. The replenishment cycle was not.
The 90-Day Retail Inventory Model
The first retail forecast needs four numbers.
1. Pipeline Fill
Pipeline fill is the inventory required to stock the initial retail system.
Formula: Initial pipeline fill = door count × units per door × launch allocation factor
Example: 300 doors × 12 units per door × 1.2 launch allocation factor = 4,320 units.
The launch allocation factor accounts for display fill, damaged units, DC holdback, and initial variance. For most first retail launches, 1.1–1.3 is a practical planning range.
Do not plan to the exact PO quantity if the retailer expects replenishment quickly. Plan to the system.
2. Safety Stock
Safety stock protects against demand variance and supplier lead time variance.
Simple formula: Safety stock = average weekly retail demand × buffer weeks
If the first 90-day plan expects 1,000 units per week and the brand needs four weeks of buffer: 1,000 × 4 = 4,000 units of safety stock.
The buffer should match the risk:
- 2 weeks for stable supply and domestic replenishment
- 4–6 weeks for international production
- 6–8 weeks for seasonal or promotional launches
Safety stock is not excess inventory. It is insurance against a broken replenishment clock.
3. Reorder Trigger
The reorder trigger tells the team when to place the next production order.
Formula: Reorder trigger = lead time demand + safety stock
If demand is 1,000 units per week, production lead time is 12 weeks, and safety stock is 4,000 units: 12,000 + 4,000 = 16,000 units. That means the reorder must be placed when projected inventory drops to 16,000 units.
Not when the warehouse feels low. Not when the buyer asks. When the math says the clock has started.
4. Production Lead Time
Lead time is not just production. It includes:
- PO creation
- Supplier confirmation
- Materials procurement
- Production
- QC
- Freight
- Customs
- Receiving
- Available-to-ship conversion
If the supplier says production is eight weeks and freight is four weeks, the planning model should not use eight weeks. It should use the full replenishment cycle. For imported packaging or product, 12–16 weeks is a more realistic planning window. For domestic replenishment, 4–8 weeks may be possible.
The Three Formulas Every First Retail Forecast Needs
The model can be simple. It cannot be vague.
Formula 1: Initial Buy Coverage
Initial buy coverage = initial PO quantity / expected weekly sell-through
If the first PO is 12,000 units and the expected weekly sell-through is 1,000 units, the initial buy covers 12 weeks. That sounds safe until the replenishment lead time is 14 weeks. The model is already short before the product ships.
Formula 2: Replenishment Gap
Replenishment gap = replenishment lead time – initial buy coverage
If replenishment lead time is 14 weeks and initial buy coverage is 12 weeks, the gap is two weeks. That means the brand needs either more initial inventory, faster replenishment, or a second order placed before sell-through is proven.
This is the uncomfortable part of retail planning. You often need to make the second inventory decision before the first 30 days of sales tell the full story.
Formula 3: Cash Commitment
Inventory cash commitment = units ordered × landed cost per unit
A retail launch is not just an inventory decision. It is a cash decision. If the brand orders 20,000 units at $6 landed cost, the cash commitment is $120,000 before payment terms, deductions, or replenishment risk. That number needs to be visible before the buyer meeting turns into a PO.
Why Stockouts Hit in Months Four Through Six
The first month is often fine because the launch PO was planned. The brand had time. The buyer waited. The initial order had attention.
The stockout appears later because replenishment was not triggered early enough.
Common failure pattern:
- Initial PO ships.
- Sell-through looks strong.
- The team waits for more data.
- Reorder is placed after confidence arrives.
- Production lead time is 12 weeks.
- Inventory runs out in week 14.
The brand did not misread demand. It misunderstood the clock.
Retail replenishment planning has to begin before demand is fully proven. That feels uncomfortable. It is also unavoidable when lead times are longer than the sell-through learning cycle.
What to Do When Retail Demand Beats the Plan
Strong sell-through is not always good news operationally. If demand beats the plan and the brand has no second order queued, the result is a stockout. The buyer sees lost sales. The retailer may reduce confidence in the brand's ability to support the account. The founder sees growth and stress at the same time.
The response should be sequenced:
- Check available-to-ship inventory. Not inventory on order. Not inventory in production. What can ship now?
- Check packaging availability. Product without packaging is not sellable inventory.
- Confirm supplier capacity. Can the next run be pulled forward without creating quality risk?
- Model expedited freight. Air freight may protect shelf availability, but it should be tied to specific revenue at risk.
- Communicate internally before communicating externally. Sales, ops, finance, and the retailer account owner need one version of the plan.
Do not celebrate sell-through until replenishment is secured. Retail rewards availability.
The Weekly Review Cadence
A 90-day inventory plan should be reviewed weekly. The weekly review should answer five questions:
- What is current sell-through by SKU?
- What inventory is available at the 3PL?
- What inventory is in retailer DCs or stores?
- What production is already committed?
- What reorder decision needs to be made this week?
The review should not become a 20-tab spreadsheet exercise. It should produce a decision. Order, hold, expedite, reallocate, or reduce. That is the work.
The meeting should have one owner. Sales can bring sell-through. Finance can bring cash constraints. Operations can bring inventory and lead time. But one person needs to decide whether the plan changed.
Otherwise the meeting becomes reporting theater. Retail inventory planning is not reporting. It is decision-making.
Retail Inventory Planning by Revenue Stage
$1M–$3M: Build the First Model
At this stage, a spreadsheet can work. The model needs clean demand, lead time, safety stock, and reorder logic. It does not need enterprise software. What matters: one source of truth.
$3M–$8M: Add Weekly Discipline
At this stage, the brand needs a weekly review rhythm. SKU count is increasing. Retail interest is growing. Inventory decisions start affecting cash. What matters: reorder triggers and lead time discipline.
$8M–$15M: Add System Support
At this stage, the spreadsheet starts breaking. The brand likely needs forecasting support, 3PL reporting, and stronger inventory visibility. What matters: integrated demand, inventory, and supplier data.
$15M+: Build the Operating System
At this stage, inventory planning is no longer a founder task. It needs ownership, reporting, and weekly accountability. What matters: process before software, then software to support the process.
The Cash Side of Retail Inventory Planning
Inventory planning is also cash planning. DTC brands get paid close to the customer transaction. Retail brands wait. Payment terms can run 30, 60, or 90 days depending on the account and structure. That means the brand may need to fund the first production run, the pipeline fill, the safety stock, and the second order before the first retail cash comes back.
This is why the 90-day forecast needs finance in the room. The question is not only “how many units do we need?” It is “how much cash is tied up before replenishment proves itself?”
If the answer is uncomfortable, solve it before the PO arrives. Negotiate payment terms, stage production, reduce SKU count, or adjust launch allocation. Do not discover the cash gap after the warehouse is empty.
What Not to Forecast
Do not forecast every scenario equally. Build three cases:
- Base case: what you actually expect
- Upside case: what happens if sell-through beats plan
- Constraint case: what happens if replenishment arrives late
The constraint case matters most. It tells you where the brand breaks first: cash, production capacity, packaging availability, or warehouse throughput. That is the point of the forecast. Not prediction. Preparation.
FAQ
What is retail inventory planning for a CPG brand?
Retail inventory planning is the process of forecasting initial pipeline fill, safety stock, reorder triggers, and production lead time before the first retail PO ships.
Why does DTC inventory planning not work for retail?
DTC demand is daily and direct. Retail demand arrives in larger blocks, with longer replenishment cycles, retailer systems, and less room to recover from a late reorder.
How much safety stock should a CPG brand carry for a first retail launch?
Most brands should plan 2–6 weeks of safety stock depending on production geography, supplier reliability, launch seasonality, and retailer expectations.
When should a brand place the second production order?
The second order should be placed when projected inventory reaches lead time demand plus safety stock. Waiting for perfect sell-through data often means ordering too late.
Why do brands stock out after a successful first PO?
They often plan the launch order but not the replenishment cycle. The stockout usually appears in months four through six when the reorder was triggered too late.