Weighted Sales Pipeline Calculator

How to calculate weighted pipeline?

Weighted pipeline adjusts revenue based on the likelihood of closing a deal. Instead of viewing every deal at its full value, this method applies a probability percentage based on the current sales stage to provide a more accurate revenue forecast.

Weighted Value = (Amount × Probability)

Using the Pipeline Calculator: an example

If you have a deal worth $10,000, its value in your forecast depends on how close it is to closing. For example, a deal in the early stages might only contribute a fraction of its total value to your expected revenue.

Step-by-step calculation

1. Identify stage: Determine where the deal is in your process (e.g., Proposal).
2. Assign probability: Use historical data to assign a win likelihood (e.g., 50%).
3. Multiply: Calculate the individual value ($10,000 x 50% = $5,000).
4. Sum: Add up all weighted values for your total sales forecast.

Frequently Asked Questions

• What is the difference between weighted and unweighted pipeline? Unweighted is the total sum of all potential deals at 100% value, while weighted reflects the realistic expected revenue.
• How should I determine my stage probabilities? Base these on your historical CRM data by calculating the percentage of deals that successfully move from a specific stage to "Closed-Won".
• Why is weighted pipeline useful for forecasting? It provides a balanced view that accounts for the risk of deals falling through, allowing for better resource planning and budgeting.