Track commission based upon number of sales
I received a new job (yay!) and I'm trying to track my commissions. I get paid by a combination of production and the number of sales I produce. Here's a little table to show what I mean.
# of sales | Payout Rate |
1 | 6% |
2 | 7% |
3 | 8% |
4 | 9% |
5 | 10% |
6 | 11% |
7 | 12% |
8 | 13% |
Let's say each sale the client pays $2,000 to keep it simple. The first sale I would earn $120, the second sale I would now earn $140 for each because it's retroactive (does this make sense?) with no cap. How would I effectively track this in numbers? Thanks in advance!
MacBook Pro, iOS 10
