Math for Business Operations

Applied Accounting with Excel

UNIT07 - Lesson 9

Group Project Kickoff: New Business, New Inventory Data, Same Workbook Logic

45 minutes
Lesson Overview

Lesson Focus

Outline strategic rationale, draft written brief, peer critique

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: New Dataset Introduction
10 minutes

Each group receives a unique inventory dataset for a new business

Details:

  • Distribute group-specific inventory datasets
  • Teams review new data and identify inventory characteristics
  • Confirm workbook structure matches rehearsal format
  • Set expectations for final deliverables
Activity 2: Strategic Rationale Development
15 minutes

Develop the business case for inventory method selection

Details:

  • Analyze new dataset: What type of inventory? What industry?
  • Evaluate which method best fits this business context
  • Consider tax implications, cash flow, and reporting objectives
  • Draft written brief with supporting analysis
Building a Strong Recommendation

Executive recommendations need evidence, not just opinion

  • Start with a clear claim: 'We recommend [method] because...'
  • Support with COGS and ending inventory calculations
  • Include inventory turnover ratio analysis
  • Address potential risks or limitations of the chosen method
Activity 3: Peer Critique Session
15 minutes

Exchange draft briefs and provide structured feedback

Details:

  • Teams swap advisory brief drafts
  • Use peer critique form to evaluate clarity, evidence, and professionalism
  • Provide specific, actionable feedback
  • Identify top 2 improvements to apply before Day 10
Activity 4: Revision Planning
5 minutes

Plan final revisions based on peer feedback

Details:

  • Review peer feedback and prioritize changes
  • Assign revision tasks to team members
  • Set timeline for completing final deliverables
  • Preview Day 10: Final presentation to executive panel
Required Materials
  • Group-specific inventory datasets
  • Brief outline template
  • Peer critique form
  • Recommendation structure guide
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