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