4.5 Valuation of inventory (3)
Resources |
Revision Questions |
Accounting
Login to see all questions
Click on a question to view the answer
1.
A company has the following inventory balances: Opening Inventory: £12,000; Purchases: £35,000; Closing Inventory: £18,000. Calculate the Cost of Goods Sold (COGS) using two different inventory valuation methods: FIFO and Weighted Average. Explain which method is generally preferred and why.
FIFO (First-In, First-Out):
- Assume the opening inventory was purchased at the beginning of the period.
- The £35,000 in purchases are assumed to be sold from the opening inventory first.
- This leaves £35,000 - £12,000 = £23,000 of purchases to be sold.
- The remaining £18,000 of closing inventory represents the purchases made last.
- Therefore, COGS = £12,000 + £23,000 = £35,000.
Weighted Average Method:
- Calculate the total cost of goods available for sale: Opening Inventory + Purchases = £12,000 + £35,000 = £47,000
- Calculate the number of units available for sale (assuming each unit has the same cost): We need to know the number of units. Let's assume each unit costs £10. Then, the total number of units available is £47,000 / £10 = 4700 units.
- Calculate the weighted average cost per unit: £47,000 / 4700 units = £10 per unit.
- COGS = Weighted Average Cost per Unit * Number of Units Sold. We don't know the number of units sold, so we can't calculate the exact COGS. However, if we assume all the inventory was sold, COGS would be £47,000. If we assume the closing inventory represents the unsold units, we need to calculate how many units are in the closing inventory. Since the closing inventory is £18,000 and each unit costs £10, there are 1800 units in the closing inventory. Therefore, the number of units sold is 4700 - 1800 = 2900 units. COGS = £10 * 2900 = £29,000.
Generally Preferred Method:
The FIFO method is generally preferred because it more accurately reflects the flow of inventory. It assumes that the oldest inventory is sold first, which is usually the case. This provides a more realistic view of the company's current inventory value on the balance sheet. The Weighted Average method can distort the true cost of goods sold, especially if there are significant fluctuations in purchase prices.
2.
ABC Ltd holds a batch of widgets that cost £12,000. Market research indicates that these widgets can now be sold for £10,000. Explain, with reference to IAS 2, why ABC Ltd should apply the lower of cost and net realisable value (LCNRV) method to value this inventory. State the accounting treatment involved.
Explanation: IAS 2, Inventory, requires that inventory be valued at the lower of cost and net realisable value (LCNRV). This principle is based on the matching principle, which aims to match expenses with revenues. If the cost of the inventory exceeds its net realisable value, it indicates that the inventory has likely declined in value due to obsolescence, damage, or a decrease in market demand. Therefore, it's prudent to reflect this decline in the financial statements. Applying LCNRV ensures that the carrying value of the inventory does not exceed its recoverable amount.
Accounting Treatment:
- Calculate the net realisable value (NRV) by subtracting the estimated costs of completion and disposal from the selling price.
- Compare the cost (£12,000) with the net realisable value (£10,000).
- Since the cost (£12,000) is greater than the NRV (£10,000), the inventory should be written down to its NRV.
- This will result in an impairment loss of £2,000 (£12,000 - £10,000).
- The inventory should be revalued to £10,000 on the statement of financial position.
- The impairment loss should be recognised in the profit and loss account.
3.
Question 1
On 1 January 2023, the opening inventory for ABC Retail was valued at £12,000. During the year, purchases amounted to £25,000 and closing inventory was valued at £9,000. Prepare a simple inventory valuation statement as at 31 December 2023.
Inventory Valuation Statement as at 31 December 2023
Opening Inventory | £12,000 |
Add: Purchases | £25,000 |
Less: Closing Inventory | £9,000 |
Total Inventory Valuation | £28,000 |