Using fifo for costing

Hello All,

Please in the attached, I have products purchased at different dates with different prices. Using FIFO for issuance on the second table, what formular can I use to cost the item so as to arrive at the amount for each day's issuance?


Thanks.

Please take a minute to include the desired results (which you can enter manually) in your sample then re-upload the workbook.

Once we see the desired results, we can build a formula to replicate them automatically.

I have reattached the file with some adjustments. What I want is a formular to cost items issued (Table 2) based on its purchasing price in table 1.

You still haven't filled in the desired results. Column I is empty.

I have a feeling that you are looking for this in I5, but I can't be sure without seeing the desired results.

=D5/H5

You can also get rid of column D and use this:

=B5*C5/H5

=vlookup(g6,$a$6:$b$22,2)*h6

Thanks.

I have reattached the file with some adjustments. I want products to be issued at their purchase price. I have included a column for my expected results for some transactions. I hope it's clearer now.

Regards.

Try this in I6:

=IFERROR((SUM(C5:C$6)-SUM(H5:H$6))*B5+(H6-(SUM(C5:C$6)-SUM(H5:H$6)))*B6,H6*B6)

The result matches the 3 results that you shared in post #6.