You are currently browsing the tag archive for the ‘Integrated Business Planning’ tag.
Our benchmark research on next-generation business planning finds that a large majority of companies rely on spreadsheets to manage planning processes. For example, four out of five use them for supply chain planning, and about two-thirds for budgeting and sales forecasting. Spreadsheets are the default choice for modeling and planning because they are flexible. They adapt to the needs of different parts of any type of business. Unfortunately, they have inherent defects that make them problematic when used in collaborative, repetitive enterprise processes such as planning and budgeting. While it’s easy to create a model, it can quickly become a barrier to more integrated planning across the business units in an enterprise. As I’ve noted before, software vendors and IT departments have been trying – mainly in vain – to get users to switch from spreadsheets to a variety of dedicated applications. They’ve failed to make much of a dent because although these applications have substantial advantages over spreadsheets when used in repetitive, collaborative enterprise tasks, these advantages are mainly realized after the model, process or report is put to use in the “production” phase (to borrow an IT term).
Host Analytics Modeling Cloud is designed to address the needs of people who – often working alone – create representations of the business or portions of the business used in a collaborative planning process. These individuals often create analyses and reports that complement the planning process. To date most dedicated applications have been far more difficult than spreadsheets for the average business user to use in the design and test phases. To convince people to switch to its dedicated application, a vendor must offer an alternative that lets users model, create reports, collect data and create dedicated data stores as easily as they can do it in a desktop spreadsheet.
Modeling Cloud is designed to integrate individual businesses unit plans with a company’s financial planning, forecasting and budgeting. It attempts to address the spreadsheet problem by enabling individuals in business units to create and update plans and budgets and their underlying models in a way that is consistent with what they are used to doing, but also makes it easy to tie these together to achieve an integrated company-wide view. Compared to desktop spreadsheets, this approach better enables a company to analyze and refine plans and budgets. It also facilitates advanced modeling capabilities such as rolling quarters forecasting and contingency and what-if planning. Compared to desktop spreadsheets, with Modeling Cloud it’s much easier to consolidate the plans from multiple contributors and then drill back down into individual plans and their underlying assumptions. The software also has mobile features that enable individuals to review, contribute and approve plans and budgets on the go. Each of these capabilities increase the business value of the company’s planning and budgeting.
People and businesses plan in order to be successful. Companies do a lot of planning – some formal and some informal – about all aspects of the business including sales, production, headcount, distribution and the supply chain. Done properly, planning is the best way to get everyone organized in executing the plan. At that point they can take advantage of collaboration, which is essential to effective planning and budgeting. Our research finds that in the large majority (85%) of companies that collaborate well in their planning and budgeting processes participants regard it as well managed. Dedicated applications work better than desktop spreadsheets when it comes to bringing individual models, plans, budgets and forecasts into an integrated companywide view. In contrast it’s difficult and time-consuming to combine desktop spreadsheets into a consolidated view, and it’s even harder and more tedious to look back into the underlying data in seeking a better understanding of important differences between individual plans and models.
Modeling Cloud is designed to address an important need in corporate planning – closely tying all aspects of business planning to financial planning and budgeting and helping organizations collaborate across business silos. Our research shows that integrated planning works better, as I have written : Two-thirds of companies in which information in individual plans is directly linked have a planning process that works well or very well, compared to 40 percent in which the information must be copied and only 25 percent where there is little or no connection. As a rule, providing users with a familiar environment in which to create business models, create and compare different business scenarios, analyze actuals and create reports goes a long way toward mitigating the difficulty of having to learn to use a new tool that has been a barrier to the use of dedicated planning software across an enterprise and makes it easy to directly link plans. Business planning can be more effective if individuals have software that gives them a high degree of flexibility to create models and plans in a way that works comfortably for them yet also facilitates the integration of everyone’s plans into a consolidated view. Our research shows that dedicated planning applications can help users align their plans with strategy and the rest of the organization. For example, companies that use them said twice as often that they are able to estimate accurately one plan’s impact on others as those that use spreadsheets. In addition, two out of three that have dedicated applications said they are satisfied with their planning process and that their plans are accurate.
Information technology has the potential to make business planning more useful, as I have noted, enabling it to improve a company’s performance and increase its competitiveness. One of the necessary tools for more fully integrating business and financial planning is a software and data environment that enables business people to plan their part of the business in a way that is familiar, productive and useful to them in achieving their objectives. That environment also must enable them to communicate the financial consequences of their business plan to inform the financial forecasting, planning, budgeting and review processes. Host Analytics Modeling Cloud is designed to do that. It’s not a perfect substitute for spreadsheets, which still excel in their ability to help people quickly translate their thoughts into models and reports. But because Modeling Cloud eliminates most of the hassles and defects of spreadsheets (for example, the ability to quickly store, retrieve and consolidate data from a single authoritative source), it is ultimately a much more attractive alternative. I recommend that Host Analytics customers assess using Modeling Cloud in their organization and that buyers of dedicated planning applications include this type of capability in their evaluation of vendors’ offerings.
Robert Kugel – SVP Research
Adaptive Insights held its annual user group meeting recently. A theme sounded in several keynote sessions was the importance of finance departments playing a more strategic role in their companies. Some participating customers described how they have evolved their planning process from being designed mainly to meet the needs of the finance department into a useful tool for managing the entire business. Their path took them from doing basic financial budgeting to planning focused on improving the company’s performance. This is one of the more important ways in which finance organizations can play a more strategic role in corporate management, an objective that more finance organizations are pursuing. Half of the companies participating in our Office of Finance benchmark research said that their finance organization has undertaken initiatives to enhance its strategic value to the company within the last 18 months.
We believe that presenting its software as an aid to make the planning process more strategically valuable is a product strategy that is essential for the long-term success of planning software vendors. It was a theme in Adaptive Insights’ recent release of its Adaptive Suite and revenue planning software.
Companies do many kinds of planning, not just budgeting. They plan sales, they determine what and how they will produce products or deliver services. They plan the head count they’ll need and how to organize distribution and the supply chain. They also produce a budget, which itself is a financial plan. The planning process involves discussions about objectives and the resources and tactics that people need to achieve them. Our benchmark research finds that dedicated applications are more effective tools for planning than are desktop spreadsheets (which nevertheless are still the most widely used technology for planning). For example, dedicated planning software is more able to get to underlying causes behind variances immediately during a performance review meeting. Users can apply the information that’s in the application when reviewing results and adjusting goals and objectives to reflect changes that have taken place in the business. The research shows that organizations that use dedicated software more often can get to the underlying details of the difference between plans and actual results and therefore are more able to make fast decisions about what to do next. Spreadsheets are inherently less capable of drilling down into underlying details.
Adaptive Insights has a suite of planning, analysis, reporting and consolidation applications that mirror the evolution of the business planning category. I coined the term “integrated business planning” more than a decade ago to describe an approach to planning that brings together financially focused budgeting and forecasting activities with various stand-alone functional planning efforts. The objectives of this approach are to provide senior executives with a comprehensive view of future expectations for their business; to set a baseline for performance measurement; to assess performance relative to these baseline objectives; and to periodically adjust objectives and resources in a coordinated, strategic fashion as conditions evolve. Integrating the business planning activities of the various functional groups within a company is best accomplished by providing a single planning environment in which each group can plan its part of the business the way it prefers, compare its actuals to plan using preferred analytical methods and easily report and communicate results within the group. Each planning process can be loosely coupled in that the cadence, items, measures, dimensions and other planning elements fit the needs of that specific part of the business. At the same time, because all planning takes place in a single environment, it’s easy to bring together the necessary information from each of the individual business unit plans to create a consolidated, forward-looking view of the company. It’s also easy to provide control and consistency across planning units by ensuring, for example, that all plans use the same projected benefits costs, commodity prices, exchange rates and other elements that will affect all parts of the organization. Our benchmark research on next-generation business planning finds that companies that integrate their planning by directly linking plans get better results: Two-thirds that have direct links said they have a planning process that works well or very well compared to 40 percent that copy and paste information and just one-fourth that have little or no connection between plans. Well-executed planning is the best way to get everyone onto the same page to ensure that the company is organized in executing the plan. Setting and to a greater degree changing the company’s course require coordination. It enables understanding of the impact of the policies and actions in one part of the company on the rest of the company. Information technology has the potential to make business planning more useful, and to help improve a company’s performance and increase its competitiveness.
From a financial management standpoint, it’s essential to be able to project pro-forma balance sheets and cash flows. When all operational planning is feeding the core business model, the future state of a company’s balance sheet and cash flow can be more realistic than when it is only loosely connected. Moreover, it’s possible to quickly and accurately compare the impacts of various operating scenarios on the company’s finances, assess the impacts of various financing alternatives and project how different capital market conditions will affect the company’s overall financing costs across multiple operating scenarios. All of this is possible using spreadsheets, but doing so is far more time-consuming (and therefore impractical) and potentially much less accurate.
Another reason why a dedicated planning application a better planning environment than desktop spreadsheets is that it facilitates the separation of planning into things and the financial aspect of those things: a unit-times-rate structure. While financial planning focuses on money, the rest of the business plans mainly in terms of things: units produced, head count at various pay grades, tons of raw materials and production yields, to name just a few. Having the ability to model units and currency amounts separately makes it far easier to measure performance in ways that are meaningful to each part of the business. In its most simplistic form, it helps planners determine immediately and unambiguously whether variance between the plan and actual results was driven by units, a price or cost variance or both.
Our research on enterprise use of spreadsheets shows that companies that use spreadsheets for forecasting, planning and budgeting usually spend much more time in analyzing and reporting results than users of more appropriate tools do. Dedicated software automates this process, enabling finance departments and other functional units to spend less time on repetitive tasks while providing accurate and consistent information to executives and managers. Adaptive Insights recently added to its suite Office Connect, which facilitates creating and updating reports in Microsoft’s Excel, Word and PowerPoint applications, enabling departments to operate more efficiently and speed the availability of performance reports. For example, using the software, standard monthly tables and charts can be instantly updated each month to speed the production of spreadsheets, narrative reports or presentation decks for monthly board meetings.
I have long advocated the use of dedicated planning applications rather than desktop spreadsheets for handling planning processes. The inherent technology limitations of spreadsheets make them a poor choice because they consume time needlessly and prevent organizations from being able to forecast, plan, analyze and replan effectively. Yet spreadsheets remain the leading technology used for planning. Our recent planning research finds that, across 11 different types of business planning, on average seven out of 10 companies use spreadsheets. I recommend that all midsize and large companies consider replacing spreadsheets with a dedicated planning application that provides a unified environment for planning across the entire enterprise. Midsize companies and midsize divisions of large enterprises should consider Adaptive Insights for this role.
Robert Kugel – SVP Research