The situation
A food producer reports April revenue of US$1,240K. Against budget it is 4.6% short. Against April of last year it is 12.1% down, and the management meeting opens with the word decline.
Four comparisons, four readings
Nothing in the table is wrong. Each comparison answers a different question, and only some of them are worth management’s time.
Last April had one more selling week. Per week, sales are up 9.9%. The second quarter of last year is a poor base too: the company had run out of stock in March, and customers placed a month of accumulated orders in April. The last quarter without that distortion was two years ago.
| Compared with | Base | Variance | What it tells management |
|---|---|---|---|
| April budget | $1,300K | −4.6% | The plan was missed. |
| April last year | $1,410K | −12.1% | Looks alarming, but last April had five selling weeks and this one had four. |
| April last year, per week | $282K vs. $310K | +9.9% | On equal weeks, the business is growing. |
| Average month, Q2 two years ago | $1,180K | +5.1% | Against the last normal quarter, before stockouts distorted orders, growth is modest. |
Beyond budget and last year
Budget and prior year are the starting point, not the whole answer. Every business has other bases that explain a month better; which ones depends on its history, its season and its market.
Choosing them is part of the analysis, and it is done with management, not for it.
Two rules that keep it honest
Flexible comparison is not permission to pick the flattering base. Budget and prior year stay in every review, so the thread is never lost. Any additional base comes with one sentence saying why it was chosen.
And the comparison must be made on equal terms: per week or per working day when the calendar differs, and with new or discontinued products shown separately when the base is far back.
The management questionWhich comparison would actually change what we decide?