Category Archives: Spend Analysis

Organizational Data is Organizational Data — NOT Department Data

While reading “Cuts from the Center”, which records a recent CPO Agenda Executive debate held during this past winter, I couldn’t help but notice Nikki Bell’s comment on how she gets frustrated when we make excuses about how we can’t have the right data, or about people protecting data. I have to agree. This is what kills Supply Management initiatives that could save the organization Millions (and in some cases, Billions) of dollars.

And it’s ridiculous. Everyone in the organization needs to know that organizational data IS organizational data and that anyone who has access to organizational data has access to ALL organizational data. And Senior Executives, starting with the CEO, have to mandate this. No exceptions. If information is sensitive, then it should be “scrubbed”, “sanitized”, or “anonymized”, and the data then made available for analysis and mining. Without complete data, you cannot do a proper spend analysis project, and without a proper spend analysis, you will not find the true savings opportunities. And if you want to recover overpayments and avoid unnecessary spending, you need to do a proper spend analysis and uncover the true savings opportunities.

Your data is your data. So mandate it’s use. Remember, if you want performance, you have to make it so.

What to Look For in a Spend Analysis System

These days, every vendor and his dog is offering “spend analysis” solutions to the market, but, as one can easily guess, not all “solutions” are appropriate in all situations, or even capable of producing a true picture of spend for an average organization. Therefore, in order to select an appropriate solution, one has to know what to look for. The right answer is often elusive, because there is a fundamental lack of understanding in the market of what a “spend analysis” solution actually is, and what it should be expected to do. Depending on who is asked, the definition of analysis will vary from the process of building predictive models using historical data, to deciding whether past events or transactions are statistically significant, to sorting through haystacks of data to find meaningful needles that will suggest patterns. Each is a valid definition, but it is not necessarily useful to an organization that just needs a better understanding of what it is spending, where, with whom, by whom, and, more importantly, why. From a practical perspective, spend analysis boils down to “finding stuff in your data” that the organization was not aware of, or was not sufficiently aware of. Spend analysis, therefore, is the process of deriving insight from spend data.

So how do you derive insight? You apply a well understood process to multiple data sets. Emphasis on “you” and emphasis on “multiple”. If the process can only be accomplished by a team of programmers in a back room, it is not useful from a business perspective. You have to be able to use the system to do the analysis you need to do. And if the system can only build one cube on one data set, then it is not a useful analysis system. Depending on your organization, there could be savings in the AP data, the invoice data, the HR data, or the ERP data. You don’t know until you look at all the data sources and build and analyze all the cubes.

So what does this mean from a system perspective? Find out in our article on “What to Look For in a Spend Analysis System” over on the new Next Level Supply site. True spend analysis is a fundamental requirement of a next generation supply management organization.

Trade Extensions: No Rest for the Wicked-ly Powerful – Part II

As per yesterday’s post, it’s been less than five months since we last checked in with Trade Extensions, who had traded up to a Fact Sheet User Interface and added a slew of new features, including improved RFI support, multi-dimensional rankings in e-Negotiation, Google Earth integration, new incumbent rules, and an OLAP foundation to reporting, including the implementation of a new n-way comparison report. Since then, Trade Extensions has been on a tear to add new functionality as fast as it can to make the platform not only one of the most powerful expressive bidding optimization platforms on the planet, but also one of the easiest to use — listening to its users (which include the Fortune 1000) and adding features and functions that make an average buyer’s life easier, taking usability to a whole new level yet again. And while earth-shattering technology improvements are cool, it is usability that is the ultimate key to to adoption, use, and, ultimately, cost avoidance and reduction in your sourcing organization.

Scenario Creation & Analysis

Not only are there new rules that allow partial awards to be fixed based upon existing scenarios, but the number of constraint categories has doubled. While there were only general and incumbent constraints in the past, there are now an entire category of scenario reference rules and post processing rules. With respect to scenario reference rules, not only can allocations be kept, but bids can be favoured or penalized as well. The post-processing rules are also quite useful. Allocations can automatically be rounded and allocations that don’t meet a minimum number of units can be removed (or re-assigned to the supplier who meets a minimum allocation with the lowest total cost).

Feedback Mechanisms

The buyer now has fine-grained control over what the supplier sees, and can even mix feedback types. For example, if the buyer only wants the top three suppliers to know they are top three, but suppliers four to six to know their exact rank, they can specify that specific rank starts at bidder four, and the top bidders default to “top 3”. In addition, if the supplier does not meet a minimum bid increment, which can be defined in a number of ways (including, minimum dollar or % decrease over last bid), the supplier gets a nice red error that the bid is not acceptable AND a message indicating the minimum increment required. Finally, and this is really cool, the user can define custom color-coded bid feedback fields based on dynamic formulas that now only let the user know where they rank, but how competitive their bid is (against the current bids from the competition) in English using a buyer defined scale such as “Competitive”, “Slightly Competitive”, “Not Competitive”, and “Not Acceptable”.

