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 Fifth Variance
February 10, 2020

By John Stretch,  MD at Stretch Business Training

FP&A Tags
Financial Planning and Analysis
Planning and Budgeting

One day in November, a worried operations manager for a transport company was preparing for a meeting with the group’s financial director. He’d been ordered to explain the overspending on his region’s fuel account for the first 10 months of the financial year. The variance was huge and the MD had hit the roof!

Fuel budget – 10 months to end of October     $5,000,000
Fuel actual   – 10 months to end of October    $8,000,000                            
Negative variance                                                ($3,000,000)

There were many reasons for the variance. The operations manager’s explanations were as follows: 

1. Price

“At budget time we thought the fuel price would remain steady at $4.00 per litre, but it quickly went up and is now $6.00 per litre.”

2. Volume

“At budget time we didn’t know whether our company would be awarded the National Sugar contract. I couldn’t budget for it because the tender was still being adjudicated. We were awarded the contract in February, so we’ve consumed a great deal of additional fuel”

3. Mix

“Company policy has always been to use diesel-driven vehicles in our fleet, but for the National Sugar contract, our technical people advised us to buy petrol-driven vehicles. Petrol is about 50% more expensive than diesel.”

4. Timing/calendar/smoothing 

“Our new depot has just become operational and we needed to fill the new 20,000-litre tank. I budgeted for this to happen in November; in fact, the new tank became operative in October.” 

5. Waste, loss and inefficiency

“Two vehicles collided with each other in our yard and caught alight. The insurance company alleges negligence and refuses to settle. Also, an underground pipe in our main depot sprang a leak and we lost 10,000 litres of fuel. Finally, a ring of employees was falsifying petrol purchases at a filling station on one of our routes”.

The group financial director listened to the manager’s nervous explanations and sighed to himself. He wondered how many meetings like this he’d have to attend, year after year, where good managers, like his colleague today, trotted out the same old excuses for their overspending. 

In the financial director’s opinion, the explanations for the first four variances added very little value to the conversation. They are “assumption variances” explaining that the assumptions and guesses made at budget time were not what happened in reality. The only really important item in this meeting, in his opinion, was the fifth variance, which focuses on waste, loss and inefficiency.

The financial director knew that the Board was considering his proposal to move from annual fixed budgets to rolling forecasts. If the proposal was adopted, the operations managers in the group would be required to forecast their monthly fuel expenditure in litres, and submit their forecasts for approval to their regional manager. At month or quarter-end, actual spend would be reported against this forecast, not against a budget set ten months ago. And in this instance, the financial director thought to himself:

  1. The manager’s forecast would be based on the ruling fuel price.
  2. The National Sugar contract volumes would be incorporated.
  3. He would take the policy change from diesel to petrol into account.
  4. The timing of the new depot’s fuel purchase would be correct.

And any variance reported against this forecast at the end of the month would arise almost entirely from waste and inefficiency, the fifth variance, which is what management should be focussing on in the first place!

The article was first published in Unit 4 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

A New Approach to Business Forecasting
July 10, 2018

Many millions of people are stuck with the habit of smoking. They know its bad for...

Read more
Breakpoints in Forecasting
August 20, 2019

Sometimes, what you forecast needs to change dramatically, due to e.g. market disruption or internal changes...

Read more
Budgeting and Forecasting Myths
February 18, 2020

A core aspect of financial planning & analysis (FP&A) is forecasting and budgeting. In this article, exposed...

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