Don't Explain Yesterday. Predict Tomorrow!
These days no one cares about the past because the present and the future is coming at you so fast and with so much change that dwelling on the past and making decisions based on historical insights can lead to disaster. All companies need to relate to this when they make decisions and when most want to make data-based decisions it means that the data provided to management also needs to look forward. Typically companies have been driven by various KPIs depending on industry and the current state of the company. KPIs that tended to be backwards looking rather than forward looking. Companies, therefore, need to transform their analytics to be looking at Key Leading Indicators (KLIs) instead. Finance especially, having established itself as an analytical powerhouse, needs to be aboard with this paradigm change. Let’s then take a look at exactly what should be done.
Don’t record – predict
Finance functions need to be able to predict the future at least to a certain degree of certainty. While everyone knows that classic 5-year plans probably won’t turn out the way they were designed then it wouldn’t be too much to ask for instance to forecast how many goods or services are expected to be sold in the next 1-3 months. If you are a business that employs sales people that make sales calls you should be able to predict your sales by following a certain formula.
Number of sales people X number of sales calls X average addition to pipeline per sales call X win ratio
Above might be a simplified formula, however, it does well to illustrate what you need to do. At any given time you will know how many sales people you have. You will also know how many sales calls you expect your sales force to make in the next 1-3 months either because of historical trends or because you’ve set targets for your sales force. You can also determine from historical data how much you add to your sales pipeline each time a sales rep performs a sales call. Then all you need to do is add your historical win ratio and you’re done. All four drivers will be changing constantly as you add more data to the pipeline and older data becomes obsolete. Variable costs typically follow your sales so they can be auto-predicted from your top-line and the rest (fixed costs, SG&A, deprecation etc.) you would know with a great degree of certainty. You can, of course, also go more granular on the cost side as some can be auto-predicted whereas others are driven by behaviors. Then you can track the KLIs related to your employee’s behavior etc.