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

<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>
[TD="class: xl65, width: 101"]QTY[/TD]
[TD="class: xl66, width: 77"]COST[/TD]

[TD="class: xl67"]60[/TD]
[TD="class: xl68"]50[/TD]

[TD="class: xl67"]40[/TD]
[TD="class: xl68"]30[/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl67"][/TD]
[TD="class: xl68"][/TD]

[TD="class: xl69"]Total 100
[/TD]
[TD="class: xl70"] [/TD]

</tbody>

<colgroup><col style="mso-width-source:userset;mso-width-alt:2816; width:58pt" width="77" span="2"> </colgroup><tbody>
[TD="class: xl65, width: 77"]QTY[/TD]
[TD="class: xl66, width: 77"]Formula ?
[/TD]

[TD="class: xl67, align: right"]50[/TD]
[TD="class: xl68, align: right"]50
[/TD]

[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl68, align: right"]50[/TD]

[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl68, align: right"]50[/TD]

[TD="class: xl67, align: right"]10[/TD]
[TD="class: xl68, align: right"]30[/TD]

[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl68, align: right"]30[/TD]

[TD="class: xl67, align: right"]10[/TD]
[TD="class: xl68, align: right"]30[/TD]

[TD="class: xl67, align: right"]5[/TD]
[TD="class: xl68, align: right"]30[/TD]

[TD="class: xl67, align: right"]10[/TD]
[TD="class: xl68, align: right"]30
[/TD]

[TD="class: xl69, align: right"]Total 100
[/TD]
[TD="class: xl70"] [/TD]

</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