Qees business tools › Lessons › Inventory & purchasing

How to value inventory with weighted average cost

When you buy the same product at different prices, what did the unit you sold today cost? The weighted average method gives the simplest answer that works for day-to-day management.

The method

Average cost = (value on hand + value of the new purchase) ÷ (units on hand + new units)

Example: you have 100 units at 10 = 1,000, then buy 50 units at 13 = 650. Average = 1,650 ÷ 150 = 11 a unit, and the stock is worth 1,650.

You sell 30 units: cost of goods sold = 30 × 11 = 330, leaving 120 units worth 1,320. Selling does not change the average; only buying at a different price does.

What goes into cost?

  • The purchase price after discount.
  • Shipping, customs and other direct purchase costs, spread over the items.
  • Tax only if you cannot recover it.

Compared with FIFO

With FIFO (first in, first out) the units sold come from the oldest batch: 30 × 10 = 300 instead of 330. Over time the total cost is the same, but how it falls between periods differs. Qees uses weighted average and keeps the cost of every movement, so FIFO can be added later without changing the history.

Gross profit is not net profit

Gross profit = sales − cost of goods sold. Net profit also takes away rent, salaries, marketing and the rest.

Apply it to your stock. Qees Inventory & Procurement works out reorder points, suggested quantities, stock value and ABC classes from your real movements.

See the product Try it with sample data

Frequently asked questions

Which method does the tax authority accept in my country?

It depends on the country. Weighted average is accepted in many systems, but check with your accountant or tax authority.

Does moving stock between warehouses change its value?

No. A transfer moves the units and their value from one warehouse to another; the company total does not change.