Automatingly Calculating Cost of Goods Sold in Multi Sku|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Perhaps not the most elegant solution but I had an older model that calculated FIFO cost and adapted it a little to be used with your example.

Start by putting both IN and OUT in one table, sorted in date order. Then you need to  create a some column headers with the various Unit Costs and Incoming Quantities. Below, you can then calculate from which cost layer the outgoing quantities are taken and thus calculate GOGS.

I'm tempted to further develop this and make it all a bit more dynamic, but this is all for now.

Edit: I now realize that you have different SKU's within the table. My file will work if you would have one table for each SKU.