In order to solve our client’s troubles, we developed a solution in the form of an Anaplan model that allowed sales and business unit directors to create targets for their salesforce. The model we developed was not only a target distribution solution, but it also included persona-based customization, presenting different information based on user, department, and region. It utilized the full power of Anaplan and connected planning, being able to immediately reflect changes within the model, thus resulting in a complete department-wide data sync.
First, we implemented the data from all the sheets they had and visualized it nice and clean. Then, we created a hierarchical functionality, and in that way, if a person is not working on a specific project anymore, he can be deleted with one click, and his targets can easily be reallocated.
Additionally, we were able to link several other models that feed information in real-time and make target calculations more accurate. With this integration, the other models were used as a baseline for the targets, and that way, the data was accurate and up to date, and the targets were always optimal.
We went even further to develop a feature that allowed adjustments on units or sales. So, if a person edits a specific value on the report and saves it, the model automatically recalculated it and sent it to the next person in the hierarchy who can validate it. That way, the change was automatically reflected on the account level, and the whole process was visible to both the business directors and the employees.
Last but not least, we developed a validation process that confirmed whether the targets for all employees were accurate or in need of change and if all was well, the whole target distribution got finalized.
The model that we developed managed to save our client a lot of time since it eliminated the need for back-and-forth data distribution and calculation. Furthermore, it helped reduce the number of errors within the data, thus ensuring more reliable data. The company shared with us that they had never had so much information and control over their sales targets and units. We even introduced full transparency of any and all changes in the reports, and with our model, every person – from higher management to sales directors and salespeople – had access to the full information. Since we developed the Sales Quota Distribution Model, salespeople get adequate targets calculated by sophisticated formulas and thus are more motivated to fulfill them, and the whole sales process is way better.