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

lease accounting journal entriesdirect labor cost variance formulamanufacturing overhead accountingsundry expenses meaningpresent annuity formulaaccounting rate of return methodgross margin and contribution marginmeaning of imprest accountwhat does freight collect meanpre incorporation expensesnormal balance of unearned revenuesimple trial balance exampledebtors ledger exampleformula for fv of annuitycalculate the variable cost per unitpv formula calculatorformula for present value of an annuitygoodwill impairment entrydepreciation and amortization on income statementassets liability equitybookkeeping invoicesundry payablesimple petty cash templatedefinition of accounting equationexample of subsidiary ledgerledger entry examplesrecord unearned revenuelifo method examplehow to treat disposal of fixed assetaccount receivable days formulamarkup price calculatora predetermined overhead rate is used todistinguish between trade discount and cash discountdepreciation of fixed assets journal entryexamples of contra accountsdupont chart analysisaccounting credits and debitsdouble entry prepaymentdepreciation equationformula for annuitiesaccrued expenses journal entry examplethe formula for computing annual straight line depreciation isdilapidation provision ifrsbookkeeping abbreviationaccounting transposition errortimesheets templateaccounting unearned revenueannuity forumlagross profit calculationstemplate voucherroa equationinventory impairment gaapoperating lease vs finance lease accountingdiscount on bonds payable balance sheetnbv accountingbalance sheet deferred revenuehow to calculate factory overheadaccount receivable formulaformula for total contribution marginamortizing bond premiumcash received from customers journal entrymid year convention depreciationturnover accounting formulayear end adjustments journal entriesaccounts payable excel templatevertical statement analysisdiscounted present value exceltie ratiogrowing annuity future valuefinished goods inventory formulaonline apportionment calculatorequation for gross profitfcf calculator