Looking for assistance in creating a formula that will deduct QTY Sold from oldest purchase first, then from next oldest and so on. I have attached a simple file.

Data table contains Qty on hand.

User Input shows Qty sold.

Result table is where I want the calculations, results must match figures in the table. Deduct from oldest purchase first, then from next oldest.

I'm struggling to workout a formula.

TIA