AccountancyNEB 2075 (old course)

The following transactions were taken from the store for the month of poush: Poush 1): Opening balance: 400 units for Rs.2000 Poush 3): Purchase: 600 units @ Rs.6 each Poush 6): Issued: 800 units…

5

The following transactions were taken from the store for the month of poush:

  • Poush 1): Opening balance: 400 units for Rs.2000
  • Poush 3): Purchase: 600 units @ Rs.6 each
  • Poush 6): Issued: 800 units
  • Poush 15): (Return from department): 70 units
  • Poush 22): Purchase: 800 units @ Rs. 7 each
  • Poush 25): Issued: 830 units
  • Poush 28): (Store verification surplus): 10 units

Required:

  • Store ledger under First In First Out (FIFO) Method. [5]

Answer

Store Ledger under FIFO Method

Store Ledger (FIFO) - Poush MonthDr.Cr.To Opening Balance2,000To Poush 3 Purchase3,600To Poush 15 Return420To Poush 22 Purchase5,600By Poush 6 Issued (400@5 + 400@6)4,400By Poush 25 Issued (400@6 + 800@7)5,540By Closing Balance (10@6)60By Balance c/d1,62011,62011,620
Double-entry format showing debits and credits for store transactions

Step-by-Step Calculation:

  1. Opening Balance (Poush 1):

    • Quantity: 400 units
    • Rate: Rs. 5 per unit (since Rs. 2000 / 400 = Rs. 5)
    • Amount: Rs. 2000
  2. Purchase (Poush 3):

    • Quantity: 600 units
    • Rate: Rs. 6 per unit
    • Amount: Rs. 3600
    • Total Balance: 1000 units (400 + 600)
    • Total Amount: Rs. 5600 (2000 + 3600)
  3. Issued (Poush 6):

    • Quantity: 800 units
    • Calculation:
      • First, issue 400 units @ Rs. 5 = Rs. 2000
      • Remaining 400 units @ Rs. 6 = Rs. 2400
      • Total Issued Amount: Rs. 4400
    • Remaining Balance: 200 units @ Rs. 6 = Rs. 1200
  4. Return from Department (Poush 15):

    • Quantity: 70 units
    • Rate: Rs. 6 (since last issued rate was Rs. 6)
    • Amount: Rs. 420
    • Total Balance: 270 units (200 + 70)
    • Total Amount: Rs. 1620 (1200 + 420)
  5. Purchase (Poush 22):

    • Quantity: 800 units
    • Rate: Rs. 7 per unit
    • Amount: Rs. 5600
    • Total Balance: 1070 units (270 + 800)
    • Total Amount: Rs. 7220 (1620 + 5600)
  6. Issued (Poush 25):

    • Quantity: 830 units
    • Calculation:
      • First, issue 270 units @ Rs. 6 = Rs. 1620
      • Remaining 560 units @ Rs. 7 = Rs. 3920
      • Total Issued Amount: Rs. 5540
    • Remaining Balance: 40 units @ Rs. 7 = Rs. 280
  7. Store Verification Surplus (Poush 28):

    • Quantity: 10 units
    • Rate: Rs. 6 (since last issued rate was Rs. 6)
    • Amount: Rs. 60
    • Final Balance: 10 units @ Rs. 6 = Rs. 60

Final Store Ledger Summary:

  • Total Issued Amount: Rs. 9940 (4400 + 5540)
  • Final Closing Balance: 10 units @ Rs. 6 = Rs. 60
0337.56751012.51350Opening Stock400Poush 3 Purchase600Poush 22 Purchase800Total Issued1350Closing Stock10Units
Unit movement comparison showing stock levels throughout Poush month
Poush 1Opening Balance:400 units @ Rs. 2000 (Poush 3Purchase: 600units @ Rs. 6 each (ToPoush 6Issued: 800 units(400 @ Rs. 5 + 400 @ RPoush 15Return fromDepartment: 70 units @Poush 22Purchase: 800units @ Rs. 7 each (ToPoush 25Issued: 5540 units(400 @ Rs. 6 + 800 @ RPoush 28Closing Balance:10 units @ Rs. 6 (Tota
FIFO Store Ledger Timeline: Movement of units and amounts in Poush month

Discussion

Loading…

More Accountancy questions

All Accountancy old questions