Math for Business Operations

Applied Accounting with Excel

UNIT05 - Lesson 1

Launch & Explore: The Payroll Cash Crunch

45 minutes
Lesson Overview

Lesson Focus

Analyze realistic payroll timing crisis through interactive scenario

Key Unit Objectives

Enduring Understandings:

  • Accurate payroll calculations protect both employees and business owners from legal and financial risks
  • Cash flow timing is critical - payroll commitments must align with revenue cycles
  • Systematic reconciliation processes prevent costly errors and maintain compliance
  • Professional payroll systems build employee trust and business credibility

Lesson Activities

Activity 1: Café Owner Crisis Skit
8 minutes

Watch dramatic scenario of small business payroll emergency

Details:

  • Students watch 3-minute skit showing café owner Maria discovering overdraft after payroll
  • Scenario reveals timing mismatch: payroll processed Friday, but weekend receipts not deposited
  • Maria faces choice: bounce payroll checks or emergency loan with high fees
Real Business Impact

43% of small businesses struggle with payroll cash flow timing

  • Overdraft fees: $35-50 per bounced payroll check
  • Employee trust: Lost when paychecks bounce or are delayed
  • Legal liability: Penalties for late payroll can reach $5,000+
  • Emergency loans: Interest rates of 15-30% for payroll advances
Video: Maria's Friday Crisis: When Payroll Goes Wrong (3 minutes)

Follow café owner Maria through a realistic payroll crisis where timing mismatches create cash flow emergencies. See the real business impact of poor payroll planning.

Activity 2: Bank Statement Analysis
15 minutes

Students analyze Maria's actual bank statement and payroll register

Details:

  • Review Maria's bank statement showing transaction timing patterns
  • Compare payroll register entries with actual bank debits
  • Identify the timing gaps that caused the overdraft situation
  • Calculate the true cost of Maria's payroll timing mistake
Activity 3: Payroll Challenge Brainstorm
12 minutes

Teams identify payroll risks and brainstorm solutions

Details:

  • Think-Pair-Share: What payroll mistakes could destroy a small business?
  • Team discussion: How can Excel help business owners avoid Maria's mistakes?
  • Class sharing: What features would make a 'smart' payroll system?
Activity 4: Project Introduction & Team Formation
10 minutes

Introduce PayDay Simulator challenge and form teams

Details:

  • Present essential question: How can we predict payroll cash-outs and avoid Maria's crisis?
  • Form teams of 2-3 students to build comprehensive payroll system
  • Teams choose employee scenario focus: hourly workers, tipped employees, or salaried staff
  • Initial planning: What does our chosen business type need most?
Required Materials
  • Maria's Crisis video and discussion guide
  • Sample bank statement and payroll register (realistic data)
  • Interactive timeline matching activity
  • Team formation materials and scenario selection cards
Differentiation Strategies

For Struggling Students

  • • Pre-filled Calculator Templates: Provide partial Excel structures to reduce complexity
  • • Step-by-Step Formula Guides: Visual walkthroughs for complex calculations
  • • Simplified Scenarios: Focus on hourly employees before adding salaried/tipped
  • • Extra Practice Time: Additional support sessions for Excel skill building

For Advanced Students

  • • Multi-Jurisdiction Payroll: Handle employees in different states with varying tax rules
  • • Advanced Excel Features: Explore Power Query for large payroll data processing
  • • Leadership Roles: Mentor struggling students and facilitate team discussions
  • • Business Extension: Research actual payroll service costs vs. internal processing

For English Language Learners

  • • Bilingual Resources: Payroll terms glossary in home language
  • • Visual Calculation Guides: Infographics showing payroll process flow
  • • Cultural Context: Examples relevant to diverse cultural backgrounds
  • • Translation Support: Peer translators for complex business concepts