Project Control Tower Dashboard
Integrated Earned Value Management & Agent Intelligence System
📊 Portfolio Control Tower — Project Summary Aggregate KPIs across all active projects | Last updated: 2026-06-30
⚓ Executive Portfolio Overview
The project portfolio currently consists of 6 projects spanning maritime vessel fabrication, logistics solutions, and subsea structures. As of the latest reporting cycle, the portfolio has a total baseline budget (BAC) of 7,100,000 USD, with 5,220,810 USD logged in actual costs (AC) and 4,752,500 USD earned in physical progress value (EV). The aggregate portfolio Cost Performance Index (CPI) stands at a stable 0.91. Individual active projects exhibit cost and schedule pressures, but overall execution remains within manageable tolerances.
Project Highlights & Statuses:
- PRJ-001 (Composite Vessel Construction): Completed with a total spend of 1.85M USD against a 1.5M USD budget, resulting in a -356K USD cost overrun (CPI: 0.81).
- PRJ-002 (Patrol Vessel Carbon Mold): Planned to start in August 2026 with an approved budget of 800K USD. No actuals logged yet.
- PRJ-003 (Subsea Cable Frame): Active at 30% progress. Tracking slightly over budget with 382.5K USD spent to earn 360K USD (CPI: 0.94).
- PRJ-004 (Autonomous Workboat Hull): Active at 70% progress. Showing mild cost pressure with 1.48M USD spent to achieve 1.4M USD of value (CPI: 0.95).
- PRJ-005 (Defense Logistics Pontoon): Active at 90% progress, managed by Frank Ellingsen. In good financial standing with 927K USD spent to achieve 900K USD of value (CPI: 0.97).
- PRJ-006 (Lightweight Cargo Hatch): Completed successfully under budget, spending 586.5K USD on a 600K USD baseline budget (CPI: 1.02, progress 100%).
📈 Portfolio Financial Ratios & Forecasts
📋 Portfolio Project Breakdown
| Project ID | Project Name | Manager | BAC (USD) | AC (USD) | EV (USD) | CPI | Progress | VAC (USD) | Status |
|---|---|---|---|---|---|---|---|---|---|
| PRJ-001 | Composite Maritime Vessel Construction | Morten Hansen | 1,500,000 | 1,848,810 | 1,492,500 | 0.81 | 99.5% | -359,559 | 🔴 Over Budget |
| PRJ-002 | Patrol Vessel Carbon Mold Design | Morten Hansen | 800,000 | 0 | 0 | 1.00 | 0.0% | 0 | ⚪ Planned |
| PRJ-003 | Subsea Cable Installation Frame | Erik Johansen | 1,200,000 | 382,500 | 360,000 | 0.94 | 30.0% | +30,556 | 🟡 Overrun Warn |
| PRJ-004 | Autonomous Workboat Hull Weldments | Astrid Nilsen | 2,000,000 | 1,476,000 | 1,400,000 | 0.95 | 70.0% | -156,000 | 🟡 Overrun Warn |
| PRJ-005 | Defense Logistics Pontoon Build | Frank Ellingsen | 1,000,000 | 927,000 | 900,000 | 0.97 | 90.0% | -32,714 | 🟢 Active |
| PRJ-006 | Lightweight Composite Cargo Hatch | Morten Hansen | 600,000 | 586,500 | 600,000 | 1.02 | 100.0% | +13,500 | 🟢 Completed |
📅 Interactive Schedule & WBS Gantt Chart
Select Project Context:
Deviation Focus:
■
Planned Baseline
■
On Track
■
Overrun/Deviation
| WBS Code | Element Name | BAC (USD) | AC (USD) | EV (USD) | CPI | Percent Complete | EAC Typical (USD) | Status |
|---|
🌲 Interactive WBS Hierarchy Explorer
Click WBS nodes to expand task details, baseline schedules, labor roles, and committed costs.
📂 WBS 1.0 - Project Management & Engineering (🟢 Active)
- 1.1 Project Controlling & PM: Planned: 150h | Actual: 180h. Cost: 120,000 USD.
- 1.2 Structural Design & Drafting: Planned: 200h | Actual: 210.8h. Cost: 210,000 USD.
- 1.3 Systems Integration Planning: Planned: 50h | Actual: 50h. Cost: 89,230 USD.
Leading Resource Role: Senior Design Engineer, Financial Controller.
📂 WBS 2.0 - Hull Fabrication & Assembly (🟢 Active)
- 2.1 Jig Setup & Alignment: Planned: 300h | Actual: 290h. Cost: 150,000 USD.
- 2.2 Carbon Fiber Infusion: Planned: 600h | Actual: 150.5h. Cost: 300,000 USD.
- 2.3 Demolding & Inspection: Planned: 300h | Actual: 73h. Cost: 170,450 USD.
Leading Resource Role: Composites Lead Technician, Structural Welder.
📂 WBS 3.0 - Outfitting & Integration (🟢 Active)
- 3.1 Propulsion Engine Rigging: Planned: 300h | Actual: 210.5h. Cost: 180,000 USD.
- 3.2 Piping & Valve Manifolds: Planned: 300h | Actual: 140.6h. Cost: 220,000 USD.
- 3.3 Electrical & Automation Wiring: Planned: 200h | Actual: 50h. Cost: 140,445 USD.
Leading Resource Role: Marine Outfitting Supervisor, Marine Electrician.
📂 WBS 4.0 - Sea Trials & Handover (🟢 Active)
- 4.1 Pier-Side Machinery Checkout: Planned: 100h | Actual: 90.5h. Cost: 80,000 USD.
- 4.2 Sea Endurance Trials: Planned: 150h | Actual: 160h. Cost: 120,000 USD.
- 4.3 Survey Certification (DNV): Planned: 50h | Actual: 30h. Cost: 68,685 USD.
Leading Resource Role: Sea Trials Captain, DNV Class Surveyor.
| Audit Indicator | Value / Metric | Status |
|---|---|---|
| Projected Margin Variance (VAC) | -359,559 USD | Macro Risk |
| Typical Estimate at Completion (EAC) | 1,859,559 USD | Forecasted |
| Labor Costs Allocation | 1,326,810 USD | 71.8% Share |
| Materials & Procurement Costs | 522,000 USD | 28.2% Share |
🚨 Overtime Anomaly Audit (>45 hrs/week)
| Work Week | Resource | Role | Total Hours |
|---|
💳 Large Procurement Audit (>50,000 USD)
| Purchase Date | Invoice # | Item Description | Cost (USD) |
|---|
📋 Active RAID Log Register
| RAID ID | Category | Description | Impact | Probability | Owner | Status |
|---|
Structural Assembly Progress & Physical Milestones
| WBS Code | Structural Element | Physical Progress | Status |
|---|---|---|---|
| 1.0 | Project Management & Engineering | 97.5% | Design Verification Phase |
| 2.0 | Hull Fabrication & Assembly | 100.0% | Structural Assembly Certified |
| 3.0 | Outfitting & Integration | 100.0% | System Integration Complete |
| 4.0 | Sea Trials & Handover | 100.0% | Maritime Readiness Verified |
📋 Active Corrective Action Items
Priority: Critical
Reason: Cost overrun of 119k USD in PM & Eng
and 140k USD in Outfitting.
Action: Renegotiate contractor rates, freeze
non-essential variation orders, and restrict scope expansion.
Priority: Medium
Reason: Fabricated 10 days early but slightly
exceeded BAC.
Action: Shift excess structural labor to
delayed outfitting tasks to optimize yard-wide capacity.
Priority: High
Reason: Sea trials schedule slipped by 10
days.
Action: Enforce double-shift schedules for
final testing, pre-commissioning checkouts, and DNV witness
surveys.
🎛️ What-If Corrective Simulator
Simulate the financial impact of implementing corrective controlling actions in real time:
📊 Simulated Results
📚 Earned Value Management (EVM) Glossary
This glossary details the mathematical definitions, equations, and AACE / PMI international compliance guidelines utilized within this dashboard.
| Term / KPI | Equation | Description | AACE Compliance |
|---|---|---|---|
| BAC (Budget at Completion) | Baseline Budget | The total authorized budget for the project's scope of work. | Baseline Value |
| PV (Planned Value) | BCWS (Budgeted Cost of Work Scheduled) | The authorized budget planned for work scheduled to be completed. | Baseline Distribution |
| EV (Earned Value) | BCWP (Budgeted Cost of Work Performed) | The measure of work performed expressed in terms of the budget authorized for that work. | Physical Progress Value |
| AC (Actual Cost) | ACWP (Actual Cost of Work Performed) | The total cost actually incurred for work performed. | Accounting Cost Data |
| CPI (Cost Performance Index) | EV / AC |
A measure of cost efficiency. Values < 1.0 indicate overrun. | Standard Ratio |
| SPI (Schedule Performance Index) | EV / PV |
A measure of schedule efficiency. Values < 1.0 indicate delay. | Standard Ratio |
| EAC Typical | BAC / CPI |
Forecasted final cost assuming current cost performance trends persist. | Recommended for persisting deviations |
| EAC Atypical | AC + (BAC - EV) |
Forecasted final cost assuming remaining work will be done at the planned rate. | Recommended for one-time anomalies |
| ETC (Estimate to Complete) | EAC - AC |
The expected cost required to complete all remaining project work. | Forecast Metric |
| VAC (Variance at Completion) | BAC - EAC |
The projected budget deficit or surplus at project end. | Variance Indicator |
| TCPI | (BAC - EV) / (BAC - AC) |
The cost performance required to meet the target budget (BAC). | Target index |
🔍 International Project Controlling Compliance Audit
-
Calculation Accuracy: Database queries strictly
compute EVM ratios (
CPI = EV / AC;SPI = EV / PV) and EAC metrics. Zero-division checks are implemented to prevent errors on unstarted tasks. - Standard Alignments: Fully compliant with AACE International 10S-90 Practice Standard and the Project Management Institute (PMI) EVM Practice Standards.
🤖 Multi-Agent Crew Audit Console
Simulates active auditing from the project controller, CFO, contract, and production agents checking DuckDB views and SQLite transactions.
📋 Project Controlling Control Tower Overview
An automated, interactive Project Controlling & Earned Value Management (EVM) Control Tower designed for engineering, maritime, and defense sector projects. This workspace integrates analytical data processing, automated agentic auditing, Excel reporting, Power BI compilation, and a Streamlit web dashboard.
📊 Portfolio Scope & Health Snapshot
| Metric | Value | Status |
|---|---|---|
| Total Portfolio BAC | 7,100,000 USD | Baseline budget (6 active projects) |
| Total Portfolio AC | 5,220,810 USD | Active spend logged to date |
| Total Portfolio EV | 4,752,500 USD | Physical value earned |
| Portfolio CPI | 0.91 | 🔴 9% Budget Overrun (Threshold: 0.95) |
| Portfolio Cost Variance (CV) | -468,310 USD | Net overrun difference |
| Overall Portfolio Progress | 66.9% | Weighted physical completion progress |
🏗️ Workspace Architecture
The system is organized into a data layer, a CLI automation layer, a web dashboard layer, and an agent skill framework:
- AI_Controller/: Contains database compilers, multi-agent audits, Excel report writers, and Streamlit dashboards.
- Data/CSV/: Contains the 8 core relational CSV files (projects, WBS elements, timesheets, material costs, progress, raid log, etc.).
- Data/DuckDB/: Analytical database engine for high-speed aggregations and views.
- Data/SQLite/: Transactional database engine for log audits and RAID logs.
- .agents/skills/: Registry of 13 domain-specific agent instructions and rules.
📐 EVM Terminology & Formulas
| KPI Metric | Equation | Interpretation & Thresholds |
|---|---|---|
| CPI (Cost Performance Index) | EV / AC |
Measure of cost efficiency. Values < 0.95 generate early warnings. |
| SPI (Schedule Performance Index) | EV / PV |
Measure of schedule efficiency. Values < 0.90 indicate critical path delays. |
| EAC (Typical) | BAC / CPI |
Forecasted final cost assuming current cost trends persist. |
| EAC (Atypical) | AC + (BAC - EV) |
Forecasted final cost assuming remaining work runs at planned budget rate. |
| VAC (Variance at Completion) | BAC - EAC |
Projected surplus or deficit at project end. |
🧭 Dashboard Navigation Guide
This browser-ready dashboard provides a comprehensive window into the workspace. Below are instructions on how to use the interactive elements:
🖱️ Interactive Dashboard Controls
- Project Context Gantt Selector: In the Gantt chart card, toggle the project context dropdown to filter scheduling details down to individual projects (e.g. PRJ-001) or aggregate them at the portfolio level.
- Gantt Metric Deviation Focus: Toggle between Schedule, Cost, and Hours metrics to visualize task variances and overruns on the bar tracks.
- What-If Corrective Simulator: Navigate to the bottom tab of the Control Tower Dashboard. Adjust sliders for labor or material savings and toggle schedule crashing to view simulated CPI and EAC results.
- Stakeholder Reports Selector: Click "Stakeholder Reports" in the sidebar, then use the dropdown to customize metrics for steering committees, project managers, engineers, yard operators, procurement, or quality inspectors.
- Skill Inspector Selector: Click "Skill Inspector" or select an option from either the "Focus Agent Skill" sidebar dropdown or the new "Select Agent Skill to Inspect" dropdown inside the page. Choosing a skill from either dropdown will automatically synchronize the other and display the detailed markdown directives for that agent.
- Live Agent Audit Runner: Click "Live Crew Execution" in the sidebar and run the auditor console simulator to watch timesheet, material, and RAID log integrity checks execute dynamically.
- Workspace README & Guide Tabs: Use the new "Workspace README" navigation link in the sidebar to review system architecture and schemas, or use the "User Guide & Navigation" link to return to these instructions at any time.
🚀 Executing Scripts & the PowerShell Orchestrator
The backend engine runs on SQLite, DuckDB, and Python. To rebuild reports or run active audits locally:
- Open a PowerShell terminal in the workspace folder:
c:\Users\frank\Desktop\Project Mng - Launch the master menu orchestrator:
./run_all.ps1 - Choose from 10 automated tasks, including:
- Option 1: Recompile and sync SQLite and DuckDB relational tables.
- Option 4: Generate the formula-driven Excel report (OpenPyXL).
- Option 8: Launch the interactive Streamlit web dashboard.
- Option 9: Run the entire data processing and reporting pipeline in sequence.