Category Archives: X-emplification

The 12 Days of X-emplification: Day 2 – Spend Analysis

As you have probably figured out by the large number of postings to date on spend analysis, a strong understanding of the data behind spending is pivotal to the proper identification and management of your spend initiatives. Here are some key questions to ask, and answers you should be expecting.

1. How much flexibility do I have in spend cube creation?

Spend analysis is more than just one A/P level spend cube. It’s many cubes. It’s multiple cubes by supplier by commodity for contract compliance. It’s cubes for purposes outside “normal” spend analysis. For example, this could include an analysis of transactional data not necessarily related to spend per se, such as cell phone usage patterns or help desk support calls, but any data where an improved understanding can lead to process improvements which impact organizational spend. It’s cubes for throw-away analysis, cubes that are derivative of other cubes, and so on.

So, you need to be able to build your own cubes, modify your own cubes, and, in many cases, map your own cubes*. This needs to be easy and fast, so that your analysts spend their time analyzing the data, not wrestling with the data for days or weeks before the analysis can even be started.

* The exception is when you know the data has been properly mapped by an expert in the data source you are using. However, this is not the normal situation at most companies, especially in commodity and indirect spend, and you will find that you have to do mapping the majority of the time.

2. How should I deploy spend analysis?

It doesn’t make sense to share a spend cube between your analysts, unless you want to set up a UFC Grudge Match in the hallway to decide who gets to implement his/her changes next. Unlike the central data warehouse, analysis cubes need to be private, not public (although sharing public cubes can be useful for casual informational purposes). The popular notion of a central data warehouse as the basic ingredient for detailed data analysis is wrong, and that’s why there’s so much unhappiness among data analysts with both BI systems and with the majority of spend analysis systems today.

3. What if I am resource constrained, and I need to outsource spend cube services?

Make sure that if you outsource cube development to the vendor, or a third party that works with the vendor, you can do it in such a way that your own people get trained along the way, so they can take over at any time. With the exception of the more complex direct spend categories, which require complex bill of materials and engineering-specific knowledge to properly map, most spend isn’t that hard to map, and this is especially true in the purchase of commodities. Furthermore, you need to make sure there’s more than one source for services with the spend analysis system you select. This is not only because you might want to throw the services business out to bid, but because you don’t want to be waiting on a resource constrained vendor every time you have spend to map and need help. (Let’s face it, just because you should be able to do mapping on your own, this doesn’t mean you’ll have the skills or insight to be able to do it the first time without some help.)

4. How much reporting flexibility do I have?

Reporting is where the rubber meets the road, and despite marketing noise to the contrary, no set of static reports will get you past the first corner. If your analysts are downloading transactions to their desktops in order to construct a report or conduct an analysis, that should be the first clue that your spend “analysis” system isn’t an “analysis” system at all.

It should be possible for your analysts to construct new reports and models easily and quickly, and they shouldn’t have to be IT experts. After all, that’s the whole point of spend analysis!

5. What should I know about data cleansing?

Cleansing is a term that involves “classifying” like items together (for example, multiple entries of “IBM” in the vendor master) and “mapping” spending to a useful sourcing commodity hierarchy. Classification is mostly the elimination of redundant vendor entries, although when collecting spend from multiple sources, it can include the creation of over-arching General Ledger and Cost Center categories. The spend analysis vendor should provide hierarchy classification tools that make the classification process simple.

Some spend analysis vendors make a big deal about classification, but 95-97% of the problem is redundant entries, not issues such as “Lotus” being owned by “IBM.” You’ll find that in most cases your own commodity managers are well aware of who owns whom, and don’t need any help in this area; but if you’re still doubtful, there are third party vendors who will create a who-owns-whom hierarchy out of your Vendor Master for $0.10 to $0.15 per line item.

Spend analysis vendors also make a big deal about mapping, but that process is also straightforward in the majority of commodity and indirect spend categories. (Direct spend categories, where you have to create hierarchical bill of materials that allow you to determine the impacts of raw material or labor cost increases and to perform make-vs-buy analysis, can be quite involved, but unless you are a manufacturing organization, this is not the norm.)

