XPM - Construction Project Management
Back to Case StudiesREFERENCE PROJECT | METRO RAIL TRANSIT
xPM - BMM Projects

How a Mega Metro Program Achieved a Cost Forecast That Updated the Moment a Single Unit Cost Moved

21.6 km Underground Metro Construction | Istanbul, Turkey

Istanbul Buyuksehir / IETT5-Firm JV DeliveryMaster Coding + Integrated Cost Control
2005-2011 | Istanbul, Turkey

5-Year

Cash Flow Forecast

5-Firm

Joint Venture

53-Sheet

Monthly Workbook

7

PMP Disciplines

THE PROJECT STORY

How a Mega Metro Program Held the Line on Cost Forecasting When the Ground Itself Was the Risk

SITUATION

In January 2005, T.C. Istanbul Buyuksehir Belediyesi (IETT) awarded the Kadikoy-Kartal Rayli Toplu Tasima Sistemi, an underground metro program traversing one of the most densely built corridors on the Asian side of Istanbul, to a five-firm joint venture (Yapi Merkezi, Dogus, Yuksel, Yenigun, Belen). The contract covered station-box excavation, tunnel construction, mechanical and electrical systems, and finishing works across a multi-year horizon. Cash flow was forecast through 5 years visibility requirement.

COMPLICATION

Underground metro work is uniquely exposed to discovery risk. Soil profiles, groundwater elevation, rock depth, and the requirement for ground improvement (jet grouting) are estimated from preliminary boreholes, and revised the moment excavation begins. In April 2006, the program's earned value position dropped to BLACK status: Schedule Performance Index (SPI) at 0.254 (actual progress at one-quarter of plan) and Cost Performance Index (CPI) at 0.779. Five contracting firms, dozens of subcontractors, and the owner's board needed to know, within thirty days, what the project would cost at completion if April performance continued, and whether May was a recovery or a deeper fall.

QUESTION

How does the management board of a mega metro joint venture know, every month, with verifiable arithmetic, what the project will cost at completion when a single material unit rate (say, a one-cent shift in the price of jet grout cement) can ripple through thousands of linked activities and reshape the forecast?

ANSWER

A seven-discipline Project Management Plan (Time, Cost, Contract, Quality, Safety, Risk, Communication), documented in 2005, established governance. A unified Master Coding System assigned a single alphanumeric ID to every activity, every cost line, and every quantity record so that Primavera, ERP, SAP, and the site's quantity surveys all spoke the same language. And an Integrated Cost Control System closed the loop: when a unit cost moved by one cent, the master code propagated the change through every linked activity, recomputed CPI, and re-derived the Estimated Cost at Completion (EAC = BAC / CPI). The 2006 CPI of 0.779 implied a forecast running 28% over baseline; one month later, with CPI at 1.317, the forecast tracked under baseline by 24%, a 52-percentage-point swing visible within thirty days of the discovery event.

PROGRAM SCALE & CONTROL CADENCE

Mega Metro Governance: At a Glance

7

PMP Discipline Areas, 2005

Time / Cost / Contract / Quality / Safety / Risk / Communication

5

Joint Venture Partners Coordinated

Yapi Merkezi · Dogus · Yuksel · Yenigun · Belen

53

Sheet Monthly Workbook, Single Source of Truth

Performance, financial, resource, and cash flow tabs

84

Months, Forward Cash Flow Horizon

January 2005 → December 2011

1 ID

Master Code Linking Primavera ↔ ERP/SAP ↔ Site

One activity, one cost line, one quantity record, one ID

DIFFERENTIATOR
12x/yr

CPI-Driven EAC Refresh, Every Month

April 2006 CPI 0.779 → May 2006 CPI 1.317 (52-pt swing in 30 days)

DIFFERENTIATOR
PRIMARY DIFFERENTIATOR #1

The Project Management Plan That Governed a Mega Metro Program

Documented on 2005, the Project Management Plan defined seven integrated discipline areas, designed to be realistic, monitorable, comprehensive, forward-looking, and crisis-capable from contract signing onward.

PLAN DESIGN CRITERIA
RealisticMonitorableComprehensiveForward-LookingCrisis-Capable
01

Time Management

