Back to Quick reads

Analysis

Compared to what?

April against budget and April against last April are habits, not answers. The base of a comparison is an analytical choice, and the wrong one sends management after the wrong problem.

Illustrative case, not a client.

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.

April revenue of US$1,240K against four different bases
Compared withBaseVarianceWhat 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?

Back to Quick reads

Want to apply this thinking to your business?

If the numbers are available but they are not enough to decide, we can start with the questions that matter most.

A 20-minute conversation: we understand your context, answer your questions and tell you whether the service fits. No financial information needed.

Send a message Book 20 min