Daily Archives: November 29, 2007

the doctor On Dashboards: They’re Dangerous and Dysfunctional

A colleague of mine recently remarked that the whole dashboard concept is stupid beyond belief and just a lot of malarkey and I have to agree. “Dashboards” as they exist today are completely useless, and, in general, the concept is mostly useless.

As my enlightened colleague would say, a single metric on a dashboard is like saying one idiot light is better than the combination of oil pressure, water temperature, and battery voltage gauges. Sorry, it’s not. And, guess what, you can’t see the relationship between oil pressure and water temperature, so you could have a “TEMP” light that’s going off because oil pressure is nonexistent and you’re scraping the metal off the cylinder walls! It’s useless.

The fundamental flaw is that today’s dashboards are marketed as a snapshot view of how well your organization is doing. A dashboard can not tell you how well you’re doing. To do that, it would have to know everything you’re not doing well, determine how much that is impacting your overall performance, and report that. However, the best it can do is capture the data it’s been programmed to capture, roll-up the metrics it’s been programmed to roll up, and do the built in calculations of efficiency based on those roll-ups.

Just because it reports 90% of spend “on contract” does not mean 90% of your spend is “on contract”. Maybe 10% of your total spend on a commodity under contract has been misclassified under the wrong commodity code, and all of this spend is off contract, meaning that only 82% of your spend is actually on contract. Just because it says on-time supplier delivery is 95%, does not mean that you’re doing a fantastic job of managing your suppliers and that only 5% of shipments are late. Maybe it’s only recording shipments late if they don’t arrive on the designated day and not taking into account the time of arrival – which could be a consistent 2 to 4 hours late. Since this could require a lot of overtime by your warehouse crews who arrive early with nothing to do for the first two hours, this costs you. And so on.

A dashboard can only provide an upper bound on how well you’re doing, and this is useless. Saying my efficiency is at most 98% when it is in fact 92% is useless and unactionable. I can say your efficiency is at most 100% and always be correct – and I don’t need an overpriced software hack to tell you that!

The most a well designed “dashboard” could do, if the goal was reversed from trying to tell you how well you are doing, which it cannot do, to how poor you are doing, is give you a lower bound on how poor you are currently performing. Whereas “my efficiency is at most 96%” is not useful, “my inefficiency is at least 4%” is useful. That tells you that not only are you not performing at 100%, but that the system, even though it’s unable to identify all sources of inefficiency, has found 4% inefficiency that is immediately actionable. Whereas “at most 88% of spend is on contract” is not useful, “at least 12% of spend is off contract” is useful because it identifies some low hanging fruit that should be immediately tackled to improve spend compliance within your company. Of course, this is assuming that the process used to compile the data and calculate the metrics isn’t fundamentally flawed (which it very well could be in some of the dashboards out there).

Of course, this is still nowhere as useful as a good spend analysis or business intelligence tool that allows a seasoned analyst to construct some well formed cubes and drill around as she desires – as such an analyst would find anything the “dashboard” would find in about five minutes of drilling into the “spend cube” or “efficiency cube”. Furthermore, even if you covered an entire wall with dashboard displays, you still wouldn’t get close to all the perspectives you could come up with by drilling around a couple of well formed data sets.

Basically, all today’s dashboards do is present a pretty picture of a rather useless report. And I don’t want to hear any arguments that they’re “flexible” or “configurable” or “customizable” and that they can do whatever you want them to do – they can’t – they can only be “customized” or “configured” to the extent that they were built to be “customized” or “configured” by the development team – who probably had little understanding of your business, your data collection methodologies, your processes, and the information you really need to understand your business – and, in my experience, that’s usually not nearly as “configurable” or “customizable” as they would need to be to be useful even to the limited extent they could be if they were designed properly.

So next time someone tries to sell you a “dashboard”, thank them for the offer, and instead ask them about their analytics engine. That’s what you really need!

Supply Chain Finance : You Have To Get It Right

Aberdeen and Hackett are right – Supply Chain Finance is important – and poor supply chain finance can trap millions, tens of millions, and, if the organization is large enough, hundreds of millions of dollars in the supply chain. However, the only way to free up that money is to get it right – and that doesn’t necessarily mean following someone else’s lead. A lot of the initial strategies that have been devised to free up cash are not strategies for success – but strategies for dismal failure in the long run.

And, even worse, a lot of articles, including “Where’s The Money? It’s Trapped In Your Supply Chain”, which I recently discovered over on Supply Chain Brain, don’t distinguish between the good strategies and the bad strategies. This article in particular mixes recommendations for better handling of payables, early payment discounts, extending days payable outstanding, inventory reduction, better handling of receivables, better supplier management, deployment of EIPP, better collaboration, closer cooperation with finance, VMI, consigned inventories, transit time reduction, global inventory leverage, and activity-based management, and network optimization as if they’re all good and equal – sometimes mixing recommendations for multiple options in the same sentence – when in fact some are quite good, some make little difference, and some have the potential to be disastrous to your supply chain.

