Build the Inventory Method Workbook
Students move from correct hand calculations to a working method-comparison workbook. The same logic they learned by hand in Lessons 2-4 now lives in one file that switches methods, scales with data, and earns trust.
- ▶Build a workbook that computes COGS and ending inventory for FIFO, LIFO, Specific ID, and Weighted Average
- ▶Use Excel Tables and structured references so the model scales as transactions grow
- ▶Implement method-specific Excel algorithms (layer consumption, lot lookup, and pooled-rate logic) with clear helper blocks
- ▶Document assumptions so an investor can audit the method comparison
This lesson follows a structured 6-phase learning model designed for authentic project-based learning.
Hook
Open with a business scenario where Sarah needs to compare methods fast under investor scrutiny
Introduction
Teach the Excel algorithms for FIFO, LIFO, Specific ID, and Weighted Average
Guided Practice
Rehearse each workbook sheet with guided formula decoding before touching the real workbook
Independent Practice
Build the real method-comparison workbook and verify all four algorithms
Assessment
Technical check plus a brief artifact task: defend your method recommendation
Closing
Reflect on what the tool added and preview the dashboard integration in Lesson 06