KOTA'S AEROSPACE

MRO Financial Intelligence

Operational cost intelligence, not accounting software. 3 of 17 work orders have recorded cost data — the remainder show “Insufficient source data.”, never a fabricated $0.

Partial Data

Financial Overview

Total MRO Cost

USD 25,330

Labor Cost

USD 1,510

Parts Cost

USD 19,220

Vendor Spend

USD 4,600

Customer Charges

USD 26,495

2 of 3 costed work order(s) have a charge on file

Gross Margin

USD 2,125

Section 2 — Cost by Aircraft

VT-ABCUSD 21,170 · 2/4 WO costed

N412MXUSD 4,160 · 1/3 WO costed

Section 3 — Cost Composition

LaborUSD 1,510 (6%)

PartsUSD 19,220 (76%)

VendorUSD 4,600 (18%)

“Other” cost category (tooling/consumables/subcontracting): Insufficient source data.

Section 4 — Cost by Work Order

Work Order	Aircraft	Labor	Parts	Vendor	Total Cost	Customer Charge	Margin	Status
WO-1042	VT-ABC	510	18,500	1,200	USD 20,210	USD 21,615	6.5%	Calculated
WO-1045	N412MX	760	0	3,400	USD 4,160	USD 4,880	14.8%	Calculated
WO-1050	VT-ABC	240	720	0	USD 960	Insufficient source data.	Insufficient source data.	Partial Data

14 of 17 work orders have no cost data recorded — not shown above rather than rendered as $0.

Section 5 — Estimated vs Actual

Insufficient source data. No estimated-cost field exists anywhere in the current work order domain model, so cost variance cannot be determined for any work order. This is a real data-model gap, not a calculation the system chose not to show.

Section 6 — Vendor Expenditure

Vendor	Spend	Orders	Lead Time	Rating
Borescope NDT Services (demo)	USD 1,200	1	Insufficient source data.	Insufficient source data.
Structures NDT Partners (demo)	USD 3,400	1	Insufficient source data.	Insufficient source data.

Section 7 — Margin Intelligence

Highest-cost work order: WO-1042 (USD 20,210)
Best-margin work order: WO-1045 (14.8%)
Highest-cost part: part-2 — USD 18,500
Highest vendor spend: Structures NDT Partners (demo) — USD 3,400
Largest overrun: Insufficient source data — no estimated cost exists to compare against.

Traceability

Aircraft → Work Order → Labor / Parts / Vendor → Cost → Customer Charge → Margin. Every figure above traces to a labeled DEMO_SEED record in lib/mock/finance.ts on a real, existing work order — nothing is invented. Ask Lisa a financial question, or generate the Financial Intelligence report.