Classification by numbers: Dutch chemicals manufacturer adopts e Cl@ss-based spend analysis

Colin Rickard, a managing director with data-management specialist DataFlux, says work with chemicals giant DSM prompted development of an off-the-shelf commodity coding solution for the purchasing and spend-analysis process that saves users time when managing data quality with international coding standards such as UNSPSC and e Cl@ss.


When Heerlen, The Netherlands-headquartered DSM decided it needed greater visibility into its spend, it discovered that specialist strategic sourcing applications weren’t fully equal to the task of matching and classifying the products and services it was buying.
Instead, relates DSM’s global data manager Joachim Beurskens, the [euros] 9 billion multinational chemical company went with a custom-developed solution from data management vendor DataFlux , a subsidiary of business intelligence specialist SAS Institute.
The logic was simple: Rather than invest effort in a complicated "after the event" spend analysis that looked problematic at best, do the classification at the point of raising the purchase order—that way, a body of data would build up that was known to be not only accurate, but up-to-date.
But things weren’t quite that straightforward. Direct spend, totaling some [euros] 4 billion each year, wasn’t a major headache, explains Beurskens. The requisite coding information could be applied to each raw materials item master record within the company’s SAP enterprise suite, enabling future purchases to be logged. “But indirect spend, equating to [euros] 2 billion each year, was a much bigger problem,” he says. “It wasn’t covered by SAP-derived purchase orders, but free-format text orders raised by end users and buyers.”
In theory, Europe’s e Cl@ss global classification system was the ideal means for classifying every purchase: Simply require the person filling-in each purchase order to insert the correct e-Cl@ss code. But with some 27,500 codes to choose from, and a lot of maverick buying, data accuracy was low.
“Worldwide, there were a thousand people raising purchase orders, and we were asking them to make consistent judgments about which of the 27,500 codes was applicable to every order,” recalls Beurskens. “What was worse, they themselves didn’t have a vested interest in generating the right code. They just needed a code to put on the order, and would often put on the highest-level code that looked right.”
Enter, in March 2007, DataFlux, which already had a relationship with another part of the DSM group— DSM Nutrition .
A plan soon emerged, says Colin Rickard, DataFlux managing director for Northern and Western Europe. For a start, classification at the very detailed 27,0000-code level was probably a step too far. In practice, classification at a higher level, containing just 1,000 codes, would still generate meaningful insight to purchase spend.
“What this meant was that if we could retrospectively analyze past purchases and assign them to the correct code at the 1,000-code level, we could develop an intelligent‘prompt’ to add to the purchase ordering system,” says Rickard. Better still, by harnessing service-oriented architecture, the prompt could be fully integrated with the normal order-raising process, whether that was SAP-based, or one of the more rudimentary systems in use throughoutthe group—or even little more than a spreadsheet-based system.
With a plan in place, progress was rapid. It took just 25 days, for example, to build the reference database, created by analyzing and classifying some five years of purchase data. Coding, too, was quick.
“What did take time was testing,” recalls Rickard. “The data had to be correct, otherwise the exercise was pointless.” A further barrier to progress was the fact that internal DSM rules meant that new software could only be released into the corporate IT environment at two points in the year—meaning that the next available go-live date was November 2007.
Today, says Beurskens, the DataFlux-built application is working as intended, with every purchase order being matched to the appropriate e-Cl@ss code.
“Users enter the text for the item they want to buy, along with any items codes that they have, and a screen pops up saying:‘Here are the top five recommended e-Cl@ss codes based on what you’ve typed’,” he explains. “It looks exactly like the normal SAP purchase order process, but behind the scenes it is matching the text against hundreds of thousands of keywords in several languages, and generating e-Cl@ss codes.”
All the user has to do, adds Rickard, is scroll down the proffered list to select the right item, or click on the screen’s radio button to accept the top suggestion. “Compared to the levels of classification accuracy that DSM obtained, it’s a significant improvement,” he says. “Granted, the [euros] 2 billion indirect spend is only a third of the overall annual spend, but even a small percentage improvement in purchase cost on [euros] 2 billion is still a significant amount.”
Beurskens concurs, pointing to future projects already in the pipeline. A planned extension of the sourcing work, he explains, will be to intercede in the "create new vendor: process, intelligently matching proposed new vendors typed in at the input screen to vendors already on file in the system. “The idea is to make sure we aren’t entering a vendor that is already set up, but with a different spelling or format,” says Beurskens.
DataFlux, too, has plans, says Rickard. The work with DSM has prompted the company to develop an off-the-shelf commodity coding solution called DataFlux Commodity Coding Accelerator, enabling users to save time when managing data quality with international coding standards such as UNSPSC and e Cl@ss.
At press time, pricing information is unclear, but, concludes Rickard, the new product is due to be formally announced at the end of April.

