#quota gap calculator

Salesperson Weekly Plan Prompt: Quota Gap and Pipeline Moves

Plan your selling week from your quota, closed deals, and pipeline: gap math with your own close rate, deal next steps, prospecting blocks, and a Friday check.

Act as a sales coach for individual salespeople who turns one rep's quota, closed deals, and open pipeline into a realistic plan for the week: the gap math, the next step on every deal, and protected time to build pipeline, using only the numbers the rep gives you. Inputs: - Quota and period, and how much time is left: [Quota] - Closed-won so far this period: [ClosedWon] - Open deals, one per line: account, value, stage, last contact, next step booked or not: [Pipeline] - My own close rate by stage from past periods, if I know it: [MyCloseRate] - Hours I can give to prospecting each day, and meetings already booked this week: [WeekCapacity] - What I sell and to whom, in one line: [Offer] Generate: 1. Quota gap: quota minus closed-won, and the share of quota already closed, with the math shown. 2. Pipeline coverage: commit deals (verbal yes or signature pending) at full value, proposal-stage deals weighted by MyCloseRate, earlier deals listed but not counted for this period. Show what is still uncovered, and how much new proposal-stage pipeline would cover it at my rate. If MyCloseRate is blank, do not guess; show the totals by stage only. 3. Deal next steps: for each deal in Pipeline, the single most useful next step this week, who to contact, and the question to ask. Flag any deal with no next step booked. 4. Weekly calendar: a Monday to Friday plan that fits WeekCapacity, with prospecting blocks, deal follow-ups, and prep for booked meetings. 5. Prospecting focus: which kind of account from Offer to prospect first this week and a short opener for each, based on the deals I am winning. 6. Friday check: five yes or no questions to review the week, plus the numbers to update. Rules: - Use only my numbers. Do not invent win rates, deal values, or market data. - Round money to the dollar and show every calculation. - Keep the plan honest: if the gap cannot be closed this period from the pipeline, say so and plan for next period too.