🚨 SISTEM RED FLAG & EARLY WARNING PROYEK

Panduan Deteksi Dini & Decision Making untuk Mencegah Kegagalan Proyek

Version: 1.0
Tanggal: 27 Januari 2026
Tujuan: Memberikan framework untuk mendeteksi potensi masalah sejak dini dan mengambil keputusan tepat
Basis Data: Analisis 37 proyek 2025 (23 sukses, 7 fair, 4 bermasalah, 3 disaster)
Impact: Mencegah kerugian Rp 74+ juta seperti 3 proyek disaster 2025


πŸ“‘ DAFTAR ISI

  1. Executive Summary
  2. Red Flag System - Pre-Project Phase
  3. Early Warning System - Execution Phase
  4. Decision Matrix Framework
  5. Action Protocol per Warning Level
  6. Case Study Disaster & Lessons Learned
  7. Checklist & Tools
  8. Escalation & Authority Matrix

1. EXECUTIVE SUMMARY

1.1 Mengapa Sistem Ini Penting?

[!NOTE] FAKTA DARI DATA 2025 (37 PROYEK) | Metric | Nilai | Detail | |--------|-------|--------| | βœ… SUCCESS RATE | 62,2% | 23 proyek margin >50% | | ⚠️ FAIR | 18,9% | 7 proyek margin 20-50% | | πŸ”΄ BERMASALAH | 10,8% | 4 proyek margin <20% | | πŸ’€ DISASTER | 8,1% | 3 proyek rugi |

TOTAL KERUGIAN 3 DISASTER: Rp 74.307.950

Proyek Kerugian Margin
Bu Raras Cimanggis -Rp 36.337.700 -457%
Pak Dani -Rp 23.247.000 -61%
Bu Yasmin Bojong -Rp 14.723.250 -100%

DAMPAK KE PROFITABILITAS: - Kerugian 3 proyek = 2,1% dari total profit Rp 3,5M - Setiap disaster konsumsi 1-2 bulan margin netto - Kerugian bukan hanya uang, tapi juga waktu & reputasi

GOOD NEWS: - 🎯 Dari 22 proyek dengan RAB lengkap: Success rate 95,5% (21/22 profitable) - Average margin 64%

KESIMPULAN: - πŸ‘‰ Proyek DENGAN PLANNING BAIK = 95,5% sukses - πŸ‘‰ Proyek TANPA PLANNING/ASAL TERIMA = risiko disaster - πŸ‘‰ PREVENTION jauh lebih murah daripada CORRECTION

1.2 Framework 3 Lapis Pertahanan

graph TB A[3-LAYER DEFENSE MECHANISM] --> B[LAYER 1: RED FLAG SYSTEM
πŸ”΄ Pre-Project] A --> C[LAYER 2: EARLY WARNING
🟑 During Execution] A --> D[LAYER 3: STOP-LOSS MECHANISM
🟠 Emergency] B --> B1[Deteksi masalah SEBELUM
proyek dimulai] B --> B2[Tool: Pre-Project
Assessment Scorecard] B --> B3[Decision: TERIMA /
TOLAK / TERIMA DENGAN SYARAT] C --> C1[Monitoring real-time selama
proyek berjalan] C --> C2[Tool: Weekly Cost Tracking
+ KPI Dashboard] C --> C3[Decision: CONTINUE /
INVESTIGATE / MITIGATE] D --> D1[Automatic trigger
untuk cut losses] D --> D2[Tool: Cost Ratio Trigger
+ Emergency Protocol] D --> D3[Decision: CUT LOSS /
RENEGOTIATE / ESCALATE]

2. RED FLAG PRE-PROJECT PHASE

Tujuan: Screening proyek SEBELUM deal closed untuk identifikasi risiko tinggi

2.1 Red Flag Checklist - Integrated dengan Cluster Brackets

A. CLIENT ASSESSMENT (Potensi masalah pembayaran & scope creep)

Cara Pakai: Ceklis setiap indikator, hitung berapa πŸŸ’πŸŸ‘πŸ”΄. Simple!

# Indikator 🟒 Green (0 point) 🟑 Yellow (1 point) πŸ”΄ Red (2 points)
1 Budget Range (disesuaikan cluster) Bracket C-E (β‰₯Rp 250jt) Bracket B (Rp 100-250jt) Bracket A (<Rp 100jt)
2 Down Payment Ready Mau DP 30-40% cash ready Nego DP 20-25% Tolak DP / minta kredit
3 Payment Term Terima standard cluster Nego dikit (masih wajar) Minta extended/aneh-aneh
4 Decision Speed Cepat (<2 minggu) Normal (2-4 minggu) Lambat/bingung (>1 bulan)
5 Scope Clarity Jelas, ada gambar/referensi Agak fuzzy tapi bisa dikembangkan Nggak jelas sama sekali
6 Timeline Realistis Sesuai standard cluster Agak tight tapi doable Impossible (<50% standard)
7 Price Sensitivity Focus value & kualitas Nego wajar (5-10%) Tawar habis-habisan (>20%)
8 Communication Responsif & profesional Agak lambat tapi OK Ghosting / susah banget kontak
9 History / Track Record Client lama atau referral trusted Baru tapi qualified Walk-in tanpa referral
10 Red Flags Behavior Nggak ada tanda-tanda aneh Ada 1-2 hal yang sedikit concern Banyak red flags (3+)

Cara Hitung: - Hitung total points: Jumlah 🟒 Γ— 0 + 🟑 Γ— 1 + πŸ”΄ Γ— 2 - Max score: 20 (semua red), Min score: 0 (semua green)

Interpretasi Client Score:

Score Kategori Action
0-4 points βœ… GREEN CLIENT (Low Risk) Accept dengan terms standard
DP: 30% sesuai cluster
Monitoring: Normal weekly
5-9 points 🟑 YELLOW CLIENT (Medium Risk) Accept DENGAN SYARAT:
β€’ DP: 35-40% (lebih tinggi)
β€’ Payment: Termin lebih sering
β€’ Monitoring: Daily
β€’ Premium pricing: +10-15%
10-14 points 🟠 ORANGE CLIENT (High Risk) Accept HANYA jika:
β€’ DP: 50% MINIMUM
β€’ Milestone-based payment strict
β€’ Premium pricing: +25-30%
β€’ Owner approval WAJIB
15-20 points πŸ”΄ RED CLIENT (Extreme Risk) REJECT (politely decline)
Atau consultation fee only
Atau referral ke kontraktor lain

B. TECHNICAL ASSESSMENT (Potensi cost overrun & timeline delay)

Cara Pakai: Sama, ceklis setiap indikator. Makin banyak πŸ”΄ = makin risky!

# Indikator 🟒 Green (0 point) 🟑 Yellow (1 point) πŸ”΄ Red (2 points)
11 Site Access Mudah, truk/mobil lancar Agak sempit tapi masih OK Sulit/gang kecil/jauh dari jalan
12 Existing Condition Baru/bagus atau kosong Perlu renovasi wajar Kritis/bongkar total
13 Soil/Foundation Tanah padat, standard Agak lembek/pernah banjir Bermasalah (gambut/rawa/instabil)
14 Legal/Permit Aman/lengkap/tidak perlu Perlu urus tapi bisa Sengketa/bermasalah
15 Design Complexity Standard cluster bracket Custom tapi reasonable Over-design/unrealistic
16 Material Spec Standard, stok ready Special order tapi available Import/langka/sulit cari
17 Location Distance <10km dari base/cluster 10-20km (manageable) >20km (jauh banget)
18 Season/Weather Kemarau/low risk Peralihan (OK) Hujan peak/banjir risk
19 Neighborhood Supportif/no problem Netral/biasa aja Potensi protes/ribet
20 Utilities Ready Lengkap (PLN, PDAM, akses) Perlu sambung baru Terbatas/jauh/mahal

Cara Hitung: - Total points: Jumlah 🟒 Γ— 0 + 🟑 Γ— 1 + πŸ”΄ Γ— 2
- Max: 20 points (disaster!), Min: 0 points (perfect!)

Interpretasi Technical Score:

Score Kategori Action
0-4 points βœ… GREEN PROJECT (Technically Feasible) Execute dengan RAB standard
Contingency: 10-15% (normal)
Timeline: Sesuai cluster bracket
5-9 points 🟑 YELLOW PROJECT (Manageable dengan Extra Care) Contingency: 20-25%
Timeline: +10-20% buffer
Premium pricing: +10-15%
PM experienced WAJIB
10-14 points 🟠 ORANGE PROJECT (High Technical Risk) Contingency: 30-40%
Timeline: +30% buffer minimum
Premium pricing: +30-40%
Site visit intensive
Owner approval WAJIB
15-20 points πŸ”΄ RED PROJECT (Extreme Risk) REJECT strongly recommended
Atau consultant fee only (desain saja)
Atau premium +50-100% (cover risk)

2.2 Combined Risk Matrix - Simple & Clear

Cara Pakai: Gabungkan Client Score + Technical Score, lihat di tabel.

