Monthly Archives: August 2010

Has Coupa Settled on a Coupe? Part III

In our first post, we discussed how, when Davie ran The Coupa Factory, their strategy was innovation focussed and they were constantly charging ahead in their efforts to bring Procurement Independence to the masses but that, lately, it seems that their strategy has shifted to putting customer acquisition first and building a better platform second. In our last post, we reviewed what they have accomplished over the past eighteen months, which isn’t too shabby to say the least (especially compared to some of their peers which do not appear to have innovated at all), but noted that there’s nothing to really shake your foundations … which is a shame considering that had Coupa taken benchmarking and supplier ratings to the next level, they could have knocked your Procurement socks off. This is the subject of this post.

In order for benchmarks to be useful, they have to be meaningful. In order for a comparison to be meaningful, it has to be against like items. And while you can compare apples to oranges, unless you’re comparing the spectra of dried samples in powdered form, it doesn’t make sense. The reality is that savings, request, order, and invoice metrics only make sense if the comparison is against a similar company of a similar size in a similar vertical buying similar products. Consider free-form requests … depending on company size that’s going to range from hundreds per year to tens of thousands per year. Frequency of self-approval … that’s not only going to depend on corporate policies but the types of goods being purchased. If the system is mainly used to purchase office supplies, who’s going to waste time approving every small order? But if the system is being used to buy high priced electronics, different story. PO value will not only vary widely between companies, but within a company. A purchase order for a weekly office supplies order in a small company will be a fraction of a purchase order for a new set of servers. Active suppliers will vary widely depending upon the size of the company and how many different types of products are being bought. Had Coupa defined appropriate verticals, segmented the verticals into appropriate sizes, and insured that the metrics were meaningful (even if that meant waiting until there were more customers in some verticals), this could have been extremely useful. However, right now, it’s interesting at best, and could be dangerous if misunderstood.

In order for supplier rankings to be useful, they have to be against meaningful metrics, and those rankings need to be defined by a majority of affected users. If they are random rankings defined by random users against random products, they are not very useful, especially if they are done by users who have only used the supplier’s products once and not users who have to work with the supplier and its products every day. In order to truly rank a supplier, a company needs to insure that all of the relevant users who use the supplier’s products or services regularly or who interact with the supplier as part of their role rank the supplier. This means that the buyer needs to send out mandatory surveys to these users. While a buyer can easily send out a survey through your standard SIM or e-Negotiation tool, what a buyer normally can’t do through these tools is figure out which organizational users are in the best position to rate the supplier. However, as Coupa enables all spend related to a supplier to be captured in the system, it’s a pretty easy query to figure out which buyers are the biggest user’s of a supplier’s products and which buyers should be ranking the suppliers. If Coupa had enabled the construction of supplier performance surveys which could be sent to the regular users of the supplier’s products in a single click, and then made it impossible for a buyer to requisition anything until the mandatory survey was completed, think of how useful it could be. However, right now, like benchmarking, it’s interesting, but not very useful.

Hopefully these oversights are just the result of Coupa going through the growing pains associated with a brand new management team and rapid customer acquisition. When you consider that The Coupa Sunflower was only starting to blossom, it would be nice to see Coupa return to the days when its releases were much more than coupacetic. After all, why should they settle for a coupe when they can build a dragster? It only takes a little bit of innovation in the right direction to bring back the excitement to Coupa Time.

Share This on Linked In

Undervalued Currencies, Part II

Editor’s Note: Today’s post is from Dick Locke, Sourcing Innovation’s resident expert on International Sourcing and Procurement. (His previous guest posts are still archived.)

In our last post we discussed the undervaluation of the yuan, introduced the Purchasing Power Parity (PPP) rate as a measure of the relative valuation of a currency, and reviewed the background behind the PPP rate. In this post, we’ll cover the determination of PPP rates, the calculations necessary to determine value against the US dollar, and list some countries with large differences between the PPP rate and the actual rate.