Zaman Yonetimi

Work program preparation, resource allocation (labor / equipment / materials / subcontractors), payroll and equipment schedules, material procurement program, physical completion projection.

02

Cost Management

Maliyet Yonetimi

Budget preparation, production cost analysis, general overhead analysis, income-expense (profitability) analysis, financial completion projection.

03

Contract Management

Sozlesme Yonetimi

Red flag clauses, subcontractor contracts, administrative follow-up procedures, change order discipline.

04

Quality Management

Kalite Yonetimi

Quality approach and standards, quality control and inspection procedures, quality management plan tied to each work package.

05

Safety Management

Is Guvenligi Yonetimi

Site safety procedures and directives, safety inspection and oversight system, hazard escalation pathway.

06

Risk Management

Risk Yonetimi

Project risk analysis, risk responses (accept / mitigate / transfer), cost-impact quantification for each identified risk, contingency reserve linkage.

07

Communication Management

Iletisim Yonetimi

Organization structure, role and responsibility definitions, reporting matrix linking owner, JV, subcontractors, lenders, and consultants.

The PMP was not a document. It was a system.

The seven disciplines were operationalized through ERP, which managed the time and cost deliverables, and reinforced by the master coding architecture (Section 5) and the integrated cost control mechanism (Section 6). This is what 'integrated project management' actually looks like when it is built into the contract from Month 1, not bolted on after problems appear.

PRIMARY DIFFERENTIATOR #2

One Code. Three Systems. Zero Reconciliation.

The Master Coding System assigned a single alphanumeric ID to every schedule activity, every cost ledger entry, and every site quantity record. When any one of them moved, all three were synchronized, automatically.

ID: MTR-S03-EXC-JG-CEM-01MASTER CODE — single source of identity

SCHEDULE

Primavera

Activity duration, sequence, resource calendar

carries the master code
shared ID

COST LEDGER

ERP · SAP

Budget, committed, actual cost per code

earns value via the master code
shared ID

SITE QUANTITY

Take Off · Survey

Physical progress, installed quantity per code

validates the master code

Without a unified code...

Schedule progress is reconciled to cost actuals by hand, in Excel, days after the fact. Quantities are surveyed on site, copied into spreadsheets, and only weeks later flow into the cost report. CPI and SPI are calculated on stale data. EAC is an opinion, not an arithmetic result.

With the master coding system...

Every activity in Primavera, every cost line in ERP/SAP, and every quantity record in the site survey share the same alphanumeric ID. A change in any one input, a quantity, a rate, a duration, is aggregated upstream and propagated downstream automatically. CPI and SPI become arithmetic, not estimation.

And the cost forecast becomes...

A live function of three observable inputs (planned, earned, actual), refreshed at the cadence of the underlying data, not the patience of the analyst. The integrated cost control system (next section) runs on top of this foundation.

“Without a unified code, earned value is arithmetic. With it, earned value is forecasting.”

xPM Master Coding Principle

PRIMARY DIFFERENTIATOR #3

When a Unit Cost Moves by One Cent, the Forecast Moves the Same Day

Integrated cost control on Kadikoy-Kartal connected planning, execution, and forecasting through the master code, making the Estimated Cost at Completion a live function of every observable input on site.

LEVEL 01

Planning

PRE-EXECUTION
  • · Budget estimates derived from contract scope
  • · Unit cost database (labor, materials, equipment, specialist items)
  • · Cost breakdown by work package, location, resource type
  • · Contingency analysis tied to identified risks

BAC (Budget at Completion) is set here

EV / AC
LEVEL 02

Execution

MONTHLY MONITORING
  • · Actual cost tracking from purchase orders, timesheets, invoices
  • · Earned value calculation linking progress to budgeted cost
  • · Monthly variance analysis (EV · AC · PV)
  • · Master-code aggregation across the 53-sheet workbook

EV and AC are observed here

CPI
LEVEL 03

Forecasting

CPI-DRIVEN PROJECTION
  • · CPI (Cost Performance Index): efficiency metric
  • · EAC = BAC / CPI: projected final cost
  • · VAC = BAC - EAC: projected over/under at completion
  • · Cash flow forecast extended 12-24 months ahead

