Category Archives: Spend Analysis

Information … Information … Information

Yesterday’s post discussed the lack of realistic starting points for an average organization that wants to merge onto the value focussed path and the need for information. Then the post discussed e-RFX applications and how they are not always the answer as most are not configured for collecting more than a moderate amount of data, and the information required to make the right decision might require a large amount of data to be collected.

For example, consider the information required to make the right decision in a global freight bid where the company has over 5,000 lanes across five continents that are currently being serviced, in part, by almost 500 carriers. Not only will there be a need to collect up to 1,000,000 LTL and TL bids to know what the lowest rates are, but there will be a need to collect data on capabilities (refrigerated, freezer, hazardous martial, etc.), capacities, and serviced lanes. And then, once all of the information has been collected, past performance, guaranteed service levels, (commitments to) sustainability (such as biofuels and hybrid vehicles) will have to be considered in addition to costs and on-time-delivery capabilities. And if multiple carriers are almost equal, long term viability, strategic partnerships, and/or commitment to social responsibility might also need to be considered.

All-in-all, this represents a significant amount of data that needs to be collected, analyzed, and distilled into useful information — data that is not even going to be collected if a firm is still using a first-generation e-Sourcing platform. This is because:

  1. Traditional RFX tools, which are now a commodity (as every provider and their dog has one — trust me), are not built to collect that much information.
  2. Most of the RFX tools that can handle that much information, typically by way of Excel import and export, are not designed with supplier usability in mind. No supplier is going to quote 5,000 lanes at multiple LTL and FTL levels if they only service 3,000 and 2,000 can be broken into 20 cross-regional groups where each lane in the group is priced the same by mile.
  3. Of the few tools that allow for generic pricing and (typically) single-dimensional overrides, most won’t designed with the ability to easily design multiple levels of overrides and the OLAP-like navigation that’s really need to quickly zoom in on the relevant data items (which need to be viewed or altered).
  4. And while most of the better RFX tools allow a user to define as many RFIs, RFPs, and RFQs as the user desires, these generally have to be crammed into rigid workflows that may or may not fit the scenario at hand.
  5. Plus, while most of the tools can push data out into an auction or a SIM tool (that is the foundation for SPM and/or SRM), most don’t allow data to be pulled back in, since the first generation e-Sourcing model was a linear RFX -> Auction -> Decision Optimization -> Award -> Contract Management -> SPM flow.

And then, once you get past all that, you still have to analyze the data to distill the information required to make a good award decision. Because even the best strategic sourcing decision optimization on the market will fail if it’s not provided with the right data AND the right constraints (or, depending on your choice of terminology, rules). The right constraints can only derived by a knowledge individual that has the right information at her disposal.

So how do get the right information? You take your sourcing to the next level. So what does this Next Generation Sourcing look like? Stay Tuned.

VFS Enablers: Competitive Enablers in a New Wrapper

Generally speaking, I’m not hard on CAPS Research because they tend to produce some of the best research and papers in the space, but I had to take a crack at VFS in yesterday’s post because I don’t think we need another acronym. And while it may look like I’m taking another crack at their recent “Value Focused Supply” publication in this post, I’m trying to point out that the next level of strategic supply management in your organization, regardless of what you call it, isn’t that hard to obtain. It’s just the next rung on the ladder, and only one small addition to the capability repertoire will get an organization there.

According to the white paper, the critical enablers of VFS are:

  • executive engagement
    No initiative will succeed over the long term without executive engagement, which is also a critical enabler of classic competitive supply strategies.
  • value chain goal alignment and measurement
    This is a fundamental requirement of any supply strategy designed to enhance an organization’s overall competitive position — and a core requirement for any enhanced competitive supply strategy, such as DDSN and TVM.
  • supply market understanding
    Without supply market understanding, even a simple e-Auction will fail miserably.
  • collaboration approaches
    The best results always materialize from collaboration.
  • supplier relationships
    Without a good supplier relationship, quality, on-time delivery, and emergency orders are at risk.
  • organization and human resources
    The right people will always be required to pull the strategy off.
  • information/analytic capabilities
    This is essentially the only enabler that’s new, sort-of. While information/analytic capabilities are a requirement of competitive sourcing strategies, as good information is necessary to select the right strategy and analyze the bids, classic competitive sourcing did not require decision optimization, modern (POS-based) forecasting techniques, inventory optimization strategies, or (true) spend analysis.

Thus, any organization that has mastered standard competitive sourcing can easily move on to next generation sourcing strategies simply by adding a new tool or two to their toolkit — complete overhauls not required.

Share This on Linked In

Should You Really Care About the Finance Classification Hierarchy?

