Reporting and Analyzing Inventories: Valuation, Cost Flows, and Periodic Accounting Systems

Core Learning Objectives in Inventory Accounting

  • Conceptual Framework (C1):

    • Identify the specific items comprising merchandise inventory.

    • Determine all expenditures and allowable costs included in merchandise inventory valuation.

  • Analytical Framework (A1–A3):

    • A1: Analyze the financial statement and income tax consequences of alternative inventory costing methods.

    • A2: Analyze the effects of merchandise inventory errors on both current and future financial statements.

    • A3: Evaluate inventory operational efficiency and management performance using financial ratios, specifically inventory turnover and days' sales in inventory.

  • Procedural Framework (P1–P3):

    • P1: Calculate ending inventory and cost of goods sold under a periodic inventory system using specific identification, first-in, first-out (FIFO\text{FIFO}), last-in, first-out (LIFO\text{LIFO}), and weighted average cost flow methods.

    • P2: Compute merchandise inventory valuation using the lower of cost or market (LCM\text{LCM}) / net realizable value (NRV\text{NRV}) rule.

    • P3 (Appendix 5A): Calculate inventory and cost of goods sold under a perpetual inventory system using FIFO\text{FIFO} and LIFO\text{LIFO}.

Determining Merchandise Inventory Items and Legal Ownership

  • General Definition and Scope:

    • Merchandise inventory consists of all goods owned by a company and held for sale in the ordinary course of business, regardless of the physical location of the goods when the inventory count is performed.

    • Special physical situations require distinct legal and ownership evaluations.

  • Goods in Transit:

    • Goods moving between buyer and seller require review of shipping terms to determine ownership at the balance sheet date.

    • FOB Shipping Point (Free On Board Shipping Point):

    • Ownership transfers from seller to buyer at the moment the carrier accepts the shipment at the shipping point.

    • The buyer pays the transportation costs (freight-in).

    • Goods in transit belong in the buyer's inventory, not the seller's.

    • FOB Destination (Free On Board Destination):

    • Ownership transfers from seller to buyer only after the merchandise arrives at the buyer's destination.

    • The seller pays the transportation costs (freight-out).

    • Goods in transit remain in the seller's inventory until physical delivery is finalized.


FOB shipping point versus FOB destination ownership and freight payment rules

  • Goods on Consignment:

    • Consignor: The legal owner of the merchandise.

    • Consignee: An agent who holds and sells the goods on behalf of the owner without taking title.

    • Inventory Reporting Rules:

    • Consigned merchandise remains in the inventory of the consignor until sold to an end consumer.

    • The consignee never reports consigned merchandise on its balance sheet.

  • Damaged or Obsolete Goods:

    • Merchandise that is damaged or obsolete and cannot be sold must be written off completely and excluded from ending inventory.

    • Damaged or obsolete merchandise that can still be sold at a discounted price must be reported at net realizable value (NRV\text{NRV}).

    • Net Realizable Value Calculation:     Net Realizable Value=Estimated Sales Price−Estimated Selling Costs\text{Net Realizable Value} = \text{Estimated Sales Price} - \text{Estimated Selling Costs}

    • An inventory write-down loss must be recognized immediately in the period when damage or obsolescence occurs.

Determining Merchandise Inventory Costs

  • General Capitalization Principle:

    • Inventory cost comprises all expenditures directly or indirectly necessary to bring an item into a salable condition and location.

  • Expenditures Capitalized into Inventory Cost:

    • Invoice purchase price of goods

    • Freight-in costs (shipping charges to bring items to the warehouse)

    • Shipping insurance while goods are in transit

    • Import duties and tariffs

    • Inspection costs incurred upon receipt

    • Conditioning, unpacking, and preparation costs necessary for sale

  • Reductions from Inventory Cost:

    • Purchase discounts taken for early payment

    • Purchase returns and allowances granted by suppliers

  • Inventory Cost Computation Formula:   Total Inventory Cost=Invoice Price+Freight-In+Shipping Insurance+Import Duty+Inspection Costs+Preparation Costs−Purchase Returns and Allowances−Purchase Discounts\text{Total Inventory Cost} = \text{Invoice Price} + \text{Freight-In} + \text{Shipping Insurance} + \text{Import Duty} + \text{Inspection Costs} + \text{Preparation Costs} - \text{Purchase Returns and Allowances} - \text{Purchase Discounts}

