Bonus Calculation using Eligible Elements (Earnings)

Summary

We are looking for a way to capture eligible elements (earnings) for two or more jobs in a specific time period

Content

Hello,

Our bonus calculations use eligible elements (earnings).  For example, an employee works 6 months out of the year in a job with a 10% bonus target and is promoted to a new job mid-year that has a 15% bonus target.  We need to capture the combined eligible earnings for the time the employee was in both jobs.

Assumption:  100% company performance and the employee was making $50,000 the first half of the year, then increased to $60,000 after the promotion in the second half of the year.