Skip to Content
0
Former Member
Feb 04, 2014 at 05:29 AM

Load Factor Incentive(LFI) Calculation

143 Views

Hi All,

Hope you all doing well.

I have a requirement where in i have to calculate the LFI(Load Factor Incentive) from the FQEVENTS no 42, there in i have 3 scenarios.

Scenario 1:

Customer Makes the Payment Promptly

LFI for January Month will be credited to the customer in February Month’s Invoice which will be raised on 1st March.


Scenario 2:

Customer failed to make the payment promptly for the last Month but makes on time for current month

LFI for the month of April will not considered because customer did not make payment on time as well as it should not calculate LFI for the month of May.


Scenario 3:

Customer failed to make the payment promptly.

LFI for should not calculate till at least 2 months Prompt Payment Made.

If my above understanding is correct then we will have to do enhancement for that I need to find out which events are relevant for these scenarios. Please give your scenarios and inputs.


Above are the 3 scenarios based on that i have to calculate the Load Factor Incentive.

Below table is detailed description of the above scenario.


Billing Month

Invoice Date

Due Date

Invoice Amount

Inclusive LFI

Payment Date

LFI Amount

January

01st Feb

21st Feb

10000

10th Feb

100

February

01st March

21st March

(11000)-100

10th March

110

March

01st April

21st April

(9000)-110

10th April

90

April

01st May

21st May

(80000)-90

10th May

80

May

01st June

21st June

12000

15th June

Nil

June

01st July

21st July

13000

10th July

130

July

01st Aug

21st Aug

14000-130

10th Aug

140

Kindly help me find the solution.