DECISION MATRIX (Client + Technical Score)

Client Score GREEN (0-4) YELLOW (5-9) ORANGE (10-14) RED (15-20)
GREEN (0-4)
Low Risk
βœ… IDEAL
Accept Standard
DP: 30%
βœ… GOOD
Accept +10-15%
DP: 35%
⚠️ CAUTIOUS
Accept +25-30%
DP: 40%
πŸ”΄ RISKY
Consider +40-50%
DP: 50%
YELLOW (5-9)
Medium Risk
βœ… GOOD
Accept +10%
DP: 35%
⚠️ WATCH
Accept +20-25%
DP: 40%
πŸ”΄ HIGH
Consider +40%
DP: 50%
🚫 DANGER
REJECT or +100%
DP: 60%
ORANGE (10-14)
High Risk
⚠️ WATCH
Consider +25-30%
DP: 40%
πŸ”΄ RISKY
Consider +40-50%
DP: 50%
🚫 DANGER
REJECT or +100%
DP: 60%
🚫 NO
REJECT
-
RED (15-20)
Extreme Risk
πŸ”΄ RISKY
Consider +50%
DP: 50%
🚫 DANGER
REJECT
-
🚫 NO
REJECT
-
🚫 NO
REJECT
-

[!NOTE] Keterangan Matrix - βœ… IDEAL/GOOD = Accept dengan senang hati - ⚠️ WATCH/CAUTIOUS = Accept tapi extra careful (premium + DP tinggi) - πŸ”΄ RISKY/HIGH = Consider hard (Owner approval wajib, atau reject) - 🚫 DANGER/NO = REJECT (99% cases), kecuali premium extreme

PREMIUM % = Markup dari RAB standard cluster DP % = Down payment requirement

Special Cases - AUTOMATIC REJECT (Non-Negotiable):

  1. ❌ Budget < Rp 25 juta (kecuali client existing loyal)
  2. ❌ Client menolak DP sama sekali (minta kredit/hutang)
  3. ❌ Sengketa legal aktif (tanah/bangunan/permit)
  4. ❌ Timeline unrealistis (<2 bulan untuk proyek >Rp 200 juta)
  5. ❌ Scope tidak jelas + client indecisive (red flag combo)
  6. ❌ Harga nego >30% dari RAB (tidak profitable)
  7. ❌ Bad reputation (diketahui sering bermasalah dengan kontraktor lain)

2.3 Quick Cluster Reference (Cheat Sheet)

Sebelum scoring, cek dulu proyek masuk cluster mana:

Bracket Nilai RAB Timeline Standard Target Cost Ratio DP Standard Notes
A - MICRO <Rp 100jt
Rp 25-99jt
1-3 bln <50% 40% ⚠️ RISKY
B - SMALL ⭐ Rp 100-250jt 3-4 bln <40% (efficient) 30% ⭐ SWEET SPOT
C - MEDIUM ⭐ Rp 250-450jt 4-6 bln <38% 30% ⭐ SWEET SPOT
D - LARGE ⭐ Rp 450-700jt 5-7 bln <35% (economy) 30% ⭐ BEST MARGIN
E - XL ⭐ >Rp 700jt 6-10 bln <32% (scale) 30-40% ⭐ BEST MARGIN

[!TIP] Insight Cluster - ⭐ SWEET SPOT = Bracket B & C (paling konsisten profit) - ⭐ BEST = Bracket D & E (margin & efficiency terbaik) - ⚠️ RISKY = Bracket A (overhead tinggi, margin tipis)

MINIMUM PROJECT SIZE: Rp 25 juta Auto-reject: <Rp 25 juta (kecuali client existing loyal)


2.4 Pre-Project Assessment Form (Template)

[!NOTE] RENOVASIA - PRE-PROJECT RISK ASSESSMENT (v2.0) INFORMASI DASAR:

Field Value
Tanggal Assessment __
Nama Client __
Lokasi Proyek __
Estimasi Nilai Rp _____ β†’ BRACKET: ___
Assessed by __
Referral Source __

SECTION A: CLIENT ASSESSMENT

Cara: Centang salah satu (🟒/🟑/πŸ”΄) untuk tiap indikator

# Indikator 🟒 🟑 πŸ”΄
1 Budget Range Bracket C-E Bracket B Bracket A
2 DP Ready 30-40% OK Nego 20% Tolak/kredit
3 Payment Term Standard Nego dikit Aneh-aneh
4 Decision Speed Cepat <2w Normal Lambat >1m
5 Scope Clarity Jelas Fuzzy Nggak jelas
6 Timeline Realistis Sesuai Tight Impossible
7 Price Sensitivity Value focus Nego 5-10% Tawar >20%
8 Communication Responsif Lambat Ghosting
9 Track Record Referral Qualified Walk-in
10 Red Flag Behavior Nggak ada 1-2 hal Banyak (3+)

HITUNG: 🟒 = 0 point | 🟑 = 1 point | πŸ”΄ = 2 points

Count Γ— Point = Total
Total 🟒 ___ Γ— 0 = ___
Total 🟑 ___ Γ— 1 = ___
Total πŸ”΄ ___ Γ— 2 = ___
CLIENT SCORE (A): ___ points (max: 20)

SECTION B: TECHNICAL ASSESSMENT

# Indikator 🟒 🟑 πŸ”΄
11 Site Access Mudah Agak sulit Sulit banget
12 Existing Condition Bagus/baru Renovasi Kritis
13 Soil/Foundation Padat Lembek Bermasalah
14 Legal/Permit Aman Bisa urus Sengketa
15 Design Complexity Standard Custom Over-design
16 Material Spec Standard Special Import/langka
17 Location Distance <10km 10-20km >20km
18 Season/Weather Kemarau Peralihan Hujan peak
19 Neighborhood Supportif Netral Ribet
20 Utilities Ready Lengkap Perlu urus Terbatas

HITUNG: 🟒 = 0 point | 🟑 = 1 point | πŸ”΄ = 2 points

Count Γ— Point = Total
Total 🟒 ___ Γ— 0 = ___
Total 🟑 ___ Γ— 1 = ___
Total πŸ”΄ ___ Γ— 2 = ___
TECHNICAL SCORE (B): ___ points (max: 20)

ASSESSMENT RESULT:

Score Interpretasi
Client Score (A) ___ pts β†’ 🟒 0-4 🟑 5-9 🟠 10-14 πŸ”΄ 15-20
Technical Score (B) ___ pts β†’ 🟒 0-4 🟑 5-9 🟠 10-14 πŸ”΄ 15-20

COMBINED RISK LEVEL: Client ___ + Technical ___ = __


DECISION RECOMMENDATION:

  • [ ] βœ… ACCEPT - Standard Terms

    • DP: 30%
    • Markup: Normal
    • Monitoring: Standard
  • [ ] ⚠️ ACCEPT WITH CONDITIONS

    • DP: ___%
    • Markup: +___%
    • Contingency: ___%
    • Special Terms: _______
    • Monitoring Level: KETAT / VERY STRICT
  • [ ] πŸ”΄ REJECT / POLITELY DECLINE

    • Alasan: _____
    • Alternative:
    • [ ] Offer consultation fee only
    • [ ] Referral ke contractor lain
    • [ ] Counter-offer dengan premium pricing +___%

NOTES & MITIGATION PLAN:





APPROVAL:

Role Signature Date
Sales/Marketing _______ _
Project Manager _______ _
Finance _______ _
Owner/CEO _______ _ (for RED cases)

3. EARLY WARNING EXECUTION PHASE

Tujuan: Monitoring proyek yang sudah berjalan untuk deteksi masalah sedini mungkin

3.1 Weekly Monitoring KPI (5 Indikator Kunci)

Indikator 1: Cost Ratio Tracking (Adjusted per Cluster)

Target Cost Ratio per Cluster Bracket:

Bracket Target Cost Ratio Keterangan
Bracket A (Micro) <50% overhead tinggi per mΒ²
Bracket B (Small) <40% sweet spot efficiency
Bracket C (Medium) <38% ekonomi skala mulai
Bracket D (Large) <35% economies of scale
Bracket E (XL) <32% maximum efficiency

[!NOTE] COST RATIO WARNING SYSTEM | Zone | Cost Ratio | Status | Action | |------|------------|--------|--------| | 🟒 GREEN | ≀ Target Cluster | EXCELLENT, on track | Monitor normal, continue
Frequency: Weekly report
Example: Bracket C target 38%, actual 35% β†’ GREEN βœ… | | 🟑 YELLOW | Target +10% s.d +20% | WATCH CLOSELY - early warning | Daily monitoring + identify cause
Review upcoming expenses
Cost reduction plan dibuat
Frequency: Daily tracking
Example: Bracket C, actual 45-50% β†’ YELLOW ⚠️ | | 🟠 ORANGE | Target +20% s.d +30% | SERIOUS - margin terancam | STOP non-essential spending
Emergency meeting Owner+PM+Finance
Client notification (soft warning)
Frequency: Daily report to Owner
Output: Corrective action MANDATORY
Example: Bracket C, actual 55-60% β†’ ORANGE 🟠 | | πŸ”΄ RED | >Target +30% atau >65% | CRITICAL - margin hampir habis | FREEZE all spending immediately
Emergency meeting dengan Client
Options: 1) Client bayar additional 20-30%
2) Scope reduction drastis
3) Project termination (prepare)
Example: Bracket C, actual >65% β†’ RED πŸ”΄ | | πŸ’€ DISASTER | >75% atau Cost > Revenue | LOSS IMMINENT | TERMINATE PROJECT immediately
No negotiation - protect company
Handover as-is + legal if needed
Decision: MANDATORY stop, no exception |

