Demand Planning & ERP for China Sourcing: Forecast, Buffer, and Reorder
Sourcing from China rewards scale but punishes poor planning. Long lead times, ocean transit of 25–40 days, and minimum-order quantities mean a forecasting error does not show up as a small blip — it shows up as a six-week stockout or a warehouse full of dead inventory. This guide explains how to build a demand-planning discipline and wire it into an ERP or inventory system so your China orders are timed, not guessed.
Table of Contents
- Why Demand Planning Matters for China Sourcing
- Core Forecasting Methods
- The Role of ERP in Sourcing
- Practical Examples
- Common Mistakes
- Expert Recommendations
- Frequently Asked Questions
- Conclusion
- Collaborative Planning with Suppliers
- Need Help Sourcing Products from China?
Why Demand Planning Matters for China Sourcing
When you source domestically, a replenishment order might arrive in three days. From China, the clock includes factory production (15–30 days), quality inspection, export clearance, ocean transit (25–40 days), and US deconsolidation. A realistic reorder cycle is 60–90 days end to end. That lag means your forecast must be right two months before the sale happens.
Good demand planning converts that lead-time risk into a managed buffer. It tells you not just what to order, but when and how much, factoring in seasonality, MOQs, and supplier reliability.
Core Forecasting Methods
Most importers benefit from a blend of three approaches:
- Time-series / moving average: Use the last 3–6 months of sales to project the next period; simple and stable for steady SKUs.
- Seasonal indexing: Apply a monthly multiplier (e.g., 1.4 for Q4) to capture holiday spikes common in consumer goods.
- New-product proxy: For launches, borrow the curve from a comparable existing SKU and dampen by 30–50% until data accrues.
Calculating Safety Stock
A practical formula: Safety Stock = Z × σlead-time × √(lead time), where Z is your service-level factor (1.65 for 95%). The longer and more variable your China lead time, the larger the buffer you need.
| Method | Best For | Weakness |
|---|---|---|
| Moving average | Stable, mature SKUs | Slow to react to trend shifts |
| Seasonal index | Holiday-driven goods | Needs 12+ months of history |
| Proxy launch | New products | High initial error |
The Role of ERP in Sourcing
An ERP (enterprise resource planning) or even a lightweight inventory system becomes the control tower. It should connect sales channels, warehouse stock, and supplier lead times in one place so reorder points trigger automatically.
- Centralize demand signals: Pull Shopify, Amazon, and wholesale orders into one forecast.
- Track supplier lead time per SKU: Not a flat 60 days — each factory differs.
- Automate reorder points: When projected stock hits buffer threshold, generate a PO draft.
- Flag exceptions: Sudden velocity changes should pause auto-reorder for human review.
Even a spreadsheet with disciplined weekly updates beats an unused enterprise system. The value is the process, not the license cost.
A mature planning system also creates leverage in supplier negotiations. When you can show a factory a documented 12-month forecast, you earn better pricing and priority production slotting than a buyer who orders reactively, because the supplier can smooth its own capacity. Data, not purchase volume alone, is what converts a transactional relationship into a strategic one — and it is the same dataset that powers your reorder automation.
Collaborative Planning with Suppliers
Internal forecasting only gets you so far when your supplier holds half the lead-time risk. Collaborative Planning, Forecasting, and Replenishment (CPFR) extends your demand plan to the factory: you share sell-through data and promotional calendars, and the supplier commits to capacity and a realistic production window. For China sourcing, this is especially valuable because factory load fluctuates with Lunar New Year shutdowns and peak export seasons.
A simple version works even without fancy software: a monthly shared sheet showing your 90-day forecast, confirmed purchase orders, and the supplier’s stated ready-date. The moment the supplier’s stated date drifts, your reorder math updates. The payoff is fewer “the container is late again” surprises and the ability to promise customers reliable delivery. As your China sourcing strategy matures, this shared visibility becomes a competitive moat that pure price-shopping competitors cannot match.
Practical Examples
| Business | Planning Move | Outcome |
|---|---|---|
| Seasonal decor brand | Seasonal index + August China PO for Q4 | Avoided 35% air-freight premium |
| Subscription supplement | Moving average + 1.65 Z safety stock | 99% in-stock, 20% less capital tied |
| Multi-SKU electronics | ERP auto-reorder by per-SKU lead time | Cut manual PO hours by 80% |
For background on how trade and logistics structure affect planning horizons, the World Bank’s trade and logistics research provides useful macro context on lead-time drivers.
Common Mistakes
- One flat lead time for all suppliers. Reality varies 20–40 days between factories.
- Ignoring MOQ in the reorder math. Your ideal order may fall below supplier minimums, forcing overstock.
- Forecasting from revenue, not units. Price changes distort the signal.
- No seasonal adjustment. Flat averages cause Q4 stockouts and Q1 glut.
- Treating the ERP as set-and-forget. Models decay; review monthly.
Expert Recommendations
| Step | Action |
|---|---|
| 1 | Export 12 months of unit sales per SKU and compute base demand. |
| 2 | Assign each supplier a measured, not assumed, lead time. |
| 3 | Set safety stock using the Z-formula at your target service level. |
| 4 | Round orders up to MOQ and container efficiency. |
| 5 | Schedule a monthly forecast review with your sourcing partner. |
A strong planning cadence is the difference between a China sourcing strategy that scales and one that lurches between emergencies.
“The cheapest freight you will ever book is the container you ordered two months ago because your forecast was right.”
Frequently Asked Questions
Do I need a full ERP to plan China sourcing?
No. A disciplined spreadsheet with sales history, per-SKU lead times, and reorder formulas works for many small importers. Upgrade to ERP when SKU count and channel complexity outgrow manual control.
How much safety stock is enough?
Enough to cover demand and lead-time variability at your target service level. A 95% service level typically uses a Z factor of 1.65 in the safety-stock formula.
How do I handle new products with no history?
Use a proxy SKU’s launch curve, dampen it by 30–50%, and keep safety stock higher until real data accrues over two to three reorder cycles.
Should lead time include ocean transit?
Yes. Your reorder point must cover production, inspection, export, ocean transit, and US receiving — often 60–90 days total.
How often should I review the forecast?
Monthly at minimum, and always after a demand shock, a supplier change, or a major seasonality shift.
Can demand planning reduce air freight costs?
Significantly. Accurate forward planning lets you use slow, cheap ocean freight instead of emergency air shipments that can cost 5–10× more.
Conclusion
Demand planning and ERP discipline turn China sourcing from reactive firefighting into a predictable supply engine. Start with unit-level history, measure real lead times, set buffer stock with a sound formula, and review monthly. The payoff is fewer stockouts, lower emergency-freight spend, and capital freed from excess inventory.
Need Help Sourcing Products from China?
Request a free sourcing consultation with Woosourcing. Our team can help you with:
- Product sourcing
- Supplier verification
- Factory audits
- Quality inspections
- Private label manufacturing
- International shipping
Contact us today for a free quotation.
Recent Comments