Skip to main content
Home
The Online Resource for Modern FP&A Professionals
Please register to receive the latest FP&A news, updates and tips Login

Main menu

  • Home
  • FP&A Insights
    • FP&A Trends Digest
    • FP&A Trends Research
    • FP&A Trends Insight Paper
    • FP&A Trends Survey
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI/ML Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Tools
    • FP&A Trends Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
image
Achieving Forecasting Consistency within an Organisation
August 1, 2023

By Nick Arzenton, Divisional Finance Director CS&O – IBO at Orange Business Services

FP&A Tags
Modelling and Forecasting
Forecasting Quality

Nick-Arzenton-Forecasting-Consistency-Main

Why Do We Struggle with Forecasting Consistency?

Recent events and geopolitical situations demonstrate how difficult it is to produce reliable forecasts. It is often a daunting task which involves a large amount of data, technical skills, tools and a bit of luck. Plenty of literature offer guidelines on the subject. Another less known but not less significant challenge is forecasting consistency across different units within the same organisation. For example, it does not necessarily mean that Operations are producing a cost forecast consistent with the revenue profile just because the Sales department has produced a good revenue forecast. Consequently, it can be challenging when revenues and costs do not necessarily follow the same patterns for whatever reason.

How can we ensure forecasts produced by different business units are combined into one single consistent and comprehensive exercise? Even within the same organisation, different units can approach the same topic differently: consider inflation's impact or exchange rates. Therefore, it is pivotal to establish a framework for a consistent approach and strive to provide as accurate forecasts as possible. We can summarise this approach using the quote 'consistency over accuracy'. In reality, it is more important that one specific business area (for instance, headcount) is in line with the rest of the forecasting exercise (revenues and costs) rather than aiming to be as accurate as possible but in isolation.


Aligning Cost Projections with Revenue Forecasts

Let's dive into a specific case, highlighting the forecast inconsistency. A 'cost-only' Operational unit had to produce forecasts in line with a defined revenue profile. However, revenue forecasts have already been produced by the Sales departments, agreed upon, and loaded into corporate tools. For the 'cost-only' Operational unit, these represent an input. Therefore, the task becomes how to ensure the forecasted costs align with these revenue profiles. Indeed, it is not as straightforward exercise as it might have appeared due to operational complexities around specific customer contracts, which may differ substantially. This is true, especially for large customers, who tend to require a more tailored customer experience.

Costs incurred by the specific Operational unit are mainly represented by labour and driven by the headcount organised in many technical departments. Fundamentally, the costs are related to six main processes. Employees are spread internationally and in different roles and levels, thus allowing an almost infinite number of different combinations and costs. Hence, understanding the evolution of the headcount over time according to the revenue profile evolution becomes crucial. Given the highly technical nature of the roles, the headcount number is strictly linked to the number of activities completed. These can be as follows:

  • installations,
  • network configurations,
  • network modifications,
  • additions, and so on.

The problem then becomes how to forecast such activities, after which the headcount more or less follows.


What Were the Previous Forecasting Method and Related Issues?
 

Nick-Arzenton-Forecasting-Consistency-1-Cropped

Figure 1. Source: Nick Arzenton's presentation at the FP&A Trends Webinar, May 2023

The Operations department received extensively detailed revenue files with granularity by 1000+ large or medium customers. A detailed manual analysis was conducted, breaking down the revenue by individual customer, services, and nature. The organisational unit drew a conclusion around the evolution of the activities for that specific account.

What was the bottleneck? This exercise was highly complicated by the data volumes, which had to be handled manually. Revenue streams, which produced activity variations, had to be identified. For example, discounts had to be excluded from forecasts. Also, different services required different levels of activities and changes in the product mix. In turn, it could provide material changes in activity levels.

After consolidating these detailed analyses, the Operations could understand the whole picture. The issues with this method were as follows:

  • First and foremost, this truly bottom-up exercise didn't necessarily guarantee an accurate picture, as the overall accuracy was relatively unsatisfactory.
  • Also, the method was not efficient. It was so manually intensive and required a vast amount of resources, more or less dedicated to the exercise for a long time.
  • Another key challenge was to agree with the Sales department on the required activities under the pressure of deadlines.
  • There was no top-down view that could validate and confirm the results of the bottom-up exercise.


The New Forecasting Method
 

Nick-Arzenton-Forecasting-Consistency-2-Cropped

Figure 2. Source: Nick Arzenton's presentation at the FP&A Trends Webinar, May 2023

Identifying the historical relationship between revenues and activities over time was key for the new forecasting method. The Operations collected the same detailed revenue files and activity levels for the last five years to try a new approach. The team analysed the trends over these periods for each of the six main processes without necessarily going into the details regarding the customer.

The second step in the new forecasting method was to identify patterns. Indeed, these emerged, and valuable discussions took place in order to understand trends and the underlying business reasons accounting for these trends. Also, the organisation produced documentation to formally agree on conclusions between the Sales and Operations departments. This aspect was another key consideration since work on the historical data could take place before the need for any budgets or forecasts.

The historical analysis came in handy when the next forecast was needed. The newly identified relationships could be quickly deployed to establish the activity evolution, from which to derive the headcount needs. The relationships are more 'high level' than before, while customer information is analysed only in very specific cases, not as a matter of process. If new elements, such as a new product, come into play and disrupt the model, they can be quickly absorbed into the method with some minor tweaks.


