Price Forecasting: Who Needs That?

By Paulo Moretti

August 01, 2013 at 8:00 AM

Common wisdom says that any price forecast is already wrong the moment it is published. I can only smile and agree with this. If people were able to predict the price of anything, they would be billionaires and very well known by now.

I’d like to hold this thought about price forecasts for a moment and talk about something we all know about: Weather forecasts.

Weather Forecasting

Historians tell us that Babylonians in 650 BC predicted the weather from cloud patterns. Around 300 BC, Indian astronomers developed weather-prediction methods. It was only in 904 AD that Wahshiyya, an Iraqi alchemist, began forecasting weather based on observed patterns of events called pattern recognition. The publication of written weather forecasts did not begin until August 1st, 1861 by Admiral Robert Fitzroy (in The Times of London). That means official weather forecasting turns 152 years old today. 

Fitzroy started studying weather forecasting for a good reason. In 1859, a steam clipper named the Royal Charter was lost in a terrible storm with at least 450 killed. For years he published the forecasts despite strong criticism that they could not possibly be accurate. After much debate, his public forecasts ended in 1866.

From the BBC, “You have to admire Fitzroy for trying. He saw the big picture and walked the first few steps along a very hard path. Even now, when we have a sky full of satellites and enormous computational weather models, we don't always get it right.”

Today, we all use weather forecasts to prepare for future events. From air and marine traffic, to crop reports and outdoor weddings, we all rely on accurate data to guide decisions on our safety, business, and social lives.  And despite our best technology, we still sometimes get it wrong.

Those criticisms of inaccuracy with weather forecasting most certainly apply to our earlier topic of price forecasting. However, for the savvy user, price forecasting can be an invaluable weapon in the Purchasing arsenal.  Let’s see how.

Futures Markets

Many companies already use futures markets in currencies, grains, metals, and energy, trading over US$1.5 trillion a year. Commodity prices are volatile according to the balance of supply and demand. To mitigate this volatility, a futures contract is an agreement to buy and sell an asset at a certain date at a certain price. That is, Investor A may make a contract with Farmer B in which A agrees to buy so many bushels of B's corn at $15 per bushel. This contract must be honored whether the price of corn goes to $1 or $100 per bushel. 

Futures contracts can add stability to certain markets, but they contain the risks inherent to all speculative investing. Here, then, is a prime use of price forecasting.

Price Forecasting

Purchasing deals with prices every day for diverse categories like Raw Materials, Logistics, MRO, Capital, Packaging, Labor, and other products and services. Some categories already have price forecasts done by well-respected companies like ICIS (forpetrochemicals, energy, and fertilizer), IHS Global Insight  (forcountry and industry forecasts), and many others in specific fields.

Many collect opinions from hundreds of experts to understand the trends and cost drivers to publish their forecasted prices. Others have developed mathematical models to predict future prices. To be sure, both methods incur inaccurate predictions. However if trends are identified, Purchasing can take a reasoned position about buying more or less, according to their perceived needs.

Models

Experts in price forecasting identify two kinds of models: Univariate and Multivariate. 

  • Univariate modeling is based solely on the history of the variable being forecast itself, using trends, seasonality, and cycles. It is used for short-term forecasts.
  • Multivariate modeling is based on the history of variables and drivers like GDP, PPI, inflation, raw materials, etc. It is used for longer time horizons. Best practices say that each year of forecast requires four years of historical data.

Development Process

The eight steps below are based on my own experience at Fortune 500 companies where we developed models for Raw Materials, Logistics, and MRO, totaling US$12 billion of spend.

Define with category leader the product families to be forecasted based on their priorities and business needs. The definition must include the region and the lowest level of granularity as possible.

Using Mind Map, interview the purchasing expert to capture and visually outline the information about cost drivers. You must understand what affects the price of your product or service in each region.

Collect the external historic macro-economic data of all the cost drivers you are able to find. To maximize certainty, collect four years of data.

Collect the historic internal data of the product or service you want to forecast. Again, it is best to collect four years of data.

Using specific software from SAS (Statistical Analysis System), compare both internal and external historic data. The software is able to show which 3-5 external variables are most correlated with internal data by calculating the R-square for each variable (where higher is better).

Develop the forecast models where each variable participates in such proportion and time lag effect. For example, if the model is driven by GDP, PPI, and Raw Material X, the model may have a proportion of 3X, 2 PPI, and 1 GDP effect; it also includes the time lag like GDP 3 months in the future, with one month ahead for PPI and Raw Material X.