The Top Plant program honors outstanding manufacturing facilities in North America. View the 2015 Top Plant.
The Product of the Year program recognizes products newly released in the manufacturing industries.
Each year, a panel of Control Engineering and Plant Engineering editors and industry expert judges select the System Integrator of the Year Award winners in three categories.
Pipe fabrication and IIoT; 2017 Product of the Year finalists
The future of electrical safety; Four keys to RPM success; Picking the right weld fume option
A new approach to the Skills Gap; Community colleges may hold the key for manufacturing; 2017 Engineering Leaders Under 40
Control room technology innovation; Practical approaches to corrosion protection; Pipeline regulator revises quality programs
The cloud, mobility, and remote operations; SCADA and contextual mobility; Custom UPS empowering a secure pipeline
Infrastructure for natural gas expansion; Artificial lift methods; Disruptive technology and fugitive gas emissions
Power system design for high-performance buildings; mitigating arc flash hazards
VFDs improving motion control applications; Powering automation and IIoT wirelessly; Connecting the dots
Natural gas engines; New applications for fuel cells; Large engines become more efficient; Extending boiler life

Annual Salary Survey

Before the calendar turned, 2016 already had the makings of a pivotal year for manufacturing, and for the world.

There were the big events for the year, including the United States as Partner Country at Hannover Messe in April and the 2016 International Manufacturing Technology Show in Chicago in September. There's also the matter of the U.S. presidential elections in November, which promise to shape policy in manufacturing for years to come.

But the year started with global economic turmoil, as a slowdown in Chinese manufacturing triggered a worldwide stock hiccup that sent values plummeting. The continued plunge in world oil prices has resulted in a slowdown in exploration and, by extension, the manufacture of exploration equipment.

Read more: 2015 Salary Survey

Maintenance and reliability tips and best practices from the maintenance and reliability coaches at Allied Reliability Group.
The One Voice for Manufacturing blog reports on federal public policy issues impacting the manufacturing sector. One Voice is a joint effort by the National Tooling and Machining...
The Society for Maintenance and Reliability Professionals an organization devoted...
Join this ongoing discussion of machine guarding topics, including solutions assessments, regulatory compliance, gap analysis...
IMS Research, recently acquired by IHS Inc., is a leading independent supplier of market research and consultancy to the global electronics industry.
Maintenance is not optional in manufacturing. It’s a profit center, driving productivity and uptime while reducing overall repair costs.
The Lachance on CMMS blog is about current maintenance topics. Blogger Paul Lachance is president and chief technology officer for Smartware Group.
The maintenance journey has been a long, slow trek for most manufacturers and has gone from preventive maintenance to predictive maintenance.
This digital report explains how plant engineers and subject matter experts (SME) need support for time series data and its many challenges.
This digital report will explore several aspects of how IIoT will transform manufacturing in the coming years.
Maintenance Manager; California Oils Corp.
Associate, Electrical Engineering; Wood Harbinger
Control Systems Engineer; Robert Bosch Corp.
This course focuses on climate analysis, appropriateness of cooling system selection, and combining cooling systems.
This course will help identify and reveal electrical hazards and identify the solutions to implementing and maintaining a safe work environment.
This course explains how maintaining power and communication systems through emergency power-generation systems is critical.
click me