Make sure your spend analysis system supports an overlay-type mapping scheme that allows you to prioritize mapping rules or mapping rule groups in a reasonable way. Prioritizing rules is important, because it allows you to apply basic engineering principles (the famous 80-20 rule) to mapping your spending. The idea is to organize your rules such that each successive rule group maps more and more specifically, but also so that each successive rule group can focus on a smaller and smaller number of transactions. Using simple techniques that are widely published and well known, you can be up and running with a 90% spending map in just a few days. (And this is usually more than enough to allow you to perform initial analysis to find key categories to focus on as part of your first set of spend management initiatives after acquiring a real spend analysis system.)

You should also ensure that the vendor provides a way to map free-form text descriptions. These can be helpful in cases where there is little or no useful information in terms of supplier or GL coding in commodity and indirect categories or missing engineering classification codes in direct categories.

6. Does the tool support derived and ranged dimensions?

A good tool will not only support various time periods, such as day, week, month, quarter, and year, and time period – over – time period analyses, such as month-over-month, quarter-over-quarter, and year-over-year analyses, but will also support other types of ranged dimensions, such as spend size (that will allow you to bucket your suppliers for a commodity into small, medium, and large spending buckets by dollar volume) and risk level (that will allow you to group your suppliers into low, medium, and high risk buckets based on derived risk factors).

7. Can the user fix any set of filters they choose while pivoting and drilling down into reports?

This might not sound that important, but when trying to figure out why a certain spend category is 2M over last year, when an initiative expected to reduce costs by 10% was undertaken, can be difficult if you can’t find the key source of the problem. For example, let’s say you, as the telecommunications sourcing professional at a large national organization with hundreds of locations, decided to switch long distance carriers. If all divisions and business units implemented the change, then costs should be less, not more (unless everyone is calling significantly more than expected). However, let’s say that IT and HR didn’t switch at ten of your largest locations. With a dozen divisions, and hundreds of locations, it could be difficult to determine this unless you can drill into the data, fixing divisions and units at each step, and find out that 30 intersections of division and business unit are spending more than last year. Then, drilling into each you find that 15 of these are still paying, and thus using, the wrong carrier. However, if you can’t fix multiple dimensions, or apply filters that achieve the same effect, you might only be able to figure out that IT is spending more – and then you might have to call 50 locations to figure out which ones haven’t switched. Flexibility in the analysis and reports is key!

8. What if I have multiple accounting systems?

This is actually excellent news, because you are likely to have huge opportunities for savings, given that those systems probably haven’t been combined in any reasonable way before for spend and procurement analysis.

The key for spend analysis is to ensure that the vendor provides an effective tool for translating (the “T” in the “ETL” acronym) files from one format to another. As with the other spend analysis system tools, this tool must also be accessible to, and usable by, your business analysts. You should never let yourself be at the mercy of IT or a spend analysis vendor when trying to analyze new data sources, or when merging new data sources into an existing cube.

With independence comes power; and ensuring that your analysts can control their own data processing and reporting is the key to spend analysis success. This brings us to our last question.

9. How easy is it to get data in and out of the system?

Importing data should be a piece of cake. It should simply be a matter of pointing the system at the appropriate file or URL connection, specifying the dimensions of the records to import, and pressing “import” to get the data in. Then, as pointed out in the last question, transformation and mapping should be easy for even a junior business analyst.

In addition, since the goal of spend analysis is to identify spend reduction projects, it should be easy to get the data out that you need to not only create a spend project in your sourcing system, and track historical costs, but justify the project’s creation.

The 12 Days of X-emplification: Day 1 – RFx & e-Auction

So, I bet you’re all wondering – what’s to x-emplify? I’m sure you’re saying that it’s just RFx and e-Auction … it’s been around for 10 years … and it’s pretty self explanatory. My answer to that is that you’d think it should be, but given the wide range of capabilities that exist in the various products out there, as well as the even broader range of sales pitches, I’d argue that RFx and e-Auction are still not well understood.

