โ†Back to Dashboard
๐Ÿ—๏ธ

Construction ERP & Margin Guard

Industry Command Center โ€ข Portfolio Estimation & Margin Telemetry

Illustrative interface ยท synthetic data ยท not a live system
โš ๏ธ Synthetic demonstration dataset โ€” not client data (BASE SCENARIO ACTIVE)
๐Ÿ“‹

Executive Morning Brief โ€” Construction Portfolio (Synthetic Preview)

Illustrative synthesis for Project Directors & CFOs โ€” Requires client-data validation

Synthetic / Illustrative
Synthetic Portfolio Value
604.94B VND
3 Demo Contracts (Illustrative)
Synthetic Forecast Margin
13.03%
78.85B VND (Illustrative)
Margin Risk Flagged
2 Demo Projects
1 Critical, 1 At Risk
Pending VOs (Synthetic)
2 Submissions
Awaiting Approval
โšก Illustrative Action Items (Synthetic):
  • SYN-SHB-INF-03 (Bridge Pkg 3): Margin drift flagged (-8.0% vs target). Rebar scrap rate exceeded allowance by 7.2%.
  • SYN-CLW-RES-01 (Residential Tower): Variation Order SYN-VO-042 pending review for Subcontractor A door substitution.

CSV Upload Data Studio (Browser In-Memory Session)

๐Ÿ“ค

Upload Project Portfolio CSV

Demo mode โ€” uploaded files are parsed in this browser session and are not sent to an external service.

Required CSV Headers (Exact Match):
project_namecontract_valueapproved_budgetactual_cost_to_dateforecast_final_costtarget_margin_pctprogress_pctstatus
๐Ÿ“ค

Upload BOQ Line-Item Variance CSV

Demo mode โ€” uploaded BOQ items are parsed in this browser session and are not sent to an external service.

Required CSV Headers (Exact Match):
project_nameboq_codeitem_descriptionunitbudget_quantityactual_quantitybudget_unit_costactual_unit_cost
๐Ÿ“ค

Upload Variation Orders CSV

Demo mode โ€” uploaded Variation Orders are parsed in this browser session and are not sent to an external service.

Required CSV Headers (Exact Match):
project_namevo_numbercontractor_namedescriptionclaimed_amountrecommended_amountmargin_impact_pctapproval_status
๐Ÿ“ค

Upload Cash-Flow Forecast CSV

Demo mode โ€” uploaded Cash-Flow forecast periods are parsed in this browser session and are not sent to an external service.

Required CSV Headers (Exact Match):
period_start_dateperiod_end_datecontract_billing_inflowsubcontractor_outflowmaterial_procurement_outflowoverhead_admin_outflow

Portfolio Construction Projects

Illustrative margin tracking and budget execution โ€” Requires client-data validation

Synthetic / Illustrative Data
Project & CodeContract ValueActual / Forecast CostTarget / Forecast MarginProgressStatus
Synthetic Demo Project Alpha (Residential Tower)
SYN-CLW-RES-01 โ€ข Synthetic Lead Eng. A
431.44B VND
245.00B VND
Fcst: 375.35B VND
Target: 15%Fcst: 13% (-2.0%)
62.5%
MARGIN RISK
Synthetic Demo Project Beta (Industrial Plant)
SYN-MTP-IND-02 โ€ข Synthetic Lead Eng. B
48.50B VND
32.00B VND
Fcst: 40.74B VND
Target: 15%Fcst: 16% (+1.0%)
78%
ON TRACK
Synthetic Demo Project Gamma (River Bridge)
SYN-SHB-INF-03 โ€ข Synthetic Lead Eng. C
125.00B VND
78.00B VND
Fcst: 110.00B VND
Target: 20%Fcst: 12% (-8.0%)
68%
CRITICAL DRIFT
๐Ÿงฎ

Illustrative Value Simulator

Scenario estimate only โ€” validate with client financial, project, and contract data before making decisions.

Illustrative / Requires validation
Input Mode:Derived from synthetic portfolio.
Formatted: 604.94B VND
Portfolio Average
Target Leakage Recovery (e.g. 1.5%)
Hours per week
350,000 VND/hr
Formatted: 300.0M VND

Explicit Formula Calculations & Scenario Results

