Skip to content
Embed

Paste this on your site. The attribution link is required and is what makes embedding free.

Average Cost Calculator — Free Online Cost Tool

Calculate the weighted average cost per unit when you have multiple purchases at different prices.

Weighted Average

The average cost per unit is weighted by quantity. Larger purchases at lower prices pull the average down more than small purchases at higher prices.

Average Cost Results

Average Cost Per Unit$11.25
Total Cost$4,500.00
Total Quantity400
Number of Purchases3

Cost Distribution by Purchase

Item 1 (100 @ $12.50): 27.8%Item 2 (250 @ $10.00): 55.6%Item 3 (50 @ $15.00): 16.7%
Item 1 (100 @ $12.50)27.8%
Item 2 (250 @ $10.00)55.6%
Item 3 (50 @ $15.00)16.7%

Average Cost Reference Table

Scenario Total Qty Total Cost Avg Cost Simple Avg
100 @ $5 + 200 @ $4 300 $1,300 $4.33 $4.50
50 @ $12 + 150 @ $10 200 $2,100 $10.50 $11.00
500 @ $2 + 100 @ $3 600 $1,300 $2.17 $2.50
1000 @ $0.50 + 200 @ $0.80 1,200 $660 $0.55 $0.65
25 @ $100 + 75 @ $80 100 $8,500 $85.00 $90.00
300 @ $15 + 300 @ $18 + 300 @ $12 900 $13,500 $15.00 $15.00

Related Calculators

About this calculator

Understanding the Weighted Average Cost Formula

The weighted average cost formula accounts for both the quantity and price of each purchase, producing a single cost-per-unit figure that accurately represents your true average acquisition cost. This is the standard method used in inventory accounting and portfolio cost basis calculations.

Weighted Average Cost = Total Cost / Total Quantity

Total Cost = ∑(Quantityi × Unit Costi)

Total Quantity = ∑(Quantityi)

Where each variable represents:

  • Quantityi = Number of units in purchase batch i
  • Unit Costi = Cost per unit for purchase batch i
  • Total Cost = Sum of all purchase subtotals across all batches
  • Total Quantity = Sum of all units purchased across all batches
  • Weighted Average Cost = The true average cost per unit considering quantity weights

Step-by-Step Calculation Example

A coffee shop owner purchases coffee beans from different suppliers at varying prices. Calculate the weighted average cost per pound:

  1. Purchase 1: 50 lbs at $8.00/lb = $400.00
  2. Purchase 2: 120 lbs at $7.20/lb = $864.00
  3. Purchase 3: 30 lbs at $9.50/lb = $285.00
  4. Total cost: $400 + $864 + $285 = $1,549.00
  5. Total quantity: 50 + 120 + 30 = 200 lbs
  6. Weighted average: $1,549 / 200 = $7.745/lb

Note that the simple average of the three unit costs would be ($8.00 + $7.20 + $9.50) / 3 = $8.23/lb. The weighted average is significantly lower at $7.745/lb because the largest purchase (120 lbs) was at the lowest price ($7.20). The weighted average more accurately reflects the shop's true cost basis and should be used for pricing menu items and calculating cost of goods sold.

Why Simple Average is Wrong

A simple (unweighted) average treats all prices equally regardless of quantity. If you bought 1 unit at $100 and 999 units at $1, a simple average gives ($100 + $1) / 2 = $50.50. The weighted average correctly gives (1 × $100 + 999 × $1) / 1000 = $1.099 per unit. The simple average wildly overstates your actual cost. For any inventory or investment analysis, always use the weighted average when quantities differ across purchase batches.

Sources

  • U.S. Small Business Administration — Business Guide: sba.gov
  • U.S. Bureau of Labor Statistics — Occupational Employment and Wages: bls.gov
  • U.S. Securities and Exchange Commission — Investor Publications: sec.gov

Disclaimer: This calculator is for informational purposes only and does not constitute financial advice. Consult a qualified financial advisor before making financial decisions.

Last updated: November 3, 2026