How to forecast monthly wholesale airtime volume
Start with a few comparable months of sales, then add known events such as a promotion or a new outlet. Show the reserve separately. Forecast each product and sales channel on its own so you can see which denomination might run short even if the overall budget looks right.
Forecast inputs
| Input | Treatment |
|---|---|
| Recent baseline | Average comparable complete periods |
| Planned change | Add separately with reason and owner |
| Seasonal effect | Use a comparable period if records exist |
| Buffer | State amount and trigger for use |
By Freepaid · Published
Clean the history before using it
Collect transaction history for comparable complete periods. Split it by product, outlet and channel if those differences affect replenishment. Exclude or annotate unusual campaigns, outages, one-off allocations, closures and incomplete periods. Keep the original data so another reviewer can reproduce the forecast.
If history is unavailable, label the first forecast an assumption. Estimate using the most relevant operational information you have, state who supplied it and set a date to replace it with actuals. Do not present an estimate as a proven seasonal pattern.
Calculate a baseline and changes separately
Say a shop sold R12,000, R13,000 and R14,000 in airtime over three comparable months. The average is (12,000 + 13,000 + 14,000) ÷ 3 = R13,000. If a confirmed upcoming promotion adds an estimated R2,000, the working forecast is R15,000 before any separately approved buffer.
Keep a range when uncertainty matters: low, expected and high. Show the assumptions behind each scenario, such as planned outlet count or campaign recipients. Do not simply add a percentage buffer without explaining what risk it covers. A buffer for a longer replenishment interval is different from an allowance for a promotion.
Connect the forecast to funding
Use supplier terms confirmed for your account to understand funding lead time, minimums, invoice timing and balance treatment. Tie replenishment to an approved threshold and a named owner. Have finance approve the purchase against the current quote and spend limits.
For multiple locations, avoid pooling away important differences. One branch may have a strong weekend pattern while another serves mostly weekday trade. Plan centrally if that is how the account is funded, but keep enough outlet-level data to identify where assumptions fail.
Review forecast against actuals
At month end, compare forecast and actual by product and outlet. Calculate the absolute difference and ask why it occurred: demand changed, the source data was incomplete, supply was interrupted, or a planned activity did not happen. Update the next forecast using evidence rather than carrying a stale number forward.
Record forecast version, preparer, assumptions, approval and actual result. Revisit the model after catalogue changes, new outlets or major changes in operating hours.
For business purchasing context, see Freepaid bulk airtime. Confirm current products and funding terms directly.