The client offered 10000+ SKUs to 30,000 major eye care groups in the US through 1000+ price lists. However, given the complexity of data acquisition across a number of systems and the analytical processing needed, it was difficult to track pricing performance at an individual customer level.
Core Compete created a pricing data lake and delivered Self-Service pricing analytics dashboards and tools to help the Pricing Team gain visibility into customer pocket margin leakage and to help them simulate pricing impact on the revenue-mix. Furthermore, the solution enables the pricing team to provide account teams with an up-to-date view of the individual customer level sales mix and profitability along with sales guidance for achieving the target performance capture.
A data lake was created for pricing by consolidating existing data from 6 different sources including Sales, Financial Systems, Planning and an existing Data Warehouse. The source data was available in varying formats including some data that was only available in spreadsheets.
Self-Service analytics dashboards with Price-Elasticity Models were developed to analyze customer pocket margin leakage, revenue-mix impacts, and price-list comparisons. Cross price-elasticity models were developed to estimate volume impact of price changes on the overall portfolio.
The technologies used were SAS Office Analytics, SAS Visual Analytics, and SAS add-on for Microsoft Office/Excel. Pre-formatted PowerPoint reports are generated that are automatically sent to sales executives that work as selling tools.
Over $20 million in pricing benefits through effective discounting and streamlining of the annual rate increase program. The pricing team has been able to utilize the pricing data lake and analytical platform to significantly improve price execution and also support the sales team in key account price negotiations.