FORMULA:

Cost Ratio = (Total Biaya Actual Γ· Revenue Kontrak) Γ— 100%

CONTOH PERHITUNGAN: Proyek: Pak Rony (Rp 604 juta)

Week Biaya Actual Revenue Cost Ratio Status Action
Week 4 Rp 120 juta Rp 604 juta 19,9% 🟒 GREEN Normal
Week 8 Rp 280 juta Rp 604 juta 46,4% 🟑 EARLY WARNING Review & cost control ketat

Indikator 2: Timeline Variance

[!NOTE] TIMELINE DELAY WARNING SYSTEM | Zone | Delay | Status | Action | |------|-------|--------|--------| | 🟒 ON TRACK | 0-5% | Good progress | Continue normal
Example: Target 100 hari, actual 105 hari | | 🟑 MINOR DELAY | 6-15% | Acceptable with recovery plan | Accelerate non-critical path
Review cause of delay
Example: Target 100 hari, actual 115 hari | | 🟠 MAJOR DELAY | 16-30% | CONCERN - impacting cashflow | Emergency meeting
Client notification
Recovery plan MANDATORY
Impact: Next termin payment delayed!
Example: Target 100 hari, actual 130 hari | | πŸ”΄ CRITICAL DELAY | >30% | SEVERE - risk project failure | Escalate to Owner
Renegotiate with client
Consider additional resources
Decision: Continue atau cut loss?
Example: Target 100 hari, actual >130 hari |

DAMPAK DELAY KE CASHFLOW:

Delay Payment Impact Financial Impact
0-5% Minimal Rp 0-5 juta overhead
6-15% 1-2 minggu Rp 5-15 juta
16-30% 3-4 minggu Rp 15-30 juta
>30% >1 bulan Rp 30-50 juta+

[!WARNING] Peringatan Setiap 1 bulan delay = Overhead Rp 12-18 juta terbuang!


Indikator 3: Payment Collection Rate

[!NOTE] PAYMENT COLLECTION WARNING SYSTEM | Zone | Payment Delay | Status | Action | |------|---------------|--------|--------| | 🟒 HEALTHY | 0-7 hari | Client bayar on-time atau sedikit delay | Normal follow-up
Example: Termin due 15 Jan, paid 20 Jan | | 🟑 CONCERN | 8-14 hari | Perlu follow-up intensif | Daily reminder via WA/call
Courtesy visit jika perlu
Impact: Cashflow mulai tertekan | | 🟠 SERIOUS | 15-30 hari | HIGH RISK - cash problem suspected | STOP all works immediately
Formal letter/email reminder
Owner direct contact dengan client
Decision: Lanjut hanya setelah payment masuk | | πŸ”΄ CRITICAL | >30 hari | BAD DEBT RISK | PROJECT SUSPENDED
Legal warning letter
Prepare claim/legal action
Protection: Jangan tambah biaya lagi! |

[!CAUTION] NO PAYMENT = NO WORK POLICY - Termin 1 belum masuk? β†’ STOP pembelian material termin 2 - Termin 2 belum masuk? β†’ STOP all works - >2 termin nunggak? β†’ PROJECT TERMINATION - Pelunasan belum masuk? β†’ TIDAK handover kunci


Indikator 4: Scope Creep Index

[!NOTE] SCOPE CREEP WARNING SYSTEM | Zone | Change Order | Status | Action | |------|--------------|--------|--------| | 🟒 NORMAL | <5% dari kontrak | Wajar, minor adjustments | Standard change order process
Example: Kontrak Rp 300jt, tambahan Rp 10jt | | 🟑 WATCH | 5-15% | Significant but manageable | Detailed approval, strict payment 50% DP
Track separately from main project
Example: Kontrak Rp 300jt, tambahan Rp 30jt | | 🟠 CONCERN | 15-30% | HIGH - Scope tidak terkontrol | STOP accepting new changes
Review dengan client: prioritas vs budget
Warning: Risk client tidak mau bayar semua!
Example: Kontrak Rp 300jt, tambahan Rp 60jt | | πŸ”΄ DANGER | >30% | CHAOS - Proyek melenceng total | FREEZE semua perubahan
Renegotiate kontrak baru
atau TERMINATE
Example: Kontrak Rp 300jt, tambahan >Rp 90jt |

[!CAUTION] CHANGE ORDER PROTOCOL (NON-NEGOTIABLE) SETIAP pekerjaan tambahan WAJIB: 1. βœ… Foto area + deskripsi detail 2. βœ… Quotation terpisah dengan breakdown 3. βœ… Written approval dari client (WA/Email minimal) 4. βœ… DP 50% untuk change order diterima DULU 5. βœ… Sisa 50% sebelum pekerjaan tambahan selesai


Indikator 5: Material Variance

[!NOTE] MATERIAL COST VARIANCE WARNING | Zone | Variance | Status | Action | |------|----------|--------|--------| | 🟒 ON BUDGET | ±5% | Material cost sesuai RAB | Continue normal procurement | | 🟑 MINOR OVER | +6% s.d +15% | Masih acceptable | Review next procurement
Find alternative supplier
Cause: Harga naik wajar / spec upgrade approved | | 🟠 MAJOR OVER | +16% s.d +30% | CONCERN - eating margin | STOP procurement
PM + Owner review
Renegotiate atau ganti material
Cause: Bad procurement / spec tidak sesuai | | πŸ”΄ CRITICAL | >+30% | DISASTER - margin habis | Emergency audit
Investigate fraud/kickback
Disciplinary action jika terbukti |

[!TIP] ROOT CAUSE ANALYSIS (saat variance >15%) - Harga market naik? β†’ Request price adjustment ke client - Salah estimasi RAB? β†’ Learn & fix untuk next project - Waste berlebihan? β†’ Site management issue - Spec upgrade tanpa approval? β†’ Policy violation - Fraud/kickback? β†’ Investigation & legal action


3.2 Weekly Project Report Template

[!NOTE] WEEKLY PROJECT STATUS REPORT PROJECT INFO:

Field Value
Nama Proyek _____
Client ____-------
Nilai Kontrak Rp _______
Week # ___ (Tanggal: ___ s.d ___)
PM _____
Overall Status 🟒 / 🟑 / 🟠 / πŸ”΄

1. PROGRESS UPDATE

Metric Value
Physical Progress ___%
Timeline Progress On Time / Delay ___ days
Milestone This Week _______
Issues/Blockers _______

2. FINANCIAL STATUS (5 INDIKATOR KUNCI)

KPI Target Actual Status Trend
Cost Ratio <45% ____% πŸŸ’πŸŸ‘πŸŸ πŸ”΄ ↑↓↔
Timeline Variance <5% ____% πŸŸ’πŸŸ‘πŸŸ πŸ”΄ ↑↓↔
Payment Collection <7 hari ___ hari πŸŸ’πŸŸ‘πŸŸ πŸ”΄ ↑↓↔
Scope Creep Index <5% ____% πŸŸ’πŸŸ‘πŸŸ πŸ”΄ ↑↓↔
Material Variance Β±5% +____% πŸŸ’πŸŸ‘πŸŸ πŸ”΄ ↑↓↔

DETAILED FINANCIALS:

Item Budget (RAB) Actual (YTD) %
Revenue Received
Material Cost
Labor Cost
Subcon Cost
Other Cost
TOTAL COST
Gross Profit (Est)
Gross Margin % ___%

3. RISK STATUS

Overall Risk Level: 🟒 GREEN / 🟑 YELLOW / 🟠 ORANGE / πŸ”΄ RED

Active Risks: 1. ________ 2. _______ 3. _________

Mitigation Actions Taken: 1. ________ 2. _______ 3. _________


4. NEXT WEEK PLAN

Item Detail
Key Activities _______
Material to Procure _______
Expected Payment Rp __ (Termin _)
Potential Issues _______

5. ACTION ITEMS & ESCALATIONS

  • [ ] Normal - No escalation needed
  • [ ] Early Warning - PM handle, inform Owner
  • [ ] Serious - Owner review required
  • [ ] Critical - Emergency meeting required

Specific Actions: 1. ________ 2. _______ 3. _________


ATTACHMENTS: - [ ] Progress photos - [ ] Cost tracking spreadsheet - [ ] Updated timeline (if delayed) - [ ] Change order documentation (if any)


SIGNATURES:

