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 Talks Series
    • FP&A Trends Research
  • FP&A Board
    • Amsterdam
    • Boston
    • Brisbane
    • Brussels
    • Chicago
    • Copenhagen
    • Dubai
    • Frankfurt
    • Geneva
    • Hong Kong
    • Houston
    • Kuala Lumpur
    • London Board
    • London Circle
    • Melbourne
    • 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
2022 global CPM trend report

2022 global CPM trend report

Click here to view details and register

 

Driver-Based Planning — Why and How
New
February 25, 2020

By John Sanchez, Keynote Speaker, Corporate Trainer and Author

FP&A Tags
Driver Based Planning
Financial Planning and Analysis

Why Use Driver-Based Planning

Driver-based planning is characterized by using formulas that rely on a thorough understanding of the relationship between the independent and dependent variables used to model outcomes. A simple example of driver-based modeling is forecasting sales by using a rate multiplied by units formula. A big strength of driver-based models is that they allow for quick and easy what-if analysis. All you need to do to see the results of different scenarios is to change a variable and the results flow through your model to let you see the outcome. These models provide great flexibility, but they require a deep understanding on the part of the modeler of how the variables affect each other. These models can also require more time up-front to develop than judgment-based or statistical models.

When creating a driver-based model it is important to produce one that is not overly detailed or complex, but one that is accurate and actionable. Avoid complexity by adding variables if they do not provide analytical benefits. Starting with the chart of accounts is not a good idea. The model should focus on key performance drivers. 

Identifying Key Drivers (80/20)

Every planning professional I’ve ever met is familiar with the Pareto Principle, also known as the 80/20 rule. It simply says that roughly 20% of inputs account for 80% of outputs. The interesting thing is, most people I’ve met routinely ignore this principle. 

A little analysis will tell you where the 20% are in your business. This will then be your focus when you’re designing your driver-based model. You may not need to use driver-based planning for every item you want to forecast. Let your 80/20 analysis steer your modeling. Your planning should integrate the operational elements of the business, not just financial data from the general ledger. Many of the drivers you will want to evaluate include non-financial, operational, variables. Here are some examples of financial and operational drivers:

Examples of Financial Drivers:

  • Price
  • Volume
  • Margin
  • COGS

Examples of operational drivers:

  • Call Volume 
  • Employee turnover
  • Service Level: 
  • % of orders fulfilled

One of the best ways to gain a deep understanding of the operational drivers is to get out of your office and get into the operations of your business. See how the business operates. Observe first-hand what makes the needle move in the business. When I had to develop the operating budget for the reservations department at Royal Caribbean Cruises, I spent some time observing reservation agents taking calls and booking cruises. This gave me a good understanding of what variables affected their call volume, average talk time, and a variety of other variables. This helped me immeasurably when I built a driver-based model to develop the reservations department’s budget.

Steps to Building a Driver-Based Model

Remember Pareto

The first thing I would do when building a driver-based model is the 80/20 analysis. First, figure out what you are going to model because it is not going to be the entire chart of accounts. 

Discovery

Once I know the output I’m looking for, it’s time to go into discovery mode. That’s where the operational experience I mentioned comes in. Go talk to the people in the departments involved in the things that drive the outcome you’re planning for. If you’re forecasting sales (in dollars), go talk to the vice president of sales and some managers in the sales department, maybe even some salespeople who are the ones racking up the sales. Gain an understanding of their sales cycle. What are the things that affect prices, discounts given, receivables terms, chargebacks/returns, sales volume, the timing of various promotions, etc.? These are all things that can affect your projection, so you better understand them. 

Put the Variables to Work

Now it’s time to build your model. Be organized and develop your formulas based on what you learned in the discovery process. Let what you learned to drive the level of detail in which you build your model. For example, if sales prices don’t vary, it’s sufficient to set up a price list and use that to drive all the formulas that involve sales price. If, on the other hand, your business runs lots of promotions or routinely gives discounts, you’ll want to build your formulas to incorporate these variables so you are not constantly reworking the model when things change. That’s the whole purpose for using this method, flexibility.

Using Technology to Enhance Driver-based Planning

