Do You Need a Spend Cube to Identify Top Underperforming Products?

No, you don’t. But that doesn’t mean you shouldn’t have one!

Let’s face it, if you have an n-step process that can theoretically be done in a spreadsheet, then it can be done in a spreadsheet — but how long will it take to do it in a spreadsheet vs. doing it in a modern spend analysis solution?

If sub-steps of the process consist of:

  1. researching and accumulating industry specific data
  2. comparing your data to industry averages
  3. repeating the comparisons with selected competitors, putting your place in their shoes
  4. looking for anomalies
  5. selecting top categories outside industry average
  6. selecting top underperforming products within those categories

How long is it going to take without a proper spend analysis product?

Industry data is going to come in many different forms, in many different tables, and will initially need to be stored in many different sheets. It will take a lot of manual effort and data formatting to get the data into a consistent format that will allow it all to be compared apples to apples. In contrast, a good spend analysis platform with ETL will allow for data to be automatically mapped to the right format will easily save hours or days of manual effort, as most good data tables will be detailed and large.

Comparisons in spreadsheets require lots of formulas and calculations, which can be tedious and error-prone to implement. Modern spend analysis packages come with lots of standard reports and templates that will allow for comparisons with industry averages and available competitor data out of the box. Again you will be saving hours, if not days, with a good package.

Anomalies are really easy to see in appropriate scatter plots, but very, very hard to spot in rows of data. If you have thousands of rows, how do you detect outliers with a manual scan? Sure you can pivot on volume or distance from average and so on, but is it really an outlier? Careful inspection and analysis is required on each potential row — but a visual glance at an appropriate scatter plot gives you results in seconds.

So no, you don’t need a modern spend analysis product or a spend cube to identify good potential opportunities, if you don’t mind dedicating a back room full of people for days or weeks to do an analysis that can be done by a good spend analysis product in a few hours.

And that’s why modern spend analysis solutions can deliver an ROI of more than 10% year over year as the expected value of analysis is typically above water, vs. under it, as it is when you do it manually. (See this classic post on .)

So while you don’t need a spend analysis solution, it’s akin to saying you don’t need modern technology for sourcing either. There’s nothing you can’t do with pen, paper, and telephone, but do you really want to remain in the dark ages?

As far as SI is concerned, there are only three reasons someone trying to sell you a sourcing suite would tell you that you don’t need a modern spend analysis solution (based on proper spend cubes):

  • they don’t have it and they don’t want you to use another vendor in case that vendor also has, or implements, a comparable sourcing solution (and they fear competition);
  • they want the services revenue (there’s a lot of billable hours to doing it manually); or
  • they truly don’t understand what modern spend analysis can do

And none of these reasons are good reasons. In fact, they are all reasons to be wary of the provider! There are only two cornerstone technologies that set leading sourcing organizations apart, and analytics is one. (The other is optimization.)

Precision is Contextual, But How Can You Get Precise?

Late last year, over on the public defender‘s blog, Pierre Lapree penned a post that asked “how many decimals of π does Procurement really need”? In short, the answer was, it depends on the context — some situations don’t need very precise calculations, and others need precision down to 1/100th of a decimal point. In his post, Pierre notes that in some situations, like savings, rounding can be to the closest power of 10. In others, like RFP, rounding to the dollar is more than enough, sometimes the closest hundred or thousand is enough. But in spend analysis, sometimes you need to match those financial statements down to the penny to get it right.

But how do you do that?

Your data is a mess, across multiple systems, in multiple formats, with varying levels of detail.

The financial reports are typically created from spreadsheets, which, even though they were output from the organization’s accounting systems, are typically riddled with errors.

And any hopes of matching, despite the fact that each system should be the checksum for the other, are as fantastical as J.K. Rowling’s beasts.

So how do you get precise?

You get out of the data and into the real world. When you don’t know where you are in the real-world, you geo-locate. How do you do that? In today’s world, you tri-angulate your position by taking measurements with respect to cell phone towers and/or satellites and using mathematics to estimate your position as close as possible – the more readings, the more accuracy.

In other words, you take measurements. Lots of measurements. And correlate them. The financial statements are just one set of checks.

Another set of checks are inventory levels. You’re paying for physical goods — you should have payments and invoices for the majority of physical goods and vice versa.

A third set of checks is the accounts receivable system — every part or good that was bought for (re)sale should not only have a corresponding inventory entry but an invoice, and vice versa.

