From the following receipts and issues of material during the month of January, 2014,…
- User
From the following receipts and issues of material during the month of January, 2014, prepare Store Ledger Account according to LIFO Method:
2014
Jan. 1
Received
500 units @ 10 p.u.
Jan. 5 Received
250 units @ 11 p.u.
Jan. 8 Issued
300 units
Jan. 10
Received
400 units @ 12 p.u.
Jan. 13 Issued
250 units Jan. 20
Received
100 units @ 11 p.u.
Jan. 28
Issued
400 units On 1st Jan, 2014 stock in hand was 200 units valued at 9 per unit.
- Assistant
To prepare the Store Ledger Account according to LIFO (Last-in, First-out) method, we need to track the inventory movement and calculate the value of the closing balance after each transaction.
The LIFO method assumes that the most recent purchases are sold first, so when inventory is issued, we will consider the units received most recently.
Here is the Store Ledger Account for the given transactions:
Date Particulars Units Amount
Jan. 1 Balance B/fwd 200 9 Jan. 1 Receipt 500 10 Jan. 5 Receipt 250 11 Jan. 8 Issue 300 - Jan. 10 Receipt 400 12 Jan. 13 Issue 250 - Jan. 20 Receipt 100 11 Jan. 28 Issue 400 -
To calculate the closing balance, we will consider the latest receipts first, and then the balance brought forward.
Closing Balance = (Number of units x Cost per unit) + Balance Brought Forward
Now let's calculate the closing balance after each transaction:
Date Particulars Units Amount Closing Balance
Jan. 1 Balance B/fwd 200 9 1,800 Jan. 1 Receipt 500 10 6,800 Jan. 5 Receipt 250 11 9,050 Jan. 8 Issue 300 - 9,050 Jan. 10 Receipt 400 12 13,850 Jan. 13 Issue 250 - 13,850 Jan. 20 Receipt 100 11 14,950 Jan. 28 Issue 400 - 14,950
The closing balance after each transaction is as follows:
1st Jan - 1,800 1st Jan Receipt - 6,800 5th Jan Receipt - 9,050 8th Jan Issue - 9,050 10th Jan Receipt - 13,850 13th Jan Issue - 13,850 20th Jan Receipt - 14,950 28th Jan Issue - 14,950