Questions · Q8
Q.From the following transactions, prepare a Stores Ledger Account under the Weighted Average method:
Mar 1 Opening balance 100 units @ ₹20 per unit
Mar 5 Received 300 units @ ₹24 per unit
Mar 10 Issued 200 units
Mar 15 Received 200 units @ ₹27 per unit
Mar 20 Issued 300 units
Mar 25 Issued 50 units
ChseodishaTextbookSubjectiveImportance★★★★★est
10% · 8/78 Questions
You're viewing a preview — the full solution, concept, methods & PYQ mapping are locked.
Start your 14-day free trial to unlock the full solution →Under the Weighted Average method, a new issue rate is calculated after each receipt as total value of stock ÷ total quantity of stock, and that rate is used to price every issue until the next receipt.
Stores Ledger Account (Weighted Average method)
| Date | Receipts Qty | Receipts Rate ₹ | Receipts Amt ₹ | Issues Qty | Issues Rate ₹ | Issues Amt ₹ | Balance Qty | Balance Amt ₹ |
|---|---|---|---|---|---|---|---|---|
| Mar 1 | — | — | — | — | — | — | 100 | 2,000 |
| Mar 5 | 300 | 24 | 7,200 | — | — | — | 400 | 9,200 |
| Mar 10 | — | — | — | 200 | 23 | 4,600 | 200 | 4,600 |
| Mar 15 | 200 | 27 | 5,400 | — | — | — | 400 | 10,000 |
| Mar 20 | — | — | — | 300 | 25 | 7,500 | 100 | 2,500 |
| Mar 25 | — | — | — | 50 | 25 | 1,250 | 50 | 1,250 |
Working of the average rates:
- After Mar 5: total value = ₹2,000 + ₹7,200 = ₹9,200; total quantity = 400 units; rate = ₹9,200 ÷ 400 = ₹23. Mar 10 issue = 200 × ₹23 = ₹4,600; balance 200 units, ₹4,600.
- After Mar 15: total value = ₹4,600 + ₹5,400 = ₹10,000; total quantity = 400 units; rate = ₹10,000 ÷ 400 = ₹25. Mar 20 issue = 300 × ₹25 = ₹7,500 (balance 100 units, ₹2,500); Mar 25 issue = 50 × ₹25 = ₹1,250 (balance 50 units, ₹1,250). …
Unlock everything free for 14 days
- Full step-by-step solutions
- Concept-first explanations
- Methods, shortcuts & mistakes
- PYQ mapping + timed mock tests
Full access for 14 days. No credit card required.