In other words, every enterprise system that tracks goods and services is a data point for correlation, and should be used as such. Don’t just focus on the dollars and cents, as trying to balance erroneous totals can lead you down the wrong path — use all the data at your disposal to get it right — and precise.

Seal Software: Breaking the Seal to Identify Contract Value

Seal Software is a provider of contract discovery and contract analytics software that is different than your standard CLM (contract lifecycle management) module built into your e-Sourcing or e-Procurement suite (which is designed to negotiate and track contracts, awards, milestones, and related documents). And unlike many CLM providers that just focus on Procurement, Legal, or Sales, Seal Software is designed to support Legal, Procurement, Sales, M&A, and IT — making it a fuller enterprise CLM solution than many of its peers. In fact, in large organization with tens of thousands of contracts, Seal Software is often used in conjunction with a traditional CLM solution.

This is because Seal’s strengths of contract discovery and contract analytics are quite unique. Seal’s contract discovery capability can automatically locate existing contractual documents wherever they may reside, automatically extract key contractual terms and clauses, and automatically populate other corporate solutions including Customer Relationship Management (CRM) and Contract Lifecycle Management (CLM).

The discovery engine can handle multiple file format types (text, doc[x], PDF, jpg, etc.) and work across local hard drive, network drives, file shares, and even cloud-based repositories — anything with a UNC path or API is accessible. It then uses advanced semantics and machine learning to analyze the contracts and identify the clauses and critical information that the organization has deemed to be of interest.

It does this by comparing all files discovered to standard contract templates and identified organizational contracts to find contracts. It then determines the type, category, and whether or not it is a (potential) duplicate. Finally, it runs all (unique) contracts through descriptor templates that identify and extract the clauses, terms, and date elements of interest.

But the power of Seal only starts at discovery. Once the contracts and elements are identified, the analytics solution not only allows the user to access all contracts that meet a specification or search; filter down based on timeframe, search, or other elements of interest; and create reports, but to also identify all contracts that contain clauses or terms of interest that were not previously of interest. If all of a sudden a new regulation comes into effect and the organization now has to determine whether or not all of its contracts are compliant with a new privacy requirement or contain clauses to ensure compliance. All the organization has to do to find all contracts with a relevant clause, paragraph, etc. is find a few contracts with clauses and sentences of interest, define any additional phrases or terminology of interest, and tell the system to re-process all contracts and it will find all contracts, structured or otherwise, that contain associated phraseology. The semantic engine can learn from examples and key-phrase definitions.

And the analytics can be used during negotiation and review too. The platform allows for the definition of policies that will auto-detect clauses and phrases in suggested revisions that can alter the intended meaning of the actual contract and bring them to the attention of the reviewers. It can also highlight contract areas using non-standard language or language identified by legal to be (high) risk. And this review can be done in the contract creation platform of choice. Seal’s newly released Analyze this Now capability allows links to be embedded that send the contract to seal which sends back a marked-up highlighted docx file that highlights everything of interest and concern. (In Microsoft Word, it’s a simple plug-in.)

It’s a very powerful solution for large (global) organizations that often have well over 10,000 or even 100,000 contracts that need to be tracked, analyzed, maintained, and negotiated in accordance with a plethora of business rules and industry (and government) regulations. When you consider that even enterprises with revenues below $250M have an average of 8,000 Procurement contracts (as per Aberdeen Group), most of which are not in the e-Procurement system (and not effectively managed and tracked), the importance of discovery and analytics cannot be underestimated.

For a deeper dive on Seal Software, and its capabilities, see the recent Pro series by the doctor and the prophet over on Spend Matters (Part I, Part II, and Part III) [membership required].

Swegways for Smegheads this Valentine’s Day!

Despite the fact that more and more natural resources are becoming scarce, there are still quite a number of smegheads that haven’t adopted the 3Rs.

Up until now, it’s been quite perplexing as to how we can deal with this problem.

However, after catching up on the public defender‘s blog and reviewing “the 10 cautionary supply chain tales of christmas”, we think we have a solution!

Since these smegheads often feel entitled (after all, they are taking the environment for granted), play to that entitlement and give them a free Swegway hoverboard and tell them they deserve it, that they shouldn’t have to use their own two feet to get around. And when the Swegway goes up in smoke, chances are, one way or the other, they’ll get the message. 😉