Subjects inventory management

Fifo Store Ledger

Step-by-step solutions with LaTeX - clean, fast, and student-friendly.

Search Solutions

Fifo Store Ledger


1. **Stating the problem:** Calculate the store ledger for July 2012 using the FIFO (First In, First Out) method. 2. **List opening and purchases:** - July 1: Opening balance = 500 units @ Tk. 10 - July 3: Purchased 700 units @ Tk. 10.50 - July 7: Purchased 650 units @ Tk. 11.00 - July 12: Purchased 600 units @ Tk. 12.00 3. **Record issues and returns:** - July 4: Issued 400 units from stock (FIFO takes from oldest stock first) - July 8: Returned 50 units to suppliers (reduce stock) - July 14: Issued 500 units - July 16: Returned 25 units from department B (add back to stock) - July 20: Issued 500 units - July 24: Issued 525 units - July 25: Shortage of 20 units found (reduce stock by 20 units) 4. **Calculate FIFO ledger step-by-step:** - July 1 opening: 500 units @ Tk. 10 - July 3 purchase: +700 units @ Tk. 10.50 Total: 500 @ 10 + 700 @ 10.50 - July 4 issue: 400 units issued starting from oldest: 400 units taken from 500 @ 10, remaining 100 @ 10 - July 7 purchase: +650 units @ Tk. 11.00 Stock now: 100 @ 10 + 700 @ 10.50 + 650 @ 11.00 - July 8 return to supplier: 50 units removed: Remove from latest stock (FIFO assumes oldest used first but for return to supplier, assume removal from latest batch): Remove 50 units from 650 @ 11.00, remaining 600 @ 11.00 - July 12 purchase: +600 units @ Tk. 12.00 Stock now: 100 @ 10 + 700 @ 10.50 + 600 @ 11.00 + 600 @ 12.00 - July 14 issue: 500 units issued: First 100 units @ 10 (all used) Then 400 units @ 10.50 (700 - 400 = 300 remaining) Stock after issue: 0 @ 10 + 300 @ 10.50 + 600 @ 11.00 + 600 @ 12.00 - July 16 return from dept B: 25 units added back: Add 25 units at latest purchase price assumed (12.00) New stock: 300 @ 10.50 + 600 @ 11.00 + 625 @ 12.00 - July 20 issue: 500 units issued: Use 300 @ 10.50 (all used) Then 200 @ 11.00 (600 - 200 = 400 left) Stock now: 0 @10.50 + 400 @11.00 + 625 @12.00 - July 24 issue: 525 units issued: Use 400 @ 11.00 (all used) Then 125 @ 12.00 (625 - 125 = 500 left) Stock now: 0 @ 10.50 + 0 @ 11.00 + 500 @ 12.00 - July 25 shortage: 20 units shortage: Remove 20 units from latest stock @ 12.00 Stock now: 480 @ 12.00 5. **Final stock:** 480 units remaining @ Tk. 12.00 6. **Summary:** The FIFO store ledger carefully accounts for each issue, purchase, and return noting the cost layers and quantities. **Final answer:** 480 units remain in stock valued at Tk. 12.00 each using FIFO method.