Formula to find the cost using First In First Out Basis

[zaska]

Hello,

I want to learn the formula to find the cost under FIFO Basis

Example:

Source Table

QTY	COST
60	50
40	30
Total 100

<colgroup><col style="mso-width-source:userset;mso-width-alt:3693;width:76pt" width="101"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> </colgroup><tbody>
</tbody>

QTY	Formula ?
50	50
5	50
5	50
10	30
5	30
10	30
5	30
10	30
Total 100

<colgroup><col style="mso-width-source:userset;mso-width-alt:2816; width:58pt" width="77" span="2"> </colgroup><tbody>
</tbody>

Can anyone help me with the formula to find the cost under fifo basis

Thank you

 

[zaska]

Sumifs or lookup just can't figure out the logic.

Can any one help me?

How to find the cost from First tranch and then second tranch