How to Forecast Stock Demand When Scaling to National Retailers
The Complete Guide to Accurate Demand Forecasting for FMCG Brands Entering Grocery, Pharmacy & Mass Retail
Entering national retail is a huge growth opportunity—but also a high-stakes game. Whether you’re pitching to Foodstuffs, Progressive, Chemist Warehouse, or any major chain, your ability to forecast stock demand accurately can make or break your success. Get it wrong, and you’ll face:
Get it right, and you’ll:
In this guide, we’ll break down how to forecast stock demand when scaling into national retailers across New Zealand or Australia—step by step, using proven strategies, real metrics, and best practice frameworks tailored for FMCG.
Why Stock Forecasting Matters in Retail Expansion
Retail buyers expect your brand to come prepared. They’re managing limited shelf space and performance targets. If your brand can’t meet demand—or overproduces and clogs their supply chain—it reflects poorly on both sides. Buyers are looking for:
- Confidence in supply continuity
- Awareness of category benchmarks
- Ability to support demand across a store network
- Alignment between marketing plans and production volumes
Accurate demand forecasting ensures you launch smoothly and stay on shelf.
Step 1:Analyse Your Historical Sales Data
Your past performance is your most reliable starting point. Even if you haven’t launched in major retail yet, look at:
- Rate of Sale per SKU (units per store per week)
- Channel performance (DTC, independents, pharmacy)
- Seasonality and demand spikes (e.g. summer drinks, winter supplements)
- Promotional uplift (what % increase did you see during past offers?)
If you don’t have this data? Start building it now. Even 3 months of velocity data from local stores or your online store can dramatically improve forecast accuracy.
Step 2: Understand the Retailer’s Store Network
Forecasting for Foodstuffs North Island will look very different to Chemist Warehouse or New World South Island. You need to factor in:
- Number of stores ranged (e.g. 80 Countdown stores vs 250 New Worlds)
- Distribution model (DC-delivered vs direct-to-store)
- Launch phase (Full national rollout vs trial in 50 doors)
- Planograms and facings (how much shelf space do you get?)
- Reorder frequency (some order weekly, others monthly)
Lorem ipsum dolor sit amet, at mei dolore tritani repudiandae. In his nemore temporibus consequuntur, vim ad prima vivendum consetetur. Viderer feugiat at pro, mea aperiam
Step 3: Use Bottom-Up Forecasting (Not Guesswork)
This is the most reliable model for FMCG retail demand planning:
(Expected Units Sold Per Store Per Week) x (Number of Stores) x (Number of Weeks)
Let’s say:
- You estimate 4 units per store per week (based on category data or past sales)
- You’re launching in 100 stores
- You want to forecast for the first 8 weeks
4 x 100 x 8 = 3,200 units
Now add:
- 10–25% promotional buffer (for launch activity or unexpected velocity)
- Pipeline fill (retailers may want 2–3 weeks’ worth of buffer stock on hand)
- Lead time and manufacturing lag (you may need to produce stock 6–10 weeks ahead of launch)
💡 Pro Tip: Create both a conservative and aggressive forecast so you can adjust ordering and production quickly as real data comes in.
Step 4: Align With Retail Buyers & Distributors
Your forecast shouldn’t exist in isolation. Bring it to your buyer review and ask:
- “What’s the average rate of sale in this category for new products?”
- “What’s a typical weeks of cover target for this type of SKU?”
- “How long after launch do you expect a reorder?”
You’ll also want to involve your distributor or field sales team. They’ll have hands-on insights about:
- Sell-through rates in similar stores
- Upcoming promotional windows
- Store-level demand fluctuations
Buyers want to see that you’re prepared, proactive, and building with scale in mind.
Step 5: Account for Lead Times & Logistics
When scaling, production timelines get longer. Here’s what you need to plan for:
- Raw material ordering and delivery
- Manufacturing availability or co-packer booking
- Packaging lead times (especially for printed components)
- Freight and DC intake windows
- Retail shelf-ready packaging (SRP) compliance
Most brands underestimate how long it takes to go from PO to shelf. Build in a minimum 20–30% safety buffer on stock to avoid emergency air-freight or penalties from retailers.
Step 6: Review, Track, and Adjust in Real Time
The first 12 weeks in-store are crucial. This is where sell-through either proves your forecast—or demands a reset. Track:
- Weekly sales data from retailers or IRI/Nielsen
- Inventory levels at DC and store
- Store feedback from reps (e.g. “selling fast”, “slow mover”, “out of stock”)
- Reorder timing and frequency
Be ready to:
- Upweight production quickly if stores are selling faster than forecast
- Pause or redirect stock if uptake is slower than expected
- Adjust promos and field activity to support underperforming doors
Forecasting isn’t a one-time exercise. It’s a continuous cycle of planning, adjusting, and optimising.
Common Forecasting Mistakes to Avoid
Using only “gut feel” or guesswork
Without data-backed insights, you’re flying blind and risking major overstock or stockouts.
Ignoring regional rollout variations
Demand differs by location—what works in Auckland may flop in Dunedin if you don’t localise your forecast.
Overlooking the difference between sell-in and sell-through
Just because stock is shipped doesn’t mean it’s selling—retailers care about what moves off shelf.
Failing to build in promotion impact or out-of-stock scenarios
Promotions spike sales and stockouts stall them—both must be factored into your model.
Underestimating supply chain delays and minimum MOQs
If you don’t allow for lead times and production thresholds, you’ll miss launch windows or tie up capital.
Forecasting stock demand isn’t about being perfect—it’s about being prepared. National retailers reward suppliers who come to the table with clear numbers, accurate assumptions, and the ability to deliver what they promise.
By combining:
- Historical sales data
- Bottom-up modelling
- Retailer and distributor input
- Real-time tracking
- You’ll set your brand up for a strong, scalable launch—without the chaos of stockouts or overstock.
Need Help Building Your Retail Forecasting Strategy?
We help ambitious FMCG brands scale into national retail with clarity, confidence, and cash flow intact.
Get in touch with us
We’d love to chat about how we can help your brand
Ready to take your brand to the next level?
Partner with us to grow faster, reach more shelves, and boost performance — backed by expert strategy and deep FMCG know-how.