Hi All,
I am trying to come up with a formula for a bonus plan. Here are the details:
The bonus is capped, for instance, at $100,000.
There are revenue tiers, $1m - $15m at $1m increments.
The formula should take into account that we would like the higher revenue numbers to produce more bonus - but not use any arbitrary numbers, strictly based on the formula.
And should be easy to manipulate if you want to change the bonus cap, or the revenue scale.
I'm not sure something like this even exists, but any help would be much appreciated!
Thank you.
Peter
Bookmarks