Forums › Ask ACCA Tutor Forums › Ask the Tutor ACCA MA – FIA FMA › Weighted average
- This topic has 4 replies, 2 voices, and was last updated 5 years ago by John Moffat.
- AuthorPosts
- October 9, 2019 at 6:19 pm #548528
A wholesaler had opening inventory of 300 units of product Emm valued at $25 per unit at the beginning of January. The following receipts and sales were recorded during January.
Date 2 Jan 12 Jan 21 Jan 29 Jan
400
Issues 250 200 75
The purchase cost of receipts was $25.75 per unit. Using a weighted average method of valuation,calculate the value of closing inventory at the end of January.Answer)4492
Sir can you help me out with this question? I cant seem to figure out the workings for this even after applying your formula.
October 9, 2019 at 6:23 pm #5485292 Jan 400 (receipts)
12 jan 250 (issues)
21 jan 200 (I)
29 Jan 75(I)this is the table for the question**
October 10, 2019 at 8:04 am #548560The started with 300 units at $25 each, so a total of $7,500.
They bought another 400 units at $25.75 each, so a total of $10,300.So in total they now have 700 units at a total cost of $17,800.
There are no more purchases, and so all the issues are at an average cost of $17,800/700 = $25.43 per unit.
The closing inventory is 700 – 250 – 200 – 75 = 175 units.
They are therefore valued at 175 x $25.43 = $4,450.
(The answer is your book is different simply because of roundings which does not matter in the exam)
October 10, 2019 at 11:48 am #548613Thank you very much!
October 10, 2019 at 3:15 pm #548675You are welcome 🙂
- AuthorPosts
- You must be logged in to reply to this topic.