Back to all posts
FP&A
November 29, 2023

Coping with market uncertainty Part 2

The second post in this series: We look at how different data transformations can help companies face market uncertainty with greater confidence

Metapraxis writes on design and business analysis

In times of change and uncertainty, there can be a temptation for executives to discard those practices and processes in business management which assume business continuity. While such techniques are aimed at reducing uncertainty on the assumption of "business as usual", that is something that many sectors of the economy no longer enjoy, even at the best of times. However, a focus on continuity and assurance is just as useful in difficult circumstances as it is during easier times.

Confidence, both internally and externally, has a big part to play in driving business success. But confidence can only come from knowledge, and routine gathering of insight on the performance of the business. Such practices include targeting and monitoring the performance of the business using monthly budgets, quarterly reforecasts and annual plans. But the conventional means of applying these are not sufficient for modern business management. In order to drive an effective strategic response, managers must modify their approach to creating and using them.

One area where this may be particularly true is in the use of visualization, as poor visualization can be hugely misleading. An example of this might be a simple line graph – choice of scales on the y axis can make the difference between a gradual trend and a cataclysmic change. A less obvious, but no less important instance is the comparison of budget, forecast and actuals. In the chart below, it’s clear that sales have fallen short of budget, but the difference appears small, is getting smaller, and perhaps has even been closed in the most recent month.

Order book graphic 1

However, if we calculate a cumulative variance, and represent that as a continuous trend, rather than a serious of monthly reports, the underlying situation is made clearer:

Order book graphic 2

In this case, the management forecast suggests that the current shortfall will be made up by the year end, but this can only be done by closing and delivering the sales in the weighted pipeline, and the additional work to win. This should prompt the identification of actions to make sure that the actual results to the end of the year meet the results that are currently forecast.

This data transformation may seem simple – elementary, even – but it is surprisingly uncommon, particularly in large organisations, where budget, forecast and results information may involve collecting data from many separate systems. However, making the investment necessary to bring these together is worthwhile, as it offers real clarity on the health of a business’s finances. It is one example of a slightly unconventional approach that can yield very large improvements in the quality of insight.

What’s a Rich Text element?

The rich text element allows you to create and format headings, paragraphs, blockquotes, images, and video all in one place instead of having to add and format them individually. Just double-click and easily create content.

Static and dynamic content editing

A rich text element can be used with static or dynamic content. For static content, just drop it into any page and begin editing. For dynamic content, add a rich text field to any collection and then connect a rich text element to that field in the settings panel. Voila!

How to customize formatting for each rich text

Headings, paragraphs, blockquotes, figures, images, and figure captions can all be styled after a class is added to the rich text element using the "When inside of" nested selector system.

  • ffff
  • ffff
Metapraxis
Company news and insights
We have been working with finance teams for nearly 40 years. We've built up an in-depth understanding of finance needs, and all of that experience has been embedded in our Empower product.
Popular POst
FP&A
Coping with market uncertainty Part 2
Follow us

Latest Posts

Navigating Challenges in Construction
eBooks
Navigating Challenges in Construction
Explore how the construction industry confronts economic volatility, technological integration, and strategic decisions. Uncover the effects of economic downturns and policy shifts, delve into the significance of digital transformation, and grasp strategies for bolstering resilience through innovation.
Read more
Navigating a 2024 Tech Investment Slowdown
FP&A
Navigating a 2024 Tech Investment Slowdown
Managing Internal Tech Investment Slowdowns in 2024 with savvy finance strategies: streamline operations, rethink ROI, and set dynamic objectives for a resilient financial approach.
Read more
What does 2024 look like for FP&A teams?
FP&A
What does 2024 look like for FP&A teams?
2024 poses unique challenges for FP&A teams amidst a shifting financial landscape. Here we delve into the anticipated obstacles, developmental prospects, and socio-economic trends that will shape the course of businesses in the upcoming year.
Read more