The Pipeline That Looks Full but Closes Empty
A sales manager reviews a $9M pipeline against a $3M quarterly quota. Coverage looks healthy at 3x. But forecast accuracy has been poor for three quarters: reps commit deals that slip 60–90 days, and the manager consistently lands at 80–85% of forecast. Digging in, the manager finds: 40% of pipeline value sits in 'Proposal' stage with no next-step date; average deal age in stage is 71 days versus a 30-day benchmark; reps log activities but stage definitions are subjective; and the two most optimistic reps account for 55% of committed forecast. The quarter is six weeks from close.
1. Diagnose the root causes of the forecast miss using the pipeline evidence.
Read the worked answer
The 3x coverage is an illusion; the problems are structural:
- Stage definitions are subjective, so 'Proposal' means different things to different reps. Without exit criteria (e.g., decision-maker identified, budget confirmed, timeline agreed), stage is a feeling, not a fact.
- No next-step date on 40% of Proposal value signals deals with no active buyer commitment - these are stalled, not progressing.
- 71-day average age vs. 30-day benchmark means deals are aging in stage, a classic sign of unqualified opportunities being kept alive to inflate pipeline.
- Two optimistic reps own 55% of committed forecast - forecast is concentrated in the least reliable sources, so the aggregate inherits their bias.
These combine to produce systematic over-forecast: unqualified deals at inflated stages, held by optimistic reps, with no forcing function (next-step dates) to expose reality.
2. Recommend actions for the final six weeks and a structural fix for the next quarter.
Read the worked answer
Next six weeks (triage):
- Run a deal-by-deal scrub on committed and best-case pipeline: require a dated next step with a named buyer action for every deal to stay in forecast. Deals without one drop to pipeline, not forecast.
- Apply historical stage-conversion rates to re-weight the forecast rather than trusting rep commits; produce a manager-adjusted number.
- Focus the team's remaining time on late-stage deals with confirmed decision processes; deprioritize early-stage work that cannot close this quarter.
- Separate the two optimistic reps' commits and validate independently with the buyer where possible.
Structural fix:
- Rewrite stage definitions with objective exit criteria and enforce them in CRM.
- Require a next-step date and buyer action to advance any stage.
- Institute a weekly pipeline hygiene review flagging deals over benchmark age.
- Move to a weighted forecast blended with rep commit, and track forecast accuracy by rep to coach bias.