• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

driver-based modeling

FP&A Done Right: To Recover from Economic Shock, Are CFOs Envisioning Enough Scenarios?

October 16, 2020 by Revelwood Leave a Comment

This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. Hansen explains the why scenario modeling is imperative when facing disruption.

Three out of four finance executives recently acknowledged that the planning processes their companies have in place do not equip them to respond quickly to major economic and geopolitical disruption.

Published in November of last year, the survey results could hardly have been more timely. Just a few weeks later, a virus would emerge in Wuhan, China, that would touch off a global pandemic, sending shocks through virtually every business.

Few could possibly have predicted how this event could have sent recently minted plans and forecasts for 2020 into trash bins everywhere. But even before the SARS-CoV-2 outbreak, CFOs and other execs were keenly aware that business conditions were unpredictable. They were equally aware of the hurdles keeping them from the adaptability and agility needed to outmaneuver and pivot around unforeseen obstacles. The same 75% of survey respondents who said their planning processes left them vulnerable also reported that outdated legacy planning systems, siloed planning processes with limited collaboration, and a lack of relevant workforce skills were keeping them from embracing the one thing their business needed to weather the storms of disruption: agility.

If ever there was a time to marshal all the tools and technology available to help organizations meet the needs of persistent, significant change, that time is now. And as businesses figure out how to recover from the initial shocks brought by the pandemic, gaining a clearer picture of what the future could hold may well be priceless.

CFOs have known this all along

A look back shows that finance executives have long recognized the importance of agility—and the need to plan for the unexpected. A 2016 global survey found that 67% of CFOs respondents said they were concerned about economic uncertainty in their region. Those worries turned out to be prescient. Soon would come tumultuous trade wars and other global impacts, culminating eventually in an unprecedented global pandemic impacting public health, transportation, critical supply chains, and more.

Indeed, forces like digital transformation, automation, and globalization have made agility a business imperative. Though change is a constant, it continues to accelerate.

Now, with so much uncertainty in front of us, agility is more important than ever.

Scenario planning: The reality check every business needs

Back in 2016, CFOs were asked how they could add the most strategic value when managing through an economic or business contraction. Nearly half (48%) said planning for multiple scenarios could help reduce risk by allowing their organizations to respond and course-correct when conditions change.

Since then, scenario planning has become an even more critical capability for finance and beyond. For businesses, it’s helpful to understand that scenario planning isn’t about modeling the likely effects of a specific disruption, such as a pandemic. Why? Because a disrupted supply chain could result from any number of causes: a natural disaster, a fuel crisis, a regional currency crash, political unrest, a pandemic—the list is virtually endless. So it’s important to instead build scenarios based on the likely impacts and model around those. Running what-if scenarios involving possibilities like cost cutting or changes in demand helps to prepare a series of contingency plans to address the financial, operational, and cash flow impacts that could result from specific disruptions.

And companies are doing this now more than ever before. For example, one higher education institution is running scenarios around the loss of room and board revenue, the possibility of fewer returning students, and the expenses associated with remote online learning. Another example is a healthcare organization that has used multidimensional, driver-based modeling capabilities to make course corrections while managing changes in patient volumes, increased government regulations, and a decline in insurance reimbursement.

Regardless of the industry or use case, multiple scenario planning empowers organizations to isolate their drivers, model according to how those drivers might be impacted, and sharpen their foresight to know what their future selves might need to do. It’s a reality check for a reality that hasn’t yet happened.

Scenario planning beyond the bottom line

How are these companies able to conjure up a crystal ball and peer into a mix of their possible futures? They do it through active planning.

Unlike its manual, siloed, episodic, static predecessor, active planning is comprehensive, continuous, and collaborative. Active planning processes are fueled by real-time data, powerful automation, and advanced technologies like machine learning to help planners throughout the business model what-if scenarios with virtually no limits—while iterating multiple scenarios rapidly to identify the most likely outcomes and most effective actions. The most advanced platforms even help you identify erroneous predictions, so you can have more confidence in the scenarios you model. Meanwhile, monitoring results helps you to identify trends and patterns that could further refine your scenario model.

By incorporating financial and nonfinancial inputs that might be impacted by economic disruptions into your active planning model, you can draw more parallels between drivers and better understand how one affects the other. Your responding game plan will also be more comprehensive, encompassing multiple departments for swifter execution and more precise pivots. This includes financial, workforce, and salesplanning.

Are you exploring enough what-ifs?

The right platform will allow CFOs and their teams to model any number of scenarios—and modeling enough of them could mean the difference between success and failure. Just be sure these scenarios are anchored around your key business drivers so that you avoid wandering off into low-value explorations that tie up valuable resources to game out extremely unlikely events.

But do assess a wide range of outcomes, including best case, worst case, and most likely. Generating a 360-degree view of potential outcomes helps you and your organizational leaders make better decisions. And developing strong internal communications to distribute and disseminate scenarios quickly and with the right people allows you to stay on top of changing conditions and quickly shift gears.

