Teacher Resources
PayDay Simulator
How can a small business owner predict payroll cash-outs and still make rent on time?
Duration: 2 weeksDifficulty: Intermediate
Driving Question
Small business owners often struggle with cash flow timing, especially when payroll obligations coincide with other major expenses like rent. Through this unit, you'll build a comprehensive payroll system that helps predict and manage these cash flow challenges.
How can a small business owner predict payroll cash-outs and still make rent on time?
Performance Task
Local youth entrepreneurs need practical tools for managing payroll and cash flow. Your tutorial will be published on the school's YouTube channel to help the broader community.
PayDay Simulator Tutorial
Create and present a comprehensive screencast tutorial showing how to use your payroll system to prevent cash flow crises.
- Complete payroll calculator handling multiple employee types (hourly, tipped, salaried)
- Clear screencast demonstrating all system features and edge cases
- Professional presentation suitable for public YouTube publication
- Documentation showing how the system prevents cash flow problems
Assessment Milestones
Aligned to implemented student lessons
Day 3: Prototype Calculator
MilestoneSingle-employee payroll calculator with basic gross-to-net computation
- Accurate gross pay calculation for different employee types
- Correct withholding calculations using tax tables
- IF formulas for conditional deductions
- Clean, professional formatting
Day 4: Validation & Error Detection
MilestoneBulletproof the prototype with data validation and visual error checks
- Input validation prevents missing/invalid entries (IDs, hours, dates)
- Conditional formatting highlights errors and warnings
- Clear user guidance and labels for correction
- Error-checking system documents and flags edge cases
Day 5: Advanced Automation Engine
MilestoneScaled payroll engine with robust mapping and overtime logic
- Structured references and named ranges for reliability
- XLOOKUP maps employee data and tax tables with safe defaults
- Overtime/tiered logic implemented (e.g., SUMPRODUCT or equivalent)
- Automation passes advanced dataset with documented audit checks
Lessons (10)
Click a day to open the detailed lesson plan
Day 1
Launch & Explore: The Payroll Cash Crunch
Analyze realistic payroll timing crisis through interactive scenario
45 minutes
Day 2
Skill Introduction: Gross to Net Calculations
Master fundamental payroll mathematics with realistic scenarios
45 minutes
Day 3
Application Practice: Building the Prototype Calculator
Students build single-employee payroll calculator with guided support
45 minutes
Day 4
Making Your Calculator Bulletproof: Data Validation & Error Detection
Implement validation rules and visual error checks for reliability
45 minutes
Day 5
Advanced Automation: Payroll Tax & Overtime Engine
Engineer mapping and overtime logic; run mastery checks on advanced data
45 minutes
Day 6
New Skill Focus: XLOOKUP & Multi-Employee Systems
Master XLOOKUP for employee data management and payroll register creation
45 minutes
Day 7
Model Completion: 10-Employee System & Reconciliation
Complete full payroll system with bank reconciliation capabilities
45 minutes
Day 8
Presentation Prep: Tutorial Planning
Plan comprehensive tutorial explaining payroll system for business audience
45 minutes
Day 9
Mock Panel & Revisions: Tutorial Refinement
Receive feedback and refine tutorials for maximum impact
45 minutes
Day 10
Public Presentation: YouTube Publication & Business Q&A
Publish professional tutorials and engage with authentic business audience
45 minutes
Prerequisite Resources
Files referenced in student lessons
PayDay Simulator Templatedownload
Tax Tables Referencedownload
Sample Bank Statementsdownload
Bilingual Pay Stub Templatesdownload
Screencast Planning Guidedownload
Validation Practice Datasetdownload