• 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

Budgeting Planning & Forecasting

IBM Planning Analytics Tips & Tricks: Headcount Analysis

June 27, 2023 by Revelwood

Did you miss our recent webinar on headcount analysis? Here’s a high-level recap of what we covered. In short, IBM Planning Analytics is a powerful, flexible tool for headcount analysis. 

Headcount analysis is a critical component of any organization’s workforce planning and management strategy. Headcount analysis helps organizations understand their staffing requirements, analyze performance metrics, and identify areas of inefficiency that can be addressed through better HR practices. IBM Planning Analytics provides powerful capabilities for headcount analysis. In this blog post, we will explore headcount analysis with IBM Planning Analytics and discuss key features and benefits of this solution.

Watch the webinar here!

IBM Planning Analytics enables organizations to create sophisticated headcount models that can track a wide range of metrics related to employee performance, retention rate, demographics, compensation, and benefits. With Planning Analytics, organizations can analyze trends in headcounts, understand factors driving variations in headcounts, and identify opportunities to optimize their workforce. For example, you can use Planning Analytics to compare headcounts across different geographies or business units and to identify trends in staffing changes over time.

The solution provides a flexible and user-friendly interface that makes it easy for HR teams and other stakeholders to analyze headcount data. They do not need to be Planning Analytics power users. Planning Analytics includes a variety of pre-built dashboards, reports, and visualizations that enable users to explore and collaborate on data. Users can drill down into specific data points, filter data based on different criteria, and customize their views to suit their needs. The solution also includes a built-in report writer that enables users to create customized reports with ease. 

IBM Planning Analytics integrates seamlessly with a variety of data sources, such as ERP and HR systems, to provide a holistic view of headcount data. This means that organizations can extract data from multiple sources and integrate it into a single model for analysis, without having to rely on complex data transformations or manual data entry. This integration capability also ensures that headcount data is accurate and up to date, which is essential for effective decision-making.

Additionally, IBM Planning Analytics provides advanced analytics features such as predictive analytics, what-if scenarios, and trend analysis that enable organizations to forecast future headcount requirements, costs, and risks. Predictive analytics models can use historical data and machine learning algorithms to predict future staffing demands and highlight areas of staffing volatility. What-if scenarios enable organizations to simulate the impact of different staffing strategies, such as hiring freezes or increased retention efforts. And trend analysis enables organizations to understand the impact of different factors on headcount, such as seasonality, economic trends, and business cycles.

The solution also provides robust collaboration and workflow capabilities that enable HR teams to work together effectively and efficiently. The solution includes a variety of collaboration features such as commenting, task assignment, and alerts that enable teams to share information and coordinate efforts. The solution also includes powerful workflow features that enable teams to automate routine tasks and streamline processes, such as approvals and reviews.

Finally, IBM Planning Analytics provides security features that ensure the confidentiality and privacy of headcount data. The solution includes granular access controls, data encryption, and other security measures that enable organizations to protect their sensitive data. The solution is also compliant with a variety of security and privacy regulations, such as GDPR and HIPAA.

In conclusion, headcount analysis is a critical component of any organization’s workforce planning and management strategy. IBM Planning Analytics is an advanced analytics solution that provides powerful capabilities for headcount analysis. The solution enables organizations to create sophisticated headcount models, analyze trends in headcounts, and forecast future headcount requirements, costs, and risks. The solution also provides a user-friendly interface, integrates seamlessly with a variety of data sources, provides advanced analytics features, enables robust collaboration and workflow, and includes security features that ensure the confidentiality and privacy of headcount data. If you’re looking to optimize your workforce and improve your HR practices, IBM Planning Analytics is a solution worth exploring. Interested in learning how to leverage your investment in Planning Analytics by adding headcount analysis into your environment? Let us know – we can help!

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: PAW Set Editor Remove Duplicates

IBM Planning Analytics Tips & Tricks: Popular Posts, Part 1

IBM Planning Analytics Tips & Tricks: Run TI Processes from PAx Task Pane

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Cognos TM1, IBM Planning Analytics, TM1

Enterprise Planning Helps Professional Services Firms Adapt to Changes

