Math for Business Operations

Applied Accounting with Excel

UNIT07 - Lesson 3

FIFO and LIFO: Two Ways to Value the Same Inventory

45 minutes
Lesson Overview

Lesson Focus

FIFO vs. LIFO logic and business implications

Key Unit Objectives

Enduring Understandings:

  • Inventory valuation methods directly impact reported profits, tax obligations, and business decision-making
  • FIFO, LIFO, Weighted Average, and Specific Identification produce different COGS and ending inventory values
  • Accurate inventory tracking is essential for business sustainability and investor confidence
  • The inventory equation (Beginning Inventory + Purchases − COGS = Ending Inventory) must always reconcile

Lesson Activities

Activity 1: FIFO Logic & Calculations
15 minutes

First-In, First-Out method with step-by-step examples

Details:

  • Visual demonstration: Physical inventory flow in retail/manufacturing
  • FIFO assumption: Oldest costs assigned to Cost of Goods Sold first
  • Practice calculation: Given purchases and sales, calculate COGS and ending inventory
  • Business implications: Impact on gross profit during price inflation
FIFO in Rising Price Environment

When prices increase, FIFO reports lower COGS and higher profits

  • Example: Buy inventory at $10 (Jan), $12 (Feb), $15 (Mar)
  • Sell 100 units in March: FIFO uses January cost ($10) first
  • Result: Lower COGS, higher gross profit, higher taxes
  • Strategic consideration: Better for investor relations, higher tax burden
Activity 2: LIFO Logic & Calculations
15 minutes

Last-In, First-Out method with comparative examples

Details:

  • LIFO assumption: Most recent costs assigned to Cost of Goods Sold first
  • Same data as FIFO practice: contrast the results
  • LIFO calculation: Use March costs ($15) for Cost of Goods Sold
  • Business implications: Higher COGS, lower profits, reduced taxes in inflation
Activity 3: Method Comparison & Peer Verification
10 minutes

Compare FIFO vs. LIFO results and verify accuracy

Details:

  • Side-by-side comparison: FIFO vs. LIFO schedules for same inventory
  • Discuss business implications: cash flow, taxes, financial reporting
  • Peer accuracy verification using provided rubric
  • Preview Day 4: Specific Identification and Weighted Average
Activity 4: Checkpoint
5 minutes

Quick understanding check

Details:

  • Students calculate basic FIFO and LIFO values independently
  • Review answers and address common errors
  • Milestone 1 checkpoint: Basic inventory schedule completed
Required Materials
  • FIFO/LIFO examples and templates
  • Visual aids showing inventory flow assumptions
  • Practice datasets with varying price scenarios
  • Peer accuracy verification rubric
Differentiation Strategies

For Struggling Students

  • • Formula templates: Pre-built Excel structures with guided parameter entry
  • • Step-by-step calculation guides: Visual walkthroughs for all four inventory methods
  • • Simplified datasets: Reduced complexity while maintaining authentic business context
  • • Peer tutoring: Pairing with students strong in Excel or business concepts
  • • Alternative assessment: Oral presentation option with reduced Excel complexity requirements

For Advanced Students

  • • Advanced Excel features: Explore LIFO reserve and tax implications as extension activity
  • • Complex scenarios: Multiple inventory categories and sensitivity analysis on purchase timing
  • • Leadership roles: Facilitate team strategic discussions and mentor struggling peers
  • • Extension analysis: Research industry-specific inventory practices and regulatory requirements
  • • Presentation enhancement: Develop sophisticated visual aids and executive summary documents

For English Language Learners

  • • Business vocabulary support: Glossary of inventory terms with visual aids and translations
  • • Calculation emphasis: Focus on quantitative skills while building language gradually
  • • Collaborative support: Mixed-language team structures with peer translation assistance
  • • Visual learning aids: Charts, diagrams, and flowcharts to support conceptual understanding
  • • Presentation alternatives: Option to focus on Excel demonstration with reduced verbal component