Weighted average inventory cost, explained with an example

· 4 min read

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:

Item movements at moving weighted average cost (illustrative figures, SAR)
MovementQuantityUnit costValueBalance afterAverage cost
Opening balance10010.001,000.00100 units = 1,000.0010.00
Purchase5013.00650.00150 units = 1,650.0011.00
Sale-6011.00-660.0090 units = 990.0011.00
Purchase3012.20366.00120 units = 1,356.0011.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.

See AlMuraji run operations like yours

Tell us about your business and the modules you care about, and we will arrange a demo.