Spar InfoTech, Inc.
Mathematical Model Comparison
Selecting the model to calculate a baseline, forecast or, analysis of Trade Promotions is the most critical decision. Once a model is selected data will be collected, databases built, reports designed, and people assigned to the project. There are endless models but they fall into three types. Even a unique model will have the traits of one of these three. Here is an explanation of the three, how they should be used, and their strengths and weaknesses.
Exponential Smoothing is the easiest to build, use ,and implement. It uses an average of historical data but weights recent data more heavily. For example if the last 5 periods have values of 1,2,3,4 and 5, a straight average would be 3. But if the first four periods were weighted as zero and the last one 100% the weighted average would be 5. There are variations of smoothing such as double and triple exponential smoothing that allow for a more robust analysis to help consider such factors as trends.
Advantages of Exponential Smoothing:
Disadvantages of Exponential Smoothing:
A Univariate analysis considers the variables one by one in an order selected by the user. It is easy to explain and the math is straightforward. It quantifies some measures such as seasonality and trend. A common approach is to calculate seasonality by adding together all the same periods for a number of years (e.g. all the January’s, all the February’s) and de-seasonalize the data. The de-seasoned data is then analyzed to determine the impact of marketing factors such as trade promotion with the difference between the de-seasonalized sales in promoted periods compared against the sales in non-promoted periods.
Advantages of Univariate Analysis:
Disadvantages of Univariate Analysis:
A multi-variate analysis calculates all the variables simultaneously. This is the most accurate method to do an analysis of Trade Promotions since the order of the variables does not impact the answer. A well-known multi-variate analysis is multiple regression where all the variables are calculated simultaneously. Since all variables are calculated simultaneously new variables can be added or old variables dropped if they are not having an impact. This type of model will allow for the calculation of the impact of different conditions such as Trade Promotions, Price Increases, Seasonality, and Trend. Because of the work involved to have a multi-variate analysis, the payoff for a more accurate analysis must justify the extra cost.
Advantages of Multi-variate models:
Disadvantage of Multi-variate analysis:
Conclusion: There are many factors that impact the type of model to be used. Choosing the wrong model will result in failure since it will be unworkable or the results too inaccurate. A manufacturer of thousands of SKU’s where demand doesn’t vary can use an exponential smoothing model since it is easily developed and the inaccuracy can be offset by added safety stock. A good example is forecasting 1000’s of SKU’s for a manufacturer of nuts, bolts and screws. Forecasting is quick and items can be easily added even with one period of sales. Errors can be dealt with by increasing the safety stock and the cost of a mistake is minor. Univariate models are best when seasonality is a factor and tens of thousands of items are processed routinely so that the model must run under set logic without creating any need for user input. Companies processing tens of thousands of scanner-level SKU’s such as A.C. Nielsen and IRI will run a Univariate Model. The multivariate analysis is most useful when the value of accurate information is high. Since the skill to handle this type of model is high, it is only used by some Government Departments or large companies that spend hundreds of millions on Trade Promotions as the value of accurate answers more than compensates for the cost of the analysis and the maintenance of the database.