Inventory, warehouse & supply chain
Demand planning and forecasting for distributors and retailers
Practical demand planning for Philippine distributors and retailers: data you need, forecasting methods, seasonality, promotions and a monthly cycle.
Demand planning estimates what customers will buy, where and when, so purchasing, production and logistics can prepare. Perfect forecasts do not exist. The goal is a forecast that is good enough to plan with, updated regularly, and paired with safety stock for the uncertainty that remains. For Philippine businesses, demand swings with paydays, holidays, the Christmas season, school opening, weather and promotions, so seasonality matters.
Data you need
- Sales history by item, branch or customer, by week or month, ideally two to three years
- Stock-out periods, because sales during stock-outs understate true demand
- Promotions and price changes, to separate promotional spikes from base demand
- Calendar events: holidays, paydays, school calendar, local fiestas
- Commercial input: new customers, lost accounts, product launches and phase-outs
Clean data matters more than sophisticated methods. Remove one-time bulk orders and adjust for stock-outs before forecasting.
Simple forecasting methods that work
| Method | How it works | Good for |
|---|---|---|
| Moving average | Average of the last N periods | Stable items |
| Weighted moving average | Recent periods weigh more | Items with gradual trend |
| Seasonal index | Base demand × seasonal factor for the month | Items with strong seasonality |
| Year-over-year growth | Last year's same period × growth factor | Seasonal items with steady growth |
Seasonal index example: an item averages 1,000 units a month across the year, but December sales are typically 1.8 times the average. December forecast = 1,000 × 1.8 = 1,800 units, adjusted for expected growth.
Adding commercial judgment
Statistics capture the past. Sales and marketing know the future: a new distributor, a lost key account, a planned promotion. A good process starts with a statistical forecast and lets commercial teams adjust with reasons, then measures whether their adjustments improved accuracy.
A monthly planning cycle
- Week 1: update sales history and statistical forecasts.
- Week 2: commercial review; agree adjustments for promotions and accounts.
- Week 3: supply review; check purchasing and production capacity against demand.
- Week 4: management decision on gaps, inventory targets and actions.
This is a simple form of sales and operations planning (S&OP), which aligns sales, supply and finance on one plan.
Measuring forecast accuracy
Forecast error (MAPE) = average of |actual − forecast| ÷ actual, by item or category. Track it monthly. Focus improvement on high-volume items with high error. Also watch bias: forecasts consistently above or below actual, which causes overstock or stock-outs.
From forecast to replenishment
The forecast feeds reorder points and safety stock (reorder point guide), purchase plans and production schedules (production planning). Branch-level forecasts drive branch replenishment (multi-branch inventory).
Common mistakes
- Forecasting from sales that were limited by stock-outs
- Ignoring promotions, then treating spikes as new base demand
- One national forecast applied to every branch
- No accountability for forecast accuracy
- Forecasts updated once a year
Where Cirquolus fits
Cirquolus Supply chain management connects supplier records, purchasing, branch inventory, transfers and logistics. POS and field sales provide sales by product, branch and customer, and inventory management shows stock by location, giving planners the data behind replenishment decisions.
Frequently asked questions
What is demand planning?
The process of forecasting customer demand and aligning purchasing, production and inventory to meet it.
What is the simplest forecasting method?
A moving average of recent periods. Add seasonal factors for items whose demand changes by month.
What is S&OP?
Sales and operations planning: a monthly process that aligns demand forecasts with supply capacity and financial plans.
How accurate should forecasts be?
It depends on the item and level of detail. Track accuracy and bias over time and focus on improving high-impact items.
Bring this workflow to a Cirquolus demo.
Show us your current process, companies and branches. We will map it to the modules you need and propose a realistic rollout.