To gather forecasting input from the sales force -- or not?


A recurring question among business forecasters is how to incorporate input from the sales force. We discussed this last year in The BFD post "Role of the sales force in forecasting." But the question came up again this week in the Institute of Business Forecasting discussion group on LinkedIn, where Leona O of Flextronics asked:

My company is using Excel to do Sales Forecasting on a monthly basis, I am looking for a solution to automate the front part where sales people will input their numbers directly in the system (instead of compiling different Excel spreadsheets currently). Our forecast period is for 36 months, please recommend a software that could automate this function.

The story of O is a familiar one. The good news is that when a company is ready to move ahead from Excel, there are plenty of forecasting software choices available. These include my personal favorites: SAS Forecast Server (for large-scale automatic forecasting) and SAS Forecasting for Desktop (which provides the same automatic forecasting capabilities for small and midsize organizations).

However, before automating the collection of input from the sales people, we need to first ask whether this is even advisable?

If it is known that the sales force inputs are adding value to the forecasting process (by making the forecast more accurate and less biased), then making it faster and less cumbersome to provide their inputs could be a very good thing. If a company hasn't already done this (and I don't know the particular circumstances at Flextronics), I would suggest they first gather data and determine whether the sales force inputs are adding value.

There are reasons why they may not be.

In addition to being untrained and unskilled (and generally uninterested) in forecasting, sales people are notoriously biased in their input. During quota setting time they will forecast low, to have easier to achieve targets. Otherwise they may forecast high, to make sure there is plenty of supply available to fill orders.

Also, if you ask someone whether they are going to hit their quota, the natural response is "Yes!" -- whether they believe they'll hit their quota or not. Why get yelled at twice (first for admitting you won't hit your quota, and then again at period end when you don't hit it), when you can just say yes you'll hit it, and then only get yelled at once (at period end when you don't hit it). Steve Morlidge made a similar point at his International Symposium on Forecasting presentation in 2012.

If you find that your sales people are not improving the forecast, then you'll make them very happy -- and give them more time to sell -- by no longer requiring their forecasting input. So rather than implement new software to gather sales input, it may be simpler, cheaper, and ultimately much more effective, to stop gathering their input. Instead, implement software to generate a better statistical forecast at the start of the process, and minimize reliance on costly human intervention.


About Author

Mike Gilliland

Product Marketing Manager

Michael Gilliland is a longtime business forecasting practitioner and formerly a Product Marketing Manager for SAS Forecasting. He is on the Board of Directors of the International Institute of Forecasters, and is Associate Editor of their practitioner journal Foresight: The International Journal of Applied Forecasting. Mike is author of The Business Forecasting Deal (Wiley, 2010) and former editor of the free e-book Forecasting with SAS: Special Collection (SAS Press, 2020). He is principal editor of Business Forecasting: Practical Problems and Solutions (Wiley, 2015) and Business Forecasting: The Emerging Role of Artificial Intelligence and Machine Learning (Wiley, 2021). In 2017 Mike received the Institute of Business Forecasting's Lifetime Achievement Award. In 2021 his paper "FVA: A Reality Check on Forecasting Practices" was inducted into the Foresight Hall of Fame. Mike initiated The Business Forecasting Deal blog in 2009 to help expose the seamy underbelly of forecasting practice, and to provide practical solutions to its most vexing problems.


  1. I see things somewhat differently. Sales people have a responsibility to themselves and their company to try and predict sales for many good reasons. Mostly to help balance company assets (inventory) that drive customer service. Engaging sales people directly with an on line tool ensures their commitment to the numbers and publicly displays the results for all to see and grade them. For example if we treated development people like you suggest treating sales people then we would never get any project completion dates and product planning would go south. I have managed sales people for over 20 years and they like to take the path of least resistance (don't bother with forecasting) but frankly they have the same responsibility as the rest of us to commit to a task and then complete it. Their are some fine tools out there for collecting sales inputs such as Silvon's Stratum Viewer product when combined with the Stratum Forecast engine the solution provides a complete sales forecasting and planning solution

    • Mike Gilliland
      Mike Gilliland on

      John, thank you very much for the thoughtful comment. I want to explain why I'm still not convinced that including sales people is a sure way to improve forecasting, and will do so in a new blog post.

  2. Pingback: Engaging the sales force: Forecasts vs. Commitments - The Business Forecasting Deal

  3. Pingback: Engaging the sales force: Forecasts vs. Commitments

Back to Top