Page History: Inventory Costing Methods
Compare Page Revisions
Page Revision: Tue, 23 Jul 2013 14:52
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.
Specific Identification
The specific identification method refers to the tracking and costing of inventory based on the movement of specific, identifiable inventory items in and out of stock. This method is applicable when individual items can be clearly identified, such as with a serial number or lot number.
An example of the variance between average cost and specific ID cost can be reviewed here: http://www.abiscorp.com/adjwiki/coilfindervsioh.ashx
Specific Identification Method Requirements
In Adjutant, only items that are serialized or lot controlled may be costed under this method.
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 the other non specific ID 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
- Final Inventory value in Houston is $18.33
- Final Inventory value in Austin is $857.75.
FIFO - First in, First Out
The first in, first out (FIFO) method of inventory valuation operates under the assumption that the first goods purchased are also the first goods sold or used.
LIFO - Last in, First Out
