Lesson ProgressPhase 3 of 6
Phase 3Guided Practice
Guided Practice: Build the Inventory Method Workbook
Rehearse each workbook sheet with guided formula decoding before touching the real workbook
Phase 3: Safe Rehearsal
Rehearse the Excel Algorithms Before Workbook Build
This is a guided walkthrough, not a multiple-choice test. Decode the table references, practice explaining each formula, and follow the same sheet order you will use in Phase 4.
How to Use This Simulator
- Work one sheet at a time (FIFO, LIFO, Specific ID, Weighted Average, Outputs).
- For each sheet, read what each formula reference means in plain English.
- Write a short explanation in your own words, then compare with the model response.
- Use the trap + audit checks so you know what to verify during the real build.
When you can explain each sheet's formulas clearly, you are ready for the workbook sprint.
Guided Rehearsal Navigator
Move sheet-by-sheet in the same order you will build in Excel.
FIFO Build Rehearsal
Sheet: FIFOTarget output: FIFO COGS and FIFO Ending Inventory
| Build Step | Formula / Pattern | What It Means |
|---|---|---|
| Cumulative quantity | SUM($B$2:B2) | Adds lot quantities from the first FIFO row through this row. |
| Units consumed in this lot | MAX(0, MIN([@Qty], UnitsSold - ([@[FIFO CumQty]] - [@Qty]))) | Consumes only the units still needed after older lots have already been used. |
| Lot cost used | =[@[FIFO Used]]*[@UnitCost] | Converts consumed units from this lot into cost. |
Reference Decoder
[@Qty]: Qty value in this FIFO row only.[@[FIFO CumQty]]: Running total quantity in this FIFO row.UnitsSold: Named cell holding total sold units.
Common trap: Using cumulative quantity from a different sort order gives wrong lot consumption.
Audit check: FIFO COGS + FIFO EI must equal GAFS.
Talk-Through Practice (Not Graded)
Explain why the consume formula uses MAX and MIN together.