A few decades ago everything seemed so straightforward. When it came to planning and controlling businesses annual budgets were the only show in town. Managing performance simply consisted of comparing financial outcomes to these budgets on a periodic basis and using variance analysis to understand where and how deviations in performance had come about, to help the business ‘get back on track’.
In this simple world of plan, actual and variance, simple presentational devices such as tables displaying columns of numbers sufficed. But things have changed since then:
• Budgets have declined in status, falling into disrepute and disuse. This is partly the result of an increasing recognition that in a dynamic and unpredictable world the cost of building and managing a traditional annual budgeting system vastly outweighs the benefits. Partly it results from the work of organisations like the Beyond Budgeting Round Table (BBRT) in convincing people that they are an unnecessary evil, responsible for promoting dysfunctional and unproductive behaviour as well as wasting resources doing the wrong things.
• An industry has grown up around measurement systems, usually promoting a richer and more extensive range of measures of business performance. The balanced scorecard is the most famous example, but few businesses feel they can manage without key performance indicators (KPIs) or ‘dashboards’.
• The amount and quantity of data available to analysts has increased enormously over recent years; a trend to which there is no visible end.
• Sophisticated data analysis, dissemination and presentation tools capable of exploiting the potential of super abundant data are now easily accessible.
• Insightful, coherent analysis needs to be delivered and assimilated more quickly than ever before. The bandwidth of consumers of performance information is physiologically fixed and demands on it have increased enormously. As a result, the time available for the careful consideration and weighing up of evidence has collapsed.
So the demands and the potential have increased but there is a large gap between what is possible and what we see on the ground. This is partly because the capability of the tools available has outstripped the time needed for analysts’ to master them. The result of this is that Excel and the rest of the Office suite of products continues to be the tool of choice for routine reporting, even where significant investments have been made in business intelligence (BI) software. It also because there is an abundance of advice on what to measure but there is relatively little guidance given on how to analyse the results and communicate them in an effective way.
Also, we need to recognise that performance reporting is part of a social process; it informs decisions which are made collectively by boards and business teams. While there is now an abundance of BI software that helps individual managers personally explore and make sense of data on line, these capabilities are ill-suited to the task of providing groups of decision makers with the information they need in the form in which they need it.
To help them collectively agree what needs to be done they need clearly presented and concise analyses to ensure that they all receive the same story about performance message at the same time – because if they do not there is little chance of them quickly agreeing what needs to be done.
Approaches and remedies
So software isn’t the solution to these problems, although it will certainly be part of it.
This is the premise upon which the author made his presentation to the London FP&A board last month. It will form the basis of a forthcoming book ‘Present Sense’ – a companion volume to his book on business forecasting ‘Future Ready’ published in 2012 – along with his remedies.
These remedies are divided into two; the first set comprise a series of simple and pragmatic approaches to help practitioners make sense of performance data and include:
1. Using rolling measures like moving annual totals (MAT) to provide decision makers with an accessible picture of trends in organisational performance that can offset the blinkered focus on the most recent period.
2. Using simple statistical filters like control charts to reduce the risk of reacting to ‘noise’ and help find the needle in the haystack of data that most businesses now sit on.
3. Using tracking signals to reduce the reliance on arbitrary ‘point in time’ targeting and the risk of over interpreting variances.
These second set of remedies are six design principles practitioners better present and communicate insights to decision makers, particularly in the form of graphics. Effective communication needs to be:
1. Targeted: taking account of the role, purpose and capabilities of the target audience.
2. Attenuated: eliminating as much irrelevant detail as possible, so as not to distract the brain.
3. Amplified: emphasising the important stuff that remains.
4. Contextualised: giving information meaning by adding contextual information in the form of text and so on.
5. Condensed: limiting the amount of space that is used for the message and thereby employing it to maximum effect.
6. Organised: presenting the information on paper or on screen in such a way that makes it easy for the audience to navigate and interpret.
Information about the London FP&A Board may be accessed here.
The London FP&A Board is a collection of senior financial planning and analysis experts, with years of experience collectively between them, which seeks to advance the profession. It operates on a non-profit basis and is based in London, UK, with chapters around the world contributing to case studies, training tips, best practice recommendations, networking events and other initiatives designed to help the advance FP&A.
The London FP&A Board is intended to support the best practices and to communicate latest trends in Financial Planning and Analysis. Members meet regularly throughout the year, have a lively FP&A Club LinkedIn Group (1700+members globally) and actively develop social media and the community blog.
A US study, based on the quick service restaurant chain Chick-fil-A, offers conflicting evidence on whether a TMS is the best option when upgrading from Excel-based forecasting.
With four hikes since late 2015 - three of them in the past six months - US interest rates are moving higher in line with a strengthening economy. However, for many American corporates the trend has raised concerns over their working capital management.
Uncertainty surrounding the UK’s exit terms from the EU is preventing businesses from being able to accurately hedge foreign-exchange risks.
Why a career in sales proposal writing should be a no-brainer for bright young finance graduates.