Worst, Likely and Best figures should be used when looking at your sales forecasts, helping to determine which sales are most likely to be closed by the estimated close date.
The Sales Pipeline (This Month) Report shows these three figures at the top of the Report as summaries.
Worst Value Total
The worst value total is calculated by totalling the value for all Opportunities that are a status of sold/won. Therefore, the worst value total represents the actual sales so far this month. This total will increase as users mark more Opportunities as sold throughout the month.
Likely Value Total
The likely value total is calculated by totalling the value for all Opportunities that have a guttometer of 50% or over and by working out it's weighted value. For example, an Opportunity with an estimated value of £100 and has a guttometer of 50%, would have a likely value total of £50. Furthermore, if an Opportunity had an estimated value of £100 but had a guttometer of 25%, then it would have a likely value total of £0. Therefore, the likely figure will not count any Opportunities that are below 50% as they will not likely come in this month. If a user was to increase the guttometer later in the month, then this will then be represented in the likely value total.
Best Value Total
The best value total is calculated by totalling the weighted value for all Opportunities using the guttometer. For example, an Opportunity with an estimated value of £100 and a guttometer of 50%, would have a best value total of £50. Furthermore, if an Opportunity had an estimated value of £100 and a guttometer of 25% then the best value would be £25. As a result, the best value total represents the total that could be achieved within this month, if all Opportunities were sold at their current guttometer percentage.