IDS Case Study: Create a Model to Allocate Performance Bonuses

By Keiter CPAs

IDS Case Study: Create a Model to Allocate Performance Bonuses

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.


View All IDS Case Studies >


Learn More about our Innovative Data Solutions Services


Share this Insight:

About the Author

Keiter CPAs

Keiter CPAs

Keiter CPAs is a certified public accounting firm serving the audittax, accounting and consulting needs of businesses and their owners located in Richmond and across Virginia. We focus on serving emerging growth businesses and companies in the financial servicesconstructionreal estatemanufacturingretail & distribution industries and nonprofits. We also provide business valuations and forensic accounting servicesfamily office services, and inbound international services.

More Insights from Keiter CPAs

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.


Contact Us