CSE CSE Sales Forecasting & Pipeline Management 2 — Questions and Answers
Question 1: What is pipeline coverage ratio and why is it important?
- Ratio of marketing leads to sales leads; shows campaign effectiveness
- Ratio of total pipeline value to revenue target; indicates likelihood of hitting quota (Correct answer)
- Ratio of closed deals to lost deals; measures win rate
- Ratio of outbound to inbound deals; shows prospecting mix
Correct answer: Ratio of total pipeline value to revenue target; indicates likelihood of hitting quota
Pipeline coverage ratio (pipeline value divided by quota) tells sales leaders whether enough opportunities exist to achieve targets, with 3x coverage commonly considered healthy.
Question 2: Which technique assigns a probability percentage to each pipeline stage to estimate weighted forecast revenue?
- Regression analysis
- Stage-based probability weighting (Correct answer)
- Balanced scorecard
- Monte Carlo simulation
Correct answer: Stage-based probability weighting
Stage-based probability weighting multiplies deal value by the historical close probability for each pipeline stage to produce a weighted, more realistic revenue forecast.
Question 3: What is the main risk of relying solely on a salesperson's 'commit' forecast category?
- It overestimates pipeline coverage
- It may introduce individual optimism bias, overstating likely closures (Correct answer)
- It does not account for deal size
- It ignores the sales cycle length
Correct answer: It may introduce individual optimism bias, overstating likely closures
Commit forecasts depend on individual rep judgment, which can be overly optimistic; cross-referencing with CRM data and activity signals improves accuracy.
Question 4: When a deal has been in the same pipeline stage for twice the average sales cycle duration, it is BEST classified as:
- A high-priority opportunity
- A stalled or at-risk deal requiring immediate management attention (Correct answer)
- A standard opportunity with no intervention needed
- A deal to be escalated to senior leadership for approval
Correct answer: A stalled or at-risk deal requiring immediate management attention
A deal lingering in a stage well beyond the average cycle time signals stagnation and requires the sales executive to re-engage, re-qualify, or remove it from the active forecast.
Question 5: Which CRM metric BEST helps identify if a sales rep needs coaching on early pipeline stages?
- Average contract value
- Lead-to-opportunity conversion rate (Correct answer)
- Customer satisfaction score
- Renewal rate
Correct answer: Lead-to-opportunity conversion rate
A low lead-to-opportunity conversion rate indicates a rep struggles to qualify prospects early in the funnel, pointing to a need for coaching on discovery and qualification.
Question 6: What is the purpose of a quarterly business review (QBR) in the context of pipeline management?
- To negotiate compensation packages with sales reps
- To assess pipeline health, review forecast accuracy, and set action plans for the next quarter (Correct answer)
- To present product roadmaps to customers
- To audit compliance with company expense policies
Correct answer: To assess pipeline health, review forecast accuracy, and set action plans for the next quarter
A QBR evaluates past pipeline performance, examines forecast accuracy, and aligns the sales team on strategies and resource needs for the upcoming quarter.
CSE CSE Sales Forecasting & Pipeline Management 2
What is pipeline coverage ratio and why is it important?