Query on Excel Formula -FIFO Accounting

Hi ,

I am facing a serious problem while computing the working capital blocked due my excess purchase items , or due to late realisation .

I am looking for a formula which I can use to identify my multi-location and multi-product 1) stock outflow on FIFO basis and 2)date of purchase of the sold materials ,

in other words ,

1)the date difference ( time period ) between item purchased and sold (realisation ) .and
2) also the item unsold at the end of the period ( closing stock) .

Have attached an excel sheet to understand the exact problem

This is a real life issue and would be grateful if you help me .

regards