Hi!
After taking a few weeks break, I've been trying for a several hours to build an Excel Spreadsheet for a Tiered Bonus System... but now, it needs to be done.
I figured out how to do a "simple" Tiered Bonus System following the advice that I found on the web and or the forum here but where it gets complicated is the way I want to do my commission structure.
(The following are fictitious salaries used for example purposes)
I want to build an Excel Spreadsheet where the Tiered Bonus System is Variable with the Salary earned.
So if the guy that earns a salary of $50,000 makes $100,000 in sales, I want him to get remunerated the same way as the guy who earns $100,000 in salary or the guy that decide not to take a salary.
What happens when I do it on Excel, is YES, I'm able to get the same value for each Tier but when they add up, the value of "money" is not the same.
In addition to this, I'm trying to plug-in a Quarterly Quota in the Spreadsheet... So if the Quota is met one Quarter, you get the salary but if 2 quarters later you're a quarter behind, you have to fulfill your previous number and the on-going one to get the commission... but that.. that's another story.
Maybe I'm not clear or I'm trying to do something too complicated or I'm asking too much, I don't know but I have an headache now... I really need someones help. I know for someone, figuring this thing out is not as complicated as it is for me..
Thank you.
Mathieu
Bookmarks