Forecast pipeline revenue

Build the Q3 pipeline forecast by aggregating all open opportunities owned by quota-bearing reps with close dates in July–September. Use weighted values by stage: Qualification 10 percent, Proposal 40 percent, Negotiation 70 percent, Commit 90 percent. Produce a summary by rep and by product line, and flag any deals over $100,000 that are still in Qualification. Deliver this to the CRO and finance by end of day Friday.

Before I finalize the forecast, make it easier to trust. Surface deal age, last activity date, and any changes to ARR or scope since the last forecast. Highlight deals that slipped from previous quarters and mark those with no activity in two weeks. Show a sensitivity view with optimistic and conservative totals based on moving Proposal-stage deals up or down one stage.

The weekly forecast dropped by half a million and the CRO is asking for an explanation. I don’t know whether deals were lost, stages regressed, or weightings changed. I’m afraid rushing a canned response will miss a systemic error. Diagnose the likely sources to check in order and recommend the first three actions I should take to produce a reliable explanation for the CRO.

Quarter after quarter my forecasts swing wildly because reps advance stages on verbal commitments and we lack consistent activity proof. This erodes leadership trust and forces emergency scrambles. What two habits should I change in our pipeline hygiene routine and what one small report or metric would give me an early warning before forecasts break?