Strategy: is forecasting destroying your planning process? Part 18.104.22.1688
In this part we will introduce variance analysis in the real businnes including traditional forecasting and other interesting issues
Improve variance analysis
One benefit of business planning over forecasting is it’s more likely the organization’s goals
will be achieved. Additionally, when the year starts and the actuals begin to roll in,variance analysis goes from being superficial to being substantive. Without a real business plan, the Finance team can only say,“We have a negative 2 % variance in revenue because we didn’t sell as much as we forecasted.” There’s very little business insight offered in that case—nothing that points to what can be done differently next time, nothing to learn from.
“The traditional process at this point would involve managers creating rationales for why the targets can’t be met and producing detailed P&Ls and other financial schedules
that reflect reduced expectations. So here’s the big break with the traditional approach. “
Contrast that with what you can glean froma real business planning process because there was a real, substantive plan. For example, if XYZ Company doesn’t grow revenue by 8 %, the organization can identify what happened from a business perspective, like if a key marketing campaign launch date had been delayed or a Groupon event didn’t draw the anticipated response rate. Then it can delve much deeper into those issues. What caused the delay in the marketing campaign? If it was an issue with the advertising agency, maybe a new one is needed. If the root cause was that the marketing person leading the campaign left the company on short notice, maybe there’s an issue with succession planning.
The analysis can reveal real business issues from which the company can draw important lessons and insights and learn what to do differently next time. In other words, it facilitates continuous improvement in the enterprise.
It may seem at this point that I’ve disparaged forecasting, but it does have an important role to play. After the business plan has been approved and the year begins, management needs a reality check. It needs an objective view on whether the organization is on track to achieve its goals or not. If it isn’t on track,
then management can consider alternatives to achieving its goals. The forecast serves as an early warning system to give as much time as possible to readjust and get back on track.
The way forward
It’s important to ensure that your company is doing proper planning rather than creating forecasts and calling it planning. As stated, it begins by having senior executives establish well-informed, high-level targets (for example, revenue, gross margin percentage, EBITA). Finance has a critical role to play in presenting trend analysis, unbiased projections based on current reality, and other analysis to help executives make informed decisions. That process can kick off with an offsite meeting with the executives and should be concluded in a couple of weeks. Remember, this is their business, which they’re living and breathing every day. They probably have a good answer in their minds before the question is even asked.
The traditional process at this point would involve managers creating rationales for why the targets can’t be met and producing detailed P&Ls and other financial schedules that reflect reduced expectations. So here’s the big break with the traditional approach. Rather than develop a full-blown P&L and start an endless cycle of negotiations and managing expectations, challenge the organization to come up with a set of initiatives — along with high-level resource requirements — to meet the targets. Give the organization two to four weeks to accomplish that and present to senior management. Depending on the size and complexity of the organization, the review by senior executives could take a day or a week.
Coming out of that meeting would be a list of approved initiatives, which then should be further detailed in execution plans at the activity and task level. Resource requirements would be refined, and then a full P&L can be created. Notice that the focus of the process has shifted from endless rounds of forecasting and negotiating to a more pointed dialog about how to achieve the targets. Will this put an end to gamesmanship?Probably not—at least not entirely. But those trying to game the process will be much easier to spot. They’ll be the ones marching in with superficial initiatives lacking depth and substance while carrying a long list of reasons why they can’t meet their goals. Over time, they, too, will learn it’s in their best interest to focus their attention on how to rather than why not.
The last step is to incorporate the initiatives and execution plans into the budget and produce the plan’s P&L. As long as the high-level targets (like revenue, gross margin percentage, EBITA) remain consistent, there can be flexibility in the individual line items of the P&L. If something truly game changing is revealed in the process of developing or reviewing the initiatives, then modifying a specific target may be warranted. But if that’s the case, modifying the target will be the result of a well-informed business process rather than the consequence of horse trading.
A quick note to supporters of rolling forecasts: As I noted, forecasting still serves a vital function as an early warning system and an unbiased view of the future state of the business. Forecasts should be completed on a monthly or an as-needed basis, but they shouldn’t be focused exclusively on the financials.
They also should focus on the progress of the initiatives and execution plans that are designed to drive the financial results. If the plans are falling behind, then the expected financial results may also be delayed. Because this type of analysis requires an understanding of the business and the initiatives, which goes above and beyond the understanding of financial models, financial analysts might need additional training and development.
“Coming out of that meeting would be a list of approved initiatives, which then should be further detailed in execution plans at the activity and task level. Resource requirements would be refined, and then a full P&L can be created. Notice that the focus of the process has shifted from endless rounds of forecasting and negotiating to a more pointed dialog about how
to achieve the targets.“
Back to you, coach
A wise sage once said, “A problem well stated is a problem half-solved.” That simply means that we too often solve for the wrong problem. And until we define the problem properly, the answer will continue to elude us. The reason why coaches don’t go around projecting their win-loss ratio in the upcoming season is that it doesn’t solve their real challenge. Their problem isn’t how to do a better job projecting wins and losses, it’s figuring out how they’re going to win.
The same applies in business. Not to overlook forecasting’s importance, but the bigger challenge is how to make the future you want actually happen. The answer is in planning to win. That means revising the focus of the planning process. As Figure 1 shows, change the time spent on negotiating targets to instead focus on developing execution plans. Following this rigorous, more comprehensive approach to planning will result in actionable plans that truly drive business results.
Sidebar: the death spiral
A very common refrain heard in business is “Our planning process takes too long and delivers too little value.” And the response to it is equally common. Addressing the “too little value” criticism seems a bit daunting, so most Finance teams focus on the “takes too long” aspect. And by “takes too long,” people
outside Finance really mean “It takes too much of my time when I could be busy doing something
that actually adds value.” So Finance looks to minimize the time required for people to engage in the process. On some level, the fix seems straightforward. Since Finance owns the financial models that produce the projections, it will look to automate as much of the projection process as possible: Take a handful of input assumptions, apply some robust formulas, and deliver a new projection.
As easy as that approach sounds, those not in Finance often respond with a refrain of “That isn’t my number!” They see the projections as guesswork, detached from reality, and delivering no business value. This makes them less interested or willing to engage in the process.
As the resistance to engaging in the process grows, Finance looks for ways to minimize the time it has to “bother people.” This involves turning to the financial model and finding ways to further automate projections by refining or elaborating the calculations, changing or further minimizing the inputs (i.e.,
The result is a paper projection that reflects an even wider gap between the actual business operations and the business planning process. This trap of minimizing the engagement of nonfinance managers, reducing the efficacy of the planning process, increasing the frustration with the results and lack of value, and then turning once again to refining financial models results in a death spiral. If a process delivers zero value, then any time spent on it will be perceived to be wasted.
The answer is, yes, minimize any friction or inefficiencies in the process, but an overriding priority has to be improving the value that the process delivers; otherwise, no amount of process efficiency improvement will ever change the perception that the planning process takes too long and delivers too little value.
is a globally recognized authority on enterprise performance management (EPM). He began his career as FP&A manager at Pepsi Cola International and went on to found one of the fastest-growing EPM software companies in North America. Lawrence is the author of Value Planning: The New Approach to Building Value Every Day (J. Wiley & Sons) and is coauthor of IMA’s global survey and research project on FP&A. He can be reached at firstname.lastname@example.org.