LO 7.2 Calculate the Cost of Goods Sold and Ending Inventory Using the Periodic Method

As you’ve learned, the periodic inventory system is updated at the end of the period to adjust inventory numbers to match the physical count and provide accurate merchandise inventory values for the balance sheet. The adjustment ensures that only the inventory costs that remain on hand are recorded, and the remainder of the goods available for sale are expensed on the income statement as cost of goods sold. Here we will demonstrate the mechanics used to calculate the ending inventory values using the four cost allocation methods and the periodic inventory system.

Information Relating to All Cost Allocation Methods, but Specific to Periodic Inventory Updating

Let’s return to the example of The Spy Who Loves You Corporation to demonstrate the four cost allocation methods, assuming inventory is updated at the end of the period using the periodic system.

Cost Data for Calculations

Company: Spy Who Loves You Corporation

Product: Global Positioning System (GPS) Tracking Device

Description: This product is an economical real-time GPS tracking device, designed for individuals who wish to monitor others’ whereabouts. It is being marketed to parents of middle school and high school students as a safety measure. Parents benefit by being apprised of the child’s location, and the student benefits by not having to constantly check in with parents. Demand for the product has spiked during the current fiscal period, while supply is limited, causing the selling price to escalate rapidly. Note: For simplicity of demonstration, beginning inventory cost is assumed to be $21 per unit for all cost assumption methods.

Chart showing July 1 beginning inventory of 150 units costing $21, July 5 sale of 120 units for $36, July 10 purchase of 225 units for $27, July 15 sale of 180 units for $39, July 25 purchase of 210 units for $33, with July 31 ending inventory of 285 units.

Specific Identification

The specific units assumed to be sold in this period are designated as follows, with the specific inventory distinction being associated with the lot numbers:

  • Sold 120 units, all from Lot 1 (beginning inventory), costing $21 per unit
  • Sold 180 units, 20 from Lot 1 (beginning inventory), costing $21 per unit; 160 from the Lot 2 (July 10 purchase), costing $27 per unit

The specific identification method of cost allocation directly tracks each of the units purchased and costs them out as they are actually sold. In this demonstration, assume that some sales were made by specifically tracked goods that are part of a lot, as previously stated for this method. So for The Spy Who Loves You, considering the entire period together, note that

  • 140 of the 150 units that were purchased for $21 were sold, leaving 10 of $21 units remaining
  • 160 of the 225 units that were purchased for $27 were sold, leaving 65 of the $27 units remaining
  • none of the 210 units that were purchased for $33 were sold, leaving all 210 of the $33 units remaining

Ending inventory was made up of 10 units at $21 each, 65 units at $27 each, and 210 units at $33 each, for a total specific identification ending inventory value of $8,895. Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $7,260 in cost of goods sold this period.

Calculations of Costs of Goods Sold, Ending Inventory, and Gross Margin, Specific Identification

The specific identification costing assumption tracks inventory items individually, so that when they are sold, the exact cost of the item is used to offset the revenue from the sale. The cost of goods sold, inventory, and gross margin shown below were determined from the previously-stated data, particular to specific identification costing.

Specific Identification Costing Assumption Cost of Goods Sold and Cost Value.:

Chart showing Cost of Goods Sold: Beginning Inventory $3,150 plus Purchases of 13,005 equals Goods Available of 16,155; minus Ending Inventory of 8,895 equals COGS 7,260. Chart showing cost value: 10 units at $21 equals $210, 65 units at $27 equals 1,755, 210 units at $33 equals 6,930, totaling $8,895.

The gross margin, resulting from the specific identification periodic cost allocations of $7,260, is shown below.

Specific Identification Periodic Cost Allocations Gross Margin:

Chart showing Gross Margin calculation: Sales of $11,340 minus Cost of Goods Sold 7,260 equals Gross Margin 4,080.

Calculation for the Ending Inventory Adjustment under Periodic/Specific Identification Methods

Merchandise inventory, before adjustment, had a balance of $3,150, which was the beginning inventory. Journal entries are not shown, but the following calculations provide the information that would be used in recording the necessary journal entries. The inventory at the end of the period should be $8,895, requiring an entry to increase merchandise inventory by $5,745. Cost of goods sold was calculated to be $7,260, which should be recorded as an expense. The credit entry to balance the adjustment is $13,005, which is the total amount that was recorded as purchases for the period. This entry distributes the balance in the purchases account between the inventory that was sold (cost of goods sold) and the amount of inventory that remains at period end (merchandise inventory).

First-in, First-out (FIFO)

