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

  1. CASM Analysis answers any unit cost question for airline finance, with every number sourced.
  2. A tenth of a cent per seat mile is $100 million a year.
  3. Today, it's explained by hand.
  4. The CFO asks why CASM-ex fuel rose to 11.84 cents from 11.42.
  5. Agents fix the definition, then read the ledger, seat miles, and maintenance records.
  6. Maintenance adds 19 hundredths.
  7. 11-engine shop visits on the 787-9 fleet.
  8. Labor adds 15 and integration aid.
  9. Every figure opens its source.
  10. The FP&A director excludes integration.
  11. The agents recompute to 1176.
  12. A check agent ties both to the ledger and Form 41 and flags 1T, 100 difference.
  13. She approves the slides, and the CFO signs the section, cited, signed, and logged.
  14. The result? A unit cost, move explained in minutes, every cent tied to its source.
  15. Built on Botminds: agents, data, screens, and governance on one platform.

Transcribed from the film’s narration. Captions are on the player.