AccountancyNEB 2076 (old course)

Required: Stores ledger under First in First out Method.

5

Answer

027505500825011000Opening Stock (100 units @ Rs. 50)5000Purchases (July 5: 200 units @ Rs. 55)11000Purchases (July 15: 150 units @ Rs. 60)9000Purchases (July 25: 100 units @ Rs. 65)6500Closing Stock (150 units: 100 @ Rs. 65 + 50 @ Rs. 60)9500Value (Rs.)
Bar chart comparing opening stock, purchases, and closing stock values under FIFO (units and rates included for clarity).

Stores Ledger under First-in-First-out (FIFO) Method

Assume the following transactions for a company’s stores ledger under the FIFO method:

Cost of Goods Sold (COGS) Ledger (FIFO)Dr.Cr.To Opening Stock (100 @ Rs. 50)5,000To Purchases (July 5: 200 @ Rs. 55)11,000To Purchases (July 15: 150 @ Rs. 60)9,000To Purchases (July 25: 100 @ Rs. 65)6,500By COGS (July 10: 150 units)7,750By COGS (July 20: 200 units)11,500By COGS (July 30: 100 units)6,000
COGS Ledger showing the cost of goods sold entries under FIFO.
Stores Ledger (FIFO)Dr.Cr.To Opening Stock (100 @ Rs. 50)5,000To Purchases (July 5: 200 @ Rs. 55)11,000To Purchases (July 15: 150 @ Rs. 60)9,000To Purchases (July 25: 100 @ Rs. 65)6,500To Closing Stock (150 units: 100 @ Rs. 65 + 50 @ Rs. 60)9,500By COGS (July 10: 150 units)7,750By COGS (July 20: 200 units)11,500By COGS (July 30: 100 units)6,000By Balance c/d15,75041,00041,000
Stores Ledger showing opening stock, purchases, sales (COGS), and closing stock under FIFO.
  • Opening Stock: 100 units @ Rs. 50 per unit
  • July 5: Purchased 200 units @ Rs. 55 per unit
  • July 10: Sold 150 units
  • July 15: Purchased 150 units @ Rs. 60 per unit
  • July 20: Sold 200 units
  • July 25: Purchased 100 units @ Rs. 65 per unit
  • July 30: Sold 100 units

Calculation of Cost of Goods Sold (COGS) and Closing Stock under FIFO

  1. July 10 (Sale of 150 units):
    • First, 100 units from opening stock (Rs. 50) = Rs. 5,000
    • Remaining 50 units from July 5 purchase (Rs. 55) = Rs. 2,750
    • Total COGS = Rs. 7,750
    • Balance Stock = 150 units (50 @ Rs. 55 + 100 @ Rs. 55)
July 1 (Opening)100 units @ Rs. 50(Rs. 5,000)July 5Purchased 200units @ Rs. 55 (Rs. 11July 10 (Sale: 150 units)Issued: 100(Oldest @ Rs. 50) + 50July 15Purchased 150units @ Rs. 60 (Rs. 9,July 20 (Sale: 200 units)Issued: 150(Oldest @ Rs. 55) + 50July 25Purchased 100units @ Rs. 65 (Rs. 6,July 30 (Sale: 100 units)Issued: 100(Oldest @ Rs. 60) COGSJuly 31 (Closing)Remaining: 100 @Rs. 65 + 50 @ Rs. 60 →
Timeline of stock movements under FIFO, showing oldest stock issued first with updated stock levels after each transaction.
  1. July 20 (Sale of 200 units):

    • First, 100 units from July 5 purchase (Rs. 55) = Rs. 5,500
    • Next, 100 units from July 15 purchase (Rs. 60) = Rs. 6,000
    • Total COGS = Rs. 11,500
    • Balance Stock = 100 units (Rs. 60)
  2. July 30 (Sale of 100 units):

    • First, 100 units from July 15 purchase (Rs. 60) = Rs. 6,000
    • Total COGS = Rs. 6,000
    • Balance Stock = 150 units (100 @ Rs. 65 + 50 @ Rs. 60)
  3. Closing Stock (July 31):

    • 100 units @ Rs. 65 = Rs. 6,500
    • 50 units @ Rs. 60 = Rs. 3,000
    • Total Closing Stock = Rs. 9,500

The Stores Ledger under FIFO is shown in the table above, with all transactions recorded systematically. The final closing stock value is Rs. 15,000 (corrected based on remaining units after all sales). The ledger ensures that the oldest stock is issued first, maintaining accurate inventory valuation.

Discussion

Loading…

More Accountancy questions

All Accountancy old questions