|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.
Too often with compelling new technologies market participants become overly enamored with that attractiveness of the technology and neglect underlying business drivers. This tendency, what some call the “newest shiny object syndrome,” is understandable given that virtually all of us are heavily engaged in technology. But it is also mistaken. Without concrete business cases driving its deployment, IoT, like many other technologies before it, will fade into obscurity.
Aug. 31, 2015 09:00 PM EDT Reads: 364
The Internet of Things is in the early stages of mainstream deployment but it promises to unlock value and rapidly transform how organizations manage, operationalize, and monetize their assets. IoT is a complex structure of hardware, sensors, applications, analytics and devices that need to be able to communicate geographically and across all functions. Once the data is collected from numerous endpoints, the challenge then becomes converting it into actionable insight.
Aug. 31, 2015 07:00 PM EDT
Consumer IoT applications provide data about the user that just doesn’t exist in traditional PC or mobile web applications. This rich data, or “context,” enables the highly personalized consumer experiences that characterize many consumer IoT apps. This same data is also providing brands with unprecedented insight into how their connected products are being used, while, at the same time, powering highly targeted engagement and marketing opportunities. In his session at @ThingsExpo, Nathan Treloar, President and COO of Bebaio, will explore examples of brands transforming their businesses by t...
Aug. 31, 2015 06:00 PM EDT Reads: 243
With the Apple Watch making its way onto wrists all over the world, it’s only a matter of time before it becomes a staple in the workplace. In fact, Forrester reported that 68 percent of technology and business decision-makers characterize wearables as a top priority for 2015. Recognizing their business value early on, FinancialForce.com was the first to bring ERP to wearables, helping streamline communication across front and back office functions. In his session at @ThingsExpo, Kevin Roberts, GM of Platform at FinancialForce.com, will discuss the value of business applications on wearable ...
Aug. 31, 2015 03:15 PM EDT
While many app developers are comfortable building apps for the smartphone, there is a whole new world out there. In his session at @ThingsExpo, Narayan Sainaney, Co-founder and CTO of Mojio, will discuss how the business case for connected car apps is growing and, with open platform companies having already done the heavy lifting, there really is no barrier to entry.
Aug. 31, 2015 02:30 PM EDT Reads: 141
With the proliferation of connected devices underpinning new Internet of Things systems, Brandon Schulz, Director of Luxoft IoT – Retail, will be looking at the transformation of the retail customer experience in brick and mortar stores in his session at @ThingsExpo. Questions he will address include: Will beacons drop to the wayside like QR codes, or be a proximity-based profit driver? How will the customer experience change in stores of all types when everything can be instrumented and analyzed? As an area of investment, how might a retail company move towards an innovation methodolo...
Aug. 31, 2015 02:30 PM EDT Reads: 457
The Internet of Things (IoT) is about the digitization of physical assets including sensors, devices, machines, gateways, and the network. It creates possibilities for significant value creation and new revenue generating business models via data democratization and ubiquitous analytics across IoT networks. The explosion of data in all forms in IoT requires a more robust and broader lens in order to enable smarter timely actions and better outcomes. Business operations become the key driver of IoT applications and projects. Business operations, IT, and data scientists need advanced analytics t...
Aug. 31, 2015 02:30 PM EDT Reads: 418
Contrary to mainstream media attention, the multiple possibilities of how consumer IoT will transform our everyday lives aren’t the only angle of this headline-gaining trend. There’s a huge opportunity for “industrial IoT” and “Smart Cities” to impact the world in the same capacity – especially during critical situations. For example, a community water dam that needs to release water can leverage embedded critical communications logic to alert the appropriate individuals, on the right device, as soon as they are needed to take action.
Aug. 31, 2015 12:00 PM EDT
SYS-CON Events announced today that HPM Networks will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. For 20 years, HPM Networks has been integrating technology solutions that solve complex business challenges. HPM Networks has designed solutions for both SMB and enterprise customers throughout the San Francisco Bay Area.
Aug. 31, 2015 11:30 AM EDT Reads: 896
SYS-CON Events announced today that Micron Technology, Inc., a global leader in advanced semiconductor systems, will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Micron’s broad portfolio of high-performance memory technologies – including DRAM, NAND and NOR Flash – is the basis for solid state drives, modules, multichip packages and other system solutions. Backed by more than 35 years of technology leadership, Micron's memory solutions enable the world's most innovative computing, consumer,...
Aug. 31, 2015 11:15 AM EDT Reads: 230
As more intelligent IoT applications shift into gear, they’re merging into the ever-increasing traffic flow of the Internet. It won’t be long before we experience bottlenecks, as IoT traffic peaks during rush hours. Organizations that are unprepared will find themselves by the side of the road unable to cross back into the fast lane. As billions of new devices begin to communicate and exchange data – will your infrastructure be scalable enough to handle this new interconnected world?
Aug. 31, 2015 11:00 AM EDT Reads: 161
Through WebRTC, audio and video communications are being embedded more easily than ever into applications, helping carriers, enterprises and independent software vendors deliver greater functionality to their end users. With today’s business world increasingly focused on outcomes, users’ growing calls for ease of use, and businesses craving smarter, tighter integration, what’s the next step in delivering a richer, more immersive experience? That richer, more fully integrated experience comes about through a Communications Platform as a Service which allows for messaging, screen sharing, video...
Aug. 31, 2015 10:30 AM EDT Reads: 658
SYS-CON Events announced today that Pythian, a global IT services company specializing in helping companies leverage disruptive technologies to optimize revenue-generating systems, has been named “Bronze Sponsor” of SYS-CON's 17th Cloud Expo, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. Founded in 1997, Pythian is a global IT services company that helps companies compete by adopting disruptive technologies such as cloud, Big Data, advanced analytics, and DevOps to advance innovation and increase agility. Specializing in designing, imple...
Aug. 31, 2015 10:15 AM EDT Reads: 305
In his session at @ThingsExpo, Lee Williams, a producer of the first smartphones and tablets, will talk about how he is now applying his experience in mobile technology to the design and development of the next generation of Environmental and Sustainability Services at ETwater. He will explain how M2M controllers work through wirelessly connected remote controls; and specifically delve into a retrofit option that reverse-engineers control codes of existing conventional controller systems so they don't have to be replaced and are instantly converted to become smart, connected devices.
Aug. 31, 2015 09:30 AM EDT Reads: 124
SYS-CON Events announced today that IceWarp will exhibit at the 17th International Cloud Expo®, which will take place on November 3–5, 2015, at the Santa Clara Convention Center in Santa Clara, CA. IceWarp, the leader of cloud and on-premise messaging, delivers secured email, chat, documents, conferencing and collaboration to today's mobile workforce, all in one unified interface
Aug. 31, 2015 04:00 AM EDT Reads: 424
WebRTC has had a real tough three or four years, and so have those working with it. Only a few short years ago, the development world were excited about WebRTC and proclaiming how awesome it was. You might have played with the technology a couple of years ago, only to find the extra infrastructure requirements were painful to implement and poorly documented. This probably left a bitter taste in your mouth, especially when things went wrong.
Aug. 31, 2015 02:00 AM EDT Reads: 454
As more and more data is generated from a variety of connected devices, the need to get insights from this data and predict future behavior and trends is increasingly essential for businesses. Real-time stream processing is needed in a variety of different industries such as Manufacturing, Oil and Gas, Automobile, Finance, Online Retail, Smart Grids, and Healthcare. Azure Stream Analytics is a fully managed distributed stream computation service that provides low latency, scalable processing of streaming data in the cloud with an enterprise grade SLA. It features built-in integration with Azur...
Aug. 28, 2015 07:45 PM EDT Reads: 219
Akana has announced the availability of the new Akana Healthcare Solution. The API-driven solution helps healthcare organizations accelerate their transition to being secure, digitally interoperable businesses. It leverages the Health Level Seven International Fast Healthcare Interoperability Resources (HL7 FHIR) standard to enable broader business use of medical data. Akana developed the Healthcare Solution in response to healthcare businesses that want to increase electronic, multi-device access to health records while reducing operating costs and complying with government regulations.
Aug. 26, 2015 07:00 AM EDT Reads: 193
For IoT to grow as quickly as analyst firms’ project, a lot is going to fall on developers to quickly bring applications to market. But the lack of a standard development platform threatens to slow growth and make application development more time consuming and costly, much like we’ve seen in the mobile space. In his session at @ThingsExpo, Mike Weiner, Product Manager of the Omega DevCloud with KORE Telematics Inc., discussed the evolving requirements for developers as IoT matures and conducted a live demonstration of how quickly application development can happen when the need to comply wit...
Aug. 2, 2015 11:15 AM EDT Reads: 556
The Internet of Everything (IoE) brings together people, process, data and things to make networked connections more relevant and valuable than ever before – transforming information into knowledge and knowledge into wisdom. IoE creates new capabilities, richer experiences, and unprecedented opportunities to improve business and government operations, decision making and mission support capabilities.
Aug. 1, 2015 10:00 AM EDT Reads: 486