Role Signature Date
PM _______ _
Finance Review _______ _
Owner Reviewed _______ _

4. DECISION MATRIX FRAMEWORK

4.1 Multi-Factor Decision Model

Ketika proyek menunjukkan warning signs, gunakan matrix ini untuk menentukan action:

flowchart TD A[START: Warning trigger activated] --> B{Question 1:
Berapa % proyek
sudah selesai?} B -->|<30%| C[EASIER to cut loss
or renegotiate
β†’ Consider TERMINATE
jika red flags banyak] B -->|30-70%| D[MODERATE -
Evaluate carefully
β†’ Fix atau continue
dengan strict monitoring] B -->|>70%| E[HARDER to stop -
sunk cost high
β†’ Push to finish
tapi cap the loss] C & D & E --> F{Question 2:
Berapa cost ratio
saat ini?} F -->|<55%| G[Masih ada margin
β†’ FIX THE PROBLEM,
continue] F -->|55-70%| H[Margin tipis
β†’ RENEGOTIATE payment
atau reduce scope] F -->|>70%| I[Margin hampir/
sudah habis
β†’ STOP LOSS immediately] G & H & I --> J{Question 3:
Apakah client
kooperatif?} J -->|YES| K[NEOTIABLE -
Ada harapan selamat] J -->|NO| L[HIGH RISK -
Protect company assets
β†’ Prepare legal action] K & L --> M{Question 4:
Apakah masalah
bisa diperbaiki?} M -->|YES| N[CONTINUE dengan
action plan] M -->|NO| O[EXIT STRATEGY -
minimize damage] N --> P{FINAL DECISION} O --> P P --> Q[βœ… CONTINUE + FIX
Conditions:
β€’ Cost ratio <70%
β€’ Client kooperatif
β€’ Progress >50%
β€’ Problem solvable

Actions:
β€’ Implement corrective plan
β€’ Daily monitoring
β€’ Weekly Owner review] P --> R[⚠️ CONDITIONAL CONTINUE
Conditions:
β€’ Client agree payment adjustment
β€’ Scope reduction approved
β€’ Timeline extension granted
β€’ Cost cap agreed

Actions:
β€’ Renegotiate contract
β€’ Written addendum
β€’ Milestone-based payment] P --> S[πŸ›‘ STOP LOSS / TERMINATE
Conditions:
β€’ Cost ratio >75%
β€’ Client tidak kooperatif
β€’ Unsolvable fundamental issues
β€’ Legal/safety risks

Actions:
β€’ Immediate work stoppage
β€’ Handover as-is
β€’ Legal protection
β€’ Claim assessment]

4.2 Stop-Loss Trigger Matrix

[!CAUTION] AUTOMATIC STOP-LOSS TRIGGERS (MANDATORY - NO DISCUSSION) | Level | Trigger | Action | Decision | |-------|---------|--------|----------| | LEVEL 1: EARLY WARNING | Cost Ratio 50-60% | β€’ PM submit detailed report to Owner (same day)
β€’ Review all upcoming expenses
β€’ Cost reduction plan dibuat dalam 48 jam
β€’ Monitoring naik jadi DAILY | CONTINUE dengan monitoring ketat | | LEVEL 2: SERIOUS WARNING | Cost Ratio 61-70% | β€’ STOP all non-essential purchases
β€’ Emergency meeting Owner + PM + Finance (24 jam)
β€’ Client notification tentang cost concern
β€’ Review options: a) Request additional payment, b) Reduce scope drastis, c) Prepare exit strategy | CONTINUE only dengan approval Owner & clear corrective action plan | | LEVEL 3: CRITICAL | Cost Ratio 71-80% | β€’ FULL STOP semua pengeluaran proyek
β€’ Immediate Owner + Client meeting (dalam 48 jam)
β€’ Written notice ke client tentang status
β€’ Options: a) Client pay additional minimum 20%, b) Project scope cut 30-50%, c) Project terminated | CANNOT continue tanpa salah satu option dipilih & executed | | LEVEL 4: DISASTER PREVENTION | Cost Ratio >80% ATAU Cost > Revenue | β€’ IMMEDIATE PROJECT TERMINATION
β€’ No negotiation, no "kasihan client"
β€’ Handover as-is dalam kondisi saat ini
β€’ Legal protection mode activated
β€’ Document semua evidence
β€’ Prepare claim untuk payment outstanding
β€’ Legal counsel jika client tidak kooperatif | TERMINATE - NO EXCEPTION |

**SPECIAL TRIGGERS (Auto-Escalate):**
- Payment delay >30 hari β†’ STOP project
- Client MIA (missing in action) >14 hari β†’ STOP
- Safety incident β†’ STOP until resolved
- Legal issue muncul β†’ STOP & consult lawyer
- Force majeure (banjir, kebakaran, dll) β†’ STOP

5. ACTION PROTOCOL PER WARNING LEVEL

5.1 Green Zone Protocol (Normal Operations)

[!TIP] GREEN ZONE PROTOCOL Status: Semua indikator hijau, proyek berjalan sesuai rencana

Monitoring Frequency: - Weekly report ke Owner - Monthly financial summary - Standard site visit

Actions: - [ ] CONTINUE normal operations - [ ] Weekly PM report (standard template) - [ ] Monthly profitability check - [ ] Maintain good communication dengan client - [ ] Document progress dengan foto - [ ] Prepare for next termin collection

**No special action needed**, enjoy the smooth sailing! 🚒

5.2 Yellow Zone Protocol (Early Warning)

[!WARNING] YELLOW ZONE PROTOCOL Status: 1-2 indikator kuning, perlu perhatian lebih

Monitoring Frequency: - Daily cost tracking - Weekly Owner review meeting - Increased site supervision

WITHIN 24 HOURS: - [ ] PM submit detailed report explaining yellow flags - [ ] Identify root cause of warning - [ ] Propose corrective action plan - [ ] Get Owner approval for plan

WITHIN 48 HOURS: - [ ] Implement corrective actions - [ ] Review upcoming expenses - [ ] Re-forecast final cost & margin - [ ] Set daily monitoring

ONGOING: - [ ] Daily cost tracking updates - [ ] Daily PM report to Owner (via WA group) - [ ] Weekly review meeting - [ ] Track effectiveness of corrective actions

Sample Corrective Actions:

Warning Type Root Cause Corrective Action
Cost ratio 45-55% Material over-budget β€’ Switch to alternative supplier
β€’ Negotiate bulk discount
β€’ Reduce waste
Timeline delay 6-15% Weather / resource β€’ Add workers (if margin allows)
β€’ Extend work hours
β€’ Parallel activities
Payment delay 8-14 hari Client cash issue β€’ Daily friendly reminder
β€’ Offer payment plan
β€’ Slow down non-paid works
Scope creep 5-15% Client requests β€’ Strict change order process
β€’ 50% DP untuk semua tambahan
β€’ Limit further changes

Yellow Zone Decision Points:

flowchart TD A[After 1 week of corrective action] --> B{Improvement?} B -->|back to green| C[βœ… Continue dengan monitoring normal] B -->|still yellow| D[⚠️ Escalate intensity, consider preemptive talks with client] B -->|turning orange| E[🟠 Escalate to Orange Zone Protocol immediately]

5.3 Orange Zone Protocol (Serious Warning)

[!CAUTION] ORANGE ZONE PROTOCOL Status: 2+ indikator kuning ATAU 1 indikator orange, proyek dalam masalah serius

Monitoring Frequency: - REAL-TIME cost tracking (daily update) - Daily Owner review - Client communication intensified

WITHIN 4 HOURS: - [ ] STOP all non-essential spending - [ ] Notify Owner immediately (call/WA) - [ ] Emergency meeting Owner + PM + Finance - [ ] Assess severity & options

WITHIN 24 HOURS: - [ ] Contact client - inform status - [ ] Present 3 options: - Option A: Additional payment - Option B: Scope reduction - Option C: Project termination - [ ] Document everything in writing - [ ] Set deadline untuk client decision (3-5 hari max)

WITHIN 48 HOURS (if no client response): - [ ] Formal written notice via email/letter - [ ] Stop all field works - [ ] Secure tools & materials on-site - [ ] Prepare legal documentation

ONGOING UNTIL RESOLVED: - [ ] ZERO new spending tanpa Owner approval - [ ] Daily situation report - [ ] Prepare exit strategy parallel - [ ] Protect company interests

Orange Zone Decision Tree:

flowchart TD A[Client Response within deadline?] -->|YES - Client Kooperatif| B{Agree to pay additional?} A -->|NO - Client tidak merespons| C[πŸ›‘ Forced termination] B -->|YES| D[βœ… Resume work after payment received
β€’ Revise budget & margin expectation
β€’ Written addendum to contract
β€’ Strict monitoring continues] B -->|NO| E{Agree to scope reduction?} E -->|YES| F[βœ… Revise scope & continue
β€’ Document scope cuts clearly
β€’ Adjust timeline
β€’ Recalculate final margin] E -->|NO| G{Agree to terminate?} G -->|YES| H[πŸ›‘ Execute termination protocol
β€’ Handover as-is
β€’ Final accounting
β€’ Settlement agreement] G -->|NO| C C --> I[β€’ Work stoppage
β€’ Legal notice
β€’ Claim preparation]

