Category Archives: Technology

Trade Extensions Keeps Extending the Platform

The fact-sheet based RFX module is not the only improvement that Trade Extensions has made since it last traded up its UI and improved its optimization and reporting capabilities. Since Trade Extensions was last covered on Sourcing Innovation, it has made a number of significant improvements to its platform, including:

  • RFI-driven supplier data requests
  • multiple dimension ranking in e-Negotiation
  • integration with Google Earth
  • more cost support and new incumbent rules in optimization
  • conversion of all reports to OLAP reports and implementation of a new n-way comparison report

RFI-driven supplier data requests

In the Trade Extensions platform, supplier data collection can be configured to be dependent on supplier responses. If a supplier indicates that they don’t have a certain capability (or don’t wish to bid on particular item or category), then they don’t see the associated fact sheets (which they can download as an Excel Spreadsheet if they like). Also, if they indicate they do perform a certain function, the RFI can be configured to request additional information.

Multiple dimension ranking in e-Negotiation

Most auction platforms rank by bid, volume, or another relevant factor to the buyer. The Trade Extensions platform can be configured to rank (and report on) bids on multiple dimensions, such as supplier and location or supplier and quality. This makes it easy to quickly see how a bid stacks up against multiple relevant factors.

Integration with Google Earth

Often times when I hear about integration with Google Maps or Earth I say “that’s nice” because it usually doesn’t add much value. But the TE implementation actually makes Google Earth useful. Not only can you quickly see the lanes, relative volumes [by line thickness], and carrier distribution [by line colour] at different scales, but, with a click, you can pop up a box that provides the full details of what is flowing down the lane (products, volume, from, to, frequency, total weight, etc.). A warehouse manager can quickly zoom into her facilities and see what is coming and when. It can take a scenario with thousands of allocations and make the information quickly comprehensible.

More cost support and new incumbent rules in optimization

Relative and absolute fixed, on-, cost support has been greatly improved in the application. A buyer can define a cost on supplier selection, on a certain volume threshold, on a specified property, etc. This allows for incredibly detailed and accurate costing formulas to be created. Trade Extensions has also added four new incumbent rules to the optimization solution, two new allocation and two new keepers. The user can now choose to allocate an incumbent volume at least equal to what they have now, or to the current percentage of volume, or to incumbent proportions and allow redistribution between incumbents, or between winners in incumbent proportions.

Conversion of all reports to OLAP reports and implementation of a new n-way comparison report

When Trade Extensions last traded up their UI, they had just implemented their new OLAP reporting feature and were in the process of converting their existing reports. Now that the OLAP reporting feature has been fully implemented, all of the reports have been converted and the new report creation facility is complete, allowing users to define their own OLAP reports on the dimensions of their choosing. Also, the user can now create arbitrary n-way comparison reports and “glue” reports together from existing report definitions.

And Trade Extensions has no intention of slowing down. In addition to a commitment improve SIM/SPM/SRM, Trade Extensions is also working on:

  • auctions – simplifying them for low-end spot buys
  • e-Negotiation – instant messaging, better charting, etc.
  • enterprise features – search across projects, track cross-project metrics, integrated BI
  • roles – admin, project manager, buyer, viewer, etc.
  • new project types – to simplify auction setup
  • on-demand training – the wiki is under constant development and walkthrough videos will soon be available

It should be an exciting year for this European company that has just started to gain traction in North America (where they opened a new office last year).

Trade Extensions Trades Up to a Fact Sheet User Interface

Trade Extensions is another company that has refused to sit still during the downturn. Even though it did a complete overhaul of its UI in late 2009 (when it traded up its UI and e-Negotiation Management Capabilities), it realized that was just the first step of many that would be required to make its application more useful and more useable across the Supply Management Organization. Trade Extensions has been working hard to break out of the “complex transportation optimization” niche that they started in and has developed a fully functional Sourcing and Supply Optimization solution because they see the value that an organization can receive when optimization-based sourcing events are undertaken across the board.

While Trade Extensions started as a niche Strategic Sourcing Decision Optimization platform in the early naughts, it has expanded into a full suite solution over the years and now includes one of the most powerful RFX modules on the market, real-time optimization-powered reverse auctions, contract management, and OLAP spend analysis (which rivals many of the other suite spend analysis solutions on the market and a few of the pure-play solutions as well). And while they don’t yet have much of a SIM/SRM/SPM solution, they recognize that as a weak point and it is one of their top priorities for the coming year.

