Inventory valuation using average cost of all units in stock
The Weighted Average Cost method is an inventory valuation technique that calculates the average cost per unit by dividing the total cost of all goods available for sale by the total number of units available. Every time a new purchase is made, the average cost per unit is recalculated. This method is permitted under Indian Accounting Standards (Ind AS) and is popular among Indian businesses because of its simplicity. Unlike FIFO, it does not require tracking individual batches, making it easier to implement in small businesses with high-volume, low-value items. The weighted average method smooths out price fluctuations over time, providing a more stable cost figure for goods sold. It is especially useful for businesses that deal in fungible goods like grains, chemicals, or hardware items where individual units are indistinguishable from one another.
You own a stationery shop. On 1st June, you buy 200 notebooks at Rs. 40 each (total Rs. 8,000). On 15th June, you buy another 300 notebooks at Rs. 50 each (total Rs. 15,000). Your weighted average cost = (Rs. 8,000 + Rs. 15,000) / (200 + 300) = Rs. 23,000 / 500 = Rs. 46 per notebook. If you sell 150 notebooks, your COGS = 150 x Rs. 46 = Rs. 6,900, and remaining stock value = 350 x Rs. 46 = Rs. 16,100.
Weighted Average Cost = Total Cost of Inventory / Total Units in StockExample: If you bought 200 units at ₹40 each (₹8,000) and 300 units at ₹50 each (₹15,000), then Weighted Average Cost = (₹8,000 + ₹15,000) / (200 + 300) = ₹23,000 / 500 = ₹46 per unit.
Weighted average is simpler and works best for fungible items like grains, chemicals, hardware, or stationery where individual units are interchangeable. FIFO is better for perishable goods or items with batch-specific expiry dates where you need to track which batch was sold first.
Yes, the weighted average cost is recalculated every time you make a new purchase at a different price. For example, if your current average is ₹46 and you buy a new batch at ₹55, the new average will increase to somewhere between ₹46 and ₹55 depending on the quantities.
Yes, the weighted average method is accepted under Indian Accounting Standards (Ind AS 2) and is valid for both GST and income tax purposes. However, once you choose a method, you must apply it consistently across financial years.
Manage inventory, billing, and accounting effortlessly.