Weighted Forecast

Sales Forecasting

6 min read

Also known as: Probability-Weighted Forecast, Stage-Weighted Pipeline Forecast, Expected Value Forecast

A pipeline forecast that multiplies each deal's value by its stage probability to produce a probability-adjusted revenue projection.

Definition

A weighted forecast is a sales projection method that assigns a probability percentage to each open opportunity based on its pipeline stage, then multiplies that probability by the deal's potential value to produce an expected revenue figure. Instead of treating a $100k deal at discovery and a $100k deal at contract sent as equal, weighting acknowledges that later-stage deals are more likely to close.

Sales ops teams use weighted forecasts inside CRM reporting to roll up pipeline into a single number that finance and leadership can plan against. Each stage (e.g., Qualified 20%, Proposal 50%, Negotiation 80%) carries a fixed weight, and the system calculates weighted value automatically as deals move forward. The total across the pipeline becomes the weighted forecast for the quarter.

Weighted forecasting differs from commit forecasting (rep judgment on what will close) and AI/predictive forecasting (machine-learned probability based on deal signals). Weighted is the most common baseline because it's transparent, fast to set up, and easy to audit — but it's only as accurate as the stage probabilities you assign.

Why It Matters

Without a weighted view, your pipeline number is just raw potential — a fantasy that ignores the reality that most deals won't close. Weighting gives finance a defensible quarterly revenue projection, helps RevOps spot coverage gaps early, and lets sales leaders know whether the team has enough late-stage volume to hit quota or needs to push more activity at the top of the funnel.

Teams that skip weighted forecasting tend to either over-promise (reporting full pipeline value as expected revenue) or rely entirely on rep gut-feel commits, which swing wildly month to month. The result is missed quarters, panicked board updates, and hiring or spend decisions made on numbers that never had a real basis.

Examples in Practice

A SaaS sales team has $2M in open pipeline this quarter: $800k in discovery (20%), $700k in proposal (50%), and $500k in negotiation (80%). The weighted forecast is $160k + $350k + $400k = $910k, which the VP of Sales reports to finance as the expected number — a far more defensible figure than the raw $2M.

A 30-person agency uses weighted forecasting to staff delivery. By looking at the weighted value of deals in proposal and negotiation stages, the COO can predict billable hours coming online in 60 days and decide whether to start recruiting contractors now or hold off.

A B2B services firm noticed their weighted forecast consistently overshot actuals by 25%. They audited stage definitions, found reps were advancing deals to Proposal too early, and tightened entry criteria. Within two quarters the weighted forecast was within 5% of closed revenue.

Frequently Asked Questions

What is a weighted forecast and why does it matter?

A weighted forecast multiplies each open deal's value by the probability of closing at its current pipeline stage, producing an expected revenue figure rather than a raw pipeline total. It matters because it gives finance and leadership a defensible number to plan against, surfaces coverage gaps earlier, and prevents the over-promising that comes from reporting full pipeline value as expected revenue.

How is weighted forecast different from commit forecast?

Weighted forecast uses fixed stage probabilities applied uniformly across all deals, making it objective and easy to audit. Commit forecast is rep judgment — what each seller personally believes will close this period regardless of stage. Most teams use both: weighted for the systematic baseline, commit for the rep-level call. Predictive AI forecasting is a third layer that scores individual deals based on behavioral signals.

When should I use weighted forecasting?

Use it once your pipeline has enough volume that stage-level statistics become meaningful — typically 30+ open opportunities per quarter. It's especially valuable when your sales cycle is longer than 30 days, when deals move through clearly defined stages, and when finance needs a defensible quarterly projection. Smaller teams or transactional sales models often get more value from commit-based forecasting.

What metrics measure weighted forecast accuracy?

Forecast accuracy is the primary metric: weighted forecast value divided by actual closed revenue, with anything in the 90-110% range considered healthy. Also track stage conversion rates (do deals at 50% actually close 50% of the time?), forecast variance over time, and category-level accuracy by segment or product line to spot where your stage probabilities need recalibration.

What's the typical cost of weighted forecasting tools?

Weighted forecasting is a standard feature in most modern CRM platforms, so there's usually no separate line item. Mid-market CRM seats range from roughly $50 to $200 per user per month depending on tier. Dedicated forecasting tools layered on top typically run $40 to $100 per user per month. The bigger cost is usually RevOps time to configure stages and audit probabilities quarterly.

What tools handle weighted forecasting?

Any full-featured sales CRM supports weighted forecasting natively — it's a baseline capability in mid-market and enterprise sales platforms. Specialized revenue intelligence and forecasting platforms add layers like AI-driven deal scoring and historical pattern analysis on top of the basic weighted view. Spreadsheets can work for very small teams but break down quickly as pipeline volume grows.

How do I implement weighted forecasting for a small team?

Start by defining 4-6 clear pipeline stages with explicit entry criteria, then assign a probability to each based on your historical close rate from that stage. Apply the weights inside your CRM's forecast view. Review accuracy monthly for the first quarter and adjust probabilities based on what actually closed. Avoid the temptation to set probabilities by gut feel — use your real win-rate data.

What's the biggest mistake teams make with weighted forecasting?

Setting stage probabilities once and never recalibrating them. Sales motions evolve, win rates shift by segment, and stage definitions drift as reps interpret them differently. If your Proposal stage was set at 50% three years ago but actually converts at 30% today, every forecast is structurally inflated. Audit probabilities against actual close data at least once per quarter.

Should weighted forecast replace rep commits?

No — they answer different questions. Weighted forecast tells you what the math says based on stage and probability. Commits tell you what the people closest to the deals believe will happen. The best forecasting cadences compare both numbers weekly, investigate the gap between them, and use that gap as a coaching signal to surface deals reps are sandbagging or over-committing.

Can AI improve weighted forecasting?

Yes. Traditional weighting applies one probability to every deal at a given stage, which ignores real-world variance — a deal with executive sponsorship and a signed mutual action plan is more likely to close than one stuck on the same stage for 60 days. AI agents can score deals individually based on engagement, deal age, contact seniority, and historical patterns, producing a more accurate probability per opportunity.

The AMW Suite