Daily Archives: June 30, 2011

What Impact Will a 9% Drop in Profits Have On Your Organization?

Unless your Supply Management organization takes it to the next level, your company is facing a 9% drop in corporate profits this year due to rising prices and other inflationary pressure according to a recent Hackett Group study. For a typical Global 1000 company with 27.8 billion in revenue, Hackett’s study estimated that commodity and offshore labor inflation will drive a 150 million per year hit to the bottom line. Ouch!

Why? While most companies are now able to effectively anticipate commodity price increases, more than 60% of companies surveyed by Hackett in the recent study have not been successful at mitigating these cost increases. The reality is that few executives have experienced significant inflation, which is now at levels not seen in 30 years (when inflation rates hovered around 13% back in 1981).

And while inflation may not yet be at 13%, it is bad. Not only do respondents to the Hackett study expect the rate of inflation for commodities overall to rise by more than 30%, to 6.3% a year, but commodity price volatility has increased nearly 60% since before the recession. Making matters worse, at the same time, due to the talent crunch, the rate for internal labor is expected to more than triple from 0.7% to 2.2% and the rate of inflation for external labor is expected to more than double from 1.2% to 3%.

The problem, as identified by the Hackett study, is that most companies tend to take a fragmented, siloed approach to anticipating and mitigating costs. And while more advanced companies will forecast prices and do some basic hedging by adjusting contract length, purchase volumes, or inventory levels, few take the cross-functional approach required to combat the mitigation. The majority of companies do not do the analysis required to understand the impact of commodity cost increases on profitability, do not use specialized analytics to anticipate future commodity costs, and do not provide clear direction and policy for making hedging decisions. A future post will explore in greater detail some of the options presented in Hackett’s study on “Taming the Inflation Dragon” and why your organization must adopt more advanced

Mintec – Data for the Masses from the Masses

Regular readers of SI will know the importance of good should-cost modeling (which is also great for negotiations) as well as good market intelligence (which has dimensions and is valuable in a down economy) in cost reduction and avoidance. And while both should-cost modelling and market intelligence have a number of critical requirements that must be met for success, they both have one key requirement in common — good data. But where do you get good data? Certainly not from supplier bids! A new supplier is going to bid what it thinks it can get, not what the actual price is. Market indices from governments and professional associations? Better, but they will typically be at least a month or so behind. Trade associations that track and monitor prices on a daily basis or stock markets that trade the commodity? Great — but do you have the IT skills to integrate the feeds? And are you going to do it for the dozens of raw materials and commodities you need to build your should cost models?

The best place to get data en-masse is from a professional data provider that tracks and integrates all of the feeds you need into a centralized database that is updated with fresh data for the categories you need when you need it and that maintains years of historical data for analysis purposes. One such provider is Mintec. Formed back in 1982 by consultants and analysts who realized that real savings required real data, Mintec has been collecting raw material, commodity, and service price data from around the globe for almost 30 years. Used by 16 of the top 25 Global Food & Beverage & Retail companies, Mintec maintains price data for a database of 75,000 “line items” from A to Z across dozens of industries and categories. It then distills this information into custom databases for each client that contain just the line items they need, pre-processed and normalized to their defaults. (Combine this data with a great expressive-bidding optimization platform, such as that provided by BravoSolution or Trade Extensions and you have cost avoidance engine that can’t be beat!)

To help their clients understand the data, Mintec provides a data analysis package, called Datagain, which can be used to import, graph, analyze, and compare different line items (such as the petrol price in the UK and the petrol price in Australia, normalized to US dollars). A user can graph any set of series, against any frequency, using any (currency and unit) converions, for any date range she chooses. She can also normalize or index this data using a custom formula, factor in seasonality, and plot trends. She can also break the series down across two or four graphs and/or plot specific subseries, against different projections, to see how the price might trend over time under different assumptions. The normalization / indexing equations can use all of the standard algebraic operators and be defined over any set of variables, including user defined variables, that the user chooses.

If the user is not sophisticated at trend analysis, or does not want to do it, Mintec also offers Benchmarking and Market (Intelligence) Report services that do a deep dive into a particular raw material, commodity, or service that discuss recent, current, and projected pricing subject to the state of the market and the dominant factors at play. These, by request, reports complement the monthly market reports and commodity fact sheets that track the major commodities and markets and their relative month-over-month changes for buyers who want to look at the bigger picture. If the user wants to learn more about Datagain, analysis, and should-cost modeling, Mintec also provides on-demand out-of-the-box and customized training sessions as well as quarterly newsletters and occasional articles.

It’s a huge amount of data, that comes at a very low price point. Most customers pay less than 100K £s for access to the data they need, when they need it, updated as often as they like. Moreover, medium-sized business can get basic access (to the datafeeds) and access to the desktop Datagain tool for as little as 10K £s a year. Large enterprises will probably want the on-line hosted applet version (at the higher price-point) that runs through the browser on a hosted database that is accessible anywhere, anytime, and always up to date. While it is more expensive, it’s still cheap compared to what the organization will be paying for their ERP solution (and much more valuable from a cost avoidance perspective).