Aller au contenu

Weighted average cost: how to value your inventory correctly

The value of your inventory determines two important figures: the stock shown on the balance sheet and the cost of goods sold that reduces your profit. A valuation error distorts both at once. Among the accepted methods, weighted average cost is the one most small businesses use, because it is simple to apply and stable over time. It still has to be calculated correctly.

The principle

With weighted average cost, every unit in stock has the same cost: the total cost of the units available divided by their number. When you buy new units at a different price, the average cost is recalculated. When you sell, units leave at the current average cost.

The formula, under a perpetual inventory system, is:

New average cost = (value of existing stock + cost of new purchase) ÷ (existing quantity + quantity purchased)

« Weighted » means that each purchase price counts in proportion to the quantity purchased. A small purchase at a high price barely moves the average. A large purchase moves it a lot.

A worked example

A business sells a single item. Here are its movements for the month.

DateMovementQuantityUnit costValueStock (qty)Stock (value)Average cost
1stOpening stock100$10.00$1,000.00100$1,000.00$10.00
8thPurchase (50 × $13.00 + $75 freight)50$14.50$725.00150$1,725.00$11.50
15thSale−80$11.50−$920.0070$805.00$11.50
22ndPurchase30$12.00$360.00100$1,165.00$11.65
28thSale−40$11.65−$466.0060$699.00$11.65

Three points deserve attention.

  • On the 8th, the $75 freight is added to the cost of the purchase. The real unit cost is $14.50, not $13.00.
  • On the 15th, the sale of 80 units leaves at the average cost of $11.50. The cost of goods sold is $920.00.
  • On the 22nd, the new purchase at $12.00 brings the average cost to $11.65 ($1,165.00 ÷ 100).

At month-end, stock is worth $699.00 and cost of goods sold totals $1,386.00 ($920.00 + $466.00). Check: $1,000.00 + $725.00 + $360.00 − $1,386.00 = $699.00.

What is part of cost

The cost of an item in stock is not limited to the price paid to the supplier. Under the accounting standards for private enterprises, it includes purchase costs and the other costs incurred to bring the inventory to its present location and condition.

In practice, it generally includes:

  • the purchase price, net of discounts and rebates received;
  • inbound freight and delivery charges;
  • customs duties and brokerage fees on imports;
  • non-recoverable taxes.

These costs added to the purchase price are called landed costs. Leaving them out understates stock and overstates the margin on the first sales, then understates it later.

Not part of cost: storage costs after receipt (unless they are necessary to the production process), administrative costs and selling costs. GST and QST recoverable through ITCs and ITRs are not part of it either.

Landed costs that arrive late

It happens often: goods are received on the 8th, but the carrier’s or customs broker’s invoice arrives three weeks later. In the meantime, part of the lot has already been sold.

Two approaches are possible. The more precise one spreads the costs over the units of the lot and adjusts the average cost of the units still in stock. The simpler one, acceptable when the amounts are small, adds them to stock when they are received. What matters is choosing one approach and applying it consistently.

When one shipment covers several items, the costs must be allocated among them. Allocation is usually based on value, weight or volume. Choose the basis that best reflects what caused the cost.

Returns

Customer return. The item comes back into stock at the cost at which it left, not at the average cost on the day of the return. Otherwise, the cost of goods sold of the original sale is not properly reversed.

Return to a supplier. The item leaves stock at its purchase cost, and the supplier’s credit note reduces the value of stock by the same amount. If the credit note price differs from the average cost, the difference must be dealt with, not left in stock.

The lower of cost and net realizable value

Average cost is not a guaranteed floor. If an item can only be sold for less than its cost, because it is damaged, obsolete or its market price has dropped, the stock must be valued at its net realizable value. That value is the estimated selling price, less the estimated costs to complete the sale.

Do this review at least at the end of every fiscal year, starting with items that have not moved for a long time. An inventory turnover report is a good starting point.

Counts

The best valuation method does not fix stock that is wrong in quantity. Differences between book stock and actual stock come from losses, theft, receiving errors or data entry errors. A physical count at least once a year, and cycle counts on high-value items, keep quantities reliable. Differences found are adjusted at average cost.

Lots and serial numbers

For items tracked by lot or serial number, such as perishable products or equipment, you need to know which unit was sold to which customer. Weighted average cost remains compatible with this tracking: traceability concerns the identity of units, valuation concerns their cost.

In BooksMatic

With the Growth plan, BooksMatic manages inventory and purchase orders at weighted average cost, with lots and serial numbers, landed costs and reorder alerts. The Premium plan’s advanced financial analysis adds inventory turnover.

This article is for information only. Choosing a valuation method and applying it to your situation should be confirmed with your accountant.

Essayez avec votre vraie comptabilité

Créez votre compte, importez votre balance et voyez vos états financiers se construire.

30 jours d'essai gratuit · Annulation en tout temps