The weighted average method calculates inventory cost by dividing the total cost of goods available for sale by the total number of units, giving a single average cost per unit that reflects actual purchase patterns. This also explains the weighted average meaning in inventory valuation, where both price and quantity determine cost.
What is the weighted average formula?
There are two versions of the weighted average formula, depending on how frequently a business updates its stock records.
-
Periodic weighted average
This version calculates a single average cost at the end of the accounting period:
Weighted average cost per unit = Total cost of goods available for sale / Total units available for sale
Closing stock value = Weighted average cost per unit × Units in closing stock
COGS (Cost of Goods Sold) = Weighted average cost per unit × Units sold
-
Moving weighted average (perpetual method)
Here, the average is recalculated after each new purchase, giving a continuously updated cost rate. This version is used when businesses maintain real-time stock records.
Updated cost per unit = (Existing inventory value + New purchase cost) / (Existing units + New units purchased)
How to calculate weighted average: A step-by-step example
Consider a small manufacturing firm in India that purchases raw material in three batches during April 2025:
|
Batch |
Units purchased |
Cost per unit (₹) |
Total cost (₹) |
|
1 |
200 |
50 |
10,000 |
|
2 |
300 |
60 |
18,000 |
|
3 |
100 |
70 |
7,000 |
|
Total |
600 |
35,000 |
Step 1: Calculate the weighted average cost per unit.
Weighted average cost per unit = ₹35,000 / 600 = ₹58.33
Step 2: Suppose the firm sold 400 units during April.
COGS = 400 x ₹58.33 = ₹23,332
Step 3: Value the closing stock of 200 units.
Closing stock value = 200 x ₹58.33 = ₹11,666
Note: COGS + closing stock (₹23,332 + ₹11,666 = ₹34,998) reconciles approximately to the total cost of ₹35,000, with a minor rounding difference. Always verify that these figures balance before finalising your accounts.
Business applications of the weighted average method
The weighted average method is suitable for a range of industries and business situations. Common scenarios where businesses apply it include:
- Homogeneous goods: Businesses dealing in undifferentiated products such as grain, cement, chemicals and textiles find this method practical because individual units cannot be tracked separately.
- High-volume, low-margin trading: Frequent purchases at fluctuating prices are averaged, preventing artificial swings in reported profit from short-term price movements.
- Simplified record-keeping: Businesses using the periodic method need to compute the average only once per period, reducing the administrative burden compared to perpetual FIFO (First In, First Out) tracking.
What are the limitations of the weighted average method?
The method has practical constraints that businesses should consider before adopting it:
- Does not reflect physical flow: It does not track the actual movement of goods, which can matter for perishable or dated products where the oldest stock must be dispatched first.
- Distortion in rising prices: In a persistently rising price environment, weighted average costing results in lower COGS and higher closing stock values than FIFO, which may not reflect economic reality for items such as electronics or pharmaceuticals with short shelf lives.
- Lag in volatile markets: When purchase prices are highly volatile over a short period, the moving weighted average can lag current market rates, particularly under the perpetual method.
Conclusion
The weighted-average formula provides a stable, practical way to value inventory and calculate cost of goods sold without tracking individual batches. Once adopted, the method should be applied uniformly, as changes can affect financial reporting and tax calculations.
Used in the right context, it helps smooth price fluctuations, simplify record-keeping and maintain reliable inventory values across periods.
For businesses that want accuracy without added complexity, TallyPrime supports real-time weighted-average calculations, updates cost per unit with every transaction and helps keep inventory records audit-ready.
