Menu
Business Tips
Written by
- Melanie
- December 17, 2018
3 Minute Read
Share Blog:
The weighted average cost method is one of three approaches of valuing your businesses inventory stock and determines the average cost of all inventory items based on the individual costs and the quantity of each item held in stock. Businesses use the weighted average to determine the amount that goes into the inventory and the cost of goods sold (COGS).
When a business purchases items of inventory, they may pay different prices due to diversity in the types of inventory stock or the same stock items, purchased at different times.
In the weighted average cost method, the cost of goods available for sale is divided by the number of units available for sale and is commonly used when inventory items are so melded or identical to each other that it is impossible to assign specific costs to single units.
Play Video
- Watch the next video: How Weighted Average Cost Works in Unleashed
- See the software in action: Unleashed Webinars
Calculating the weighted average cost
When using the weighted average method, you divide thecost of goods available for saleby the number of units available for sale, which yields the weighted-average cost per unit. In this calculation, the cost of goods available for sale is the sum of opening inventory and net purchases. This weighted average figure is then used to assign a cost to bothending inventoryand theCOGS.
Weighted average cost example
Corporation A uses the weighted average method and during the month of June it records the following transactions:
- Actual total cost of all inventory is $116,000 ($33,000 beginning inventory + $83,000 purchased) and total units of inventory is 450 (150 beginning inventory + 300 purchased)
- The weighted average cost per unit therefore is $257.78 ($116,000 ÷ 450 units)
- Ending inventory valuation is $45,112 (175 units × $257.78 weighted average cost) and COGS valuation is $70,890 (275 units × $257.78 weighted average cost)
- The total of these two amounts equals the $116,002 total actual cost of all purchases and beginning inventory
The result of using the weighted average cost method is that the recorded amount of on-hand inventory will represent a value somewhere between the oldest and most recent stock units purchased.
Equally, the COGS will reflect a cost somewhere between that of the oldest and newest units that were sold during the period.
Benefits of the weighted average cost method
A significant advantage of using the weighted average cost method that it is the simplest way to track inventory expense. You can store inventory stock without the need to designate which batch it belongs to and you don’t need to trace the original cost before pricing items, simply marking up the average price of the stock units.
The calculation used to determine the weighted average cost is also easier than that of other valuation methods which take multiple steps to calculate the inventory value or COGS.
Using this method also requires less paperwork. The weighted average cost method only requires a single cost calculation and uses this cost for all other calculations, requiring only a single record documenting the calculation. There is no need to maintain detailed records for each purchase, only records of the totals.
Consistency is another advantage because once the product cost is calculated, it is used consistently across all stock units. This includes the cost used for the ending inventory value as well as the COGS. Alternative methods such as FIFO and LIFO use a range of costs, depending on the individual costs incurred with each transaction.
Finally, it costs money to track inventory stock, so whether you are counting manually or using software to track inventory expenses, this method requires fewer labour hours to maintain.
Disadvantages of the weighted average cost method
An issue with the weighted average cost method is when your inventory prices vary widely, where you may not recover the costs of the more expensive units and may even suffering a loss with your sales price. The idea behind the method is that you will make up any loss when you sell the less expensive items. If that doesn’t happen, however, you may end up discontinuing the item, never recovering the losses sustained when selling the pricey units.
This method assumes that all units are identical, but this is not always the reality. Newer batches of product may have had upgrades or additional features added and may eligible for a better price than the older stock units. This is particularly problematic when a supplier replaces a product with a new version, giving it the same name as the previous version. Finally, the average cost method is retrospective, in that it looks back over a purchasing period to see what was paid per unit.
More about the author:
Share Blog:
Melanie
Article by Melanie Chan in collaboration with our team of Unleashed Software inventory and business specialists. Melanie has been writing about inventory management for the past three years. When not writing about inventory management, you can find her eating her way through Auckland.
More posts like this
-
Marketing plans are an important tool for any business. But they’re especially useful in fast-moving consumer goods (FMCG) categories such as fo...
-
Why Sales Reports are Important to Inventory Management
When managing your inventory, you are always looking for ways to optimise and improve your operations. Trying to keep healthy levels of inventory with...
-
Receiving Efficiency: KPIs, Formulas, Tips
Creating efficient warehousing processes can result in less downtime, lower running costs, and better customer service. And what better place to start...
Topics: accounting, average landed cost, business costs, inventory accounting, inventory cost, inventory management, inventory stock, inventory valuation
Get weekly supply chain insights
Sign up to our free newsletter to receive the latest industry news, expert advice, and productivity tips,
delivered to your inbox every Wednesday.