Margin-Recovery Opp.
9.07B VND

604,942,000,000 ร— 1.5%

Admin-Efficiency Opp.
273.0M VND

15 hrs ร— 350,000 ร— 52 wks

Illustrative Annual Value
9.35B VND

Margin Opp. + Admin Opp.

Net Illustrative Value
9.05B VND

Annual Value โˆ’ Investment

Illustrative ROI %
3015.7%

(Net Value / Investment) ร— 100

Scenario Principles & Assumptions:
  • Margin recovery assumes leakages occur in unverified BOQ surface area calculations and material scrap rate drift.
  • Admin hours saved assume automated synthesis of daily morning briefs and variation order workflows.
  • All monetary values are expressed in Vietnamese Dong (VND).
๐Ÿ“Œ Sensitivity Note: Results change materially with margin leakage, data quality, project mix, contract structure, and implementation adoption.

โš ๏ธ BOQ Line-Item Variance & Margin Guards

Illustrative drift alerts โ€” Requires client-data validation

Synthetic / Illustrative
SYN-CLW-RES-01 โ€ข SYN-DF2-FIRE-DOOR

Synthetic Demo Variance: DF2 Fire-Rated Steel Door Area Calculation Drift

+28.7% Drift
Budget Qty6.16 mยฒ
Actual Qty7.25 mยฒ
Cost Impact+4.3M VND
๐Ÿ“Œ Synthetic Provenance:Matched from Synthetic_Schedule_Sheet_v2.xlsx (Demo payload)
SYN-SHB-INF-03 โ€ข SYN-BOQ-STR-STEEL

Synthetic Demo Variance: Structural Rebar Fabrication Scrap Surplus

+7.2% Drift
Budget Qty1250 Ton
Actual Qty1340 Ton
Cost Impact+2.56B VND
๐Ÿ“Œ Synthetic Provenance:Synthetic material requisition record MRV-2026-DEMO

๐Ÿ“ Variation Order Approval Queue

Illustrative subcontractor change requests โ€” Requires client-data validation

Synthetic / Illustrative
Pending Review Queue:2 Submissions (4.82B VND Claimed)
SYN-VO-042 โ€ข SYN-CLW-RES-01

Synthetic VO: Fire Safety Door Specification Change Request

Synthetic Subcontractor A (Steel Doors)

15.1M VND
Rec: 13.8M VND
Margin Impact: -0.4%
SYN-VO-043 โ€ข SYN-SHB-INF-03

Synthetic VO: Foundation Soil Reinforcement Surcharge Package

Synthetic Subcontractor B (Geotechnical)

4.80B VND
Rec: 4.20B VND
Margin Impact: -3.8%

๐Ÿ’ฐ 30/60/90-Day Liquidity & Cash Flow Forecast

Projected project receipts vs subcontractor disbursements

Static Synthetic Figures
30 Days
Rec: +85.00B VND
Disb: -72.00B VND
Net: +13.00B VND
60 Days
Rec: +140.00B VND
Disb: -128.00B VND
Net: +12.00B VND
90 Days
Rec: +210.00B VND
Disb: -195.00B VND
Net: +15.00B VND
๐Ÿ”’

Governance, Lineage & Cryptographic Audit Panel (Engine v0.3)

Fail-Closed Control: Unverified margin variances >5.0% block automated sign-off
Active Portfolio ModeSyntheticDefault Synthetic (3 rows)
BOQ Dataset LineageSynthetic DefaultboqVariances (Static)
VO Dataset LineageSynthetic DefaultvariationOrders (Static)
Cash Flow LineageSynthetic DefaultcashFlowForecast (Static)
Morning Brief Payload SHA-256 Hash (v0.3)Morning Brief integrity hash: pending implementation.
Value Simulator Payload SHA-256 Hash (v0.2)Value simulator integrity hash: pending implementation.
BOQ Variance Canonical SHA-256 HashBOQ integrity hash: pending upload.
Variation Orders Canonical SHA-256 HashVO integrity hash: pending upload.
Cash Flow Forecast Canonical SHA-256 HashCash Flow integrity hash: pending upload.
Portfolio Dataset Canonical SHA-256 HashPending calculation...
Morning Brief Disclaimer: The Morning Brief uses deterministic calculations from the active dataset. It does not validate business accuracy, completeness, authority, or forecast reliability.
Simulator Disclaimer: The simulator uses scenario assumptions. It does not validate financial accuracy or predict actual outcomes.
Schema Validation Disclaimer: Schema validation checks data shape and arithmetic consistency only. It does not verify source authority, contractual correctness, accounting accuracy, completeness, or suitability for operational decisions.
๐Ÿ›ก๏ธ

