A useful sales forecasting example does more than produce a revenue target. It shows leadership what must happen in the pipeline, how much capacity the sales team needs, and where results could fall short before the quarter is over.
Consider a growing B2B services company with four account executives. The leadership team has set a quarterly bookings goal of $720,000. Rather than asking the team to simply “sell more,” the sales manager builds a forecast from real operating data: open opportunities, historical conversion rates, deal values, and rep capacity.
This practical approach gives managers a number they can defend, a plan they can manage, and clear signals for when action is needed.
Sales Forecasting Example: Start With the Revenue Goal
The company’s $720,000 quarterly target equals $240,000 in new bookings per month. Its average closed-won deal is $12,000, so the team needs to close 20 deals per month:
| Metric | Calculation | Monthly Requirement | |—|—:|—:| | Revenue target | $720,000 / 3 months | $240,000 | | Average deal value | Historical average | $12,000 | | Deals needed | $240,000 / $12,000 | 20 deals |
That calculation is simple, but it is not yet a forecast. A target states the desired result. A forecast estimates the likely result based on current evidence.
The difference matters. When a company treats an ambitious target as a forecast, leaders may not recognize a pipeline gap until there is too little time to correct it.
Build the Forecast From Open Pipeline
The sales team begins the quarter with 60 active opportunities. Their CRM uses four stages, and the company has measured its historical close rate for each stage over the past 12 months.
| Sales stage | Open opportunities | Average deal value | Historical win rate | Weighted forecast | |—|—:|—:|—:|—:| | Discovery | 24 | $12,000 | 10% | $28,800 | | Qualified | 18 | $12,000 | 25% | $54,000 | | Proposal | 12 | $12,000 | 50% | $72,000 | | Negotiation | 6 | $12,000 | 75% | $54,000 | | Total | 60 | | | $208,800 |
The weighted pipeline forecast is $208,800. Against the monthly target of $240,000, the company begins the month with a $31,200 gap.
This does not mean the team cannot reach the target. It means the current pipeline, based on historical performance, does not support the target with enough confidence. Sales leadership now has a specific issue to address: create, advance, or improve enough opportunities to cover the gap.
Why weighted pipeline is useful
Weighted forecasting is effective when a company has reasonably consistent CRM data and enough closed opportunities to calculate meaningful stage conversion rates. It gives more credit to late-stage deals while recognizing that early-stage opportunities remain uncertain.
However, stage probability should come from the company’s own history whenever possible. Assigning 50% probability to every proposal simply because it “feels right” can create a misleading forecast. A proposal stage may convert at 20% in one business and 65% in another, depending on qualification quality, sales cycle length, pricing, and competition.
Add Sales Capacity to the Forecast
Pipeline tells leaders what may close. Capacity tells them what the team can realistically create and manage.
In this example, each account executive produces an average of 20 qualified opportunities per month. The qualified-to-closed-won conversion rate is 25%. With an average deal value of $12,000, one representative’s expected monthly contribution from newly qualified opportunities is:
20 qualified opportunities × 25% win rate × $12,000 average deal value = $60,000
With four account executives, the team can generate approximately $240,000 in future bookings per month once those opportunities move through the sales cycle.
The company’s average sales cycle is 60 days. That timing changes the interpretation. Opportunities created this month are not likely to close this month. They are more likely to influence results two months from now.
A practical forecast therefore separates three questions:
- What is likely to close this month from the existing pipeline?
- What pipeline must be created now to support future months?
- Does the team have enough capacity to create and progress that pipeline?
This distinction prevents a common planning error: using current lead activity to explain a near-term revenue target that is already dependent on opportunities created weeks or months earlier.
Create a Three-Month View
The sales manager combines current weighted pipeline with expected opportunity creation. The result is a rolling forecast that is more actionable than a single quarterly estimate.
| Month | Weighted existing pipeline | Expected new bookings contribution | Forecasted bookings | Target | |—|—:|—:|—:|—:| | Month 1 | $208,800 | $0 | $208,800 | $240,000 | | Month 2 | $150,000 | $60,000 | $210,000 | $240,000 | | Month 3 | $120,000 | $240,000 | $360,000 | $240,000 |
The figures reveal a potential concern. Month 3 looks strong, but Month 1 and Month 2 are below target. Leaders should examine whether Month 3 contains a few unusually large deals, whether close dates are credible, and whether each rep can handle the volume of opportunities required.
Forecasting is not about creating a perfect number. It is about identifying the assumptions that determine the number and testing them early enough to make better decisions.
Use Best-Case, Commit, and Likely Views
A single forecast can hide uncertainty. For management discussions, it is often more useful to maintain three views of expected revenue.
The commit forecast includes deals that sales representatives and managers believe have a high probability of closing within the period. The likely forecast uses weighted probabilities based on historical stage performance. The best-case forecast includes qualified upside opportunities that could close if timing, budget approval, and competitive conditions align.
For example, the company may report $180,000 committed, $208,800 likely, and $300,000 best case for Month 1. This framing helps finance and operations plan responsibly. Hiring, inventory, and spending decisions should rarely rely on a best-case number alone.
It also improves accountability. If a representative’s committed deal repeatedly slips into the next month, that is not just an individual performance issue. It may point to weak exit criteria, inaccurate close dates, or a sales process that needs clearer qualification standards.
Check the Data Before Trusting the Forecast
A forecast is only as reliable as the data and operating habits behind it. CRM records should include a defined sales stage, realistic expected close date, deal amount, lead source, opportunity owner, and documented next step. Without these fields, a dashboard can look polished while offering little decision value.
Managers should also review forecast accuracy over time. Compare each month’s forecast at the beginning, middle, and end of the period with actual closed revenue. If the forecast consistently overstates performance, review stage probabilities, close-date discipline, and the treatment of stalled opportunities. If it consistently understates results, the team may be progressing opportunities more effectively than the model recognizes.
For newer organizations with limited history, use a combination of available CRM data, sales team judgment, and conservative assumptions. As more deals close, replace assumptions with measured conversion rates. The model should improve with experience rather than remain fixed.
Turn the Forecast Into Management Action
The value of this sales forecasting example is not the spreadsheet formula. It is the conversation the formula creates.
If the weighted forecast is below target, leaders can decide whether to increase prospecting activity, improve conversion at a specific sales stage, reassign opportunities, adjust pricing strategy, or revise expectations. If the forecast is above target but concentrated in a small number of deals, the team can reduce risk by building broader pipeline coverage.
Analytics tools such as Excel, Power BI, SQL, or a CRM dashboard can make these patterns visible, but the business process comes first. Teams need agreed definitions, disciplined data entry, and regular forecast reviews that focus on evidence instead of optimism.
DataLunch Consulting helps organizations build the analytics skills needed to turn operational data into clearer business decisions. The most valuable forecast is not the most complicated one. It is the one your leaders understand, your sales team trusts, and your organization uses early enough to change the outcome.
English 
French