The weighted average cost method accounting is a method of inventory valuation used to determine the cost of goods sold and ending inventory. Weighted average accounting assumes that units are valued at a weighted average cost per unit and applies this calculated average to the units sold and the units held in ending inventory.
Periodic Weighted Average Cost Method
Using the average inventory method the total cost of goods available for sale is averaged and any two units are sold at the average cost. Using a simple average the calculation is as follows.
Average cost = Cost of goods available for sale / Number of units Average cost = 56 / 8 = 7
Average Cost Method Example
By way of illustration.
If a business had the following inventory information for October:
- October 1 Beginning inventory 100 units @ 5.00 cost per unit
- October 4 Purchase 300 units @ 6.00 cost per unit
- October 10 Sell 200 units
- October 20 Purchase 100 units @ 8.00 cost per unit
The calculations using the periodic average cost method are summarized in the following table.
|Sell||– 200||6.20||– 1,240|
As the business uses the periodic inventory accounting system, the fact that a sale occurs (October 10) before the final purchase (October 20) can be ignored. The beginning inventory and purchases are simply combined to calculate the weighted average unit cost of 6.20 using the average cost formula as follows:
Average unit cost = Total cost / Total units Average unit cost = (100 x 5.00 + 300 x 6.00 + 100 x 8.00) / (100 + 300 +100) Average unit cost = 6.20
This weighted average unit cost is then applied to the number of units sold (200) to calculate the cost of goods sold of 1,240 (200 x 6.20), and to the ending inventory of 300 units to give an ending inventory cost of 1,860 (300 x 6.20).
Simple Average Cost Method
It should be noted that the above method refers to the use of a weighted average calculation in determining the inventory valuation. An alternative approach would be to use simple averages. In the above example the simple average of the unit costs would be calculated as follows.
Simple average unit cost = (5.00 + 6.00 + 8.00) / 3 Simple average unit cost = 6.33
The simple average unit cost of 6.33 compares to the weighted average cost calculate earlier of 6.20. The method gives a reasonable estimate of the inventory value when the beginning inventory and purchases are of a similar level.
Weighted Average Cost Method with Perpetual Inventory
Under the perpetual inventory system transactions are continually recorded and the average cost method calculations are carried out during the accounting period each time a purchase or sale takes place. The weighted average cost per unit is based on the cost of the beginning inventory and the purchases up to the point at which a sale takes place. This approach is sometimes referred to as the moving average cost method.
Using the information from the previous example, the calculations using the perpetual average cost method are summarized in the following table.
|Sell||– 200||5.75||– 1,150|
As the business uses the weighted average perpetual inventory system, the purchase and sales need to be dealt with in chronological order and an weighted average unit cost calculation is needed each time a sale is made.
As the weighted average is continually calculated, the perpetual inventory average cost method is sometimes referred to as the moving average cost method.
Notice that in both cases the total cost of the beginning inventory and the purchases (3,100) is the same, and only the allocation of that cost to the cost of goods sold and ending inventory changes.
This is summarized in the following table.
The average inventory method is one of the available methods used in inventory management. Clearly the method used to determine which units are sold and which remain in ending inventory determines the value of the cost of goods sold and the ending inventory. As profit depends on the cost of goods sold, the method chosen will affect the profits of a business.
About the Author
Chartered accountant Michael Brown is the founder and CEO of Plan Projections. He has worked as an accountant and consultant for more than 25 years and has built financial models for all types of industries. He has been the CFO or controller of both small and medium sized companies and has run small businesses of his own. He has been a manager and an auditor with Deloitte, a big 4 accountancy firm, and holds a BSc from Loughborough University.