Pipeline Coverage Calculator.

This calculator computes two complementary pipeline coverage ratios. Raw coverage divides total open pipeline by remaining quota, showing the simple multiple of pipeline to target. Weighted coverage multiplies each stage amount by its win probability before dividing by remaining quota, providing a probability-adjusted view that accounts for the reality that early-stage deals close at much lower rates than late-stage deals.

Remaining quota is calculated as the maximum of zero and the difference between total quota and already closed-won revenue. When closed-won revenue meets or exceeds quota, the calculator displays a success state with the surplus amount and suppresses coverage grading, since coverage ratios lose meaning when the target is already achieved. Pipeline metrics are still shown for next-quarter planning purposes.

The coverage grade applies to the raw coverage ratio only. Below two-x is graded as Danger because typical win rates mean insufficient pipeline will convert. Two to three-x is At Risk, three to four-x is Healthy, and above four-x is Strong. Weighted coverage is not graded because the definition of "good" varies significantly by sales motion, deal size, and organizational maturity.

The gap analysis calculates the shortfall between remaining quota and weighted pipeline. It then converts this weighted gap into a raw pipeline target by dividing by the blended win rate, which is the ratio of weighted pipeline to total pipeline. This gives pipeline generation teams a concrete dollar target in terms of deals they need to create rather than probability-adjusted values they cannot directly influence.