The first-in, first-out method (FIFO) of cost allocation assumes that the earliest units purchased are also the first units sold. For The Spy Who Loves You, considering the entire period, 300 of the 585 units available for the period were sold, and if the earliest acquisitions are considered sold first, then the units that remain under FIFO are those that were purchased last. Following that logic, ending inventory included 210 units purchased at $33 and 75 units purchased at $27 each, for a total FIFO periodic ending inventory value of $8,955. Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $7,200 in cost of goods sold this period.

Chart calculating FIFO Periodic Ending Inventory Value: Units Sold (180 plus 120) equals 300 units. 150 units times $21 equals 3,150 plus 150 units times 27 equals 4,050, Total Sold equals 300 units with a Cost of Goods Sold of $7,200. Ending Inventory would be 210 units times $33 equals 6,930 plus 75 units times 27 equals 2,025, equals Ending Inventory Value of $8,955.

Calculations of Costs of Goods Sold, Ending Inventory, and Gross Margin, First-in, First-out (FIFO)

The FIFO costing assumption tracks inventory items based on segments or lots of goods that are tracked, in the order that they were acquired, so that when they are sold, the earliest acquired items are used to offset the revenue from the sale. The cost of goods sold, inventory, and gross margin shown below were determined from the previously-stated data, particular to FIFO costing.

FIFO Costing Assumption Cost of Goods Sold and Cost Value:

Chart showing Cost of Goods Sold: Beginning Inventory $3,150 plus Purchases of 13,005 equals Goods Available of 16,155; minus Ending Inventory of 8,955 equals Cost of Goods Sold 7,200. Chart showing cost value: 75 units at $27 equals $2,025, 210 units at $33 equals 6,930, totaling $8,955.

The gross margin, resulting from the FIFO periodic cost allocations of $7,200, is shown below.

FIFO Periodic Cost Allocations Gross Margin:

Chart showing Gross Margin calculation: Sales of $11,340 minus COGS 7,200 equals Gross Margin 4,140.

Calculations for Inventory Adjustment, Periodic/First-in, First-out (FIFO)

Beginning merchandise inventory had a balance of $3,150 before adjustment. The inventory at period end should be $8,955, requiring an entry to increase merchandise inventory by $5,895. Journal entries are not shown, but the following calculations provide the information that would be used in recording the necessary journal entries. Cost of goods sold was calculated to be $7,200, which should be recorded as an expense. The credit entry to balance the adjustment is for $13,005, which is the total amount that was recorded as purchases for the period. This entry distributes the balance in the purchases account between the inventory that was sold (cost of goods sold) and the amount of inventory that remains at period end (merchandise inventory).

Last-in, First-out (LIFO)

The last-in, first-out method (LIFO) of cost allocation assumes that the last units purchased are the first units sold. For The Spy Who Loves You, considering the entire period together, 300 of the 585 units available for the period were sold, and if the latest acquisitions are considered sold first, then the units that remain under LIFO are those that were purchased first. Following that logic, ending inventory included 150 units purchased at $21 and 135 units purchased at $27 each, for a total LIFO periodic ending inventory value of $6,795. Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $9,360 in cost of goods sold this period.

Chart calculating LIFO Periodic Ending Inventory Value: Units Sold (210 plus 90) equals 300 units. 210 units times $33 equals 6,930 plus 90 units times 27 equals 2,430, Total Sold equals 300 units with a Cost of Goods Sold of $9,360. Ending Inventory would be 150 units times $21 equals 3,150 plus 135 units times 27 equals 3,645, equals Ending Inventory Value of $6,795.

It is important to note that these answers can differ when calculated using the perpetual method. When perpetual methodology is utilized, the cost of goods sold and ending inventory are calculated at the time of each sale rather than at the end of the month. For example, in this case, when the first sale of 150 units is made, inventory will be removed and cost computed as of that date from the beginning inventory. The differences in timing as to when cost of goods sold is calculated can alter the order that costs are sequenced.

Calculations of Costs of Goods Sold, Ending Inventory, and Gross Margin, Last-in, First-out (LIFO)

The LIFO costing assumption tracks inventory items based on lots of goods that are tracked, in the order that they were acquired, so that when they are sold, the latest acquired items are used to offset the revenue from the sale. The following cost of goods sold, inventory, and gross margin were determined from the previously-stated data, particular to LIFO costing.

LIFO Costing Assumption Cost of Goods Sold and Cost Value:

Chart showing Cost of Goods Sold: Beginning Inventory $3,150 plus Purchases of 13,005 equals Goods Available of 16,155; minus Ending Inventory of 6,795 equals Cost of Goods Sold 9,360. Chart showing cost value: 150 units at $21 equals $3,150, 135 units at $27 equals 3,645, totaling $6,795.

