Subscribe to DSC Newsletter

You may wonder how those mighty people do the fancy projection in their business plan, there are broadly three methods of forecast and it is suitable in different situations: 1. Bottom up: 2. Top down guestimate, and 3. Top down forecast.

1. Bottom up
As its name suggest, forecast is down on name by name basis by the sales person, it is more often to have bottom-up forcast when the client numbers are smaller but High value Eg investment banking often uses this approach in its sales forcast. However it will be highly subject to the gaming of the provider- they would put a lower number in the estimate and you find no basis to challenge it as there is only one person who knows the truth. One famous bottom-up indicator is purchasing management indicator.

2. Top down guesstimate
By the gut feeling of an authority or simply done by screaming. Someone with the authority from the organization apply some random growth rate as the objective, then the rest of the people work backward for the solutions. I have done similar exercises like this before, the challenges are to allocate back how much are needed from each of the constitute. Sometimes goal seeking are needed to guess back the combination needed.

3. Top down forecast
By linking the management data and relevant leading indicators, we can build the model that describes the causation of the factors ( could be economic indicators) vs the internal management data (could be sales volume of products). How to pick the relevant factors for forecasting? For example, if you want to forecast the GDP of a country, you can start by looking at the major industries within the economy. The method of decomposition by finding the relevant indicators are a useful rule of thumb. Ok then you get the model, the next problem comes: How to translate it into common languages where the CEO, CMO understand? The challenges are 1. you do not know how to explain the coefficient and 2. the model structure can be unstable in the turmoil.

Problem one is the biggest challenge I had in my early career. This damper the ability to use model for forecast. My lesson learnt are: 1. You have to meet the right boss to use model; 2. You have to ride on the right wave (following the management's strategic direction when applying the model, not to stick to what the model can do). 3. Study hard: You need to spend a huge amount of time to understand the model and explain in details and steps by steps how it works. 4. Create confidence by modeling your company's common wisdom into model. e.g. if most people usually think that there should be cross selling between two products, model it using predictive modeling and prove it.

To exemplify the instability of model, one typical example is that the GDP of china vs government spending. Being the major component of GDP, using government spending to estimate GDP means you assume that government spending will always be used as the main tool to expand/ sustain the economy- keeping GDP growing. It is true during the financial tsunami and lasts for only a two to three years. The point here is that once you start using the model, there should be routine to validate it on a regular basis.

Should there be the forth method? Random numbers generation- forecast may have not use to some people.

Views: 269

Comment

You need to be a member of AnalyticBridge to add comments!

Join AnalyticBridge

On Data Science Central

Follow Us

© 2018   AnalyticBridge.com is a subsidiary and dedicated channel of Data Science Central LLC   Powered by

Badges  |  Report an Issue  |  Privacy Policy  |  Terms of Service