Calculating Cost Using First-In, First-Out (FIFO)

The First-In, First-Out method, also called FIFO, is the most straight-forward of all the methods. When determining the cost of a sale, the company uses the cost of the oldest (first-in) units in inventory. This does not necessarily mean the company sold the oldest units, but is using the cost of the oldest ones. When I think of FIFO, it reminds me of milk being sold at the grocery store. In most grocery stores, the coolers are built to allow staff to put the new milk in from the back, pushing the old milk forward, and encouraging shoppers to purchase the older milk (first-in) before the new milk.

When the cost of inventory is rising, FIFO will ensure that the older, less expensive inventory cost is transferred to Cost of Goods Sold. This creates a lower expense on the income statement and higher profit. Higher profit also leads to higher income taxes. Inventory on the balance sheet will be higher than when using other inventory methods, assuming costs are rising.

The wonderful thing about FIFO is that the calculations are the same for both periodic and perpetual inventory systems because we are always taking the cost for the oldest units.

FIFO 1

FIFO Periodic

All periodic inventory systems calculate inventory at the end of the period. Therefore, we are not concerned about which units are on hand when a sale occurs. When calculating any inventory method under periodic, it is best to separate the purchases from the sales.

FIFO2

We now have a much clearer picture of what happened during the month of January. Our goods available for sale (beginning inventory plus purchases) is 415 units or $3,394. We know we sold 245 units during the month. When using FIFO, we pick the units that were acquired first and use the cost of those units first. We keep picking units until we have accounted for the cost of all the units sold, in this case 245 units.

First we select the units from beginning inventory.

FIFO3

That gives us 150 of the 245 units we need. We still need 95 more units. We move to the first purchase on January 3.

FIFO3A

Taking all the units from January 3 still leaves us 20 units short of the 245 units we need. We will take those 20 units from the 50 purchased on January 12.

FIFO4

We have now accounted for all 245 units sold and have determined that the cost of those units is $1,972.50. We sold the units for $4,900. Now we can calculate gross profit. Gross profit is sales less cost of goods sold. Gross profit tells us how much profit we are making off the sale of our product before all other expenses.

 FIFO5

Our gross profit is $2,927.50. Remember that as prices rise, FIFO will give you the lowest cost of goods sold because the oldest and least expensive units are being sold first. This also gives us the highest gross profit.

Now to calculate ending inventory. Remember that ending inventory is what is left at the end of the period. The units from beginning inventory and the January 3rd purchase have all been sold. The company also sold 20 of the 50 units from the January 12 purchase. That leaves 30 units from that purchase and the units purchased on January 22 and 26.

FIFO6

Ending inventory contains 170 units with a value of $1,421.50. To ensure we accounted for all the units and their value, add cost of goods sold and ending inventory.

 FIFO7

This agrees to our original goods available for sale. While this check figure will not ensure that you picked the right units, it will ensure that you accounted for all the units and calculated the cost correctly.

FIFO Perpetual

As stated previously, FIFO periodic and FIFO perpetual will give you the same result for cost of goods sold and ending inventory. However, with perpetual inventory systems we must be concerned with calculating cost of goods sold at the time of each sale.

FIFO8

When calculating using the perpetual systems, do not separate purchases and sales. At the time of each sale, we must consider what units are actually available to be sold. Only consider units that are on hand at the time of the sale. Look at the sale on January 7. What units are on hand on that date? The company has the units from beginning inventory and the purchase on January 3rd.

FIFO9

If we take 100 units out of inventory, we would take them from beginning inventory.

FIFO10

The cost of goods sold for the January 7th sale is $800. That would leave 50 units from beginning inventory and 75 from the purchase on January 3rd. Now we can move on to the next sale on January 17. Update the list of goods available for sale to reflect what was sold and the additional purchase on January 12.

FIFO11

The company sold 65 units on January 17. Using FIFO, we would take the first units in, taking 50 units left from beginning inventory and an additional 15 from the purchase on January 3rd.