Velyx Control Gate โ€” Demo Status

Control visibility for this local demonstration. A Passed status does not represent client-production approval.

Passed: 12Demo Only: 0Pending: 0Blocked: 0
Control Status Legend:
Passed: locally implemented and tested in this demo.
Demo only: implemented as local/demo behaviour, not production enforcement.
Pending: not implemented yet.
Blocked: cannot be enabled or claimed until prerequisites exist.
Not applicable: not required for this workspace.
Showing 12 of 12 controls
Control ID & NameDomain & ScopeStatusEvidenceLimitationsRequired
CG-BLD-01
TypeScript Compilation
Owner: Engineering Team
buildScope: appPASSEDnpx tsc --noEmit executed with 0 type errors.Static type checking only; does not replace runtime integration testing.Yes (Prod Gate)
CG-BLD-02
Next.js Production Build
Owner: Engineering Team
buildScope: appPASSEDnpm run build compiled static pages successfully in 500ms.Builds static Next.js assets; backend microservices not bundled in static build.Yes (Prod Gate)
CG-OPS-01
Local Demonstration Route Health
Owner: Operations Team
operationsScope: appPASSEDHTTP GET /demo/construction-erp-margin-guard returned 200 OK.Verified on local dev server; performance under load not measured.Yes (Prod Gate)
CG-DAT-01
Browser-Session CSV Parsing
Owner: Data Engineering
dataScope: appPASSEDRFC-4180 CSV parser executes in-memory with zero network requests.Data persists only in active browser memory session.Yes (Prod Gate)
CG-DAT-02
Portfolio Schema Validation
Owner: Data Engineering
dataScope: appPASSEDStrict 8-header verification, duplicate checks, and numeric range rules enforced.Validates data shape and range bounds, not business accuracy or authority.Yes (Prod Gate)
CG-DAT-03
Explicit Data Source Labelling
Owner: UX Team
dataScope: appPASSEDAll UI components display explicit Synthetic / Uploaded / User Scenario labels.Visual labeling only; does not enforce data lineage provenance at DB level.Yes (Prod Gate)
CG-DAT-04
BOQ, VO & Cash Flow CSV Import Schemas
Owner: Data Engineering
dataScope: appPASSEDBOQ variance, Variation Orders, and Cash Flow CSV schemas and dynamic UI replacement implemented.Browser-session in-memory storage only.Yes (Prod Gate)
CG-CAL-01
Deterministic Forecast Margin Calculations
Owner: Financial Engineering
calculationScope: appPASSEDFormula ((contract_value - forecast_final_cost)/contract_value)*100 unit tested.Calculates forecast margin from raw inputs; does not model complex tax or currency hedging.Yes (Prod Gate)
CG-CAL-02
Dataset-Reactive Morning Brief Metrics
Owner: Product Team
calculationScope: appPASSEDDynamic weighted margin, forecast profit, and drift action items compute from active portfolio rows.Uses rule-based drift thresholds (5.0%); does not perform predictive ML forecasting.Yes (Prod Gate)
CG-CAL-03
Value Simulator Zero-Division Guard
Owner: Financial Engineering
calculationScope: appPASSEDROI calculation blocks division when annual platform investment is <= 0.Scenario simulation model only; not a financial guarantee or warranty.Yes (Prod Gate)
CG-AUD-01
Dataset Cryptographic Hash Generation
Owner: Security Architecture
auditScope: appPASSEDWeb Crypto API computes SHA-256 hash over canonical dataset payload.Generates client-side payload digest; does not anchor to a public blockchain or HSM.Yes (Prod Gate)
CG-AUD-02
Scenario & Brief Cryptographic Digest
Owner: Security Architecture
auditScope: appPASSEDSHA-256 digests computed live for Morning Brief, Value Simulator, and Supplementary datasets.Payload digests reset when browser tab is refreshed.Yes (Prod Gate)