SALESPERSON'S COMPENSATION WORKSHEETS
Input only into "YELLOW" cells, remaining calculation cells.
Commission sheets will allow you to:
Set % levels of payout on commissionable gross, non-retro.
Note: If you have 1 set % value set all levels to that value.
Set a plateau bonus , flat $ value based on commissionable gross, non-retro.
Note: If no plateau bonuses set values to $ 0.
Apply weekly draws to commissionable gross.
Pay F & I dollar bonuses for assisted sales incentive.
You can create an endless amount of Commission Sheets, Simply by:
Right Click on Sheet Tab.
Select "Move or Copy".
Click on "Create an Copy" box.
Then Click "OK"
You may than rename your worksheet, Simply by:
Right Click on Sheet Tab.
Select "Rename".
Then type new name in highlighted tab area.
Worksheets are protected, NO password.
Worksheets contain NO Macros.
Feeling creative, create a new worksheet, totaling all individual sheets for a summary page.