What it means
Nearly every other plan in a business depends on expected sales. Hiring, stock purchasing, marketing spend and loan covenants (promises made to a lender) all start from a view of future revenue.
A forecast that is too high leaves the business overcommitted, while one that is too low can mean missed opportunities and empty shelves. There are several common methods.
Time-series methods extend past patterns such as seasonality, pipeline methods weight each live deal by its chance of closing, and driver-based methods start from things like website traffic or store numbers. Many companies blend two or three approaches and compare the results.
Pipeline weighting is the method that non-finance managers meet most often. Each stage of the sales process is given a probability, such as 20% for a qualified lead and 80% for a deal in negotiation, and the deal value is multiplied by it.
The probabilities should come from actual history, not hope. A good forecast comes with a range and a record of how accurate earlier forecasts were.
Finance teams track the gap between forecast and actual, often called forecast error, and use it to improve the next round. Forecasts that are never compared with results tend to drift into wishful thinking.
The biggest practical risk is bias. Salespeople may inflate to look ambitious or deflate to beat the target, and both habits distort planning.
Clear stage definitions and a regular review meeting keep the numbers honest. Forecasts also feed external conversations.
Lenders, investors and landlords often ask for a sales outlook before agreeing to funding or lease terms, and they will test how realistic it is. A clear explanation of the method and the assumptions behind it builds more trust than a confident number with no support.
In practice
Real-world examples
Example 1
A garden centre looks at three years of monthly sales and notices that spring brings in 40% of annual revenue. It builds next year's stock orders around that pattern, adjusted for a planned new store opening. The buyer also keeps a reserve budget in case spring arrives late.
Example 2
A cybersecurity software company with renewals and new business forecasts them separately. Renewals are predicted from past retention, while new business is weighted by deal stage. The two are added together for the board pack. Each part is reviewed separately because they behave so differently.
Example 3
A restaurant group forecasts takings from the number of tables, the average spend per cover and the expected occupancy. When bookings fall below the plan in week one, it trims staff rotas for the month. Without the forecast, the extra wages would simply have been absorbed as lost margin.
Think of it
Sales forecasting is like checking the weather forecast before planning a major outdoor event. You look at past climate patterns for that time of year, check the current sky for clouds, and decide whether to rent a large marquee or keep it simple.
Formula
Calculation
Weighted pipeline forecast = sum of (deal value x probability of closing)
Suppose a business services firm has three groups of open deals. Proposals total $400,000 with a 60% chance of closing, so 400,000 x 0.60 = $240,000. Negotiation deals total $250,000 at 80%, so 250,000 x 0.80 = $200,000, and early-stage qualified deals total $600,000 at 20%, so 600,000 x 0.20 = $120,000. The weighted forecast is 240,000 + 200,000 + 120,000 = $560,000, even though the unweighted pipeline is $1,250,000.Case study
Seen in the real world
Kestrel Bakeware is an illustrative, fictional manufacturer that supplies ovens to catering firms. The sales team reported a pipeline of $3,000,000 each quarter and the board planned production on it, but actual sales kept landing near $1,200,000.
The finance manager reviewed eight quarters of history and found that only 40% of the pipeline ever closed. She replaced the raw total with stage-weighted values and added a range, with a low case of $1,000,000 and a high case of $1,500,000.
Production planning improved immediately and surplus stock fell, which released cash that had been tied up in unsold ovens. The illustrative lesson is that a forecast built on measured conversion beats one built on optimism, and that a range is more honest than a single figure.
Watch out
Common mistakes
- Reporting the total pipeline as if it were the forecast, ignoring that many deals will never close.
- Using the same closing probabilities year after year without checking them against actual results, even though sales processes and markets change.
- Presenting a single number with no range, which hides how uncertain the estimate really is and leaves decision makers with false precision.
Questions
People also ask
How far ahead should a business forecast sales?
Most firms use a rolling twelve months for planning and a tighter three-month view for operations, refreshed regularly. The nearer months deserve the most detail, because they drive purchasing and staffing.
Who should own the sales forecast?
Sales leaders, who are closest to customers, usually provide the inputs, but finance should challenge and consolidate them so the final number is independent. A second pair of eyes catches both over-optimism and excess caution.
What is the difference between a forecast and a budget?
A forecast is the best estimate of what will happen, while a budget is the target the business has chosen to aim for. The two are often different, and the gap between them is useful information for managers.