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
Life Cycle of a Planning Model: Determine the Purpose of the Driver-Based Model(s)
April 27, 2023

By Michael Coveney, Analytics Thought Leader and Author, Head of Research at FP&A Trends Group

FP&A Tags
Driver Based Planning
Modelling and Forecasting

Michael-Coveney-Life-Cycle-Planning-Model-2

In this blog series, I provide a comprehensive approach to the design, construction, roll-out and maintenance of a modern driver-based planning solution.

Driver-based plans are not a substitute for experience or management intuition but can effectively and efficiently support decision-making. When set up well, they can answer questions such as: 

  • What does the future look like based on our current mode of operation?
     
  • Are the forecasts on which our plans are based realistic?
     
  • What would be the cost of resourcing the strategic plan, and can we afford it?
     
  • What would happen if we changed direction or redistributed some of the budget to other areas? 

In order to answer these and other questions, the first step is to determine the decisions the model is to support. It will require understanding the factors on which the decisions will be made. These factors can be broken down into two groups:

  1. The first is the measures that link goals, the activities supporting them, and their resource implications. E.g., what does each of the organisation’s business activities (Sales, Production, Customer support, Product/service development and Administration) cost in terms of money, people and additional assets?
     
  2. The second shows the interrelationship of departments, groups and activities that work together to achieve a goal. 

If we go back to the first two questions posed at the start of this blog, the model needs to reflect the relationships between measures and structure and how they change over time to make a prediction. With the last two questions, the model would also need to handle the likely changes to be made to the model itself, such as fundamental changes in how departments may be structured in the future.

For example, we will consider a typical commercial company selling products it manufactures. The questions initially to be supported include the first two questions mentioned as bullet points. In order to predict the future and assess the accuracy of a forecast, we need to take the planned sales and costs and document what factors we believe affect them. These factors will be those that are internal to the company and external things outside of the organisation’s control.

Factors can be gauged by analysing previous results and by asking those involved. As each factor is identified, we need to identify what drives them.

For example, sales volume is driven by the number of sales opportunities, which itself is driven by sales enquiries. The sales achieved from these enquiries are related to the number of online promotions placed by the marketing department and the price being asked compared with competitors. Profitability is driven by sales value, less sales cost and cost of production. Production costs are driven by the volume produced, which is a function of overheads, raw materials and staffing.

Considering external factors, we could assume that sales volume is affected by competitor prices and that the cost of raw materials is driven by inflation.

In each of these, we must break down the impact of each factor until we end up with a measure (known as a ‘driver’) that is not worth breaking down further as these items do not have a material effect on consolidated results.

With the third and fourth questions, the model would need to cater for new variables and possibly structural elements that would capture the cost of a project and its impact on current costs, as well as projected sales.

We can’t go into too much detail in this blog, but hopefully, the concept is easily understood. At this stage, we are only documenting the variables and their associated ‘rules’ the model will need to hold and the organisation structure. We are not yet ready to build the model – that will come much later.

In the next blog, I will look at defining the reports and analyses required, as this will impact the overall model design.

This article was first published on the Unit4/Prevero blog.

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

Related articles

Michael-Coveney-Life-Cycle-Planning-Model-Main-Picture
Life Cycle of a Planning Model
April 6, 2023

In this series of blogs, the author will be providing a comprehensive approach to the design...

Read more
Why Driver-Based Planning and Dedicated Planning Systems Matter for FP&A
August 8, 2019

Normally, integrating actuals into the planning cycle is not an easy task. Often financial and operating results...

Read more
Driver-Based Planning: Why is it So Important For Modern FP&A?
December 5, 2017

On 12th October 2017, 22 senior finance practitioners from such companies as Ericsson, IDG (International Data...

Read more
FP&A: the Evolution of Driver-Based Planning
July 25, 2016

Driver-based planning (DBP) is an essential part of the financial planning and analysis (FP&A) armoury, enabling...

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