How to Prepare a Sales Forecast
Sales forecasting of your product or service is the starting point and the key to preparing financial projections, so it is important to use a realistic estimate.
Most businesses have different types of sales e.g. product lines, departments, customer groups etc. so you’ll eventually need a sales forecast for each main type. I would suggest no more than seven types and perhaps a final one for sundry sales.
Methods of Producing a Sales Forecast
There are numerous methods of producing a sales forecast to get an estimate depending on the stage of your business and the type of business you’re in, here’s a few to be going on with.
- If you have historical annual sales information for your business use that as your starting point for the sales forecast. If you have a number of years then average them, but try and take into account unusual fluctuations e.g. particularly bad weather, economic climate, new products coming on line etc.
- Use information from companies in the same or similar type of business, trade associations, company accounts of similar businesses to give you an idea of the level of sales for your industry and location.
- Use market data and statistics, if you’re in retailing for example its usually possible to get an idea of the typical sales volume per square foot of space for shops in similar locations and sizes. This sales volume multiplied by your average price should give you a sales forecast.
- Use national government demographic data and average spend data to estimate the total market for the product in your area and then calculate your market share by dividing this estimate by the number of competitors plus one in your area. You’ll need to use your own judgment and adjust this figure (probably downwards, for the first year)
- If your in a business with a fixed capacity use a bottom up method by calculating your available capacity (e.g. in a restaurant use the available seating and multiply this by the average meal price), and then estimate a likely usage, say 50% to give a sales forecast for the year.
Avoid wishful thinking, (take 20-30% off the sales forecast figure you first thought of), avoid too much detail in analysing the types of sale you have, and make sure the sales are within your businesses capacity, for example if your manufacturing widgets with a given capacity, there’s no point in sales forecast well above this unless you have plans to expand.