A recent article in CPO Agenda on “a meeting of the minds” that discussed the need for Procurement and Finance to establish a common framework put forward five suggestions on what an organization can do to make it happen. Four of the suggestions were really great, but the last one, which said that Procurement and Finance should “establish common organization and spend classification hierarchies in spend analytic and value-tracking pipeline tools” has me scratching my head.

If the article had suggested that Procurement and Finance should establish a common reference classification hierarchy that Procurement could map too, that would be different, but instead the article says that “the spend analytics programme and value-tracking pipeline should share a common organization and spend classification framework“. There are two problems with this logic.

First, there is the built-in fallacy that one spend cube is enough. It’s not. You need a spend cube for AP data, a spend cube for Invoice data, a spend cube for utilization data, etc. You need a spend cube, and an appropriate hierarchy, for everything you can think of analyzing. The real savings in spend analysis doesn’t come from analyzing canned reports — it comes from having a hunch, analyzing the data, and walking away with either a savings opportunity or a better informed hunch as to where the savings opportunity truly lies. A true spend analysis system lets the user build new cubes and hierarchies at will, because, otherwise, data analysis is avoided and savings go unrealized.

Secondly, the hierarchy most appropriate to Finance and the financial and tax reporting they need to do is often the least appropriate hierarchy for Procurement and the spend analysis it needs to do. As a result, a compromise isn’t going to help either party. It’s just going to create a common language that Finance can use to explain why it now takes them 50% longer to do reporting and that Procurement can use to explain why they can’t find any savings opportunities.

The answer is to define a common reference classification that each side can map too after they performed their analysis and created their reports. After all, ETL Tools are a dime a dozen these days, and most good spend analysis or BI tools come with one or more built in. As a result, such mappings can be easily automated to occur automatically on a fixed interval or after analysis is completed and each department can then view the hierarchy in a manner that makes sense to them. No need for unproductive compromises.

However, as mentioned at the start of the post, the other four suggestions are good. To develop a common language:

  • Establish a savings framework (and definitions),
  • define and implement a disciplined engagement model,
  • produce timely, consistent, and accurate reporting, and
  • capture opportunities created for profit improvement.

Check out “a meeting of the minds” for more details.

Share This on Linked In

Spend Rappin’ (3rd Repost)

It’s Boxing Day! And you know what that means … at Sourcing Innovation, it’s Spend Rappin’ time! (It’s a holiday tradition!)


To the Tune of “Christmas Rappin'” by Kurtis Blow

Don’t you get me all that JIVE about code you used before I’s alive,
Cause this ain’t 1965 – ain’t even 1999!
Now I’m the guy named Lamoureux and Spend is one thing that I know.
So every year, just about this time, I celebrate it with a rhyme!

Gonna save it, gonna shave it, gonna make it good,
Gonna take it all down through your neighborhood.
Gonna wring it, gonna sling it till it’s understood.
My rap’s about to happen, like the knee you was slappin;
Or the toe you been tappin’ on a hunk of wood.
‘Bout a two fisted dude, with a friendly attitude
and a sack full of savings for the people on the block.
He’s an old grey beard, maybe looks kind of weird,
and if you ever seen him he could give you quite a shock.

Now people let me tell ya about last year
when the dude came slicing spend through here.
Well the wit was out, the gloves on the ground,
folks stayed to watch him cut it down.
The beat was thumping on the block,
and they were glued to just one spot,
as the master cubed at a solid pace,
…
got a taste of the waste thrown in your face.
…
And this old spend slayer laid down a heavy layer
of his slicing dicing rhythm to a tree-mapped beat.
And the guy with the database started to participate,
and I could sure appreciate the spend roll up neat.

We were all in the mood so we had a little brood,
not a sound did abound, as he plowed through the mound,
then I thought I heard a gasp as he sliced through the past,
and laid our mav’rick spend bare, as I flopped into a chair.
So I went to the attic where I thought about the static
that our last spending tool was programmed to always give.
And I threw up my arms at the industry yarns,
Just a trick, a nick, and I’d let the suckers in.

He was quick, he was sharp and always on the mark,
he had a lot of success on his chinny, chin, chin.
He avowed, he was proud of the savings he allowed
from the tip of the ‘burg he found the savings within.
He’s cool for a fool throwin’ out every rule
every hour of the day when the cold winds blow.
Though the beard was-a cleared, I still have never cheered
like I did in the storm when I was in the know.

I said you’re right, my spend’s a fright,
Can you stop for a drop before you have to go?
He said “Sure, Bill, if the wine is chilled
and I’ll stake a steak down at the Monaco”.
So we went out back and discussed the stack
of invoices that had all been over-paid
and every dollar spent off of the contract
and then we laid it all bare till we made the grade.

And before he went this fine old gent,
finding gifts went to sift through his spend reports.
From the top to the bottom he reached in and got ’em,
spend trends for me, and variances from torts.