5.4 Red Zone Protocol (Critical / Disaster)

[!CAUTION] RED ZONE PROTOCOL Status: Cost ratio >70% ATAU multiple critical indicators

This is EMERGENCY MODE 🚨

HOUR 0 (Trigger detected): - [ ] FULL STOP all project activities IMMEDIATELY - [ ] Call Owner ASAP (tidak bisa ditunda) - [ ] Secure all company assets on-site (tools, materials) - [ ] Emergency meeting within 4 hours (mandatory) - [ ] Document current status completely

**HOUR 4 (Emergency meeting):**
- [ ] Attendees: Owner, PM, Finance (NON-NEGOTIABLE)
- Agenda:
  1. Situation assessment (how bad is it?)
  2. Financial damage calculation
  3. Legal risk assessment
  4. Decision: Save atau Cut Loss?
  5. Action plan untuk next 24-48 jam
- Output:
  - Clear decision documented
  - Assigned responsibilities
  - Timeline for execution
  - Communication plan
- [ ] Owner final approval required

**HOUR 24 (Client notification):**
- [ ] Formal written notice to client (email + hardcopy)
- Content:
  - Current project status
  - Financial situation (transparent)
  - Company position & options
  - Deadline for client response (48-72 jam)
  - Consequences of no response
- [ ] Delivery: Email + WA + Surat (triple confirmation)
- [ ] Document proof of delivery

**HOUR 48-72 (Awaiting client response):**
- [ ] NO additional work on-site
- [ ] Prepare 2 parallel scenarios:
  - Scenario A: Client kooperatif (settlement)
  - Scenario B: Client tidak kooperatif (legal)
- [ ] Gather all evidence:
  - Contract & addendums
  - All communications (WA, email)
  - Photos & videos
  - Payment records
  - Cost receipts
  - Timeline documentation
- [ ] Consult legal counsel (if needed)

**HOUR 72+ (Execute decision):**
- [ ] Based on client response:
  - Settlement? β†’ Execute settlement agreement
  - Legal? β†’ Handover to lawyer
  - No response? β†’ Default to legal protection
- [ ] Finalize all documentation
- [ ] Close project financially
- [ ] Post-mortem analysis (learn for future)
- [ ] Team debrief & lessons learned session

Red Zone - Settlement Options:

Option Deskripsi Detail
OPTION 1:
Client Pay to Continue
Client pay additional = (Target BEP - Current situation) β€’ Minimum: Cover all costs + Rp 20-30 juta margin
β€’ Payment: 100% UPFRONT before any work resumes
β€’ Contract: Written addendum mandatory
OPTION 2:
Mutual Termination Agreement
Renovasia stop work, handover as-is β€’ Client pay for all costs incurred to date
β€’ Both parties release claims (mutual release)
β€’ Handover: Professional, documented dengan BA
β€’ Agreement: Written & signed by both parties
OPTION 3:
Client Complete on Their Own
Renovasia withdraw dari proyek β€’ Client take over remaining works
β€’ Settlement: Pay outstanding costs + admin fee
β€’ Handover: Site condition documentation
β€’ Release: No future claims from both sides
OPTION 4:
Legal Resolution (Last Resort)
File claim untuk unpaid invoices β€’ Claim for costs incurred
β€’ Seek legal remedies via lawyer
β€’ Risk: Time-consuming, expensive, uncertain
β€’ Use: Only jika client benar-benar tidak kooperatif

[!CAUTION] CRITICAL RULES untuk Red Zone 1. β›” NEVER continue work hoping "nanti bayarnya" 2. β›” NEVER spend more money to "selesaikan dulu" 3. β›” NEVER prioritize "customer service" over financial survival 4. β›” NEVER hide the situation from Owner 5. β›” NEVER make promises you can't keep to client 6. βœ… ALWAYS document EVERYTHING 7. βœ… ALWAYS protect company assets first 8. βœ… ALWAYS consult Owner before major decisions 9. βœ… ALWAYS get everything in writing 10. βœ… ALWAYS learn from the disaster untuk prevent next time


6. CASE STUDY DISASTER & LESSONS LEARNED

6.1 Case Study #1: Bu Raras Cimanggis

[!CAUTION] BU RARAS CIMANGGIS - DISASTER | Metric | Nilai | |--------|-------| | RAB Interior | Rp 106.900.000 | | Kontrak Actual | Rp 7.750.000 (hanya 7,2%!) | | Biaya Actual | Rp 44.087.700 | | Kerugian | Rp -36.337.700 | | Margin | -469% (DISASTER!) |

What Went Wrong? (Red Flags yang Terlewat)

Phase Red Flag Seharusnya Action Actual Action Impact
Pre-Project Scope tidak jelas, RAB Rp 106jt tapi client hanya kontrak Rp 7,7jt ❌ REJECT atau RENEGOTIATE scope βœ… Terima proyek dengan scope mismatch πŸ”΄ Fatal error #1
Pre-Project Client hanya mau bayar 7,2% dari RAB ❌ REFUSE - ini impossible profitable βœ… Hoping "nanti ada tambahan" πŸ”΄ Fatal error #2
Week 1-2 Biaya sudah Rp 20jt, revenue cuma Rp 7,7jt
Cost ratio: 259%!
πŸ›‘ STOP IMMEDIATELY βœ… Continue, hoping client akan bayar lebih πŸ”΄ Fatal error #3
Week 3-4 Biaya sudah Rp 35jt, masih jauh dari selesai πŸ›‘ EMERGENCY STOP βœ… Continue "sudah terlanjur" πŸ”΄ Fatal error #4
Week 5+ Biaya total Rp 44jt, client tidak mau bayar tambahan πŸ›‘ STOP & CUT LOSS βœ… Selesaikan proyek "supaya customer puas" πŸ”΄ Fatal error #5

Root Cause Analysis:

  1. Planning Failure: RAB Rp 106jt vs kontrak Rp 7,7jt = MISMATCH 93%!
    β†’ Ini NEVER should have been accepted

  2. No Pricing Floor: Tidak ada minimum project size enforcement
    β†’ Proyek kecil dengan scope besar = impossible math

  3. No Stop-Loss: Tidak ada automatic trigger untuk stop
    β†’ Continue sampai rugi Rp 36jt

  4. Client Expectation Mismatch: Client expect full RAB Rp 106jt dengan bayar Rp 7,7jt
    β†’ Communication failure sejak awal

  5. "Service Excellent" Trap: Prioritas customer satisfaction over profitability
    β†’ Company rugi Rp 36jt untuk "customer puas"

[!TIP] PREVENTION RULES dari Case Bu Raras 1. MINIMUM PROJECT SIZE - Proyek < Rp 25 juta: AUTOMATIC REJECT - Exception only untuk client loyal dengan track record

  1. SCOPE vs BUDGET ALIGNMENT CHECK
  2. Jika RAB Rp 100jt tapi client budget Rp 10jt: REJECT immediately atau scope cut 90%!
  3. Formula: Budget minimum = RAB Γ— 80%

  4. STOP-LOSS TRIGGER: Cost Ratio >60%

  5. Bu Raras hit 259% di week 2 β†’ Should have STOPPED
  6. Automatic freeze spending jika cost ratio >60%

  7. PRE-PROJECT RED FLAG CHECKLIST

  8. Bu Raras would score RED di client + technical
  9. Matrix decision: REJECT

  10. NO "HOPING CLIENT WILL PAY MORE" MENTALITY

  11. Jika scope Rp 100jt, client MUST agree upfront
  12. TIDAK ADA "dikerjakan dulu, nanti minta bayar"

  13. OWNER APPROVAL untuk HIGH-RISK PROJECT

  14. Proyek dengan red flags MUST get Owner pre-approval
  15. PM tidak boleh decide sendiri untuk extreme cases

What Should Have Happened:

IDEAL SCENARIO:
Day 1: Client approach dengan budget Rp 7,7jt, scope RAB Rp 106jt
β”œβ”€β–Ί Renovasia response:
"Pak/Bu, untuk scope yang Anda inginkan (RAB Rp 106jt),
budget minimal adalah Rp 85-90 juta.
Dengan budget Rp 7,7 juta, kami hanya bisa kerjakan:
- Option A: 7% dari scope (list detail)
- Option B: Consultation fee only (design + RAB)
- Option C: Kami referral ke kontraktor lain
Silakan pilih mana yang sesuai."
β”œβ”€β–Ί Client insist: "Tapi saya maunya semua dikerjakan"
└─► Renovasia: "Maaf Pak/Bu, itu tidak memungkinkan.
Kami tidak bisa rugi. Silakan cari kontraktor lain
atau adjust budget Anda."
└─► RESULT: Proyek DECLINED
Impact: Rp 0 revenue, tapi Rp 0 loss
Better than: Rp 7,7jt revenue dengan Rp -36jt loss!

