Forecasting & Budget Allocation

A plan for next year’s budget that shows its range, its trade-offs and its assumptions.

Who it’s for

Teams heading into annual or quarterly planning who need a number their CFO will challenge, and a way to answer the challenge.

What you get

  • Forecasts with ranges, not single lines, so the plan shows the best case, the likely case and the risk.
  • Scenario planning: what happens if spend goes up, down or moves between channels.
  • Allocation under diminishing returns, using response curves from your own data.
  • Trade-off analysis. Profit, reach and risk rarely point the same way. I show the efficient frontier so the choice is explicit.
  • A planning pack your finance and marketing teams can both use.
Illustrative

A forecast is a range, and the range widens with time

Index (month 1 = 100). Solid line: history. Dashed line: forecast mean.

Sales history followed by a twelve-month forecast. The central line rises with seasonal swings and two shaded bands widen over time to show uncertainty.

View data
Index by month (month 1 = 100)
MonthSeriesValue or mean50% range90% range
1History89.5
2History91.1
3History102.2
4History110.3
5History108.6
6History114.2
7History118.9
8History114.9
9History110.7
10History102.9
11History102.8
12History100.7
13History100.7
14History108.7
15History114.6
16History119
17History129.8
18History129.6
19History136.1
20History129.8
21History123.7
22History115.7
23History116
24History110
25History111.1
26History116.9
27History127.9
28History136.6
29History144.5
30History149.1
31History155.8
32History142.7
33History135.9
34History127.7
35History126.5
36History125.5
37Forecast124121.5 to 126.5117.9 to 130.1
38Forecast130.1126.4 to 133.9121 to 139.2
39Forecast139.2134.3 to 144.1127.3 to 151.1
40Forecast149.1143.1 to 155.1134.4 to 163.8
41Forecast157.5150.4 to 164.6140.1 to 174.9
42Forecast162.3154.3 to 170.4142.7 to 181.9
43Forecast162.6153.8 to 171.3141.3 to 183.8
44Forecast158.4149.3 to 167.4136.3 to 180.5
45Forecast151.1141.9 to 160.3128.7 to 173.5
46Forecast143133.8 to 152.1120.7 to 165.3
47Forecast136.5127.3 to 145.7114.2 to 158.8
48Forecast133.7124.3 to 143.1110.9 to 156.6
Illustrative: a forecast shown as a range that widens with time, not a single line. Illustrative data. Built to show how the method works, not a client result.
Illustrative

Trade-offs are choices, not calculations

Each dot is a possible budget allocation. Hover over a grey dot to see why it loses.

A scatter plot with a curved frontier. Points under the curve are inferior allocations. Moving along the curve trades profit for reach.

View data
Allocations: profit and new-customer reach (index)
AllocationProfitReach
Balanced choice (on the curve)96105.5
Profit-first choice (on the curve)12361.8
Curve point 160134.4
Curve point 262133.2
Curve point 364132.1
Curve point 466130.9
Curve point 568129.6
Curve point 670128.3
Curve point 772126.9
Curve point 874125.5
Curve point 976124
Curve point 1078122.4
Curve point 1180120.8
Curve point 1282119.2
Curve point 1384117.4
Curve point 1486115.6
Curve point 1588113.8
Curve point 1690111.8
Curve point 1792109.8
Curve point 1894107.7
Curve point 1996105.5
Curve point 2098103.2
Curve point 21100100.8
Curve point 2210298.3
Curve point 2310495.6
Curve point 2410692.9
Curve point 2510890
Curve point 2611087
Curve point 2711283.7
Curve point 2811480.3
Curve point 2911676.7
Curve point 3011872.9
Curve point 3112068.7
Curve point 3212264.2
Curve point 3312459.3
Curve point 3412653.9
Curve point 3512847.7
Curve point 3613040.4
Beaten allocation 18180.3
Beaten allocation 2102.363
Beaten allocation 394.879.1
Beaten allocation 463.8104.1
Beaten allocation 562.4101.5
Beaten allocation 664.585.6
Beaten allocation 787.6101.9
Beaten allocation 86889.9
Beaten allocation 9100.893.1
Beaten allocation 1097.577.9
Beaten allocation 11123.538.6
Beaten allocation 12115.855.2
Beaten allocation 1369.484.8
Beaten allocation 1480.1107.4
Beaten allocation 1571.7103.2
Beaten allocation 16101.573.4
Beaten allocation 1795.667.9
Beaten allocation 1863.990.9
Beaten allocation 19104.272.6
Beaten allocation 2080.498
Beaten allocation 2189.580.8
Beaten allocation 22111.671.8
Beaten allocation 2375.9100.4
Beaten allocation 2494.197.7
Beaten allocation 25107.465
Beaten allocation 26123.739.6
Beaten allocation 2787.299.6
Beaten allocation 2869.9100.3
Beaten allocation 2962.5111.7
Beaten allocation 30109.770.7
Beaten allocation 31116.954.3
Beaten allocation 32105.276.7
Beaten allocation 3397.779.8
Beaten allocation 34114.673.9
Beaten allocation 3590.893.1
Beaten allocation 3663.9112.5
Beaten allocation 37102.193
Beaten allocation 38113.458.1
Beaten allocation 3985.197.9
Beaten allocation 4061.5103.1
Beaten allocation 4170.984.1
Beaten allocation 4263.8115.5
Beaten allocation 4368.490.7
Beaten allocation 4485.4105.4
Beaten allocation 4565.2100.9
Beaten allocation 4695.796.4
Beaten allocation 47113.373.9
Beaten allocation 4878.192.6
Beaten allocation 4983.3107.6
Beaten allocation 50122.342.6
Beaten allocation 5171.588.6
Beaten allocation 5275.297.2
Beaten allocation 5398.372.7
Beaten allocation 5460.3101.8
Beaten allocation 558494.7
Beaten allocation 5612254.5
Beaten allocation 5793.589.1
Beaten allocation 5810461
Beaten allocation 59118.563.1
Beaten allocation 60116.866.4
Beaten allocation 6185.587.3
Beaten allocation 6266.7108.1
Beaten allocation 636484.8
Beaten allocation 6473.684.7
Beaten allocation 6582.175.9
Beaten allocation 666090
Beaten allocation 6766.696.6
Beaten allocation 6861.7121.2
Beaten allocation 6999.967.5
Beaten allocation 7076.490.9
Illustrative: every allocation below the curve is beaten by one on it. Choosing a point on the curve is a decision about trade-offs, not a calculation. Illustrative data. Built to show how the method works, not a client result.

How it works

  1. Set the objectives and constraints (profit, growth, cash, risk).
  2. Build the forecast from your history and drivers.
  3. Test scenarios and allocations.
  4. Present the trade-offs and agree the plan.
  5. Track against it and update as evidence arrives.

What I need from you

Sales and spend history, margin and cost data, and the targets and constraints the plan has to meet.

Evidence you’ll reach

Level 2, modelled evidence. Forecasts are only as good as the evidence behind their inputs, which is why they are best paired with an MMM or experiments.

Evidence levelLevel 2See the Evidence Ladder
Can you forecast demand shocks or new product launches?

Not precisely, and I won’t pretend to. I model scenarios and ranges so you can see what you’d do under each.

Do you use my existing spreadsheets?

Where they are sound, yes. I’d rather build on what your team already trusts.