Subjects accounting

Fifo Closing Stock 1F4D9B

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

Search Solutions

Fifo Closing Stock 1F4D9B


1. **Problem Statement:** Prepare a stores ledger card for Gabon Ltd for March 2020 using the FIFO (First-In, First-Out) inventory method and find the value of the closing stock. 2. **Given Data:** - Opening stock (Feb 29): 2,500 units valued at 90,000 - Purchases in March: - Mar 13: 1,000 units @ 38 - Mar 20: 1,200 units @ 39 - Mar 25: 1,600 units @ 40 - Mar 28: 500 units @ 38 - Sales in March: - Mar 3: 350 units - Mar 4: 500 units - Mar 16: 400 units - Mar 24: 900 units - Mar 26: 1,900 units 3. **FIFO Method Explanation:** FIFO assumes the oldest inventory is sold first. So, sales reduce the earliest stock first. 4. **Step-by-step Ledger Calculation:** - Opening stock: 2,500 units @ sh.36 per unit (since 90,000/2,500 = 36) - Sales on Mar 3 (350 units): reduce from opening stock Remaining opening stock: 2,500 - 350 = 2,150 units - Sales on Mar 4 (500 units): reduce from opening stock Remaining opening stock: 2,150 - 500 = 1,650 units - Purchase on Mar 13: add 1,000 units @ 38 - Sales on Mar 16 (400 units): reduce from opening stock Remaining opening stock: 1,650 - 400 = 1,250 units - Purchase on Mar 20: add 1,200 units @ 39 - Sales on Mar 24 (900 units): reduce from opening stock Remaining opening stock: 1,250 - 900 = 350 units - Purchase on Mar 25: add 1,600 units @ 40 - Sales on Mar 26 (1,900 units): reduce first from opening stock (350 units), then from Mar 13 purchase (1,000 units), then from Mar 20 purchase (550 units) Remaining Mar 20 purchase: 1,200 - 550 = 650 units - Purchase on Mar 28: add 500 units @ 38 5. **Calculate closing stock units:** - Remaining from Mar 20 purchase: 650 units @ 39 - Remaining from Mar 25 purchase: 1,600 units @ 40 - Remaining from Mar 28 purchase: 500 units @ 38 Total closing stock units = 650 + 1,600 + 500 = 2,750 units 6. **Calculate closing stock value:** $$\text{Value} = 650 \times 39 + 1,600 \times 40 + 500 \times 38$$ $$= 25,350 + 64,000 + 19,000 = 108,350$$ **Final answer:** Closing stock value = sh.108,350 --- **Stores Ledger Card Summary:** - Opening stock: 2,500 units @ 36 - Purchases: 4,300 units (1,000@38, 1,200@39, 1,600@40, 500@38) - Sales: 4,050 units - Closing stock: 2,750 units valued at sh.108,350