Note: ITD margin is muted by front-loaded engineering (CLIN-001/002) where labour intensity is higher. Forecast shows margin recovery in CLIN-004 Bus Mfg (lower labour-to-material ratio) and CLIN-005 AI&T (test labour at higher bill rate).
Programme-target margin remains 21.2% per EAC.
💰 Accounts Receivable · aging 2 invoices · $2.3M total
Runway: at -$3.0M/month current burn (with collections), 9.5 months runway before next CLIN-004 milestone billing in Q3-26 ($14.5M expected).
📈 KPI scorecard · Apr 2026
Metric
Apr
Trend (3mo)
Target
Status
DSO · Days Sales Outstanding
31
↘ 33→32→31
≤ 35
✓
DPO · Days Payable Outstanding
31
↗ 28→30→31
30 ± 3
✓
Inventory turns (annualised)
2.4
↗ 2.0→2.2→2.4
> 2.0
✓
Gross margin %
54.2%
↗ 50→52→54
> 35%
✓
Project CPI · ANDROMEDA
1.04
= 1.04→1.04→1.04
> 0.95
✓
Project SPI · ANDROMEDA
0.97
↘ 1.00→0.99→0.97
> 0.95
~
Cash runway (months)
9.5
↘ 11→10→9.5
> 6
✓
Backlog ($M)
119.3
↘ 130→127→119
> 50
✓
🔗 Where these numbers come from · 5 cross-system flows that close the loop
Revenue (4xxx) ← ARM
$5.26M Apr revenue is exactly the sum of Apr ARM events REV-007 + REV-008 (RE-003 cost-to-cost + RE-004 MES-driven). Reconciles to $0 variance on every close.
Direct material (5300) ← Procurement
$1.51M Apr material is sum of vendor bills 3-way matched in Apr (PO ↔ Receipt ↔ Bill). BCT $729K + Sodern $680K + smaller items. AP aging shows $3.1M open · payment scheduled Net-30.
Direct labour (5100/5200) ← Project Tasks
$740K Apr labour pulls from project timesheet entries against PROJ-A WBS tasks. Posts at standard cost rate with variance to actual run-rate. EVMS reconciles AC = labour + material.
Inventory (1320/1340) ← Items + WO
Raw $3.82M reflects on-hand serialised inventory at standard. WIP $740K = 2 RWs in Stage 4 install + sub-assy partial labour. Issues to WO drain raw, build WIP, deliver to FG on Stage 9.
$2.28M open from 2 invoices issued late Apr against milestones. Net-30 means receipt expected mid-May. DSO 31 days is on-target. Customer (defense, gov-paymaster) historically pays 28-35 days.
Trial Balance · summary by class
Full TB summary (182 active accounts · $84.2M balanced) is shown on the Period Summary tab. DR=CR variance is $0.
Full project P&L with EVMS roll-up is shown on the Period Summary tab. Direct material/labour/overhead pulls from procurement, project tasks, and burden allocations.
💡 Click any Bill # for full vendor bill detail (GL impact · payment schedule · 3-way match) ·
Click any PO # for full Purchase Order record (header · lines · vendor · receipts · compliance).
🏦 Bank Reconciliation · 4 accounts
All reconciled · 2026-04-30
Account
Bank
Type
NS balance
Bank statement
Variance
Last recon
Status
1010-01 · Operating
SVB · acct ****8442
Checking
$24,820,000
$24,820,000
$0
2026-04-30
✓ Reconciled
1010-02 · Payroll
SVB · acct ****8443
Checking
$1,820,000
$1,820,000
$0
2026-04-30
✓ Reconciled
1015 · Money market
BlackRock · MMF
Investment
$1,640,000
$1,640,000
$0
2026-04-30
✓ Reconciled
1020 · Wire-only
JPMorgan · acct ****1142
Checking
$120,000
$120,000
$0
2026-04-30
✓ Reconciled
Total cash
$28,400,000
$28,400,000
$0
—
—
Period close · 16-step checklist
Full close checklist (14 of 16 done · 2 in progress for May open) is shown on the Period Summary tab.