Inventory Costing Methods

Modified on Wed, 24 Jul 2013 15:25 by tsanchez — Categorized as: General Ledger, Item Control


General Information

Stock inventory can be valued four different ways in Adjutant:
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).

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.


The moving average cost of the widgets is calculated as:



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.









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.

In Adjutant, the FIFO inventory method is implemented through the use of Cost Tiers. Each receipt of goods creates a new FIFO cost tier. Each sale or usage of goods removes a quantity from a cost tier.

As with the other non-specific ID inventory costing methods, the average cost is maintained at the Warehouse/Owner/HeldFor level.

FIFO Example



As of Jan 1st, ABC Supply has 0 widgets on hand in its Houston warehouse.



At this point in time, there is no difference in total value between FIFO, LIFO, and Average Cost. However, when a widget is sold, the system will start removing inventory from the FIRST cost tier.




LIFO - Last in, First Out

The last in, first out (LIFO) method operates under the assumption that the last item of inventory purchased is the first one sold.

The reason why companies use LIFO is the assumption that the cost of inventory increases over time, which is a reasonable assumption in times of inflating prices. If you were to use LIFO in such a situation, the cost of the most recently acquired inventory will always be higher than the cost of earlier purchases, so your ending inventory balance will be valued at earlier costs, while the most recent costs appear in the cost of goods sold. By shifting high-cost inventory into the cost of goods sold, a company can reduce its reported level of profitability, and thereby defer its recognition of income taxes. Since income tax deferral is the only justification for LIFO in most situations, it is banned under international financial reporting standards (though it is still allowed in the United States under the approval of the Internal Revenue Service).

In Adjutant, the LIFO inventory method is implemented through the use of Cost Tiers. Each receipt of goods creates a new LIFO cost tier. Each sale or usage of goods removes a quantity from a cost tier.

As with the other non-specific ID inventory costing methods, the average cost is maintained at the Warehouse/Owner/HeldFor level.

FIFO Example



As of Jan 1st, ABC Supply has 0 widgets on hand in its Houston warehouse.



At this point in time, there is no difference in total value between LIFO, FIFO, and Average Cost. However, when a widget is sold, the system will start removing inventory from the LAST cost tier.