Skip to main content
logo top bar

The Online Resource for Modern FP&A Professionals

Main menu

  • Home
  • FP&A Insights
    • FP&A Articles
    • FP&A Publications
    • FP&A Trends Digest
    • Short Videos
    • Our Contributors
  • FP&A Events
    • International FP&A Board
    • FP&A Trends Webinars
    • Digital FP&A Circles
  • AI FP&A Committee
    • Introduction
    • Members
    • Resources
    • Meetings
  • FP&A Maturity Model
  • About Us
    • Company Policy
    • Privacy Policy
    • Editorial Guidelines
    • Our Ambassadors
    • Our Sponsors & Partners
    • Contact Us
  • Sign up
  • Login
image banner
Using Analytic Models
September 21, 2017

By Michael Coveney, Analytics Thought Leader and Author

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

There are only 3 things management can ever control:

  • The arrangement of its own business processes (e.g. sales, production, customer service, etc.)
  • The resources (money, people, assets) applied to those business processes, and
  • The volume and quality of work carried out within those business processes

However, organisations operate in an uncontrollable and often unpredictable business environment, such as market demand, energy, inflation and exchange rates. As a consequence, the role of planning is to help manage what can be controlled to produce outcomes that will achieve organisational objectives, within an uncontrollable and unknowable external environment.

With this in mind, an analytic model can be used in a number of ways as outlined here:

  • To confirm relationships that managers believe exist within an organisation and their impact on performance. These may be between those that are controllable such as resources applied and production capacity, and those outside the control of the organisation, such as the weather and interest rates. Relationships are typically set up as ‘rules’ that use historic base data to generate the results achieved, taking into account any time lag between ‘cause and effect’. By doing this, managers are able to confirm that the organisation operates as expected, and they can assess how this compares with other organisations/industries.
  • To explore the boundaries of performance caused by unpredictability in the market. Once a model’s relationships have been confirmed, it can now be used to determine variability in the drivers of the business. For example, if raw materials costs were to increase by 5% and demand reduce by 10%, what would be the impact on profitability and cash flow. By running multiple scenarios, managers can get a better understanding of how a change in one part of the business impacts overall results.
  • To assess changes to the way in which the business operates. Business performance can only be improved so much by cutting costs. The most radical changes come when business processes are performed better, more efficiently or differently. Analytic models can simulate these changes, such as outsourcing or the introduction of new initiatives, by making changes to the model’s relationships. Managers can then prioritise how its business operation should evolve over time along with a forecast of the likely costs and impact on performance.
  • To predict future results and set interventions.  By using a combination of the above, analytic models are able to predict a range of future results from pessimistic to optimistic. These forecasts should cover the short-term, say 1 month, to the longer term such as 3 to 6 months into the future. Managers can then set thresholds that represent specific levels of individual business process performance at which interventions will take place. For example, if a 3-month forecast shows a 10% under budget variance in sales, then marketing spend will increase to generate more demand.

It's worth emphasising that analytic models can never accurately predict results as it’s impossible to code or even know all the relationships involved. Their true value is in allowing managers to assess the impact of uncontrollable events and the cost of implementing changes to offset them when they arise.

 

The article was first 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

Future Meetings

  • Digital
  • In person
London FP&A Board
The Face-to-Face London FP&A Board
Beyond the Horizon: Top FP&A Trends of Tomorrow

February 25, 2026

Toronto FP&A Board
Toronto FP&A Board
From Insight to Impact: FP&A Business Partnering in Action

March 5, 2026

New York FP&A Board
New York FP&A Board
Agile FP&A: Turning Myths into Practice

March 10, 2026

Chicago FP&A Board
Chicago FP&A Board: Beyond the Horizon: Top FP&A Trends of Tomorrow
Beyond the Horizon: Top FP&A Trends of Tomorrow

March 12, 2026

Seattle FP&A Board
Seattle FP&A Board: Dynamic Shift: Mastering Predictive Planning & Forecasting
Dynamic Shift: Mastering Predictive Planning & Forecasting

March 19, 2026

The FP&A Trends Webinar
The FP&A Trends Webinar. FP&A Business Partnering in the Age of AI
Elevating FP&A Business Partnering Through AI

March 18, 2026

The FP&A Trends Webinar
The FP&A Trends Webinar. The Winning Formula of Integrated FP&A
The Analytical Backbone of Integrated FP&A

March 31, 2026

Pagination

  • Previous
  • February 2026
  • Next
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
The Power of FP&A Storytelling
 
Agile FP&A: Turning Myths into Practice
 
8
9
10
11
12
13
14
Creating Your Transformation Map with the FP&A Trends Maturity Model
 
15
16
17
18
19
20
21
22
23
24
25
26
27
28
Beyond the Horizon: Top FP&A Trends of Tomorrow
 
All events for the year

Homepage – Acme Corp

Visit our register pageemailVisit our LinkedIn pagelinkedinVisit our Twitter profiletwiterWatch our YouTube channelyoutube Visit our register pagefp&a digest

A leading international think tank dedicated to advancing the practice of Financial Planning and Analysis (FP&A). Its mission is to shape the future of the profession by exploring emerging trends and sharing best practices through research, publications, events, education, and advisory work.

Foot menu

  • FP&A Articles
  • FP&A Publications
  • FP&A Trends Digest
  • International FP&A Board
  • FP&A Trends Webinars
  • AI FP&A Committee

© 2015 - 2026, FP&A Trends Group. All rights reserved.

0