To jump-start the what-if scenario modeling process, ask questions that will help you fully explore the possibilities of a business interruption, price war, revenue slide, or any other scenario worth planning for:

  • What do financial hits like deferred revenue or default payments do to revenue forecasts? How will they affect demand planning for things like potential location closures or inventory imbalances?
  • How will you balance your short-term workforce needs against the long-term needs of the business?
  • Is there a shortage of a certain skill set that’s currently high in demand and lacking in your area? How can you source people with those skills?
  • What if you forgo hiring until the next quarter or even the quarter after that?
  • What happens if you need to reduce employee pay or staff levels?
  • How will you adjust your goals or quotes, and what does the ripple effect of that look like throughout the sales department?
  • What if your sales pipeline freezes or shrinks?
  • How can you adjust for potential reduction of sales resources, and how will that impact bookings, productivity, and costs?
  • How will seasonality affect already disrupted cash flow?

You’re not a fortuneteller, but you can be better prepared

You may not be able to predict the next pandemic, the next recession, or the latest technological advancement that sends shockwaves through your industry. But if you model enough of the most critical what-if scenarios, you can meet disruption with agility. And that may be the most valuable outcome of all.

This blog post was originally published by Adaptive Insights.

Home » driver-based modeling

Filed Under: FP&A Done Right Tagged With: active planning, Adaptive Insights, Analytics, Budgeting, Budgeting Planning & Forecasting, disruption, driver-based modeling, Financial Performance Management, scenario modeling, scenario planning, what-if scenarios, Workday Adaptive Planning

FP&A Done Right: Reforecasting in a COVID-19 World – Best Practices you Can Implement Now

August 7, 2020 by Revelwood Leave a Comment

FP&A Done Right

This is a guest blog post from our partner Adaptive Insights, written by Bob Hansen. The article shares insights from Workday’s internal finance leaders on how they are adjusting to the impact of COVID-19.

COVID-19 has hit the entire world with unprecedented disruption, and you are no doubt feeling it in your plans and forecasts. Ironically, just as you likely completed your 2020 revenue, headcount, hiring, opex, and capex forecasts, COVID-19 rendered them moot.

In a recent webinar, we asked finance professionals where they’re focusing their attention in terms of scenario planning and reforecasting. More than a third of attendees (34%) are interested in planning for the top line to accommodate unexpected changes in sales or demand. Nearly one in three (31%) want to better understand and game out their cash position. Nearly a quarter (22%) are focused on how to plan for workforce factors like headcount, hiring, capacity, and utilization. For 13%, the priority is determining a way forward for opex, capex, and discretionary expenses.

Taken as a whole, these concerns paint a picture of businesses working hard to anticipate what the future holds when they realize many of their prior assumptions no longer apply.

So where to go from here? How can you chart a new course when time is of the essence and the waters are murky? The good news is that Workday Adaptive Planning can help.

The need for more granularity and flexibility

As we’ve been helping customers adapt and respond to the current climate, we’re seeing an increased need for two things across the board: more granular forecasts and a finer time horizon.

These two dominant asks point to the demand for business agility. As Kinnari Desai, senior director of FP&A at Workday, points out, “Flexibility and the ability to react quickly are the two most important things.”

For CFOs and their teams, navigating an uncertain future requires up-to-the-minute, data-driven forecasting that can be done monthly, weekly, or even daily. With the COVID-19 pandemic sending waves of disruption throughout every aspect of an operation, businesses need a real-time view into their cash flow to make the right decisions in the moment.

At Workday, our team of finance professionals has gathered timely and actionable tips for dealing with revenue shocks and workforce and capacity planning when income is hard to predict, and strategies for emerging from this pandemic in a position of strength.

Focus on 3 elements of driver-based top-line modeling

Along with the right attitude, a flexible planning environment, and a good dose of business agility, it’s vital to boil down your most important business drivers and optimize your plan to those key drivers.

When implementing driver-based top-line modeling, Desai says to focus on three key elements.

  1. Align around the metrics that matter. Query your senior managers across the business on which metric or metrics are the most important in these times so you know what to optimize for when you run what-if scenarios.
  2. Identify your largest business drivers. Focus on adjusting those levers to realize the largest financial impact (rather than trying to optimize for every single lever).
  3. Home in on the top two to three meaningful scenarios. By now, you probably have a sense of the impact the pandemic has made on your business, so focus your energy and recommendations on the three most likely or meaningful scenarios. Don’t waste your time, cycles, and sanity spinning 10 or more scenarios that are only slightly different from one another. Iterate and refine the scenarios that will matter the most.

You can use Workday Adaptive Planning to tee up your top-line model without a lot of versioning headaches, number crunching or toggling between spreadsheets. Top-line modeling also helps ensure you and your leadership are marching toward the same goal—something that’s never been more crucial.