6.2 Case Study #2: Bu Yasmin Bojong

[!CAUTION] BU YASMIN BOJONG - TOTAL LOSS | Metric | Nilai | |--------|-------| | Revenue | Rp 0 (ZERO!) | | Biaya Actual | Rp 14.723.250 | | Kerugian | Rp -14.723.250 | | Margin | -100% (TOTAL LOSS!) |

What Went Wrong?

Phase Issue Should Have Actual Impact
Pre-Project Tidak ada kontrak tertulis? βœ… Written contract MANDATORY ❌ Verbal agreement? πŸ”΄ No legal protection
Pre-Project Tidak ada DP βœ… REFUSE to start tanpa DP ❌ Start work tanpa DP πŸ”΄ Zero cash upfront
Execution Biaya sudah Rp 14jt, payment tidak masuk πŸ›‘ STOP immediately βœ… Continue working πŸ”΄ Loss keeps growing
Post-Work Client tidak bayar sama sekali βš–οΈ Legal action ❓ Unknown πŸ”΄ Total loss Rp 14,7jt

Root Cause Analysis:

  1. No Proper Contract: Tidak ada dokumen tertulis yang mengikat
    β†’ Legal exposure, client bisa "lupa" atau deny

  2. Zero Down Payment: Mulai kerja tanpa DP sama sekali
    β†’ Red flag besar! Client commitment sangat rendah

  3. No Payment Collection: Setelah work done, client tidak bayar
    β†’ Collection process failed atau client sengaja ngemplang

  4. Possible Client Fraud: Client mungkin dari awal niat tidak bayar
    β†’ Harus screening better di pre-project phase

