Required qualified pipeline equals the revenue target divided by the win rate on qualified opportunities. Coverage ratio equals open qualified pipeline divided by the revenue still required.
What each input means
Revenue target is what has to be closed in the period. Win rate is deals won divided by deals won plus lost, calculated on opportunities that met your qualification standard. Qualified pipeline is the open value of opportunities meeting that same standard, which is why the standard has to be written down and enforced. Sales cycle length does not appear in the ratio but determines when the pipeline must exist: opportunities created less than one cycle before the period ends belong to the next period regardless of where they sit on the board.
A worked example (illustrative figures)
A team carries an annual target of ₹8,00,00,000. Its win rate on qualified opportunities is 25%, and its average deal value is ₹4,00,000. Required pipeline is 8,00,00,000 divided by 0.25, which is ₹32,00,00,000, or a coverage ratio of four times. At ₹4,00,000 per deal that is 800 qualified opportunities across the year, which is roughly 67 a month. With a three-month sales cycle, everything intended to close in the October to December quarter needs to exist by the end of September. Stated this way, the annual target becomes a monthly generation number that a team can actually manage, and a shortfall becomes visible three months before it turns into a missed quarter.