The gross margin, resulting from the LIFO periodic cost allocations of $9,360, is shown below.

LIFO Periodic Cost Allocations Gross Margin:

Chart showing Gross Margin calculation: Sales of $11,340 minus Cost of Goods Sold 9,360 equals Gross Margin 1,980.

Calculations for Inventory Adjustment, Periodic/Last-in, First-out (LIFO)

Beginning merchandise inventory had a balance before adjustment of $3,150. The inventory at period end should be $6,795, requiring an entry to increase merchandise inventory by $3,645. Journal entries are not shown, but the following calculations provide the information that would be used in recording the necessary journal entries. Cost of goods sold was calculated to be $9,360, which should be recorded as an expense. The credit entry to balance the adjustment is for $13,005, which is the total amount that was recorded as purchases for the period. This entry distributes the balance in the purchases account between the inventory that was sold (cost of goods sold) and the amount of inventory that remains at period end (merchandise inventory).

Weighted-Average Cost (AVG)

Weighted-average cost allocation requires computation of the average cost of all units in goods available for sale at the time the sale is made. For The Spy Who Loves You, considering the entire period, the weighted-average cost is computed by dividing total cost of goods available for sale ($16,155) by the total number of available units (585) to get the average cost of $27.62. Note that 285 of the 585 units available for sale during the period remained in inventory at period end. Following that logic, ending inventory included 285 units at an average cost of $27.62 for a total AVG periodic ending inventory value of $7,872. Subtracting this ending inventory from the $16,155 total of goods available for sale leaves $8,283 in cost of goods sold this period. It is important to note that final numbers can often differ by one or two cents due to rounding of the calculations. In this case, the cost comes to $27.6154 but rounds up to the stated cost of $27.62.

Calculations of Costs of Goods Sold, Ending Inventory, and Gross Margin, Weighted Average (AVG)

The AVG costing assumption tracks inventory items based on lots of goods that are tracked but averages the cost of all units on hand every time an addition is made to inventory so that, when they are sold, the most recently averaged cost items are used to offset the revenue from the sale. The cost of goods sold, inventory, and gross margin shown below were determined from the previously-stated data, particular to AVG costing.

AVG Costing Assumption Cost of Goods Sold and Cost Value: Chart showing Cost of Goods Sold: Beginning Inventory $3,150 plus Purchases of 13,005 equals Goods Available of 16,155; minus Ending Inventory of 7,872 equals Cost of Goods Sold 8,283. Chart showing cost value: 285 units at $27.62 equals $7,872.

The picture below shows the gross margin resulting from the weighted-average periodic cost allocations of $8283.

Weighted AVG Periodic Cost Allocations Gross Margin:

Chart showing Gross Margin calculation: Sales of $11,340 minus Cost of Goods Sold 8,283 equals Gross Margin 3,057.

Journal Entries for Inventory Adjustment, Periodic/Weighted Average

Beginning merchandise inventory had a balance before adjustment of $3,150. The inventory at period end should be $7,872, requiring an entry to increase merchandise inventory by $4,722. Journal entries are not shown, but the following calculations provide the information that would be used in recording the necessary journal entries. Cost of goods sold was calculated to be $8,283, which should be recorded as an expense. The credit entry to balance the adjustment is for $13,005, which is the total amount that was recorded as purchases for the period. This entry distributes the balance in the purchases account between the inventory that was sold (cost of goods sold) and the amount of inventory that remains at period end (merchandise inventory).

KEY TAKEAWAYS

Key Concepts and Summary

  • The periodic inventory system updates inventory at the end of a fixed accounting period. During the accounting period, inventory records are not changed, and at the end of the period, inventory records are adjusted for what was sold and added during the period.
  • Companies using the periodic and perpetual method for inventory updating choose between the basic four cost flow assumption methods, which are first-in, first-out (FIFO); last-in, first-out (LIFO); specific identification (SI); and weighted average (AVG).
  • Periodic inventory systems are still used in practice, but the prevalence of their use has greatly diminished, with advances in technology and as prices for inventory management software have significantly decreased.

Adapted from Principles of Accounting, Volume 1: Financial Accounting (c) 2010 by Open Stax. The textbook content was produced by Open Stax and is licensed under a Creative Commons BY-NC-SA 4.0 license. Download for free at https://openstax.org/details/books/principles-financial-accounting

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Financial Accounting adapted by SPSCC Copyright © 2020 by OpenStax is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.

Share This Book