I am trying to find the right formulas to use for calculating commission for the following;
1. Target 1 – for the year is £486,000 GP. Any sales up to this target will be paid standard commission rates up to 100%.
2. Target 2 – If within a quarter period you exceed the target but are under the budget then the commission between those two figures will have an automatic accelerator of x1.5. The budget is £648,000 GP for the year.
3. Target 3 – If within a quarter period you exceed the budget then the commission over that budget figure will have an automatic accelerator of x2.
I have a commission calulation sheet set up from last year but there has been some changes for this fiscal year and I thought i could use the same excel sheet and amend the forumlas but seem to be having a bit of trouble and not sure if i should just start a fresh.
I have attached the current excel sheet so you can see the existing formulas.
A help would be appreciated.
Bookmarks