FIFO in Excel Quantity Distribution

enter image description here

Hi, I need the help in getting the above output in the form FIFO Method in Excel There will be 2 input screen given, one is for Purchase Side (Qty and Exp. Goods Receipt Date) and other is Sales Side (Qty and Exp. Ship Date) We need the Qty to be distributed in the form FIFO method, means how the quantity been distributed along with Expected Goods Receipt Date and Expected Ship Date as shown in Output table