Sales Forecasting

Sales forecasting is the process of predicting a business's future sales (1), in units or revenue, over a future period to guide planning (1).

A four-period moving average needs to be centred because four is an even number, so the average of four consecutive quarters falls between two quarters rather than on a single one. To make the trend value line up with an actual quarter, the firm averages two consecutive four-period totals (dividing by 8). This centring means each trend value can be compared directly with the real sales of that quarter — which is necessary to calculate the seasonal variation.

Sales forecasting is important to a manufacturer because almost every plan depends on how much it expects to sell. The forecast lets it plan production and inventory — producing and ordering the right amount of raw materials so it neither holds expensive excess stock nor runs out and loses sales.

It also feeds into cash flow forecasts and budgets, so the firm can see in advance whether it will need finance, and into workforce planning, so it recruits and trains the right number of staff in good time. Without a forecast, the manufacturer would be planning blind, risking over- or under-production. So forecasting allows it to plan operations, finance and staffing proactively — although its usefulness depends on how accurate the forecast turns out to be.

Quantitative methods such as time series analysis rely on past sales data to identify and extrapolate a trend. For a brand-new product, no such data exists, so these methods simply cannot be used — there is nothing to average or extrapolate. The firm must therefore turn to qualitative forecasting, which is based on informed judgement.

One option is market research / consumer surveys, asking potential customers about their likely buying intentions. This is valuable because it draws directly on the target market, giving the firm some evidence of demand before launch and helping it avoid over- or under-producing.

Another option is expert opinion or the Delphi method, where a panel of experienced managers or analysts gives forecasts, with the Delphi version refining them anonymously over several rounds until a consensus emerges. This captures industry knowledge and expected trends that raw numbers could not, and the anonymity reduces the bias of dominant individuals.

The firm could also use sales force opinion — the people closest to customers. However, qualitative methods are subjective and can be over-optimistic or biased, so the firm should treat the forecast cautiously and update it once real sales data starts to appear. In short, with no sales history, qualitative methods are not just useful but necessary — though they are estimates, so the firm should review them as quantitative data becomes available.

Relying on the sales forecast has clear advantages. A forecast gives the retailer a structured, evidence-based estimate of future demand, allowing it to plan the expansion properly — how many new stores, how much stock, how many staff and how much finance it will need. Using time series analysis, the forecast smooths out seasonal swings to reveal the underlying trend, which is far better than guessing. A forecast also lets the retailer prepare a cash flow forecast for the expansion and convince lenders or investors with credible numbers. For a routine, stable retail market, the trend is likely to be a reasonable basis for planning, so relying on it is sensible.

However, relying heavily on a three-year forecast is risky. Forecasts are estimates that assume the past trend continues (extrapolation), and over three years many things can change — a new competitor, a recession, shifting consumer tastes or online disruption could break the trend completely. The further ahead the forecast, the less reliable it becomes, so a three-year horizon is especially uncertain. Forecasts also cannot predict sudden shocks, and if the forecast is over-optimistic the retailer could over-expand, ending up with excess stores, idle capacity and a cash crisis. Basing a major, irreversible expansion 'largely' on one forecast puts a lot of weight on a single uncertain estimate.

Judgement (criterion). How wise it is to rely on the forecast depends on the stability of the retailer's market and the time horizon involved. In a stable market over the short term, the forecast is a sound primary basis for planning. But for a three-year, large-scale expansion, especially if the retail market is volatile or being disrupted, relying heavily on a single forecast is unwise. The retailer should treat the forecast as one important input, combine it with up-to-date market research and qualitative judgement, build in contingency plans for if demand is lower, and review and update the forecast regularly rather than committing fully upfront. On balance, the forecast should inform the expansion, but the retailer should not rely on it so heavily — a phased expansion that can be scaled back if the forecast proves wrong would be far safer.

Sales forecasting gives a business an estimate of its future sales, on which it can base decisions across operations, finance, HR and marketing. It is clearly valuable, but how far a business should rely on it depends on how reliable the forecast is likely to be and on the nature of the decision.

The case for relying on sales forecasting. A forecast turns guesswork into a structured estimate, letting the business plan proactively. It guides production and inventory so the firm neither holds costly excess stock nor runs out; it feeds cash flow forecasts and budgets so the firm can arrange finance in advance; and it underpins workforce planning and marketing decisions. Quantitative methods such as the four-period centred moving average reveal the underlying trend beneath seasonal noise, giving a sound basis for short-term planning, while qualitative methods extend forecasting to new products. A credible forecast also strengthens a business plan when raising finance. For an established firm in a stable market making routine, short-term decisions, a forecast is a reliable and essential planning tool.

The case against over-relying on sales forecasting. Forecasts are estimates, not facts. Time series relies on extrapolation — assuming the past trend continues — which fails after a market shock, a new competitor, a recession or a technology change. The further ahead the forecast, the less reliable it becomes, and it cannot predict sudden, one-off events. Qualitative methods are subjective and can be biased or over-optimistic. A forecast is also only as good as the data and assumptions behind it, so a flawed forecast can misdirect every decision built on it — leading to over- or under-production and wasted resources. Relying solely on a forecast for a major, irreversible decision is therefore dangerous.

Weighing it up (criterion). How far a business should rely on forecasting depends on the stability of its market, the time horizon, and the size and reversibility of the decision. For short-term, routine, easily-reversed decisions in a stable market, a business can rely heavily on the forecast. For long-term, large, irreversible decisions, or in a volatile or disrupted market, it should rely far less and treat the forecast as just one input.

Judgement. A business should rely on sales forecasting to a moderate extent — as an essential planning tool and a key input, but not as the sole basis for major decisions. The deciding criteria are market stability, the time horizon and the reversibility of the decision: with a stable market and short, reversible decisions, the forecast can lead; with long horizons, volatile markets or irreversible commitments, it must be combined with market research, qualitative judgement and contingency planning, and reviewed regularly. The most defensible conclusion is that forecasting tells the firm what is likely to happen if current patterns continue — a vital input — but not what will certainly happen, so it should inform decisions rather than dictate them.