Amount to be allocated but with Upper Limit

[gurusanthanam]

Hi All,

I have to allocate a specified amount (column E) for each Item(Column A) based on column D.
Amount to be allocated cannot exceed the total amount specified for each Item in Column E.

I have to maintain the same order in which the data is displayed in sample file. Because, the data has been sorted by Transaction date.
I have to allocate the amount which has been transacted first based on transaction date.

I am expecting a formulae to get the Values as in Column F. (i have manually filled up Column F, but i have 13000 Rows for which same calculation has to be done for different Items).

Please do not mind the repeated values in Column E. For one Item (column A) there is always only one Maximum value that can be allocated.

Sorry i could explain in words much. Please refer to the example in the file attached.

Thanks in Advance.