Benefits and Recommendations

Such a model offers numerous substantial advantages. Thanks to historical relationships, time-consuming analyses are no longer necessary. Other benefits are the increased forecasting speed and the impact on efficiency and costs. Another important aspect is that the model was developed together by Sales and Operations, thus negating the need for lengthy discussions to agree upon forecasts. Finally, the studies yielded another bonus – an increase in business knowledge.

Recommendations for the practical application of this forecasting method include the following:

  • Availability of good historical data

We are all familiar with the data quality issues. Also, we need to remember that if we perform a historical analysis like this one, additional challenges may arise as data capturing might have changed over time. It will always be necessary to perform manual adjustments and corrections.

  • Knowledge and collective operational experience

We need both to understand trends and evolutions, as well as to establish meaningful relationships.

  • Management buy-in

It is pivotal to obtain top management support. While this forecasting method, supported by solid historical analysis, might appear as a 'leap in the unknown', some departments may be uncomfortable with its implementation because large amounts of details are no longer analysed nor considered.


Conclusion

The method has been initially developed in Excel. A new tool is being considered. AI has been utilised, but for the time being, only at an embryonic level, mainly to provide some specific outputs related to seasonality forecasting. The new method was no silver bullet on the topic of forecasting. However, it was a great practical help to ease an extremely complex exercise, allowing the organisation to focus on its core mission.


---

To watch the webinar recording where Nick shared his insights, please follow this link.

The full text is available for registered users. Please register to view the rest of the article.
  • Log In
  • or
  • Register

Related articles

Microsoft Central Forecast Case Study
Microsoft Central Forecast Case Study
May 18, 2023

In this video, Charles Peter, Finance Director Global sales, marketing and operations at Microsoft, shares his experience...

Read more
forecast-system-evaluation
Forecasting System Evaluation
November 1, 2022

So, as a business professional, how can you evaluate the process(es) put in place in your...

Read more
Evolution of the Forecasting Process : Moving from Traditional to Rolling
Evolution of the Forecasting Process: Moving from Traditional to Rolling
March 30, 2022

In this video, we learn how A.P. Moller – Maersk Group made the transition from traditional...

Read more
forecast
Caution: Forecast Accuracy is Seasonal Too!
December 13, 2021

The benefits of measuring seasonality of accuracy are that users can plan high/low scenarios for each...

Read more
+

Subscribe to
FP&A Trends Digest

We will regularly update you on the latest trends and developments in FP&A. Take the opportunity to have articles written by finance thought leaders delivered directly to your inbox; watch compelling webinars; connect with like-minded professionals; and become a part of our global community.

Create new account

image

Event Calendar

Pagination

  • Previous
  • May 2025
  • Next
Su Mo Tu We Th Fr Sa
27
28
29
30
1
2
3
 
 
 
 
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Transforming FP&A Together: Human & AI Synergy
 
18
19
20
21
22
23
24
Moving from FP&A to Extended Planning and Analysis (xP&A)
 
Five Critical Roles for Building a World-Class FP&A Team
 
25
26
27
28
29
30
31
FP&A Business Partnering and AI: A New Era
 
All events for the year

Future Meetings

The Face-to-Face Amsterdam FP&A Board
The Face-to-Face Amsterdam FP&A Board Transforming FP&A Together: Human & AI Synergy

May 15, 2025

The Face-to-Face Milan FP&A Board
The Face-to-Face Milan FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)

May 20, 2025

The Face-to-Face Frankfurt FP&A Board
The Face-to-Face Frankfurt FP&A Board Five Critical Roles for Building a World-Class FP&A Team

May 22, 2025

BPAI
The FP&A Trends Webinar FP&A Business Partnering and AI: A New Era

May 28, 2025

The Face-to-Face London FP&A Board: Data Management & Analytics: Unlocking FP&A Value
The Face-to-Face London FP&A Board Mastering Data in FP&A: Smarter Analytics, Better Decisions

June 5, 2025

FP&A Trends Webinar The Evolving Role of FP&A: From Number Cruncher to Strategic Advisor
The FP&A Trends Webinar Making FP&A Teams Fit for the Future

June 11, 2025

The Face-to-Face New York FP&A Board
The Face-to-Face New York FP&A Board From Insight to Impact: FP&A Business Partnering in Action

June 17, 2025

The Face-to-Face Sydney FP&A Board
The Face-to-Face Sydney FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

June 26, 2025

The Face-to-Face Singapore FP&A Board: Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments
The Face-to-Face Singapore FP&A Board Modern Financial Planning and Analysis (FP&A): Latest Trends and Developments

July 8, 2025

AI/ML FP&A
AI/ML FP&A
Data and Analytics
Data & Analytics
FP&A Case Studies
FP&A Case Studies
FP&A Research
FP&A Research
General
General
Integrated FP&A
Integrated FP&A
People and Culture
People and Culture
Process
Process
Technology
Technology

Please register to receive the latest FP&A news, updates and tips.

info@fpa-trends.com​

              

Foot menu

  • FP&A Insights
  • FP&A Board
  • FP&A Videos

Footer countries

  • Amsterdam
  • Austin
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Helsinki
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London (Circle)
  • Melbourne
  • Miami
  • Milan
  • Munich
  • New York
  • Paris
  • Perth
  • Riyadh
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2025 fpa-trends.com. All rights reserved.

0