PROJECT CONTROL DASHBOARD – STRUCTURAL STEEL WORKS MD2 & MD3
Plan vs Actual by Stage (% Scope)
Cumulative S-Curve Progress (%)
Progress by Stage
| Stage | Scope | Plan (t) | Actual (t) | Plan% | Act% |
|---|
Progress by Structural Package (11 Packages)
| Package | Scope | Plan% | Earned% | Var | Alarm | Driving Lag |
|---|
Alarms Summary by Control Sources
| Control Source | RED | AMBER |
|---|
Top Project Priorities
Manpower Plan vs Actual (Person/Day)
Weekly Manpower Summary (Days: 0 / 6)
| Group | Plan | Actual | Δ | Fulfil |
|---|
ITP Status by Section
| ITP Section | Tot | Done | Prog | Blk | RED | AMB |
|---|
Key Contract Milestones
| Milestone | Base R1 | Forecast | Actual | Var | LD | Alarm |
|---|
2. DAILY ACTIVITY LOG (PER USER & DEPARTMENT)
Log aktivitas kerja harian, rencana besok & kendala lapangan
| Date | User / PIC | Dept | Unit / Area | Work Done Today | Plan Tomorrow | Constraint → Help Needed From | Status | Solution / Follow-Up Log | Attachment | Action |
|---|
Excel Schedule Aligned (Read-Only Table · Add / Edit / Delete via Form)
3. MASTER PROJECT SCHEDULE & LOOK-AHEAD CONTROL
Baseline vs Forecast Schedule, Weighted Progress % & Variance Tracking (Aligned with Excel Schedule Sheet)
| ID | Activity | Module | Resp. | Group | Dur (cal. d) | Baseline Start (LCI R1) | Baseline Finish (LCI R1) | Plan Start (MKS 11-Nov) | Plan Finish (MKS 11-Nov) | Actual Start | Actual Finish | % Complete | Forecast Start | Forecast Finish | Status | Delay (d) | Alarm | Cause | Recovery action | Remarks | Action |
|---|
| Doc No | Group | Document Title | ITP | Owner | Phase | Submit By | Approve By | Rev | Submitted | Status | Alarm | Remarks | Action |
|---|
| SD Package | Mod | Description | Plan Sub | Plan App | Rev | Submitted | Sheets | Weight (t) | Status | Alarm | Remarks | Action |
|---|
| ITP ID | Section | Inspection / Test Activity | H/W/R | Prereq Doc / Ref | Prereq Status (Auto) | Target Date | Actual Date | Status | RFI / Insp. Ref (Auto) | Alarm | Action |
|---|
4. PROCUREMENT, PURCHASE ORDERS & MATERIAL RECEIVING
Integrated Purchase Orders, Multi-Item Expected Delivery Tracking, Goods Receipt Management & Cost Control
Recent Purchase Orders
| PO Number | Supplier | PO Date | Items | Grand Total | Status | Action |
|---|
Procurement Alerts
Material Requirements (from Purchase Order)
| Ref | Material Description | Module | Required Qty | Supplier | Schedule & Lead Time | Status | Action |
|---|
4. TECHNICAL QUERY (TQ) / DEVIATION & PM APPROVAL GATE
Material dengan deviasi spesifikasi WAJIB diajukan TQ dan mendapat status Approved dari Project Manager (PM) sebelum dapat diterbitkan PO.
2. MATERIAL REQUIREMENTS REGISTER (MR / PR TECHNICAL BASELINE)
Single Source of Truth: Input spesifikasi teknis 1 kali (Brand, Grade, Standard, Certificate, Stock Availability & Required Docs)
| MR / PR Ref | Mod | Material Description | Required Technical Spec | Required Docs | Avail | Scope Qty | Schedule | Status | Action |
|---|
3. RFQ & AUTOMATIC TECHNICAL COMPARISON
Bandingkan penawaran multi-supplier terhadap spesifikasi MR/PR. Sistem otomatis mendeteksi COMPLIANT vs DEVIATION.
| RFQ Ref | MR / PR | Supplier | Required Spec (PR) | Offered Spec (Supplier) | Unit Price | Quoted ETA | Stock | Quotation Docs | Tech Check | Deviation Notes | Actions |
|---|
5. PURCHASE ORDERS REGISTER (ACCURATE PO NO. & PROJECT FORMAT PO)
Daftar PO terbit (terhubung ke Delivery Tracking, Material Receiving & Project Cost Control)
| No | PO Number (Accurate) | Supplier | PO Date | Module | Items | Grand Total | Status | Actions |
|---|
6. MATERIAL DELIVERY TRACKING – CENTRALIZED MONITORING
Single Source of Truth dari Purchase Orders & Goods Receipt · Klik baris material untuk melihat riwayat penerimaan & Parent PO
| Period | Code | Material Description | Unit | Qty Received | GRs |
|---|
| Period | PO Number | Supplier | Total Qty | Receipts |
|---|
| Period | Supplier | POs | GRs | Total Qty Received |
|---|
| Period | Project / Module | Materials | Total Qty Received |
|---|
| Period | GR Number | Date | PO Number | Supplier | DO Number | Material | Qty | Unit | Received By |
|---|
| Project | PO Number | Supplier | Material Code | Material Description | Specification | Unit | PO Qty | Planned Schedule | Total Received | Remaining Balance | Delivery Progress | Delivery Status | Latest Receiving Date |
|---|
7A. GOODS RECEIPT (GR) HISTORY
Riwayat penerimaan material di Gudang Site / Workshop berdasarkan Surat Jalan (DO)
| GR Number | PO Number | Supplier | DO Number | Date | Time | Items | Received By | Status | Action |
|---|
7B. PO LINE ITEMS RECEIVING BALANCE
| PO Number | Supplier | Mod | Material Description | Ordered | Received | Remaining | ETA Site | Last Arrival | Status | Action |
|---|
8. OUTSTANDING PROCUREMENT ITEMS
Daftar item PO yang belum diterima 100% beserta sisa hari menuju ETA Site
| PO Number | Supplier | Mod | Material Description | Ordered | Received | Remaining | ETA Site | Schedule | Alarm |
|---|
9. PROCUREMENT COST & COMMITMENT REPORT
Analisis biaya PO berdasarkan Supplier, Module (MD2/MD3), dan Bulan
Cost Breakdown by Supplier
| Supplier | POs | Ordered Cost | Received Value | Outstanding |
|---|
Cost Breakdown by Module
| Module | Items | Ordered Cost | Received Value | Outstanding |
|---|
Monthly Procurement Commitment
| Month | POs | Items | Ordered Value | Received Value | Outstanding |
|---|
Package progress & daily tonnage log
5A. CONSTRUCTION & FABRICATION WORK LIST BY PACKAGE
Master Fields Editable (Package ID, Name, Mod, Base Start, Base Finish, Scope, FP Scope) · Formula Columns Auto-Synced Read-Only from 5B. LOG PROGRESS
| Package ID | Package Name | Mod | Base Start | Base Finish | Scope (t) | FP Scope (t) | Plan% | SD | Mat | Fab | QC | HDG | FP | Del | Erect | Bolt | Earned% | Var% | Alarm |
|---|
5B. LOG PROGRESS
Daily work done, stage tonnage & field attachments
| Date | Module | Package ID | Stage | Qty Today (ton) | Pieces | Reported By (unit) | Source Report / Photo Reference | Remarks | Action |
|---|
7A. QA/QC INSPECTION & RFI LOG
Linked to Package, Stage & ITP Checkpoint (H/W/R) · Click "+ NCR" on rejected items
| Date | Inspection / RFI Ref | ITP No. | Module | Package ID | Stage / Activity | Location / Grid / Member | Witness (H/W/R) | Result | Inspector (MKS / LCI) | NCR Raised? | Remarks / Attachment | Action |
|---|
7B. NON-CONFORMANCE REPORT (NCR) & CAPA REGISTER
Track Internal/LCI NCRs, Root Cause, Corrective Action, Target Closure Date & Rework Cost
| NCR No | Date | Source | Package | Severity | Non-Conformance Description | Root Cause & CAPA | Due Date | Rework Cost (IDR) | Status | Alarm | Evidence | Action |
|---|
7C. WELDING, NDT (UT/MT/PT) & COATING (HDG / FP) SUMMARY
Weld joint acceptance rate & Dry Film Thickness (DFT Micron) verification log
| Date | Mod | Package | Test / Coating Type | Tested (Joints/m²) | Accepted | Rejected | Reject % | Spec / Actual DFT | Status | Report | Action |
|---|
7D. WPS/PQR, WELDER QUALIFICATION (WQT) & INSTRUMENT CALIBRATION
Automatic expiry tracking (AMBER ≤ 14 days, RED if expired)
| Ref / ID | Category | Personnel / Equipment / WPS | Process / Range | Issue Date | Expiry Date | Days Left | Alarm | Certificate | Action |
|---|
Weekly Manpower Plan vs Actual (Persons / Day – Synced from Active Week of Manpower_Plan)
Daily Manpower Log
| Date | Location | Local | Non-Local | Staff | Shop | Site | Total | Manhours | Action |
|---|
HSE Incident & Safety Log
| Date | Type | Description | LTI | Action |
|---|
| Alarm | Source | Ref ID | Item / Description | Due / Target | Trigger Condition | Required Action | Owner |
|---|
| ID | Mod | Milestone | Base R1 | Forecast | Actual | Var | LD/day (M) | LD Exp (M) | Alarm | Action |
|---|
| ID | Mod | Severity | Category | Issue Description | Action / Mitigation | Owner | Due | Status | Alarm | Action |
|---|
| Zone ID | Module & Level | Concrete Pour | Anchor Plan | Actual Handover | Age (d) | Status | Alarm | Action |
|---|
10A. CONTRACT / LOA SUMMARY & COMMERCIAL PARAMETERS
Master PO / LOA Reference, Contract Period, Retention/LD Terms & Signed Contract Document
10B. PROGRESS CLAIMS & BILLING SCHEDULE (IPC)
| Claim No. | Period / Description | Gross Claim (IDR M) | Retention 10% | Net Certified | Submit Due | Invoice Date | Payment Due (45d) | Status | Alarm |
|---|
10C. VARIATION ORDERS (VO) & EOT CLAIMS REGISTER
| VO Ref | Category | Description | Submitted Date | Submitted (IDR M) | Approved (IDR M) | EOT (Days) | Status | Alarm |
|---|
10. PROJECT COST CONTROL – EXPENDITURE & PO COMMITMENT REGISTER
Centralized tracking of daily project expenses (Non-PO multi-item) & automated Procurement PO commitments
Cost Breakdown by Category
PO Commitment + Non-PO Expenses| Cost Category | PO Commitment | Non-PO Expense | Total Cost | Share |
|---|
Cost Breakdown by Project Module
Item-level Module Cost Allocation| Project Module | PO Commitment | Non-PO Expense | Total Cost | Share |
|---|
Recent Project Transactions (PO & Non-PO)
| Date | Transaction No. | Supplier / Payee | Description | Category | Project Module | Total Amount | Status | Source | Action |
|---|
PROJECT TRANSACTION REGISTER (NON-PO EXPENSES & LINKED POs)
Record daily direct expenses with multiple items per receipt, or inspect linked Procurement POs
| Transaction Date | Transaction Number | Supplier / Payee | Description | Category | Project Module | Total Amount | Payment Status | Source | Actions |
|---|
PO COST REGISTER (AUTO-LINKED FROM 4. PROCUREMENT)
Live synchronization with Procurement Purchase Orders. Tracks PO Commitment vs Invoiced vs Paid vs Outstanding without double counting.
| PO Number | Date | Supplier | Description | PO Value | Invoiced Amount | Paid Amount | Outstanding Amount | Status | Actions |
|---|
PRINTED & SAVED PDF REPORT HISTORY (0)
Arsip otomatis setiap kali laporan Daily / Weekly dicetak atau disimpan PDF (dapat di-Preview & Re-Print kapan saja)
| Printed At (WIB) | Report No. | Report Type | Status Date | To / Recipient | Paper | Printed By | Actions |
|---|
12. USER MANAGEMENT & ACCESS CONTROL
Manage system users, departments, roles, and module access permissions
System Users Directory
| Employee ID | Full Name | Username | Email Address | Department | Position | Role / Access | Status | Actions |
|---|
14. PROJECT FILE STORAGE & DEPARTMENT DRIVE
Gudang arsip file terpisah per departemen (Upload, Download, Preview, Edit & Version History)