Recept issues 880 units x 9=7920 4march 400 units x9=3600 300 units x 6=1800 6march 480 units x9=4320 400 units x 8=3200 120 units x6= 720 500 units x 5=2500 22march180 units x6=1080 200 units x 2= 400 400 units x8=3200 900 units x 3=2700 320 units x5=1600 28march100 units x5= 500 Total receipt 18520 31march 80 units x5= 400 200 units x2= 400 420 units x3=1260 Total issued 17080 Closing inventory = total receipt-total issues = 18520-17080 = $1440
fifo by: makwaza
closing 480 *$3=1440
FIFO Method Question by: Patrick
Closing Balance:
400 units worth $1,200
Working is as follows;
Receipts Issues Balance units $ total units $ total units $ total 800 9 7,200
The last figures under Balance is the closing stock(inventory) for the end of the month i.e. 400 units @ $1,200. On my answer, i excluded the date column, the spaces in between the figures on the top and those below represent another date.
If you have any question on this, please ask.
Different Answer by: Anonymous
Correct Answer after completing all entries.
31 March 480 * $3 = $1440
Answer by: Qasim
Closing Balance is 1080 units having total value of 6780.
Details;
180 units @ $ 6 having value 1080 400 units @ $ 8 having value 3200 500 units @ $ 5 having value 2500