EAC is derived here, automatically

THE ONE-CENT CASCADE

What Happens When the Jet Grout Cement Unit Cost Changes by One Cent

INPUT

Jet grout cement unit price moves +1 cent per unit

Captured in ERP cost ledger against master code MTR-Sxx-EXC-JG-CEM

PROPAGATION

Master code aggregates new unit cost to ALL linked jet grout activities across every station

No human reconciliation. The code IS the link.

VARIANCE

Monthly AC for the jet grout work package recomputes → variance vs. EV updates

PM_Analizi sheet refresh, 53-sheet workbook auto-aggregates.

CPI

Cost Performance Index recomputes: CPI = EV / AC

At the work-package level AND at the rolled-up program level.

OUTPUT — EAC

Estimated Cost at Completion re-derived: EAC = BAC / CPI

Cash flow forecast through Dec 2011 is updated in the same pass.

DOCUMENTED EVIDENCE — APRIL → MAY 2006

BLACK STATUS

· SPI: 0.254 · schedule progress at 25% of plan

· CPI: 0.779 · cost efficiency below baseline

· Implied EAC: 28% over baseline

Crisis-level performance flagged within 30 days of the discovery event.

YELLOW STATUS — RECOVERY

· CPI: 1.317 · cost efficiency above baseline

· SPI: 0.678 · schedule still behind, but improving

· Implied EAC: 24% under baseline

52-percentage-point EAC swing in one month, the integrated control system at work.

The April-to-May swing was not noise. It was a contractual recognition event flowing through the master code: change orders posted against jet grout and excavation work packages, recomputed unit costs propagated to every linked activity, and the EAC re-derived from arithmetic, not opinion. Without the integrated system, this would have been a year-end surprise. With it, it was a 30-day decision cycle.

TECHNOLOGY & REPORTING STACK

The Tools That Operationalized the System

Each tool carried the master code. Each tool fed the others. None of them stood alone.

Primavera (P3 / P6)

Master schedule, activity sequence, duration, resource allocation

ERPMaster CodeMonthly Workbook

ERP

Time + cost integration, earned value engine; supports all PMP deliverables

PrimaveraSAPBI Reports

SAP ERP

Accounting actuals, invoices, supplier payments, subcontractor settlements

ERPMonthly Workbook

53-Sheet Monthly Workbook

Single source of truth: performance (EV/AC/PV/CPI/SPI), cash flow, resource, subcontractor status

All tools aboveSite surveys

5B-PYS Framework

Five-dimensional project supervision: the governance system that wraps all of the above

Master CodingPMPCost Control
53SHEETS

Per month, every month, for years.

WORKBOOK ANATOMY

[4]Core Report: Month selection · Cover · Contents · Project info

[4]Performance: PM_Analyze · PM_Graf · SPI · CPI

[7]Financial: GG yearly / Cumulative · Cash Flow Yearly / Cumulative Monthly Cash Flow

[7]Resources: Per.O · Per.List · Mec.-Equipment · Submittals

[~30]Detail / Admin: work package breakdowns, supporting calculations

Source: Metro_Aylik Faaliyet Raporu_[Month].xls, workbook covering Aug 2005 through May 2007+

WHAT THIS MEANS FOR YOUR PROGRAM

Mega Programs Deserve Forecasts You Can Defend in Front of a Board

Imagine knowing, on the first business day of every month, with verifiable arithmetic, what your mega program will cost at completion. Imagine being able to trace that forecast back to a single unit-rate movement on a single material at a single station. Imagine the day-one discovery event that would have been a year-end surprise becoming a 30-day decision cycle. That is the standard xPM established on Kadikoy-Kartal.

How 5B-PYS Works on Mega Programs

Coming soon

Discuss Your Program →

30-minute scoping call, no commitment

84-month forward cash flow horizon
Monthly EAC refresh via master code
EVM-grade CPI/SPI separation
Documented April → May 2006 recovery

Reference project: Kadikoy-Kartal Rayli Toplu Tasima Sistemi, T.C. Istanbul Buyuksehir Belediyesi / IETT, 2005-2011. Yapi Merkezi-Dogus-Yuksel-Yenigun-Belen JV.