Supply and demand chain planning and execution have grown in importance over the past decade as companies have recognized that software can meaningfully enhance their competitiveness and improve their financial performance. Sales and operations planning (S&OP) is an integrated business management process first developed in the 1980s aimed at achieving better alignment and synchronization between the supply chain, production and sales functions. A properly implemented S&OP process routinely reviews customer demand and supply resources and “replans” quantitatively across an agreed rolling horizon. The replanning process focuses on changes from the previously agreed sales and operations plan; while it helps the management team understand how the company achieved its current level of performance, its primary focus is on future actions and anticipated results. Adoption of S&OP has increased as software to support the process has become more powerful and affordable and as a growing list of companies demonstrated its value in producing meaningfully improved business results. Even without adopting a full-scale S&OP management approach, companies can benefit from better coordination and collaboration between their supply and demand functions. Software plays an important role here, too, in facilitating this coordination and collaboration.
Topics: Planning, SaaS, Sales, Forecast, Mobile Technology, Operational Performance Management (OPM), Human Capital, Supply Chain Planning, Analytics, Business Analytics, Business Collaboration, Cloud, Cloud Computing, Business Performance Management (BPM), Financial Performance Management (FPM), Sales Performance Management (SPM), Sales Planning, Supply Chain, Supply Chain Performance Management (SCPM), Demand Chain, Integrated Business Planning, SCM Demand Planning, S&OP
In our benchmark research at least half of participants that use spreadsheets to support a business process routinely say that these tools make it difficult for them to do their job. Yet spreadsheets continue to dominate in a range of business functions and processes. For example, our recent next-generation business planning research finds that this is the most common software used for performing 11 of the most common types of planning. At the heart of the problem is a disconnect between what spreadsheets were originally designed to do and how they are actually used today in corporations. Desktop spreadsheets were intended to be a personal productivity tool used, for example, for prototyping models, creating ad hoc reports and performing one-off analyses using simple models and storing small amounts of data. They were not built for collaborative, repetitive enterprise-wide tasks, and this is the root cause of most of the issues that organizations encounter when they use them in such business processes. 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). 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 their 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. Spreadsheets are seductive for most business users because, even with a minimum amount of training and experience, it’s possible to create a useful model, do analysis and create reports. Individuals can immediately translate what they know about their business or how to present their ideas into a form and format that makes sense to them. They can update and modify it whenever they wish, and the change will occur instantly. For these business users ease of use and control trump putting up with the issues that routinely occur when spreadsheets are used in collaborative enterprise processes. Moreover, it’s hard to persuade “spreadsheet jockeys” who have strong command of spreadsheet features and functions that they should start over and learn how to use a new application. Those who have spent their careers working with spreadsheets often find it difficult to work with formal applications because those applications work in ways that aren’t intuitive. Personally these diehards may resist because not having control over analyses and data would diminish their standing in the organization. Nevertheless, there are compelling reasons for vendors to keep trying to devise dedicated software that an average business user would find as easy and intuitive as a desktop spreadsheet in the design, test and update phases. Such an application would eliminate the single most important obstacle that keeps organizations from switching. The disadvantages of using spreadsheets are clear and measurable. One of the most significant is that spreadsheets can waste large amounts of time when used inappropriately. After more than a few people become involved and a file is used and reused, issues begin to mount such as errors in data or formulas, broken links and inconsistencies. Changes to even moderately complex models are time-consuming. Soon, much of the time spent with the file is devoted to finding the sources of errors and discrepancies and fixing the mistakes. Our research confirms this. When it comes to important spreadsheets that people use over and over again to collaborate with colleagues, on average people spend about 12 hours per month consolidating, modifying and correcting the spreadsheets. That’s about a day and a half per month – or five to 10 percent of their time – just maintaining these spreadsheets. Business applications vendors started to address business users’ reluctance to use their software more than a decade ago when they began to use Microsoft Excel as the user interface (UI). This provides a familiar environment for those who mainly need to enter data or want to do some “sandbox” modeling and analysis. Since the software behind the UI is a program that uses some sort of database, companies avoid the issues that almost arise when spreadsheets are used in enterprise applications. There also are products that address some of the inherent issues with such as the difficulty of consolidating data from multiple individual spreadsheets as well as keeping data consistent. Visualization software, a relatively new category, greatly simplifies the process of collecting data from one or more enterprise data sources and creating reports and dashboards. As the enterprise software applications business evolves to meet the needs of a new generation of users, as I mentioned recently, it’s imperative that vendors find a way to provide users with software that is a real alternative to desktop spreadsheets. By this I mean enterprise software that provides business users with the same ability to model, create reports and work with data the way they do in a desktop spreadsheet as well as update and modify these by themselves without any IT resources. At the same time, this software has to eliminate all of the problems that are inevitable when spreadsheets are used. Only at that point will a dedicated application become a real alternative to using a spreadsheet for a key business process. Regards, Robert Kugel – SVP Research
Topics: Planning, ERP, Forecast, GRC, Operational Performance Management (OPM), Reporting, closing, dashboard, enterprise spreadsheet, Excel, plan, Analytics, Business Analytics, Business Collaboration, Accounting, Business Intelligence (BI), Business Performance Management (BPM), Customer Performance Management (CPM), Data, Financial Performance Management (FPM), Risk, Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), application, benchmark, Financial Performance Management, spreadsheet
One trend in business software that’s still in its early stages but gathering momentum is the availability of modeling tools that fill the gap between desktop spreadsheets and enterprise systems. Granted this “early stage” has been under way for quite some time, but the technology has finally progressed to the point where I expect it to get increasing market traction.
Topics: Database, Planning, Analyst, Anaplan, Forecast, Operational Performance Management (OPM), BizNet Software, Essbase, model, plan, Quantrix, Analytics, Business Analytics, Business Collaboration, Business Intelligence, In-memory, Business Performance Management (BPM), finance, Financial Performance Management (FPM), Sales Performance Management (SPM), Workforce Performance Management (WPM), analysis, analytic application, BI, business model, business plan, financial model, spreadsheet
I believe that one of the more important analytical applications that a company can implement is profitability management. IBM Cognos offers Profitability Modeling and Optimization as part of its Cognos 10 offering that my colleague has assessed. As I’ve noted, most people in a corporation are focused on profitability, but not necessarily in a way that optimizes results across the organization in a day-to-day, consistent fashion. Those responsible for each component piece that contributes to profitability (such as departments, product lines or divisions) have objectives, but in pursuing these individual objectives they may make decisions that degrade the overall profitability of the corporation. Moreover, companies rarely seek to maximize short-term profits. They routinely make decisions that diminish their bottom line, such as promotional pricing, warranties or services included at no additional cost, with the aim of achieving strategic objectives. The question they must answer in making these decisions is whether these moves are justified. Similarly, they also must ask what they are including in their offer that they might be able to charge more for, such as shipping or warranties.
Topics: Performance Management, Forecast, Modeling, Operational Performance Management (OPM), enterprise profitability management, Business Analytics, IBM, Business Performance Management (BPM), Cognos, Financial Performance Management (FPM), Sales Performance Management (SPM), Workforce Performance Management (WPM), financial services, optimization, Profitability, profitability optimization, segmentation
SAP announced the release of version 10 of its SAP BusinessObjects Enterprise Performance Management (EPM) Solutions suite, an enhanced and updated set of applications and capabilities for executives and managers. In our Value Index assessment of financial performance management suites and my analysis of it last year, Ventana Research gave SAP’s offering the highest score, and this new release builds on that solid foundation that I already assessed in my blog. It has been several years since SAP began acquiring and assembling its performance management and analytical software assets, and the company has progressed to the point where discussing the integration efforts is becoming irrelevant. This release revamps the user interface of the different components to provide a more consistent look and feel – a crucial factor in facilitating training and improving user productivity. Outside of the suite itself, the current release is designed to integrate better with ERP, SAP NetWeaver BW, risk management and BI. In facts it establishes a foundation for finance analytics that I have researched and is essential for doing what I call and have written about in putting the “A” back in FP&A.
Topics: Planning, SAP, Forecast, Operational Performance Management (OPM), budget, Budgeting, rolling forecast, XBRL, Business Analytics, Business Mobility, Governance, Risk & Compliance (GRC), Business Intelligence (BI), Business Performance Management (BPM), CFO, Financial Performance Management (FPM), Information Management (IM), Supply Chain Performance Management (SCPM), agile planning, budgeting software, CEO, Corporate Finance, Financial Performance Management, Integrated Business Planning
Alight Planning sells planning and budgeting software mainly to midsize companies and stresses its software’s ability to support a more effective approach to corporate planning and budgeting. It calls this “agile planning,” a term used to contrast a traditional, highly deterministic method of drawing up and executing plans with an “agile” mindset that is better able to deal with the high level of economic volatility that most businesses confront today. In many respects Alight’s approach is consistent with what Ventana Research refers to as “integrated business planning,” which I have written about as a business priority and an area that I have extensively researched.
Topics: Planning, Forecast, Operational Performance Management (OPM), budget, Budgeting, rolling forecast, CFO, Financial Performance Management (FPM), Sales Performance Management (SPM), Supply Chain Performance Management (SCPM), agile planning, budgeting software, CEO, Integrated Business Planning