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.
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
| Month | Series | Value or mean | 50% range | 90% range |
|---|---|---|---|---|
| 1 | History | 89.5 | ||
| 2 | History | 91.1 | ||
| 3 | History | 102.2 | ||
| 4 | History | 110.3 | ||
| 5 | History | 108.6 | ||
| 6 | History | 114.2 | ||
| 7 | History | 118.9 | ||
| 8 | History | 114.9 | ||
| 9 | History | 110.7 | ||
| 10 | History | 102.9 | ||
| 11 | History | 102.8 | ||
| 12 | History | 100.7 | ||
| 13 | History | 100.7 | ||
| 14 | History | 108.7 | ||
| 15 | History | 114.6 | ||
| 16 | History | 119 | ||
| 17 | History | 129.8 | ||
| 18 | History | 129.6 | ||
| 19 | History | 136.1 | ||
| 20 | History | 129.8 | ||
| 21 | History | 123.7 | ||
| 22 | History | 115.7 | ||
| 23 | History | 116 | ||
| 24 | History | 110 | ||
| 25 | History | 111.1 | ||
| 26 | History | 116.9 | ||
| 27 | History | 127.9 | ||
| 28 | History | 136.6 | ||
| 29 | History | 144.5 | ||
| 30 | History | 149.1 | ||
| 31 | History | 155.8 | ||
| 32 | History | 142.7 | ||
| 33 | History | 135.9 | ||
| 34 | History | 127.7 | ||
| 35 | History | 126.5 | ||
| 36 | History | 125.5 | ||
| 37 | Forecast | 124 | 121.5 to 126.5 | 117.9 to 130.1 |
| 38 | Forecast | 130.1 | 126.4 to 133.9 | 121 to 139.2 |
| 39 | Forecast | 139.2 | 134.3 to 144.1 | 127.3 to 151.1 |
| 40 | Forecast | 149.1 | 143.1 to 155.1 | 134.4 to 163.8 |
| 41 | Forecast | 157.5 | 150.4 to 164.6 | 140.1 to 174.9 |
| 42 | Forecast | 162.3 | 154.3 to 170.4 | 142.7 to 181.9 |
| 43 | Forecast | 162.6 | 153.8 to 171.3 | 141.3 to 183.8 |
| 44 | Forecast | 158.4 | 149.3 to 167.4 | 136.3 to 180.5 |
| 45 | Forecast | 151.1 | 141.9 to 160.3 | 128.7 to 173.5 |
| 46 | Forecast | 143 | 133.8 to 152.1 | 120.7 to 165.3 |
| 47 | Forecast | 136.5 | 127.3 to 145.7 | 114.2 to 158.8 |
| 48 | Forecast | 133.7 | 124.3 to 143.1 | 110.9 to 156.6 |
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
| Allocation | Profit | Reach |
|---|---|---|
| Balanced choice (on the curve) | 96 | 105.5 |
| Profit-first choice (on the curve) | 123 | 61.8 |
| Curve point 1 | 60 | 134.4 |
| Curve point 2 | 62 | 133.2 |
| Curve point 3 | 64 | 132.1 |
| Curve point 4 | 66 | 130.9 |
| Curve point 5 | 68 | 129.6 |
| Curve point 6 | 70 | 128.3 |
| Curve point 7 | 72 | 126.9 |
| Curve point 8 | 74 | 125.5 |
| Curve point 9 | 76 | 124 |
| Curve point 10 | 78 | 122.4 |
| Curve point 11 | 80 | 120.8 |
| Curve point 12 | 82 | 119.2 |
| Curve point 13 | 84 | 117.4 |
| Curve point 14 | 86 | 115.6 |
| Curve point 15 | 88 | 113.8 |
| Curve point 16 | 90 | 111.8 |
| Curve point 17 | 92 | 109.8 |
| Curve point 18 | 94 | 107.7 |
| Curve point 19 | 96 | 105.5 |
| Curve point 20 | 98 | 103.2 |
| Curve point 21 | 100 | 100.8 |
| Curve point 22 | 102 | 98.3 |
| Curve point 23 | 104 | 95.6 |
| Curve point 24 | 106 | 92.9 |
| Curve point 25 | 108 | 90 |
| Curve point 26 | 110 | 87 |
| Curve point 27 | 112 | 83.7 |
| Curve point 28 | 114 | 80.3 |
| Curve point 29 | 116 | 76.7 |
| Curve point 30 | 118 | 72.9 |
| Curve point 31 | 120 | 68.7 |
| Curve point 32 | 122 | 64.2 |
| Curve point 33 | 124 | 59.3 |
| Curve point 34 | 126 | 53.9 |
| Curve point 35 | 128 | 47.7 |
| Curve point 36 | 130 | 40.4 |
| Beaten allocation 1 | 81 | 80.3 |
| Beaten allocation 2 | 102.3 | 63 |
| Beaten allocation 3 | 94.8 | 79.1 |
| Beaten allocation 4 | 63.8 | 104.1 |
| Beaten allocation 5 | 62.4 | 101.5 |
| Beaten allocation 6 | 64.5 | 85.6 |
| Beaten allocation 7 | 87.6 | 101.9 |
| Beaten allocation 8 | 68 | 89.9 |
| Beaten allocation 9 | 100.8 | 93.1 |
| Beaten allocation 10 | 97.5 | 77.9 |
| Beaten allocation 11 | 123.5 | 38.6 |
| Beaten allocation 12 | 115.8 | 55.2 |
| Beaten allocation 13 | 69.4 | 84.8 |
| Beaten allocation 14 | 80.1 | 107.4 |
| Beaten allocation 15 | 71.7 | 103.2 |
| Beaten allocation 16 | 101.5 | 73.4 |
| Beaten allocation 17 | 95.6 | 67.9 |
| Beaten allocation 18 | 63.9 | 90.9 |
| Beaten allocation 19 | 104.2 | 72.6 |
| Beaten allocation 20 | 80.4 | 98 |
| Beaten allocation 21 | 89.5 | 80.8 |
| Beaten allocation 22 | 111.6 | 71.8 |
| Beaten allocation 23 | 75.9 | 100.4 |
| Beaten allocation 24 | 94.1 | 97.7 |
| Beaten allocation 25 | 107.4 | 65 |
| Beaten allocation 26 | 123.7 | 39.6 |
| Beaten allocation 27 | 87.2 | 99.6 |
| Beaten allocation 28 | 69.9 | 100.3 |
| Beaten allocation 29 | 62.5 | 111.7 |
| Beaten allocation 30 | 109.7 | 70.7 |
| Beaten allocation 31 | 116.9 | 54.3 |
| Beaten allocation 32 | 105.2 | 76.7 |
| Beaten allocation 33 | 97.7 | 79.8 |
| Beaten allocation 34 | 114.6 | 73.9 |
| Beaten allocation 35 | 90.8 | 93.1 |
| Beaten allocation 36 | 63.9 | 112.5 |
| Beaten allocation 37 | 102.1 | 93 |
| Beaten allocation 38 | 113.4 | 58.1 |
| Beaten allocation 39 | 85.1 | 97.9 |
| Beaten allocation 40 | 61.5 | 103.1 |
| Beaten allocation 41 | 70.9 | 84.1 |
| Beaten allocation 42 | 63.8 | 115.5 |
| Beaten allocation 43 | 68.4 | 90.7 |
| Beaten allocation 44 | 85.4 | 105.4 |
| Beaten allocation 45 | 65.2 | 100.9 |
| Beaten allocation 46 | 95.7 | 96.4 |
| Beaten allocation 47 | 113.3 | 73.9 |
| Beaten allocation 48 | 78.1 | 92.6 |
| Beaten allocation 49 | 83.3 | 107.6 |
| Beaten allocation 50 | 122.3 | 42.6 |
| Beaten allocation 51 | 71.5 | 88.6 |
| Beaten allocation 52 | 75.2 | 97.2 |
| Beaten allocation 53 | 98.3 | 72.7 |
| Beaten allocation 54 | 60.3 | 101.8 |
| Beaten allocation 55 | 84 | 94.7 |
| Beaten allocation 56 | 122 | 54.5 |
| Beaten allocation 57 | 93.5 | 89.1 |
| Beaten allocation 58 | 104 | 61 |
| Beaten allocation 59 | 118.5 | 63.1 |
| Beaten allocation 60 | 116.8 | 66.4 |
| Beaten allocation 61 | 85.5 | 87.3 |
| Beaten allocation 62 | 66.7 | 108.1 |
| Beaten allocation 63 | 64 | 84.8 |
| Beaten allocation 64 | 73.6 | 84.7 |
| Beaten allocation 65 | 82.1 | 75.9 |
| Beaten allocation 66 | 60 | 90 |
| Beaten allocation 67 | 66.6 | 96.6 |
| Beaten allocation 68 | 61.7 | 121.2 |
| Beaten allocation 69 | 99.9 | 67.5 |
| Beaten allocation 70 | 76.4 | 90.9 |
How it works
- Set the objectives and constraints (profit, growth, cash, risk).
- Build the forecast from your history and drivers.
- Test scenarios and allocations.
- Present the trade-offs and agree the plan.
- 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.
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.