In addition, while they don’t yet have category RFX solutions or a centralized data management facility (or “Business Centre”), they are planning to introduce new project types to simplify RFX and Auction setup and their new support for fact-sheet based RFX and reverse auctions makes data management significantly simpler and takes them further down the data management path than many of their e-Sourcing Suite provider brethren who have been standing still for the last few years.

Internally, Trade Extensions uses OLAP cubes to store its data. Thus, the user can provide data in d-dimensional fact sheets, which include 2-dimensional spreadsheets and 3-dimensional workbooks, that define data in familiar matrix notion. This is a very powerful method of data input. A user can define a fact at any level that makes sense. If the cost of interest is a single freight cost from a ship from to a ship to, the user can provide costs in a 2*2 matrix of ship from locations and ship to locations. Users can also define costs at the region or country level if they like, and if a user defines a fact sheet that relates lanes to regions, the user only needs to specify costs at the region level. Moreover, if the user so desires, once costs are specified at the region level, they can be overridden at the ship from – ship to level. The system will do this automatically if the fact sheets are appropriately defined and included in the project as it knows d+1-dimensional costs always override d-dimensional costs. In other words, if you define continents as collections of territories, territories as collections of regions, and regions as collections of lanes, the system knows that territory data overrides continent data and region data overrides territory data, if defined. Otherwise, default values from a higher level in the hierarchy are to be used if no suitable cost exists at a lower level of the hierarchy. This is important as this allows a user to only enter detailed cost data where it is required (and where it differs from default pricing for the category).

As a result, data collection in Trade Extensions’ e-Sourcing platform is quite easy. A buyer only has to define what the organization wants to collect, and a supplier only has to bid on what it can provide. Furthermore, a supplier only has to bid to a level of detail that makes sense. Plus, all bids can be formula based. So, if a supplier supplies a product in different sizes, and the price is dependent on weight or volume, it can define a formula once and re-use it on each size. Furthermore, a user can re-use any and all fact sheets from the event in other events, minimizing data collection and data entry. It’s definitely another step along the path to ultimate usability.

Don’t Forget The Most Important Principle of Performance Measurement

SIG just ran a great article on the “Three Guiding Principles of Performance Measurement” that hit upon a key point that is regularly and repeatedly overlooked. Simply put,

Your data is good enough. Really, it is.

As the author says, your data will always be murky. No matter how many times you clean it, massage it, enrich it, transform it, and polish it up, there will always be errors. There will always be omissions. There will always be inaccuracies.

But that’s okay. Remember the 80/20 rule, which is just as appropriate here as it is everywhere else. (In fact, more appropriate.) The law of the vital few states that roughly 80% of the effects come from 20% of the causes. This says that only 20% of your data is vital anyway. And since it is expected that at least 80% of that data will be clean, it’s going to be quite straight forward to spot important trends. (That go just beyond who your top suppliers are, but which items are ordered the most. What types of purchases are regularly bought off contract. What products are really selling best. Etc.)

And if the decision being made is critical or risky, the data will always come up short. There will always be some flaw, some missing piece of information. Because if there wasn’t, the proverbial pointy-haired boss could be an effective manager. Executive decisions will always require a bit of a risk, but they will be much better when there are data to base them on then when there aren’t. So measure, manage better, and manage some more.

Does Verizon Have Its Head in the Clouds?

As we all know, Verizon recently acquired the right to offer iPhones on its network, a status symbol that mobile providers the world over have been vying for as they wait for the initial exclusivity agreements to expire. As the first provider given permission by the world’s fifth largest mobile phone manufacturer (Globe and Mail) to challenge AT&T in the United States, it is probably a little bit smug right now as it waits for its February 10th launch date. But is that any reason to leave its head in the clouds?

Needless to say I was a little shocked to hear that Verizon is paying $1.4 Billion for Terremark Worldwide (New York Times, January 29, 2011), a provider of cloud computing services. While it’s true that Terremark runs 13 global data centres, and data centres are valuable, 13 data centres are not $1.4 Billion valuable. Trust me. I can build you ten modular and scalable Green Data Centers for 1/10th of that with a lot more computing power than you might think you’d get for that price by going with high-density low-power 64-core servers from IBM or SUN which, by the way, cost less than 100K each, even maxed out on memory. You can easily fit 8 of those on a 20u rack. That’s the equivalent of 256 dual core servers on a single rack. Fill 8 racks with servers and 4 racks with SANs (Storage Area Networks) and you have a data centre — that fits in a small room — with the equivalent of 2,000 machines of processing power, that only costs you about 10 Million. I know Terremark also offers services and has a market cap of about 945M, but a 35% premium for something you can build yourself in a few months? I just don’t get it!

