I am formulating a discount structure for my dealers.
I want to do prorata calculation for the same on excel.
There are two limits which have been defined. The lowest limit is Rs 300000
for which the dealers get a discount of 3%. The highest limit is 2000000 for
which the discount is 5%.
I would like to have a framework on excel in which between 300000 and
2000000, discount is allocated on pro rata basis. Currently I am using Excel
2000
Sales: 300000 - Discount 3%
Sales: 2000000 - Discount 5%