Yes, you will have to subtract from the inventory, starting with those already in the opening inventory (the first units).
There are 478 units in total in the inventory when sales are not taken into consideration, yes?
How many are therefore left in the inventory at the end of march?
It'll be 478 - 346 = 132 units.
Those 132 units consists of the last items purchased, since under FIFO, the oldest items are considered to have been first sold.
The last items are:
44 @ 35
Hmm, there's 132, so we need to take the one just before that too.
167 @ 32
Now, it makes a total of (44+167) = 211. That's too much! So, you take the last 44 items and the rest to make 132, that is (132 - 44) = 98.
So, that means you're taking:
44 @ 35
98 @ 32
Can you work out the value of this inventory? :)
|