Although he later qualified much of what he said with the statement, “I really never said everything I said”, Yogi Berra is also well known for his famous phrase, “Prediction is very hard, especially about the future”. In an attempt to make Yogi’s dilemma slightly more manageable, three of my SAS colleagues, Lou Galway, David Pope and Robert Szczerba, are being awarded a patent on a process for “Computer-Implemented Systems and Methods for Determining Future Profitability”. I recently sat down with the team to better understand what they are trying to accomplish with this new process, and more importantly, what are the business benefits to be gained from implementing their suggested approach.
In a nutshell, what their process is about is extending the activity-based management approach of determining past profitability at the granular level of the customer or product, into the future, through forecasting techniques at this same, granular level. The value of knowing which of your products or customers are the most and the least profitable, and then taking appropriate action based on segmentation and target marketing, can be readily extended into future-focused actions based on data-driven forecasts. It’s still all about making better decisions, just that now the domain of your decision making time frame has been considerably expanded beyond just the present day.
Briefly, the idea is that just as you can utilize a set of independent variables to forecast most anything: costs, revenues, volumes, you can also utilize an appropriate collection of independent variables to forecast profitability at the very lowest levels. By combining the capabilities of SAS Forecast Server with SAS Profitability Management, what you can get is a forward-looking, pro-forma P&L statement for each of your customers. This is driver-based forecasting not just at the summary general ledger account level, but by customer. It is based on data you likely already possess within the organization, data that until now hasn’t been effectively turned into business intelligence.
This is truly one of those cases where the wizard-driven, automated forecasting capabilities of SAS Forecast Server can immediately be put to effective use, that 80% of the time where the analytical application can automatically create a valid forecast (10% of the time the situation is complex enough to require professional statisticians, and 10% of the time the data is completely random and cannot generate a valid forecast at all). If your financial analysts have had even just one statistics course, and all they can remember is the difference between a dependent and an independent variable, you are in business – the wizard-driven software can do the rest.
The real key to creating business value from such a process comes from integrating your customer demographic and attribute data with your financial data, incorporating the information contained in your CRM, loyalty and marketing management systems with financial cost and revenue data. A couple of examples would be beneficial at this point. For each example below, let’s assume that prior history indicates, by eyeball, on average, simply a flat “trend” line of past purchase behavior.
- Adding demographic data, such as age, might lead to, say, an upward trending forecast for younger customers and a lower trend for those somewhat older (or visa-versa).
- Adding attributes, such as the date they joined your frequent buyer’s club, might indicate a future upward trend with a three-month time lag.
- A purchase history of three or more products from different categories, or one product plus related services, might indicate an upward trend in profitability compared with other buying patterns.
- Use of coupons, only buying during certain sales events, or only buying after receiving certain target marketing offers could be matched with the planning of such future marketing events to better forecast volumes and production capacity.
- Perhaps the data shows a switch in buying behavior over time from low-end, low-margin products to higher-end offerings that might portend improved future profitability that is not visible just in the revenue data by itself.
- An industry attribute, combined with external market or forecast data, might indicate that going forward, customers of the same size and prior buying history may be headed in opposite directions based on their industry affiliation.
There is value in this sort of a granular forecast for both B2B and B2C businesses. In the B2C world, all of the targeted marketing approaches I listed above, combined with some segmentation and up-sell/cross-sell promotions gets you on the right road to be actively managing that elusive concept of customer lifetime value. In the B2B world, imagine if you could use such a process to set quotas and establish territories, by whatever criteria you run your business (i.e. geographic, industry, hunter/farmer, direct/indirect, etc …). Not only can you eliminate arbitrary, one-size-fits-all sales quotas that consistently are points of contention, the software also automatically identifies those outliers, those once-in-a-lifetime $10 million dollar deals that need to be factored into the setting of a proper sales target.
And if that wasn’t enough, there is a next step – optimization and “what-if” scenario analysis. Why? Because you still have constraints, constraints in resources or time or investment, that need to be included in your customer-level planning activities such that it is your most profitable customers and products that get priority.
It was just two weeks ago in my “Finance in more than two dimensions” post that I noted the long-term goal of FP&A to better position itself to engage in more value-add activities tied to business and decision support. While there are many paths one could take on that journey, forecasting profitability at the customer level in support of marketing and account management activities is certainly one path you could readily take using just the data you already have on hand. No, the future isn’t what it used to be, it’s gotten a whole lot better.




This is the disconnect represented by the division between the middle, financial/ functional section and the bottom, operational layer of this Integrated Business Planning (IBP) diagram - between the financial and operational plans. There are two primary approaches to solving this problem: 1) integrated enterprise-class systems, and, 2) integrated operational planning and supplemental schedules.






