Weighted Average Inventory

Enter your inventory purchase lots to calculate weighted average cost per unit, ending inventory value, and cost of goods sold.

Purchase Lots

Total units sold during the period.

Results

Add purchase lots and click Calculate to see results.

Summary

Enter your inventory purchase lots to calculate weighted average cost per unit, ending inventory value, and cost of goods sold.

How it works

  1. Add each inventory purchase lot: a label, quantity purchased, and unit cost.
  2. Enter the number of units sold during the period.
  3. Click "Calculate" to compute the weighted average cost per unit.
  4. The tool multiplies units sold by the average cost to get cost of goods sold (COGS).
  5. Remaining units are multiplied by the average cost to get ending inventory value.
  6. Review the lot breakdown table and the summary totals.

Use cases

  • Value ending inventory on a balance sheet using the AVCO method.
  • Compute COGS for an income statement when using weighted average costing.
  • Compare AVCO results against FIFO and LIFO to choose a costing method.
  • Verify manually computed weighted average figures before filing financial statements.
  • Teach or study the weighted average cost method with a clear lot breakdown.
  • Estimate tax liability under the average cost inventory method.

Frequently Asked Questions

Last updated: 2026-06-11 · Reviewed by Nham Vu