Sales scenario planning is simple to describe and rarely done well. The idea is to model more than one version of the year and decide in advance what you would do in each. In practice most teams build a single plan, call the optimistic version the target, and have no documented answer for the downside that usually arrives.
Doing it properly is a method, not a spreadsheet exercise. It means choosing the few variables that actually move the number, modeling each case against capacity rather than against hope, and attaching a concrete response to each so the plan is a decision, not a chart.
This guide walks that method step by step, and shows where Lative lets you run the cases against a live capacity model instead of rebuilding a file each time.
Why scenario planning usually fails
Two failures are common. The first is modeling revenue scenarios without touching capacity, so the worst case is a smaller number with no explanation of what causes it. The second is building the cases and never assigning a response, so when reality lands on the downside there is a chart but no plan. A scenario without a trigger and a response is trivia.
How to do sales scenario planning, step by step
Five steps turn scenario planning from a chart into a decision.
1. Pick the variables worth flexing
Do not flex everything. Choose the two or three inputs that actually move the outcome: hiring timing, ramp speed, attrition, and win rate by segment. Flexing noise produces noise.
2. Build base, best, and worst against capacity
Model each case through capacity, not just revenue. The worst case is not “we make less”; it is “a hire slips and attrition runs high, so ramped capacity drops to X, which produces Y.” The cause has to be in the model.
3. Quantify the range, not just the midpoint
The value is the spread. Knowing the plan produces the target in the base case but falls short by a definable amount in the worst case tells you how much coverage or hiring buffer the plan needs to carry.
4. Attach a response and a trigger to each
For each downside, write the response before you need it: pull forward a hire, reallocate capacity, adjust the target with finance. Attach a trigger, a metric that says the scenario is happening, so the response fires on data rather than on panic.
5. Re-run on a cadence
Scenarios go stale. Rerun them each quarter as actuals move, so the live plan always sits inside a current range rather than a set of cases built once in January.
Average attainment that low is what a single-number plan produces: no modeled downside, no trigger, and no response until the gap is already unfixable.
How Lative helps
The friction in scenario planning is the rebuild, which is what Lative removes.
Lative’s Simulations model long-range capacity under different hiring and attrition assumptions, and Quota Modeling re-derives net quota capacity for each case, all off the live model. Because a scenario is the same plan under new assumptions rather than a separate spreadsheet, you can build the range in an afternoon and re-run it whenever the quarter shifts.
Key takeaways
- Scenario planning is a method, not a spreadsheet: pick variables, model against capacity, attach responses.
- Flex only the two or three inputs that actually move the number.
- The worst case needs a cause in the model, not just a smaller revenue figure.
- Every scenario needs a written response and a trigger, or it is just a chart.
- Re-run scenarios on a cadence so the live plan always sits inside a current range.
Frequently asked
How do you do sales scenario planning?
Pick the few variables that move the number, build base, best, and worst cases through capacity rather than just revenue, quantify the range, attach a response and a trigger to each downside, and re-run the cases on a cadence.
What variables should you flex in a sales scenario?
The ones with real leverage: hiring timing, ramp speed, attrition, and win rate by segment. Flexing everything produces noise; flexing the drivers produces decisions.
How many scenarios should you build?
Base, best, and worst is the minimum. The point is the spread between them and the response attached to each, not the exact count, so add cases only where they change a decision.
What makes a scenario useful rather than a chart?
A cause in the model, a trigger metric that signals it is happening, and a written response. Without those, a scenario is trivia; with them, it is a pre-made decision.
How does Lative help with scenario planning?
Lative’s Simulations and Quota Modeling run each scenario off the live capacity model, so a case is the same plan under new assumptions rather than a rebuilt spreadsheet, and re-running it takes minutes.
See it in action. Book a Lative demo and build a base, best, and worst case against a live capacity model in one sitting.
Werner Schmidt — Werner Schmidt is the CEO and Co-founder of Lative, with over 20 years of experience in Revenue Operations with companies including Forcepoint, Aruba Networks, Citrix, and Sage.