Understand the value of the common data model

As these changes impact your data model, as you encounter unforeseen expenses, and as you face the prospect of making critical decisions on an accelerated timeline, the true value of a common data model becomes clear. “At Workday, our common data model really helps us,” explains Desai. “At the end of the day, having the same data model being used in your planning system and your ERP system (and if it’s one and the same, that’s even better) is very important to react quickly and understand the data. I can’t emphasize enough the value of the common data model when you need to know what’s really happening in the business right now.”

Working from a single source of truth, notes Desai, you can better explore data, understand the source of that data, and identify viable, numbers-backed opportunities. Say you’re exploring the idea of moving all your new hires out by a quarter. Historically, that may have been done on a quick Excel workup or even a back-of-the-envelope calculation, with decisions based on a glance at the actual data. But neither of those comes close to what anyone would legitimately describe as “data-driven.” With Workday Adaptive Planning and a common data model, we’re seeing customers forecast quickly, adjust variables in real time, and identify the right moment for taking specific action.

From our own experience at Workday, we realized that to move quickly, we had to iterate multiple times. And we realized that revenue, headcount, and cash flow are all driver-based. A single source of truth is making those iterations easier because those drivers are always accurately represented.

Another key advantage: The platform also helps you isolate and measure the impact of specific variables, instead of the detail just disappearing in a never-ending stream of formulas and sheets. For example, many companies now face (hopefully) one-time expenses like supporting a remote workforce. (We created a special “COVID-19” project code so we could track these one-off expenses, like the relief package Workday provided its employees, separate from typical ongoing business expenses.) Operating on a common data model helps you trace the impact of that expense and present true business-related actuals-to-forecast variance.

Keep management in a forecasting feedback loop

Especially in a time like this, the most valuable role of FP&A is to provide expert insight and well-modeled scenarios to senior management early on so they can make informed decisions on issues like expense reduction, hiring, workforce deployment, customer payment options, and more. The faster they can understand and digest those scenarios and the data, the better suited your organization will be to see the other side of this with minimal lasting damage.

This new pace will most likely not let up anytime soon, so now more than ever, you need to utilize Workday Adaptive Planning to ensure your models, plans, and forecasts reflect the latest expectations and data. You have to be able to make changes on the fly and be ready with an answer when you’re asked, rather than spending the next two to three days calculating it.

So to help ensure your leadership is up to speed, turn to our platform to:

  • Build your Active Dashboard to showcase the top business drivers for quick reference and fast, high-level adjustments
  • Drill down into a specific number, or into specific areas of the company to better help understand relationships and correlations across departments or business units. Top-line numbers don’t always provide the insights you need, but discovering what’s behind the numbers can help you see, say, where that opex increase is really coming from
  • Automate as much as you reasonably can, including ingesting data instead of copying and pasting into reports, to free yourself of the manual minutiae and save time to serve as the strategic force you are

How quickly can you get Workday Adaptive Planning up and running?

This is a question we’re hearing frequently these days as FP&A professionals realize their spreadsheets and legacy planning systems have left them at a disadvantage—and they’re looking for something that will give them greater agility fast.

Depending on what you want with your initial build, getting up and running could take as little as a couple of weeks. As with anything, the timeline depends on a variety of considerations.

  • Workday Adaptive Planning is vendor-agnostic and easily integrated with most any other system. You’re going to want to pipe in any data source you’re currently using that’s valuable to your plan
  • There’s no real limit to the amount of data you can sync with Workday Adaptive Planning. Just determine what makes sense for your business—and if your need is urgent, decide what data is critical now and what can wait for later
  • Workday Adaptive Planning lets you plan as far into the future as you like. This is a significant differentiator from some tools like Salesforce, which allow you to forecast relatively near term or the quarterly pipeline but remains a transactional element. With Workday, you can look past the near term
  • If you’re still dependent on external files for your planning, no worries. OfficeConnect is a helpful add-on that lets you interact with live numbers in your Excel, PowerPoint, and Word documents

Change is always a constant. Yet unprecedented changes such as those we’re seeing today require more insight and support. That’s why we’ll be rolling out more webinars and education for you to learn how to get the most from Workday Adaptive Planning—and keep your business agile and responsive in these uncertain times.

This blog post was originally published by Adaptive Insights and appeared here.

Read more blog posts from our partner Adaptive Insights:

FP&A Done Right: Tips for Scenario Modeling During COVID-19

FP&A Done Right: What Must FP&A Do Differently to Make Planning a Success

FP&A Done Right: 3 Words for a COVID-19 World — “Flexible Budget Variance”

Home » driver-based modeling

Filed Under: FP&A Done Right Tagged With: Adaptive Insights, Budgeting Planning & Forecasting, business drivers, cloud financial performance management, COVID-19, driver-based modeling, enterprise performance management, forecasting, Planning & Reporting, Revelwood, Workday Adaptive Planning

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.