Weighted Average Cost Calculator

About the Weighted Average Cost Calculator

The Weighted Average Cost (WAC) method calculates a single blended cost per unit by dividing the total cost of goods available for sale by the total number of units available. This average cost is then applied to both COGS and ending inventory, eliminating the need to track individual cost layers.

WAC is popular because of its simplicity and is accepted under both US GAAP and IFRS. It smooths out price fluctuations, providing a stable cost per unit that avoids the extremes of FIFO (low COGS in inflation) and LIFO (high COGS in inflation).

This calculator lets you enter multiple purchase lots and units sold. It computes the weighted average cost per unit, COGS, and ending inventory value — saving time compared to working by hand.

Use the result to compare operating scenarios, pressure-test assumptions, and rerun the model when volumes, rates, or service targets change.

When This Page Helps

WAC is the simplest costing method to administer. It requires no tracking of individual cost layers and produces results that fall between FIFO and LIFO. This calculator quickly produces the blended cost per unit, COGS, and ending inventory from your purchase data.

How to Use the Inputs

1. Enter the quantity and unit cost for each purchase lot (up to three lots).
2. Enter the total number of units sold during the period.
3. Review the weighted average cost per unit.
4. Check the COGS based on the average cost.
5. Check the ending inventory value.
6. Use the results for journal entries or financial statement preparation.

Example Calculation

Tips & Best Practices

• Recalculate the weighted average after every new purchase for perpetual systems.
• WAC produces results between FIFO and LIFO, making it a moderate choice for financial reporting.
• WAC is easiest to maintain and reduces bookkeeping complexity for high-volume businesses.
• Be aware that WAC smooths out cost spikes, which may mask price trends you need to track.
• WAC is accepted under both US GAAP and IFRS, making it suitable for multinational companies.
• Compare WAC results to FIFO periodically to understand the impact on reported income.

Periodic vs Perpetual WAC

In a periodic system, WAC is calculated once at the end of the period using all purchases. In a perpetual system, the average is recalculated after each purchase, and COGS is recorded at the running average. Perpetual WAC produces slightly different results than periodic WAC due to the timing of recalculations.

WAC for High-Volume Businesses

Businesses with thousands of transactions and similar-cost items (e.g., commodity goods, fasteners, chemicals) find WAC the most practical method. The administrative simplicity of a single average cost per SKU reduces accounting labor and audit risk.

Comparing WAC to Other Methods

In a rising price environment, WAC COGS falls between FIFO (lowest COGS) and LIFO (highest COGS). This makes WAC a balanced choice that avoids the extreme tax effects of LIFO while providing a more realistic COGS than FIFO.

Frequently Asked Questions

• What is the weighted average cost method?

  The WAC method divides the total cost of all inventory available for sale by the total number of units available. This blended cost per unit is used for both COGS and ending inventory valuation.

• How does WAC differ from simple average?

  A simple average adds up unit costs and divides by the number of lots. WAC weights each lot by its quantity, giving larger lots proportionally more influence on the average. WAC is the correct method for inventory costing.

• When is WAC recalculated in a perpetual system?

  In a perpetual weighted average system, the average cost is recalculated every time a new purchase is received. Sales between purchases use the most recently calculated average cost.

• Is WAC accepted under IFRS?

  Yes. IFRS allows both FIFO and weighted average cost. LIFO is prohibited under IFRS, making WAC the primary alternative to FIFO for international companies.

• What are the disadvantages of WAC?

  WAC smooths cost variations, which can obscure price trends. In rapidly changing price environments, it may not accurately reflect the cost to replace inventory or the most recent acquisition costs.

• Can WAC be used for tax reporting?

  Yes. WAC is an accepted inventory costing method for tax purposes under both US and international tax regulations. It provides a middle-ground tax outcome between FIFO and LIFO.