What about a combination of threshold and tiered. I.e. In one year you make 250k in sales, the first 120k is your threshold/ annual draw amount. So on the remaining 130k, the first 30k bracket is a 10% commission payout, the next 50k bracket is 25% commission payout and anything above 80k is paid out at 25%. Hopefully, I've made sense here. thanks
Jonny that’s a good one, thanks! I’ll have to make a separate video showing the setup on that one. Definitely doable, just have to combine a few concepts from this video and lay it out a little differently. If you haven’t already, hit subscribe and the notification icon so you’ll get notified once I’m able to publish the new vid.
What about a tiered monthly commission based off annual sales? Example at the end of September you ended with $230,000 in sales. For your commission for the month of October you sold another $50,000, you receive 5% on sales up to $250,000 and 6% on everything over $250,000. Can you automate October to know that you receive 5% on the amount that gets you to $250,000 and then 6% on everything over? Maybe that’s confusing?
Yes, this can be done! Just need some creative formulas and the right layout. I can add this to my video queue but it will probably be a couple months out. If this is a significant problem you need to solve before then, feel free to reach out and see what it would take for my team to build it out for you. Colton@customexcelspreadsheets.com
very helpful thanks, subscribed
So helpful thank you
You’re welcome, thanks for the feedback!
What about a combination of threshold and tiered. I.e. In one year you make 250k in sales, the first 120k is your threshold/ annual draw amount. So on the remaining 130k, the first 30k bracket is a 10% commission payout, the next 50k bracket is 25% commission payout and anything above 80k is paid out at 25%. Hopefully, I've made sense here. thanks
Jonny that’s a good one, thanks! I’ll have to make a separate video showing the setup on that one. Definitely doable, just have to combine a few concepts from this video and lay it out a little differently. If you haven’t already, hit subscribe and the notification icon so you’ll get notified once I’m able to publish the new vid.
@@coltoncauthen8696 Adding my comment here. In case this is posted.
What about a tiered monthly commission based off annual sales? Example at the end of September you ended with $230,000 in sales. For your commission for the month of October you sold another $50,000, you receive 5% on sales up to $250,000 and 6% on everything over $250,000. Can you automate October to know that you receive 5% on the amount that gets you to $250,000 and then 6% on everything over? Maybe that’s confusing?
Yes, this can be done! Just need some creative formulas and the right layout. I can add this to my video queue but it will probably be a couple months out.
If this is a significant problem you need to solve before then, feel free to reach out and see what it would take for my team to build it out for you. Colton@customexcelspreadsheets.com