About the Average Costing Method
Average is a cost method that uses a weighted average of the costs of all items and
maintains one actual, average unit cost for an item. Unlike the other Actual cost flow
methods, which store cost information in a separate file, the Average cost for an item is
maintained on the Item Costs form, in the Unit Cost Detail fields. The unit cost
also appears on the Items form.
The cost of inventory is maintained as follows:
- When you receive a quantity through a purchase order, job completion, or miscellaneous receipt, the system computes the new average unit cost. This updated average unit cost is then posted to the Unit Cost field on the Items form.
- When you receive a quantity through an order return, stock adjustment, cycle count posting, or job material withdrawal, that quantity does not affect the Average unit cost.
- When you issue a quantity to a job or ship a quantity to a customer, the associated inventory account is reduced by the Unit Cost * Qty Issued or Shipped.
The new Average unit cost for each cost details component is calculated as follows:
(OQOH * OAUC) + (QR * RC) / OQOH + QR = NAUC
where:
- NAUC = new average unit cost
- OQOH = old quantity on-hand
- OAUC = old average unit cost
- QR = quantity received
- RC = receipt cost