There is a wide variety of technology tools that incorporate functionality that makes driver-based planning easier. Many of the newest planning software packages allow you to use formulas that are very similar to spreadsheet formulas, making the learning curve short and many planners still choose to stick with spreadsheets. If you go this route, you need to be aware of spreadsheets inherent limitations and proceed accordingly. Broken links, formula errors, data integrity and security issues abound in spreadsheets, so if you are doing serious planning, it is worth evaluating some of the other tools that are available.

Summary

My preference for driver-based planning stems from years of using them and understanding their strengths. It takes an upfront investment of time and energy to learn your business well enough to build a well-designed driver-based model, so it may not be the right choice for your purpose. If you go this route, though, it pays big dividends over and over again. 

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

MagentaCircle

October 8, 2021

Great insights
  • Log in or register to post comments

Related articles

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 Maturity: Creating Value With More Effective Rolling Forecasts
December 4, 2018

Mature driver-based planning models are an essential component of effective rolling forecast processes in complex, global...

Read more
Driver Based Planning & Forecasting in the Context of FP&A
October 14, 2019

When I first came across the term driver based planning and forecasting I was confused. As...

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

Maximizing FP&A Value Through Automation

The FP&A Trends Webinar: Maximizing FP&A Value Through Automation

Click here to view details and register

Pagination

  • ‹‹ Previous
  • May 2022
  • Next ››
Su Mo Tu We Th Fr Sa
1
2
3
4
5
6
7
8
9
10
11
12
13
14
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
Cash Flow Planning - Why the Traditional Profit-Driven Mindset Needs to Be Rethought
 
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
From Traditional to Better and Beyond Budgeting
 
15
16
17
18
19
20
21
Digital FP&A in Practice: Dorrington Plc Case Study
 
22
23
24
25
26
27
28
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
Top Five FP&A Challenges and How to Address Them
 
Maximising Value Creation with FP&A Business Partnering
 
Reinventing FP&A: Key Lessons Learned from the Pandemic
 
29
30
31
1
2
3
4
 
 
 
 
All events for the year

Future Meetings

houston
The Face-to-Face Houston FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 2, 2022
Maximising Value Creation with FP&A Business Partnering
The Digital Middle Eastern FP&A Circle Maximising Value Creation with FP&A Business Partnering
June 6, 2022
chicago-june
The Face-to-Face Chicago FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 7, 2022
Frankfurt
The Face-to-Face Frankfurt FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 9, 2022
Toronto
The Face-to-Face Toronto FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 9, 2022
dc
The Face-to-Face Washington D.C. FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 14, 2022
New York
The Face-to-Face New York FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 15, 2022
Reinventing FP&A: Key Lessons Learned from the Pandemic
The Face-to-Face Boston FP&A Board Reinventing FP&A: Key Lessons Learned from the Pandemic
June 21, 2022
The FP&A Trends Webinar
The FP&A Trends Webinar Maximizing FP&A Value Through Automation
June 22, 2022
Agile FP&AAI/ML FP&ABeyond BudgetingBusiness Intelligence (BI)Capital PlanningCash PlanningCollaborative FP&ACorporate Performance Management (CPM)Cost PlanningData-Driven FP&AData VisualisationDigital FP&ADriver Based PlanningExtended Planning & Analysis (xP&A)Financial Planning and AnalysisForecasting QualityFP&A AnalyticsFP&A Business EnvironmentFP&A Business PartneringFP&A Case StudiesFP&A DashboardsFP&A KPIFP&A Maturity ModelsFP&A PeopleFP&A Predictive AnalyticsFP&A RPAFP&A Scenario PlanningFP&A SkillsFP&A StorytellingFP&A Strategic PlanningFP&A Team BuildingFP&A TechnologyFP&A TransformationFP&A Trends ResearchIntegrated FP&AModelling and ForecastingPlanning and BudgetingProfitability AnalysisRisk-Adjusted PlanningRolling ForecastWhat is FP&AZero-Based Budgeting (ZBB)

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
  • Boston
  • Brisbane
  • Brussels
  • Chicago
  • Copenhagen
  • Dubai
  • Frankfurt
  • Geneva
  • Hong Kong
  • Houston
  • Kuala Lumpur
  • London Board
  • London(Circle)
  • Melbourne
  • New-York
  • Paris
  • Perth
  • San Francisco
  • Seattle
  • Shanghai
  • Singapore
  • Stockholm
  • Sydney
  • Tokyo
  • Toronto
  • Washington D.C.
  • Zurich

Copyright © 2022 fpa-trends.com. All rights reserved.

0