3 Sales Forecasting Methods

Sales Forecasting by More Than One Method Is Most Accurate

Businessman pointing to flipchart
••• Image (c) Robert Daly / Getty Images

is especially difficult when you don't have any previous sales history to guide you, as is the case when you're working on as part of . Here, Terry Elliott provides a detailed explanation of how to do forecasting using three common sales forecasting methods. 

Note that there are all sorts of ways to estimate sales revenues for the purposes of sales forecasting, but if you plan to  or are looking for for your business, you will want to do multiple estimates so you (and they) will have more confidence in the forecast.

 

How to Forecast Sales

Method #1

For your type of business, what is the for similar stores in similar locations and similar size? This isn't the final answer for adequate sales forecasting, since a won't hit that target for perhaps a year. But this approach is far more scientific than a general two percent figure based on household incomes.

Method #2

For your specific location, how many households needing your goods live within say, one mile? How much will they spend on these items annually, and what percentage of their spending will you get, compared to ? Do the same for within five miles (with lower sales forecast figures). (Use distances that make sense for your location.) For example:

Acme Corp Sales Forecast
Distance#HouseholdsAnnual Spending% of SpendingForecast Sales
1 Mile20$5,0005% ($250)$5,000
5 Miles500$5,0002% ($100)$50,000

Method #3

If your business offers, for instance, three types of goods plus two types of extra cost , estimate sales revenues for each of the five product/service lines. Make an estimate of where you think you'll be in six months (such as "we should be selling five of these items a day, plus three of these, plus two of these") and calculate the gross sales per day.

Then multiply by 30 for the month.

Now scale proportionately from month one to month six; that is, build up from no sales (or few sales) to your six month sales level. For example: 

Bubbles Corp Sales Forecast - Month 1
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$15005$7,500
Hot Tub 2$25002$5,000
Hot Tub 3$30002$6,000
Service$20010$3,000
Installation$8005$4,000
  Total$25,500
Bubbles Corp Sales Forecast - Month 2
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$15008$12,000
Hot Tub 2$25004$10,000
Hot Tub 3$30004$12,000
Service$20015$3,000
Installation$8008$6,400
  Total$43,400
Bubbles Corp Sales Forecast - Month 3
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$150010$15,000
Hot Tub 2$25005$12,500
Hot Tub 3$30005$15,000
Service$20020$4,000
Installation$80010$8,000
  Total$54,500
Bubbles Corp Sales Forecast - Month 4
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$150013$19,500
Hot Tub 2$25007$17,500
Hot Tub 3$30007$21,000
Service$20025$5,000
Installation$80012$9,600
  Total$72,600
Bubbles Corp Sales Forecast - Month 5
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$150018$27,000
Hot Tub 2$25008$20,000
Hot Tub 3$30008$24,000
Service$20030$6,000
Installation$80015$12,000
  Total$89,000
Bubbles Corp Sales Forecast - Month 6
ItemUnit PriceMonthly SalesMonthly Revenue
Hot Tub 1$150020$30,000
Hot Tub 2$250010$25,000
Hot Tub 3$300010$30,000
Service$20040$8,000
Installation$80020$16,000
  Total$109,000

Now carry it out from months six through 12 for a complete annual forecast.

Don't Just Do One Sales Forecast

Instead of forecasting annual sales as a single figure, use one or two of the sales forecasting methods above and generate three figures: pessimistic, optimistic, and realistic. Then put the figures in by month, as depending on your business, there could be huge variations by month. (Some retail firms do 50 percent of their gross sales around , from the end of October to the end of December, for instance, yet barely get by June through August.)

Include Expenses

Now put in your by month, including big purchases by season (or however you buy materials/goods).

Remember, you may buy materials or in say, July, for Christmas, yet not get all of your receipts until 45 days after Christmas. There can be big implications. Also, will you be buying vehicles? Capital equipment? Make sure to show depreciation expense.

In your expenses, put in an allowance for . Figure how much of your sales are by cash, how much by credit card, how much by your extending credit. Deduct say four percent or more for credit card expense for that portion sold by credit card.

, be able to answer questions such as, have you made an allowance for a reserve cash account, for your slow months, but also in case you have to quickly replace a vehicle or equipment? You say you'll charge x dollars for your product, but what happens when your competition cuts the price by 33 percent and still makes a profit?

How will you specifically - , selling existing products to new customers, selling to existing customers and selling new products in order to attract new customers? Any potential lenders are going to want to see if you've got a real plan.

Remember that it is acceptable (and realistic) to have a negative cash flow projection for the early months of your .

Good Decisions Depend on Good Information

You can see that instead of estimating one big sales figure for the year when sales forecasting, a more realistic monthly schedule of income and gives you far far more information on which to base decisions. That's what "" is designed to do: give you information you can make good decisions on.

So in effect, you need to prepare three cash flow projections, where you vary the percentage of sales or other figures to arrive at three different scenarios: pessimistic, optimistic, and realistic. The pessimistic view should be the "worst case" situation; plan to have enough capital and patience to get through that scenario. If it turns out that the actual results are better than that - great!

Accounting Software Can Help

Accounting software can be a great help in creating sales forecasts, cash flow projections, and keeping track of your expenses. See  and .

See also: