Skip to Content
0
Former Member
Feb 06, 2015 at 05:23 AM

Still unable to MAP the incremental volume in Rebate Agreement

27 Views

i am unable to put a formula like below in scales on condition in rebate agreement. Kindly help


If the sales of a customer is as under:

Product X Nov’14 A

Dec’14 B

Jan’15 C

Feb’15 D

Mar’15 E

Rebate for Dec’14:

Incremental Sale=B-A

If (B-A)/A*100 is Between 0% to 1%: Incentive = (B-A)*F

Between 1% to 2%: Incentive = (B-A)*G

Between 2% to 4%: Incentive = (B-A)*H

Between 4% to 20%: Incentive = (B-A)*I

Above 20%: Incentive =(20% of A)*J

Rebate for Jan’15:

Incremental Sale=B-A

If (C-A)/A*100 is
Between 0% to 1%: Incentive = (C-A)*F

Between 1% to 2%: Incentive = (C-A)*G

Between 2% to 4%: Incentive = (C-A)*H

Between 4% to 20%: Incentive = (C-A)*I

Above 20%: Incentive =(20% of A)*J

Similarly for Feb & Mar.

Kindly help in this Rebate Agreement.