Category Archives: Spend Analysis

Storytelling in Data

Today’s guest post is from Doug Hudgeon, Director of PitchMap, and a long-time Procurement blogger. Back in the day, he authored a vendor relations blog on WordPress (at hudgeon.wordpres.com) and more recently he authored the Operating Efficiency blog (at OperatingEffieciency.org), which has now been ported to the PitchMap Blog. It originally appeared on the PitchMap blog yesterday (Storytelling in Data), and is being reprinted with kind permission.

Now that we’ve introduced Pitchmap, I’m returning to topics on business operation efficiency. Today’s topic is Telling stories in data: Using data to support your arguments

Yesterday, I attended the first Australian IACCM meeting of the year. The two presenters spoke on very different topics, “Clean energy laws and carbon trading” and “Utilities Benchmarking” but both presenters were equally adept at using data to underpin their arguments. Today, data is everywhere and an effective business person must be an expert in presenting their arguments using data. In my view, there’s nothing like a story to make your audience feel that change can happen and a vision can be achieved.

Storytelling in Data

Let’s look at some Pitchmap data to show how data can be used to tell a story. This data compares the procurement processes of three companies (Salamander Logistics, Melbourne Transport and Queensland Trucking) with each other and with an optimised process. The columns in the chart show the cost per transaction: the higher the column the greater the cost per transaction. The type of transaction is shown by the label above the columns.

< image no longer available as source no longer exists >

The first story in the above data is indicated by the red arrow. It shows that Melbourne Transport is spending about the right amount on Vendor Creation processes whereas the other two companies, Salamander and Queensland, appear to be under-investing. This does not say that Melbourne Transport is doing it right, just that they are spending about the right amount on it.

The second story is indicated by the yellow arrow. The story within the data is that Melbourne is better than its peers but higher priced than optimal. Interestingly, the purple section of the column (transaction costs relating to invoice processing) is the same as the optimised process but the green section of the column (transaction costs relating to placing orders) is significantly more expensive. This indicates that Melbourne Transport should be focusing its process improvement initiatives on order placement rather than invoice processing.

The last story is highlighted by the blue arrow. Melbourne Transport and its peers are significantly more expensive than the optimised process. This should serve as a red flag in any attempt to re-engineer this process given that no one is doing it particularly well. It may well be that there is some aspect of expense processing such as regulatory requirements in this industry or geography that adds to the cost of the process and further investigation should be undertaken to ascertain whether this is so.

The keys to successful storytelling

The keys to being able to tell stories with data are four-fold:

  1. The data must be clearly displayed – preferably on one page,
  2. The data must show where you are now and where you could be (either by reference to an optimal state or comparison against your peers or benchmarks or all three),
  3. The data must be sufficiently detailed to make the story interesting, and
  4. You need to be able to dive into the details underlying the data when your assumptions are questioned.

Doing so will enable you to present a compelling picture (as in the chart above) of what needs to be changed, how it needs to be changed, and what further inquiries need to be undertaken to resolve outstanding questions.

In my next post, I’ll discuss how to collect and present variable data in a compelling manner.

Thanks, Doug!

Spend Visibility: An Implementation Guide – The Definitive Book on Next Level Performance

Don’t forget to take advantage of this great offer and Download Sourcing Innovation’s “Spend Visibility: An Implementation Guide” – The Definitive Book on Next Level Performance for FREE! No Registration Required!

But don’t take Sourcing Innovation’s Word For It! Listen to these reviews from leading bloggers in Supply Management:

A Rare Medium Well-Done

Vinnie Mirchandani, Deal Architect (January 18, 2012)

This book gets to the science of spend analysis vs. treating it as an art.

Jason Busch, Spend Matters (December 8, 2011)

The guide is well thought-out, practical, and well-written.

Stephen Guth, Vendor Management Office (February 4, 2012)

This guide is very comprehensive and will provide valuable information to both procurement functional and IT implementation focused readers.

Bob Ferrari, Supply Chain Matters (January 17, 2012)

It is, in fact, one of the most comprehensive step-by-step resource guides I have seen for this industry.

William Dorn, The Strategic Sourceror (January 17, 2012)

Managing Indirect Spend: An In-Depth Review, Part III

In our last post, which ended the review of Part II of Managing Indirect Spend, a new book by William (Bill) Dorn and Joe Payne of Source One that takes you on an excellent adventure through the world of indirect sourcing (that they have been living in for the past two decades, well before Strategic Sourcing and Supply Management became cool), we discussed the non-software tools at a sourcing professional’s disposal, Procurement Services Providers (PSPs), and the (common) mistakes that can kill a sourcing project. This wrapped up our discussion of the capabilities at a sourcing professional’s disposal. Today, we’re going to discuss Part III, Examples from the Field, and focus on some of the results that can be obtained when applying the best practices discussed in the section.

