CALCULATIONS FOR VARIABLE RENT

Hi,

We want to calculate Variable rent on bases of Sales Volume,

The percentage for turnover is calculated differently when the t/over reaches certain amounts i.e :

14% up to 100,000

15% from 100,001 to 200,000

16% from 200,000

Scenario 1:

Sales volume = 150,000

100,000*14%= 14000

50000*15%= 7500

Total variable rent = 21500

Scenario 2:

Sales volume = 150,000

150000*15% = 22500

How can i do in system?

Thanks