For each model, the software calculates the Mean Absolute Percent Error (MAPE), where below five is considered excellent.

Once all models are developed, one person from the category is able to update the recent historical data monthly or quarterly, run the model with the help of an Excel add-in, and publish the graph forecast to users and business clients. Each update adds one time horizon, keeping a 12- or 18-month horizon. 

Price_Forecast.JPG

The above graph shows the historic internal data (dots) very close to the model (line), which reconstructed the past using past driver data. This means that the price forecast has 95% confidence. 

Takeaways 

As with weather forecasting, people in Purchasing use price forecasting to prepare themselves for future events. Although never 100% accurate, they show us trends and patterns that can be used to avoid big losses.

Purchasing people have used price forecasting in order to:

  • Inform business clients about trends so they can take proactive price actions to prevent margin erosion.
  • Inform other internal clients for budgeting capital expenditures and freight costs.
  • Adjust product and service sourcing plans for buying more or less according to the needs and price trends.
  • Use repeatable data-driven methodology to understand price trends.

Although there is still criticism of price forecasting, just as with weather forecasting, it is only a matter of time before we adapt to it and learn how to use it well. With experience, I trust this process will not take us another 152 years to achieve.

Taking Purchasing to the next level, 

Paulo Moretti

Principal PM2Consult

Download the PDF Price Forecasting: Who Needs That?



Tags: purchasing Supply chain management Prices Procurement sourcing forecast
Category: Blog Post

Paulo Moretti

user_avatar

Paulo Moretti is Principal at  PM2Consult.com, a boutique consulting company focused on excellence in the purchasing function for manufacturing industries and market analysis of Chemicals & Plastics industries. 

Prior to becoming Principal, he was Senior Consultant at Vantage Partners, and worked 35 years at The Dow Chemical Company, where he developed experience in such diverse areas as Manufacturing, R&D, Sales, Marketing, Finance, Strategic Planning, e-Business, and Purchasing. 

A native of Brazil now based in the U.S., Moretti holds a Bachelor’s degree in Chemistry and Chemical Engineering, with Master’s degrees in Industrial Management and in Business and executive course certifications from Kellogg, Wharton, and MIT Sloan. 

 

 

 

 


Please add a comment

You must be logged in to leave a reply. Login »


Related Content

Supplier Segmentation Tools Help Drive Procurement Productivity

Paulo Moretti

The overall objective of supplier segmentation is to identify high-yield segments, that is, those segments most likely to be profitable or show good growth potential. According to Read More

3 Strategies for Enhancing Collaborative Innovation with Suppliers

Guest Editor

(This article is an extract from a kodiakrating.com article and is published courtesy of kodiakrating.com) The old leadership adage: ‘You’re only as good as your team’ truly applies when it comes to optimizing the innovation, supplier collaboration c… Read More

The 2018 EPIC Awards: Recognition of Those who are Evolving the Procurement Profession

Dennis Bouley

The EPIC Awards recognize and celebrate the most innovative, dynamic, and accomplished procurement leaders. This year, nominations will be accepted for Read More


Supplier Profiles

Staples

Staples Advantage is the one supplier that offers all the business solutions you need, all with the expertise of a specialty vendor. Read More

Digi-Key

It started in 1972 with an idea, a new concept in distribution. Today, Digi-Key Corporation is one of the fastest-growing electronic component distributors in the World. The stimulus for this growth is Digi-Key's customer-centered business philosophy… Read More

Lunney Advisory Group

Lunney Advisory Group was founded in 2007. Our firm is not your typical consulting company. Some members of our firm are highly qualified and experienced industry executives/practitioners while others are full time or adjunct university professors.… Read More


Webcasts

What CEOs Expect Of Purchasing

Guest Contributor

Procurement and supply management leaders have a seat at the table, and management’s expectations are high. But what do CEOs really want, and is purchasing delivering on these expectations? This webcast looks at how procurement and supply management … Read More

Growing Purchasing Influence On Indirect Spending

Guest Contributor

At world-class companies, purchasing’s influence touches just about every area of spending. But, how exactly do procurement teams get to the point where other departments approach them for help with sourcing such indirect categories as human resource… Read More

Procurement-Finance Collaboration

Guest Contributor

Procurement & finance are two business functions which are often at loggerheads with each other. One reason for this is the lack of perception alignment on an important metric of procurement and finance performance - 'savings'. Read More