I propose to collate our experience as a company, this time on Sales Pipeline management.
To sustain and grow any business, we must generate revenues in excess of what was generated the previous year.
It works best to follow the famous PDCA cycle (Plan-Do-Check-Act) to achieve sustained growth.
The following are the essentials of business forecasting PDCA cycle.
- Forecast the revenue for the year.
- Identify the practical difficulties in achieving the revenue
- Have a plan (or keep working on a plan) to minimise such difficulties
- Set the revenue target for the year based on the forecast
- Track progress against forecast
- Adjust forecast based on the progress
- Achieve the target, exceed the target or get as close as possible to the target (as the case may be)
First thing first, the exercise of forecasting is an intimidating thought to start with. But one MUST go ahead and do the forecasting. The exercise is worth it for any business.
Sales Management Essentials
Revenue forecasting for a business typically starts around February of every year (if the financial year cycle is from April to March).
We prepare a business forecasting sheet which is nothing but a detailed listing of potential sales for the year.
We collect potential sales for the year with the following attributes
- Region from which the sale is expected
- Name of the potential customer (if this is not known, a virtual name such as BANK1, BANK2 is used)
- Name of the project
- Deal category (product / solution. There can be more categories).
- Approximate deal value
- Weight percentage
- Weighted value
- Quarter in which the sale is expected to happen
- Customer is known or unknown
- Stage of the deal (Projected, Identified, Proposed, Negotiated, Won/Lost,OnHold, Gone Cold)
Accuracy of the forecast data is very essential as all investment and expense decisions for the year solely depends on your forecast. However, getting the pipeline forecast accurate is quite tricky.
To achieve accuracy, we split the forecasting exercise into two phases (1) The initial Sales Forecasting exercise (2) Ongoing Monitoring.
Sales Forecasting
As first step of initial forecasting, individual sales leads are collected from all those who are involved in sales. The lead generators provide the 10 attributes for each lead they bring.
We consolidate these leads in a common location. we use a simple spread sheet based tool for this & this file is currently the bible of our business. Enterprises use lead management tools, but small companies may not be able to afford it. A home grown, excel tool works effectively for small businesses.
Having collected all the leads, we conduct one to one session with the lead generator(s) on each lead item they have brought (or they believe they could bring). This session resembles an interrogation session as the strength of the lead is assessed with no room for emotions.
Here I must share a few points to remember which will define how you decide the strength of each lead item.
- How much information is available with the lead generator on the lead, influences the strength of the lead. Here the word “strength” means whether the lead has a reasonable potential to convert into a sale or not. So let the lead generator talk as much as he can on his own about the particular lead and independently make up your mind on the strength of the lead.
- The distance a lead has to travel before it materialises influences the strength of the lead. If a lead generator says that a deal is 3 quarters away, it usually doesn’t qualify beyond 10% probability. Also, in our experience, a lot of external dependencies affect the time taken for a lead to move from “Identified” stage to “Won” stage. If your sales staff calls a lead as “Identified” and can be won shortly, view this with suspicion.
- Value of the lead needs to be accurate. The accuracy of the value can be achieved only by experience. However while arriving at the value the following needs to be considered.
- Is the lead a first time customer. If so, you need to give the first deal at a low price in order to gain entry into the customer place and achieve repeat business.
- Is the sale a 1st time same. If so, your product pricing itself will fluctuate greatly as there isn’t a market yet and hence the market has not valued such a product before.
- How big or small is the potential customer. A big potential customer has better ability to pay, but also negotiates well as he knows that you need future business. A small customer has a small purse and hence he will expect your pricing to be low or he may not buy.
- Is the region in which the lead exists a green field market or a market with many competitors. The challenges differ between green field market and a well evolved market. Nevertheless challenges do exist.
- If yours is a first time sale, you may have to use some innovative ways of establishing your product such as partnering with your potential customer to enhance your product and also to get reference site. This often means a low price or no price. You must think this through.
- By closely monitoring the budget sheets, we realised that our pessimistic estimates turned out to be reality. This is debatable, but we have decided to pick up the pessimistic value of a lead for our budget estimation and tried to maximise the actual revenue.
- It is better not to add / remove buffer from the estimated value of the lead. Instead, we take the weighted value of all the leads to arrive at the total revenue budget of the year.
- The weighted value of a lead is arrived at by giving the probability of sale (in other word, how confident are we that we will win this deal. While we take inputs from sales team about their comfort on winning the deal, we make up our mind on the strength of a lead by discussing the lead with the “deal closer”. The person who has demonstrated the solution to the customer and the one who negotiated the deal. At the time of forecasting, no “deal closer” is available at least for the deals that are far in the pipeline.
- To tackle this, we follow a gut feel probability to verify and ensure that we are not too off track in our perception. It is as follows.
- “Projected” leads – any probability, provided the lead is more than 6 months away.
- If a lead is “Projected” and is less than 6 months away then the probability is < 10%
- “Identified” leads – <= 10%
- “ Proposed” leads <= 50%
- “Negotiated” leads <= 90%
- “OnHold”<= 30%
- “Unknown” items (where the customer is yet to be identified) may have upto 50% probability provided the lead has 9 months to materialise. Need a lot of debating before agreeing this item.
- We track closure of leads by quarter. So each lead item has a quarter of closure. This helps us identify a pattern of closure by quarter (which can be specific to industry). But it helps us improve our forecasting skills continuously.
- In almost all deals we have done, there is a period between “Proposed” state and “Won” state of the deal. This has been the wait period during which, we as vendor are in a difficult position to influence the speed of the closure. Please note that we could influence the out come, but the time taken is difficult to influence. This has to be factored in while deciding the quarter of closure. Providing a time buffer to accommodate this phase is good especially if this is a new customer for you. For repeat businesses however the closure happens much faster (one more reason why bird in hand is worth two in the bush).
Deliberation of Forecast
Each pipe line item which is gathered from the sales team gets deliberated in detail to meet the criteria mentioned above. We took around half person day per pipe line item.
This provided us with a clean list of pipeline items with their names, potential sales value, weighted value, probability, quarter of realisation etc. There were a few dilemmas though.
It was easy to forecast the first quarter revenue as we knew the potential customers we are talking to, what do they want, how much is their budget etc. The information on revenue potential for quarter 2 and quarter 3 became weaker and less accurate, quarter 4 was a total unknown.
One way to tackle this is, to deliberate the pipeline for quarter 1 and and 2 in as much detail as possible and finalise quarter 1 and 2. Look for similarities between quarter 3 pipeline items and quarter 2 pipeline items and apply same logic from quarter 2 to arrive at quarter 3 budget. Quarter 4 budget can just be taken as quarter 3 budget + 10% to 20%. The idea is, as time passes, we will pick up cases for Q3 and Q4 pipeline items.
Another problem we faced was, some of the pipeline items keep changing their attributes on a daily basis. This gets tricky especially when the value associated with the item is significant. The best way to deal with this during the process is to give the most pessimistic probability, and give the guaranteed value of the project if the deal is won.
The list containing the consolidated pipelines identified and deliberated as above, is the revenue budget for the year and becomes the baseline must win revenue for the year.
It is better to use a nice excel tool which could automatically provide the following, by taking all the attributes of each sales item defined above.
- Target sales by quarter (as per the baseline)
- Change in target sales by quarter as on current date and time
- Baseline Vs Current comparison for each quarter
- Ability to drill down each quarter to know the items within
- Ability to leave snapshot of performance at the end of each month
We have done it in such a way that at the end of each month, the pipeline position at the end of that month is available for future reference. So at the end of the year, we know exactly how we progressed month on month during the year.
Monitoring Progress
This pipeline tool is the single most important utility in our organisation. All sales people and management team closely monitors this tool regularly.
One member of the management team, is responsible to maintain the status of each pipeline item on a daily basis. Thus any movement of each pipeline item (value, probability, quarter, status etc) is immediately updated. Any major shift in any attribute which has the potential to disturb sales performance is reported to the rest of the management team, consequences of the shift are discussed and action taken immediately.
Our management tracks our progress against our baseline every month. Our quarterly performance against the corresponding quarterly baseline targets is as important as our performance of the year. The reason why the quarterly performance is given importance is because, if a pipeline item which was targeted for a quarter slips to the next quarter, the reason for slippage can be identified, and a preventive measure can be put in place to ensure that the quarter 4 items don’t slip to the next year.
The monthly review of the pipeline also helps us identify, which customer pays us quicker, which product has potential to sell and generate revenue quickly etc. Thus we are able to prioritise our customer focus as a byproduct of this exercise.
It also throws up our vulnerabilities such as high exposure to one potential project / customer, seasonal slow downs(E.g. sales in ME during Ramadan is difficult).
Besides, we get to know, the consequence of reduction of price or reduction in project value, on the overall revenue of the year, enabling us to better identify the most competitive price for our customers.
Conclusion
We follow the pipeline management process more seriously this year compared to the previvous year. One important benefit we derive now is that, last year, when the results came out, we believed that we did the best we could. This year, we know what best we could achieve and we are now working to better that best.
We are just beginning to learn pipeline management. But the learning so far has definitely helped us.
Please share your critical comments with us and help us improve.
