Page History: Inventory Costing Methods
Compare Page Revisions
Page Revision: Tue, 23 Jul 2013 14:34
General Information
Stock inventory can be valued four different ways in Adjutant:
- Average Cost
- Specific Identification
- First in, First Out (FIFO)
- Last in, First Out (LIFO)
All four methods are updated perpetually (as transactions occur in the system) and maintained at a Warehouse, Inventory Owner, and Held For level (aka OHF).
A combination of Specific ID and one of the other three costing methods may be used to value inventory.
Unit costs are maintained at a 4 decimal places (hundredths of a penny).
Costing Methods
Each costing method is explained below.
Average Cost
The Average Cost method implemented in Adjutant is commonly referred to as Moving Average Cost.
Moving average cost is an inventory costing method used under a perpetual inventory system whereby, after each acquisition, average unit cost is recomputed by adding the cost of acquired units to the cost of units in inventory and dividing by the new total number of units.
Simply put, the average cost of each inventory item in stock is recalculated each time inventory is added.
As with all other inventory costing methods, the average cost is maintained at the Warehouse/Owner/HeldFor level.
Average Cost Examples
Example #1:As of Jan 1st, ABC Supply has 0 widgets on hand in its Houston warehouse and 0 widgets on hand in its Austin warehouse.
- On Jan 2nd, ABC Supply receives 10 widgets into its Houston warehouse at a cost of $10/ea.
- On Jan 3rd, ABC Supply receives 50 widgets into the Austin warehouse at a cost of $9/ea.
- On Jan 15th, ABC Supply receives 10 more widgets into the Houston warehouse at a cost of $9/ea.
- On Jan 31st, ABC Supply receives 100 more widgets into the Austin warehouse at a cost of $8.60/ea.
- ABC Supply did not sell or use any widgets during the month of January.
The moving average cost of the widgets is calculated as:
- Houston = ((10*$10.00) + (10*$9.00)) / 20 = $9.5000
- Austin = ((50*$9.00) + (100*$8.60)) / 150 = $8.7333
We'll use the same purchases in the next example, but also include several sales.
Example #2:As of Jan 1st, ABC Supply has 0 widgets on hand in its Houston warehouse and 0 widgets on hand in its Austin warehouse.
- On Jan 2nd, ABC Supply receives 10 widgets into its Houston warehouse at a cost of $10/ea.
- New average cost in Houston is $10.00
- On Jan 3rd, ABC Supply sells 8 widgets from its Houston warehouse.
- Widgets are relieved from inventory and posted to COGS at $10/ea.
- Total widget inventory value in Houston is: (10-8)*$10.00 = $20.00
- On Jan 3rd, ABC Supply receives 50 widgets into the Austin warehouse at a cost of $9/ea.
- New average cost in Austin is $9.00
- On Jan 10th ABC Supply sells 20 widgets from its Austin warehouse.
- Widgets are relieved from inventory and posted to COGS at $9/ea.
- Total widget inventory value in Austin is: (50-20)*$9.00 = $270.00
- On Jan 15th, ABC Supply receives 10 more widgets into the Houston warehouse at a cost of $9/ea.
- New average cost in Houston is: ((2*$10.00) + (10*$9.00)) / 12 = $9.1667
- On Jan 22nd, ABC Supply sells 10 widgets from its Houston warehouse.
- Widgets are relieved from inventory and posted to COGS at $9.1667/ea.
- Total widget inventory value in Houston is: (12-10)*$9.1667 = $18.33
- On Jan 30th, ABC Supply sells 25 widgets from its Austin warehouse.
- Widgets are relieved from inventory and posted to COGS at $9/ea.
- Total widget inventory value in Austin is: (30-25)*$9.00 = $18.33
- On Jan 31st, ABC Supply receives 100 more widgets into the Austin warehouse at a cost of $8.60/ea.
- New average cost in Austin is: ((5*$9) + (100*$8.60)) / 105 = $8.6190