Plus, the buyer can now chat with users online in an integrated IM client, and immediately see who is online when they log in as it is a widget on their project management dashboard.

Odds and Ends

The “dashboards” for RFX and auction phases have also improved. The summary, bidder summary, and lot summary are now completely customizeable by the user, support custom fields, and user-defined colour codings in the rankings. In addition, there is integrated show/hide, drill-down functionality, and customizeable pop-up (bid, trend, and bidder activity) charts where a user can select one, some, or all of the rows in each report.

They have also added a basic workflow engine that allows buyers to initiate rate requests, lot requests, and allocation publishing requests of project managers / administrators when new needs arise during a project. This allows managers and supervisors to maintain control and a complete project history to be maintained. The workflow is fairly basic at the present time, but I suspect it will mature and fill out quickly given Trade Extensions’ track record of rapid application development over the past two years. (Especially since the feature is being used by a couple of very large companies.)

All and all, it’s a lot of new functionality in a short time frame that makes the tool extremely useable by an average buyer.

Quick Hit Cost Savings Projects

Since it’s impossible to get away from cost reduction, inspired by a recent SIG article on “Strategic Cost Management: The Survivor’s Playbook to Savings”, which listed the following high-impact projects for same year savings:

  • Software Maintenance-Rate Reduction
    Identify all of the maintenance contracts, annual spend, and maintenance percentages. Develop a standard maintenance agreement and standard percentage for annual maintenance, require an exception appoval process with senior management involvement for any alterations, and focus (re)negotiations on highest savings opportunities. Savings of 5%+ is not uncommon.
  • Software Maintenance-Elimination
    Eliminate maintenance on all non-critical systems or all systems where annual maintenance cost is low. (In the latter case, even if the system is critical, it will cost less to re-instate the maintenance on a system at a later time if it is required than to pay maintenance on all such systems.)
  • Legal Services-Hourly Rate Reduction
    Most legal firms raise costs annually regardless of competitive market conditions. (Threaten to) conduct a sourcing exercise and watch rates drop quickly.
  • Legal Services-Bundles and AFAs (Alternate Fee Arrangements)
    For general legal services that are project or task oriented, and not litigation oriented, bundles or AFAs can save the company a significant amount of money.
  • Desktop Printers-Elimination
    Shared multi-function devices, with password printing, are much cheaper to operate than individual desktop printers.

here are a few more quick-hit cost savings projects that will generate cost savings if the organization has not run them (recently):

  • Marketing-Print
    Unbundle print from creative services and then run a quick sourcing project. Significant cost reductions in the 10% to 20% range (or more) will quickly materialize when printers are being faced off against each other.
  • Office Supplies-Live SKU Guarantees & Price Checks
    Everyone knows that a quick auction will drop prices across the board, but most category experts also know that the vendors make this back by raising prices a few months down the road when they think no one is looking and by bidding expiring SKUs, which will be substituted with higher price items down the road. Insisting on a clause that states that all SKUs must not be schduled to reach end of life within the contract term, and that any SKU that is retired must be replaced with a SKU of equivalent, or greater, functionality at current, or reduced, cost will prevent those overpayments and insure that significantly greater savings materialize.
  • Computers-Overpayment Recovery
    Most vendors don’t honor the “best price” clause and generally charge the same rate for the life of the contract, even though most computers and components decrease 2% to 3% a month. A careful spend audit will typically reveal 10% or more in overpayments that can be targetted quickly.

It’s Easy To Move Beyond Spreadsheets and Improve Operational Decisions

All you have to do is survive the uprising that results when you ban spreadsheets from the organization.

Industry Week recently published a very nicely thought out and written piece from SAP on “how to move beyond spreadsheets to improve operational decisions” using business intelligence that sounds wonderful in theory but doesn’t work in practice. Why not? Because the first thing a user does when they get a new system is dump the data to a spreadsheet they can play with because

  1. they are used to the spreadsheet environment and
  2. the vast majority of BI tools don’t have the capabilities the average analyst needs to do the analysis she needs to do because they all work off one version of the data that cannot be altered in any way.

Thus, an average BI system only worsens the problem as users create and share more and more spreadsheets in an effort to get around the limitations of yet another system with yet another version of the truth. There are only two ways to move beyond spreadsheets. They are:

  1. Ban Spreadsheets
    and force your users to work within the limitations of the BI tool or
  2. Adopt a Real Analysis Tool that Supports a Spreadsheet Interface
    and allows your users to continue to use the interface they are comfortable with in a productive, value-creating, manner

Spreadsheets are not going to go away just because you’ve introduced yet another system. It’s delusional to think otherwise. Your only choices are to ban them or embrace them in a manner that is actually helpful.