Spend Analysis Lessons Learned

— Frank Buchanan, Manager, Sourcing & Procurement Practice, The Hackett Group Experts will tout the spend analysis as the lifeblood of a Procurement Organization, and they are right. But the purpose of this article is not to convince you of the benefits of a spend analysis, but to pass along key insights that will save you time and increase the effectiveness of your output. The following best practices are the result of conducting spend analyses for both medium and large sized companies in many different industries: 1.       Involve Leadership The nature of a spend analysis forces you to interact with almost all departments, because they all have spend. If this is the first comprehensive spend analysis being conducted, some of the stakeholders you need to speak with will naturally react defensively. Think about it, suddenly outsiders want to know what they buy and from which suppliers, it is only natural for them to feel criticized, and if they don’t have to help you – they won’t, or they might delay or provide incomplete information. But if the message comes from above first, with a clear explanation of the purpose and expectations, then you encounter a completely different stakeholder. This will also help when working with your ERP technicians, as the ERP data mining process typically demands more time than expected, especially when mistakes are made and “re-pulls” are necessary. 2.       Capture All the Supplier Spend Supplier spend transaction data can reside in many different areas of the company, and usually does. A spend analysis will not be complete if it does not incorporate all supplier spend. Beyond the payables data coming out of the AP system, there might be wire transfers being sent to certain suppliers (e.g., health insurance providers), or there might be T&E reimbursements coming out of the Payroll system, or the T&E card payment transaction detail might not show up in Payables – sometimes there are surprisingly large supplier payments on the T&E card. However, before you collect the data, you need to make sure you have a computer program that will allow you to view and analyze the consolidated data. Excel becomes painfully slow once you get beyond 500,000 rows; Access can handle a bit more – up to 1.5 gigabytes, that is, if you know how to use it. I recently conducted a spend analysis that had 40 million rows of data we had to deal with, which required use of a separate program and high-capacity computer processers. 3.       Use a Custom Spend Taxonomy Many companies use UNSPSC codes in their Purchase Order system because it is exhaustive, with 20,000 commodity codes from which to choose. But for a spend analysis UNSPSC is not ideal because it is not designed for strategic sourcing purposes. In other words, UNSPSC codes are not organized in a hierarchy that facilitates the identification of savings opportunities. Every company we help eventually reached this conclusion and we help them develop a taxonomy geared towards going to market (e.g., audit services and tax services are rolled up together because often the same supplier provides both), while still being customized to their business and nomenclature. It is important to develop this taxonomy early for two reasons: 1) Leadership approval will be required because spend analysis reports will eventually be widely distributed, and 2) You do not want changes to the taxonomy after you have already spent countless hours categorizing the spend data. 4.       Validate the Data The process of collecting the spend data is complex and disjointed because ERPs are typically not designed to provide company-wide supplier spend visibility, surprisingly. Therefore, errors in the data are common. You must constantly be on the lookout for missing spend, double-counted spend, or simply incorrect spend. After all the data has been collected and processed, the best way to ensure that the spend analysis is accurate is to validate it. There are two good ways of doing this: 1) A top-down analysis, and 2) Stakeholder interviews. The top-down analysis uses the financial statements to approximate the total supplier spend, and the stakeholder interviews involve speaking to the people who would know how much you spend in a given spend category. Some spend categories are fragmented and not owned by anybody in the company, but for those that have consolidated ownership, you will need their blessing in order to ensure the accuracy and legitimacy of your outputs. I recommend keeping detailed records of all stakeholder feedback, because different stakeholders will provide contradictory feedback as to what spend goes in which category bucket. 5.       Create a Repeatable Process If you are conducting a spend analysis for the first time, it is going to be a trial and error process, especially if not supported by outside experts. It is essential to document the process as you develop it, so that it may be repeated. Because a spend analysis slowly becomes less useful as it ages. Most large companies perform refreshes at least once a year, if not more often. The locations of the data, the ERP data queries used, the spend category owners and contacts, supplier name consolidations (e.g., I.B.M and IBM), the spend mapping rules, the top-down analysis methodology, etc. – all must be captured in order to reap the reward of your hard work and avoid unnecessary rework down the road. This becomes especially important if you are a global company, or a conglomerate, because this increases the likelihood of multiple ERPs (or multiple instances of the same ERP), which significantly complicates the process. 6.       Fully Leverage the Results A spend analysis can provide value to a Procurement Organization in a surprising number of ways. Many companies out there today are routinely performing spend analyses, but not taking full advantage of the output’s potential. The primary function of a spend analysis is to identify strategic sourcing opportunities and “maverick spend” (i.e., off-contract spend), but additional ways in which it can be used include: providing regular spend reports to department heads to increase the value of Procurement and enhance relationships, identifying invoice consolidation opportunities, optimizing working capital strategy (i.e., payment terms), enabling effective channel strategy development, and enabling effective supplier risk assessments and mitigation planning – to name a few. Furthermore, the most common Procurement performance indicators use total spend as the denominator in the equation, so for those without total spend it makes it difficult to track performance and benchmark results against peers. While conducting a spend analysis for the first time is a difficult task, the output, if accurate and comprehensive, is invaluable to a Procurement Organization, for without spend visibility it is impossible to effectively manage a company’s spend. These six lessons learned will make the process more efficient and the outcome more impactful. # # # The Hackett Group (NASDAQ: HCKT), a global strategic business advisory and operations improvement consulting firm, is a leader in best practice advisory, business benchmarking, and transformation consulting services including strategy and operations, working capital management, and globalization advice. More information on The Hackett Group is available: by phone at (770) 225-7300; by e-mail at info@thehackettgroup.com or on the Web at www.thehackettgroup.com