Pin Me

Calculating FIFO Inventory Costs

written by: Bruce Tintelnot•edited by: Ronda Bowen•updated: 8/14/2010

The FIFO inventory valuation method is one of several used to arrive at the year-end balance for the Inventory account, and its impact on income can make a considerable difference when compared to some other methods. This can be important when statements are being viewed by creditors or investors.

  • slide 1 of 12

    What is FIFO?

    GPK Marginal Costing Structure Flow11 

    The FIFO inventory valuation method, or first-in first-out, is one of a number of inventory costing methods. It is used to facilitate the valuation of merchandise at the end of the year in the Inventory account. When determining how to calculate FIFO inventory costs, the basic assumption is that the first units of merchandise added to the physical inventory are going to be the first units removed during the course of business. The balance sheet Inventory account at the end of the year would then reflect the most recent costs matched to the most recent units produced, or purchased and placed in stock.

  • slide 2 of 12

    Ending Inventory Valuation Using FIFO

    Two inventory systems can be used for the FIFO inventory valuation method, and other inventory costing methods. They are the periodic inventory system, and the perpetual inventory system. The periodic inventory system does not update the Inventory account regularly, but instead uses a purchases account to record purchases of merchandise that are added to the physical inventory. The purchases account is closed at the end of the year, and the Inventory account is then updated. A Cost of Goods Sold account isn't necessary for this system so there is no way of telling what the Inventory account amounts are during the course of the year.

  • slide 3 of 12

    The Perpetual Inventory System

    The perpetual inventory system, unlike the periodic inventory system, continuously records changes to the Inventory account. The account is increased by purchases of merchandise from suppliers, and reduced by sales of merchandise to customers.

    The purchases account isn't necessary in this system, but there is the Cost of Goods Sold account that is debited when merchandise is removed from the inventory and sold. This actually consists of two journal entries:

    • The recording of the sale to the Sales account (a credit), and to the Cash, or Accounts Receivable accounts (a debit).
    • The reduction of the Inventory account (a credit), and an addition to the Cost of Goods Sold account (a debit).

  • slide 4 of 12

    The Periodic Inventory System

    Calculating the ending inventory costs using periodic FIFO is fairly straightforward. The following example shows this.

  • slide 5 of 12

    Inventory Additions/Withdrawals

    100,000 units beginning inventory @ $5.00 ea. = $ 500,000

    200,000 units purchased @ $5.50 ea. = $1,100,000

    (50,000) units sold @ ? = ?

    100,000 units purchased @ $5.75 ea. = $ 575,000

    (75,000) units sold@ ? = ?

  • slide 6 of 12

    Calculating Units in Ending inventory

    The number of units in the ending inventory would be:

    Ending Inventory = Beginning Inventory + Units Purchased - Units Sold

    275,000 units = 100,000 units + 300,000 units - (50,000 units + 75,000 units)

  • slide 7 of 12

    Determine the Cost of Each Sale

    To determine the costs of each sale in this example it helps to consider purchases of inventory as forming three tiers:

    Tier 1: 100,000 units (beginning inventory)

    Tier 2: 200,000 units (first purchase)

    Tier 3: 100,000 units (second purchase)

  • slide 8 of 12

    First Sale of Goods in Inventory

    The cost of the 50,000 units that were first sold would be determined by assigning the earliest purchase price to them. This would happen to be $5.00 per unit from the first tier, the beginning inventory. The cost of the sale would be $250,000:

    50,000 units x $5.00 = $250,000

    The the remaining balance of the beginning Inventory would be 50,000 units:

    100,000 units - 50,000 units = 50,000 units.

  • slide 9 of 12

    Second Sale of Goods in Inventory

    The cost of the 75,000 units sale involves two tiers. The first 50,000 units would be costed at $5.00 per unit from the remainder of the first tier (beginning inventory), and the next 25,000 units would be costed from the second tier (200,000) of inventory at $5.50. The calculation would be:

    Remainder of tier 1: 50,000 units @ $5.00 = $250,000

    From tier 2: 25,000 units @ $5.50 = $137,500

    The total sale would be: $387,500

  • slide 10 of 12

    Ending Inventory Balance

    The value of the ending inventory would then be $1,787,000:

    $1,787,000 = $500,000 + $1,675,000 - ($250,000 + 137,500)

  • slide 11 of 12

    Summary

    The cost flow using FIFO assigns the oldest purchase prices to inventory merchandise when they are sold. How to calculate FIFO inventory costs is dependent upon the existing inventory system being used.

    The periodic inventory system uses a Purchases account to record purchases from suppliers, and adjusts the Inventory account for additions, or reductions at the end of the year. The perpetual inventory system continually updates the Inventory account throughout the year debiting a Cost of Goods Sold account and crediting the Inventory account when merchandise is sold. The systems are different, but when calculating inventory costs using periodic FIFO, or perpetual FIFO shows no differences in the Inventory account on the balance sheet.

  • slide 12 of 12

    Citations

    "Inventory Chapter 8," PrinciplesofAccounting.com. Retrieved August 2, 2010 from the World Wide Web: http://www.principlesofaccounting.com/chapter%208.htm#inventory%20costing%20methods

    "Comparison of Inventory Valuation Methods," Accounting Study Guide Online, 2010. Accounting Courses Online. Retrieved August 2, 2010 from the World Wide Web: http://accountinginfo.com/study/inventory/inventory-120.htm

    "Inventory and Cost of Goods Sold," AccountingCoach.com, 2010. Retrieved August 2,2010 from the World Wide Web: http://www.accountingcoach.com/online-accounting-course/12Xpg02.html#periodic-fifo

    Image Credit: Public domain retrieved from Wikimedia.org






© Copyright 2016 brighthub.com.