June 23, 2023 by Revelwood

FP&A Done Right

Professional services firms make money based on the number of hours they service clients. These companies need to have many consultants with desirable skills as billable as possible. They also have to have enough resources available to start new projects as soon as the contracts are signed. In short, professional services firms need to make the best use of the people they have, understand the needs they will have in the future and then appropriately plan for changes in a dynamic market with a history of being a “lumpy” business.

This can present a big challenge. In fact, according to Workday, “Only 29% of professional services leaders say they are confident in their organization’s current financial and business plans.”

This is where enterprise planning can help. With enterprise planning, professional services firms can easily perform demand planning, which can then integrate with project revenue planning, financial forecasting and reporting. These models use the same data and provide the firm with consistent and accurate information. 

Enterprise planning is a key resource for these firms. Professional services companies can perform ad-hoc analysis, asking questions of the data, such as:

  • How many consultants are available/currently “sitting on the bench,” not earning revenue?
  • What skill sets do our current consultants have and what skills are missing?
  • Which new projects are best served by onshore staffing and which new projects are best served by offshore staffing?
  • Do we have enough staff to take on this new project?
  • If a project ends unexpectedly, what existing projects can use those resources?
  • Are we optimizing our people in the most profitable way?

Learn why more and more professional services firms are embracing enterprise planning. Watch our latest webinar on Streamlining Professional Business Services with Workday Adaptive Planning here.

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, Professional Business Services, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Waterfall Charts

June 20, 2023 by Revelwood

Did you miss our webinar on waterfall charts in IBM Planning Analytics? Here’s our take on best practices and how and why to use waterfall charts.

Waterfall charts, also known as bridge charts, floating column charts, or cascade charts, are a data visualization tool used to represent changes in a value over time. They are particularly useful for showing how a specific value, such as a company’s profit or revenue, has changed from one period to another and the impact of different components on this change.

Waterfall charts are named after their appearance – the bars in the chart resemble a waterfall cascading downward. In a common example, the initial value is displayed as the starting point, and each segment of the waterfall represents the change in value due to certain factors. The length of each bar segment represents the size of the change, with upward bars indicating increases and downward bars representing decreases.

One of the advantages of using a waterfall chart is that it helps users easily identify the contribution of each component to the overall value. For example, a waterfall chart can show the contribution of different revenue streams to a company’s total revenue, thereby highlighting areas of strength and weakness in the company’s income stream.

Another common usage of waterfall charts is to show how an investment or project has affected the financial performance of a company. For instance, a waterfall chart can demonstrate the cost and revenue distribution of a new product development project over time. This can help in identifying areas where costs could be optimized or where revenue could be increased.

In enterprise planning and analytics, waterfall charts are crucial in depicting the impact of different scenarios, period-over-period comparisons, and identifying performance gaps. These charts allow professionals to identify key drivers of revenue or costs and identify areas that require improvement. It is also useful for businesses to use waterfall charts to identify performance trends, forecast trends based on prior data, and determine areas that require resource allocation.

Creating a Waterfall Chart

Creating a waterfall chart is relatively easy. A waterfall chart can include as many segments as required to represent the changes that need to be visualized.

To create a waterfall chart in Excel, start by creating a table that contains the total initial value and the changes in value. The table should represent a timeline that goes from left to right. The first column will contain a description of the different components that make up the initial value. The second column will display the size of the initial value. The subsequent columns will display the changes that occur within each segment. Each column will represent a change in the value of the previous column, either positive or negative. For example, a positive value could represent an increase in sales revenue, while a negative value could represent a rise in production costs.

Once the table has been created in Excel, the next step is to insert a waterfall chart. Select the table contents, including the initial value, then select “Insert” on the top menu bar and choose the “Waterfall Chart” type. The chart will then be created, showing each segment’s component and how it contributes to the overall value.

When using Planning Analytics, the process follows a similar outline. You will first need to create a table that houses the total initial value and the changes in value across time. The processes available with Planning Analytics are more user-friendly and automated than those of Excel, making the analysis of the chart trend even easier.

