How do you turn the sales plan from a source of conflict into a working tool? The answer is a bottom-up financial model. Let's walk through, step by step, how to build it and roll it out without team resistance.
Why a "top-down" plan is doomed to sabotage
The traditional approach: management decides on the desired revenue, divides it by the number of reps, and hands each one the "average across the board." In doing so, it ignores key factors.
- Actual conversion rates at every stage of the funnel.
- The number of leads a single employee can handle.
- Seasonality and regional specifics.
- The speed deals move and the length of the cycle.
Reps see the disconnect from reality and find ways not to hit the plan - for example, postponing tough negotiations to the next quarter. The only way to avoid this is to involve the team in calculating the plan, but on a rigorous mathematical basis.
A "top-down" plan is the desired figure divided among people. The rep does not see their own statistics in it, so they perceive it as someone else's order rather than their own commitment.
What a bottom-up model is and where its strength lies
With bottom-up, the sales plan is assembled from the micro-metrics of each rep and the funnel. You do not ask "How much will you sell?" - instead, together with the employee you calculate how many deals they can physically close, based on four parameters.
- Available selling time.
- Number of touchpoints with clients.
- Lead-to-quote conversion.
- Average deal size.
This turns the plan into a system of clear operational KPIs that the rep can directly control.
Step-by-step guide: how to build a sales plan without sabotage
Take the target revenue, say $110,000 per month, and break it down into a chain of metrics. This gives you the lead quota the employee must generate daily. It is measurable and realistic.
Take the actual figures for the past 3-6 months for each employee: individual conversion (from call to meeting, from meeting to contract), actual average deal size, number of deals per month, workload. Identify the spread: experienced reps convert at 25%, newcomers at 10%. This lets you make the plan differentiated rather than uniform.
Calculate the maximum productive hours per day (usually 4-5 hours of active selling, the rest is administrative work), the time per deal and the number of deals in a parallel funnel. If a rep spends an average of 3 hours per deal and has 80 net hours a month, the ceiling is 26-27 deals at perfect conversion. Anything higher comes only from overtime or lower quality.
Hold a meeting with the team. Suggest that instead of debating whether the $110,000 figure is "realistic," you calculate together how many leads per day, meetings per week, and proposals are needed. Let each person state their own conversion figures, time per deal, and typical deal size. This way you move the conversation into a constructive direction.
A rigid plan provokes sabotage. Introduce three levels and give reps the right to make mistakes and an incentive to over-deliver without fear.
A bottom-up model only works if you see actual metrics daily: number of new leads, conversion by stage, deal velocity. Use a CRM or at least an Excel dashboard updated once a day. Then you quickly spot where the plan diverges from reality and adjust your actions.
Launch a pilot in one department or with 2-3 volunteer reps. After a month, gather the data: did they hit the plan? Which metrics turned out to be understated or overstated? Adjust the coefficients and scale up to the whole department.
Revenue = Number of closed deals × Average deal size
Number of closed deals = Number of qualified leads × Conversion to deal
Number of leads = Number of the rep's active hours × Leads per hour
The plan "range": three levels instead of one figure
| Level | Share of target | Reward |
|---|---|---|
| Lower threshold | 80% of target | Base salary plus minimal bonus |
| Business norm | 100% of plan | Full bonus |
| Ambitious level | 120%+ | Higher coefficient |
Common mistakes when building a bottom-up model
- Using department-averaged metrics - this kills the individual approach. Weak reps get an inflated plan, strong ones an understated one.
- Ignoring lead quality - leads from different channels have different conversion. Account for the source (website, call center, events).
- Not revising the model when the market changes - if seasonality, competition or the product change, plans must be adjusted every quarter.
- Forgetting non-sales activity - reports, stand-ups, training. Budget 15-20% of working time for this.
Conclusion: a plan as an agreement, not an order
A bottom-up financial model is a tool for an honest dialogue with the sales team. When a rep sees that the plan follows from their own statistics, time resources and market constraints, they stop sabotaging it. On the contrary, they start looking for ways to improve conversion or average deal size in order to reach the ambitious level.
A rigid plan provokes sabotage. A "range" of minimum, norm and ambition gives the rep the right to make mistakes and an incentive to over-deliver.
Let's build a sales plan that doesn't trigger sabotage
G-Invest audits your funnel and pinpoints bottlenecks, trains managers and staff in the plan decomposition method, and sets up dashboards and automatic KPI control in your CRM. We implement bottom-up planning systems that the team accepts as their own.
Frequently asked questions
How do you calculate a bottom-up sales plan step by step?
Decompose revenue into deals → leads → rep actions, using historical conversions and time per deal.
What if reps understate plans during bottom-up modeling?
Use independent CRM data from past periods and cross-check against marketing.
What KPIs should you use in a bottom-up sales model?
Number of active hours, leads per day, conversion by stage, average deal size, deal velocity, funnel percentage.
How do you account for seasonality when building a sales plan?
Take seasonality coefficients over 2-3 years and multiply them by the baseline plan, or build a separate funnel for the high and low seasons.
Can you build a bottom-up model in Excel without a CRM?
Yes, but it will require manual data entry by each rep, which raises the risk of errors and manipulation.