Why this matters
A budget set as last year plus a little cannot say what it buys, so it cannot be defended when finance asks or cut sensibly when the year goes badly. Working back from revenue turns the budget into a statement about the FunnelModel of the customer journey stages.: how many leads, at what cost, to produce how many deals. The guide to lifetime value and acquisition cost sets the ceiling on what a customer is worth acquiring; the budget calculator walkthrough for lead generation turns a lead count and a cost per lead into a total. Here the work is in the segments and the limits.
The firm and its inherited budget
Routewise Telematics is an invented provider of vehicle tracking software, sold by annual subscription to small and mid-sized fleets. Sales and finance have set next year's new-business target, and marketing must say whether last year's budget, carried forward with a small increase, can deliver it.
Routewise Telematics: targets, funnel rates and channels
New annual recurring revenue target: £1,200,000, of which small fleets £400,000 and mid-sized fleets £800,000.
| Measure | Small fleets | Mid-sized fleets |
|---|---|---|
| First-year contract value | £6,000 | £30,000 |
| Lead to opportunity | 12% | 20% |
| Opportunity to won | 30% | 20% |
| Typical sales cycle | Two months | Six months |
| Gross margin | 70% | 75% |
| Annual churn | 20% | 10% |
| Sales cost per won deal | £1,200 | £6,000 |
Finance rule: total acquisition cost, sales included, must be repaid from gross margin within twelve months, and three-year customer value must be at least three times acquisition cost.
| Channel | Segment | Recent cost per lead | Leads available at that cost in a year |
|---|---|---|---|
| Google search | Small | £65 | 1,200 |
| Software review sites | Small | £90 | 800 |
| Mid-sized | £240 | 400 | |
| Trade shows | Mid-sized | £400 | 150 |
| Partner webinars | Mid-sized | £150 | 125 |
Last year's budget: £220,000. Proposed for next year: £231,000.
From revenue target to pipeline coverage
Work each segment separately, because the rates differ too much to blend. Divide the target by contract value for deals, by the win rate for opportunities and by the lead-to-opportunity rate for leads, using stages defined as in the guide to lead stages. Pipeline coverage, the value of open opportunities against the target, is simply the inverse of the win rate, so a segment that wins less often needs more coverage. Cycle length decides when that pipeline must exist: a six-month cycle means the leads for next spring's deals are bought this autumn.
Then set the ceiling. Customer value (LTVTotal value a customer brings over time.) is built on gross margin over a fixed window with the segment's own churn, not on contract revenue, and the payback rule from the retention and payback guide caps acquisition cost (CACCost to acquire one new customer.) where cash is the constraint.
Task
- Work back from each segment's target to deals, opportunities, leads and pipeline coverage.
- Calculate three-year customer value on gross margin for each segment.
- Set the maximum acquisition cost from the finance rule, then the marketing allowance per deal and per lead.
- Price the leads by channel against those limits and size the budget with a reserve.
- Test how sensitive the budget is to the weakest rate.
- List the assumptions sales and finance must agree before the year starts.
Worked answer
Routewise Telematics: from target to budget
Small fleets: £400,000 ÷ £6,000 ≈ 67 deals; ÷ 0.30 ≈ 224 opportunities; ÷ 0.12 ≈ 1,867 leads. Coverage: 224 × £6,000 = £1,344,000, about 3.4 times the target. Mid-sized: £800,000 ÷ £30,000 ≈ 27 deals; ÷ 0.20 = 135 opportunities; ÷ 0.20 = 675 leads. Coverage: 135 × £30,000 = £4,050,000, about 5.1 times the target.
Three-year value on gross margin. Small: £4,200 + £3,360 + £2,688 = £10,248. Mid-sized: £22,500 + £20,250 + £18,225 = £60,975.
Maximum acquisition cost, the lower of first-year margin and a third of three-year value: small £3,416; mid-sized £20,325. Less sales cost: marketing may spend £2,216 per small deal and £14,325 per mid-sized deal. Per lead: small £2,216 × (0.12 × 0.30) ≈ £80; mid-sized £14,325 × (0.20 × 0.20) ≈ £573.
Budget. Small: search 1,200 × £65 = £78,000; review sites 667 × £90 = £60,030. Mid-sized: LinkedIn 400 × £240 = £96,000; trade shows 150 × £400 = £60,000; partner webinars 125 × £150 = £18,750. Total £312,780; with a 10% reserve, about £344,000. The proposed £231,000 funds about two-thirds of it.
Sensitivity: a mid-sized win rate of 19% instead of 20% needs 143 opportunities and 715 leads, 40 more, about £10,400 at the segment's blended cost per lead.
What the numbers say. The inherited budget cannot deliver the target at current rates; either the budget rises to roughly half as much again as last year, or the target falls, or a rate improves, and sales and finance should choose knowingly. Mid-sized fleets carry the plan: every channel there sits far below its ceiling, so this is where extra money is safest. Small fleets are tight. Search fits under the per-lead ceiling, but review sites cost more per lead than a small-fleet customer can repay; cap their bids near the ceiling and accept fewer leads, or test whether their leads qualify at a better rate before paying full price.
Timing. Mid-sized deals take half a year, so the first half of next year's mid-sized revenue depends on leads bought in the coming months. The budget should start now, not in January.
Assumptions to agree in writing. Contract value and win rate by segment, lead-to-opportunity rate measured over a full cycle, stage definitions, churn and gross margin, sales cost per deal, the payback rule and the date the plan will be re-forecast if a rate drifts. A rate nobody signed is a rate nobody owns when it misses.
Common mistakes
- Blending segments. One average rate fits neither segment and misprices both.
- Customer value on contract revenue. Margin and churn decide what a customer is worth.
- Ignoring sales cost. Marketing's allowance is what remains after the sales effort per deal.
- Starting spend with the revenue period. Long cycles need the pipeline months earlier.
Next, take the pipeline economics checkpoint or revisit the intermediate business-to-business level.