Waterfall charts are a critical representation tool in enterprise planning and analytics. They play a significant role in identifying the drivers of revenue or performance, identifying gaps in performance, and providing a retrospective review of trends in a business’s performance. Furthermore, the ability to create data-driven visualizations in IBM Planning Analytics and Microsoft Excel (amongst other tools) has allowed businesses to quickly adapt to new data insights. As a result, they are valuable tools in every data-savvy professional’s toolkit.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Planning Analytics Workspace (PAx) Zoom Bar

IBM Planning Analytics Tips & Tricks: HTTPPORTNUMBER

IBM Planning Analytics Tips & Tricks: Popular Posts, Part 2

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, IBM Cognos TM1, IBM Planning Analytics, TM1, waterfall chart

IBM Planning Analytics Tips & Tricks: HTTPPORTNUMBER

June 6, 2023 by Marc Assenza

Did you know that when you create a new TM1 / IBM Planning Analytics instance that the HTTPPORTNUMBER parameter is required?  This setting is placed within the TM1S.cfg file for your model.

Some things to note when defining the HTTPPORTNUMBER parameter:

  1. 1. The valid port values are between 5000 and 49151.
  2. 2. The configuration like will look something like this:

HTTPPORTNUMBER=5005

  1. 3. The port used must be unique on the server for any service, not just TM1 / PA database services.
  1. 4. If you forget to assign a value within the TM1S.cfg file, then Port 5001 is automatically assigned to the model.  This is important for multiple reasons:
  1. a. Port 5001 may already be being utilized by another service which will prevent the TM1 / PA server instance from starting
  1. b. If you have multiple TM1/PA models on the server and none of the TM1S.cfg files have the HTTPPORTNUMBER parameter defined, then the first server instance will start (if port 5001 is not currently being utilized).  Every other TM1 /PA instance will then fail because each will also try to use Port 5001, but the port is already used.

That’s it!  Just something to keep in mind when creating new TM1 / PA models on your server!

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Popular Posts, Part 2

IBM Planning Analytics Tips & Tricks: PAW Set Editor Remove Duplicates

IBM Planning Analytics Tips & Tricks: Popular Posts, Part 1

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: UNIQUE Function in Excel

April 4, 2023 by Revelwood

Have you ever needed to produce a list of unique values within a cell range in Excel?  If so, the UNIQUE function can do this.

The example below shows a simple list of countries that includes some duplicates:

Table

Description automatically generated

To produce a unique list, simply pass the cell range of the original list into the UNIQUE function.

Application, table, Excel

Description automatically generated

The unique list of values will “spill” down from the original UNIQUE formula. 

Table

Description automatically generated

This approach will give you a quick and easy way to get unique values from a cell range.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 2

IBM Planning Analytics Tips and Tricks: Upgrading to Planning Analytics for Excel 2.0.65 or later

IBM Planning Analytics Tips & Tricks: Excel YEARFRAC

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, TM1

IBM Planning Analytics Tips & Tricks: On-Demand Webinars, Part 2

March 28, 2023 by Revelwood

Did you know we have a wide variety of IBM Planning Analytics webinars on-demand? We showcased two of our most popular webinars – Best Practices when Using Planning Analytics Workspace Charts and Creating PAW Charts Using the New Experience – in a recent blog post. 

Here are two more of our popular IBM Planning Analytics / TM1 on-demand webinars. 

Best Practices for Using TurboIntegrator

This webinar showcases some features of TurboIntegrator that you may not be using. We cover a series of functions and offer best practices for using them. We describe each function, explain how we use the function when creating models, and discuss the benefits you get by using these approaches.

Here are a few of the topics we review:

  • Making calls outside of a process
  • Modifying dimension structures
  • Creating views and subsets

 Best Practices When Using Hierarchies in IBM Planning Analytics

In this webinar, we explain the concepts, the creation and the things to consider when using hierarchies within their existing models. We show examples of hierarchies that Revelwood clients use and how they create new reports and analyses.

IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 2

IBM Planning Analytics Tips & Tricks: Excel EOMONTH

