|By Jon Kondo||
|February 1, 2012 08:00 AM EST||
Everyone wants a crystal ball to be able to peer into the future. For businesses, that desire becomes a necessity because having a vision of the future allows for better and more strategic decision making in the present.
Rolling forecasts built on driver-based and project-based planning do just that, creating a framework that supports better decision making. A rolling forecast simply means that each quarter or month, a company projects four to six quarters or 12 to 18 months ahead.
This allows executives and key decision-makers to see both a financial and operational vision of the future. It also helps them assess next steps in their execution of their plan, understand critical pivot points in the plan and better judge the impact the economy may have on their plan.
We have seen rolling forecasts can replace annual planning cycles with a continual planning process that results in more regular business reviews that look to the future. These reviews enable managers to understand problems, challenges and trends sooner and improve their proactive approach to those problems, challenges and trends.
Here are the top 10 best practices for implementing them:
1. You need a system and Excel is not a system (it's a personal productivity tool). In the next nine best practices we will outline functionality and practices that will outstrip the capability of Excel spreadsheets. The challenge we have seen arises when companies start rolling forecasts in Excel and then can't keep them up to date because it isn't just a single forecast. Once a baseline forecast is created, additional analysis/versions will be required to:
- Understand the impact of major and minor alterations to the plan
- Run the plan against different drivers
- Copy the plan as a baseline for other plans
- Perform variance and sensitivity analysis
To get the most out of rolling forecasts you need a system that can provide the necessary functionality to accommodate your budget, forecasting, planning, strategic management and measurement needs. Excel will be to labor intensive, prone to error and too difficult to provide the reporting.
2. Understand your objectives of creating a rolling forecast. This will drive all of the other best practices related to rolling forecasts. While the overall objective of planning is to a) create a financial view of the vision for the future and to know the decisions you need to make and b) understand the financial impact of those decisions before you need to make them, your objectives and focus for the rolling forecast will dictate the areas of the plan that need more detail. As an example:
- If your strategic plan calls for acquisitions you may consider building the plan with a high-level summary input of drivers that help plan for acquisitions.
- If you want to better manage finished goods inventory you may focus more on customer/product forecasts and inventory management.
- If cash is tight you will want to focus on timing of events around cash, i.e., payables and receivables policies, cash borrowings, line of credit.
The challenge is, there isn't one overriding holistic model format that allows you to account for all of these in a first pass rolling forecast implementation.
3. Identify the rolling forecast duration. The challenge with rolling forecast duration is it sounds easy until you put pen to paper and begin to implement it. There are a number of questions:
- Will you re-forecast every month or every quarter? (many of our customers re-forecast monthly)
- Will you add a new month to every forecast or just add a new quarter at quarter end? (our customers either add new periods quarterly or start planning for a two year time frame)
- How long should the rolling forecast be--12 months 15 months 18 months, or should you start by forecasting out two years and at the end of the first year tack on another year?
- How will the mechanics work of rolling in actual?
As a starting point, make sure your forecasting time frames are consistent with your business cycle and business needs. If sales 15 months from now are dependent on capital expenditures today, it is important to create rolling forecasts out past 15 months. It is also important to have a minimum of quarterly bias to the rolling forecast. That is, don't tack on an additional month to a rolling forecast at the end of every month, wait until quarter end and then add a new quarter, otherwise each month you are making preparers think about a new forecast period.
4. Identify the rolling forecast comparison periods. While this sounds relatively straightforward, it gets tricky when you consider the need for comparison columns in reporting. It is tricky because you need to compare to multiple periods/combinations of actual and forecast. With annual plans we compare the combination current year actual for closed periods and forecast for remaining periods to last year actual. We think in terms of annual sales and annualized expenses. With rolling forecasts we need to also roll in the actual and shift the comparison periods. We must be able to not only provide annual comparisons, (i.e. How will this year compare to last year?, Where will we end up for this year?) but we also need to provide how this 12/15/18 month rolling plan compares to the 12/15/18 actual results. This requires access to roll the forecast periods but also roll the comparison periods, for not just actual, but also for prior year actual.
5. Understand/analyze the dynamics of revenue and expense in your business and their related drivers. Rolling forecasts won't work if you create them from a bottom up forecast every quarter--they need to be driver based. This provides flexibility in the planning process and agility when you re-plan or create alternate plans. It also helps managers focus on what is really important. Over time, some of the drivers will be replaced if they are found as an inconsistent predictor of results and the stronger drivers will evolve to KPIs and used for goal setting. In addition, over time forecasts will also start to use consistent models and model drivers.
As an example, sales units should drive production volumes. Price increases could drive (or be driven by) material and labor cost increases.
To help understand what drives your business you can ask these questions:
- How does this line item affect our bottom line?
- Will $1 (pick appropriate unit of measure, thousands, millions, billions) in sales affect this account?
- How does this number change our bottom line?
To be successful doing rolling forecasts it is important to use drivers to eliminate detail while creating a realistic expectation about the future.
6. Plan capital and strategic projects separately from the rolling forecast. Capital and strategic projects should be layered separately into the plan. Projects have two unique characteristics that require this:
- They are time independent of a typical rolling forecast. Projects can last months to years and treating them with the same duration as a forecast doesn't provide the complete story around the projects.
- They typically have a lot of dependencies which means project expenditures can be moved out or in a plan for a variety of reasons.
Projects should be treated as separate entity/profit center and have the ability to be move in and out of rolling forecasts. In addition they should have the ability to move time frames and adjust for changes in project scope.
7. Start with a small select group of key department/operations managers, plan on increasing the scope over time and plan on continual improvement over time. While conventional wisdom is to involve as many participants as possible, many companies find it easier to start with a small group that cuts across the major departments and gradually involve more executives, lines of business managers and operational managers as processes, methods are refined. Let the small group get some practice with the process. It will help flush out the process and the more practice they have at preparing forecasts, the better they will become and the more mentoring they can provide as you add additional participants. Typically there is a risk (including career risk) if you roll something out that isn't totally baked or based on theory, which could result in confusion, especially if you are doing it with a large group within the company.
As you expand the scope of the plan and the more people share in the plan the closer to reality the plan will be and the better the execution.
In addition you should plan for and build in a process of continual improvement. Managers should learn from their forecast accuracy record by carrying out postmortems on forecast. The objective is not to punish the guilty but to better understand how to do better, what changed, what were we surprised about, where what should we do differently to turn out better forecasts. To improve forecast, it is important to understand the cause for variability and learn to reduce them through postmortems.
8. Consider the rolling forecast as your baseline plan. Once you have the completed rolling forecast for the period/month, use it as your baseline plan. From this plan finance can massage drivers, adjust values and analyzing alternate scenarios, black swan events and potential significant events, to create a picture of alternate futures and be prepared to make decisions if situations arise.
This does requires the flexibility in the tool you are using to "mash up" scenarios and compare scenarios from different sources.
9. Tie your rolling forecast to your strategic plan. Rolling forecasts, if well prepared, form the backbone of a new and much more useful information system that connects all the pieces of the organization and gives senior management a continuous picture of both the current position and the short term outlook.
10. Analyze/understand how external conditions impact your performance. Business does not operate in a vacuum. Plan on qualifying the key external drivers of your business.
Do not confuse rolling forecasts with targets you receive your bonus on. Regarding targets and profitability, is it better to hit your target or gain targeted market share? Leading organizations are placing forecasting at the center of the management process. It becomes the essential tool for business managers to support their decision making, not just another management chore that needs to be done and they are basing targets not on fixed revenue numbers but rather percentages based on external market indicators.
Adaptive organizations focus less on annual budgets targets or long-term views/targets generated from within the company based on incremental sales and income year over year and focus more on rolling views and goals based on market conditions like achieving market share or achieving cost efficiencies over the competition by benchmarking against competition or similar public companies.
As you consider implementing rolling forecasts remember the purpose is to provide a vision for the future and support better decisions. If you try to motivate behavior based on this forecast the results and plans get skewed and the usefulness of the solution is compromised. Forecasts should not be used by executive management as a tool for questioning or reassessing performance targets. This means forecasts and targets must be independent if you want to obtain both relevant action plans and reliable forecasts that allow risks and opportunities to be identified and corrective action taken in the best interest of the company (which may be in conflict with the target). If you do merge the two, the term "sandbagging" comes to mind.
Many businesses have yet to discover the full benefits of evolving their planning process to include complete and accurate rolling forecasts. With so many external factors that affect the bottom line for these businesses, including the volatility of the economy, creating rolling forecasts is a sound way to ensure strategic decisions are made. Businesses need an accurate picture of a future in order to chart a course towards it.
SYS-CON Events announced today that SoftLayer, an IBM Company, has been named “Gold Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. SoftLayer, an IBM Company, provides cloud infrastructure as a service from a growing number of data centers and network points of presence around the world. SoftLayer’s customers range from Web startups to global enterprises.
Mar. 29, 2017 03:15 PM EDT Reads: 2,207
SYS-CON Events announced today that CA Technologies has been named “Platinum Sponsor” of SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY, and the 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. CA Technologies helps customers succeed in a future where every business – from apparel to energy – is being rewritten by software. From ...
Mar. 29, 2017 02:30 PM EDT Reads: 2,272
SYS-CON Events announced today that Technologic Systems Inc., an embedded systems solutions company, will exhibit at SYS-CON's @ThingsExpo, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Technologic Systems is an embedded systems company with headquarters in Fountain Hills, Arizona. They have been in business for 32 years, helping more than 8,000 OEM customers and building over a hundred COTS products that have never been discontinued. Technologic Systems’ pr...
Mar. 29, 2017 02:30 PM EDT Reads: 3,802
SYS-CON Events announced today that Auditwerx will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Auditwerx specializes in SOC 1, SOC 2, and SOC 3 attestation services throughout the U.S. and Canada. As a division of Carr, Riggs & Ingram (CRI), one of the top 20 largest CPA firms nationally, you can expect the resources, skills, and experience of a much larger firm combined with the accessibility and attent...
Mar. 29, 2017 02:30 PM EDT Reads: 667
SYS-CON Events announced today that HTBase will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. HTBase (Gartner 2016 Cool Vendor) delivers a Composable IT infrastructure solution architected for agility and increased efficiency. It turns compute, storage, and fabric into fluid pools of resources that are easily composed and re-composed to meet each application’s needs. With HTBase, companies can quickly prov...
Mar. 29, 2017 02:15 PM EDT Reads: 3,251
SYS-CON Events announced today that Loom Systems will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Founded in 2015, Loom Systems delivers an advanced AI solution to predict and prevent problems in the digital business. Loom stands alone in the industry as an AI analysis platform requiring no prior math knowledge from operators, leveraging the existing staff to succeed in the digital era. With offices in S...
Mar. 29, 2017 01:30 PM EDT Reads: 1,743
Buzzword alert: Microservices and IoT at a DevOps conference? What could possibly go wrong? In this Power Panel at DevOps Summit, moderated by Jason Bloomberg, the leading expert on architecting agility for the enterprise and president of Intellyx, panelists peeled away the buzz and discuss the important architectural principles behind implementing IoT solutions for the enterprise. As remote IoT devices and sensors become increasingly intelligent, they become part of our distributed cloud enviro...
Mar. 29, 2017 12:15 PM EDT Reads: 7,899
SYS-CON Events announced today that T-Mobile will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. As America's Un-carrier, T-Mobile US, Inc., is redefining the way consumers and businesses buy wireless services through leading product and service innovation. The Company's advanced nationwide 4G LTE network delivers outstanding wireless experiences to 67.4 million customers who are unwilling to compromise on ...
Mar. 29, 2017 11:45 AM EDT Reads: 2,574
SYS-CON Events announced today that Infranics will exhibit at SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Since 2000, Infranics has developed SysMaster Suite, which is required for the stable and efficient management of ICT infrastructure. The ICT management solution developed and provided by Infranics continues to add intelligence to the ICT infrastructure through the IMC (Infra Management Cycle) based on mathemat...
Mar. 29, 2017 11:00 AM EDT Reads: 3,437
SYS-CON Events announced today that Interoute, owner-operator of one of Europe's largest networks and a global cloud services platform, has been named “Bronze Sponsor” of SYS-CON's 20th Cloud Expo, which will take place on June 6-8, 2017 at the Javits Center in New York, New York. Interoute is the owner-operator of one of Europe's largest networks and a global cloud services platform which encompasses 12 data centers, 14 virtual data centers and 31 colocation centers, with connections to 195 add...
Mar. 29, 2017 10:15 AM EDT Reads: 1,728
SYS-CON Events announced today that Cloudistics, an on-premises cloud computing company, has been named “Bronze Sponsor” of SYS-CON's 20th International Cloud Expo®, which will take place on June 6-8, 2017, at the Javits Center in New York City, NY. Cloudistics delivers a complete public cloud experience with composable on-premises infrastructures to medium and large enterprises. Its software-defined technology natively converges network, storage, compute, virtualization, and management into a ...
Mar. 29, 2017 10:00 AM EDT Reads: 2,342
In his session at @ThingsExpo, Eric Lachapelle, CEO of the Professional Evaluation and Certification Board (PECB), will provide an overview of various initiatives to certifiy the security of connected devices and future trends in ensuring public trust of IoT. Eric Lachapelle is the Chief Executive Officer of the Professional Evaluation and Certification Board (PECB), an international certification body. His role is to help companies and individuals to achieve professional, accredited and worldw...
Mar. 29, 2017 08:45 AM EDT Reads: 944
In his General Session at 16th Cloud Expo, David Shacochis, host of The Hybrid IT Files podcast and Vice President at CenturyLink, investigated three key trends of the “gigabit economy" though the story of a Fortune 500 communications company in transformation. Narrating how multi-modal hybrid IT, service automation, and agile delivery all intersect, he will cover the role of storytelling and empathy in achieving strategic alignment between the enterprise and its information technology.
Mar. 29, 2017 08:00 AM EDT Reads: 7,553
Microservices are a very exciting architectural approach that many organizations are looking to as a way to accelerate innovation. Microservices promise to allow teams to move away from monolithic "ball of mud" systems, but the reality is that, in the vast majority of organizations, different projects and technologies will continue to be developed at different speeds. How to handle the dependencies between these disparate systems with different iteration cycles? Consider the "canoncial problem" ...
Mar. 29, 2017 06:00 AM EDT Reads: 9,077
The Internet of Things is clearly many things: data collection and analytics, wearables, Smart Grids and Smart Cities, the Industrial Internet, and more. Cool platforms like Arduino, Raspberry Pi, Intel's Galileo and Edison, and a diverse world of sensors are making the IoT a great toy box for developers in all these areas. In this Power Panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists discussed what things are the most important, which will have the most profound e...
Mar. 29, 2017 04:00 AM EDT Reads: 15,128
Keeping pace with advancements in software delivery processes and tooling is taxing even for the most proficient organizations. Point tools, platforms, open source and the increasing adoption of private and public cloud services requires strong engineering rigor - all in the face of developer demands to use the tools of choice. As Agile has settled in as a mainstream practice, now DevOps has emerged as the next wave to improve software delivery speed and output. To make DevOps work, organization...
Mar. 29, 2017 03:45 AM EDT Reads: 2,177
My team embarked on building a data lake for our sales and marketing data to better understand customer journeys. This required building a hybrid data pipeline to connect our cloud CRM with the new Hadoop Data Lake. One challenge is that IT was not in a position to provide support until we proved value and marketing did not have the experience, so we embarked on the journey ourselves within the product marketing team for our line of business within Progress. In his session at @BigDataExpo, Sum...
Mar. 29, 2017 03:30 AM EDT Reads: 3,265
Web Real-Time Communication APIs have quickly revolutionized what browsers are capable of. In addition to video and audio streams, we can now bi-directionally send arbitrary data over WebRTC's PeerConnection Data Channels. With the advent of Progressive Web Apps and new hardware APIs such as WebBluetooh and WebUSB, we can finally enable users to stitch together the Internet of Things directly from their browsers while communicating privately and securely in a decentralized way.
Mar. 29, 2017 03:00 AM EDT Reads: 6,104
DevOps is often described as a combination of technology and culture. Without both, DevOps isn't complete. However, applying the culture to outdated technology is a recipe for disaster; as response times grow and connections between teams are delayed by technology, the culture will die. A Nutanix Enterprise Cloud has many benefits that provide the needed base for a true DevOps paradigm.
Mar. 29, 2017 01:15 AM EDT Reads: 2,541
What sort of WebRTC based applications can we expect to see over the next year and beyond? One way to predict development trends is to see what sorts of applications startups are building. In his session at @ThingsExpo, Arin Sime, founder of WebRTC.ventures, will discuss the current and likely future trends in WebRTC application development based on real requests for custom applications from real customers, as well as other public sources of information,
Mar. 29, 2017 01:00 AM EDT Reads: 1,144