Power BI Smart AMS workspace › Owner's Pack
Data refreshed 6:04 AM · Dataset: RAAS production (SQL, read-only)
PROTOTYPE — synthetic data only. This mocks the Power BI workspace included with a RAAS licence; shapes are realistic, numbers are invented; nothing here leaves your browser.

The monthly pack your ERP won't print: margin by line of business, quote-vs-actual while the aircraft is still in the hangar, labour recovery, WIP, signer coverage, customer concentration — the numbers a buyer, a lender, or you at 11 p.m. on a Sunday actually trust. Built with the Power BI licence already included with RAAS.

Labour capture covered 61% of paid hours this month — these numbers are only as good as the scans. Revenue and WIP come straight off invoices and hold; margins, burn-down projections and recovery ride the scans, so they render with a ~ until capture is back above 75%. One example: an E175 below shows an 18% under-run — at 61% capture that's missing scans, not efficiency.

Revenue — May 2026

$2,096,532

invoiced across four lines of business

Blended gross margin

25.5%

heavy at 17.8% — the line to watch

Labour recovery, billed ÷ paid

80.7%

St. Thomas 76.4% · YYZ 86.9%

WIP > 90 days

$329,907

of $2,557,681 started, not yet invoiced

Gross margin by line of business

Source: RAAS invoicing · job costing — Feb to May 2026, selected month marked

Margin by line of business

Source: RAAS invoicing · expense centers — heavy: 24.1% in Feb, 17.8% by May

Line of businessRevenue Gross marginvs last month

Labour recovery by site

Source: RAAS labour capture (scan clock-ins) · customer invoicing — billed hours ÷ paid hours

SitePaid hrs Billed hrsRecovery

Every point of recovery across 70 AMEs is worth ≈ $151,200/yr at a $120 billed-out hour. This month’s combined rate is 80.7%; the gap to a defensible 85% is ≈ $649,112/yr.

Quote vs. actual — heavy checks in work

Source: RAAS work orders · quotes · scanned labour — projection = burned hours ÷ percent complete. The point is the date: a check projecting past quote on day 12 can be re-scoped; the same number found at invoicing is margin already spent.

TailType · check DayQuoted hrs Burned hrsComplete Projected at completionvs quote

WIP aging — started, not invoiced

Source: RAAS work orders · invoicing — work performed that hasn't reached an invoice yet, by age

Reading the 90+ bucket

Source: RAAS work orders · invoicing

The 90+ bucket is finished work earning nothing — $329,907 of it this month. A buyer's quality-of-earnings team reads a stale WIP ledger as an estimate factory; you should read it as the collections list.

Endorsement coverage — licence holders by type and shift

Source: RAAS personnel authorizations — one name in a cell is a single point of failure; the September A220 heavy slot currently has exactly one nights signer

TypeDays Afternoons Nights

signers per shift ·one signer — single point of failure ·none — slot cannot be worked

Customer concentration

Source: RAAS customer invoicing — top five customers as a share of the month's revenue; names withheld even in a synthetic pack

Anything over 25% on one customer gets re-priced in diligence and reads as covenant material to a lender. Not a number to hide — a number to manage, and you only manage what you can see.