The examples focussed around the gains that can be achieved by collaborating with suppliers, leveraging supplier feedback, and analyzing data — which, as SI outlined in Spend Visibility: An Implementation Guide, we know to be significant even before the application of additional tools and techniques. We’ll start with supplier collaboration.

As Bill and Joe point out, collaborating with your suppliers can produce surprising and profitable results. In fact, collaborating with your entire supply chain (including your suppliers’ suppliers) can often produce sustainable results that equate to large cost savings opportunities. Plus, it encourages partnerships with your suppliers, which may lead to your company being the first in line for new product developments or other supplier benefits.

Consider these examples from the text:

  • specifying printer models and toner requirements, instead of brand name toner cartridges, generally leads to savings north of 50% when suppliers are asked to propose low-cost (non-OEM) solutions
  • the cost of a simple chemical compound was reduced 39% when the buyer worked with the supplier to jointly source expensive regulatory valves at a higher volume
  • the willingness to work with a new supplier that produced a required solvent at an insufficient level of purity (and guarantee them a reasonable amount of business under the right circumstances) if the supplier was willing to refine their manufacturing process to get to the required level of purity convinced the supplier to make the infrastructure investment and saved the customer a considerable amount of money now that a third, lower-cost supplier, had entered the market

In addition to collaborating with suppliers, you can use the information they provide to your advantage. By leveraging the information that your supply chain provides, you can actually achieve deeper discounts in the products or services you are buying, and improve the overall relationship and integration with each of your suppliers. This can lead to results like the following:

  • by working with suppliers to find out what was possible, the buyer was able to approach the incumbent and ask for a new type of telecommunications infrastructure that reduced organizational cost by 35%
  • by working with the supplier to find out when the supplier wanted to make a sale, and the supplier representative, who was quite eager to make a bonus target, the customer was able to get a software product (only available through resellers) at cost with terms of net 30 days, allowing it to delay the purchase to the following quarter (while still allowing the supplier, and the representative, to recognize the sale this quarter)
  • a buyer which needed specialized multi-million dollar computer equipment that could only be supplied by one supplier was able to reduce its costs and get millions of free marketing by allowing the supplier to use its logo in its advertisements (which the supplier promised to spend millions on if the buyer allowed the use of its logo)

Lastly, there are great opportunities to be had through data analysis, including:

  • a detailed line analysis that will often identify a significant number of (secondary) phone lines that are not required that are costing the organization hundreds (or thousands) each
  • the appropriate segregation of MRO spend into the right buckets that will allow suppliers to be more competitive on the categories they are strong in, as this will decrease overall cost significantly
  • the identification of non-compliant spend and the top offenders as a few choice words from the CFO to these individuals (or their superiors) will considerably decrease maverick spend quickly increase realized savings 20% to 30%

There are plenty more examples, but considering that SI essentially co-wrote a book detailing what they are and how to find them in Spend Visibility: An Implementation Guide (free download, no registration required), we’re not going to go into them any further in this post, especially since the important lesson is that you should be leveraging the information provided by the supply chain (for analysis) and then working with your suppliers to implement the best solution(s) you identify.

Stay tuned. After another break, SI will conclude it’s review of Managing Indirect Spend later this month with Part IV: How to Do It.

Series to date:

Managing Indirect Spend: An In-Depth Review, Part I.1

Late last year, Joe Payne and William (Bill) Dorn of Source One released their first book on Managing Indirect Spend (Amazon) which is a culmination of everything they have learned while doing nothing but Strategic Sourcing since 1992 — before it was cool. Clocking in at 422 pages, this is an incredible resource for anyone who wants to get a handle on indirect spend, which has increased significantly since outsourcing and right-sizing rose to fame in the 1990s.

This book, which should be on the desk of everyone looking to get a handle on indirect spend, is loaded with so much information that there’s no way SI could do it justice in just a post or two — so it’s not going to even try. Just like the book is broken down into four parts, our review, over the next few weeks, will be broken down into four parts — and then into sub-parts where there is just too much to comment in with a single post.

Today we’re going to review the first part of Part One – The Process, and, specifically, the chapters that cover the first three parts of their six part process, namely:

  • Data Collection & Spend Analysis
  • Research
  • The RFx Process

We’re all familiar with the basic process, and if you are a regular reader who has downloaded the free e-book, no registration required, Spend Visibility: An Implementation Guide, then you are very familiar with the data collection and spend analysis process. However, the chapter still makes some good points that need to be reiterated, particularly in regards to building sponsorship and understanding the category. Lack of sponsorship will kill your project faster than a minnow can swim a dipper, and to get it you need the end user’s support as well as senior management. As Joe and Bill state, this will require sitting down with the users and letting them know that they are not being singled out by your spend project, that your project’s success depends on them and is their success as well, and that your project is designed to tie to their objectives (as it should be). In addition, the following is a great checklist of information you will have to review with your users before starting a serious sourcing project on the category:

  • business relationship (with current suppliers)
  • product or service utilization specifics
  • location impact
  • financial implications
  • contractual obligations
  • reports, requirements and actual utilization
  • service requirements and expectations
  • supplier ranking

