Weighted Average Cost Method: Formula & Example (India)
6 min read
By
TranZact Solutions Team
· Published


Weighted average cost: the short answer
Weighted average cost is the average price of all units of an item you hold, weighted by how many you bought at each price. To find it, divide the total cost of the stock by the total number of units. Total cost means opening stock plus purchases, without GST you can claim back as input credit. In India, AS 2 and Ind AS 2 allow weighted average or FIFO for items that are interchangeable; LIFO is not allowed.
This page is about stock. If you meant the cost of capital (WACC), that is a different finance formula.
The weighted average cost formula
Weighted average cost per unit = (cost of opening stock + cost of purchases) ÷ (opening units + units purchased)
Multiply that rate by the units you issue to production. That gives the cost of material used. The units left, times the same rate, give your closing stock value. Your opening stock is simply last period's closing figure.
What goes into cost:
Purchase price, after trade discounts.
Freight inward and other costs to bring material to your store.
Duties and taxes you cannot recover.
GST you claim as input tax credit stays out. It is not a cost to you.
How to work out weighted average cost
Take opening units and their value
Add each purchase at ex-GST cost
Add freight inward to purchase cost
Divide total value by total units
Apply rate to issues and closing stock
Worked example: steel sheet in a fabrication unit (periodic method)
Say a fabrication unit buys CRCA steel sheet twice in a month. All rates are before GST, because the GST is claimed as input credit. The numbers are illustrative.
Line | Kg | Rate (₹/kg) | Value (₹) |
|---|---|---|---|
Opening stock | 2,000 | 60 | 1,20,000 |
Purchase 1 | 3,000 | 64 | 1,92,000 |
Purchase 2 (incl. ₹2,000 freight) | 1,000 | 66 | 66,000 |
Total | 6,000 | 63 | 3,78,000 |
Purchase 2 was ₹64/kg on the invoice, or ₹64,000. Freight inward of ₹2,000 brings it to ₹66,000, which is ₹66/kg. The GST on that invoice stays out.
Weighted average cost = ₹3,78,000 ÷ 6,000 kg = ₹63 per kg. Say 4,500 kg went to production. Material used = 4,500 × ₹63 = ₹2,83,500. Closing stock = 1,500 kg × ₹63 = ₹94,500.
Moving (perpetual) weighted average: recalculate after every purchase
The periodic method works out one rate at the end of the period. The moving method works out a new rate after every purchase. Each issue is costed at the rate on that day.
Here is the same month, with issues in between.
Step | Kg in stock | Rate (₹/kg) | Stock value (₹) |
|---|---|---|---|
Opening stock | 2,000 | 60.00 | 1,20,000 |
Buy 3,000 kg at ₹64 | 5,000 | 62.40 | 3,12,000 |
Issue 3,000 kg to production | 2,000 | 62.40 | 1,24,800 |
Buy 1,000 kg at ₹66 | 3,000 | 63.60 | 1,90,800 |
Issue 1,500 kg to production | 1,500 | 63.60 | 95,400 |
Material used = ₹1,87,200 + ₹95,400 = ₹2,82,600. Closing stock is ₹95,400. That is ₹900 more than the periodic method, from the same purchases.
Moving average fits if you buy and issue often and want stock value every day. Periodic fits if you close monthly with few transactions.
Periodic vs moving weighted average
Periodic average | Moving average | |
|---|---|---|
Rate worked out | Once, at period end | After every purchase |
Suits | Monthly close, few entries | Frequent buying and issuing |
Stock value known | At period end | Every day |
Issue costing | One rate for the period | Rate on the issue date |
Weighted average vs FIFO: which should a factory use?
FIFO (first in, first out) issues the oldest stock first. Here is the same month, with 4,500 kg issued, under each method.
Method | Cost of 4,500 kg issued (₹) | Closing stock, 1,500 kg (₹) |
|---|---|---|
FIFO | 2,80,000 | 98,000 |
Weighted average (periodic) | 2,83,500 | 94,500 |
Moving average | 2,82,600 | 95,400 |
When prices rise, FIFO issues older, cheaper stock first. So it shows a lower cost of material used and a higher closing stock value. When prices fall, the gap flips.
Choose weighted average when you buy the same item often at changing prices, and tracking each lot is a burden. Choose FIFO when cost must follow the physical lots.
How TranZact tracks stock value for a manufacturer
Whichever method you pick, the formula is easy. Keeping every receipt and issue entered on time, across stores and hundreds of items, is where spreadsheets break.
TranZact's manufacturing AI software covers stock in, bin card, issue and multi-store in its inventory management. A photo of a paper entry becomes a system entry, with no typing. Reorder and AI stock alerts are built in. System stock and physical stock always match.
Inventory Ageing & Valuation, Production Costing, and multi-step BOM and production are on every plan from Grow. Grow is ₹8,333/month billed yearly, with 4 users. Scale+ adds batch-wise stock tracking. See all plans and prices.
Accounting stays in Tally, Busy or Zoho Books. TranZact syncs one-way to your accounts, with no double entry. Your valuation policy stays a decision for you and your CA.
10,000+ manufacturers use TranZact. It goes live in 2–3 weeks.
Indian rules you must follow (AS 2 and Ind AS 2)
For items that are interchangeable, use only FIFO or weighted average.
For items that are not interchangeable, or are kept for a particular job, use specific identification.
LIFO is not allowed.
Use the same formula for all stock of a similar nature and use.
Value stock at the lower of cost and net realisable value. If it can sell for less than cost, write it down.
These are the main points, not the full standard. Check the policy for your company with your CA.
Raw material vs finished goods
Raw material is valued at purchase cost only. WIP and finished goods also carry direct labour and production overheads, based on normal capacity. Selling costs and abnormal wastage stay out. Our guide to production costs explains direct and indirect costs.
Weighted average vs standard cost
Standard cost is a planned rate you set in advance, such as ₹62/kg for the year. Weighted average comes from the prices you actually paid. Standard cost helps with budgets and quotes, and the gap to actual cost shows where prices moved.
Common mistakes
Including GST you claim back. It inflates the rate and the stock value.
Leaving out freight inward. Material then looks cheaper than it was.
Not updating after purchase returns. Take the returned units and their cost out, then work out the rate again.
Issuing stock that isn't in the system yet. Negative stock breaks the moving average.
Mixing methods across similar items. Use one method for all your steel sheet.
Weighted average cost is simple maths on correct numbers. The hard part is getting every receipt and issue into the system on time. See it on your own items. Don't be the bottleneck. Become the AI-Run Factory.