[!TIP] PREVENTION RULES dari Case Bu Yasmin 1. NO CONTRACT = NO WORK (Absolute Rule) - Setiap proyek WAJIB ada SPK/Kontrak tertulis - Minimum: Scope, nilai, termin, timeline - Signed oleh kedua pihak

  1. NO DOWN PAYMENT = NO WORK (Absolute Rule #2)
  2. DP minimum 30% WAJIB diterima SEBELUM mulai
  3. Tidak ada exception untuk "client terpercaya"
  4. Tidak ada "nanti bayarnya kalau sudah selesai"

  5. VERIFY CLIENT IDENTITY & CONTACT

  6. KTP/ID card
  7. Alamat jelas
  8. No HP aktif
  9. Reference check untuk client baru

  10. PAYMENT MILESTONE ENFORCEMENT

  11. Termin 1 belum masuk? β†’ STOP work
  12. Termin 2 belum masuk? β†’ STOP & legal notice
  13. Pelunasan belum lunas? β†’ TIDAK handover

  14. LEGAL PROTECTION KIT

  15. Template contract ready
  16. Standard SPK dengan terms clear
  17. Collection SOP (reminder, notice, legal)
  18. Lawyer contact untuk emergency case

  19. CLIENT BLACKLIST SYSTEM

  20. Maintain list of bad clients
  21. Share dengan industry network (jika ethical)
  22. Auto-reject jika di blacklist

What Should Have Happened:

IDEAL SCENARIO:
Client: "Saya mau renovasi, tapi bayarnya nanti setelah selesai ya"
└─► Renovasia response:
"Maaf Pak/Bu, policy kami:
- Down payment 30% wajib sebelum mulai
- Tidak ada down payment = kami tidak bisa mulai
- Ini untuk melindungi kedua belah pihak
Jika Bapak/Ibu serius, silakan transfer DP terlebih dahulu.
Setelah DP masuk, kami baru mobilisasi tim.
Terima kasih atas pengertiannya."
β”œβ”€β–Ί Client bayar DP?
└─► βœ… PROCEED dengan contract proper
└─► Client tidak mau bayar DP?
└─► ❌ DECLINE proyek
Impact: Rp 0 revenue, Rp 0 loss
Better than: Rp 0 revenue, Rp -14,7jt loss!

6.3 Case Study #3: Pak Dani (Margin -61%)

[!CAUTION] PAK DANI - HEAVY LOSS | Metric | Nilai | |--------|-------| | Revenue | Rp 38.202.000 | | Biaya Actual | Rp 61.449.000 (161% dari revenue!) | | Kerugian | Rp -23.247.000 | | Margin | -61% (DISASTER!) | | Cost Ratio | 161% (>100% = spending lebih!) |

What Went Wrong?

Phase Likely Issue Should Have Impact
Pre-Project RAB underestimated atau pricing terlalu murah βœ… Proper RAB dengan buffer 15-20% πŸ”΄ Pricing tidak cover cost
Execution Material overrun atau scope creep tanpa bayar πŸ›‘ Stop di cost ratio 60-70% πŸ”΄ Cost 161% = massive overrun
Execution Vendor overcharge atau waste sangat tinggi βœ… Procurement control strict πŸ”΄ Biaya membengkak Rp 61jt
Control Tidak ada cost monitoring real-time βœ… Weekly cost tracking πŸ”΄ Warning signals terlewat

Root Cause Hypotheses (data terbatas):

  1. Bad Estimation: RAB terlalu optimis, tidak memperhitungkan complexity
  2. Scope Creep Unpaid: Client minta tambah-tambah tapi tidak bayar
  3. Material Price Shock: Harga material naik drastis, tidak di-adjust
  4. Procurement Issue: Vendor overcharge atau kickback
  5. Waste/Rework: Quality issue, harus ulang pekerjaan

[!TIP] PREVENTION RULES dari Case Pak Dani 1. RAB ACCURACY CHECK - RAB harus di-review minimal 2 orang (PM + Finance) - Contingency buffer 15-20% MANDATORY - Material prices harus updated (max 1 bulan lalu)

  1. COST TRACKING DARI HARI 1
  2. Week 1: Check cost ratio (should be <10-15%)
  3. Week 2: Trend analysis (increasing atau stable?)
  4. Warning jika cost ratio >40% di <50% progress

  5. SCOPE CHANGE = PAYMENT CHANGE

  6. Setiap tambahan scope = quotation + approval + DP
  7. NO free scope additions
  8. "Service excellent" β‰  free services

  9. STOP-LOSS AT 70% COST RATIO

  10. Pak Dani 161% = jauh melewati trigger
  11. Should have STOPPED di 60-70%
  12. Cut loss Rp 15-20jt instead of Rp 23jt

  13. VENDOR AUDITING

  14. Compare 3 vendor prices untuk major items
  15. Spot-check material quality vs invoice
  16. Investigate jika variance >15%

  17. PROGRESS vs COST ALIGNMENT

  18. Progress 30% β†’ Cost should be ~30-35%
  19. Red flag jika Progress 30% tapi Cost 50%+

Prevention Timeline:

WEEK 1-2 (Early Detection):
Progress: 20%
Cost: Rp 20jt (52% of revenue Rp 38jt)
Cost Ratio: 52%!
└─► 🟑 YELLOW ALERT!
Action: Emergency review
- Why cost so high early?
- Material overpriced?
- Scope creep already?
Decision: FIX immediately atau consider terminate
WEEK 3-4 (Crisis Point):
Progress: 50%
Cost: Rp 40jt (105% of revenue!)
Cost Ratio: 105%!
└─► πŸ”΄ RED ALERT - STOP NOW!
Action: FULL PROJECT STOP
- Client meeting immediate
- Options: Pay Rp 30jt more atau terminate
- Cut loss at -Rp 2jt instead of -Rp 23jt
ACTUAL (What Happened):
Progress: 100% (finished)
Cost: Rp 61jt (161%)
Loss: -Rp 23jt
└─► πŸ’€ TOO LATE - Massive damage done
Prevention failed at every checkpoint

6.4 Summary: Common Patterns Disaster Projects

[!NOTE] COMMON PATTERNS - 3 DISASTER PROJECTS | Pattern | Deskripsi | Prevention | |---------|-----------|------------| | ❌ PATTERN #1:
Accepting Impossible Projects | β€’ Scope vs budget mismatch ekstrim
β€’ Client tidak willing bayar harga realistis
β€’ Hoping "nanti bisa minta lebih" | Pre-project red flag screening | | ❌ PATTERN #2:
No Formal Contract / No DP | β€’ Mulai kerja tanpa proteksi legal
β€’ Trust-based agreement yang tidak binding
β€’ Client commitment rendah dari awal | No Contract/DP = No Work rule | | ❌ PATTERN #3:
No Cost Control & Stop-Loss | β€’ Cost ratio meledak tanpa early warning
β€’ Continue sampai selesai meski sudah rugi
β€’ "Sudah terlanjur" mentality | Weekly tracking + auto stop-loss | | ❌ PATTERN #4:
"Service Excellent" Trap | β€’ Prioritize customer satisfaction over profit
β€’ Free scope additions untuk "customer happy"
β€’ Company rugi tapi customer senang = BAD BUSINESS | Profit-first mindset | | ❌ PATTERN #5:
Weak Client Screening | β€’ Accept semua clients tanpa assessment
β€’ No verification, no reference check
β€’ Walk-in clients dengan red flags diterima | Client risk assessment mandatory |

The Good News:

βœ… Dari 22 proyek dengan RAB lengkap: 95,5% sukses (21/22 profitable)
βœ… Disaster cuma 3 dari 37 = 8,1% (masih minority)
βœ… All disasters PREVENTABLE dengan sistem yang tepat
βœ… Success pattern REPEATABLE dengan follow SOP

Kalau sistem Red Flag + Early Warning ini dipakai konsisten:
β†’ 3 disaster (Rp -74jt loss) bisa dicegah atau diminimalkan
β†’ Success rate bisa naik dari 62% ke 85-90%
β†’ Annual profit bisa naik Rp 50-100 juta dari prevent losses


7. CHECKLIST & TOOLS

7.1 Master Checklist - Project Lifecycle

[!NOTE] RENOVASIA PROJECT SAFETY CHECKLIST Gunakan untuk SETIAP proyek tanpa exception

PHASE 1: PRE-PROJECT ASSESSMENT - [ ] Red Flag Assessment dilakukan (Client + Technical score) - [ ] Combined Risk Level determined (Green/Yellow/Red) - [ ] Budget β‰₯ Rp 25 juta (atau ada exception approval) - [ ] Pricing Floor check: β‰₯ Rp 2,5 juta/mΒ² - [ ] Expected margin β‰₯ 40% - [ ] RAB detailed sudah dibuat dan di-review - [ ] Contract/SPK prepared dengan terms jelas - [ ] DP requirement sesuai risk level (30-50%) - [ ] Owner approval jika kategori Yellow/Red - [ ] Decision: ACCEPT / ACCEPT WITH CONDITIONS / REJECT

PHASE 2: PROJECT KICK-OFF - [ ] Contract signed oleh client - [ ] DP diterima & cleared di bank (MANDATORY) - [ ] Scope of work documented dengan detail - [ ] Drawing/design approved oleh client - [ ] Material specification confirmed - [ ] Timeline realistic dan agreed - [ ] Payment schedule clear (termin + dates) - [ ] PM assigned dan briefed - [ ] Site survey completed - [ ] Subkontraktor & supplier identified - [ ] Cost tracking system setup - [ ] Weekly reporting schedule set

PHASE 3: EXECUTION MONITORING (WEEKLY)

Week: ___

  • [ ] Physical progress update (foto + percentage)
  • [ ] Cost ratio calculation & status (Green/Yellow/Orange/Red)
  • [ ] Timeline variance check (on-time / delay ___ days)
  • [ ] Payment collection status (termin due vs actual)
  • [ ] Scope creep index (change orders tracking)
  • [ ] Material variance check (budget vs actual)
  • [ ] Risk status review (active risks documented)
  • [ ] PM weekly report submitted
  • [ ] Owner review completed (if Yellow+)
  • [ ] Corrective actions (if needed) implemented

WARNING TRIGGERS THIS WEEK: - [ ] None - All green βœ… - [ ] Early warning - Yellow flag(s) 🟑 - [ ] Serious warning - Orange flag(s) 🟠 - [ ] Critical - Red alert πŸ”΄

ACTIONS TAKEN:


PHASE 4: PAYMENT COLLECTION

For each termin:

Termin: ___ | Due date: __ | Amount: Rp __

  • [ ] Invoice sent to client (3 days before due)
  • [ ] Reminder sent (on due date)
  • [ ] Payment received & cleared
  • [ ] Delay: ___ days (0 = on time)
  • [ ] Action if delayed:
  • [ ] 1-7 days: Friendly reminder (WA/call)
  • [ ] 8-14 days: Intensive follow-up
  • [ ] 15-30 days: STOP work + formal notice
  • [ ] >30 days: Legal warning + project suspend

PHASE 5: PROJECT COMPLETION - [ ] Final inspection done - [ ] Punch-list items completed - [ ] Client final approval received - [ ] Pelunasan 100% received & cleared (MANDATORY before handover) - [ ] Handover documentation prepared (BA, warranty, manual) - [ ] Kunci & documents handed over to client - [ ] Site cleanup completed - [ ] Final photos taken (before-after) - [ ] Client satisfaction survey - [ ] Referral request (jika client puas)

PHASE 6: POST-PROJECT REVIEW - [ ] Final financial summary completed - [ ] Actual vs Budget analysis - [ ] Final margin calculation - [ ] Lessons learned documented - [ ] RAB template updated (jika ada learning) - [ ] Client profile updated (untuk future reference) - [ ] Success case study (jika margin >60%) - [ ] Team debrief session - [ ] Warranty period tracking setup (if applicable)

FINAL METRICS: | Metric | Value | |--------|-------| | Final Revenue | Rp _ | | Final Cost | Rp _ | | Gross Profit | Rp _ | | Gross Margin % | _% | | Timeline Variance | ___% (on time / delay / early) | | Client Satisfaction | ⭐⭐⭐⭐⭐ (1-5 stars) | | Overall Grade | A / B / C / D / F |


7.2 Quick Decision Tools

Tool #1: 60-Second Risk Score

[!NOTE] 60-SECOND PROJECT RISK CALCULATOR (Quick Pre-Screen) | Question | Option | Points | |----------|--------|--------| | Q1: Budget berapa? | >Rp 250 juta | 0 point | | | Rp 100-250 juta | 1 point | | | <Rp 100 juta | 3 points | | Q2: Client mau DP berapa persen? | 30-40% OK | 0 point | | | Nego 20-25% | 2 points | | | Tolak DP / <20% | 5 points | | Q3: Timeline expectation? | 4-6 bulan realistis | 0 point | | | 2-3 bulan tight | 1 point | | | <2 bulan unrealistis | 3 points | | Q4: Scope clarity? | Jelas, ada design | 0 point | | | Agak fuzzy | 2 points | | | Sangat tidak jelas | 4 points | | Q5: Client price sensitivity? | Focus value | 0 point | | | Nego 5-10% | 1 point | | | Bargain >20% | 3 points |


TOTAL RISK SCORE: _____ points

Score Interpretation
0-3 points βœ… LOW RISK - Accept
4-7 points ⚠️ MEDIUM RISK - Accept dengan syarat ketat
8-12 points πŸ”΄ HIGH RISK - Premium pricing +30% atau reject
13+ points ❌ EXTREME RISK - REJECT
**TIME:** 60 seconds  
**USE:** First phone call / initial meeting screening

Tool #2: Stop-Loss Calculator

[!NOTE] STOP-LOSS TRIGGER CALCULATOR INPUT:

Field Value
Nilai Kontrak Rp _____

CALCULATE TRIGGERS:

Zone Calculation Trigger Amount
🟑 Early Warning (50%) Kontrak Γ— 50% Rp ____ Γ— 50% = Rp ____
🟠 Serious Warning (65%) Kontrak Γ— 65% Rp ____ Γ— 65% = Rp ____
πŸ”΄ Critical (75%) Kontrak Γ— 75% Rp ____ Γ— 75% = Rp ____

β†’ Jika biaya actual mencapai trigger: ALERT!

EXAMPLE: Kontrak Rp 300 juta: - Yellow trigger: Rp 150 juta (50%) - Orange trigger: Rp 195 juta (65%) - RED trigger: Rp 225 juta (75%) β†’ STOP!

SET ALERTS di cost tracking: - [ ] Reminder di Rp _ - [ ] Warning di Rp _ - [ ] STOP di Rp ____


Tool #3: Payment Delay Tracker

[!NOTE] PAYMENT DELAY ACTION TRACKER | Day | Action | Status | |-----|--------|--------| | DAY 0 (Due date) | Send reminder via WA (friendly)
Confirm client received invoice | | | DAY +3 | Follow-up call (polite inquiry) | 🟒 Green | | DAY +7 | Second reminder (more formal) | 🟑 Yellow - Watch closely | | DAY +10 | Direct call to decision maker
Email formal reminder | 🟠 Orange - Escalate | | DAY +14 | 🚨 SERIOUS DELAY
STOP all work on-site immediately
Notify Owner
Send formal letter/email (registered) | πŸ”΄ Red - Crisis mode | | DAY +21 | Owner direct contact dengan client
Warning: Legal action in 7 days
Prepare termination docs | | | DAY +30 | πŸ›‘ CRITICAL - EXECUTE STOP-LOSS
PROJECT SUSPENDED officially
Legal warning letter sent
Consult lawyer untuk next steps
Protect company assets | |

**NOTES:**
_________________________________________________________________
_________________________________________________________________

8. ESCALATION & AUTHORITY MATRIX

8.1 Decision Authority Levels

Level Authority Scope Limit
LEVEL 1:
PROJECT MANAGER (PM)
Decide Sendiri β€’ Green flag projects: accept & execute
β€’ Minor changes (<5% scope): approve
β€’ Daily operational decisions
β€’ Vendor selection (dalam budget)
β€’ Weekly reporting
Impact <Rp 5 juta
LEVEL 2:
PM + FINANCE
Joint Decision β€’ Budget variance >10%
β€’ Change order Rp 5-15 juta
β€’ Payment term negotiation
β€’ Early warning situations (Yellow flag)
β€’ Monthly financial review
Impact Rp 5-15 juta
LEVEL 3:
PM + FINANCE + OWNER
Approval Needed β€’ Yellow/Red flag projects: accept atau reject
β€’ Change order >Rp 15 juta
β€’ Serious warning situations (Orange flag)
β€’ Budget overrun >20%
β€’ Timeline extension >2 weeks
β€’ Payment delay >14 hari
β€’ Scope reduction negotiation
Impact Rp 15-50 juta
LEVEL 4:
OWNER ONLY
Final Decision β€’ Critical situations (Red flag)
β€’ Project termination decision
β€’ Legal action decisions
β€’ Write-off losses >Rp 20 juta
β€’ Client blacklist decisions
β€’ Policy exceptions (special cases)
Any impact >Rp 50 juta atau reputational risk

8.2 Escalation Protocol

[!NOTE] WHEN & HOW TO ESCALATE? | Zone | Action | Method | Timeline | |------|--------|--------|----------| | 🟒 GREEN ZONE | No escalation | PM manage normal, weekly report to Owner | Standard | | 🟑 YELLOW ZONE | Inform Owner (same day) | WA message + brief explanation
Content: What's yellow? What's the plan?
Owner response: Acknowledge, may request details | Daily updates until back to green | | 🟠 ORANGE ZONE | Emergency meeting (within 24 hours) | Phone call Owner + Emergency meeting
Attendees: PM + Finance + Owner (MANDATORY)
Content: Full situation, options, recommendations
Output: Clear decision & action plan | Daily reports until resolved | | πŸ”΄ RED ZONE | Immediate escalation (within 4 hours) | Direct call Owner (interrupt apapun)
Meeting: Emergency (dalam 4 jam, non-negotiable)
Content: Crisis briefing, damage assessment
Decision: Owner makes final call
Execute: Immediate action based on decision | Hourly updates until stabilized |

Escalation Communication Template:

[!NOTE] ESCALATION MESSAGE TEMPLATE | Field | Value | |-------|-------| | TO: | Owner | | FROM: | PM [Nama] | | DATE: | [Tanggal] [Jam] | | PRIORITY: | 🟑 YELLOW / 🟠 ORANGE / πŸ”΄ RED | | PROJECT: | [Nama Proyek] | | CLIENT: | [Nama Client] | | ISSUE: | [Brief description] |


SITUATION:

Metric Value
Progress ___%
Cost Ratio ___% (Target: <45%)
Status 🟒 / 🟑 / 🟠 / πŸ”΄

Warning Triggers: - [Indikator 1]: [Value] - [Status] - [Indikator 2]: [Value] - [Status] - [Indikator 3]: [Value] - [Status]

Root Cause: [Explain apa yang menyebabkan masalah]

Financial Impact: | Item | Value | |------|-------| | Current Loss/Risk | Rp _ | | Projected Final Impact | Rp _ | | Timeline Impact | +___ days delay |


OPTIONS & RECOMMENDATION:

Option A Option B Option C
Description [Description] [Description] [Description]
Pros [Benefits] [Benefits] [Benefits]
Cons [Drawbacks] [Drawbacks] [Drawbacks]
Cost Rp ____ Rp ____ Rp ____
Timeline ___ days ___ days ___ days

MY RECOMMENDATION: Option ___ Reasoning: [Explain why]


REQUESTED ACTION: - [ ] Approve recommendation & execute - [ ] Emergency meeting untuk diskusi (when: __) - [ ] Different approach (please advise)

URGENCY: - [ ] Immediate (dalam 4 jam) - [ ] Urgent (dalam 24 jam) - [ ] Soon (dalam 48 jam)


ATTACHMENTS: - [ ] Cost tracking spreadsheet - [ ] Photos/evidence - [ ] Client communication - [ ] Other: ____

PM: [Nama]
Contact: [No HP]

πŸ“Œ QUICK REFERENCE SUMMARY

The 10 Commandments of Project Safety

  1. Thou Shalt Screen Every Client - Pre-project red flag assessment MANDATORY
  2. Thou Shalt Not Start Without DP - Minimum 30% DP, no exceptions
  3. Thou Shalt Not Accept Impossible Projects - Scope vs budget must align
  4. Thou Shalt Track Cost Weekly - Cost ratio monitoring dari week 1
  5. Thou Shalt Stop at 70% - Cost ratio >70% = automatic stop-loss trigger
  6. Thou Shalt Not Work for Free - Every scope change = quotation + payment
  7. Thou Shalt Escalate Early - Yellow flag = inform Owner same day
  8. Thou Shalt Protect Company First - Profitability > customer satisfaction
  9. Thou Shalt Document Everything - Paper trail untuk legal protection
  10. Thou Shalt Learn from Disasters - Post-mortem analysis after every problem

One-Page Cheat Sheet (Integrated dengan Cluster)

[!NOTE] RED FLAG & EARLY WARNING - QUICK GUIDE (v2.0) CLUSTER BRACKETS (Cek dulu proyek masuk mana): | Bracket | Nilai | Timeline | Notes | |---------|-------|----------|-------| | πŸ…°οΈ A | Rp 700jt | 6-10 bln | ⭐ BEST MARGIN |

PRE-PROJECT SCORING (Simple!): - πŸ“‹ Client Assessment: 10 indikator Γ— 🟒(0) 🟑(1) πŸ”΄(2) - πŸ“‹ Technical Assessment: 10 indikator Γ— 🟒(0) 🟑(1) πŸ”΄(2)

Score Category
0-4 pts GREEN (Low Risk)
5-9 pts YELLOW (Medium Risk)
10-14 pts ORANGE (High Risk)
15-20 pts RED (reject!)

AUTO-REJECT RULES (Non-Negotiable): - ❌ Budget 50% - ❌ Timeline unrealistis (<50% standard cluster) - ❌ Sengketa legal/permit aktif

COST RATIO WARNING (per Cluster Target): Bracket A: <50% | B: <40% | C: <38% | D: <35% | E: <32%

Zone Action
🟒 ≀Target Normal, weekly monitor
🟑 Target+10-20% Daily track + cost reduction plan
🟠 Target+20-30% Emergency meeting + STOP non-essential
πŸ”΄ >Target+30%/65% FREEZE spending + client negotiation
πŸ’€ >75% TERMINATE immediately (no exception)

PAYMENT DELAY PROTOCOL: | Delay | Action | |-------|--------| | 🟒 0-7 hari | Normal follow-up | | 🟑 8-14 hari | Daily reminder intensif | | 🟠 15-30 hari | STOP work + formal notice | | πŸ”΄ >30 hari | Project suspend + legal protection |

DECISION AUTHORITY (Decision Speed): | Amount | Authority | |--------|-----------| | πŸ’° Rp 50 juta | Owner final decision only | | πŸ›‘ Terminate | ALWAYS Owner only |

THE 10 COMMANDMENTS: 1. Screen setiap client (20-point checklist) 2. Jangan mulai tanpa DP (30-50% depending risk) 3. Jangan terima proyek impossible (scope vs budget) 4. Track cost weekly (cost ratio dari week 1) 5. Stop di 75% cost ratio (automatic, no exception) 6. Jangan kerja gratis (change order = quotation + DP) 7. Escalate early (yellow = inform Owner same day) 8. Protect company first (profit > customer satisfaction) 9. Document everything (paper trail for legal) 10. Learn from disasters (post-mortem analysis)

**GOLDEN RULES:**
- βœ… Prevention > Correction
- βœ… Data > Feeling | Cluster > Gut-feel
- βœ… Early Action > Late Regret
- βœ… Bracket B-E > Bracket A (better margin & efficiency)

🎯 IMPLEMENTATION ROADMAP

Week 1: System Setup

Week 2: Tool Preparation

Week 3: Pilot Implementation

Week 4: Full Rollout

Ongoing:


CLOSING MESSAGE:

Sistem Red Flag & Early Warning ini bukan untuk membuat kita paranoid,
tapi untuk membuat kita prepared.

Bukan untuk menolak semua proyek,
tapi untuk accept the right projects.

Bukan untuk menghindari risiko sama sekali,
tapi untuk manage risk dengan bijak.

Prevention jauh lebih murah daripada correction.
Rp 74 juta kerugian 2025 bisa dicegah dengan sistem ini.

Data tidak berbohong. Emotion bisa salah.
Ikuti trigger, jangan ikuti "feeling".

Profit dulu, baru customer satisfaction.
Company sehat = bisa service customers lebih baik long-term.

Mari kita pastikan 2026 ZERO DISASTER PROJECTS! 🎯


Document Control: - Version: 1.0 - Created: 27 Januari 2026 - Last Updated: 27 Januari 2026 - Next Review: 27 April 2026 (quarterly) - Owner: Management Renovasia - Status: ACTIVE - MANDATORY USE