Formula Import and export inventory according to expiration date and age of inventory

Dear all

I have an import and export table of raw materials. I need to install the formula from columns I to Q. I want to calculate product inventory by date (first in, first out)
for example, product A has the beginning number of the period on November 30 as 5, the input is 150 (in which December 31, 2022 is 50 and January 1, 2023 is 100, I am applying import first before export). Before, 30 should be exported, including 5(November 30), 25(December 31), so the final number of product A is 125 kg, including 25kg(December 31, 2022) and 100 kg(January 1, 2023). I want the remaining number of product A according to the warehouse date to calculate the age of the inventory

THanks in advance

I rearranged the data.
On the Input sheet the stock is arranged in rows 2:5 and the export is arranged in columns A:B
The calculation of stock exported (first in, first out) in rows 6:11 is accomplished using: =IF(D$2=$A6,MIN(D$4-SUMIFS(D$5:D5,$A$6:$A6,D$2),$B6-SUMIFS($C6:C6,$C$2:C$2,$A6)),"")
The remaining stock is calculated in row 1 using: =D4-SUM(D6:D11)
On the Output sheet the PRODUCT, Date and AMOUNT columns are populated using formulas similar to:
=IFERROR(INDEX(Input!$D$2:$K$3,COLUMNS($A3:A3),AGGREGATE(15,6,(COLUMN(Input!$D$2:$K$2)-COLUMN(Input!$C$2))/(Input!$D$1:$K$1>0),ROWS(I$3:I3))),"")
The age of inventory columns are populated using formulas similar to: =IF(AND($D3<>"",$D3<=120),$C3,"")
Let us know if you have any questions.