Description

Cyrious Control supports average costing for material parts that have full accounting and inventory tracking enabled. For these parts, the value of the part is accrued in an inventory asset account until it is used and subsequently expensed.

One of the options that Control provides to maintain accurate costs is “Average Costing”. In Average Costing, the value of existing inventory is blended with the cost of new purchases to produce a new (average) cost for that part. (Note: Average Costing may only be used with material that is accrued in inventory. Control does not provide FIFO or LIFO part costing.)

A sample worksheet in Excel is also available for review at this link.
Inventory Weighted Average Worksheet


How It Works

The basic idea of average costing is to combine the current value of inventory and the new purchase and then divide by the total quantity. Formulaically, this would be:

Note, however, that if the existing quantity is negative, this formula is not used (or desirable). Since a negative quantity doesn't make accounting sense, the existing quantity is ignored and the average cost is given as:




Examples



Example 1 - Using Average Costing

You have 175 widgets in inventory at a current part cost of $1.10 each. Bill #1234 is entered for 300 widgets at a total cost of $360 ($1.20 each). Average costing is being used. The new average cost is:



The GL activity for this would be:

AccountDebitCreditPartQuantityBill
Widget Inventory Asset $ 360.00 Widget3001234
Accounts Payable $ 360.00 1234



Example 2 - Not Using Average Costing

You have 175 widgets in inventory at a current part cost of $1.10 each. Bill #1234 is entered for 300 widgets at a total cost of $360 ($1.20 each). Average costing is not being used. The new average cost is unchanged, so:


Since the change in inventory value does not equal the amount of the new bill, the overage (or shortage) is immediately expensed into the expense account specified on the Part (i.e. Material Expense). The GL activity for this would be:

AccountDebitCreditPartQuantityBill
Widget inventory Asset $ 330.00 Widget3001234
Material Expense $ 30.00 1234
Accounts Payable $ 360.00 1234



Example 3 - Average Costing with Negative inventory

You have -15 widgets in inventory at a current part cost of $1.10 each. Bill #1234 is entered for 300 widgets at a total cost of $360 ($1.20 each). Average costing is being used, but since the existing inventory is negative the new average cost uses the new cost, so:



Changing the existing cost will revalue the existing inventory (by $0.10 each times a quantity of negative 15 ), which must be taken into consideration. The overage (or shortage) is immediately expensed into the expense account specified on the Part (i.e. Material Expense). The GL activity for this would be:

AccountDebitCreditPartQuantityBill
Material Expense $ 1.50
Widget inventory Asset $ 1.50Widget
Widget inventory Asset $ 360.00 Widget3001234
Accounts Payable $ 360.00 1234

Note that after this purchase there will be 285 widgets in inventory at a value of $1.20 each.

You could leave a comment if you were logged in.