KOTA'S AEROSPACE · Report
MRO Financial Intelligence Report
FINANCIAL INTELLIGENCEScope: Fleet-wide · Generated 2026-03-17 · From: Lisa (Prototype)
Source modules: Work Orders, Aircraft, Parts, Technicians, Finance (demo cost records)
Financial KPIs
Total MRO Cost
25,330 USD
Labor Cost
1,510 USD
Parts Cost
19,220 USD
Vendor Spend
4,600 USD
Customer Charges
26,495 USD
Gross Margin
2,125 USD
3 of 17 work orders have recorded cost data.
Cost by Aircraft
| Aircraft | Total Cost | Work Orders Costed |
|---|---|---|
| VT-ABC | 21170 | 2/4 |
| N412MX | 4160 | 1/3 |
Cost by Work Order
| Work Order | Aircraft | Labor | Parts | Vendor | Total Cost | Customer Charge | Margin % |
|---|---|---|---|---|---|---|---|
| WO-1042 | VT-ABC | 510 | 18500 | 1200 | 20210 | 21615 | 6.5% |
| WO-1050 | VT-ABC | 240 | 720 | 0 | 960 | Insufficient source data. | Insufficient source data. |
| WO-1045 | N412MX | 760 | 0 | 3400 | 4160 | 4880 | 14.8% |
Labor vs Parts vs Vendor
Vendor Spend
| Vendor | Total Spend |
|---|---|
| Borescope NDT Services (demo) | 1200 |
| Structures NDT Partners (demo) | 3400 |
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.
Margin Analysis
No work orders with both cost and customer-charge data show a negative margin.
Highest single part cost: part-2 — 18,500 USD.
Highest single vendor line item: Structures NDT Partners (demo) — 3,400 USD.
Cost Risks
14 work order(s) have no cost data recorded at all — financial exposure on these is unknown, not zero.
1 costed work order(s) have no customer charge on file — margin cannot be determined for these.
Cost variance cannot be determined because no estimated-cost field exists in the domain model.
Executive Actions
VT-ABC carries the highest recorded maintenance cost — review for recurring cost drivers.
Extend cost recording to the remaining uncosted work orders for a complete financial picture.
AI-Generated Summary
3 of 17 work orders costed; total recorded cost 25,330 USD; gross margin 2,125 USD.
AI Prototype · Based on current KOTA'S AEROSPACE demo data · Non-authoritative · Human review required.
AI-assisted analysis — non-authoritative. Verify against source records before operational/commercial decisions.
Prototype limitation: this report is generated client-side from in-memory demo data. Regenerating produces the same result unless the underlying mock data changes; nothing here is backend-persisted.