Applying business intelligence (BI) solutions to procurement resolves traditional customer/supplier conflicts and provides a wealth of benefits to both parties. A longtime supply chain executive explains how it works.
To optimize their purchases of the high-dollar-value items that are essential for their businesses, many large and progressive companies are turning to strategic sourcing, a systematic and fact-based approach to improving an organization's purchasing activities. These companies look to their purchasing and procurement departments to implement strategic sourcing. Yet many also undermine the ability of their sourcing departments to successfully carry out those responsibilities, by using outdated approaches for evaluating suppliers and overburdening their procurement personnel with repetitive, low-value tasks.
At the same time, many suppliers view the process by which their customers evaluate them as a mystery. They lack a clear understanding of their own performance and where they stand relative to their competitors. Even when their customers do provide hard performance data, suppliers often fear that the data are inaccurate, out-of-date, or biased. This situation makes it harder to engage in strategic sourcing.
What can be done to resolve this dilemma and fully embrace strategic sourcing by more thoroughly evaluating an organization's supply base? The answer lies in the application of business intelligence (BI) to procurement.
A tool for analysis and decision-making
Business intelligence uses analytics, various technologies, and software to retrieve and extract raw data from enterprise resource planning (ERP) systems, data warehouses, and other data sources and then convert it to usable, applicable facts. BI is able to summarize the data into meaningful, real-time, and fact-based information that facilitates and simplifies decision making. This capability can help companies solve some longstanding information-related problems.
Historically, the relationship between supplier and customer was adversarial because of a lack of trust or transparency. Moreover, the primary thrust of sourcing was reduced price and acquisition cost. Now, however, the relationship between a company and its suppliers is much more symbiotic. The buyer needs quality goods and services by a required delivery date (RDD), and at the best possible price. The strategic suppliers, meanwhile, would like more business, and they want to receive advance notice of purchases and demand patterns. Today's approach, then, is one of optimizing value (which transcends purely price) in order to determine the total cost of acquisition and operating costs—in other words, the total cost of ownership (TCO).
Still, the strategic sourcing experts in any business have a difficult job. They must determine how well each vendor is meeting their requirements for goods or services, and whether more or less business should be directed its way. The suppliers they work with need information that will allow them to answer four questions:
How am I being evaluated?
How am I performing against the criteria?
How am I performing vis-à-vis my competitors?
Are the data by which I am being measured accurate, unbiased, and up-to-date?
Additionally, when a company's evaluation criteria change, suppliers want to know what impact those changes will have on the answers to questions 2 and 3.
In the past, however, the information sought by both buyer and supplier was simply unavailable, or woefully out of date. Until recently, providing timely, accurate, and verifiable answers to these questions was impossible.
Fortunately, the needed data are now available, thanks to recent advances in the capabilities of the business intelligence applications included in ERP software. Instead of making decisions based on "gut feeling," executives can now take advantage of a BI application's analytics and decision-making tools to provide actionable intelligence. These BI tools can sort through the voluminous available data to quickly perform **italic{ad hoc} queries, optimize reporting of key performance indicators (KPIs), update dashboards and scorecards in real time, and even perform predictive analytics.
As will be discussed later in this article, in order to do that effectively, both the strategic sourcing arm of the company and the information technology (IT) department must work together, with the former determining the critical data required, and the latter using BI tools to obtain or ferret out the needed information.
Identify the most important criteria
So how might a company use the data available through the BI pipeline to evaluate strategic suppliers? The first step is to decide which factors are the most important to assess during the evaluation. Companies traditionally have used criteria such as price, quality, on-time delivery, and service to evaluate suppliers. But there were two difficulties with that approach. First, the data were often out of date or delayed. And second, many of the criteria were based on subjective judgment rather than on facts.
BI overcomes both of these impediments by supplying verifiable, real-time metrics. Moreover, a company can define its own criteria for evaluation as long as the relevant data are available. In addition, BI can vary the relative importance of one or more factors based on the product or service. For example, one might normally assume that price is the key factor for evaluating any supplier. However, in some situations, quality and on-time delivery may be more important, because a critical product or material that fails or does not arrive when required is unacceptable, regardless of how good the price may be. Given the right tools, this is not a problem; the marvelous thing about BI is that the criteria can easily be modified as required.
There are many ways to measure the commonly used criteria of price, quality, delivery, and service. For example, price or value can be determined by comparing one supplier's charges against those of another supplier of a similar good or service. Another, related criterion is the bid-success ratio; namely, how successful was a supplier in obtaining business when bidding through requests for quotes (RFQs). Product and service quality can be determined based on over, short, and damaged cargo (OS&D) data from receipts at distribution centers or warehouses, as well as on feedback from quality assurance/quality control (QA/QC) personnel in the field who inspect, install, and use the product. (If nonconformance data are to be used in BI analyses, it must be accessible to the BI application, rather than simply residing in a written report.) On-time delivery measures the actual delivery date versus the promised or required delivery date. (It should be mentioned that a "promise" date in a purchase order is a contractual commitment; a required delivery date is the customer's desired date.) Service levels can also be measured by bid responsiveness (the percentage of RFQs for which the supplier submitted a bid), and the percentage of purchase order acknowledgements.
A caveat: The accuracy level will not be the same for all data, especially when some data require manual input. Decision makers must always have a realistic view of data quality.
Using key metrics for mutual benefit
Once the critical criteria have been established, it is easy to develop the metrics that will be used in the strategic-supplier evaluation process. Most BI programs come preprogrammed with reporting tools for such items as spend, demand, and performance. However, software that allows tailored metrics, reports, and analyses is available. Depending on which factors are the most important for a given product, a weight can be assigned to each, so that an overall score can be calculated.
The primary method of displaying the data in BI solutions is through a dashboard. Using software such as Tableau, the various criteria can be graphically depicted. "Speedometer," pie, or red/yellow/green charts clearly demonstrate at a glance how well a supplier is performing.
Using BI solutions to provide performance metrics to strategic suppliers helps them answer the four critical questions mentioned earlier. It also creates a win-win situation for both buyer and supplier because it incents suppliers to improve their performance.
For example, if the supplier sees that its prices and quality are good, but its on-time delivery is substandard, it will know exactly where to focus its efforts in order to be more competitive. Or if its performance deteriorates, the instantaneous feedback provided by the BI solution alerts the supplier that something is amiss, so it can quickly take action to return to its previous performance levels. When the relevant information is not available, or it takes much longer to obtain, the supplier may suffer a loss of business without knowing why. With a BI application, that is not the case.
Here is another example. The BI solution informs the buyer how well each supplier stacks up against its competitors. It also tells suppliers the criteria by which they and their competitors will be evaluated, thus setting up a healthy competition among them. If a strategic supplier sees that it has high scores for quality and on-time delivery but has a low overall score, it may be incented to reduce its prices in order to be more competitive.
When sharing performance data with suppliers, however, it's important that they know the overall criteria used to evaluate their products and performance but are not privy to the exact formula used in the matrix. That way they cannot manipulate the data to "game" the system.
Yet another advantage of BI solutions is that all the data used to evaluate suppliers are real-time and verifiable. This completely removes subjectivity from the evaluation process and "tells it like it is." If, say, a supplier promises to deliver by a certain date, but the actual delivery date was later, the sy