Need help to make FIFO calculation more efficient

Hi all,

I'm currently working on the cost allocation of sold products based on FIFO. In the file attached, you find an example of how I have done it. It works, but I think it is not efficient, as the example only takes into account 2 purchase orders. However, if there are 100 purchase orders, you get 100 columns starting from column P.

Is there a way to make this more efficient and scalable?

Thank you in advance.


Juan

FIFO calculation.xlsx