Weighted Average Cost Method: Formula & Example (India)

6 min read

By

TranZact Solutions Team

· Published

Hero Background
Functions of ERP System Explained

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
  1. Take opening units and their value

  2. Add each purchase at ex-GST cost

  3. Add freight inward to purchase cost

  4. Divide total value by total units

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

Book a demo →

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.

Book a demo →

Check out other blogs

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders

Hero Background
Become the
AI-Run Factory

Born in India. Building for the world.

Built by IIT & IIM founders