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

 

'Business Analytic' Model Life Cycle
New
September 19, 2017

By Michael Coveney, Analytics Thought Leader and Author

FP&A Tags
Financial Planning and Analysis
FP&A Analytics
Modelling and Forecasting

Analytic models are rarely static. Their aim is to model the organisation in such a way as to allow managers to investigate what is actually going on and to assess changes to the way it operates. These changes may include looking at price/cost structures; the way in which departments are organised; partnerships; outsourcing; or introducing new products/services into new territories.

In each investigation, the model being used will evolve as new information is uncovered that impacts into what is being analysed.  The following graphic illustrates these major steps in a model’s evolution:

By way of example, I will use my experience in a real situation, to explain each phase of development.

Define what is being investigated

A number of years ago I was involved in an exercise with a major brewer as to what areas of the business were the most profitable.  As profitability was the main focus, the model concentrated on the different sources of income and associated costs.  They brewed beer which was sold through pubs they owned as well as other outlets such as supermarkets, restaurants and independent pubs. They also sold products such as wines and spirits bought in from other suppliers – all of which were put into the model so that profitability could be calculated by brand and outlet over time.

Collect relevant data

Now the model was built we had to find the data.  As a tip, don’t create a model from the data that is to hand – first model what you need and then go find the data.  Of course we didn’t have all the data we needed, so estimates were made but noted that they were estimates.  As models evolve, you might need to consider replacing these estimates with systems that can supply facts.

Model / analyse the data

Once the model was completed extensive analysis of the data was performed.  This was done by posing a number of questions such as ‘How has profitability of beer changed over time compared to spirits?”, and ‘Which locations have the lowest cost/structure per unit sold’.  We were using a specialised analytic system so answering these questions was quite easy.

Adapt the Model

What surprised us was the answers.  It appeared the most profitable area of the business was the product labelled ‘Other’, which was a ‘catch all’ for revenue that didn’t fall into beer and spirits.  So the model was adapted to look at ‘Other’ in more detail. This revealed that most of the organisation’s profits were coming from the gambling machines placed in the pubs they managed.  The organisation thought they were a drinks company but in fact they had become part of the leisure industry.

Use Model as a basis for Planning

Now profitability was understood, arrangements were made to improve this through targeted marketing campaigns, incentives and restructures.  The model again was adapted for these and now used to assign budgets and predict future performance.

Monitor Model Performance

The last step was then to track performance to see whether the changes were having the right effect.

Of course, this isn’t really the last step.  And that’s because the world we live in isn’t static. There will always be more/different competitors, the markets will continue to change – and so must our analytic models. Models are never finished – they need to continually evolve if they are to be of any real use.

This article was originally published in ​prevero Blog

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

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