In Sales Forecasting, Quality Is the New Accuracy


Share on LinkedIn

“The sales team forecasts $100 million in revenue for the quarter.”

Many companies motivate employees with incentives for matching sales results to predictions. Some punish them for being wrong. Some do both. A constant lament:  “Why, oh why, can’t I get an accurate sales forecast?” .

“Businesses often use forecasts to project what they are going to sell. This allows them to prepare themselves for the future sales in terms of raw material, labor, and other requirements they might have. When done right, this allows a business to keep the customer happy while keeping the costs in check,” according to Arkieva, a company that specializes in supply chain management. Seems reasonable.

Insisting on forecast accuracy is the easy part. It’s when people try to measure accuracy that things get weird.

One popular metric is MAPE, or Mean Absolute Percentage Error. According to the table below, APE, or Absolute Percentage Error looks relatively tight at 4% after five periods (note: APE = [actual – forecast] / actual X 100). But at 26%, MAPE suggests a different story. Using MAPE, it’s hard to describe this example as representative of stellar forecasting.


The table also reveals a subtle, but substantial, risk for interpreting forecast accuracy. Notice that periods 1 and 2 have the same actual-forecast variance (10), but sandbagging in Period 1 produces a lower APE (10%) than overstating in Period 2 (11.1%). If you’re rated on forecast accuracy, there’s a clear message: ‘tis better to be under than over. That’s warped. You can hear the rancor in customer service call center: “Half my conversations are with customers miffed about why it’s taking so long to get materials the sales rep said were in stock.”

I hate the notion of accurate sales forecasting. It’s naïve and wrongheaded. It’s contrived failure, a la Lucy from Peanuts: “Hey Charlie Brown! You kick the football while I hold it!” Year after year, CXO’s and sales managers unwaveringly insist on forecast accuracy, as they hold knives to the necks of functionaries tasked with ensuring it. Einstein would be pleased to know that his definition of insanity continues to thrive.

If I said, “a pretty good forecast is good enough,” people would malign my squishy tolerance. “Oh, you must eat vegan granola and wear Birkenstocks to sales calls.” Au contraire! My acceptance of sales forecast inexactitude comes from a passion for pragmatism – a reaction fueled by both anger and love. Author Edward Abbey wrote, “a writer without passion is like a body without a soul.” I make no apology for my astringent pronouncements.

Forecast accuracy simply doesn’t align with customer fickleness, cold feet, biases, budget revisions, caveats, vacillations, backpedaling, tactical changes, reprioritization, intervening events, committees, sub-committees, ad hoc project teams, internal bickering, passive-aggressiveness, competing interests, leadership attrition, new hires, new agendas and directives, politics (both national and intra-company), informal decision hierarchies, second-guessing, scuttled venture funding, maxed-out lines of credit, indecision, trigger events, buyouts, divestitures, mergers, competitive Hail Mary’s, and external forces. All, ingrained in corporate decision making. And I haven’t yet introduced buyer ignorance, stupidity, and confusion. “Sales forecast accuracy!” Whoever coined this oxymoron should be taken to the woodshed.

In forecasting, there’s more alchemy than reason. “The manufacturing people divide it by two after I give it to them, so I multiplied it by three before I gave it to them! Then they divided by four, so I multiplied by five. The credibility gap became ridiculous. Nobody uses my forecast anymore. They make their own!” writes  Dave Garwood , an internationally recognized expert in supply chain management. If you’re on the forecast accuracy horse, it’s dead. Get off!”

Happy to dismount, sir, because I ran out of liniment a long time ago. Following decades of complaining and handwringing ad nauseum over forecast accuracy, after countless hours in sales meetings dedicated to telling reps that forecast inaccuracy is tantamount to failure, it’s time to take a step back to ask a different question. Instead of asking for forecast accuracy, ask for forecast quality.

Pause for a moment, close your eyes, and take five powerful Ujjayi breaths. Think about what you gain when quality, rather than accuracy, becomes the goal. Namely, the liberty to think probabilistically instead of deterministically. The freedom to be wrong, and the opportunity to learn. That’s far from Easy Street. Forecast quality demands keen situational awareness, iterative learning, and continuous improvement. Compared to the don’t-be-wrong-or-you’ll-get-your-tail-kicked ethos surrounding sales forecast accuracy, that’s a valuable upgrade for sales organizations.

Forecast quality concentrates on reducing outcome volatility – not eliminating it. Forecast quality accepts the inevitability of variances. The goal is to tighten the deviation between predicted and actual.

I understand why managers insist on accuracy. Who wants to deal with variances, and all their overhead, including staffing buffers, contingent resources, safety stock, and Plans B, C, and D? CXO’s find life is easier when not bogged down with what-if scenarios. Considering worst-case, most-likely, and best-cases for revenue, unit demand, material purchases, plant capacity, transportation logistics, and labor is tough. Yet, we soldier on. As one former boss often told me, “that’s why we pay you the big bucks.”

Eight attributes of quality sales forecasts:

  1. Intelligent. Quality forecasts result from careful situational analysis and interpretation. They are supported by clean data and appropriate statistics, and not strictly on instinct or intuition.
  2. Account for intrinsic uncertainty and complexity. Resolute as a sales team might be on making goal, revenue achievement is not deterministic. Quality forecasts involve ranges like worst case, most likely, and best case.
  3. Include relevant variables and dependencies, and exclude those that are not. Quality forecasts identify which elements predict an outcome – and the relationships between them – so that probabilities can be assigned.
  4. Future-oriented. Future events can’t be predicted or modeled from historical data alone. Quality forecasts embed emerging or nascent forces into the model.
  5. Collaborative. Inputs reflect multiple points of view, including forces that the company doesn’t control (e.g. economic, competitive, technological, social).
  6. Documented. Quality forecasts clearly explain the methodology, inputs, and interpretation of results.
  7. Transparent. Quality forecasts allow other departments to learn and understand how they are developed.
  8. Iterative. Quality forecasts are continuously improved, and must be adjusted as conditions change.

Tips for achieving high forecast quality:

  1. Use forecast variance as a planning tool. Garwood advises that forecasts “should not be punitive as their primary purpose. When forecasts fall outside an acceptable tolerance, root cause analysis must be performed.”
  2. Involve the company – not just Sales. A quality forecast must include inputs from product engineering, marketing, and supply chain operations.
  3. Meet regularly to discuss forecast quality and accountability. “The #1 cause of forecasting problems is lack of accountability,” Garwood says. “A company might meet its overall revenue target, while a particular region or channel might be significantly under- or over-forecast. No region wants to be called out as ‘worst’ in forecast quality.”
  4. Pursue buy-in. Garwood suggests to “start by describing the forecast accuracy problem and how it impacts the manager, not by saying ‘here’s why this change is good for you.’ With forecast accuracy myopia, everyone spends too much time apologizing for not hitting ‘the number’ bang on. Who wouldn’t want to fix that?”

Above all, recognize the difference between good forecast quality and poor quality. That’s more nuanced than forecast accuracy. According to Garwood, “a good quality forecast means the business operates profitably within the planning variance that management has established. If the variance creates significant strategic or tactical risks, either 1) the forecast is poor quality, 2) the business lacks adequate risk capacity or 3) both.”

The post For Sales Forecasting, Quality Is the New Accuracy appeared first on Contrary Domino.

Republished with author's permission from original post.


Please use comments to add value to the discussion. Maximum one link to an educational blog post or article. We will NOT PUBLISH brief comments like "good post," comments that mainly promote links, or comments with links to companies, products, or services.

Please enter your comment!
Please enter your name here