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
The Power of Machine Learning: Then and Now
January 3, 2022

By Tom Byrne, Managing Director at T&B Software Solutions

FP&A Tags
AI/ML FP&A
FP&A Technology
FP&A Skills
FP&A Transformation

AI & Machine LearningIntroduction

In the early 1990s, I became Finance Manager of a manufacturing operation facing challenges. The UK economy was in recession and the marketplace was changing.  Sales forecasts were regularly missed by some 10%. There was too much working capital and hence a shortage of cash. This had to be brought under control, as the position of the business with its suppliers was at risk.

Traditionally, Finance had not contributed to the sales forecast but was responsible for the P&L between sales and profit.

Product - the remanufacture of alternators and starter motors - was highly seasonal; business volume was closely related to the time of year.

I needed a tool that would help to optimise the business environment. This would shift the discussion to control of the future rather than analysis of what had gone wrong in the past.  This paper describes how I constructed that tool and how I would do this today using commonly available Machine Learning techniques.

I hope to show the analytical power that is now available to the FP&A practitioner and how it can drive business change in a structured manner; a method that involves considerably less effort than I had to apply all those years ago.

The Machine Learning Paradigm

Machine Learning is a branch of Artificial Intelligence that builds predictive functions by analysing data. It has three subgroups:

  • Unsupervised learning – ‘What happened?’.  This includes techniques such as clustering that can find patterns in data that is not labelled, for example, the determination of market segments form of historical data.
  • Supervised learning – ‘What is going to happen?’.  Data is labelled and we place new data either onto a continuum, for which we use regression, or a discrete category, for which we use classification. In both cases we construct a model that is trained by historical data and used to determine the outcome for new data – for example, to determine the likely sales volume for a particular price, based on the historical relationship between price and volume.
  • Reinforcement learning – ‘How do we make it happen?’. This models the activity of an agent within an environment, rewarding positive behaviour so that the model evolves an effective solution.  Self-driving cars are a sophisticated example.

I shall focus on unsupervised learning (clustering) and supervised learning (regression and classification).

The Business Model

fp&a

Figure 1: Business Model Schematic

The model created scenarios that forecast PBT, Cash and Return on Capital Employed for a range of inputs. It predicted cash in the short term and showed longer-term trends, helping to determine strategy.

I used a Quattro spreadsheet; this was the only spreadsheet that offered multiple, communicable tabs; different modules could be linked and changes in drivers would ripple through the model.

The Sales Forecasting Model

Then:

I developed a time-series analysis model to calculate sales. It used a 13-dimensional multiple regression – one dimension for trend and 12 to cover the months of the year – in order to separate trend from seasonality. Forecast error was reduced from 10% to 2%. Figure 2 shows an actual report (from 1991) that displays how seasonal the business was and demonstrates the long-term downward trend.

fp&a


Figure 2: Sales Forecasting Model Output – actual report from 1991

The module required knowledge of statistics, array functions and macro programming.

Now:

I would use the Python programming language and a library such as Facebook’s Prophet. This is simple to apply, understands seasonality and has flexible granularity. The statistical ‘heavy lifting’ is done automatically.

The Factory Model

Then:

The factory model used the sales forecasts to generate build inputs for the manpower model, and inventory and overhead recovery estimates for the financial model. It also calculated estimates of raw material purchases and expected service levels through regression, built using array functions in the spreadsheet. 

Now:

I would use the Scikit-learn Python library to make regression a step-by-step process.

It is also a good idea to use the following facilities:

  • Classification. In those days much time was spent determining A, B and C inventory. ‘A’ items have the highest annual consumption value, ‘B’ items are interclass and ‘C’ items have the lowest consumption value – some of these would be scrapped.  I would use existing categories to train a classification model to determine the inventory groupings.  This would be checked for exceptions, reducing management meetings.
  • Clustering, to identify slow-moving or obsolete inventory by the manufacturer.  Clusters would be plotted to see how the market was moving.  Results would feed into marketing and purchasing strategy.

The Labour Model