FIFO12

The cost of the January 17th sale is $521.50. We have now used up all the units from beginning inventory and 15 of the units from January 3rd. Now let’s look at the last sale, again updating what is on hand as of that date.

 FIFO13

The sale on January 31 of 80 units would be taken from the purchase on January 3rd and the purchase on January 12th.

FIFO14

The total cost of the sale is $651.00. We can now figure out the total cost of goods sold for the month by adding the cost of goods sold from each transaction.

FIFO15

Cost of goods sold for the month of January is $1,972.50. Notice this is the same as the cost of goods sold calculated until FIFO periodic. We can also calculate ending inventory, which is just the sum of what is left over.

 FIFO16

If we add cost of goods sold and ending inventory, we get $3,394.00 which is our goods available for sale.

Remember that under FIFO, periodic and perpetual inventory systems will always give you the same cost of goods sold and ending inventory. This will only occur under FIFO.

When doing this by hand, I always cross out the number of units and write in the remaining amount. This is much faster than rewriting the list. Keeping track of the number of units remaining will help to ensure that you take your units from the correct date and calculate ending inventory properly.

 Related Videos:

FIFO Inventory Calculations

FIFO Inventory Journal Entries

Share This:

6 Responses to First-In, First-Out (FIFO) Inventory

  • Greetings

    1. what would be the “damaged components returned from production to stores”… issued or purchased???
    2. what would be the “returned to supplier 50 damaged and 5 incorrectly cupplied “… issued or purchased???

  • Thank u so much for this super great tutorial. Ive learned a lot. Thank u thank u 😊😊😘

  • hi!
    my question was, what if out of the stock you have some goods got damaged, and you had them repaired and obviously their value has now changed, how can we show this using the FIFO method?

    • You would need to add the cost of the repairs to the original cost. However, those cannot be sold in the same category as the non-refurbished goods. You would need to keep these in a separate category for refurbished goods.

Leave a Reply

Your email address will not be published. Required fields are marked *


Related pages


predetermined indirect cost allocation ratehow to find ending inventory using fifowhat is separate legal personalityallowance for bad debt accountperpetual inventory fifofactory overhead expenses listhow to do adjusting journal entriesordinary annuity versus annuity dueunearned revenue debithow to calculate cogsfinding the principal in simple interest calculatorbudgeted manufacturing overhead ratemerchandising companies examplesdefine direct labor costcalculate manufacturing overheadginormicpv annuity factor tablewrite off method and allowance methodprofit variance formulatable discount factoroverappliedbad debt expense journal entrieswhat is retained profit in balance sheetaccumulated depreciation contra assetperpetual inventory journal entries exampleclosing entries are madewarranty provision ifrscredit accumulated depreciationschedule of cost of goods manufactured in good formadjusting journal entry examplesdoes land depreciateallowance for doubtful accounts is a contra asset accountaccrued revenue entrycommon stockholders rightsmanagerial accounting activity based costinghow to record closing entriesincome received in advance journal entryas 6 depreciation accountingformulas of cost accountingreducing balance method depreciation calculatorconvert net pay to grossjournal entries for accounts receivable processinventory sold journal entryhow to calculate simple interest loana post closing trial balance will showwage expense journal entryabsorbing costingthe present value of an ordinary annuityjob costing journal entriesordinary annuity versus annuity duecalculate factory overheadperiodic perpetualdepreciation debit or creditcalculate total contribution marginbond valuation calculator semiannualinvestment turnover ratio formulahow to compute accumulated depreciationaccounting for merchandising operations solutionsdirect materials formulapv of bond calculatorhow to calculate average grade with weightsshort term pricing decisionsdiminishing value depreciation formula accountingdeferred income double entryyear end closing entries examplesadjusting entry examplesdefine adjusting entriesaccounts receivable income statementaccounts payable example entryentry for salary payablegross profit equationwhy we prepare trial balancecalculating interest expense on a loanexplain variable costsfica payroll taxjournal entry for credit sales with discount