Only six of these – better handling of payables, inventory reduction, better handling of receivables, better collaboration with finance, transit time reduction, and network optimization – are guaranteed to always be good if done right. Seven of these – early payment discounts, better supplier management, deployment of EIPP, better collaboration, VMI, global inventory leverage, activity base management – can be good if done right, but can be done perfect and have little effect. This leaves extending days payable outstanding and consigned inventory, two options that are generally bad decisions.

Let’s start with the good. Better handling of payables and better handling of receivables are obviously good – since they deal with the movement of cash, but as suggestions, they aren’t very helpful. How do you handle payables better? How do you handle receivables better? In the latter case, you keep track of who owes you what, when, and make sure to follow up if the payment doesn’t show up when expected. In the former case, well, that’s really a large part of what supply chain finance is all about. The most common recommendations are early payment discounts and extending days payable outstanding, but the first has to be done right to be good and the second is rarely the right decision, unless you have the habit of paying for goods before they are received.

Inventory reduction is always positive, since it costs you money to hold goods in inventory. And if the goods take up a lot of room, or have a high value and require a lot of security, a large amount of inventory can be very costly. Similarly, transit time reduction within a given carrier mode can save money since each day a good is on the truck, or ocean freight liner, adds cost. (Transit time reduction does not imply switching carrier modes as this can raise costs. It means optimizing routes and handoffs within a mode to reduce overall costs.) Collaboration with finance is probably the best thing supply chain can do. Supply chain needs to understand how much each potential buy can cost from a TCO perspective, and this includes taxes, VAT rebates, potential rebates for dealing with MWBE suppliers, and other costs only finance will have a good handle on. Furthermore, finance cannot optimize use of working capital if it doesn’t understand what commitments are outstanding. Finally, network optimization can be effective as this can lead to reduced inventory, shorter transit times, and a better understanding of costs and working capital needs. But it’s not easy – and will require some good optimization tools and a good knowledge of network planning. (In other words, it’s something that should be left to the experts and not the low-hanging fruit you should start with to see some early successes and gain support for your initiatives.)

This brings us to the middle ground where the strategy can be good, or even very good, if effectively employed or of almost no benefit at all if not employed judiciously. Early payment discounts often make a lot of sense, especially when compared to the shortsighted strategy of extending days payable outstanding, but this is only true if the supplier is not forced to take the discount and if the discount amount is more attractive from a suppliers total cost of operation when compared with the costs the supplier would incur from borrowing working capital. Better supplier management is always a positive from a supply chain perspective, but this doesn’t mean that the supplier will be capable of reducing costs. This tactic is very situation dependent.

Deployment of an e-Procurement solution will usually help in terms of speeding up invoice processing and increasing supply chain visibility, but unless checks and balances are put in place to make sure invoiced amounts equal contracted rates and that payments are made at appropriate times, it’s not guaranteed to be a win. Better collaboration always helps, but like supplier collaboration, is not guaranteed to reduce costs or free up working capital. Sometimes, all it does is improve quality and reliability.

VMI can be a good call if the vendor can manage your inventory better, but if the vendor is not experienced in 3rd party inventory management, this can actually end up costing you. Global inventory leverage sounds great, but not all banks will be willing to lend against inventory in countries they do not operate in – you’ll generally have to get a 3rd party financing solution to buy in. Finally, activity based management is good in that it helps you identify the costs corresponding to a process – but your supply chain is more than a collection of activities, so you really have to understand where this fits, and where this does not, to get any benefit out of it.

This brings us to the bad. Let’s start with consigned inventory. All this does is pass the costs on to your supply partner, who might not be in your financial position. This will force them to take out more loans, at higher rates, which will only increase their total cost of operation and, thus, the total cost per unit they have to charge you in the future in order to be sustainable. Then there’s extending days payable outstanding, which like consigned inventory, simply passes operating cost onto your supplier. But it’s even worse – because now the supplier doesn’t even have any inventory to leverage in negotiation for that working capital loan! As a result, they might be forced to take out loans at 20% to 40% interest just to pay their employees, while you fret about only making 2% in your money market investments and only having 500M in your bank account. What do you think that’s doing to do to your cost when the contract comes up for renewal, provided the supplier is still in business and willing to have you as a customer? Extending days outstanding to 60, 90, or even 120 days might make short-sighted wall-street happy, but all it’s going to do is hurt you in the long run. Winners don’t follow the market, they lead it. So do the right thing and pay your suppliers promptly, just like you expect your customers to pay you promptly.

Furthermore, if you really want to get a good handle on what Supply Chain Finance really is, what strategies you should be considering and, more importantly, what strategies you should not, start with the wiki-paper A Supply Chain Finance Primer over on the e-Sourcing Wiki [WayBackMachine]. I think it will be worth your time.