Is Improved Demand Forecasting an Opportunity in a Challenging Environment?

I was perusing through the usual financial and business sources when I came across this interesting article in the Wall Street Journal titled, “Trying Times for Forecasting”. The article focuses mostly on financial forecasts and I think we have written a fair amount about the importance of making sure financial results derive from the same sources of data, professionals, and market input as the S&OP forecast – in fact, with differences only in level of detail, all three should be the same forecast.

However, this article raises a couple of interesting issues from the macro level – i.e. the value of financial forecasts and the impacts of external forces that I thought would be fun to dig into a bit.

First, all the participants in this article, and I would probably argue all officers of public companies and some private companies, agree to the value of demand forecasting and guidance.  Specifically they list three specific areas of value:

  1. A less volatile and more fully valued stock prices (big value, sweet spot on the fiduciary responsibility component)
  2. Credibility with Analysts (never underestimate the importance of your reputation)
  3. Confidence of stockholders large and small (directly related to #1 above)

Yet at the same time the value of accurate forecasting was highlighted, concrete examples were showing where companies were sharing less information less frequently thereby making the guidance less useful.  Specifically companies are:

  1. Increasing the min-max ranges (revenue will be 100 give or take a 100)
  2. Discontinuing the more difficult yet more meaningful variables
  3. Minimizing specifics.

This somewhat contradictory dynamic (to put it as nicely as possible) probably explains the huge swings in stock prices we have seen recently when forecasts have been missed – and when I mention huge swings I mean large drops in stock prices costing shareholders potentially billions of dollars in value;  An interesting case study in how to manage shareholder value and the role of fiduciary responsibility.

I would argue it does not need to be this way. It seems to me that the answer is more information, and more of it with better quality.  Given the right tools, process and strategic objectives (oh I don’t know – make sure our stock price is fully valued), companies should be able to provide forecasts that are accurate on the bedrock variables – revenues, margins, yields, growth rates etc.  In addition, they should actually be able to provide detailed scenarios to showcase how much time, energy and thought goes into considering all the risks to the value drives of their companies – both within their industries and within the greater global market place at large.

Imagine the increase in credibility if, rather than stop reporting on yields or revenue growth, a company were able to provide detailed scenarios about what is impacting those yields or growth rates.  The global forecast for interest rates is between A on the high side and B on the low side.  If interest rates hit A, that will decrease our revenue within this range.  If interest rates hit B, that will increase our revenue within this range.  Same applies to growth rates in target markets. What happens if the Euro Zone implodes?   Exchange rates diverge from historic norms?  Sure this all complex and to a large degree inter-related but rather than give up, dive in and tackle them and use them to provide a richer context for the guidance provided.

This will improve your credibility with the entire investing community, ensure a fair value for your company, and help realize a further return on the strategic investment to improve demand forecasting.

Demand Forecasting – Proven bang for the buck on the bottom line

Solving business problems and helping our partners create future profits – Demand Foresight is completely focused on these goals. We focus on delivering upon these through improving demand planning and overall S&OP operations and helping support transition to being a demand driven company.  Our experience in this work helps us quantify the impact of what we do – a minimum 5% improvement in pre-tax profitability.  But obviously we are not the only game in town and there is a tremendous body of work around demand forecasting and the impact of improving the forecast on various components of the supply/value chain.  It was brought up that we had never really highlighted some of this research so we went back and took a look at some of the source inspiration for our focus.  I hope you find this of value.

First up is Dr. Hau Lee.  He is the Thoma Professor of Operations, Information, and Technology at Stanford University; Co director of The Stanford Global Supply Chain Management Forum;  Director of Managing Your Supply Chain for Global Competitiveness Executive Program.

Dr. Lee’s signature idea is the “bullwhip effect,” a concept he co-developed in the 1990s, which has become a basic tenet in both academia and industry. When a person cracks a bullwhip, the small movements at the wrist produce huge waves at the other end of the whip, which describes how information on demand becomes increasingly exaggerated and distorted as it moves up the supply chain from customer to manufacturer to supplier, driving up costs and hurting efficiency.

There are several components to the cause, effect, and solution to the bullwhip effect which you can start to explore through the attached links but one key is that the demand forecasting capability plays a large role in the bullwhip and the effects can be devastating to a company’s value chain.  Specifically:

“Distorted information from one end of a supply chain to the other can lead to tremendous inefficiencies: excessive inventory investment, poor customer service, lost revenues, misguided capacity plans, inactive transportation, and missed production schedules.”

Given Dr. Lee’s long term research and cooperation with client companies, the impact of improving forecasting and focusing on demand drivers is significant.

“I have already seen some companies using new software tools to manage their businesses based on demand, with results ranging between 50% and 100% in net profit increases, which in turn can easily be translated into enormous increases in shareholder and market values.”

http://www.gsb.stanford.edu/news/bmag/sbsm1008/feature-lee.html

Next up is Dr. John Mentzer.  Dr. John T. (Tom) Mentzer was the Harry J. and Vivienne R. Bruce Chair of Excellence in Business in the Department of Marketing, Logistics and Transportation at the University of Tennessee. He was a prolific researcher and author with 5 books on value chain excellence and competitive differentiation not to mention hundreds of articles to his name.

One of his key areas of research highlighted competitive differentiation and included was a fairly definitive summary of what it took to develop a competitive differentiation in demand forecasting and demand planning.

Specifically, here are Dr. Mentzers’ 7 Keys to better forecasting:

  1. Understand what forecasting is and is not

  2. Forecast demand, plan supply

  3. Communication, cooperation, and collaboration

  4. Eliminate islands of analysis

  5. Use tools wisely

  6. Make it Important

  7. Measure, measure, measure

Most important of all was that Dr. Mentzer extended his research, through the help of many colleagues and collaborators, to the measurable impact (following his own guidance – measure) on a company’s performance.  There are a number of components to the result most of which you can begin to explore through the included links but from the point of view of an executive and/or member of the vaunted c-suite with specific fiduciary responsibility to all stakeholders of a company – the single most clarifying result of improved forecasting highlight by Dr.  Mentzer:

An increase of shareholder value of 15% or more!

http://bus.utk.edu/supplychain/forecasting/docs/Impact%20of%20Forecasting%20F99.pdf

http://www.uam.es/personal_pdi/economicas/rmc/prevision/pdf/seven_keys.pdf

Lastly, we referred to our friends at Garter which includes the recently merged business/supply chain analysts from AMR Research.  There are a host of strong practitioners such as Noha Tohamy, Tim Payne, Mike Griswold, Dennis Gaughin, and Steve Steurterman just to name a few. Since January 2011 they have published a large number of research papers and articles that highlight the impact of improved demand forecasting.  Unfortunately here we cannot include the source documentation links as that goes against policy and legal agreements, but please feel free to contact Gartner directly (www.gartner.com).  As they are a potentially important source of information for companies looking to make strategic investments in demand forecasting, sales and operations planning, and demand driven supply chains and networks.

Relevant to this blog post, their cumulative research has pointed to some significant findings.

Gartner’s measurable impacts of improved forecasting and demand planning:

  1. 1% to 3% revenue increases

  2. 15% to 30% inventory reductions

  3. 20% to 30% order fill rate increases (Demand Foresight note – important to do 2 and 3 simultaneously)

  4. 10% to 15% decreases in obsolete inventory

  5. 3% to 5% increases in gross margin

Independent of Demand Foresight and its experiences working with it partners, there is great research ongoing that undeniably highlights the benefits of focusing on improving demand forecasting and demand planning.  However, one consistent anomaly (kind of an oxymoron – A consistent anomaly?) that we notice is that while this highlighted research above as well as others all emphasize the importance of demand forecasting and measure the benefits of improved demand planning, very few of them talk about specific impacts based on higher percentages of accuracy.  Our suggestion and potential contribution to the field is what is the impact of improving accuracy by 5%? 10%?

Or as we ask all of our partners and potential partners – what would a minimum 25% reduction in forecast error mean to your bottom line?  Judging from our experience and the research– a huge amount!

 

Forecasting MUSTS for profitability every day and after disasters.

Supply Chain Resilience is not just for tsunamis and plant fires. The steps you put into place to prepare for manufacturing catastrophes should also benefit your daily operations and bottom line. How quickly we forget the chaos that ensues for supply chain practitioners after a major disaster.  Almost a year after the tsunami hit Japan, the harrowing headlines about the failures which will ensue if you’re not adequately prepared are gone and we’re back to business as usual. Continue reading

Compete To Be Unique

Focus on Innovating to Create Superior Value For Chosen Customers  

- Joan Magretta, Stop Competing to Be the Best, Harvard Business Review, 30 Nov 2011

You know the phrase “marching to the beat of a different drummer” is a way of saying someone isn’t following the status quo and is standing out from the crowd. It’s generally not a positive statement. We disagree wholeheartedly. Continue reading

How to know when to invest in demand forecasting software

You know WHY reducing forecast error is important – accuracy is directly linked to corporate profitability. But how do you know WHEN you should look into new forecasting technology? After listening to our customers and numerous conversations with CPG, distribution and manufacturing companies, here are 6 Indicators it’s time to look at new demand forecasting software:

1)      Your forecast error is 50%*.

