Sales Forecasting using Weighted Averages 2


Profitability

For project based businesses you need to understand the sales pipeline inorder to produce a forecast, a typical sales pipeline looks like this:

  1. Prospects and Leads
  2. Qualified Opportunities
  3. Visits/Meetings
  4. Proposals
  5. Revised Proposals
  6. Sales

In many cases larger contracts require a Prequalification Questionnaire (PQQ) and Tender.

If you want to forecast Sales you have to start by recording the volume of activity at each stage of the pipeline and your success rate at each stage.

Sales is all about activity, the more Prospects you can find the more Sales will be achieved.

Finding propects will be different for every organisation but Social Media and Linked In are increasing being used to find Prospects.

To prepare a Weighted Average forecast you simply use you success ratios and apply them to each stage of the process, so for example if you win 1 in 3 proposals that means you need 3 proposals to get one sale.

You can use this approach to set targets for your sales team.

On submitted proposals you can also apply a probability of success assessed by your sales team.

The key to Sales is to Always Be Closing!

steve@bicknells.net

2 comments

  1. Good to see you last night Steve. Apologies I was involved when you saw me. I looked for you half an hour later but couldn’t see you anywhere.

    Sent from my HTC

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s