Work & small business · 397

Pipeline coverage calculator

How much open pipeline covers the quota still left to close?

Your numbers

$
$
$

Explore the numbers

Examples, chart, and saved snapshots

Start with a realistic example, adjust the inputs, or save your numbers before experimenting.

Example 1

300,000 open against 120,000 still to close

The period quota is 200,000. Closed revenue is 80,000, so 120,000 remains. Open pipeline is 300,000. The coverage target you typed is 3.

2.5×coverage of the quota still open
Example 2

Quota for the period: 25% lower

Change quota for the period to 150,000 while keeping the other example values the same.

4.29×coverage of the quota still open
Example 3

Quota for the period: 25% higher

Change quota for the period to 250,000 while keeping the other example values the same.

1.76×coverage of the quota still open

Interactive chart

See what changes the result

Result—

The chart changes one input while holding all other current values steady. It is a sensitivity view, not a forecast.

Browser snapshots

Freeze these values

Save the current calculation, experiment freely, and restore it later.

No saved snapshots for this calculator yet.

Saved only in this browser. Nothing is uploaded, and clearing browser data removes the snapshots.

Quick answer

What does the Pipeline coverage calculate?

How much open pipeline covers the quota still left to close? This calculator uses quota for the period, closed revenue, open pipeline, and coverage target to estimate open pipeline against the quota left immediately in your browser.

With the values currently entered, the result is 2.5× — coverage of the quota still open. It also shows quota still to close, pipeline the target needs, and short of the target.

How to use the Pipeline coverage

  1. Replace the example values with your own numbers.
  2. Review the result and supporting figures as they update automatically.
  3. Check the formula and assumptions before using the estimate for a decision.

Inputs used

  • Quota for the period
  • Closed revenue
  • Open pipeline
  • Coverage target

Pipeline coverage formula

Remaining quota = quota − closed revenue. Coverage = open pipeline ÷ remaining quota. Pipeline at the target = remaining quota × the target you type.

Assumptions

  • SBA tells you to set a sales goal and compare results with it. Coverage divides the open pipeline you type by the quota still left after closed revenue.
  • The coverage target is a multiple you type. This page does not set a required multiple. A probability-weighted pipeline is a smaller number than the sum of deal values. Put the version you want in the pipeline box.

Verify the inputs

Authoritative sources

These sources explain the definitions, factors, or rules behind this tool. Their geographic scope is shown because an official source for one country is not automatically valid somewhere else.

Sources do not endorse Calculum. Check the source date, scope, and your own documents before making a financial, tax, insurance, or reporting decision.

Practical guide

Pipeline coverage example and edge cases

Pipeline coverage compares open deals with the quota you still have to close. SBA tells you to set a sales goal and measure results against it. The multiple here is open pipeline divided by quota minus closed revenue.

Example: 300,000 open against 120,000 still to close

The period quota is 200,000. Closed revenue is 80,000, so 120,000 remains. Open pipeline is 300,000. The coverage target you typed is 3.

Quota for the period
200,000
Closed revenue
80,000
Open pipeline
300,000
Coverage target
3

Calculated result2.5×coverage of the quota still open

Coverage is 2.5×. A target of 3 on the remaining 120,000 would need 360,000 of pipeline. The open pipeline is 60,000 short of that target. The target is the number you typed.

Example results use the default display profile. The calculator above follows your selected country and units.

How to read the result

  • The multiple is open pipeline divided by the quota still left. The gap line uses the target you typed.
  • Put closed deals in the closed box. Leaving them in the open pipeline counts the same revenue on both sides of the quota.

Edge cases worth checking

Weighted pipeline sits next to a full quota

Type the pipeline the way you want to compare it with the quota. A probability-weighted total is smaller than the sum of deal values. The quota stays the goal you set.

Closed revenue already passed the quota

Remaining quota is zero, so the ratio has no denominator. The result says the quota is met and shows the pipeline that is still open.

What changes the result most

Quota for the period

Use a current amount for quota for the period. Include fees or recurring costs that belong in the same figure.

Closed revenue

Use a current amount for closed revenue. Include fees or recurring costs that belong in the same figure.

Open pipeline

Use a current amount for open pipeline. Include fees or recurring costs that belong in the same figure.

Try a different scenario

Small changes show whether the answer is stable or sensitive.

Quota for the period: 25% lower

150,000

4.29×coverage of the quota still open

Quota for the period: 25% higher

250,000

1.76×coverage of the quota still open

Closed revenue: 25% higher

100,000

3×coverage of the quota still open

Common mistakes

Check quota for the period

SBA tells you to set a sales goal and compare results with it. Coverage divides the open pipeline you type by the quota still left after closed revenue. Make sure this matches the number you enter.

Keep coverage target consistent

The coverage target is a multiple you type. This page does not set a required multiple. A probability-weighted pipeline is a smaller number than the sum of deal values. Put the version you want in the pipeline box. Use the same units and time period throughout the calculation.

Do not rely on one pipeline coverage scenario

Run a cautious case and an optimistic case. The range is often more useful than one exact-looking number.

Use this result well

Use it for

How much open pipeline covers the quota still left to close?

Do not use it as

It does not replace a quote, contract, accountant, or local employment guidance.