Case 41
Pipeline Forecast Stress Test
Scenario
You are Head of Sales Operations at Kestrel Logistics. The quarterly forecast goes to the leadership team on Friday. Last quarter the forecast was missed and the CEO has asked for a firmer number.
Why this framework
Uses full PINPOINT because the consequence is higher: adds a professional stance, examples, self-checks, your own review before use, and a plan to tweak and test.
Example context
Stage definitions (from export header): Qualify 10%, Solution 30%, Proposal 50%, Negotiation 75%, Verbal 90%, Closed Won 100%. Pipeline export, Kestrel Logistics, Q4 2026 (close dates in quarter), values in £k: deal, account, stage, value, close date, last logged activity: D1 Harlow Retail, Verbal, 420, 14 Nov, 28 Oct. D2 Bexley Foods, Negotiation, 310, 30 Nov, 22 Oct. D3 Ardent Pharma, Negotiation, 560, 19 Dec, 2 Sep. D4 Marsh Home, Proposal, 180, 12 Dec, 30 Oct. D5 Quayside Wines, Proposal, 240, 20 Dec, 5 Aug (at Proposal since 1 Aug). D6 Torridge Parts, Solution, 390, 28 Nov, 25 Oct. D7 Penn Medical, Verbal, 150, 7 Nov, 31 Oct. D8 Fenwick Auto, Proposal, 275, 15 Dec, 18 Oct. D9 Oriel Fashion, Qualify, 600, 31 Dec, 20 Oct. D10 Lyle Building, Negotiation, 205, 21 Nov, 29 Oct. Closed Won so far this quarter: 640. Last quarter: forecast 2,300; actual 1,820. Of deals in Negotiation at quarter start, 55% closed in quarter; of Proposal, 25%; of Verbal, 90%. Two deals slipped because legal review took longer than planned.
Prompt
Purpose: Stress-test this quarter's pipeline forecast before I present it to the leadership team, so the number I give is one I can defend.
Context: Use the attached pipeline export and last quarter's forecast against actuals. The pipeline export is the source of truth for deal stages and values. Do not change any deal values.
Narrow the ask: Give me
1. Deals whose stage, close date or activity history looks out of line, with the reason.
2. A cautious, a likely and a stretch figure, showing exactly which deals sit in each.
3. What would need to happen for the likely figure to hold.
Stop and ask me if the stage definitions are not clear from the export.
Persona and role: Act as a sceptical sales finance partner. Your job is accuracy, not optimism.
Example of what good looks like: "Deal 14 has been at proposal stage for 90 days with no logged contact, so it sits in stretch only." Example of what bad looks like: "Pipeline looks healthy overall."
Check your work: For each material claim, label it as [Verified Source], [Inference], [Assumption], or [Unverified]. Cite the source where available. If an unverified or assumed point could materially change the conclusion, flag it for review rather than guessing. Confirm every total adds up from the deals listed.
Before I use it: I will review the flagged deals with each account owner before Friday.
If the first pass misses the mark, I will change one thing at a time, starting with how deals are placed into each figure.
Materials (pasted here in place of the attachments):
Stage definitions (from export header): Qualify 10%, Solution 30%, Proposal 50%, Negotiation 75%, Verbal 90%, Closed Won 100%.
Pipeline export, Kestrel Logistics, Q4 2026 (close dates in quarter), values in £k: deal, account, stage, value, close date, last logged activity:
D1 Harlow Retail, Verbal, 420, 14 Nov, 28 Oct.
D2 Bexley Foods, Negotiation, 310, 30 Nov, 22 Oct.
D3 Ardent Pharma, Negotiation, 560, 19 Dec, 2 Sep.
D4 Marsh Home, Proposal, 180, 12 Dec, 30 Oct.
D5 Quayside Wines, Proposal, 240, 20 Dec, 5 Aug (at Proposal since 1 Aug).
D6 Torridge Parts, Solution, 390, 28 Nov, 25 Oct.
D7 Penn Medical, Verbal, 150, 7 Nov, 31 Oct.
D8 Fenwick Auto, Proposal, 275, 15 Dec, 18 Oct.
D9 Oriel Fashion, Qualify, 600, 31 Dec, 20 Oct.
D10 Lyle Building, Negotiation, 205, 21 Nov, 29 Oct.
Closed Won so far this quarter: 640.
Last quarter: forecast 2,300; actual 1,820. Of deals in Negotiation at quarter start, 55% closed in quarter; of Proposal, 25%; of Verbal, 90%. Two deals slipped because legal review took longer than planned.Example output from ChatGPT
Kestrel Logistics: Q4 2026 Pipeline Stress Test
As at 2 November 2026 | Values in £k | For leadership review
Recommendation: Present £1,725k (£1.725m) as the likely quarter-end figure, with £1,210k as the cautious case and £3,130k as stretch. The likely figure is conditional on confirming the status of four open deals.
Cautious
£1.210m
Won + verbal
Likely
£1.725m
Working forecast
Stretch
£3.130m
Conditional upside
[Inference] Scenario classifications are judgement-based, not probability-weighted forecasts. The £640k already won is included in all three cases.
1. Deals requiring scrutiny
| Deal | Value | Concern | Treatment |
|---|---|---|---|
| D3 Ardent Pharma | £560k | [Verified Source] Negotiation, last activity 2 Sep, 61 days ago. [Inference] Stage confidence is questionable. | Stretch |
| D5 Quayside Wines | £240k | [Verified Source] Proposal since 1 Aug, last activity 5 Aug, 89 days ago. [Inference] Appears stalled. | Exclude |
| D6 Torridge Parts | £390k | [Verified Source] Solution stage, 28 Nov close. [Inference] Limited time to complete remaining stages. | Stretch |
| D9 Oriel Fashion | £600k | [Verified Source] Qualify stage, 31 Dec close. [Inference] Too early to rely on a Q4 close. | Exclude |
| D8 Fenwick Auto | £275k | [Verified Source] Proposal, last activity 18 Oct. [Inference] Insufficient evidence of progression toward negotiation. | Stretch |
| D2 Bexley Foods | £310k | [Verified Source] Negotiation, last activity 22 Oct. [Inference] Needs confirmation of legal and commercial progress. | Likely, conditional |
| D10 Lyle Building | £205k | [Verified Source] Negotiation, last activity 29 Oct. [Inference] Recent contact supports inclusion, subject to closing requirements. | Likely, conditional |
[Verified Source] D1, D7 and D4 have recent recorded activity. However, a recent activity date does not establish buyer commitment.
2. Scenario composition and reconciliation
Cautious: £1,210k
Base case
Closed Won £640k + D1 £420k + D7 £150k = £1,210k
Likely: £1,725k
+ £515k
Cautious £1,210k + D2 £310k + D10 £205k = £1,725k
Stretch: £3,130k
+ £1,405k
Likely £1,725k + D3 £560k + D4 £180k + D6 £390k + D8 £275k = £3,130k
Excluded from all scenarios: D5 £240k + D9 £600k = £840k.
Reconciliation: £3,130k + £840k = £3,970k, matching £3,330k open pipeline + £640k Closed Won.
Historical challenge: [Verified Source] Last quarter's £2,300k forecast produced £1,820k actual, a £480k shortfall, or 20.9% of forecast. Historical closure rates were 90% for Verbal, 55% for Negotiation and 25% for Proposal.
[Inference] These rates support caution, particularly for D3, D4 and D8. They are not enough to calculate a reliable probability of each individual deal closing.
3. What must happen for £1,725k to hold
- D1 and D7 (£570k): Account owners confirm purchase approval, signed-contract path and the November closing dates.
- D2 and D10 (£515k): Account owners confirm outstanding commercial terms, legal review status, decision-maker approval and dates for signatures.
- Legal delays: [Verified Source] Two deals slipped last quarter because legal reviews took longer than planned. [Inference] Any unresolved legal dependency in the likely-case deals should trigger a forecast review.
- Forecast discipline: If D2 or D10 lacks a credible completion plan by Friday, remove that deal from likely rather than relying on its CRM stage.
4. Items to verify before presenting
[Assumption] The £640k Closed Won is distinct from D1–D10, and all values are additive without double-counting.
[Unverified] The export does not disclose signed contracts, buyer approvals, legal status, opportunity ownership or whether the logged activities represent meaningful progress.
[Inference] Consequently, the £1.725m figure is a defensible working scenario, but not yet an owner-validated commitment.
Leadership message: "We have £640k secured. Our working quarter-end forecast is £1.725m, dependent on closing two verbal deals and two negotiation-stage deals. We have deliberately excluded £840k of early or stalled pipeline, and will validate the remaining closing dependencies with deal owners before Friday."
All deal values and stage definitions are from the supplied Q4 pipeline export. Historical comparisons use the supplied previous-quarter results. Scenario inclusion rules are analyst judgements and should be challenged in the owner review.