The Determination of PPP rates

You can look them up in a very wordy and meandering World Bank publication. However, the World Bank does not update values very frequently. The most recent data is from 2005. The CIA in the United States publishes an annual World Factbook. It has data that enables an easy calculation of current PPP rates.

The Factbook shows GDP at both PPP and “official” exchange rates. In the case of China in 2009, GDP at PPP rates was 8.789 trillion U.S. dollars. (Note to non-U.S. readers: A trillion in the U.S. is 1,000,000,000,000.) GDP at official rates was 4.814 trillion dollars. Because both GDPs are conversions of the same amount of yuan, if you know the official rate simple algebra will give you the PPP rate.

How can you find the “official” rate? In most cases, it’s the actual rate. If you use the “Historical Exchange Rates” facility at oanda.com, it will give you an average exchange rate over a period of time. The average rate in 2009 was 6.841 yuan per dollar.

That means the PPP rate was 3.74 yuan per dollar. (I left the algebra to you.)

Calculation of Over- and Under- Valuation

There’s a big difference between 6.84 and 3.74. How big? First you need to re-express exchange rates into dollars per yuan. That means simply inverting each value, or dividing it into 1. If there are 6.84 yuan per dollar, each yuan is worth 14.62 U.S. cents. At 3.74 yuan per dollar, each yuan is worth 26.69 cents. The difference between the two values is 11.93 cents. Take that difference (11.93) and divide it by the PPP value and you get .452, or 45.2 percent of the PPP value. That means the yuan is undervalued against its PPP value by 45.2%.

Other Countries

If you do similar calculations on other countries, you get results that will dispel any notion that floating currencies settle near the PPP rate. You will also see that China isn’t different than many of its competitors.

With this method, some countries’ currencies are undervalued against the U.S. dollar. In turn, the U.S. dollar is undervalued against some countries’ currencies

Countries Undervalued against U.S. dollar Countries against which the U.S. dollar is overvalued
Country Amount
India 69%
Taiwan 50%
Thailand 45%
China 45%
Malaysia 40%
S. Korea 40%
Singapore 30%
Mexico 29%
Brazil 26%
Country Amount
Germany 14%
Italy 20%
France 23%
Japan 26%
Ireland 29%

Summary

  • PPP rates are calculated based on consumer purchases, not industrial products.
  • China is one of several countries that have both currency controls and an exchange rate that is significantly different than the PPP rate. However, removing controls and floating a currency does not guarantee it will reach PPP rates.
  • Individual buyers (and sourcerers) should not concern themselves with official PPP rates because these consumer-oriented rates may be very different than the rates for the particular product a buyer is handling.

Thanks, Dick! (Global Supply Training)

Share This on Linked In

A Hitchhiker’s Guide to e-Procurement: Analysis, Part II

Mostly Harmless, Part XVIII

Previous Post

In the last post, the analysis process was discussed and some of the basic questions were defined. This post will address the some of the associated challenges of the analysis process, some associated best practices, and the benefits that could be expected from an appropriate e-Procurement solution.

Common Challenges

The literature will claim that there are many challenges with regards to spend analysis, and that these challenges will revolve around data cleansing, data classification, and data enrichment, but the reality is that there are generally only two real challenges: access and analysis.

  • Data Access

    In order to do data analysis, an analyst needs access to the majority of the relevant organizational data that represents at least 90% of the spend in the categories that the buyer wishes to analyze. Without a centralized e-Procurement system, this can be difficult as some spend will be in the ERP/MRP, some in the accounting systems, some in the P-Card system, and some in various departmental systems.

  • Insightful Analysis

    Top N reports are not analysis. Spending trends are not analysis. Automated reports are not analysis. Analysis is the ability to slice and dice the data eight ways from Sunday to allow for the identification of unusual spending patterns that represent true savings opportunity.

