Adjutant
Welcome Guest, you are in: Login

Desktop Adjutant

RSS

Navigation







Quick Search
»


Advanced Search »

Page History: Inventory Costing Methods

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: Tue, 23 Jul 2013 14:23



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.
  • On Jan 3rd, ABC Supply sells 8 widgets from its Houston warehouse.
  • On Jan 3rd, ABC Supply receives 50 widgets into the Austin warehouse at a cost of $9/ea.
  • On Jan 10th ABC Supply sells 20 widgets from its Austin warehouse.
  • On Jan 15th, ABC Supply receives 10 more widgets into the Houston warehouse at a cost of $9/ea.
  • On Jan 22nd, ABC Supply sells 10 widgets from its Houston warehouse.
  • On Jan 30th, ABC Supply sells 30 widgets from its Austin warehouse.
  • On Jan 31st, ABC Supply receives 100 more widgets into the Austin warehouse at a cost of $8.60/ea.



Adjutant Wiki via Screwturn version 3.0.5.600. You are logged in as Guest. There are 921 pages in the Wiki. Learn More About Adjutant Enterprise Solutions