Happy Business Starts Here

Honor Student

How can I create a Monthly usage billing rate plan with annual thresholds

Hello,

 

I want to create a monthly billing rate plan based on annual thresholds.

 

Yearly Thresholds

1: 0-500: 3,5%

2. 501-1.000: 3,0%

3: 1.001-3.000: 2,5%

4: 3.001-5.000: 2,0%

5: 5.000- xxx: 1,5%

 

At the moment the monthly usage will be extrapolated to the year and the correspending percentage is set

e.g.

Month 1: 400*12 = 4.800 = Threshold 4 = 400*2% = 8

Month 2: 100*12 = 1.200 = Threshold 3 = 100*2,5% = 2,5

Month 3: 600*12 = 7.200 = Threshold 5 = 600*1,5% = 9

 

At year end there is a final settlement with peaks that we would like to smooth over the year.

 

Correct Billing would be:

Month 1: 400 = 400*3,5% = 14

Month 2: 100 = 100*3,5% = 3,5

Month 3: 600 = 500*3% + 100*2,5% =17,5

 

 

Is that possible?

 

Best,

Daniel

 

Best regards,

Daniel