IBM Planning Analytics Tips & Tricks: Excel Tips, Part 1

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, IBM Planning Analytics, IBM Planning Analytics Tips & Tricks, Planning Analytics Tips & Tricks, TM1

Embracing Forward-Looking and Customer-Centric KPIs

March 17, 2023 by Revelwood

This is a blog post from our partner Workday Adaptive Planning, highlighting a virtual panel discussion on “The Emerging CFO: Rethinking KPIs in the Digital Era.”

Revenue. Profit. Sales. Cash. The metrics that have traditionally defined business success remain relevant but are quickly evolving. Today, more executives are shifting their focus to bring forward-looking key performance indicators (KPIs) into the mix.

From customer lifetime value (CLV) to net retention rate (NRR) to customer satisfaction (CSAT), CFOs are looking to nonfinancial metrics to help them predict the future financial health and profitability of their organizations. Of particular note is the move toward more customer-focused metrics, a reaction to an increasingly data-driven consumer.

“The fact that every single customer you have has a supercomputer in their purse or their pocket changes the way that we can analyze data and engage with people,” said Michael Schrage, research fellow at the MIT Sloan School Initiative on the Digital Economy, in a virtual panel hosted by Fortune and Workday. 

A broader, more holistic set of KPIs lets finance leaders make proactive, strategic decisions rather than simply reacting to change. The idea, Schrage said, is to move toward more future-predictive, future-orientated KPIs versus ones that simply confirm that an organization made a wrong move. “That doesn’t help you very much,” he said. 

The panel, which discussed the evolving role of the CFO, also included Harmit Singh, executive vice president and CFO at Levi Strauss & Co.; Alka Tandan, CFO at Gainsight; and Kae Arima, vice president of finance at Workday. The conversation revolved around how KPIs are changing in the digital era and how CFOs must shift their perspective. 

Where Is the Juice Worth the Squeeze?

As data becomes easier to collect and analyze, business leaders are turning to measurement, instrumentation, and analytics to gain insights around performance. They’re also assessing the portfolio of KPIs across the enterprise to see how specific metrics correlate. For instance, does a positive employee experience correspond to higher customer lifetime value? How do both of those KPIs affect the bottom line? 

Looking at a broader portfolio of KPIs lets leaders understand where work is producing the most valuable results. For example, going beyond gross customer retention rates to NRR helps leaders understand which customer segments are stable, which ones are growing—and how much effort it takes to cultivate that growth.

“Especially in an environment where money is now a lot more expensive and it takes a lot more money to acquire a new customer, looking at your current customer base and growing it that way becomes a lot more efficient,” Tandan said.

Taking a more holistic view of data can also help leaders see which teams are doing the most to achieve business goals. Determining what portion of customer lifetime value growth can be attributed to sales, customer success, and operations, for example, offers insights that could inform future strategies and investments.

How Do You Get Hard Numbers?

Going forward, CFOs will need to more actively identify what attributes are associated with success, so the organization can update and monitor KPIs accordingly. But getting there requires access to reliable, real-time business intelligence—and data doesn’t flow freely across many organizations. 

“For something like customer lifetime value, finance is really dependent on the sales organization or the marketing organization to share that data with them. And that’s not always easy,” Arima said. 

Singh recounted his experience during his early days at Levi’s, which was a highly customized systems, applications, and products shop when he came on board. Each region had its own enterprise resource planning (ERP) tool and the company had more than 10 data warehouses. 

“And so the data didn’t necessarily talk to each other, and people were using different ERPs that didn’t talk to each other,” Singh said. At the time, he suggested moving the company onto a single ERP system, but he was told it would be a career-limiting move and that he should focus on turning around the company first. So, he moved the data into one warehouse that is now being converted into a single ERP system on the cloud. 

“I told my technology folks—including the board because it’s a major investment—that the success of the ERP is not going to be driven by the technology,” Singh said. “It’s going to be driven by the data unlock and the data governance that is going to happen.”

Who Owns All That Data?

Real-time data platforms can also boost performance on the front lines. “We connect with our consumers either through retailers or directly in our stores,” Singh said. “So, arming our retail associates with data and empowering them to make decisions based on data is critical.” 

