Hello everyone,
in the tool Phocas-Rebates I would like to make the calculation of Rebates for an y% increase over the x% previous year.
What should I set?
Can someone help me?
Greeting Mücke
Muecke,
Are you looking to create a rebate based on increase over previous year growth? For example, a customer grew 10% last year and you want them to grow at least 50% of that this year (5% this year over last year’s growth)?
Thanks,
Page Schrock
Hello, Schrock,
not quite if I understood it correctly, please excuse my English is not so good.
Example:
Customer XY
previous year:
Sales Total period: 01.01.2018 to 31.12.2018
Total turnover in Euro: 100.000 €
Current year:
Turnover Total Period: 01.01.2019 to 31.12.2019
Total turnover in Euro: 112.000 €
Rule:
Increase over the previous year Sales from +10% then on the increased sales 2% (level)
Increase over the previous year Revenue from +20% then on the increased revenue 4% (level)
Increase over previous year Revenues from +30% then on the increased revenues 8% (level)
Check:
Increase in %: (Current turnover - previous year turnover) / previous year turnover * 100
Increase in %: (112.000€ - 100.000 €) / 100.000 € * 100 = 12,00 %
Increase in €: Current turnover - previous year turnover
Increase in €: 112.000 € - 100.000 € = 12.000 €
Rebates: Increase in € * Level
Rebates: 12,000 € * 2% = 240.00 €
I hope you can understand what I mean.
I don’t understand what I have to put in here.
Gruß Mücke