NetSuite · FP&A · Aerospace Demo

NetSuite Aerospace Demo

Role · Controller + FP&A AEROSPACE-DEMO

Home › Financial › FP&A · Budget + Forecast FY2026 plan · YTD actuals through 2026-04-30

📊 KPI Scorecard

📈 Budget vs Actual

🔮 Rolling Forecast

🚀 Project EAC / ETC

💰 13-week Cash Flow

👥 Headcount Plan

🏗 Capex Plan

📋 Backlog

🪣 Indirect Rate True-up

📊 Executive KPI Scorecard · FY2026 YTD through 2026-04

📌 Mid-quarter narrative

Q2 mid-quarter status (April 2026): primary build is mid-program · MES Stage 4 in progress · CLIN-003 long-lead all received with 1 NCR closed (use-as-is) · milestone-4 build milestones beginning to recognise.

Headwinds: L3Harris telescope expedite premium ($14K) drove CPI to 0.964 · PROP-TANK Moog Bradford slip risk under monitor · YTD net loss $2.6M wider than plan due to early Mfg OH absorption ahead of build-stage revenue.

Tailwinds: SAT-002 framework option (~$30M) tracking close-Q3 with Apex · DSO consistently inside Net 30 · cash burn 25.3 months runway · headcount on plan at 180 (target 218 EOY).

📈 Budget vs Actual · FY2026 by month · all GL accounts

FY26 Budget Revenue

—

FY26 Budget Direct Cost

—

FY26 Budget OpEx

—

FY26 Budget Net Income (Loss)

—

Legend: Blue = actual (closed periods) · Italic amber = forecast (open / future) · variance > 5% highlighted.

🔮 Rolling Forecast · revised plan · YTD actual + remainder forecast

Methodology: Q1 actuals + April in-flight + May-Dec forecast. Forecast updates monthly at FP&A close-out. Q4 expense forecast revised up 2% (Mfg OH absorption · test phase ramp); test costs (5240) revised up 8% reflecting acceptance test campaign load.

🚀 Project Forecast · EAC / ETC · EVMS-driven

💰 13-week Cash Flow Forecast

Cash starting (May 4)

—

Cash ending (Aug 2)

—

Net change

—

Lowest week balance

—

👥 Headcount Plan · FY2026 EOY target 218 (current 180 · +38 net)

Current

—

EOY target

—

Delta

—

Cost per hire

—

Hiring by quarter

Attrition assumption: 8% annual · 14 backfills built into plan · cost per hire $22K (avg) · Restricted clearance pre-screen adds 2-3 weeks to time-to-fill.

🏗 FY2026 Capital Plan · $2.32M total

Capitalisation policy: > $5K threshold capitalised · depreciated 5-7 years (test equipment) or 39 years (cleanroom build-out leasehold). Below threshold expensed to 6320 IT hardware or relevant OpEx account.

📋 Funded Backlog · Recognised vs Remaining

Funded backlog (remaining)

—

Book-to-bill (TTM)

—

Burn (months)

—

Pipeline · weighted

—

🎯 Pipeline · Unfunded Options + Pursuits

🪣 Indirect Rate True-up · YTD Actual vs Compliance Reviewer-Approved Provisional

Process: Compliance Reviewer approves provisional rates annually. Throughout the year, FP&A monitors YTD actual cost-pool absorption vs provisional. If variance > 0.5pts trends sustained, submit revised provisional to Compliance Reviewer for current-year billing rate. Final true-up at fiscal year-end via Cost-Auditor-audited Incurred Cost Submission (ICS).