Lesson

Calculate periodic and moving average

Calculate average inventory cost for a whole period and after each purchase.

Updated Oct 21, 2026 Review due Nov 8, 2026
On this page
  1. Establish the transactions
  2. Periodic weighted average
  3. Perpetual moving average
  4. Explain the difference
About this lesson

Lesson details

Estimated study time
20 min
Learning objectives (2)

Average cost assigns costs across interchangeable units. Under periodic accounting, calculate one average for the whole period. Under perpetual accounting, recalculate a moving average after each purchase and use it for subsequent sales.

Establish the transactions

Second Helping begins November 2026 with no casserole dishes. It buys 12 dishes at $20 each on November 2 and 8 at $30 each on November 10. It sells 6 dishes on November 6 and 5 on November 18. The dishes are interchangeable, and there are no returns, shortages, or other inventory costs.

Date Transaction Purchase cost
November 2 Buy 12 dishes at $20 each. $240
November 6 Sell 6 dishes. Assigned below.
November 10 Buy 8 dishes at $30 each. $240
November 18 Sell 5 dishes. Assigned below.

The company has 20 dishes available during November and sells 11, leaving 9 unsold. Available cost is $480. We assign that cost between cost of goods sold and ending inventory.

Periodic weighted average

Include beginning inventory and all purchases in both total available cost and total available quantity. Second Helping has no beginning inventory in this example.

Average cost per dish = $48020 dishes = $24 per dish.

Multiply that average by the 11 dishes sold. Periodic cost of goods sold is $264. The 9 unsold dishes cost $216, and those two amounts equal available cost of $480.

Perpetual moving average

At the November 6 sale, only the November 2 purchase has occurred. The average is $20 per dish. Selling 6 dishes records cost of goods sold of $120, leaving 6 dishes costing $120.

After the November 10 purchase, combine the remaining inventory with the new purchase. The calculation includes only goods still on hand:

New average cost = $120 + $2406 dishes + 8 dishes = about $25.714286 per dish.

The November 18 sale uses this new average. Multiply 5 dishes by the unrounded average for cost of goods sold of $128.57. The remaining 9 dishes cost $231.43.

Total moving-average cost of goods sold is $248.57: the first sale's $120 plus the second sale's $128.57. Add ending inventory of $231.43 to recover the $480 available cost.

Explain the difference

Periodic weighted average uses both purchase costs when assigning costs to all November sales. Perpetual moving average uses the costs available when each sale occurs. The higher November 10 purchase cost therefore does not change the expense already recorded on November 6.

Keep the full average in your calculation and round the resulting dollar totals to cents. You can use the chapter's sale-by-sale diagrams to follow the remaining quantities and costs. Then try the practice questions.

Accounting Standards Codification (ASC) 330-10-30-9 permits average cost. See Inventory, Topic 330; access may require a free account.