Qualified pipeline to contribution pathsEach branch uses its own conversion, cycle, and discount assumptions
Business
Sales Pipeline Scenario Calculator
Stress-test the same opening pipeline under three explicit execution environments rather than multiplying every input by a vague percentage. Each scenario changes lead flow, stage conversion, sales-cycle completion, discount, and gross margin, then reconciles wins, bookings, contribution, quota coverage, and required pipeline coverage.
Operating-plan bookings-
Operating-plan contribution-
Quota coverage-
Expected wins-
Best bookings scenario-
Best contribution quality-
Plan target gap-
Required gross coverage-
Execution scenario fan
Separate conversion quality, closing velocity, discount, and contribution
ConservativeOperating planExecution upside
| Scenario | Proposal rate | Win rate | Cycle days | Discount | Expected wins | Bookings | Contribution | Target coverage |
|---|
Scenario design
Change the mechanism that creates the outcome, not one generic multiplier
- Freeze one opening qualified pipeline and one bookings target.
- Define the operating proposal, win, cycle, discount, and margin assumptions.
- Build a conservative branch with slower conversion and closing velocity.
- Build an execution-upside branch with better stage discipline but a higher discount.
- Compare bookings, contribution, target coverage, and contribution quality together.
Scenario notation
Each branch has a complete commercial identity
Detailed calculation process
Turn qualified value into closed contribution
New qualified value = N × VScenario qualified value = P₀ + New qualified valueExpected wins = N × p × w × min(1, Horizon days / Cycle days)Bookings = [P₀ × p × w + Expected wins × V] × (1 - d)Contribution = Bookings × max(0, m - d)Target coverage = Bookings / Bookings targetDiscount reduces both invoice value and effective gross-margin quality. Cycle completion limits only the new opportunity flow because the opening pipeline is already qualified at the start of the horizon.
Named operating branches
What changes in the three displayed paths
Conservative: proposal and win rates are reduced, the cycle is longer, and discount restraint protects margin.
Operating plan: uses the exact entered assumptions.
Execution upside: improves proposal and win discipline and shortens the cycle, while allowing a modestly higher discount to expose the contribution trade-off.
Operating-path substitution
Rebuild bookings and contribution from the qualified pool
Qualified pool = $3,200,000 + 52 x $48,000 = $5,696,000Bookings = $5,696,000 x 50% x 30% x (1 - 7%) = $794,592Contribution = $794,592 - [$5,696,000 x 50% x 30% x (1 - 66%)] = $504,096The operating path covers 44.1% of the $1,800,000 target and leaves a $1,005,408 gap. The displayed 17.8 wins are probability-weighted portfolio output, not a promise of fractional contracts.
Decision use
Questions this comparison can answer
- Whether target coverage depends on late-stage conversion
- Whether discount-led upside produces lower contribution quality
- Whether a long cycle pushes viable deals outside the horizon
- How much qualified pipeline the plan requires
Model boundary
Scenarios are not probabilities
The branches do not assign likelihood and omit stage aging, deal correlation, rep capacity, product mix, renewal revenue, and customer-specific close timing.
Sales pipeline scenario FAQ
Questions about interpreting the fan
Why can upside have weaker contribution quality?
Its higher discount may convert more deals while retaining less contribution per booking dollar.
Is gross coverage the same as forecast coverage?
No. Gross coverage uses qualified value before stage probability; the forecast applies conversion and timing.
Should scenarios share the same target?
Yes. A common target keeps the comparison decision-focused.
Practical examples
Sales Pipeline Scenario Calculator in real planning situations
- Compare a conversion slowdown with a cycle-length delay.
- Quantify the contribution cost of discount-led upside.
- Test whether the operating plan still covers the quarterly bookings target.
Important note
Before relying on this result
Calculated from the entered values using the displayed accounting method. Reconcile material decisions with source records and applicable accounting policy.
Additional Sales Pipeline Scenario Calculator questions
Why model conversion and cycle separately?
A deal can remain viable but close outside the planning horizon, which is different from losing it.
Is upside automatically the best scenario?
No. Higher bookings can carry heavier discounts and lower contribution quality.
What is coverage?
It is gross qualified pipeline divided by the bookings target, not a probability-weighted forecast.