i have generation from various statements. i want to allocate this to customers proportionally.
I have derived statement wise total proportional units upto which the customer is eligible.
I have to allocate this proportional units to the customers as slot wise with proportion to the slot wise generation.
By doing this the following criteria should get tally.
1.Proportional units should be allocated to the customers
2.The closing banking should not be less than zero
3.Net value of total allocation should not be more than the planning as slot wise.
Please find the attached file. in this i am done a sample allocation but the alloted unis is more the planning to be allocated.
kindly advise me. if any doubt plz contact me in 09176380104.