Prepare a store ledger account from the following transactions using (i) LIFO method; (ii) The weighted average method in May, 2019:

Here’s the table transcribed from the image:

2019MayUnitsPrice/Tk.
1Balance in hand3002.00
2Received2002.20
4Issued150
6Received2002.30
11Issued150
19Issued200
22Received2002.40
27Issued150

Ans:

Sure! Let’s prepare the store ledger account for the transactions using both the LIFO and Weighted Average methods for May 2019.

LIFO Method

LIFO (Last-In, First-Out) assumes that the last items received are the first ones issued.

Store Ledger Account using LIFO

DateParticularsUnitsRateAmountBalance (Units)Balance (Rate)Balance (Amount)
May 1Balance3002.00600.003002.00600.00
May 2Received2002.20440.005001040.00
May 4Issued1502.20330.00350710.00
May 6Received2002.30460.005501170.00
May 11Issued1502.30345.00400825.00
May 19Issued2002.30460.00200365.00
May 22Received2002.40480.00400845.00
May 27Issued1502.40360.00250485.00

Weighted Average Method

Weighted Average calculates a new average cost per unit after each purchase.

Store Ledger Account using Weighted Average

DateParticularsUnitsRateAmountBalance (Units)Balance (Rate)Balance (Amount)
May 1Balance3002.00600.003002.00600.00
May 2Received2002.20440.005002.081040.00
May 4Issued1502.08312.003502.08728.00
May 6Received2002.30460.005502.161188.00
May 11Issued1502.16324.004002.16864.00
May 19Issued2002.16432.002002.16432.00
May 22Received2002.40480.004002.31912.00
May 27Issued1502.31346.502502.31577.50

These tables should help you visualize the inventory accounting using both methods for May 2019.