The number of direct staff required to meet the projected build is based on known productivity levels and mix.

Then: spreadsheet.

Now: Python and Pandas.

The Warranty Model

Then:

This used lagged time series analysis array functions to determine warranty rates. 

Now:

Today I would use a library such as Facebook’s Prophet, and Scikit-learn’s clustering to identify high warranty cost items by age, type and manufacturer.  This plotted over time would show how warranty clusters were moving, feeding into marketing and sourcing decisions. If this technology had been available to me then, the lengthy meetings to analyse warranty and identify problematic brands would have been considerably reduced.

The Financial Model

Then:

The complex spreadsheet on a PC.

Now:

Today I would develop the financial model in Python using data libraries such as Pandas, powerful visualisation libraries like Matplotlib and Plotly, and Dash to distribute personalised dashboards to managers. Then, I had to carry a PC around to board meetings – now, the cloud and dashboard distribution really would reduce the ‘heavy lifting’!

Benefits

The scenario planning not only fed into short term production, marketing and purchasing decisions but also helped define business strategy and promote business transformation.

Adopting an AI/ML approach

Then:

The model was built from first principles. It required statistical, spreadsheet and programming skills along with business knowledge. I developed it in tandem with my full-time Finance Manager role. It required time and dedication for its conception, development, testing and presentation.

Now: 

Life would be easier. Here is a checklist of steps that I would employ:

  • Understand the key drivers.
  • Understand the issues – e.g. the business trends, inventory, warranty.
  • Identify consumers of finance time.
  • Get trained in the techniques. There are many excellent distant learning courses in Machine Learning; their prerequisites would be met by someone trained in finance. Such a person would have a good grasp of ML techniques and Python within six months.
  • Leverage the power of the cloud for data collection and presentation.
  • Streamline the collection, analysis and presentation of data and make these available to managers to display the effects of different scenarios in models derived from the latest data.

The Skill Set Required

Recruit individuals who are curious and willing to learn. The processes I have described fit well will data lake technology – from the collection, organisation and analysis of data to its easily consumable distribution. Hence the ideal Finance Data Scientist would draw on business knowledge, maths and stats, finance and IT skills – this powerful combination makes a whole greater than the sum of the parts.


fp&a

Figure 3: Skills for the ideal data scientist

Use consultants for mentoring, training and establishment of the role. The goal is to develop reliable and versatile individuals who could bring this powerful combination of skills and experience to bear on both short and long-term challenges.

Summary

I have described how I met a business challenge in the 1990s. The models gave the management team a common platform to understand trends and discuss scenarios. 

Today, the development of computer languages such as Python and its libraries and Machine Learning techniques would simplify and amplify this work.

The FP&A function can take advantage of these techniques now. Discussion among professionals will highlight the potential, and their use is bound to grow.

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

Related articles

AI and ML
How to use AI to forecast Account Receivables
November 22, 2021

This blog explains how FP&A can utilise Artificial Intelligence (AI) to make a data-driven forecast of...

Read more
Modern Technology
Modern Technology: Transforming FP&A’s Agility and Adaptability
May 11, 2021

The FP&A transformation journey should start right now. In this video, you will learn about three...

Read more
AI and ML
AI and ML in FP&A – Two Case Studies
November 24, 2020

This article summarises the presentations and discussions during the recent Digital FP&A Circle on how Artificial...

Read more
Big data
Using Machine Learning for Revenue Predictions
September 4, 2020

‘If I had an hour to solve a problem and my life depended on the solution...

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 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

FP&A Trends Webinar Practical Steps for FP&A Analytical Transformation.
The FP&A Trends Webinar Unlocking FP&A Analytical Transformation

June 18, 2025

The FP&A Trends Webinar How AI is shaping the future of Financial Planning & Analysis (FP&A)
The FP&A Trends Webinar Transforming FP&A with AI: Maturity, Impact, and Future Roles

June 25, 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

Webinar: FP&A Trends Survey 2025
The FP&A Trends Webinar 2025 FP&A Trends Survey: Benchmarks, Priorities, and Best Practices

July 9, 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