Comprehensive Practice: Correct Ending Inventory Determination

  • Baseline Scenario Data:

    • A warehouse physical inventory count on December 31 indicates an initial inventory value of $34,700\$34,700.

    • Several unrecorded or isolated items require valuation adjustments.

  • Item-by-Item Ownership and Adjustment Analysis:

    • Item a (Purchased Goods in Transit):

    • Goods costing $670\$670 purchased from a supplier are in transit with UPS on December 31 under terms FOB shipping point.

    • Accounting Assessment: Because terms are FOB shipping point, title passed to the buyer when shipped. The goods should have been included. An addition of $670\$670 is required.

    • Item b (Samples Out on Trial):

    • Samples costing $1,860\$1,860 were delivered to a customer on December 27 with an agreement that they will be returned on January 15.

    • Accounting Assessment: The company retains ownership of goods out on approval or trial. An addition of $1,860\$1,860 is required.

    • Item c (Sold Goods in Transit - FOB Shipping Point):

    • Goods sold to customers costing $6,100\$6,100 were shipped on December 31 under terms FOB shipping point, expected to arrive January 10.

    • Accounting Assessment: Title passed to the customer upon shipment on December 31. The goods were properly excluded from inventory. Adjustment is $0\$0.

    • Item d (Sold Goods in Transit - FOB Destination):

    • Goods sold to customers costing $2,500\$2,500 were shipped on December 31 under terms FOB destination, expected to arrive January 10.

    • Accounting Assessment: Title does not pass to the customer until delivery at destination in January. The company still owns the goods on December 31. An addition of $2,500\$2,500 is required.

  • Final Inventory Reconciliation:

    • Physical inventory count on December 31: $34,700\$34,700

    • Add Item a (Goods in transit, FOB shipping point): $670\$670

    • Add Item b (Samples out on trial): $1,860\$1,860

    • Add Item c (Goods in transit, FOB shipping point): $0\$0

    • Add Item d (Goods in transit, FOB destination): $2,500\$2,500

    • Correct Ending Inventory on December 31:     Correct Inventory=$34,700+$670+$1,860+$0+$2,500=$39,730\text{Correct Inventory} = \$34,700 + \$670 + \$1,860 + \$0 + \$2,500 = \$39,730

Internal Controls Over Physical Inventory Counts

  • Annual Physical Count Requirement:

    • Companies take a physical count of inventory at least once per fiscal year to verify physical existence and reconcile records.

    • When the physical count deviates from the perpetual Merchandise Inventory general ledger balance, an adjusting journal entry must be made to correct the balance (e.g., recording inventory shrinkage).

  • Key Internal Control Procedures for Inventory Counts:

    • Prenumbered Inventory Tickets: Count teams must use prenumbered inventory tags to track every tag and ensure no items are omitted or double counted.

    • Segregation of Duties: Counters should have no direct day-to-day responsibility for inventory custody or recordkeeping.

    • Detailed Verification: Counters must confirm the physical existence, quantity, and operating condition of every inventory item.

    • Independent Recounts: A second, independent count must be conducted by a different counting team.

    • Supervisory Confirmation: An inventory supervisor or manager must confirm that all merchandise items are tagged and counted exactly once.

Flow of Inventory Costs in Merchandising and Manufacturing


Flow of inventory costs for merchandisers and manufacturers

  • Three Stages of Inventory Cost Flow:

    • Stage 1: Purchasing or Production Activities: Direct acquisition or manufacturing of product units.

    • Stage 2: Balance Sheet Recognition: Accumulation of unsold asset costs in inventory accounts.

    • Stage 3: Income Statement Recognition: Expensing inventory costs to Cost of Goods Sold when sales occur.

  • Merchandising Company Cost Flow:

    • Purchases of merchandise directly enter the Merchandise Inventory asset account on the Balance Sheet.

    • Upon sale, the accumulated costs move to Cost of Goods Sold on the Income Statement.

  • Manufacturing Company Cost Flow:

    • Manufacturing combines three production elements:

    • Raw materials purchases enter Raw Materials Inventory.

    • Direct labor incurred is added directly to production.

    • Factory overhead incurred is applied to production.

    • Costs flow sequentially through three inventory accounts on the Balance Sheet:     Raw Materials Inventory→Work in Process Inventory→Finished Goods Inventory\text{Raw Materials Inventory} \rightarrow \text{Work in Process Inventory} \rightarrow \text{Finished Goods Inventory}

    • When finished goods are sold, costs move to Cost of Goods Sold on the Income Statement.

Inventory Formulas and Cost Flow Mechanics


