Setting up business intelligence architectures is our passion!
Predicting sales on the basis of various factors like price, advertising spends (TV, print, radio), sponsorship spends etc. is one of the specialties at Tetrahedron. It is an iterative process, and once we are within the 90% confidence level mapping the predicted sales vs actual sales, then starts the art of optimizing the spends, thus saving millions of dollars in spends.
There is the corporate regional spend, and the corporate local spend per market. Within the local spend per market; there is also the dealer kitty. Then there is the dealer spend on outdoor, cinema, newspaper, magazine and TV – which is different than the manufacturer spend on magazine! All this is part of the marketing mix, and different than the sales promotions and PR budget!
The objective of all this is to increase retail sales. So if we start with the end in mind – take the retail sales volume per month, and try to isolate the impact of each marketing mix variable, we should end up with the ones that are making the most impact. It is an iterative process, and/which broadly follows the logic that:
The modelling is run through multiple regression or the Markov process. Sometimes, we also use quadratic optimization, based on the Markowitz model.