Giving employees information about customer buying trends could help them focus their attention on the right upselling decisions. It also helps store managers see where their location may be underperforming and find ways to improve. Store managers can also input their own observations on what’s working and what isn’t into company apps that associates can access.

However, giving teams access to customer and operational data requires strong data governance—and agreement across the enterprise. But leaders often disagree about who owns particular KPIs, how they should be shared, and who is accountable, which means CFOs will need to play a larger role in closing the gap and arbitrating conflict. That’s been the case at Gainsight, where Tandan says she has taken on the responsibility for data validation. This helps ensure there is a single source of truth the executive team can work from.

The organization also identifies which executives are responsible for key metrics and creates a one-page strategic plan for each employee based on the KPIs and the executives responsible for them.

“So every single employee—if they’re attached to that executive—has a piece of [that metric],” Tandan said.

Regularly reviewing KPIs to ensure they’re in alignment with current business conditions is critical, Tandan said. That way, CFOs can ensure that their organizations remain relevant in a rapidly changing economic environment.

Watch the Fortune webcast: “The Emerging CFO: Rethinking KPIs in the Digital Era.” This blog post was originally published on the Workday blog.

More from Workday Adaptive Planning:

FP&A Done Right: ESG – An Imperative for Growth

FP&A Done Right: Forecasting Revenue for Services-Based Businesses: A Growth Factor

FP&A Done Right: The Changing Role of the CFO

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, Workday, Workday Adaptive Planning

IBM Planning Analytics Tips & Tricks: Excel YEARFRAC

March 14, 2023 by Lee Lazarow

I often build models that define the fraction of a year for a given month. For example, January is approx. 8.5% of a calendar year (31/365) and September is approx. 11.5% of a working day’s calendar (30/260). But what happens in situations when you want to calculate the percentage of a year where the days are not the first or last day of the month? This is where Excel’s YEARFRAC formula can help.

The YEARFRAC function calculates the fraction of a year based on the number of whole days between two dates. Maybe you have summer employees and want to determine how much of the calendar year they will be employed or maybe you need to rent some equipment and pay based on an annual rate.

The function has two required parameters and one optional parameter:

=YEARFRAC(start_date, end_date, [basis])

  • Start_date (required)
    • Microsoft recommends using the DATE function for this value
  • End_date (required)
    • Microsoft recommends using the DATE function for this value
  • Basis (optional)
    • This determines the denominator using a series of approaches such as 360 vs 365 and whether you want to include the start date

Application, table, Excel

Description automatically generated

This function will allow you to quickly calculate decimals which can then be used for various forms of allocations, seasonality, and other types of spreads.

Revelwood has worked with IBM Planning Analytics / TM1 for more than 27 years. We’ve partnered with hundreds of companies on the design, development, maintenance and updates of IBM Planning Analytics applications, across every industry. Have a challenge with Planning Analytics / TM1? We can help you!

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: 21/21/21

IBM Planning Analytics Tips & Tricks: Beginning to Explore the Set Editor in Planning Analytics for Excel

IBM Planning Analytics Tips & Tricks: Creating Control Objects from the Modeling Workbench

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, IBM Planning Analytics, TM1

Fueling Business Agility with Continuous Planning

March 3, 2023 by Revelwood

FP&A Done Right: Finance’s Role in ESG Reporting

This is a guest blog post from our partner Workday Adaptive Planning. The author, Bob Hansen, explaining how continuous planning enables business agility. 

Each finance leader knows the routine. Every year, as budgeting season approaches, the rest of the business turns to finance in order to make sense of the last 12 months and prepare for the next 12.

First, you look backward, to assess the progress toward last year’s stated objectives. You work with manually aggregated data and consolidated spreadsheets (both often error-prone) to discover results and generate reports. You analyze targets, performance, and spending to provide the business with an accurate reflection of its financial position.

And then you look forward, using that information to plan next year’s objectives. You think about future goals and enshrine them in a firm financial strategy. You make choices, assess trade-offs, and accept sacrifices. You settle on a new top-line target and divide it into contributions between different functional teams.

