We developed a solution in the form of an Anaplan model that could compute various types of rebates and enhance the company’s audit processes. The main advantage of our solution is that it completely automates the calculations of rebates dependent on achieved quantity or price thresholds. This model created significant flexibility when creating various rebate types and new contracts. The model’s straightforward user interface provides an effortless overview of data and makes its use easy and intuitive. Additionally, all data is stored in one place, creating a single source of truth and increasing transparency and traceability, which in turn enhances the audit processes.
Ultimately, our solution helped our client save a ton of time by automating the calculation process. This new model saves a staggering 900 person-hours every year in rebate calculations. Not only does it save time, but it also saves human effort and virtually eliminates the possibility of calculation mistakes. Additionally, calculations can be done on a more detailed level. Previously calculations were done on the product family level, and now they can go all the way to the lowest product level. Transparency and traceability are significantly increased by providing an enhanced audit process. And to top it all off, users have to opportunity for data adjustment and validation. All this allows management and finance teams to stay on top of repayment terms and to provide a better position for negotiating rebate terms.