Forum Discussion
FIFO Cost and Closing Inventory Valuation
FIFO Cost of Sales and Closing Inventory Calculation
yesterday
Hi All Experts,
I am beginner to BI and tried many methods in order to get the below result and also google about this problem but i did not get the correct answer and have no ideas how to use the relevant formula to get this below result.
Any suggestion of fomula to get the below result?
Thanks and Regards,
Sales Table
| Date | Product Name | Quantity |
| 10/10/2022 | A | 10 |
| 10/12/2022 | A | 3 |
| 10/12/2022 | A | 2 |
| 10/13/2022 | A | 1 |
| 10/10/2022 | B | 22 |
| 10/11/2022 | B | 10 |
| 10/12/22 | B | 3 |
Purchase Table
| Date | Product Name | Quantity | Cost |
| 9/12/2022 | A | 10 | 110 |
| 9/30/2022 | A | 4 | 130 |
| 10/1/2022 | A | 6 | 150 |
| 9/1/2022 | B | 20 | 210 |
| 9/2/2022 | B | 20 | 250 |
| 9/20/2022 | B | 10 | 230 |
The result i want to get;
| Date | Product Name | Quantity | Cost of Sales | Closing Inventory | Closing Inventory Value |
| 10/10/2022 | A | 10 | 1100 | 10 | 1420 |
| 10/12/2022 | A | 3 | 390 | 7 | 1030 |
| 10/12/2022 | A | 2 | 280 | 5 | 750 |
| 10/13/2022 | A | 1 | 150 | 4 | 600 |
| 10/10/2022 | B | 22 | 920 | 28 | 6800 |
| 10/11/2022 | B | 10 | 2500 | 18 | 4300 |
| 10/12/22 | B | 3 | 750 | 15 | 3550 |
2 Replies
Hi PhyuLayKhine333 - it appears you have asked the same question four different forums. Do you still need a response?
Yes sir, I sill need a response .