Best Practices

  • Force Every Purchase Through the e-Procurement System

    Forcing every purchase through the system not only significantly reduces maverick spend, but it provides a centralized repository of all transactions which provides a solid foundation for spend analysis.

  • Force Every Payment Through the e-Procurement System

    If the e-Procurement system does not support e-Payments, insure that it supports a record of payment against each invoice and that all payments are loaded into the system and cross-referenced with associated invoices, goods receipts, and purchase orders. This is necessary to take spend analysis to the next level. While many vendors will claim that only AP data is needed for spend analysis, the reality is that AP, invoice, and purchase order data is needed for spend analysis. Without the m-way analysis, it is impossible to tell if overpayments, which could be recovered, were made. Without the m-way analysis, it is impossible to identify all maverick spend, which is the first step in reducing future maverick spend. Etc.

  • Do Ad-Hoc Analysis Whenever There is a Possibility for Savings

    Traditionally, data analysis was avoided because the cost of analysis was high relative to the savings potential. However, with the right tool, the cost of an ad-hoc analysis is no longer the five or six figures it used to cost, it’s now three or four figures — which makes even a maximum five figure savings opportunity worth analyzing, especially if a preliminary analysis can be done in an hour or two! Even if only one in ten hunches pays off, if it only costs $1,000 of an analysts time to do an analysis, and the one pay off is $100,000, that’s a 10X ROI.

Potential Benefits

  • Savings

    Real analysis will identify overpayments that will lead to immediate savings. Real analysis will identify maverick spending, which will lead to more savings when it is prevented. Real analysis will uncover new savings opportunities, which will lead to more savings. Real analysis is savings.

  • Better Procurement

    Finding and eliminating maverick spend through better processes leads to better procurement. Understanding spending patterns leads to better procurement. Saving money leads to better procurement.

Once the analysis is complete, it is time to review and update the catalogs and contracts, which is the subject of the next post.

Next Post: Catalogs & Contracts, Part I

Share This on Linked In

What Will The New Brazilian Consumer Mean to Your Supply Chain?

In supply chain, we are continually talking about how the BRIC: Brazil, Russia, India, and China, are going to revolutionize our supply chain by substantially decreasing our costs and, thus, increasing the overall value the supply chain organization brings to the business. For the most part, it hasn’t happened yet (as management costs, tariffs, delays, and expedited shipping costs usually serve to eat up most of the projected savings), although many companies, who took their time and did it right, did see enough savings and enough improvements to make it worthwhile. The real opportunities are going to come when the middle class in these countries reaches a point where the market is just as lucrative, if not more lucrative, then our home markets. Just like Japan, with its focus on electronics, achieved a rapid transformation over the last few decades to become the second largest consumer economy in the world until it was overtaken by China this month, the BRIC is on track to create a new middle class larger than the current global middle class in the next 15 – 25 years.

And while much has been written about the China and India Opportunity (as the 2.5 Billion people the countries contain are expected to contribute another 500 Million to 750 Million people to the global middle class), I haven’t seen much written about Brazil, which is still very respectable in size with it’s 8.5 Million square kilometers and 192 Million people. Plus, it’s current middle class, which is approximately 25% of the population, already earn between $1,000 and $3,250 US, which is on par with what the average middle class income in India (which is as low as $3,000 to $5,000 US by some estimates) and most of China.

Brazil, like any other country, poses a distinct market. As per The Brazilian Consumer: Opportunities and Challenges, Brazilians favour quality over low price, status over indifference, and interaction vs. seclusion in their way of life. The companies that have successfully reached the emerging middle class to date have focussed on quality, distinction, small stores (in lieu of hyper-centers), and exclusive distribution networks — all of which will have an impact on your Brazilian supply chains. But will the emerging Brazilian consumer have any impact on your supply chains for those of you sourcing from, but not selling to, Brazil? Probably not. But if anyone has any differing opinions, I’d love to hear them!

