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
    • Contributors
    • FP&A Trends Digest
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Austin
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • Miami
    • New York
    • Paris
    • Perth
    • San Francisco
    • Seattle
    • Shanghai
    • Singapore
    • Stockholm
    • Sydney
    • Tokyo
    • Toronto
    • Washington D.C.
    • Zurich
  • AI/ML Committee
    • Introduction
    • Meetings
    • Members
    • Resources
  • Video Content
    • Digital FP&A Boards
    • FP&A Webinars
    • Short Videos
  • Contact Us
  • About Us
    • Ambassadors
    • Privacy Policy
    • Company Policy
    • Editorial Guidelines
    • Our Sponsors & Partners
image

FP&A Trends Survey 2023: Define the future of FP&A 

Click here to view details

 

Tips and Hints on Implementing Driver-Based Models
New
June 23, 2022

By Tomasz Klimek, Head of FP&A at International Airlines Group (IAG GBS)

FP&A Tags
Driver Based Planning

There are a few steps how we can build a driver-based model for our business. I would like to describe the process using aviation as an example. 

Decomposition of the business model

The first step in building a driver-based model is the decomposition of the business model. The easiest way would be to start with Income Statement (revenues and costs); however, we should not forget about the Balance Sheet and Cash Flow effects. 

I would recommend using the Pareto approach (20% of causes explain 80% of results). So going through P&L lines, we could pick up the biggest categories of revenues and costs and then if time, funds, and resources allow digging into details. We should always remember that benefits should outweigh the costs so that whatever we will build will be desirable, feasible and viable. 

Apart from biggest categories we could also focus on

  • Controllable revenue and costs – areas business can shape
  • Low hanging fruits – areas that give the biggest opportunities to improve performance 

Below is the cost structure, typical for the aviation business. We will focus on the direct variable costs. 
 
fp&a

Figure 1

Identification of cost drivers

The process of setting the drivers should be cross-departmental and perhaps also using some external knowledge that is available on the market e.g., in aviation, there is the general assumption that the main long-term revenue drivers are

-    GDP growth (traffic grows twice faster than GDP)

-    Level of protectionism (so-called open skies policies applied by specific countries)

I would recommend a design thinking process to establish drivers for specific areas of the business. Cross-departmental meetings could

  • identify the best drivers and 
  • agree on the process of collecting the operational data (who and when is to deliver them to the model). 

The drivers often might become KPIs and/or part of the balanced scorecard for the business, helping to interpret the results and automate the reporting. 

Below are the examples of drivers that could be used to model the direct variable costs in aviation: 


- Number of passengers (by class) – Catering, Fast track, Baggage
- Number of landings – Airport charges, Engineering (landing gears)
- Flying time – Fuel, Engineering (engines)
- Flying distance – ATS charges
- Block time – Payroll (pilot crew, cabin crew)
- Fleet type – Fuel, Engineering, Crew training
- Route types (short-haul, long haul) – Crew Accommodation

Creating solutions for data collection, analysis, and simulation

Once we have the drivers, we need to build a technical solution. My advice would be to start at the end, so focus on the output (reports, analysis, what decisions will be made based on that model), then work backwards on how to automate the process and minimise the effort involved in using the solutions. Simplifying, we need to answer two questions what? (Effectiveness) and how? (Efficiency). Process optimisation will be key. We should think not only about the implementation costs but also about the operating costs of this model (life cycle costing) – how many people will be involved, how often for how long. 

The picture below shows the solution for third-party suppliers’ variable costs. 

fp&a

Figure 2

Let’s not forget about visualisation and self-service tolls in the output area so that businesses can operate the system on their own (self-service capabilities). 

Few topics to consider when choosing and implementing the technology:

  • I would recommend building such a model as much as possible in-house. Current low-code or even no-code solutions are allowing analysts to build and then use such models with minimal support from external consultants
  • When choosing the technology, take into account its agility. Especially when your business goes through major transformation (e.g., digitalisation) and you will need to update the way the model works frequently
  • The agile approach in building such a technical model means that we can build part of the solution and test it even within a week. The whole model (build) should not take more than a few weeks. It will most probably take more time to build the concept than the technical solution. Therefore, spend enough time analysing what you want to achieve
  • Different tools are available on the market that should meet the requirements of smaller and bigger companies
  • Required granularity (not all solutions might be able to deliver it with the required performance)
  • A real-time approach might limit the choice of technologies

Integration of all business functions

Change management is important not only within finance but also in other functions. The division of responsibilities between finance and business, as agreed during the design thinking sessions, should be implemented.
The integrated approach enables to connect of all functions, entering the drivers only once (right first time) and achieving the single version of the truth.  


Figure 3

 

Blue arrows show the data (drivers) entered by specific functions; violet is showing the output/reports these functions might get in exchange. 

Technological progress makes it possible to use Machine Learning and Artificial Intelligence in setting the best drivers and using them in forecasts and simulations. It is the next quantum leap that might happen in building driver-based models in the future.  

Summary

So, the article described the methodology of creating a driver-based model on the example of an aviation company. It focused on the key steps and explains the different areas that need to be considered in order to successfully implement an automated, integrated driver-based model.
 

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

Related articles

fp&a
Connecting Stakeholder Management to Driver-Based Planning
June 15, 2022

Driver-based planning is a key topic for any FP&A team today. But what is not always...

Read more
Financial Planning in the Age of Uncertainty
Financial Planning in the Age of Uncertainty
January 6, 2022

Unlike traditional management methods, Financial Planning and Analysis solutions are a new way to manage your...

Read more
fp&a
In Search Of “Intelligent Drivers” In FP&A
October 14, 2021

It is unrealistic to link every activity. In some cases, you may only be able to...

Read more
Driver based planning
Driver Based Planning: Finding the right drivers
May 25, 2021

“If the rate of change on the outside exceeds the rate of change on the inside...

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

The FP&A Trends Webinar: The Winning Formula for Integrated FP&A

Click here to view details and register

Pagination

  • ‹‹ Previous
  • January 2023
  • Next ››
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Inside the Crystal Ball: Top 7 Trends Shaping FP&A in 2023 and Beyond
 
22
23
24
25
26
27
28
Five Critical Roles for Building a World-Class FP&A Team
 
29
30
31
1
2
3
4
 
 
 
 
All events for the year
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

Future Meetings

Geneva FP&A Board
The Face-to-Face Geneva FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 7, 2023
The FP&A Paris Board
The Face-to-Face Paris FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 9, 2023
Zurich FP&A Board
The Face-to-Face Zurich FP&A Board Five Critical Roles for Building a World-Class FP&A Team
February 9, 2023
Moving from FP&A to Extended Planning and Analysis (xP&A)
The Face-to-Face Dubai FP&A Board Moving from FP&A to Extended Planning and Analysis (xP&A)
February 15, 2023
FPA Integration
The FP&A Trends Webinar The Winning Formula for Integrated FP&A
February 22, 2023
Five Critical Roles for Building a World-Class FP&A Team
The Face-to-Face San Francisco FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 7, 2023
The Face-to-Face Houston FP&A Board
The Face-to-Face Houston FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 14, 2023
New York FP&A Board
The Face-to-Face New York FP&A Board Five Critical Roles for Building a World-Class FP&A Team
March 16, 2023

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
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • Miami
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

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

0