Allocation of goods available for sale between balance sheet and income statement

  • Goods Available for Sale Equations:   Goods Available for Sale (GAFS)=Beginning Inventory+Net Purchases\text{Goods Available for Sale (GAFS)} = \text{Beginning Inventory} + \text{Net Purchases}   Goods Available for Sale (GAFS)=Ending Inventory+Cost of Goods Sold (COGS)\text{Goods Available for Sale (GAFS)} = \text{Ending Inventory} + \text{Cost of Goods Sold (COGS)}

  • Fundamental Inventory Equation:   Beginning Inventory+Purchases−Cost of Goods Sold=Ending Inventory\text{Beginning Inventory} + \text{Purchases} - \text{Cost of Goods Sold} = \text{Ending Inventory}   Beginning Inventory+Purchases−Ending Inventory=Cost of Goods Sold\text{Beginning Inventory} + \text{Purchases} - \text{Ending Inventory} = \text{Cost of Goods Sold}

  • Demonstration Calculation:

    • Beginning inventory: $40,000\$40,000

    • Purchases: $55,000\$55,000

    • Goods available for sale: $40,000+$55,000=$95,000\$40,000 + \$55,000 = \$95,000

    • Ending inventory (Balance Sheet asset): $35,000\$35,000

    • Cost of goods sold (Income Statement expense): $95,000−$35,000=$60,000\$95,000 - \$35,000 = \$60,000

  • Practice Problem: Computing Purchases (Harrison Company):

    • Given Financial Data:

    • Ending Inventory (Current Year): $272,522,000\$272,522,000

    • Ending Inventory (Previous Year / Current Beginning Inventory): $233,153,000\$233,153,000

    • Net Sales: $2,540,286,000\$2,540,286,000

    • Cost of Goods Sold (COGS\text{COGS}): $178,624,000\$178,624,000

    • Income Before Taxes: $172,345,000\$172,345,000

    • Formula Restructuring:     Purchases=Ending Inventory+Cost of Goods Sold−Beginning Inventory\text{Purchases} = \text{Ending Inventory} + \text{Cost of Goods Sold} - \text{Beginning Inventory}

    • Calculation:     Purchases=$272,522,000+$178,624,000−$233,153,000\text{Purchases} = \$272,522,000 + \$178,624,000 - \$233,153,000     Purchases=$451,146,000−$233,153,000=$217,993,000\text{Purchases} = \$451,146,000 - \$233,153,000 = \$217,993,000

Cost Flow Assumptions and Costing Methods

  • Separation of Physical Flow and Cost Flow:

    • Inventory costing methods do not require or assume that the physical flow of goods matches the cost flow assumption.

    • Companies select an assumption to allocate total goods available for sale between ending inventory and cost of goods sold.

  • The Four Inventory Costing Methods:

    • Specific Identification

    • First-In, First-Out (FIFO\text{FIFO})

    • Last-In, First-Out (LIFO\text{LIFO})

    • Weighted Average

  • Cost Flow Assumptions in High-Volume Operations:

    • Specific identification is impractical for large quantities of low-cost, homogeneous merchandise.

    • Most merchandising firms apply FIFO\text{FIFO}, LIFO\text{LIFO}, or Weighted Average.


Cost flow methods comparison of FIFO, LIFO, and weighted average

  • Comparative Foundations (Exhibit 5.2):

    • Baseline Scenario: Three inventory acquisitions: May 1 at $45\$45, May 3 at $65\$65, May 6 at $70\$70. One unit is sold for $100\$100.

    • First-In, First-Out (FIFO\text{FIFO}):

    • Costs flow in the exact order incurred.

    • Oldest cost assigned to COGS\text{COGS}: May 1 unit ($45\$45).

    • Gross profit: $100−$45=$55\$100 - \$45 = \$55.

    • Ending inventory: May 3 ($65\$65) + May 6 ($70\$70) = $135\$135.

    • Last-In, First-Out (LIFO\text{LIFO}):

    • Costs flow in reverse order of acquisition.

    • Most recent cost assigned to COGS\text{COGS}: May 6 unit ($70\$70).

    • Gross profit: $100−$70=$30\$100 - \$70 = \$30.

    • Ending inventory: May 1 ($45\$45) + May 3 ($65\$65) = $110\$110.

    • Weighted Average:

    • Costs flow based on average unit cost available.

    • Average unit cost: \frac{\$45 + \$65 + \70}{3} = \frac{\180}{3} = \$60

    • COGS\text{COGS} for 1 unit: 1×$60=$601 \times \$60 = \$60.

    • Gross profit: $100−$60=$40\$100 - \$60 = \$40.

    • Ending inventory (2 units): 2×$60=$1202 \times \$60 = \$120.

