{"id":10024,"date":"2021-01-05T15:22:00","date_gmt":"2021-01-05T20:22:00","guid":{"rendered":"https:\/\/www.sage.com\/en-us\/blog\/?p=10024"},"modified":"2023-08-01T07:00:46","modified_gmt":"2023-08-01T11:00:46","slug":"planning","status":"publish","type":"post","link":"https:\/\/www.sage.com\/en-us\/blog\/planning\/","title":{"rendered":"Scenario planning & the now of budgeting\/planning"},"content":{"rendered":"
\n\t
\n\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\tAccountants<\/a>\t\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t
\n\t\t\t\t\t

\n\t\t\t\t\t\tScenario planning & the now of budgeting\/planning\t\t\t\t\t<\/h1>\n\t\t\t\t<\/div>\n\n\t\t\t\t\t\t\t\t\t

\n\t\t\t\t\t\t\t\t\t\t\t<\/p>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n\t\t

\n\t\t
\n\t\t\t
\n\t
\n\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\n\t\t
\n\t\t\t\n\t\t\t\t\"Brian\t\t\t\tBrian Sommer<\/span>\n\t\t\t<\/a>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t<\/div>\n<\/div>\n\n\n\n

2020 will be a year all of us will remember. We struggled with stay-at-home orders, product shortages, border closures and more. But, what 2020 really did was put an expiration date on \u2018business as usual\u2019. The business environment has been markedly and permanently changed. The \u2018new normal\u2019 will not be \u2018normal\u2019 at all.<\/p>\n\n\n\n

Business, today, is no longer that familiar, modestly changing world of yore. Businesses now exist in a more chaotic and unpredictable world and that world rewards firms with great plans, forecasts and vision. It absolutely punishes those firms that wait to be surprised. Firms that don\u2019t anticipate different planning events will be called \u2018former businesses\u2019 and will either be acquired or fail.<\/p>\n\n\n\n

Planning, therefore, is not an option but a modern business requirement.<\/p>\n\n\n\n

Here\u2019s an example of how a lack of vision and planning hampered a firm in 2020. This quote is from a highly instructive TechCrunch article<\/a> on travel app Hopper:<\/p>\n\n\n\n

\u201cIn hindsight, one misstep Hopper made is that it didn\u2019t hire more customer service agents to deal with what the pandemic would bring. In fact, Hopper did the opposite \u2014 the company furloughed agents in an effort to cut costs and stay in business. At the time, Lalonde explains, there was just too much uncertainty to hire. Stores were out of toilet paper. The Western world had closed for travel. Vaccines had typically taken years to create. This was looking like a long-term, worst-case scenario.\u201d<\/p>\n\n\n\n

Planning: Then and Now<\/h2>\n\n\n\n

Years ago, a very successful entrepreneur and I were having a bite. In our very casual conversation, I asked him why he left a very large firm to launch his own business. His answer surprised me. He said that he hated budgeting and forecasting. His old employer was, in his opinion, obsessed with the process, so much so that he was spending a couple of person-months a year doing this. He liked spending time with customers and making deals not playing with spreadsheets and begging for budget scraps.<\/p>\n\n\n\n

When I heard this, a number of thoughts flooded my brain. Clearly, his old employer had a bad process and probably bad planning technology. That firm needed to reengineer its process or other key talent would leave the firm. I also knew that this mess wasn\u2019t scalable or flexible. People were spending inordinate amounts of time building rigid plans that may have been numerically correct but I doubt they reflected the reality and variability that I saw in their industry.<\/p>\n\n\n\n

And, in a sense, I could commiserate with my friend on this matter as my employer at the time subjected us to an inane and irrelevant annual planning process. One of those dreaded work products involved the much-despised TT-5 spreadsheet. This macro marvel required my staff and I to input projected service revenues and expenses by client some 18+ months beforehand. Since our average gig was less than 90 days in duration, we couldn\u2019t know who our clients would be or our backlog that far out in advance. And, we couldn\u2019t estimate travel costs either as we didn\u2019t know where the work would occur. So, we made stuff up just to get the accounting staff off our backs.<\/p>\n\n\n\n

And those plans all lacked several critical components. While we got some piddly guidance on 1-2 factors (e.g., assume billing rates will grow 5% next year), we didn\u2019t get any guidance around matters like:<\/p>\n\n\n\n

    \n
  • What are the odds that the economy could contract 5-7% next year?<\/li>\n\n\n\n
  • Should we assume more services buys in certain countries and less in others?<\/li>\n\n\n\n
  • How will competitors likely respond in the next year?<\/li>\n\n\n\n
  • How will airline and hotel pricing likely change in the next year?<\/li>\n<\/ul>\n\n\n\n

    And, I never saw any of these planning exercises ever attempt to understand what sensitivities or vulnerabilities exist in meeting our plans. For example, no planning process had responses to questions like:<\/p>\n\n\n\n

      \n
    • How vulnerable is your top line revenue number to the loss of a few key employees?<\/li>\n\n\n\n
    • Do you have any clients that make up more than 10% of total group revenues?<\/li>\n\n\n\n
    • What would do if market demand for one of your services suddenly fell off?<\/li>\n<\/ul>\n\n\n\n

      Great planning shouldn\u2019t be laborious. It also shouldn\u2019t be an exercise. Great planning is like a map that contains many potential routes to a new destination. It can also be an insurance policy against total failure.<\/p>\n\n\n\n

      How Planning is Evolving<\/h2>\n\n\n\n

      Thankfully, plans have moved beyond paper to automated solutions. But there are clearly some more evolved solutions\/processes out there (and others less so).<\/p>\n\n\n\n

      Many firms create an annual plan with quarterly updates. These plans often reflect P&L and capital projections. Some firms still prepare these with spreadsheet technology although this is mostly the case for laggardly and very small firms now.<\/p>\n\n\n\n

      More sophisticated firms utilize specialized planning technology. The best tools are:<\/p>\n\n\n\n

        \n
      • Integrated directly with key financial applications<\/li>\n\n\n\n
      • Automatically maintain an audit trail of who updated each balance and when<\/li>\n\n\n\n
      • Permit multiple users to work on the same plan simultaneously<\/li>\n\n\n\n
      • Can rapidly create and populate alternate plans to speed up the creation of finesse, stretch and scenario-based budgets\/plans<\/li>\n\n\n\n
      • Coupled with a collaboration\/email technology to speed the development and approval of plans<\/li>\n\n\n\n
      • Use process management technology to automatically trigger reminders and other tasks<\/li>\n<\/ul>\n\n\n\n

        Better tools also provide templates to help operational and non-financial personnel understand the impact of different actions on revenues and costs. For example, a tool that helps Sales leaders understand how the timing of new sales hiring impacts revenues in subsequent quarters can help speed the development of a plan and provide the firm greater confidence of the numbers within the plan. Other utilities can help leaders understand the timing and economic impacts of subscription bookings, services utilization, hiring funnel requirement\/costs, sales capacity and more. The best tools can model the change (or delta) from one set of numbers and assumptions and show the potential impact to the firm in real-time. This power is critical as this knowledge used to be in a key person\u2019s mind or buried in the cells (or macros) in a hard-to-find spreadsheet. The knowledge in these new utilities is out in the open and tunable based on the firm\u2019s experience.<\/p>\n\n\n\n

        The better firms are using these tools to re-plan with greater frequency. Because newer tools can generate a lot of the work automatically and without taxing operational leaders, more realistic and more timely plans can be generated. One highly valued characteristic of these newer tools is their direct integration with core financial applications. It\u2019s not just that these tools can pull in actuals to help populate the initial planning values, but the software can continue to keep updating values in real-time. The software can also trend out the data and show what\u2019s been happening to key line items over time and prompt users to document why their numbers will or will not follow the trend. All of this is what makes newer planning tools \u2018active\u2019 and these stand in stark contrast to \u2018passive\u2019 data in spreadsheets.<\/p>\n\n\n\n

        Risk and Planning<\/h2>\n\n\n\n

        Businesses and business people must take risks to grow their firm. The best business people are great at taking smart risks while also managing downside risks. For example, many years ago I asked a major hotel to indemnify us against some Force Majeure concerns, specifically, earthquakes. I\u2019m glad I did as an earthquake had significantly destroyed or disrupted that area two weeks prior to the scheduled event. That one clause saved my organization over $1 million.<\/p>\n\n\n\n

        That anecdote is important as it illustrates the kind of thinking that should go into planning efforts. Planners should dig in and research what could happen to their firm in any number of scenarios, some of which your firm may have previously experienced. These situations fall into several categories:<\/p>\n\n\n\n

          \n
        • Natural disasters & pandemics<\/li>\n\n\n\n
        • Supply chain problems<\/li>\n\n\n\n
        • Employee actions (e.g., strikes)<\/li>\n\n\n\n
        • Adverse publicity\/scandal<\/li>\n\n\n\n
        • Wars, blockades, terrorism<\/li>\n\n\n\n
        • Macro-economic growth or contraction<\/li>\n\n\n\n
        • Government investigation\/action (e.g., new tariffs, trade embargo, tax increase, sanctions, etc.)<\/li>\n\n\n\n
        • New regulations<\/li>\n\n\n\n
        • A material change in the competitive landscape<\/li>\n\n\n\n
        • New, emerging customer needs\/demands<\/li>\n\n\n\n
        • Employee malfeasance or error<\/li>\n<\/ul>\n\n\n\n

          For some potential risks (e.g., one\u2019s data center catches fire), you should have a formal disaster recovery policy that is routinely tested. Other risks (e.g., outsized inflation occurs) require a combination of a playbook and a financial plan that incorporates the new costs, opportunities and business reactions.<\/p>\n\n\n\n

          For each of these scenarios, a business should know how to tell it is entering the early stages of one of these situations and what its countermeasures for minimizing the potential trauma will be. Some are quite obvious and immediate (e.g., a tornado destroys a key distribution center) while others can sneak up on a firm over time (e.g., an all-new Internet competitor quietly siphons off many of your best customers).<\/p>\n\n\n\n

          Scenario planning differs from many \u2018forecasting\u2019 exercises. When many planners create forecasts, they often work from an agreed upon budget and then create 1-3 alternate forecasts using some knowable macro factor that could impact these estimates. Commonly, we see an official plan\/forecast along with a conservative and stretch plan\/forecast being developed. This planning data might be helpful in preparing plan vs. actual management reports but they offer little guidance as to what a firm should do when confronted by a major game-changing event. For those they need scenario plans.<\/p>\n\n\n\n

          Scenario plans won\u2019t stop some event from occurring but they can definitely expedite your firm\u2019s response to it. That shortened response could save your firm millions and hasten its return to a level of normalcy.<\/p>\n\n\n\n

          Planning\u2019s Future<\/h2>\n\n\n\n

          Going forward, planning tools will likely shift their focus. Instead of being predominately focused on internal financial transaction data, we should see a trend towards greater use of externally sourced big data.<\/p>\n\n\n\n

          For example, we believe that planning tools would better help users if they could understand<\/p>\n\n\n\n

            \n
          • The impact of weather on retail sales<\/li>\n\n\n\n
          • If a potential pandemic from afar is moving and potentially threatening their supply chain<\/li>\n\n\n\n
          • Looming warranty\/recall issues (from social sentiment intelligence)<\/li>\n\n\n\n
          • How changes in customer reviews of your products\/services correlate to top line revenue and discounts offered<\/li>\n<\/ul>\n\n\n\n

            Even further out, we believe sensor data will provide insights into potential machine repair costs based on algorithmic analysis of prior and expected repair data. This ability to predict when a company will need to make repairs will hopefully reduce unplanned downtime (which improves net profits).<\/p>\n\n\n\n

            Another direction for planning technology will involve the analysis of big data feeds to spot emerging trends and to identify \u2018signals\u2019 of changes out in the global economy. Signals might be: growing seismic activity, a warming earth, mutating viruses, changing birth rate patterns, growing political tensions, etc. The value of a great signal is that it is an early indicator or harbinger of changes that will come to impact your firm. When a signal change is apparent, it\u2019s time to dust off the scenario plan for this event, do a quick update and get moving while there\u2019s time to get out in front of competitors. Signals permit your firm to proactively address a changing world\/market instead of reacting to a change once your firm has been impacted.<\/p>\n\n\n\n

            Action Plan<\/h2>\n\n\n\n

            Now that we are starting to see a way out of the pandemic, take time to reflect on what did and didn\u2019t work well with how your firm forecasted and planned. That assessment will likely point out some issues with your firm\u2019s:<\/p>\n\n\n\n

              \n
            • ability to frequently and easily re-plan throughout the year<\/li>\n\n\n\n
            • need for more non-financial data to help spot anomalies<\/li>\n\n\n\n
            • ability to spot signal changes early and often<\/li>\n\n\n\n
            • current planning tools<\/li>\n<\/ul>\n\n\n\n

              After this assessment, you may want to consider newer, more modern planning technology. The new technology shouldn\u2019t mimic current practices, processes and technologies but should push you into examining solutions that quickly, effortlessly and painlessly permit very frequent planning\/re-planning efforts.<\/p>\n\n\n\n

              The change we\u2019ve all experienced of late may abate but frequent disruptive change is likely the future. Smart businesses will equip themselves with the tools that thrive in dynamic times. Are your planning tools in-sync with this new business world?<\/p>\n\n\n

              \n\t
              \n\t\t
              \n\t\t\t
              \n\t\t\t\t\t\t\t\t

              Subscribe to our Sage Advice Newsletter<\/h2>\n\n\t\t\t\t\t\t\t\t\t
              \n\t\t\t\t\t\t

              Get our latest business advice delivered directly to your inbox.<\/p>\n\t\t\t\t\t<\/div>\n\t\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tSubscribe<\/a>\n\t\t\t\t\t\t\t<\/div>\n\n\t\t\t\t\t<\/div>\n\n\t\t\t\t\t\"Working\t\t\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

              2020 will be a year all of us will remember. We struggled with stay-at-home orders, product shortages, border closures and more. But, what 2020 really did was put an expiration date on \u2018business as usual\u2019. The business environment has been markedly and permanently changed. The \u2018new normal\u2019 will not be \u2018normal\u2019 at all. Business, today, […]<\/p>\n","protected":false},"author":1465,"featured_media":9208,"menu_order":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_sage_video":false,"post_featured_image_hide":false,"sage_hide_published_date":false,"sage_hide_read_time":false,"sage_hide_share_buttons":false,"footnotes":""},"categories":[158,44],"tags":[2,4,170,420],"business_type":[312],"lilypad":[],"context":[418,429],"industry":[55,204,59],"persona":[150],"imagine_tag":[209,436],"coauthors":[861],"class_list":["post-10024","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-accountants","category-strategy-legal-operations","tag-accountants","tag-business-intelligence","tag-business-strategy","tag-cloud-financial-management","business_type-accountants","industry-professional-services","industry-technology","industry-travel-hospitality"],"sage_meta":{"region":"en-us","author_name":"Brian Sommer","featured_image":"https:\/\/www.sage.com\/en-us\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/GettyImages-965461876.jpg","imagine_tags":{"209":"Accounting","436":"Intacct Accounting"}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Sage Advice US","distributor_original_site_url":"https:\/\/www.sage.com\/en-us\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts\/10024","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/users\/1465"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/comments?post=10024"}],"version-history":[{"count":0,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/posts\/10024\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/media\/9208"}],"wp:attachment":[{"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/media?parent=10024"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/categories?post=10024"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/tags?post=10024"},{"taxonomy":"business_type","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/business_type?post=10024"},{"taxonomy":"lilypad","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/lilypad?post=10024"},{"taxonomy":"context","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/context?post=10024"},{"taxonomy":"industry","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/industry?post=10024"},{"taxonomy":"persona","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/persona?post=10024"},{"taxonomy":"imagine_tag","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/imagine_tag?post=10024"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.sage.com\/en-us\/blog\/api\/wp\/v2\/coauthors?post=10024"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}