Hi, I am looking to design a profit sharing scheme that would take into account the job level of the employee, the performance of the geographic region, and the individual performance level. The first can be a number between 1 and 7 or a dollar amount, the second will be the achievement of projected profit, and the third will be a number between 1 and 5. Is there anyway to calculate a final contribution without making it the percentage of a cap? The total pool for each geographic regional will be a straight percentage of profits.
i.e. 15% of profits might be 10 million for ease of calculation. For thirty employees, is there some formula that will reward each employee a portion of that 10 million based on their job level, achievement of projected profit, and ind. performance???