CASM Analysis demo
Explains each move in cost per seat mile from the ledger and Form 41, for FP&A teams 1:32
What the demo shows
CASM analysis for airline FP&A: any unit-cost move, by fleet or station, explained with sources
The CFO asks why CASM-ex rose to 11.84 cents in the quarter from 11.42. The FP&A Director asks the agents. A planner agent fixes the definition (CASM-ex v3) and the period; the ledger, capacity and driver agents read 214 accounts, 31.40B seat miles, the payroll register, the shop-visit log and the integration project ledger. The answer comes back in one sentence and three drivers: maintenance +0.19 cents from 11 engine shop visits on one widebody fleet against 4, labor +0.15 from a mid-year pilot pay step, integration +0.08; everything else nets to zero. Every figure opens its ledger account, Form 41 P-6 line or log, and a strip by fleet shows that fleet at +0.82. The director asks to exclude integration; the agents recompute to 11.76 cents and keep both versions. A check agent ties both to the ledger and to the draft P-6 and flags one T-100 seat-count difference, with a fix for Regulatory Reporting. The briefing agent drafts the slides and the script line; the FP&A Director approves, Investor Relations approves the wording, and the CFO signs the section.
Transcript
- CASM Analysis answers any unit cost question for airline finance, with every number sourced.
- A tenth of a cent per seat mile is $100 million a year.
- Today, it's explained by hand.
- The CFO asks why CASM-ex fuel rose to 11.84 cents from 11.42.
- Agents fix the definition, then read the ledger, seat miles, and maintenance records.
- Maintenance adds 19 hundredths.
- 11-engine shop visits on the 787-9 fleet.
- Labor adds 15 and integration aid.
- Every figure opens its source.
- The FP&A director excludes integration.
- The agents recompute to 1176.
- A check agent ties both to the ledger and Form 41 and flags 1T, 100 difference.
- She approves the slides, and the CFO signs the section, cited, signed, and logged.
- The result? A unit cost, move explained in minutes, every cent tied to its source.
- Built on Botminds: agents, data, screens, and governance on one platform.
Transcribed from the film’s narration. Captions are on the player.