Math for Business Operations

Applied Accounting with Excel

UNIT07 - Lesson 8

Dress Rehearsal: One Shared Inventory Dataset, One Shared Workbook

45 minutes
Lesson Overview

Lesson Focus

Calculate inventory turnover ratio, chart COGS impact, create visualizations

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: Shared Dataset Practice
15 minutes

Work with a common inventory dataset to ensure all teams can produce consistent results

Details:

  • All teams use the same teacher-provided inventory dataset
  • Calculate COGS and ending inventory using all four methods
  • Verify results match expected answers
  • Build inventory turnover ratio calculation
Activity 2: COGS Impact Charting
15 minutes

Create professional visualizations comparing method impacts

Details:

  • Chart COGS under each method side by side
  • Chart ending inventory under each method side by side
  • Add professional formatting and clear labels
  • Interpret what the charts reveal about method selection
Visualization Best Practices

Executive audiences need clear, actionable visuals

  • Use consistent color coding across all charts
  • Include clear titles and axis labels
  • Add data labels for key values
  • Highlight the method recommendation visually
Activity 3: Workbook Polish
10 minutes

Finalize the shared workbook for professional presentation

Details:

  • Check all formulas for accuracy
  • Ensure consistent formatting across all sheets
  • Add navigation notes for non-technical users
  • Test dynamic method selection one final time
Activity 4: Preview Day 9
5 minutes

Set expectations for group project kickoff

Details:

  • Tomorrow: New business, new inventory data, same workbook logic
  • Teams will apply everything learned to a fresh dataset
  • Begin thinking about strategic rationale for method selection
Required Materials
  • Shared rehearsal inventory dataset
  • Chart creation guide
  • Sample visualization templates
  • Workbook verification checklist
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