Inventory

# Inventory Weighted Average Cost: Formula, Advantages, And Examples

Nguyễn Viết Lộc Companies that have inventory on hand should be aware of the average inventory costs by individual expenses and the total number of groups stored. Keeping track of stock levels as well as the value is important for eCommerce companies. You can effectively manage your inventory and estimate potential profit by using the suitable inventory tracking method. Various eCommerce inventory valuation approaches streamline the process. The inventory weighted average cost formula is one of the most common solutions. In this article, let's discuss how to determine the inventory weighted average cost and its pros and cons.

## Inventory Weighted Average Cost Method Definition

In accounting, the phrase “weighted average cost” (WAC) or inventory weighted average mentions to the method of calculating costs related to a company's COGS (cost of goods sold) and inventory. Since particular types of inventory are not available, it is usual for companies to pay varied prices when purchasing inventory. This may get mixed up with specific pricing eventually. The weighted average cost for inventory approach assists companies in determining the total cost of inventories and COGS.

### How to calculate weighted average of inventory pricing?

In order to calculate this cost, you simply divide the cost of goods ordered by the number of units listed for sale to get the WAC. You'll need to have the full sum of beginning inventory and new additions to calculate the cost of products listed for trading. The final figure will yield an inventory weighted average pricing for each item on the market.

### The weighted average cost formula (WAC)

In which:

• Costs of goods available for sale equal to the sum of the beginning inventory value and purchases
• The quantity of goods available for sale, also the total units in inventory that a business can list, equals the beginning inventory in units plus purchases in units.

## Example of calculating weighted average cost

To further understand how the average cost method of inventory is calculated, let's consider the following examples using the weighted average inventory formula:

### Example 1: Under the system of periodic inventory

At the start of its fiscal year on 1st Jan, a reported a starting inventory of 400 units at \$100 per unit. The following purchases were made by the end of the first quarter:

• 10th Jan: 200 units at a cost of \$50 = \$1,000
• 20th Feb: 100 units at a cost of \$120 = \$12,000
• 15 Mar: 300 units at a cost of \$30 = \$9,000

So, the total number of units available before sales: 400+200+100+300 = 1000 (units). The sales were reported as follows:

• End of January: sales of 104 units
• End of February: sales of 210 units
• End of March: sales of 196 units.

So, 104+210+196 = 510 units sold in total during 1st quarter. The accountants at the firm want to utilize the periodic inventory system, which determines the COGS and items available for sale at the end of the 1st quarter as follows:

The business set aside \$62 per unit sold for the sale of 510 units from January to March. The remaining items were placed in ending inventory, yielding the following figures:

• 510*\$62=\$31,620 in COGS (cost of goods sold)
• \$62000-\$31,620=\$30,380 in final inventory

### Example 2: Under the perpetual inventory system

Businesses that use the perpetual inventory system calculate the average cost before selling units. Before the January sale of 104 units, the average unit cost would have been as follows:

Following the January sale of 121 units, the costs are as follows:

• 104*\$68.33=\$7,106.32 in COGS
• \$41,000-\$7,106.32=\$33,893.68 remain in inventory

## Benefits of using the inventory weighted average cost method

Due to the various advantages it provides, such as time efficiency and accuracy, the average weighted cost of inventory approach is one of the most widely used stock valuation techniques. Here are several benefits of including the weighted-average cost in your inventory management strategy

### Track the value of your inventory with ease

Keeping track of inventory levels is one issue; managing the costs of purchasing and storing goods is another. Unlike FIFO (first in, first out) and LIFO (last in, first out), which employ a range of costs, the WAC method utilizes a blended average, making inventory valuation easier to calculate and control.

### Deal with fewer documents

To calculate the average price of all in stock, the WAC technique needs a single cost calculation. You do not need to keep accurate inventory purchasing documents because each item is priced at the same value, which means less paperwork to keep care of.

### Lower overall costs

If you do not really take the time and effort to streamline your managing inventory process, it might eat into your earnings. Rather than calculating each sellable group and then combining the price of each item, the WAC method gives a simpler way to calculate the current stock value, which saves you money in the long run. Deploy an inventory management tool and/or engage with a third-party logistics (3PL) service that offers inventory management software, real-time inventory reports, and eCommerce warehousing to streamline your process and minimize inventory management costs. You can also eliminate human mistakes, labor costs, and inventory carrying costs by improving your inventory control and reorder quantity.