Weighted Average Cost Calculator

What Is Weighted Average Cost?

Buy the same item three times at three prices and you hold one pile of identical units bought at a mix of costs. Weighted average cost answers the only question that pile can answer: what did a single unit cost, on average, once quantity is taken into account?

The word doing the work is weighted. A price paid on 500 units is not one price among three — it is 500 prices. Averaging $10, $12 and $14 to $12.00 throws that away. Weighting each price by the quantity bought at it keeps it.

It is also called average cost, AVCO, or the average cost method when applied to stock. The same arithmetic values inventory, prices a share portfolio built over several purchases, costs raw materials bought on different invoices, and sets a transfer price for interchangeable goods.

• Inventory. Costing units sold and units still on the shelf.
• Investing. The average cost basis of a holding accumulated over several buys.
• Manufacturing. The cost of a raw material drawn from batches bought at different prices.
• Procurement. The real unit price paid across suppliers, once volumes differ.

One property is worth fixing early: the weighted average cost always sits between the cheapest and the dearest price you paid, and lands nearer whichever price carried the most units. The same weighting principle powers the general weighted average calculator.

How to Use the Weighted Average Cost Calculator

Enter the Quantity and Cost of Each Purchase

Each row is one purchase. Give it a description if you want the breakdown to read clearly — March purchase, PO 4471, Supplier B — then the quantity bought and what it cost. Both number fields accept commas, decimals and a currency symbol, so figures pasted from a spreadsheet or an invoice go straight in.

The switch above the table decides what the cost column means, and it is the control most worth knowing about:

• Cost per unit — the price you paid for one unit. The calculator multiplies it by the quantity.
• Total cost — the amount paid for that whole purchase. The calculator divides it by the quantity to recover the unit price.
• Add purchase adds another row, and the Enter key on the last row does the same.
• Currency sets the symbol on every figure; Decimals shows the average to 2, 3 or 4 places.
• Load example fills in the 100 / 200 / 150 unit example above so you can see a completed calculation.

Use total cost mode when your records show invoice totals rather than unit prices. It saves a division on every line and avoids the rounding that creeps in when a unit price is derived by hand — an $850 invoice for 63 units is $13.4921, and typing $13.49 loses money at scale.

Calculate the Total Quantity and Total Cost

Both totals are reported beside the result, and they are the two halves of the formula. Total quantity is the sum of the quantity column; total cost is the sum of every line amount, whichever mode you entered it in.

They are also the fastest check on your inputs. If the total quantity does not match the units you know you bought, a row is missing or a quantity has an extra digit — a problem far easier to see in the total than in the average, where a bad line only nudges the answer.

The bar underneath shows how the total cost splits between the purchases, which is worth a glance when one supplier turns out to account for most of what you spent.

Calculate the Weighted Average Cost

The large figure is total cost ÷ total quantity: the weighted average cost per unit. Below it, a note compares that figure to the simple average of the prices and says which way the quantities pushed it, so you can see at once whether your larger purchases were the cheap ones or the expensive ones.

• Adds, on each row, is that purchase's share of the quantity multiplied by its unit price — the currency it contributes to the average. These add up to the average exactly.
• Simple average counts every price once, ignoring quantity, and is shown only for comparison.
• Value a quantity multiplies any quantity you enter by the average cost — the calculation behind an inventory valuation.
• Copy step-by-step breakdown puts every line, both totals and the division into your clipboard for a workpaper or an email.

If a row is only half filled, the calculator says so rather than quietly dropping it, because a purchase counted in the quantity but not the cost is the single most common way a weighted average comes out too low.

Periodic vs. Perpetual Weighted Average Cost

Periodic Weighted Average Cost

Everything is pooled first and costed afterwards. The $12.2222 average covers all 450 units whenever they arrived, and every unit sold in the period is charged at that rate. This is the calculation on this page: one set of purchases, one average.

It needs only period totals, which suits a business that counts stock at period end rather than tracking it continuously. It is also the version you can compute by hand in a minute, which is why it is the one taught first.

Perpetual Weighted Average Cost

The average is recomputed the moment new stock arrives, and each sale is costed at whatever the average happens to be on that date. Sales matter here, and so does order.

Cost of goods sold becomes $3,577.78 rather than $3,666.67, and ending inventory $1,922.22 rather than $1,833.33. The first 180 units were sold before the dearer April stock arrived, and perpetual costing records that; periodic costing charges them with an average that includes it.

The gap is $88.89 on a $5,500 pool here, and it widens as prices move faster. Neither figure is wrong — they answer slightly different questions — but the policy has to be stated and applied consistently.

Advantages and Limitations of Weighted Average Cost

Advantages of Weighted Average Cost

• Simple to operate. Two totals produce the cost, with no layers to track and no history per unit.
• Smooths price volatility. A spike is spread across every unit instead of landing on one month's margin.
• Hard to game. Timing a purchase near period end barely moves the average, while it can shift a LIFO figure sharply.
• Accepted everywhere. Permitted under both IFRS and US GAAP.
• Fits interchangeable goods. When units are identical, tracking which one sold adds cost and no information.
• Recomputable at any time. Because order is irrelevant under periodic costing, the figure can be rebuilt from records alone.

Limitations of Weighted Average Cost

• No unit matches its real cost. Every unit is valued at a figure that may appear on no invoice you hold.
• Closing stock lags the market. Old low costs stay in the average long after prices have moved on.
• Recalculation burden under perpetual costing. Every purchase changes the average, which is impractical by hand.
• Wrong for unique items. Serialised, bespoke or high-value goods need specific identification, not an average.
• Two answers from one dataset. Periodic and perpetual disagree, so the policy must be documented and applied consistently.
• Hides supplier differences. A single blended figure can conceal that one supplier is 30% dearer than another.

The last point is the one worth acting on. The average is the right number for the accounts and the wrong number for a purchasing conversation — for that, read the per-purchase contribution column, where each supplier's price and volume are still visible.

Common Weighted Average Cost Calculation Mistakes

1. Averaging the prices. $10, $12 and $14 average to $12.00, not the correct $12.2222. Every price must be weighted by the quantity bought at it.
2. Leaving out opening stock. Units carried in are part of the pool and belong in both totals, at the cost they carry.
3. Mixing unit costs and invoice totals in one column. One row entered as a total among rows entered per unit corrupts the whole average. Pick a mode and stay in it.
4. Counting a quantity without its cost. A half-filled row inflates the denominator and drags the average down.
5. Forgetting freight, duty and handling. If your policy capitalises them, they belong in the purchase cost before averaging, not in expenses afterwards.
6. Rounding the average too early. Rounding $12.2222 to $12.22 before multiplying by 450 units loses a dollar. Round the result, never the input.
7. Mixing periodic and perpetual. A period-end average applied to perpetual records reconciles to neither method.

Two checks catch nearly all of them. The average must fall between your lowest and highest unit price, and the total quantity must match the units you know you bought. The calculator prints both figures beside the result for exactly that reason.