Hi,
I am looking for someone to build a automation template formula to manage commission scheme.
My client is opening a shoe selling company.
He wants to set a commission basic reward scheme.
Example
Salesman sell,
( tier 1 ) 1 quantity to 15 quantity/month gets X% commission
( tier 2 ) 16 to 50 gets/month Y commission
( tier 3 ) 51 to 120 /monthgets Z commision
and then once they maintain in say tier 3 for 3 months, they get quarterly performance bonus
and then once they maintain in say tier 3 for 4 quarters - they get additional yearly bonus
That is individual salesman
then
2nd type, reference commission
3rd type co sharing, principal salesman and secondary salesman
4th type , team lead over riding
5th type, commission to the company
Thanks