Share This on Linked In

Has Coupa Settled on a Coupe? Part II

In our last post we discussed how, when Davie ran The Coupa Factory, their strategy was innovation focussed and they were constantly charging ahead in their efforts to bring Procurement Independence to the masses. However, lately, it seems that Coupa‘s strategy has shifted from “build a better platform and they will come” to “get the customer and then build them a better platform”. While not much of a change, it’s a change nonetheless and it appears to have affected their rate of innovation. Furthermore, it has been accompanied by a shift from groundbreaking new features to even flashier UIs, iPhone apps, and streamlined ERP integration. [Either that, or they’ve been celebrating all those new customer wins with The Coupa Drinking Song. ] While these features are important to the tactical buyer, they don’t add value to the strategic parts of the procurement process.

This isn’t to say that Coupa has stopped developing, or that some of their new features aren’t impressive, especially where the average buyer is concerned, but that their rate of innovation for the last year and a half just doesn’t compare to the Coupa of old. And while it is to be expected that the rate of innovation will drop as a company matures, if the rate drops too fast, the company risks going stagnant, and that would be troubling. However, what is really troublesome is that Coupa hit upon two areas in real need of innovation in their latest release, but appear to have completely missed the point on how to bring that desperately needed innovation to the masses (unless it’s still a work in progress, but why not go for the big win before anyone else beats you to the finish line?). However, that’s the subject of our next post.

For now, let’s review what they have accomplished in their latest release, as a few of the features are quite useful and still unique to the space.

Drag-and-Drop Expense Management

One of the developments Coupa seems quite proud of is the ability to snap a photo of a receipt with your iPhone, e-mail it to your Coupa account, log in to the system, bring up expense reporting, and then drag it to an expense category in an expense report. The receipt is immediately associated with the report and removed from your unprocessed receipt bucket.

Transaction Metadata for OLAP reporting

Coupa has added transaction metadata to each transaction that provides supervisors and CPOs the ability to roll up reports by chart of accounts, reporting hierarchy, and category. They’ve also added more fine grained security to insure that a user can only see spend within her visibility. (Note that they were calling this “data striping“, which, of course has nothing to do with OLAP reporting but data storage on physical mediums as it is the technique, used in RAID, of segmenting logically sequential data across different devices. So if you were confused, this is what they meant.)

Real-time Budget-Based Alerts

Not only does the application allow a user to keep on top of her budget, by way of it’s budget dashboard on the home screen (which is actually useful as most buyers don’t have a clue how much they are spending), but if a requisition puts a user over a certain percentage of her budget too early in the year, the application will alert the user, and the approver before it is approved. It will also let the approver know if the requisition would put the category or department budget over a dangerous (administrator configurable) threshold too early in the year.

iRequest

iRequest is a bookmarklet (bookmark app) that allows the user to add a bookmark to their browser that will bring up a pop-up window that will let them request whatever item is on the page of the external site she is browsing. Not only does it make requesting an item on Amazon.com a breeze, but it eliminates the excuse for out-of-system requisitioning as every item can now be easily requested through the system.

Opt-in Benchmarking

With opt-in benchmarking, a customer can opt-in to sharing benchmarking data anonymously and see how it is performing on a standardized set of benchmarks relative to all of the other customers on the Coupa system. It’s interesting, and could be a powerful tool, but right now, it’s not very useful. More on this in our next post.

Supplier Ratings

With this feature, they’ve essentially added the ratings feature of Amazon.com which allows a buyer to rate the supplier with respect to each purchase, but since the ratings are optional, and since they’re not made against meaningful performance categories, the usefulness of this feature is rather limited.

All-in-all, some useful functionality that I’m sure will go far in convincing the average office manager to accept Coupa with open arms and joy in her heart, but not what Coupa could have delivered to totally knock your Procurement socks off. More on this in our next post.

To be concluded.

Share This on Linked In