Dear All,
Looking for solution to allocate the licence fee month wise base on the escalation date. I have given the following example where allocation should be through start date to end date keeping in mind the middle escalation dates and escalated amounts.
LF Start Date LF End Date Base LF 1st Escalation Effective from 2nd Escalation Effective from
15-Jul-15 14-Jul-18 100 115 07-08-2016 120 26-01-2017
1 LF Start Date is 15th July 2015
2 LF End Date is 14th July 2018
3 Base agreement LF is Rs. 100/- pm
4 So till for 06th Aug 16, LF will Rs. 100 pm -- ( for August 2016 LF will be for 5 days @100 & for rest @ 115 pm till next escalation trigger)
5 From 07th Aug 16 till 26th Jan 2017, LF will at Rs. 115 each months
6 From 26th Jan 17 onward, LF will at Rs. 120 each months
Tabular Data will be
FY 15-16 Moth Jul-15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16
LF Amount 50 100 100 100 100 100 100 100 100
FY 16-17 Month Apr-16 May-16 Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17
LF Amount 100 100 100 100 16.67 + 91.99 115 115 115 115 92.74 + 23.22 120 120
….. and son till LF end date i.e. 14th July 2018
Note: LF for Aug 16 : 06 Days @ 100 & Rest 24 days @115 since escalation date change on 07th Aug. 2016
LF for Jan 17 : on same principal as for Aug. 16
Thanks in advance
Regards
Bookmarks