And the higher-ups got presents too,
Banned suppliers and a stale contract.
A bloated pie ’bout as clear as the sky,
the best that money couldn’t buy.
Cause money could never ever buy the feelin,
the one that comes when there’s no concealin’
of your spend by a tool that’s new
and that’s what Strovink‘s does for you.

The dude ya read’s back at the keys,
up late till all’s where it should be.
But if he were right here tonight,
he’d say Truthful Spending and to all a good night!

For my new readers, this cheerful verse is the result of a sly comment by Eric over on e-Sourcing Forum back in 2007 on How Not to Get a Job.

P.S. Those of you who have been around for a while might remember his groundbreaking and visionary series on e-Sourcing Forum and here on Sourcing Innovation in 2006 and 2007, and his new visionary series that launched this year, indexed below.

e-Sourcing Forum

  • “Web 2.0″ Spend Analysis – Introduction
  • Data, Data Everywhere
  • How Clean is Clean?
  • “Change” Does NOT Equal “Refresh”

Sourcing Innovation

Christmas Rappin’


by Curtis Blow
mp3
 on YouTube

(Since it’s difficult to find complete and well-formatted lyrics on the web.)

Don’t you get me all that JIVE about things you wrote before I’s alive,
Cause this ain’t 1823 – ain’t even 1970!
Now I’m the guy named Kurtis Blow and Christmas is one thing I know,
So every year, just about this time, I celebrate it with a rhyme!

Gonna shake it, gonna bake it, gonna make it good,
Gonna rock shock rock you through your neighborhood.
Gonna ring it, gonna sing it till it’s understood.
My rap’s about to happen, like the knee you was slappin;
Or the toe you been tappin’ on a hunk of wood.
‘Bout a red suited dude, with a friendly attitude
and a sleigh full of goodies for the people on the block.
Got a long white beard, maybe looks kind of weird,
and if you ever seen him he could give you quite a shock.

Now people let me tell ya about last year
when the dude came flying over here.
Well the hawk was out, the snow’s on the ground,
folks stayed in to party down.
The beat was thumping on the block,
and I was dancing in my sock,
and the drummer played at a solid pace,
…
and a taste of the base was in my face.
…
And the guitar player laid down a heavy layer
of the funky junky rhythm of the disco Beat.
And the guy with the 88 started to participate,
and I could sure appreciate it sound so sweet.

We were all in the mood so we had a little food,
and a joke, and a smoke, and a little bit of wine,
when I thought I heard a hoof on the top of the roof.
Could it be or was it me, I was feeling super fine.
So I went to the attic where I thought I heard the static
on a chance that the prance was somebody breaking in.
But the noise on the top was a reindeer clop,
Just a trick St. Nick, and I let the sucker in.

He was roly, he was poly and not the holy moly,
you got a lot of whiskers on your chinny, chin, chin.
He allowed, he was proud of the hairy little crowd
on the point of the door where the skin should’ve been.
Get’s cool for a fool throwin’ out every yule
for a day on the sleigh where the cold winds blow.
So the beard maybe cleared, but I never have a-cheered
’cause it’s warm in the storm when it’s ten below.

I said you’re right it’s cold tonight,
Can you stop for a drop before you go?
He said “Why not if the music’s hot
and I’ll chance a dance beneath the mistletoe”.
So he went downstairs and forgot his cares
and he rocked the spot and danced like a pro.
And every young girl tried to rock his world,
but he boogie oogie oogied till he had to go.

And before he went this fine old gent,
finding gifts went to sift through his big red bags.
In the top for the bottom he reached in and got ’em,
toys for the boys, and for the girls flat rag.

And the grown-ups got some presents too.
A new TV and a stere-u.
A new Seville ’bout as blue as the sky,
the best that money couldn’t buy.
Cause money could never ever buy the feelin,
the one that comes from not concealin’
the way you feel about your friends
and this is how the story ends.

The dude ya read’s back at the pole,
up north where everything is cold.
But if he were right here tonight,
he’d say Merry Christmas and to all a good night!

Analytics is for Industrial Manufacturers Too

I’ve written dozens, sorry, dozens upon dozens of posts on Analysis and why every organization should be using it. So I’m not going to go into the details again in this post, but make it crystal clear for you business types who have yet to sign the cheque:

High-performance businesses — those that substantially outperform competitors over the long-term and across economic cycles — are five times more likely to use analytics strategically compared to their peers.
“Using More Analytics Can Help Industrial Manufacturers”, Industry Week.

Now, it’s true that correlation is not causation, as Pinky and the Brain skillfully informed you in their lesson in statistics, but a multiplier of five is very significant. It means that the use of advanced analytics tools is definitely a common trait of industry leaders and if you’re not sure how to become an industry leader, the best way to start is to emulate what the leaders do.

Share This on Linked In