|
|
Like this article? PLEASE +1 it! |
|
Smooth Sailing or Storms Ahead ? How to use the Sales Pipeline to predict your future
|
| Guest post by: Karen Andrews |
Article Overview: A sales pipeline is simply a forecast that you or your salespeople prepare monthly which lists the customers that are likely to buy in a given time frame, the value of the sale and when it is likely to close. It is an essential tool for business owners and sales managers to identify where you are and where you need to be in order to meet budget.
![]() |
Free Download - Are you boring prospects with your questions? By Karen Andrews |
Smooth Sailing or Storms Ahead ? How to use the Sales Pipeline to predict your future
A sales pipeline is simply a forecast that you or your salespeople prepare monthly which lists the customers that are likely to buy in a given time frame, the value of the sale and when it is likely to close. It is an essential tool for business owners and sales managers to identify where you are and where you need to be in order to meet budget.
Even if the forecast is well below where you need it to be, at least you are aware of it and can take steps to improve it and stay on track. Don't wait until the 2nd or 3rd week of the month when you realise that sales are slow to come in and you need more because it's usually too late.
Typically, I usually ask for a forecast at the beginning of the month and then again on the 15th of the month to see how we are tracking.
The important thing to remember is to use a 'weighting'. You may $500,000 in your pipeline but it's very unlikely that you will be successful in winning 100% of them so the forecast will be inaccurate. A weighting is simply a % that you apply terms of the likelihood of winning the sale. Here is an example of how to calculate:
Monthly Target $100,000
Value of Sale Est. Close Date Probability of Success Weighted Total
Customer 1 $15,000 15-May 20% $3,000
Customer 2 $12,000 6-May 40% $4,800
Customer 3 $10,000 20-May 60% $6,000
Customer 4 $25,000 30-May 80% $20,000
Customer 5 $20,000 8-May 20% $4,000
Customer 6 $35,000 8-May 40% $14,000
Customer 7 $5,000 30-May 60% $3,000
Customer 8 $8,000 12-May 80% $6,400
Customer 9 $15,000 30-May 20% $3,000
Customer 10 $5,000 1 6-May 40% $2,000
Total $150,000 $66,200
Monthly Target $100,000
Shortfall/Excess -$33,800
Using this example, the salesperson needs to add more sales into their pipeline to ensure they reach their sales target of $100,000.
As a guide to the Probability you could use
Initial Communication - 10%
First Meeting/Presentation - 20%
Proposal Given - 60%
Negotiation/Verbal Commitment - 80%
Closed - 100%
Most CRM/Database packages (I use ACT or Salesforce.com) include Sales Pipeline management but it can be as simply as listing them on an Excel spreadsheet.
|
About the Author: Karen Andrews RSS for Karen's articles - Visit Karen's website This sales article was written by Karen Andrews, Director of Shine Sales Solutions, a Sydney based Sales Coach, Strategist and Sales expert that works with businesses to increase their sales through strategy development, sales coaching and mentoring. Specialising in sales strategy, business development, sales effectiveness and sales training Karen is committed to making the changes that will inspire, motivate and help you realise your sales goals and potential. Get more free sales tips, articles and sales guides at www.shinesales.com.au Click here to visit Karen's website The simple truth to increasing sales follow up follow up follow up Selling in the lead up to Christmas Build your Sales Pipeline and Boost Your Prospect Numbers Top 20 Interview Questions for Salespeople How to increase sales by upselling |
Related Forum Posts
Share this article with your friends. Fund someone's dream.
Leave a comment below or share on the left and you'll help support entrepreneurs in Africa through our partnership with Kiva. Over $50,000 raised and counting - Please keep sharing! Learn more.
Get advice & tips from famous business
owners, new articles by entrepreneur
experts, my latest website updates, &
special sneak peaks at what's to come!
Ten Reasons to take Notes during Sales Meetings
What Is The Foundation for Your Vision?
Word of Mouth Marketing Tips Fuel Success
Email us your ideas on how to make our
website more valuable! Thank you Sharon
from Toronto Salsa Lessons / Classes for
your suggestions to make the newsletter
look like the website and profile younger
entrepreneurs like Jennifer Lopez.



