Tuesday, December 21, 2010

Cause and effect of Poor Forecasting

What really causes a bad forecast? What is the impact to the business when you have a poor or unreliable forecast? I have found that the financial impact can be quite severe when forecasts are not reliable? How about you? I want to use this post to share an example of the impact an unreliable forecast had on one of my clients.

The Situation

Here is a brief synopsis of the situation. The client is a large manufacturer in the wireless industry. They manufacture their equipment offshore and also warehouse a large portion of their inventory offshore. But, here is where the problem comes in. Because of unreliable sales forecasts, they also had to maintain a large inventory presence onshore. Their poor forecasting not only forced them to warehouse millions of dollars of inventory onshore, but also negatively impacted their supply chain management, causing them to over manufacture, just in case.

“What does 75% closed really mean?”

I was reviewing the forecasting process with one of the client’s sales managers and noticed that every stage of their pipeline forecast had a % associated with it. This is a fairly common practice, but here is where I ran into the real root cause of their forecasting challenge. I selected a stage that was marked 75% and asked, “What does 75% closed really mean?” He couldn’t tell me. There was no clear definition for the 75% stage, nor for any of the other stages as well. Without a clear definition of each stage in the pipeline, how could they have a reliable forecast? How can they tell if an opportunity was truly advancing? How many of you have seen a similar situation?

Resolution Approach

So what to do? We began by stepping back and looking at their entire sales process model in their CRM system. While they had defined some characteristics of each stage, the definitions were not very clear and left a lot of room for interpretation. We reexamined how they were selling their solutions, how the customer was buying the solutions, and came up with key buying milestones that we could turn into measurable criteria to advance an opportunity through the pipeline. We linked the definition of each stage of the sales process to a stage in the customer’s buying process. We made a clear definition of the criteria necessary for advancing an opportunity to the next stage. With advancement criteria clearly defined, we were ready to improve forecasting accuracy.

Business Outcome

We started by reassessing the existing pipeline and more effectively tracking all opportunities. We applied the new criteria to all of the opportunities in the pipeline. As you might expect, there was a lot of movement – most of it to the earlier stages of the sales process. Once the projections were adjusted to match the criteria, the forecast became much more reliable. The monthly and quarterly forecast reliability increased significantly. Communications with the supply chain management organization also improved. And, within one quarter, they were able to reduce the level of on-hand inventory required in the US by approximately 15%, saving millions in inventory and manufacturing costs.

I would like to hear from the followers on experiences they have had and how they assessed the situation and improved their forecasting.


Stay Tuned! Stay Focused! Good Selling!

Monday, November 29, 2010

Welcome to The Sales Forecaster



Welcome to The Sales Forecaster. I am happy that you are here, and I’m looking forward to an interesting and fun dialog on sales process, sales forecasting, and the implications of inaccurate forecasting.


Have you ever wondered how, or even if, you could improve your sales forecasting? What would it be like if your forecast, month over month, was 95% accurate, plus or minus 4%? In other words, you were right on the money each month with your forecast. How would that affect your business? What would you be able to do or do differently with a much more accurate forecast?


Let’s look at the typical results that can come from a solid, reliable forecast. My experience has been that the first result of a good forecast is directly tied into the overall business growth of the company. When sales forecasts are inaccurate, the inaccuracy impacts all aspects of the business. Think about the allocation of resources, the investment in capital, the effectiveness of the supply chain, and the impact on inventory. At a minimum, poor forecasting impacts the expense level of the business which, in turn negatively impacts profitability.


So, can you really build accurate forecasts? My simple response is – YES, absolutely! But, to do so, each business needs to look at their own sales approach to determine how they can best define their Sales Process so that the accuracy, or predictability, percentage goes way up.


Through this blog, I plan on sharing insights on how various organizations are improving their sales forecast accuracy and how it is positively impacting their business. I will be discussing how you can build a Sales Process model that significantly improves your sales performance and forecast accuracy. I will also be sharing insights from a number of companies on how bad forecasting hurts them. Key to this blog's success will be your feedback on ideas to improve sales forecasting so that business can run more efficiently and profitably.


I look forward to your active participation and your comments in the days ahead. I am planning on posting new ideas about twice a month. I may do so more frequently as we get more participation. Stay tuned! Stay focused! Good Selling!