Weighted average inventory cost, explained with an example
Moving weighted average is an inventory valuation method that recalculates unit cost after every receipt and issues each quantity at the cost in force when it leaves. This guide works through an example and shows the effect on cost of sales.
The idea in short
On every new receipt, the value of the current balance is added to the value received and divided by the total quantity. The result is the new unit cost, and every issue uses it until the next receipt.
Worked example
The figures below are illustrative, for one item in one warehouse:
| Movement | Quantity | Unit cost | Value | Balance after | Average cost |
|---|---|---|---|---|---|
| Opening balance | 100 | 10.00 | 1,000.00 | 100 units = 1,000.00 | 10.00 |
| Purchase | 50 | 13.00 | 650.00 | 150 units = 1,650.00 | 11.00 |
| Sale | -60 | 11.00 | -660.00 | 90 units = 990.00 | 11.00 |
| Purchase | 30 | 12.20 | 366.00 | 120 units = 1,356.00 | 11.30 |
Effect on cost of sales
In the example, the sixty units sold cost SAR 660 because average cost at the time of sale was 11.00. The cost entry is: debit cost of sales 660, credit inventory 660, alongside the revenue and VAT entry.
What goes into purchase cost
The supplier price plus direct import costs such as freight and clearance when they are spread onto the items, which raises the unit cost received and moves the average with it.
Common mistakes
- Using a single average for the whole year instead of recalculating on each receipt.
- Booking freight as a direct expense, so it never reaches item cost.
- Inventory value in the stock report differing from the inventory account in the books.