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
Dynamic Forecasting and Its Benefits
February 2, 2023

By Ron Monteiro, the Founder of KICT Inc

FP&A Tags
Digital FP&A Events Insights

Ron-Monteiro-Dollar-General-Main-Cropped​

On October 5, 2022, FP&A Trends hosted an exciting webinar: Managing high growth with dynamic forecasting at Dollar General.

The author of the article facilitated this webinar, and the panellists discussed the importance of dynamic forecasting in a rapidly developing business environment. Before deep-diving into the case study, let us look at the webinar's agenda below:

The webinar covered the following areas:

  1. Why is digital Financial Planning & Analysis (FP&A) transformation important?
  2. Evolving from static FP&A to dynamic FP&A.
  3. A holistic approach to the transformation considering models, processes, systems and people.
  4. Key lessons learned and recommendations based on the Dollar General case study.
     

The World Is Changing Faster than Ever

Ron Monteiro introduced the topic by discussing his experience in an environment with a traditional planning approach and how this did not enable great business partnerships and quick decision-making. He then framed how quickly the world changes (Covid 19, massive inflationary pressure and supply chain challenges). In this rapidly changing world, the move to dynamic planning can be a tremendous advantage for companies that want to thrive in this environment.

One specific focus area was Paul Schoemaker's 'Uncertainty cone', which helped explain the situation. The predictability window has shrunk dramatically in today's world, necessitating moving away from traditional planning and expediting the move to dynamic planning. The velocity of the events going on dictates the requirement of being agile.
 

Deep-Dive Into a Case Study: Dollar General

Key facts: Dollar General is an American network of shops that has $34 billion in annual revenue. Their network includes 18,566 stores, growing with approximately 1,000 new stores annually. They are experiencing explosive growth, including international expansion into Mexico.

Ron-Monteiro-Dollar-General-1​

Figure 1: The First Polling Question about Forecasting Processes

After short introductory information and getting acquainted with the agenda, we launched the first polling question to learn more about the current state of forecasting processes in different organizations. According to the poll results, only 11% of respondents claim they have collaborative and real-time forecasting, while 16% operate completely static forecasts. However, most attendees (42%) have a partially dynamic forecasting process. The other 31% do have dynamic and collaborative forecasting, but it is not done in real-time.
 

How to Establish Dynamic Forecasting

Gray Finney ensured the audience knew that the change does require significant effort and that the FP&A teams needed to work closely with their cross-functional partners to help them through the changes. It was very important for them to paint the picture of how this change would benefit each function and person working in the company in the long run. It helped the teams stay on track and commit to this significant change within the organization.

Ron-Monteiro-Dollar-General-2-Updated​

Figure 2: The Second Polling Question about Software/Applications
Used for Planning and Forecasting

During the webinar, we asked our audience what software they use for planning and forecasting. Paradoxically, more than 50% of webinar attendees still use Microsoft Excel as their primary tool for planning and forecasting. In the current environment, Excel does not contribute to effective decision-making in real-time. The minority of the respondents (29%) go ahead with either CPM, BI, or other digital solutions. 4% of the audience claimed they use a home-grown solution for their forecasting process.

After collecting these insights, Gray started to dwell on the benefits of implementing dynamic forecasting in an organization. Some of the key takeaways are outlined below.

  • The FP&A team can complete weekly integrated forecasts.
  • The process now enables quick reviews with management and real-time decision-making.
  • Previous functional silos no longer exist, as all functions can update their respective parts of the Rolling Forecast in real-time.
  • Risks of manual error when forecasting or completing analysis have been dramatically reduced.
  • The previously disconnected Excel environment is now fully integrated into their ERP system.


Key Lessons Learned & Recommendations on Dynamic Forecasting

Gray elaborated on the crucial lessons learned in dynamic forecasting and explained the five most vital takeaways before stepping into it.

  1. Moving to a dynamic forecast model has growing pains but is well worth the effort.
     
  2. The need to gain buy-in from the organization was critical learning.
     
  3. Great coordination and relationships with the Information Technology (IT) team are essential to have a successful transition.
     
  4. It is important to utilize forecasting tools that solve specific/real issues vs one-size-fits-all. A thorough needs assessment is critical.
     
  5. Selling points to leadership include the following points, which all help prove the ROI for the investment:
  •  Faster turnaround for a forecast.
  •  A greater level of visibility.
  •  More levers to pull to drive business results.


Conclusion

Dynamic forecasting is an approach that allows you to be up to speed in the modern business world. Opting for this will help you produce forecasts faster and explore the abovementioned levers. While outdated and disconnected processes are eliminated, the organization benefits from real-time decision-making. In turn, this becomes crucial in a rapidly changing business environment.

We would like to thank Anaplan for sponsoring this webinar.

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

Related articles

forecast
Caution: Forecast Accuracy is Seasonal Too!
December 13, 2021

The benefits of measuring seasonality of accuracy are that users can plan high/low scenarios for each...

Read more
Machine Learning Revenue Forecasting - Microsoft Case Study
Machine Learning Revenue Forecasting - Microsoft Case Study
August 3, 2022

In this uncertain environment, FP&A professionals need to reconsider their approaches to forecasting and revenue management...

Read more
Rolling Forecast: Key Factors for Success
Rolling Forecast: Key Factors for Success
September 21, 2022

What are the key factors for success with Rolling Forecast?

In this short video, Nitu Agarwal...

Read more
forecast
Best Practices in Implementing Rolling Forecast
December 7, 2021

The main criticism of the traditional budget is that it does not react to what is...

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

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

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