Weighted Average Method (Cost Accounting)

Weighted Average Method Explained

The weighted average method is one of the most common methods of inventory and cost accounting. It is also known as Average Cost Method or AVCO. It is an alternative to FIFO (first in first out) and LIFO (last in first out), which are other commonly used cost accounting methods.

The core idea of the weighted average method is to assume that all units that are currently in the inventory have been purchased at the same price (unit cost).

Weighted Average Method Formula for Unit Cost

Average unit cost under the weighted average method is calculated as weighted average of unit costs of past purchases, according to the following formula:

Weighted average method unit cost formula

… where there have been n purchases of inventory (i = 1, 2, 3, …, n) and:

The weighted average unit cost is simply the total amount that has been paid for the inventory divided by the number of units in the inventory.

The formula is of course the same as the general weighted average formula:

Weighted average formula

… where:

Weighted Average Method Example

There is a small refinery. It buys crude oil and uses it to produce gasoline, diesel, and other oil products.

What has been the cost for the accounting period under the weighted average method?

Average Unit Cost

Total cost for all inventory is the sum of the costs of individual purchases:

10,000 x 85 + 7,000 x 100 + 8,000 x 80 =

= 850,000 + 700,000 + 640,000 =

= USD 2,190,000 for all 25,000 barrels.

Unit cost under the weighted average method is simply the total cost divided by number of units:

2,190,000 / 25,000 = 87.60 USD/barrel

Cost for the Period and Ending Inventory

Out of the total 25,000 barrels, only 22,000 have been used in production and 3,000 remain as inventory for the following accounting period.

The cost in the current accounting period is the average unit cost times number of units used:

87.60 x 22,000 = USD 1,927,200

Ending inventory is the average unit cost times number of units remaining:

87.60 x 3,000 = USD 262,800

… which must be the same as the total cost of all purchases less the cost of the units used in production:

2,190,000 – 1,927,000 = USD 262,800

When to Use Weighted Average Method

The weighted average method is typically used when inventory items are commodities or close to commodities and it is difficult to tell which particular item was purchased when, and therefore difficult to assign specific unit cost. It requires less sophisticated inventory management and accounting than other methods like FIFO or LIFO.

Related pages

excel formulas minushow to use normdist in excelhow to annualize standard deviationblack scholes model explainedprofit loss calculator options3x leveraged etf listmean deviation calculatorcalculating the standard deviation in excelcboe vix quotestandard deviation calcstandard dev formulaexcel probability formulablack scholes options calculatorcall option thetaexcel implied volatilitysec hedge fund filingsdefine kurtosisweighted average method accounting formulairon condor riskapple stock price graphcalculating stock volatilityaapl share price historystandard dev formulaspx settlement priceweighted average cost accountingshort stranglestandard deviation of the sample mean formulastats varianceblack-scholes opmoption payoff diagram generatormacd emaskewness definition in statisticscontango chartmeaning of kurtosisbull put spread calculatorarithmetic mean in excelblack scholes original papermacd signalhow to calculate cost of preferred stock in waccweighted average inventory methodhow to calculate the square root in excelmerits of arithmetic meanshort stranglecalculate delta of optioncboe cfemacd crossover indicatorjohn hull futures options and other derivativesubs etnswhat is squared deviationcalculate sample standard deviation excelestimated standard deviation calculatorcurrency options calculatorweighted average yield formulamarket capitalization weighted indexoptions calccontinuously compounded calculatormacro hedge fund definitionvix historical chartarithmetic progression calculatorvixy usannualized formula in exceletracsarithmetic mean formulashow to annualize standard deviationtheta call optionvix hedgegeorge soros vs warren buffettkurtosis calculatorformula for calculating average in excelbull put spread payoff diagramuvxy optionsdifferent hedge fund strategiesstandard deviation of a sample calculators&p 500 vix short-term futuresaverage true range formulaformula for exponential moving averagebullish put spreadskewness of distributioncall spread payoff