Enter Pipeline Inputs
This page keeps a single-column reading flow, while the calculator itself uses three columns on large screens, two on medium screens, and one on mobile.
Example Data Table
The example below shows a realistic CRM and pipeline scenario using the page defaults.
| Example Metric | Example Value |
|---|---|
| Revenue target | $500,000.00 |
| Current closed revenue | $180,000.00 |
| Remaining target | $320,000.00 |
| Open pipeline value | $900,000.00 |
| Weighted pipeline value | $420,000.00 |
| Average deal size | $25,000.00 |
| Win rate | 25.00% |
| Target coverage multiple | 3.00x |
| Actual coverage multiple | 2.81x |
| Benchmark pipeline needed | $960,000.00 |
| Benchmark pipeline gap | $60,000.00 |
| Expected closed revenue from open pipeline | $225,000.00 |
Formula Used
Remaining Target = Revenue Target − Current Closed Revenue
2) Actual Coverage MultipleActual Coverage Multiple = Open Pipeline ÷ Remaining Target
3) Weighted Coverage MultipleWeighted Coverage Multiple = Weighted Pipeline ÷ Remaining Target
4) Benchmark Pipeline NeededBenchmark Pipeline = Remaining Target × Target Coverage Multiple
5) Win-Rate Pipeline NeededWin-Rate Pipeline Needed = Remaining Target ÷ Win Rate (decimal form)
6) Expected Closed RevenueExpected Closed Revenue = Open Pipeline × Win Rate (decimal form)
7) Additional Opportunities NeededOpportunity Gap = Pipeline Gap ÷ Average Deal Size
8) Daily Pipeline NeededDaily Pipeline Needed = Pipeline Gap ÷ Days Remaining
How to Use This Calculator
- Enter the total revenue target for the period.
- Add the amount already closed so the calculator can find the remaining target.
- Enter both raw open pipeline value and weighted pipeline value.
- Provide average deal size and current win rate.
- Enter total days in the period and how many days have passed.
- Add rep count, target coverage multiple, and average sales cycle days.
- Click Calculate Coverage to show results above the form.
- Review the chart, export the table, and compare benchmark and win-rate gaps for action planning.
FAQs
1) What does target coverage mean?
Target coverage shows how much open pipeline supports the revenue still needed. It is usually expressed as a multiple, such as 3.0x pipeline against the remaining target.
2) Why compare raw and weighted pipeline?
Raw pipeline shows total possible value. Weighted pipeline reflects probability-adjusted value and gives a more realistic view of expected closings against the target.
3) Why is win-rate pipeline needed different from benchmark pipeline?
A fixed benchmark multiple is a policy target. Win-rate pipeline is mathematically driven by your current conversion rate, so it can be higher or lower than the benchmark.
4) What is a good coverage multiple?
Many teams track 3.0x, but the best value depends on win rate, deal quality, cycle length, and forecast discipline. Lower win rates usually need higher coverage.
5) Why does sales cycle matter here?
If the average sales cycle is longer than the time left in the period, new opportunities may not close in time. That makes the current gap harder to solve.
6) How should I use daily pipeline needed?
Use it as a pacing signal. It tells you how much qualified pipeline should be created or advanced each day to close the current gap.
7) Can this calculator help with rep planning?
Yes. It breaks remaining target, open pipeline, weighted pipeline, and average deals needed down per rep so managers can assign action more clearly.
8) When should I update the inputs?
Update the calculator whenever pipeline changes, new deals close, win rates shift, or forecast assumptions move. Frequent refreshes improve coverage decisions.