To help you understand what RFx and e-Auction is, isn’t, and should be – in addition to my various posts on RFx and e-Auctions, my guest contributions to the topics over on the e-Sourcing Forum (RFx and e-Auctions), and my contributions to the wiki-papers (RFx and e-Auctions), I’m going to point out some questions for each technology that you should be asking, as well as the answers you should be hearing, to help you cut through the sizzle and get to the steak.

e-RFx

0. Do I really need e-RFx at all?
I’ll probably take a lot of heat from everyone in the eRFX business for this, friend and foe alike, but if all you’re looking for is some basic information, or an occasional quote on office supplies, sometimes all you needis a free-form questionnaire or spreadsheet that’s mailed directly to recipients. It’s always interesting to see how suppliers respond to free-form questions — do they use marketing B.S., or do they have something useful and informative to say? Do they answer your questions honestly, or try to side-step them like your average politician or stereotypical used car salesman?

If you don’t really know much about the space, supplier, or type of product that you’re investigating, how can you ask anything but open-ended questions, anyway?

1. How much flexibility do I have in form definition?
Let’s face it – large template libraries are great ONLY if they offer the templates you need for the categories and commodities you need to source. You need to be able to create your own forms, from scratch, and have all of the form elements you need at your immediate disposal. You also need to be able to control and validate the data that gets entered into the form so that you can automatically compute scores on scorecards and identify important differences between respondents. You need more than free-form text-boxes – you need text boxes, check boxes, radio buttons, and tables (for starters), and you need the ability to define checks not only on individual elements but across elements and across rows and columns of tables.

If you’re building a weighting function, the weights should add up to a pre-specified number, like 100. If you’re asking the vendor to enter a delivery time, it should between 1 day and the maximum amount of time you can allow, like 60 days. “Next month” should not be an allowable response. If you’re sending out a survey to your internal departments to determine an order of priority between 10 sourcing projects, you should be able to enforce that each priority number between 1 and 10 is used only once. (Otherwise, they might all be ones and twos, and that won’t help you.)

Furthermore, it should be really easy to create such a form, re-organize the questions, create sub-sections (or pages), and enable or disable sections by vendors. (If you’re creating a general purpose vendor qualification form, you might not care about the “technical infrastructure” of your office supplies vendor.)

1a. Can I build advanced sourcing grids?
After 10 or more years of RFx software development, you’d think that this question would be a no-brainer. You’d be wrong. There are deep differences in the way that different eRFX products build grids, and there are deep limitations in many of them as to how big the grids can get, and how manageable/unmanageable the process may be. Every sourcing consultant worth his or her salt has recent horror stories of users unable to build the grids that they needed, period.

So don’t believe anyone who claims that”all of the sourcing vendors in this very-long list have ‘good’ RFx platforms.” They all have RFX platforms, but you will often find that there are profound differences between them and that many may not be suited to your needs.

2. Can the forms be completed by the vendors off-line?

Let’s face it – if you’re diligent about supplier and product qualification, and quality, you’ll be collecting a lot of information. Information that the individual assigned to complete the form is not likely to have at her fingertips, information that might take a long time to collect, and information that might take a long time to input. The individual should have the option of completing the form off-line, at her convenience, wherever she is – on the shop floor, on an airplane, or at the wifi-less beach.

Also, in this situation it is beneficial if the vendor can designate multiple individuals to handle multiple sections of the RFx, and if each individual can access, and complete, only their sections off-line.

3. Are the forms secure and uniquely identified?

Let’s face it, if you’re going to allow off-line completion, you want to make sure that the forms that are uploaded were actually filled out by the intending party. (Otherwise, their competition could fill out the forms and answer “no” to all the required regulation compliance questions, causing you to immediately disqualify what could be your best new vendor.) Furthermore, if your vendor doesn’t have unique identification built in, then you’re going to have to come up with your own unique identification method to insure that attachments don’t overwrite each other when a vendor uploads their form, or, even worse, that the different users who upload the forms that contain just their sections filled out do not overwrite the filled out sections completed by other users with blank data.