Periodic Inventory Costing Computations

  • Underlying Transaction Schedule (Exhibit 5.3):

    • Aug. 1: Beginning Inventory of 1010 units @ $91\$91 = $910\$910

    • Aug. 3: Purchase of 1515 units @ $106\$106 = $1,590\$1,590

    • Aug. 14: Sale of 2020 units @ retail price $130\$130

    • Aug. 17: Purchase of 2020 units @ $115\$115 = $2,300\$2,300

    • Aug. 28: Purchase of 1010 units @ $119\$119 = $1,190\$1,190

    • Aug. 30: Sale of 2323 units @ retail price $150\$150

    • Total units available for sale: 10+15+20+10=5510 + 15 + 20 + 10 = 55 units

    • Total cost of goods available for sale: $910+$1,590+$2,300+$1,190=$5,990\$910 + \$1,590 + \$2,300 + \$1,190 = \$5,990

    • Total units sold: 20+23=4320 + 23 = 43 units

    • Ending inventory units: 55−43=1255 - 43 = 12 units


Inventory purchasing and sales transaction activity schedule

  • 1. Specific Identification Method (Exhibit 5.4):

    • Specifically tracked units sold (4343 units total):

    • 1010 units from Aug. 1 @ $91\$91 = $910\$910

    • 1515 units from Aug. 3 @ $106\$106 = $1,590\$1,590

    • 1515 units from Aug. 17 @ $115\$115 = $1,725\$1,725

    • 33 units from Aug. 28 @ $119\$119 = $357\$357

    • Cost of Goods Sold: $910+$1,590+$1,725+$357=$4,582\$910 + \$1,590 + \$1,725 + \$357 = \$4,582

    • Specifically tracked units remaining (1212 units total):

    • 55 units from Aug. 17 @ $115\$115 = $575\$575

    • 77 units from Aug. 28 @ $119\$119 = $833\$833

    • Ending Inventory: $575+$833=$1,408\$575 + \$833 = \$1,408

    • Verification: $4,582+$1,408=$5,990\$4,582 + \$1,408 = \$5,990


Periodic inventory costing under specific identification

  • 2. Periodic First-In, First-Out (FIFO\text{FIFO}):

    • The earliest costs incurred are transferred to Cost of Goods Sold.

    • COGS\text{COGS} allocation (4343 units from earliest acquisitions):

    • 1010 units from Aug. 1 @ $91\$91 = $910\$910

    • 1515 units from Aug. 3 @ $106\$106 = $1,590\$1,590

    • 1818 units from Aug. 17 @ $115\$115 = $2,070\$2,070

    • Cost of Goods Sold: $910+$1,590+$2,070=$4,570\$910 + \$1,590 + \$2,070 = \$4,570

    • Ending inventory allocation (1212 units from latest acquisitions):

    • 22 units from Aug. 17 @ $115\$115 = $230\$230

    • 1010 units from Aug. 28 @ $119\$119 = $1,190\$1,190

    • Ending Inventory: $230+$1,190=$1,420\$230 + \$1,190 = \$1,420

    • Verification: $4,570+$1,420=$5,990\$4,570 + \$1,420 = \$5,990


Periodic inventory costing under first-in, first-out method

  • 3. Periodic Last-In, First-Out (LIFO\text{LIFO}):

    • The latest costs incurred are transferred to Cost of Goods Sold.

    • COGS\text{COGS} allocation (4343 units from newest acquisitions):

    • 1010 units from Aug. 28 @ $119\$119 = $1,190\$1,190

    • 2020 units from Aug. 17 @ $115\$115 = $2,300\$2,300

    • 1313 units from Aug. 3 @ $106\$106 = $1,378\$1,378

    • Cost of Goods Sold: $1,190+$2,300+$1,378=$4,868\$1,190 + \$2,300 + \$1,378 = \$4,868

    • Ending inventory allocation (1212 units from oldest acquisitions):

    • 1010 units from Aug. 1 @ $91\$91 = $910\$910

    • 22 units from Aug. 3 @ $106\$106 = $212\$212

    • Ending Inventory: $910+$212=$1,122\$910 + \$212 = \$1,122

    • Verification: $4,868+$1,122=$5,990\$4,868 + \$1,122 = \$5,990


