Complex Bonus Calculation

[AZ-XL]

Hi Excel Experts.

I have a situation here which I cannot solve. I hope you experts will show me a way for that. However I am not sure if there is solution for it. But it worth to try. Here is the question:

My problem is about the bonus calculation. But its a lot complex. There are some criterias for calculation
1. Bonuses calculated if the payment of sales have been made. Extra payments will not be calculated as bonus, however it will be considered in next sales.
2. There are different percentage rates for the each month. When we will calculate bonuses we have to consider percentage rate of the month which sales have been made.
3. Payment may include the sales of 2 or more months". Then we should consider every month"s percentage separately.

I upload the sample file because it is impossible to explain my problem without it. Also showed there in file the desired results and its explanation about how I came to that result. You may use as many helper columns as you wish.

Thank you all in advance.