What is FIFO and how is it calculated?

FIFO is an acronym for first in, first out. It is a cost layering concept under which the first goods purchased are assumed to be the first goods sold. The concept is used to devise the valuation of ending inventory, which in turn is used to calculate the cost of goods sold.

Characteristics of FIFO

A company that uses FIFO will find that the costs it maintains in its records for its inventory will always be the most current costs, since the last items purchased are still assumed to be in stock. Conversely, the cost of the oldest items will be charged to the cost of goods sold. In a normal inflationary environment, this means that the cost of goods sold will be relatively low in comparison to current costs, which will increase the amount of taxable; also, the inventory value reported on the balance sheet will approximately match current costs.

To calculate COGS (Cost of Goods Sold) using the FIFO method, determine the cost of your oldest inventory. Multiply that cost by the amount of inventory sold.

Keep in mind that the prices paid by a company for its inventory often fluctuate. These fluctuating costs must be taken into account.

The FIFO concept is best shown with the following example.

 

Received 10 on December 1 at a cost of 7.58 = $758.00 in the inventory GL and the physical/shelf inventory

Received 20 on December 31 X 10.49 = $209.80 in the inventory GL and the physical/shelf inventory

An item that is sold today would use the "first" cost, or $7.58, to calculate the gross profit and margins on the work order and to credit inventory/debit COGS with this method. Once ten have been sold at the cost of 7.58, the system will then use the cost of 10.49 for the next sales.

You can tell if your warehouse is set to use FIFO by accessing Parts Items Setup in the top toolbar of the Parts inquiry module.

On the Warehouses tab, if the FIFO Inventory Cost option is selected the system will track individual cost and use that for FIFO costing.  If it is unchecked, the system will use the cost on the part record (also known as replacement cost).

​

• Related Articles

• FIFO (First In, First Out)

  Overview FIFO, or First In, First Out, is a method of inventory management where the oldest items in inventory are assumed to be sold first. This ensures that inventory costs are based on the assumption that the oldest items are sold first, ...

• We would like to switch to using the FIFO method to value our inventory.

  If you are currently using the replacement cost method and would like to update your system to use the FIFO method, you will want to take the following steps in Softbase: First, you want to create a FIFO cost record for all parts in your inventory. ...

• Why doesn't my markup % on my sales document match my gross profit % or the markup % I have set up on the part record?

  When pricing is set to cost +%, you may expect the gross profit to match the markup percentage used, but there are actually two very different calculations used for this analysis. For an easy example, let's say we have a part that costs $100 and the ...

• Parts Inventory Reconciliation (not using WIP)

  To reconcile inventory, there are a few variables that need to be considered when looking at your physical valuation when comparing it to the GL account balance. First, the costing method being used to value inventory will be either replacement cost ...

• Parts Reconciliation using Accrual Based Accounting

  To reconcile inventory, there are a few variables that need to be considered when looking at your physical valuation when comparing it to the GL account balance. First, the costing method being used to value inventory will be either replacement cost ...