Sales Forecast

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. 

  1. 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.
  2. 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.
  3. 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.
  4. 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)
  5. 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.

Sales Forecast November 6th, 2016Team

You May Also Like

Related pages

depreciation charges on fixed assetsaccrued interest exampledeferred rent definitionworking capital to sales ratio formulainventory reserve journal entrycommon size analysis income statementdefinition of retained profit5 year cash flow projection templateincome statement unearned revenueexample of an accelerated depreciation methodstatement of comprehensive income templatecalculate contribution margin percentagejournal entry for salary paid to employeesprofitability indexroce ratio formulacapital lease vs operating lease gaapaccounting debits and creditsmarkup sheetpv of perpetuitydeclare dividends journal entrytrade creditor definitionpresent value annuity factoramortisedhow to find doubling timereturn on capital employed rocedefine prepayment in accountingpayroll suspense accountbookkeeping spreadsheet template exceldebits and credits testdiscount margin calculation excelsold inventory for cash journal entryexamples of debits and creditsrate of return calculator excelrumus receivable turnoverhow to calculate annual depreciation expenselayout of cash flow statementexpenses template small businessperpetuity growth model formulaprepayment in balance sheetsupplies expense formulaestimating allowance for doubtful accountsrumus receivable turnoveraccounts receivable credit or debit balanceaccruals and deferred income balance sheetexcel depreciationwhat is dso in accountingdeclare cash dividend journal entryfuture value of annuity chartbalance sheet ratios formulascapital contribution journal entrydebtors turnover ratio formulawhat fob means in freightfuture value interest factor annuityaccrual versus cashnsf accounting definitioncommon size income statement excelbookkeeping exercisesrevaluation loss journal entryamortized depreciationdirect labour efficiency variance formulacalculating total variable costwhat is unadjusted trial balancepresent value of future lump sumwhere does accrued interest go on the balance sheetoutstanding cheques definitionwarranty expense on income statementconsumable suppliesdays sales in receivables calculatorraw materials inventory definitioncommon size balance sheetspresent value interest factor annuity tablestock turnover days formulastockholder equity calculatorasset turnover ratiosgross margin vs markup calculatorstable monetary unit principleunearned revenues areworking capital spreadsheet