I’m going to tell you right now – point blank – that most RFX vendors don’t have this capability – and that they’ll probably try to skirt the issue by pointing out that “their user authentication algorithm insures that only designated supplier representatives can log in to the system and access their forms, and this will imply that only they will have access to the forms, and that since they will be uploading the forms through their login, the form is automatically identified” except they’ll use significantly more words while blowing though the well-practiced demo at breakneck speed in an attempt to woo you with their sizzle in an attempt to leave you too stunned to realize that this most of what they are saying is BS.

The answer you want to hear is:Yes. We use built in DEC/RSA 256-bit or better encryption combined with a unique secure digital id that uniquely identifies the form instance by user, by supplier, by buyer, and by original template instance id. And you want to hear this within three seconds of asking your question, delivered in a confident tone with eye-contact and no squirming. Otherwise, what the vendor has doesn’t even come close and they’re trying the above weasel-tactic.

Why is all that identification important? If it was just by supplier and form template and user id, then if the supplier serviced multiple buyers through the same on-demand platform, the form could be uploaded to a different buyer! If it was just by buyer and supplier and form template, then each user’s upload could overwrite the previous user’s upload when multiple users are filling out a form on behalf of a supplier! If it was just by buyer and user and supplier, then you wouldn’t know what template to attach it to if the user had mistakenly created two forms with the same name (but in two different projects)! And of course, if it was just by buyer, supplier representative, and form template id, then if the supplier representative was actually an employee of a 3PL working on behalf of the supplier, the data could be attached to the wrong project and exposed to other suppliers!

4. How easy is it to export the response grids for analysis? To Excel? To Access? To an OLAP analysis tool?
Automated scoring mechanisms are usually not good enough to select a vendor, and they often eliminate vendors that ought not to be eliminated. How can you write a fair scoring algorithm for a space you don’t know that well? You could be building in your own uninformed bias, or (worse) that of a vendor who has “helpfully” provided you with an RFP template! (And I think you know what I think about some of those templates!)

In fact, your analysts will want to pull the data into their own tools. These could be just about anything, from Excel models to Access databases to OLAP analysis tools. The ease with which data can be moved out of the RFx tool and into desktop analysis tools is an extremely important consideration. Sure, e-sourcing vendors will tell you that all the analysis can be done within the tool. And in some cases they’re right. But don’t limit your flexibility, because what if they’re wrong? And furthermore, what if you just don’t have enough hours in the day to learn somebody’s custom tool set? That can be a big investment in time and effort, especially if you only run one event a quarter. You could forget everything you learned, and have to re-learn it all over again each and every time. Sometimes it’s better to forget about the vendor’s tools, and just dump the data to a product you know.

e-Auction

1. Can I define my own bid type?

Let’s face it – not every bid is as simple as a price per unit – especially since you should be taking landed cost into account. Furthermore, this is more than just allowing a user to define a unit bid and a freight bid per unit – it’s also allowing the user to define a fixed processing cost per unit while the application automatically factors in an expected value for a variable fuel cost and it is defining your own adjustment that corresponds to the various utilization costs associated with different products from different vendors. For example, if you’re in food service, each type of sauce packaging implies a different amount of waste – metal cans and plastic bags and lined box-board have different “stick” factors, and the easiness of “scraping” or “draining” the contents from the package often varies by package design (such as cube vs cylinder vs tetrahedron).

2. Can the tool support complex formulas, splits, and cross-lot rankings?

Building on question one, not only do you want the be able to support bids based on complex formulas, but you also want to be able to rank bidders based on their individual bids on different lots and based on their entire package bids. A supplier might bid 100K for lot 1, 200K for lot 2, 300K for lot 3, and 400K for lot 4, but be willing to bid 900K for all four lots (equal to a 10% discount if they get everything). Without complex formulas and cross-lot rankings, the supplier couldn’t enter entire package bids or discounts, and you will not be able to capture the full value available to you through the auction.

3. Does the tool integrate with an optimization solution?