Periodic inventory costing under last-in, first-out method

  • 4. Periodic Weighted Average Method:

    • Average cost per unit is calculated across all goods available for sale:     Weighted Average Cost per Unit=Total Cost of Goods Available for SaleTotal Units Available for Sale\text{Weighted Average Cost per Unit} = \frac{\text{Total Cost of Goods Available for Sale}}{\text{Total Units Available for Sale}}     \text{Weighted Average Cost per Unit} = \frac{\5,990}{55\text{ units}} = \108.91 (rounded)108.91\text{ (rounded)}

    • Cost of Goods Sold (4343 units):     COGS=43 units×$108.91=$4,683\text{COGS} = 43\text{ units} \times \$108.91 = \$4,683

    • Ending Inventory (1212 units):     Ending Inventory=12 units×$108.91=$1,307\text{Ending Inventory} = 12\text{ units} \times \$108.91 = \$1,307

    • Verification: $4,683+$1,307=$5,990\$4,683 + \$1,307 = \$5,990


Periodic inventory costing under weighted average method

Case Analysis and Costing Method Comparisons: Lopez Company

  • Acquisition Schedule for Current Year:

    • Jan. 1 Beginning Inventory: 9696 units @ $2.00\$2.00 = $192\$192

    • Mar. 7 Purchase: 220220 units @ $2.25\$2.25 = $495\$495

    • Jul. 28 Purchase: 544544 units @ $2.50\$2.50 = $1,360\$1,360

    • Oct. 3 Purchase: 480480 units @ $2.80\$2.80 = $1,344\$1,344

    • Dec. 19 Purchase: 160160 units @ $2.90\$2.90 = $464\$464

    • Total units available for sale: 1,5001,500 units

    • Total goods available for sale: $3,855\$3,855

    • Physical ending inventory: 150150 units

    • Units sold: 1,500−150=1,3501,500 - 150 = 1,350 units

  • Periodic FIFO Calculations:

    • Ending inventory consists of the most recent 150150 units (all from the Dec. 19 purchase):     Ending Inventory=150 units×$2.90=$435.00\text{Ending Inventory} = 150\text{ units} \times \$2.90 = \$435.00

    • Cost of Goods Sold (GAFS−Ending Inventory\text{GAFS} - \text{Ending Inventory}):     COGS=$3,855.00−$435.00=$3,420.00\text{COGS} = \$3,855.00 - \$435.00 = \$3,420.00

  • Periodic LIFO Calculations:

    • Ending inventory consists of the earliest 150150 units:

    • 9696 units from Jan. 1 @ $2.00\$2.00 = $192.00\$192.00

    • 5454 units from Mar. 7 @ $2.25\$2.25 = $121.50\$121.50     Ending Inventory=$192.00+$121.50=$313.50\text{Ending Inventory} = \$192.00 + \$121.50 = \$313.50

    • Cost of Goods Sold (GAFS−Ending Inventory\text{GAFS} - \text{Ending Inventory}):     COGS=$3,855.00−$313.50=$3,541.50\text{COGS} = \$3,855.00 - \$313.50 = \$3,541.50

  • Periodic Weighted Average Calculations:

    • Weighted average cost per unit:     \text{Average Unit Cost} = \frac{\3,855}{1,500\text{ units}} = \2.57 per unit2.57\text{ per unit}

    • Ending Inventory (150150 units):     Ending Inventory=150 units×$2.57=$385.50\text{Ending Inventory} = 150\text{ units} \times \$2.57 = \$385.50

    • Cost of Goods Sold (1,3501,350 units):     COGS=1,350 units×$2.57=$3,469.50\text{COGS} = 1,350\text{ units} \times \$2.57 = \$3,469.50

  • Comparative Financial Statement Impact Under Rising Inventory Costs:

    • Inventory acquisition costs trend upward over time (\2.00 \rightarrow \2.25 \rightarrow \2.50 \rightarrow \2.80→$2.902.80 \rightarrow \$2.90).

    • Cost of Goods Sold Comparison:     \text{FIFO } (\3,420.00) < \text{Weighted Average } (\3,469.50)<LIFO ($3,541.50)3,469.50) < \text{LIFO } (\$3,541.50)

    • Ending Inventory Comparison (Balance Sheet):     \text{FIFO } (\435.00) > \text{Weighted Average } (\385.50)>LIFO ($313.50)385.50) > \text{LIFO } (\$313.50)

    • Net Income and Gross Profit Impact:

    • Because revenues are constant, lower COGS\text{COGS} produces higher Gross Profit and higher Net Income.

    • FIFO\text{FIFO} yields the lowest COGS\text{COGS} and therefore the highest Net Income.

    • LIFO\text{LIFO} yields the highest COGS\text{COGS} and therefore the lowest Net Income (which provides tax advantages by reducing taxable income).

    • Weighted Average yields intermediary balances for both the Balance Sheet and Income Statement.