Understanding how to calculate the weighted average cost (WAC) per unit is essential for business owners, accountants, and investors. Unlike a simple average, the weighted average accounts for the relative importance of each batch of inventory purchased at different prices.
Weighted Average Cost Calculator
Enter the quantity and unit cost for each batch of inventory or purchase.
What is Weighted Average Cost?
The weighted average cost method is an inventory valuation technique used to assign a cost to inventory items based on the total cost of goods available for sale divided by the total number of units available for sale. This method is particularly useful when inventory items are so intertwined or identical that it is difficult to assign a specific cost to an individual unit.
The Weighted Average Cost Formula
The formula for calculating the weighted average cost per unit is straightforward:
Where:
- Total Cost of Inventory: (Batch 1 Qty × Batch 1 Price) + (Batch 2 Qty × Batch 2 Price) + ...
- Total Number of Units: Sum of all quantities across all batches.
Step-by-Step Calculation Guide
To find the weighted average cost, follow these four steps:
Step 1: Identify Your Batches
List every purchase made during the accounting period, including the beginning inventory. Note the number of units purchased and the price paid per unit for each specific transaction.
Step 2: Calculate the Total Cost for Each Batch
Multiply the number of units in each batch by the cost per unit for that batch. For example, if you bought 100 units at $5 and 200 units at $7, your batch totals are $500 and $1,400, respectively.
Step 3: Sum the Totals
Add all the batch costs together to get the Total Cost of Goods Available for Sale. Then, add all the units together to get the Total Units Available for Sale.
Step 4: Divide
Divide the total cost by the total units. The resulting figure is your weighted average cost per unit.
Example Scenario
Let's say a small electronics retailer has the following inventory activity for a specific smartphone model:
- Beginning Inventory: 50 units @ $200 each ($10,000)
- Purchase 1: 100 units @ $210 each ($21,000)
- Purchase 2: 50 units @ $220 each ($11,000)
Total Cost: $10,000 + $21,000 + $11,000 = $42,000
Total Units: 50 + 100 + 50 = 200 units
Weighted Average Cost: $42,000 / 200 = $210 per unit.
Why Use the Weighted Average Method?
Businesses often choose the weighted average method for its simplicity and the way it smooths out price fluctuations. Unlike FIFO (First-In, First-Out) or LIFO (Last-In, First-Out), which can result in significant profit swings when costs change rapidly, the WAC method provides a middle-ground valuation that is easier to track for high-volume, homogeneous products.