Math for Business Operations

Applied Accounting with Excel

UNIT07 - Lesson 1

Launch & Data Exploration

45 minutes
Lesson Overview

Lesson Focus

Entry event with Sarah's inventory challenge and team formation

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: Sarah's Inventory Challenge Entry Event
15 minutes

Sarah Chen shares her growing business's inventory tracking problem

Details:

  • Video or case brief: Sarah explains her TechStart Solutions inventory challenge
  • Discussion: Why does inventory valuation matter for business decisions?
  • Introduction of provided inventory dataset for analysis
  • Connection to essential question: Which method best reflects our business reality?
Real-World Context

Inventory valuation affects reported profits, taxes, and investor confidence

  • Different methods produce different COGS and ending inventory values
  • Method choice impacts tax obligations and cash flow
  • Investors scrutinize inventory policies during due diligence
  • Consistency in method application is required for reliable financial reporting
Activity 2: Team Formation & Data Review
15 minutes

Form strategic teams and explore provided inventory dataset

Details:

  • Teams of 2-3 students formed based on complementary skills
  • Initial exploration of provided inventory CSV data
  • Identification of purchase layers, sales transactions, and inventory categories
  • Discussion of which valuation methods might apply to different inventory types
Activity 3: Industry Context Selection
10 minutes

Teams choose business context focus

Details:

  • Student voice and choice: Select retail, manufacturing, technology, or propose own
  • Each context emphasizes different inventory characteristics and valuation challenges
  • Teams commit to their chosen industry for consistency throughout unit
  • Preview of how context will affect method selection rationale
Activity 4: Challenge Framing & Preview
5 minutes

Set expectations and preview learning journey

Details:

  • Review unit timeline and major milestones
  • Preview final advisory brief and executive pitch
  • Establish learning objectives and success criteria
  • Address student questions about expectations and assessments
Required Materials
  • Sarah's case brief and inventory dataset
  • Inventory CSV files for team exploration
  • Industry context description sheets
  • Team formation materials and role assignment sheets
  • Unit overview and milestone timeline
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