Tiered commission plan paid monthly

Hello all,

I have been trying to calculate this worksheet for the past couple days. This is a tiered commission plan paid monthly. So depending on the salesperson's cumulative sales, that will trigger the rate of pay for that monthly salary. I've attached the spreadsheet for help.

I need to get some sleep so I would greatly appreciate the help!