By Keiter CPAs
Challenge and Opportunity
A company was seeking a way to better allocate performance bonuses to its employees that considered areas of high and low volume, percentage of increased sales, and location profitability.
- The customer had an outdated structure for measuring sales and performance data of its employees. They struggled to balance overall region volume with improvements the sales force had made in historically lower volume or less profitable regions.
- Using Microsoft Power BI, we were able to clean up and integrate information for all of the customer’s employees into one central database.
- The database provided the customer with essential information about each employee such as volume of sales made, customer acquisition, etc.
The new database provided the customer with the information needed to create a more equitable and performance-based bonus structure.
About the Author
The information contained within this article is provided for informational purposes only and is current as of the date published. Online readers are advised not to act upon this information without seeking the service of a professional accountant, as this article is not a substitute for obtaining accounting, tax, or financial advice from a professional accountant.