Fifo allocation of inventory & extract name of associated bin & store name.

Hi!, I'm trying to work out a formula based solution to a problem but unsuccessful. I believe somebody here can help with this problem.
I've got Two sheets:

1) Sheet1: PO data & tracker sheet for qty. allocated for each item from a particular bin no. & store location.
In this sheet, we create entries for PO no., item name, qty. required for item etc. Column A to E. All further columns in sheet 1 is auto-updated from sheet2. In the attached file I've shown this sheet to be static but in reality, PO data entries will keep on increasing with each passing day.

2) Sheet2: In this sheet, we store information for each item for its bin no., qty. of that item in that bin, & store name. For this sheet, I've shown variable data with each passing day.

What we want to achieve: In sheet 2 if we fill "yes" in release execution, column W, then all items in this bin should be allocated in sheet 1 in front of matching item along with bin no., store location.

The logic of quantity allocation is that qty. of an item is allocated as we move up to down on a fifo basis. When Qty. need in all the above po's is completed then the only qty. overflows to next po. Also, none of the po can be allocated more qty. then mentioned in PO qty.

The attached file should make it more clear as I've shown data on daily progression basis from day 1 to day6.

This is for information that I've raised the same question at another forum. Link mentioned below.
https://chandoo.org/forum/threads/fi...re-name.41701/