New Decisioning Insights Increase
Solution
We built a Microsoft SQL based Sales Promotion costing engine that could ingest all of their product, sales forecast and other relevant data. This engine allowed their promotions management team to dynamically construct and cost sales promotions on a state basis for any combination of products (state limitation only created because this was the finest granularity of BRP’s forecast data). The system can accommodate multiple approved promotion contexts for ongoing comparison as well as up to 1000 concurrent promotion prototypes in a sandpit environment. The power of the promotion configuration tool is such that up to 55million data elements can be associated with a single promotion prototype. The system calculates using data for each model to which a promotion applies.
The process of costing promotions was reduced from two days to approximately ten minutes. Very complex promotions could be modelled based on any combination of products, states, time periods and take-up rates. Because of the granularity provided by the system, promotion funding allocation was greatly improved