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.
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.