Joe and Bill also provide some great advice on how to handle the three different types of responses that you will encounter when requesting data from incumbent suppliers — acceptance, avoidance, and pushback — and questions to consider during supplier interviews.

Moving on to the research phase, they provide a breakdown of the eight (8) elements that need to be researched during any sourcing initiative (that you want to be lucky) as well as some great tips for collecting market intelligence through the RFI process. While modern tools, including Source One’s own WhyAbe, make the creation of RFIs drop-dead simple, getting responses and, in particular, the responses you want can be challenging for a variety of reasons. Suppliers might not think you’re serious, might not want to expose what they consider to be sensitive data, or might not be comfortable with the tool. A carefully constructed process has to be put in place, followed, and sometimes augmented by other approaches for the research phase to be truly successful. Joe and Bill lay out their advice, garnered from almost twenty years of experience dedicated to sourcing projects, in detail and offer a blueprint for your success.

Then they jump into the full RFX process, which might consist of an RFP and / or an RFQ/RFB and dive into the typical elements of a good RFP and RFQ as well as the evaluation process that should be followed and the response that should be provided if you want your suppliers to participate in the process again. One point that they make that most other resources miss is the need to include disclosure and liability sections in the RFx document. This is critically important when inviting new, unknown, suppliers to an open event. If these suppliers aren’t awarded the business, they may sue you on the premise that the invitation for bid was in fact an invitation to do business and that the RFx constituted an MOU to be replaced by a future PO or contract once the information was provided. Slimy and shady to say the least, but this has happened. They also discuss the reverse auction process and when it is preferable to an RFX. Finally, they end their discussion of the first half of the sourcing process with a discussion around the need for flexibility and creativity in the sourcing process, a discussion that’s often overlooked. Significant savings are never found by doing the same-old, same-old or just applying one or two sourcing technologies. They are found when the parties come to the table, broaden their horizons, and look for new, creative, and innovative ways to meet organizational needs. And, as Bill and Joe state, suppliers are often much more motivated and engaged when buyers take an alternative approach. So be flexible — and stay tuned. Part I.2 is coming!

Peter Smith Nails Why the doctor Does Not Do Predictions

Traditionally, the New Year is a time to think about how we can become better people … and of course, the chance for writers and analysts to sit at their keyboards with a cold beer and make a list of wild guesses, predictions and ill-informed comments, desperately pretending we have some particular insight into the world!
Peter Smith, Ten New Year Resolutions for 2012, BravoSolution.com

the doctor has insight into what you need to do today, but has no more insight into what the Supply Management world of tomorrow will look like for your company beyond what anyone else has. He can predict what is likely, but all it takes is one earthquake, political uprising, or stock market crash to turn everything on its end. Fortuntately, Peter’s paper is filled with advice for today and not tomorrow.

In particular, the doctor likes resolutions:

2. I will make sure we do proper risk assessment on our key supply chains – and that doesn’t just mean our “top ten suppliers”.
How exactly are you keeping track of your key suppliers’ financial situation, their accreditations or quality record? What is your mitigation strategy in case of supplier failure or natural disaster, for each of your critical raw materials / sub-components? Do you have any sense of which firms at second or third tier level in your supply chains could actually cause your organization severe problems? What about corporate social responsibility issues? the doctor would bet that you are not keeping track of key suppliers’ financials, not keeping an eye on the quality metrics, don’t know which 2nd or 3rd tier suppliers could bring your supply chain to a grinding halt, or know about the poor working conditions at the factory in Da Nang.

5. I will put the supplier closer to the heart of our process and technology strategy
As Peter says, if the supplier screws up, you have failed in the eyes of the IT / Marketing / Production VP. So look at your supplier information, risk, development, relationship management strategy — closely. If you don’t help your supplier to succeed, you ultimately won’t succeed.

7. I will move to the next level of Spend Analytics sophistication.
As per SI’s recent white-paper on Spend Visibility: An Implementation Guide, almost any attempt by an organization to analyze spending patterns is likely to be fruitful, especially if there hasn’t been a serious prior attempt. It is easy to find thousands of breathless testimonials about a particular product or method — independent of the quality of the product or method — because almost any product or method will find savings if a spend visibility initiative has never been launched before. “In the land of the blind, the one-eyed man is king“. But, what is not so obvious is that this initial burst of savings is short-lived; and that many of the “quick saves” that result are unsustainable. The key question is what to do next; in other words, how to implement a true strategic spend visibility initiative that will return value and keep returning value over time. There are too many spend visibility products that are lying unused or on the shelf, after the first burst of excitement has passed; and too many organizations who are tired of hearing a spend visibility message that has no further relevance to them. That’s why you have to take spend analytics to the next level and why you should download the FREE, no registraiton required, Spend Visibility: An Implementation Guide today (if you haven’t already).