BravoSolution’s Business Centre Category Sourcing Solution Takes e-Sourcing to a New Level

Yesterday’s post discussed how BravoSolution has figured out that a real key to e-Sourcing success is a platform that is usable and efficient. It’s one thing to collect bids through a browser (which can be done by any junior high student these days, literally, especially when you consider 14-year olds and 11-year olds are building top downloaded apps in the app store), but another to actually make such an application usable for a category where thousands of bids need to be collected and compared from dozens of suppliers along with tens of thousands of pieces of non-price information.

In other words, they have hit upon the fact that key to e-Sourcing success is the delivery of a platform with the ability to:

  1. define an event of a known (category) type with the click of a mouse,
  2. dynamically determine appropriate and minimal data requirements,
  3. but still handle as much data as can be thrown at it, while the platform tools
  4. make use of and manage existing data.

This is what BravoSolution has done out-of-the-box for nine different categories, what they are doing for more categories as you read this, and what a buying organization can do for any and all categories of their choosing (with a little elbow grease up front). A buyer can view a category specific business centre for Chemicals, Transportation, Packaging, Industrial MRO, Facilities Service, Direct Materials, Contingent Labor, Travel, and Fleet Management which not only lets the buyer see the status of all of her past, present, and upcoming events, but quickly set up, manage, and re-run an event of the given type with a few mouse clicks.

But, more importantly, it is setup to allow a buyer to define and capture all of the relevant pieces of data about a complex category for consideration and analysis with minimal effort. As an example, we’ll consider a rigid packaging RFP through the Packaging Business Centre. In this type of RFX, a buyer will often be looking for plastic bottles and containers. The pre-defined RFX format can capture plant locations; detailed plant information; up-front costs by resin, machining, decoration, and colorant; pricing by group, where groups can be defined by volume, shape, finish, height, overflow capacity, and/or resin; freight; bundle information; plant and machine capacity limits; and additional RFI and RFP details as defined by the buyer.

But more importantly, if all of this information is known for a supplier from a previous event, it can be configured to automatically attach the existing information for a supplier so that all a supplier has to do is define new capabilities, remove old capabilities, and define new pricing. Furthermore, since all of the information is accessible through the business centre, before the buyer even selects the supplier, she can view the supplier information in the business centre to determine whether or not the supplier is even appropriate to invite. (If capacities are too low or if the supplier has not been awarded business in the past three events, it might not even be worth inviting the supplier. On the other hand, if a new supplier has been added to the system and meets the capacity and capability constraints, which can easily be determined by either querying the data or doing a search for suppliers that meet a minimum requirement, then it might be a good idea to invite the new supplier this time around.)

The information that can be collected and maintained about suppliers and capabilities is incredibly detailed. Plant definitions can be multiple screens long and a buying organization can capture location, hours per shift, shifts per day, operating days per year, labour contract information, number of employees, yearly changeover, key contact information, inspection and certification info, and other fields meaningful to the buying organization. Machine capabilities can be captured for each plant and this information can include machine types, models, tonnage, average age of machines, and cost per fully loaded machine hour. Other up front costs that can be captured included detail cost information on resins (for PP, HDPE, PES, PET, etc.) by manufacturer and SKU, bottle decoration (which have one-time set-up costs, waste percentages that affect costs, dec. cost per 1,000, etc.), and colorant costs. Pricing can then be defined for each group and freight can be defined for each lane by truckload (and less than truckload if so desired). Bundles can be defined along with minimum volume rules and discount information. Capacities can be defined by plant and machine type and can include auto-increments for each machine a supplier indicates they are willing to add if such supplier is awarded sufficient business. And no time is required to set all of these templates up, because they are already there.

And once everything is captured, all of the information can be fed into (collaborative) sourcing optimization and rules (and filters) can be defined on any price or non-price factor. All of the standard price adjustment (favor/disfavor, by bid attribute), count (supplier, bid attribute), award allocation (conditional, guaranteed, relationship, revenue, etc.), exclusion, limit, and force rules are available. These rules can be restricted by any or all suppliers and bid types and allow a user to do a very powerful analysis. And once the award has been made, the details can be pushed into the contract centre where a contract can be quickly authored using an existing template, or existing clauses. BravoSolution’s category solution RFXs are very well thought out and much better than many of the first generation e-Sourcing tools still on the market (which were a great start, but leave much to be desired once a Supply Management organization is ready for next generation sourcing).