One of your sales team’s biggest challenges is forecasting revenue – especially since you likely have a range of prospects at different stages of your funnel at any given time.
Part of the trouble with sales forecasting is that it can be tricky to estimate which leads are most likely to become customers. There may be a large variance in the size of your opportunities and the likelihood of closing each one.
In this article, we’ll cover:
- How a weighted sales pipeline differs from an unweighted pipeline
- How to measure a weighted sales pipeline
- The benefits of a weighted sales pipeline
- The drawbacks of a weighted sales pipeline
A Weighted Sales Pipeline vs. an Unweighted Sales Pipeline
Your sales pipeline can be either weighted or unweighted. An unweighted sales pipeline looks at the full potential value of opportunities at every stage of the sales funnel. Each deal is considered equally likely to close, whether you’ve recently made contact via cold call or they’re ready to sign on the dotted line. This can lead to inflated revenue forecasts if high-value opportunities fall through.
A weighted sales pipeline, on the other hand, acknowledges that not every opportunity results in a sale. This is a more detailed sales forecasting method that assigns a value to each deal based on where it is in the sales funnel.
In a weighted sales pipeline, opportunities with higher likelihoods of closing are given more weight in sales forecasting. This helps account for the fact that not all leads become customers. The idea is that the further along a deal is in your pipeline, the greater the probability it will close.
So, instead of simply stating that you have five active prospects and $100,000 in potential sales, you might say you have five opportunities with a 50% or higher chance of closing a sale.
How Do You Measure a Weighted Sales Pipeline?
Each sales stage is given a percentage that represents probability of closing. For instance, deals at stage three in a six-stage pipeline might have a 50% likelihood of closing. The percentage is then multiplied by the value of the opportunities at that stage and the result is used to forecast sales.
The formula to calculate the value of a weighted pipeline is rather simple:
Probability of closing * Deal value = Weighted value
If we continue with the example above and assume there are five deals at stage three with a combined value of $100,000, then the calculation would look like this:
.50 * $100,000 = $50,000
In this case, $50,000 would be included in the sales forecast based on probability. You would repeat this process for each stage of your pipeline and add up the totals to get your weighted sales forecast. Ideally, any overestimations and underestimations would even each other out.
The most difficult part is estimating the probability of closing at every step in your CRM. These estimates differ between businesses depending on factors like the number of stages in the sales funnel, company size, and how long it takes to close a typical deal.
Here’s a hypothetical weighted sales pipeline example to help you visualize your own:
- Step 1: Prospecting – 10%
- Step 2: Qualification – 25%
- Step 3: Proposal – 50%
- Step 4: Demo – 65%
- Step 5: Negotiation – 80%
- Step 6: Close the Deal – 100%
- Lost or Dead Lead – 0%
The Benefits of a Weighted Sales Pipeline
A weighted pipeline is designed to give you a high-level impression of your sales opportunities. It hinges on consideration of how far along the pipeline each prospect is and how likely they are to make a purchase. This helps with sales forecasting and is particularly effective for businesses with numerous opportunities in the works and clearly defined sales pipeline steps.
Since a weighted sales pipeline is based on probability, the values become more reliable with more data. So the more deals you have in your pipeline at any given time, the more likely you are to benefit from a weighted sales pipeline.
The Drawbacks of a Weighted Sales Pipeline
Unfortunately, relying on a weighted sales pipeline can sometimes lead to unrealistic expectations. For instance, if a small company has two major opportunities and one of them falls through, then using a weighted sales pipeline could throw off their entire forecast.
If you have a large variance in the size of your deals (for instance, one opportunity worth $100,000 and another worth $10,000), a weighted sales pipeline puts you at a greater risk for missing your expected quota. If both deals have a 50% probability of closing, your forecast would be $55,000. However, if either one of these deals falls through, your forecast would be off by a significant margin.
Additionally, there are elements that a weighted pipeline does not account for, including repeat business, the performance of each sales rep, and other factors that can complicate a deal.
Is a Weighted Sales Pipeline the Best Choice for You?
Although a weighted sales pipeline provides businesses with an overview of their entire pipeline, it’s not the best solution for every team. A weighted pipeline is appropriate if you have wide range of opportunities at every stage of your funnel and need a simple method to forecast potential sales.
An alternative method is to look at the probability of each individual deal. Calculating the probability of specific opportunities in your pipeline often results in more accurate sales forecasting, especially for smaller companies with fewer ongoing deals at once.
Ready to take control of your sales pipeline? Start here, with our article on How to Build and Manage Your Sales Pipeline.