Complex formulas and cross-lot rankings are a good start to getting the lowest bids, but they do not capture all of the complexity associated with a sourcing scenario, and, thus, do not guarantee that the outcome of the auction will be an allocation that optimizes your total cost of ownership. Simply put, a dual-source strategy is preferable to a single-source strategy from a risk management perspective. A given supplier might be willing to make considerable infrastructure improvement investments if they get the business, resulting in year-over-year cost reductions that could, over a three year time-frame, significantly undercut the lowest bid another supplier is willing to give you today.

The reality is that most auction tools don’t support real-time optimization, and most of those that do support real-time “optimization” don’t support it very well, but that’s okay. The point is do they integrate with an optimization solution – since any high-value scenario on strategic categories or commodities should involve a separate optimization step where you run multiple what-if scenarios to understand what your business rules are costing you, what risks the lowest-cost solutions are exposing you to, and what the most valuable award is when you balance cost and risk. Thus, you should be able to easily import the results of the auction that you use to collect the initial bids, as well as easily create rules that guarantee the winner(s) of the auction receive a minimum amount of the award. (Remember your auction etiquette – if you don’t award to the winning supplier(s), you’ll damage your reputation. If you’re going to use auctions to collect bids for optimization, you should be willing to guarantee a minimum award to the winning suppliers. And if you properly define the bids and rankings, with an appropriate multi-source strategy, this shouldn’t be a problem. If you have a special situation where you think it might be, then use a multi-round sealed-bid auction instead of an open auction.)

The 12 Days of X-emplification: Prologue

Last year, I brought you the 12 days of Christmas, which went as follows:

On the twelfth day of X-Mas
my blogger gave to me
an ounce of cunning,
another vendor hyping,
blog posts worth keeping,
spend vendors lancing,
thoughts for a shilling,
strategies for winning,
tactics for saving,
five golden rings,
four little words,
tri-focal lens,
two boxing gloves,
and a lesson in strategy.

This year, in the spirit of giving, and in the spirit of Questions to Ask your Optimization Vendor, the doctor exposes the elephants in the room (Part II), and the doctor goes mental (on Auctions and on Optimization), I’m going to give you twelve posts on twelve different sourcing and procurement technologies and services that expound upon the questions you should be asking, the answers you should be expecting, and, most importantly, why, so that when you set about choosing a technology to help you with your sourcing and procurement challenges, you choose the right one.

Now, I know that Procuri and some other vendors put out a series of RFP template documents, that included The Sourcing RFP Template, The Supplier Management RFP Template, The Contract Management RFP Template, and The Spend Analysis RFP Template and that some of you might think that these posts are therefore unnecessary, but I assure you that the opposite is true. The problem with these RFP Templates is that they were written from a feature perspective, and were designed to make the sponsors look good (whether the sponsors want to admit it or not). The reality of the situation is that the number of features a product offers is irrelevant if it doesn’t support the key processes you need it to support to add value to your business. In other words, a product with only 100 features could be many times better than a product with over 1000 features if the product with 100 features supports the ten functions you need to support and enable your best-practice based business processes. For example, it doesn’t matter if a spend analysis package comes with 100 reports out of the box if you can’t build a template for the one report your boss demands to see every week.

Thus, when it comes to the technologies you use, or should use, every day, I think it’s time that you as a buyer knew the questions you should be asking, and not necessarily the questions the vendors want you to ask. Then you’ll be in better shape to select the right technologies to meet your needs.

Before the series gets started, I have a couple of things to take care of.

First of all, please understand that just because the templates I called out above (and those like them) are not appropriate templates for you to be using in your efforts to find the right product for you, this does not necessarily imply that the solutions offered by those same vendors are not appropriate for your needs. The solutions might be appropriate, and they might not. But unless you ask the right questions, how will you know?

Secondly, if you thought my blogologues were hard hitting as of late, and even a little scathing, as they used to say, you ain’t seen nothing yet. Although I’m not going to discuss specific vendors with respect to the technologies in the 12 posts that follow, I can guarantee that for any given post, there are going to be a number of vendors who are not going to be too happy after reading it – because their solution, whose last major update was five plus years ago, not only doesn’t cut it, it doesn’t even come close!