While 50/50 odds are great in Vegas, they are poor for critical business decisions. Imagine standing before a room of shareholders and telling them they have a 50% chance of making money. Forecast error of this caliber can be especially hard to swallow if monies have been spent on solutions that haven’t performed or lived up to expectations. Either way you spin it “throwing darts at a dartboard” or failing to forecast at all is a direct shirking of your fiduciary responsibility.

*Or even 10% error since once you get down to the execution-level  accuracy is drastically diminished.

2)      Your data has outgrown your homegrown system.

In the days of “Plan Source Make Deliver” information was siloed and unidirectional. However, now that technology accurately portrays supply chain complexity, the data you’re collecting adds up fast. It isn’t uncommon for POS, market information, etc., to sit in a database never utilized. You spent time and energy enabling systems that could collect it so you should use it.  For as great as they once served your organization, the homegrown tools developed by Excel whizzes and data jockeys over the years can only do so much. There comes a point when the hours spent forcing the system to work aren’t worth the performance. Are you at that point?

3)      Your customers want to collaborate and shared visibility.

With these buzzwords flying around conferences and research documents you can expect that this will be request from your customers sooner rather than later. Your customers have customers and they want to have the best data available to know what’s coming down the pipe to set expectations. The benefits here are twofold. Laying the foundation for collaboration and investing in enabling technologies now will set you up for success when the time comes to execute.

4)      Your boss is haranguing you to reduce inventory.

According to a Gartner study, “better demand forecasters have 15% lower inventory.” Now is the time to get ahead being that Accenture found that companies who employ predictive analytics hold 50% less finished goods inventory than their competitors. These numbers speak for themselves. Inventory is the biggest and least productive asset on the balance sheet so accurately forecasting will make you your CFOs favorite colleague.

5)      Your competitors are investing in S&OP enabling technology.

They are becoming leaner, meaner and more agile. While you’re waiting for a spreadsheet to be updated and passed around between sales, production and finance – they are receiving alerts and have real-time data to make faster, better decisions. It’s a commoditized world and your customers have options. With the rate at which information flows it’s won’t be long before they hear from a colleague how much better they’re serviced by the other guys.

6)      You want to hit your bonus.

Be good at your job. Scratch that. Be GREAT at your job. If you own the forecast your compensation metrics are more than likely tied to accuracy. You’re going to have to be passionate about pursuing new technology for forecast as you will be asked to be the “champion” through the selection process. But when your personal finances are in the mix taking on the burden will be well worth your while.

We’d love to hear your thoughts. What are the reasons that get you thinking about new forecasting technology?