Then—after spending weeks or months laboring over the annual plan—by the time it’s finished, the market has changed dramatically and its assumptions are out of date.

Case in point: The disruption caused by COVID-19. Or even more recently, an economy with surprising, seemingly contradictory indicators. But there’s a better way: continuous planning.

Looking Ahead

Continuous planning gives financial planning and analysis (FP&A) organizations a real-time view of the business. When decision-makers have the ability to understand what’s happening with the business now, they can accurately model what is likely to happen in the future. Unlike outdated, static planning, continuous planning enables agility with plans that are always current, insight with easily created and iterated what-if scenarios.

Instead of being once-a-year exercises, rolling forecasts happen on a regular cadence. Unlike budgets that may have hundreds of line items, rolling forecasts address key business drivers. And rather than focusing on the past, rolling forecasts act as early warning systems when you’ve drifted off course; they help to raise visibility beyond the traditional budgeting “wall.” By continually updating your forecast with actuals, you’ll be able to quickly adjust the levers that drive performance.

Here’s a three-step plan to help you design more useful rolling forecasts:

1. Choose the right forecasting horizon.

A rolling forecast is aligned to business cycles, rather than the fiscal year. To really help senior management look at the future and proactively handle it, a best practice is to forecast at least four to eight quarters past the current quarter’s actuals. However, there’s no hard-and-fast guideline for the time interval included in a rolling forecast. It all depends on your industry, your business needs, and how long it takes to make decisions about operations, capacity, and spending. 

2. Model your course on drivers not details.

Yes, your annual budget lists thousands of line items, but you need to perform rolling forecasts at a much higher level, or you’ll get bogged down in minutiae and your forecast will become a recompilation of budgets. Rolling forecasts based on key business drivers, rather than masses of detail, also become a “light-touch” process and therefore less onerous for everyone involved. Managers may mutiny if they think that rolling forecasts will require the work of a full budget, but they’ll be much more engaged if they know they can zero in on the few key variables that matter.

3. Sound out multiple what-if scenarios.

The beauty of rolling forecasts is they allow you to model what-if scenarios to ensure your business keeps pace with change and is aligned to your corporate plan. By modifying a few key assumptions and drivers, you can see their effect on the overall plan, such as the impact a price change has on headcounts and cash. For example, with what-if analyses, managers can perform studies that translate contemplated changes in product mix, processes, order parameters, and customer service into the implications for changes in resource supply and spending.

Executing Against Your Scenarios

Executing against your what-if analyses and scenario plans shouldn’t only happen once a year as part of a static annual budget and planning process. A changing marketplace calls for active, continuous planning and monitoring that gives decision-makers the real-time information they need to course-correct as needed. The ability to create scenario plans to assess potential outcomes (best case, worst case, most likely case) is extremely valuable when variables are constantly changing around and within your business.

At a minimum, this means continuously monitoring actuals so you can keep an eye on organizational financial health. It also means keeping track of your leading analytics indicators (e.g., pipeline, customer lifetime value, attrition), so you can identify trends and patterns and recommend course corrections when needed.

To execute against your scenario plans, you need to have access to easy-to-use, flexible, and robust reporting that captures all of the above, and does so on a continuous basis. And when the gathering, reconciliation, and distribution of your reports is automated, you’ll be able to transform reporting processes from a monthly rote exercise to a dynamic, ongoing driver of organizational change.

With a continuous view of the business, everyone in the company will be empowered to plan and see the results of the implementation and the execution of those plans.This blog post was originally published on the Workday Adaptive Planning blog.

More from Workday Adaptive Planning:

FP&A Done Right: ESG – An Imperative for Growth

FP&A Done Right: Forecasting Revenue for Services-Based Businesses: A Growth Factor

FP&A Done Right: The Changing Role of the CFO

Home » Budgeting Planning & Forecasting » Page 5

Filed Under: FP&A Done Right Tagged With: Budgeting Planning & Forecasting, Financial Performance Management, Workday, Workday Adaptive Planning

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 3
  • Page 4
  • Page 5
  • Page 6
  • Page 7
  • Interim pages omitted …
  • Page 26
  • Go to Next Page »

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.