3 Dangerous Myths About Sales Forecasting

December 3, 2008 RSS Feed Print
  • Comment (8)

Sales forecasting: It's hard enough to get it right without all the ways we get it wrong. It was on my mind over the long holiday weekend, and in this case, it wasn't a particularly cheery back-of-the-mind thought. My company's recent sales reflect the economic downturn.

Not cheery, perhaps, but now more than ever, managing your sales forecast is really important and very much misunderstood. Most people fear forecasting. They think some expert should do it. Visions of econometric models and weighted moving averages dance, devilishly, in their heads.

So why do people hate forecasting? It's mostly because of myths and misunderstandings. Such as, among others, these three:

Myth 1: It's About Accurate Forecasting

Not really. We're all just human, so we don't predict the future all that well. What's much more important is structuring a forecast so we can track results—make it match your accounting input—and then following up. Structure it for tracking, then track it, and then, after review, make the management decisions.

The great loss is how many forecasts never produce the second step. No wonder people disrespect forecasting. Without the following up, there's very little value.

Think of a forecast as a route on an electronic map, and the process of comparing actual results with the original forecast as the GPS technology that places your exact location onto that map. The map alone isn't nearly as effective as the combination.

Myth 2: It's for Experts

Again, not really. In the real world, forecasting is a matter of good educated guessing in rows and columns on a spreadsheet. Real people, the ones who run the business, think about what they can realistically expect.

I paid my dues with more than three years as a professional market researcher and more than 20 years in business planning. I've written about sophisticated techniques, including smoothing and weighted moving averages and econometrics, in some books that are old now. Technical analysis isn't what makes forecasting work. Common sense and frequent review make forecasting work.

Myth 3: You Can Manage Without it

Managing a company without sales forecasting—the forecast, the actual results, and the management that follows—is about as smart as driving a car without a steering wheel, or maybe I should say with your windshield covered in black paint.

Of course there are always exceptions, but most of small business right now is dealing with sales less than planned. And planned sales usually drive planned spending. So this is not a good thing.

That's where the management comes in.

Tim Berry is president and founder of Palo Alto Software, founder of bplans.com, and a cofounder of Borland International. He teaches starting a business at the University of Oregon. He has written books and software including Business Plan Pro, published by Palo Alto Software, and The Plan-As-You-Go Business Plan, published by Entrepreneur Press. He has a Stanford M.B.A. degree and degrees with honors from the University of Oregon and the University of Notre Dame. He blogs at Planning Startup Stories and Up and Running.

Tags:
sales,
small business

Reader Comments Read all comments (8)

Add Your Thoughts
Your comment will be posted immediately, unless it is spam or contains profanity. For more information, please see our Comments FAQ.

Tim, I completely agree about the importance of forecasting – and the first comment about flexibility. However, I disagree with Rich that being flexible precludes the need for a good forecast. In fact, being flexible means you have to be better and quicker at forecasting. Why?

Decisions impact the future (not the past) and therefore need to be tightly linked to the forecast. If you wish to be flexible, you need to know the latest forecast in as close to real-time as possible. More specifically: Has the forecast changed? How? And Why? You want your decisions to reflect the latest information from the market so you need to get the forecast from the sales team quickly, easily, and with minimal disruption.

I'm a member of the executive team at a small business, and we do not rely on black box algorithms or ‘what did we sell last quarter?’ as the basis for our forecast. We certainly take that data into account, but in volatile times, the sales reps talking with our current and prospective customers give us the most valuable insight on what's changing and why.

I agree that getting forecasting right isn’t easy (CRM doesn’t do it). Finding a way to get a forecast from sales folks without taking their energy away from selling is difficult – but if you get "bottoms-up" sales forecasting right, it provides tremendous value.

Southard Jones of CA 11:29PM December 04, 2008

"How? Let's say I make a forecast and I use said forecast to make purchase decisions (lets assume 90 day invoices). Now, a lot will be dependent upon the quality of that forecast. If I was making a forecast based upon the previous years sales (say, a retail store gearing up for Christmas) I could be in a world of hurt (like when an economy goes belly up.) However, were I to limit myself to placing orders based upon current cash flow (i.e. the most recent sales figures...maybe just the previous month), you can keep from getting in over your head."

I think this plays into a lot of what Tim is saying. We shouldn't base forecasting specifically off of the previous years sales or off of what someone else is telling us. We should base the forecast off of what we believe to be right in our real world situation, use our knowledge of what is happening now to forecast and then review and revise these forecasts often.

If we just forecast based off of current cash flow with no thought to what happened last year, we can get into trouble as well. This time of year gives us a wonderful example, consider a Toy Store heading into the Holiday Season. I'm sure that all toy stores are feeling the economic pressures today like most businesses but if they only plan purchases for November and December based off of October's Sales and Cash Flow situations they'd find themselves with bare shelves in the height of the holiday season. Of course, if they only planned their purchases based on last years data, that would be bad as well.

I think the goal here is to forecast based off of real world situations and to review and revise those forecasts often. It's better to move forward with a plan than to move forward in the dark and review and revise that plan often rather than just close your eyes and follow the plan or rush forward with no plan and bump into walls.

Sean of OR 3:53PM December 04, 2008

I don't consider myself and expert, but I have done extensive forecasting for both in the corporate world and in a small, start up business.

Most non-finance folks have a pretty good handle on the the P&L (statement of profit and loss) where sales and expenses are projected. Where things get interesting is when you start projecting the balance sheet (assets and liabilities) and ulimately, cash flow.

Many a business has failed because they simply ran out of cash, not because they didn't have a viable concept. A company can show positive net income and run out of cash. This problem can get particularly acute in a rapidly growing business. Cash is rapidly consumed building inventory, hiring additional staff, equipment, customers paying late, etc. Before you know it, all of your cash is gone.

If you want to get outside financing, you will need to show your investors and/or banker projections for all three (P&L, Balance sheet and Cash flow). Without these, you will come off like an amateur, and most lenders will not want to work with you.

If I sound like I am biased, I am because I see the value in planning. No one can predict the future exactly. Knowing how business variables affect cash is critical to long term success.

Pete of CO 11:44PM December 03, 2008

Outside Voices: Small Business

Read commentary about the day-to-day of running a small business from some of the top bloggers in the small business community.

advertisement

advertisement