cash flow portfolio

AWI 106 Att. 8 Rev. 2 06 Jul. 2009 Date/ Rev.

District Cooling Plant for Rihan Heights

Project Cash Flow Portfolio


Index Project Cash Flow

1 - Cash In Data --------------------------- Section 1

1.11 – Cash In-Value of Works & Monthly Invoices --------------------------- Section 1.11

1.12 – Cash In Histogram (EPC Project Period). --------------------------- Section 1.12

1.13 – Cash In Histogram (Operation and Maintenance Period). --------------------------- Section 1.13

2 - Cash Out Data --------------------------- Section 2

2.11 – Cash Out-Value of Works & Monthly Invoices --------------------------- Section 2.11

2.12 – Cash Out Histogram (EPC Project Period). --------------------------- Section 2.12

2.13 – Cash Out Histogram (Operation and Maintenance Period). -------------- Section 2.13

3 - Cash Flow ----------------------- Section 3

3.11 – Project Cash Flow Curve. --------------------------- Section 3.11

3.12 – Project Cash Liquidity. --------------------------- Section 3.12


Section 1

Cash In Data


Section 1.11

Cash In-Value of Works & Monthly Invoices

Jul-10 Aug-10 Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12

Item No. Description Value of

Work 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

A Preliminaries- Design - Procurement-Construction - Testing & Commissioning 49,055,575

A.1 Preliminaries (See Attachment.1) 7,663,699 29.36% 4.38% 5.71% 7.54% 8.68% 10.01% 14.72% 11.87% 7.74%

A.2 Design (See Attachment.2) 1,452,016 50.00% 50.00%

A.3 Procurement (See Attachment.2) 31,210,488 9.45% 4.39% 7.19% 1.04% 18.02% 27.81% 16.05% 16.05%

A.4 Construction (See Attachment.2) 8,487,050 0.81% 3.75% 8.86% 11.91% 10.51% 25.44% 36.32% 2.40%

A.5 Testing & Commissioning (See Attachment.2) 242,322 36.98% 51.05% 11.96%

B Temporary Generator 2,504,439

B.1 Mobilization Charge 50,323 100.00%

B.2 Monthly Charge 2,080,224 8.37% 8.33% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%

B.3 Demobilization Charge 35,223 100%

B.4 Generator Installation Charge 338,669 100.00%

C Operation and Maintenance 1,606,003

C.1 Operation & Maintenance for 12 motnhs after commissioing 1,606,003 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%

SUBTOTAL 53,166,017 5,924,236 2,500,867 2,999,945 1,655,753 7,298,559 10,336,991 8,775,786 9,300,088 999,740 307,384 307,384 307,063 307,063 307,063 307,063 307,063 307,063 307,063 342,286 133,780 133,780

53,166,017 - - 5,924,236 2,500,867 2,999,945 1,655,753 7,298,559 10,336,991 8,775,786 9,300,088 999,740 307,384 307,384 307,063 307,063 307,063 307,063 307,063 307,063 307,063 342,286 133,780 133,780

- - 5,924,236 8,425,102 11,425,048 13,080,801 20,379,360 30,716,351 39,492,137 48,792,225 49,791,964 50,099,348 50,406,732 50,713,795 51,020,858 51,327,920 51,634,983 51,942,046 52,249,108 52,556,171 52,898,457 53,032,237 53,166,017

Planned Percent. 11.14% 15.85% 21.49% 24.60% 38.33% 57.77% 74.28% 91.77% 93.65% 94.23% 94.81% 95.39% 95.97% 96.54% 97.12% 97.70% 98.28% 98.85% 99.50% 99.75% 100.00%

Mubadala Capitaland Real Estate District Cooling Plant for Rihan Heights

Cash In Value of Works

Plan. Value of Work - Month

Plan. Value of Work - Cumulative

File Name:Cash Flow Page 1 of 2 Printed On:10/20/10 at 1:06 PM

Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun

Item No. Description Value 1 2 3 4 5 6 7 8 9 10 11

A PRELIMINARIES 7,648,386A.1 Contractual requirements 1,160,988

A.1.1 Insurance 349,273 100%A.1.2 Contract Price and Payment 546,973 100%A.1.3 Enviromental Assessment 33,000 100%A.1.4 Defect Liability maintenance 231,742 100%

A.2 Services for the Employer's 78,981 A.2.1 Progress Photos 770 100%A.2.2 Sanitary 78,211 100%

A.3 Temporary Works 20,700 A.3.1 Gates 4,400 100%A.3.2 Fire Protection 6,204 11% 11% 11% 11% 11% 11% 11% 11% 11%A.3.3 Safety 10,096 11% 11% 11% 11% 11% 11% 11% 11% 11%

A.4 Contractor Facilities 1,154,071 A.4.1 Facilities Required by Contractor 1,154,071 90% 1% 1% 1% 1% 1% 1% 1% 3%

A.5 Services for the contractor 393,049 A.5.1 Transport of workforce 393,049 11% 11% 11% 11% 11% 11% 11% 11% 11%

A.6 Plant for permanent works (not included in construction works) 218,244

A.6.1 Small plant and tools. 3,494 11% 11% 11% 11% 11% 11% 11% 11% 11%A.6.2 Scaffolding. 20,173 14% 14% 14% 14% 14% 14% 14%A.6.3 Cranes and lifting plant. 194,577 14% 14% 14% 14% 14% 14% 14%

A.7 Supervision and Labour 4,622,353 A.7.1 Manual Manpower 2,909,987 3% 6% 11% 14% 17% 27% 19% 3%A.7.2 Non Mnaual Manpower 1,712,366 10% 10% 10% 10% 10% 10% 15% 15% 10%

A.8 SurveysA.8.1 Topoghrapic Survey 3,123 100%A.8.2 Geotechnical Investigation 12,190 100%

SUBTOTAL 7,663,699 2,249,979 335,733 437,314 578,047 664,985 766,940 1,127,722 909,563 593,417

Plan. Value of Work - Month 7,663,699 - 2,249,979 335,733 437,314 578,047 664,985 766,940 1,127,722 909,563 593,417 -

Plan. Value of Work - Cumulative - 2,249,979 2,585,712 3,023,026 3,601,073 4,266,058 5,032,998 6,160,719 7,070,282 7,663,699 -

Planned Percent. 29.36% 33.74% 39.45% 46.99% 55.67% 65.67% 80.39% 92.26% 100.00%


Preliminaries (Attachement.1)

Activity Name Start Finish Budgeted Cost BudgetedU

Jul Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun2010 2011

District Cooling Plant for Rihan Heights 05-Aug-10 12-May-11 49,055,575 15313 5908923 2500867 2999945 1655753 7298559 10336991 8386793 9125973 826457Cash Flow 05-Aug-10 12-May-11 49,055,575 15313 5908923 2500867 2999945 1655753 7298559 10336991 8386793 9125973 826457

District Cooling Plant for Rihan Heights 05-Aug-10 12-May-11 49,055,575 15313 5908923 2500867 2999945 1655753 7298559 10336991 8386793 9125973 826457General 05-Aug-10 12-May-11 7,663,699 15313 2234666 335733 437314 578047 664985 766940 1127722 909563 593417

Mobilization 05-Aug-10 12-May-11 7,663,699 15313 2234666 335733 437314 578047 664985 766940 1127722 909563 593417Soil Investigation 05-Aug-10 16-Aug-10 15,313 15313

Topographic Survey 05-Aug-10 08-Aug-10 3,123 3123Geo Technical Investigation Report 14-Aug-10 16-Aug-10 12,190 12190

Site Offices & Utilities 01-Sep-10 12-May-11 7,648,386 2234666 335733 437314 578047 664985 766940 1127722 909563 593417Preliminaries 01-Sep-10 12-May-11 7,648,386 2234666 335733 437314 578047 664985 766940 1127722 909563 593417

Design and Engineering 01-Sep-10 14-Oct-10 1,452,016 726008 726008Design 01-Sep-10 14-Oct-10 1,452,016 726008 726008

Concept & Schematic Design 01-Sep-10 01-Sep-10 726,008 726008Process Equipm ents 01-Sep-10 01-Sep-10 726,008 726008

Approve Concept & Schematic Design by Capitala 01-Sep-10 01-Sep-10 726,008 726008Detailed Design 02-Oct-10 14-Oct-10 726,008 726008

Process Equipm ents 02-Oct-10 14-Oct-10 726,008 726008Capitala Approve Detailed Engineering Package 02-Oct-10 14-Oct-10 726,008 726008

Procurement 29-Sep-10 02-Apr-11 31,210,488 2948249 1370194 2244708 325602 5622982 8678142 5010306 5010306Mechanical 29-Sep-10 02-Apr-11 21,892,623 2948249 2244708 325602 2807300 3546152 5010306 5010306

Procurement & Delivery 29-Sep-10 02-Apr-11 21,892,623 2948249 2244708 325602 2807300 3546152 5010306 5010306Plant Module Material 29-Sep-10 02-Apr-11 20,839,464 2948249 2244708 325602 2754642 2545652 5010306 5010306

Process Equipm ents 29-Sep-10 02-Apr-11 14,741,247 2948249 886193 886193 5010306 5010306Procurement&Delivery of Chil lers and Module Enclosure 30-Sep-10 02-Apr-11 10,020,611 2004122 4008245 4008245Procurement&Delivery of Chil led Water Pump 30-Sep-10 02-Apr-11 2,505,153 501031 1002061 1002061Delivery of Cooling Tower 29-Sep-10 04-Feb-11 2,215,482 443096 886193 886193

Pipes & Valves 01-Nov-10 28-Feb-11 2,713,346 1953609 325602 434135Chilled&Condenser System 01-Nov-10 28-Feb-11 2,713,346 1953609 325602 434135

Procurement&Delivery of Chilled&Condeser Water Pipes 18-Dec-10 18-Dec-10 325,602 325602Procurement&Delivery of Chilled Water Reticulation Polyethylene Pipes 01-Nov-10 07-Nov-10 1,953,609 1953609Procurement&Delivery of Chil led Water (Valves-Accessories-Fittings) 16-Feb-11 28-Feb-11 298,468 298468Procurement&Delivery of Buterflly Valves 16-Feb-11 28-Feb-11 135,667 135667

Heat Exchanger 08-Nov-10 16-Feb-11 3,384,872 291099 1868449 1225324Procurement&Delivery of Heat Exchangers 08-Nov-10 16-Feb-11 1,455,495 291099 582198 582198Procurement&Delivery of Heat Exchanger Valves 16-Feb-11 16-Feb-11 643,126 643126Procurement&Delivery of Heat Exchanger Pipes 16-Jan-11 17-Jan-11 1,286,251 1286251

Building Services Materials 16-Jan-11 21-Feb-11 1,053,158 52658 1000500Fire Fighting 16-Jan-11 21-Feb-11 1,053,158 52658 1000500

Procurement&Delivery of Fire System (FM200 or Pre-Action) 16-Feb-11 21-Feb-11 947,843 947843Procurement&Delivery of Fire Sprinklers 16-Feb-11 21-Feb-11 52,658 52658Procurement&Delivery of Fire Pipes 16-Jan-11 16-Jan-11 52,658 52658

Electrical 20-Oct-10 28-Feb-11 9,317,866 1370194 2815682 5131990Procurement & Delivery 20-Oct-10 28-Feb-11 9,317,866 1370194 2815682 5131990

Plant Module Materials 20-Oct-10 28-Feb-11 9,317,866 1370194 2815682 5131990Process Equipm ents 20-Oct-10 28-Feb-11 8,614,975 1370194 2740388 4504393

Procurement&Delivery of SCADA System 26-Feb-11 28-Feb-11 1,764,005 1764005Procurement&Delivery of Electrical Module Enclosure (LV-MV) 20-Oct-10 23-Feb-11 6,850,970 1370194 2740388 2740388

Transformers 01-Feb-11 15-Feb-11 627,597 627597Procurement&Delivery of 11 KV Transformers (Dry Type) 01-Feb-11 15-Feb-11 627,597 627597

Others 16-Jan-11 23-Jan-11 75,294 75294Procurement&Delivery of UPS 16-Jan-11 23-Jan-11 75,294 75294

Construction 23-Oct-10 12-May-11 8,487,050 68932 317923 752104 1010593 891909 2159155 3082388 204047District Cooling Modular Plant 23-Oct-10 09-May-11 4,589,366 32655 100008 255298 192248 212353 1146293 2501219 149291

Civil 23-Oct-10 10-Mar-11 656,575 32655 100008 255298 182945 47669 38000Cooling Tower Module 23-Oct-10 09-Jan-11 521,502 20130 100008 255298 146066

Foundation Level 23-Oct-10 08-Dec-10 168,928 20130 100008 48791Earth Work 23-Oct-10 21-Nov-10 74,909 20130 54779

Waterproofing Sheet & Screed over 13-Nov-10 21-Nov-10 31,843 31843Installation of Dewatering System Equipment 26-Oct-10 28-Oct-10 6,710 6710Initial Excavation 23-Oct-10 25-Oct-10 6,710 6710Formation and Blinding 07-Nov-10 11-Nov-10 11,752 11752Excavation 02-Nov-10 06-Nov-10 8,947 8947Draw down the Underground Water 29-Oct-10 01-Nov-10 8,947 6710 2237

Foundations 22-Nov-10 08-Dec-10 94,020 45229 48791Steel Fixing 22-Nov-10 05-Dec-10 35,257 25642 9616Form Work 25-Nov-10 06-Dec-10 35,257 19587 15670Concrete Pouring 08-Dec-10 08-Dec-10 23,505 23505

Ground Floor 09-Dec-10 09-Jan-11 352,574 206508 146066Walls 09-Dec-10 23-Dec-10 176,287 176287

Steel Fixing of Tank Walls 09-Dec-10 15-Dec-10 70,515 70515Form Work of Tank Walls 13-Dec-10 22-Dec-10 70,515 70515Concrete Pouring 23-Dec-10 23-Dec-10 35,257 35257

Slab 28-Dec-10 09-Jan-11 176,287 30221 146066Steel Fixing of Tank Slab 02-Jan-11 08-Jan-11 70,515 70515Form Work of Tank Slab 28-Dec-10 05-Jan-11 70,515 30221 40294Concrete Pouring 09-Jan-11 09-Jan-11 35,257 35257

LV Switchgear Module 23-Oct-10 06-Feb-11 67,536 6263 36878 24395Foundation Level 23-Oct-10 06-Feb-11 67,536 6263 36878 24395

Earth Work 23-Oct-10 22-Jan-11 20,526 6263 14264Waterproofing Sheet & Screed over 16-Jan-11 22-Jan-11 8,388 8388Formation and Blinding 10-Jan-11 15-Jan-11 5,876 5876Excavation 23-Oct-10 30-Oct-10 6,263 6263

Foundations 23-Jan-11 06-Feb-11 47,010 22615 24395Steel Fixing 23-Jan-11 03-Feb-11 17,629 12821 4808Form Work 26-Jan-11 05-Feb-11 17,629 9794 7835Concrete Pouring 06-Feb-11 06-Feb-11 11,752 11752

Chiller Module 23-Oct-10 10-Mar-11 67,536 6263 23274 38000Foundation Level 23-Oct-10 10-Mar-11 67,536 6263 23274 38000

Earth Work 23-Oct-10 23-Feb-11 20,526 6263 14264


Data Date : 18-Jul-10 Page : 1 of 8Printed On : 22-Sep-10

Project Implementation ScheduleValue of Work in Dirhams (Attachment .2)

Date Revision Checked Approved15-Aug-10 Project Implementation Schedule Rev.0021-Sep-10 Project Implementation Schedule Rev.01



Waterproofing Sheet & Screed over 16-Feb-11 23-Feb-11 8,388 8388Formation and Blinding 07-Feb-11 14-Feb-11 5,876 5876Excavation 23-Oct-10 30-Oct-10 6,263 6263

Foundations 24-Feb-11 10-Mar-11 47,010 9010 38000Steel Fixing 24-Feb-11 07-Mar-11 17,629 7051 10577Form Work 28-Feb-11 09-Mar-11 17,629 1959 15670Concrete Pouring 10-Mar-11 10-Mar-11 11,752 11752

Architectural 27-Jan-11 25-Apr-11 174,405 9303 53494 62780 48829Make Up Water Tank 27-Jan-11 26-Feb-11 58,147 9303 48843

GRP Lining for Make Up Water Tank 27-Jan-11 26-Feb-11 58,147 9303 48843Blow Down 27-Feb-11 27-Mar-11 58,129 4650 53479

GRP Lining for Blow Down 27-Feb-11 27-Mar-11 58,129 4650 53479FireTank 28-Mar-11 25-Apr-11 58,129 9301 48829

GRP Lining for Fire Tank 28-Mar-11 25-Apr-11 58,129 9301 48829Mechanical 05-Feb-11 07-May-11 1,923,871 21406 169441 1660908 72117

Cooling Tower Module 05-Feb-11 23-Apr-11 246,165 21406 37674 187085Install Cooling Tower Components (FRP) 05-Feb-11 30-Mar-11 49,233 21406 27827Install Cooling Tower 31-Mar-11 23-Apr-11 196,932 9847 187085

Chiller Module 03-Apr-11 23-Apr-11 362,588 362588Install Chiller Module Enclosure 13-Apr-11 23-Apr-11 296,663 296663Install Chiller Module Base Frame 03-Apr-11 12-Apr-11 65,925 65925

Chilled Water Pumps 03-Apr-11 11-Apr-11 296,663 296663Install Chilled Water Pump 03-Apr-11 11-Apr-11 296,663 296663

Make Up Water Pump 13-Mar-11 28-Mar-11 115,271 115271Install Make Up Water Pump 24-Mar-11 28-Mar-11 44,351 44351Install Make Up Water Pipes & Access. 13-Mar-11 23-Mar-11 70,920 70920

Blow Down Pump 01-Mar-11 12-Mar-11 16,496 16496Install Blow Down Water Pipes & Access. 01-Mar-11 12-Mar-11 16,496 16496

Other Systems 05-Apr-11 07-May-11 886,689 814572 72117Install the Process Instrument 24-Apr-11 07-May-11 144,233 72116 72117Install Expansion Tank-Outside the Modular 05-Apr-11 12-Apr-11 38,440 38440Install Chemical Water Treatment-Outside the Modular 14-Apr-11 21-Apr-11 510,697 510697Install Air Seperator 05-Apr-11 12-Apr-11 193,319 193319

Electrical 24-Feb-11 09-May-11 1,834,515 89785 876073 791482 77175Attendance and Coordination by ADWEA 24-Feb-11 01-May-11 39,732 2788 18820 17426 697MV & LV Switchgear Module Foundation 24-Feb-11 10-Apr-11 761,219 86996 587226 86996

Install MV Switch gear 26-Mar-11 10-Apr-11 152,244 65247 86996Install Electrical Module Enclosure (LV) 13-Mar-11 28-Mar-11 304,488 304488Install Electrical Module Base Frame (LV) 24-Feb-11 12-Mar-11 304,488 86996 217491

Transformers 19-Mar-11 04-Apr-11 69,733 55786 13947Install Transformers 19-Mar-11 04-Apr-11 69,733 55786 13947

Cables Works 03-Mar-11 09-May-11 870,015 214240 632906 22868Excavation 12-Mar-11 16-Mar-11 16,850 16850

Excavation Cable Trenches 12-Mar-11 16-Mar-11 16,850 16850Cable Trays 03-Mar-11 19-Mar-11 67,401 67401

Cable Trays at Transformer Room 03-Mar-11 07-Mar-11 25,276 25276Cable Trays at Pump Room 14-Mar-11 19-Mar-11 16,850 16850Cable Trays at ADDC Room 08-Mar-11 13-Mar-11 25,276 25276

Cables 16-Mar-11 09-May-11 785,763 129988 632906 22868MV Cables 30-Mar-11 01-May-11 252,755 19258 231091 2407

From ADDC Intake to 11 KV Switchgear 07-Apr-11 12-Apr-11 84,252 84252MV Cable Termination for 11 KV Switch gear 11-Apr-11 12-Apr-11 16,850 16850MV Cable Laying 07-Apr-11 10-Apr-11 67,401 67401

From 11 KV Switchgear to Chiller Soft Starter 30-Mar-11 01-May-11 84,252 19258 62587 2407MV Cable Termination for Chiller Soft Starter 24-Apr-11 01-May-11 16,850 14443 2407MV Cable Laying 30-Mar-11 06-Apr-11 67,401 19258 48144

From 11 KV Switchgear to Transformer 11-Apr-11 14-Apr-11 84,252 84252MV Cable Termination for Transformer 13-Apr-11 14-Apr-11 16,850 16850MV Cable Laying 11-Apr-11 12-Apr-11 67,401 67401

LV Cables 24-Mar-11 03-May-11 252,755 96288 149246 7222From Transformer to LV Switchgear 24-Mar-11 20-Apr-11 84,252 67401 16850

LV Cable Termination for LV Switch gear 05-Apr-11 20-Apr-11 16,850 16850LV Cable Laying 24-Mar-11 28-Mar-11 67,401 67401

From LV Switchgear to Starter or VFD of Pump 29-Mar-11 03-May-11 84,252 28886 48144 7222LV Cable Termination for Starter or VFD of Pumps 26-Apr-11 03-May-11 16,850 9629 7222LV Cable Laying 29-Mar-11 05-Apr-11 67,401 28886 38515

From LV Switchgear to Distribution Board 06-Apr-11 25-Apr-11 84,252 84252LV Cable Termination for Distribution Board 21-Apr-11 25-Apr-11 16,850 16850LV Cable Laying 06-Apr-11 10-Apr-11 67,401 67401

Control & Fibre Optic Cables 16-Mar-11 09-May-11 280,252 14443 252570 13240Fibre Optic Cables 10-Apr-11 08-May-11 238,126 229701 8425

Installation of Control System 14-Apr-11 30-Apr-11 196,001 196001Fibre Optic Cable Termination 01-May-11 08-May-11 8,425 8425Fibre Optic Cable Laying Inside Control Room 10-Apr-11 13-Apr-11 33,701 33701

Control Cables 16-Mar-11 09-May-11 42,126 14443 22868 4814Control Cable Termination for Control Cables 24-Apr-11 09-May-11 8,425 3611 4814Control Cable Laying Outside Control Room 16-Mar-11 09-Apr-11 16,850 11234 5617Control Cable Laying Inside Control Room 28-Mar-11 20-Apr-11 16,850 3210 13641

Earthing System 24-Apr-11 09-May-11 93,816 40207 53609Installation of Earthing System 24-Apr-11 09-May-11 93,816 40207 53609

Ancillary Building 23-Oct-10 12-May-11 1,574,202 36277 78773 139081 240926 264970 450785 308634 54756Civil 23-Oct-10 17-Feb-11 641,962 36277 78773 139081 240926 146906

Foundation Level 23-Oct-10 23-Dec-10 207,121 36277 78773 92071Earth Work 23-Oct-10 08-Nov-10 65,287 36277 29010

Waterproofing Sheet & Screed over 03-Nov-10 08-Nov-10 24,309 24309Formation and Blinding 28-Oct-10 02-Nov-10 11,752 7051 4701Excavation 23-Oct-10 27-Oct-10 29,225 29225

Foundations 09-Nov-10 23-Dec-10 141,834 49763 92071Water Proofing & Backfilling up to Slab on Grade Level 16-Dec-10 18-Dec-10 9,804 9804







Water Proofing & Backfilling up to Grid Beam Level 28-Nov-10 29-Nov-10 9,804 9804Steel Fixing of Tie Beams 12-Dec-10 14-Dec-10 14,103 14103Steel Fixing of Nick Columns&Trenches 30-Nov-10 05-Dec-10 14,103 3526 10577Steel Fixing of Footings 13-Nov-10 25-Nov-10 14,103 14103Form Work of Tie Beams 09-Dec-10 13-Dec-10 14,103 14103Form Work of Nick Columns&Trenches 04-Dec-10 06-Dec-10 14,103 14103Form Work of Footings 09-Nov-10 22-Nov-10 14,103 14103Concrete Pouring of Tie Beams 15-Dec-10 15-Dec-10 8,227 8227Concrete Pouring of Slab on Grade 19-Dec-10 23-Dec-10 12,928 12928Concrete Pouring of Nick Columns&Trenches 08-Dec-10 08-Dec-10 8,227 8227Concrete Pouring of Footings 27-Nov-10 27-Nov-10 8,227 8227

Ground Floor 25-Dec-10 08-Feb-11 188,040 47010 129277 11752Steel Fixing of Slab 10-Jan-11 13-Jan-11 47,010 47010Steel Fixing of Columns 25-Dec-10 27-Dec-10 23,505 23505R.C Plinths for Process Equipment 03-Feb-11 08-Feb-11 11,752 11752MEP Works Inside Slab 10-Jan-11 12-Jan-11 11,752 11752Form Work of Slab 05-Jan-11 09-Jan-11 47,010 47010Form Work of Columns 28-Dec-10 30-Dec-10 23,505 23505Concrete Pouring of Slab 15-Jan-11 15-Jan-11 11,752 11752Concrete Pouring of Columns 02-Jan-11 02-Jan-11 11,752 11752

First Floor 16-Jan-11 06-Feb-11 188,040 111648 76391Steel Fixing of Slab 01-Feb-11 05-Feb-11 52,886 52886Steel Fixing of Columns 16-Jan-11 18-Jan-11 23,505 23505MEP Works Inside Slab 02-Feb-11 05-Feb-11 11,752 11752Form Work of Slab 26-Jan-11 31-Jan-11 52,886 52886Form Work of Columns 18-Jan-11 20-Jan-11 23,505 23505Concrete Pouring of Slab 06-Feb-11 06-Feb-11 11,752 11752Concrete Pouring of Columns 22-Jan-11 22-Jan-11 11,752 11752

Roof Level 07-Feb-11 17-Feb-11 58,762 58762Steel Fixing of Parapits 07-Feb-11 13-Feb-11 23,505 23505Form Work of Parapets 10-Feb-11 16-Feb-11 23,505 23505Concrete Pouring of Parapets 17-Feb-11 17-Feb-11 11,752 11752

Architectural 09-Feb-11 12-May-11 466,727 77317 197655 162238 29517Ground Floor 09-Feb-11 07-May-11 182,934 54215 124552 1018 3148

ADDC Intake Room 09-Feb-11 04-May-11 61,196 20063 39285 1848Plaster Works 01-Mar-11 07-Mar-11 3,698 3698Install Windows and Doors Works 26-Mar-11 27-Mar-11 30,040 30040Install Windows & Doors Frames 23-Feb-11 24-Feb-11 3,338 3338Final Paint Coat Works 02-May-11 04-May-11 1,848 1848Epoxy Coating 14-Mar-11 17-Mar-11 3,698 3698Blocks Works 09-Feb-11 21-Feb-11 16,725 16725Base Paint Coat Works 21-Mar-11 23-Mar-11 1,848 1848

Pumps Room 22-Feb-11 01-May-11 45,689 11179 32984 1018 509Plaster Works 09-Mar-11 13-Mar-11 3,055 3055Install Windows and Doors Works 30-Mar-11 31-Mar-11 25,347 25347Install Windows & Doors Frames 27-Feb-11 28-Feb-11 2,816 2816Final Paint Coat Works 28-Apr-11 01-May-11 1,527 1018 509Epoxy Coating 20-Mar-11 23-Mar-11 3,055 3055Blocks Works 22-Feb-11 26-Feb-11 8,362 8362Base Paint Coat Works 27-Mar-11 29-Mar-11 1,527 1527

Transformers Room 09-Feb-11 07-May-11 76,049 22974 52284 791Plaster Works 27-Feb-11 02-Mar-11 1,583 792 792Install Windows and Doors Works 19-Mar-11 20-Mar-11 49,117 49117Install Windows & Doors Frames 23-Feb-11 24-Feb-11 5,457 5457Final Paint Coat Works 04-May-11 07-May-11 791 791Epoxy Coating 08-Mar-11 12-Mar-11 1,583 1583Blocks Works 09-Feb-11 16-Feb-11 16,725 16725Base Paint Coat Works 15-Mar-11 17-Mar-11 791 791

First Floor 26-Feb-11 12-May-11 249,296 5854 55854 161220 26369Office 05-Mar-11 22-Apr-11 128,566 21163 107404

Plaster Works 22-Mar-11 26-Mar-11 3,829 3829Install Windows and Doors 09-Apr-11 09-Apr-11 11,876 11876Install Windows & Doors Frames 14-Mar-11 15-Mar-11 1,320 1320Install Furniture 21-Apr-11 22-Apr-11 88,349 88349Install False Ceiling Tiles 10-Apr-11 11-Apr-11 1,914 1914Install False Ceiling Frames 05-Apr-11 07-Apr-11 1,914 1914Floor Tiles 27-Mar-11 30-Mar-11 3,829 3829Final Paint Coat Works 18-Apr-11 20-Apr-11 1,914 1914Blocks Works 05-Mar-11 10-Mar-11 11,707 11707Base Paint Coat Works 31-Mar-11 04-Apr-11 1,914 479 1436

Control Room 26-Feb-11 12-May-11 27,570 5854 11578 9153 985Plaster Works 14-Mar-11 17-Mar-11 1,971 1971Install Windows and Doors 27-Apr-11 28-Apr-11 7,183 7183Install Windows & Doors Frames 07-Mar-11 08-Mar-11 798 798Install False Ceiling Tiles 25-Apr-11 26-Apr-11 985 985Install False Ceiling Frames 21-Apr-11 24-Apr-11 985 985Floor Tiles 19-Mar-11 22-Mar-11 1,971 1971Final Paint Coat Works 10-May-11 12-May-11 985 985Blocks Works 26-Feb-11 03-Mar-11 11,707 5854 5854Base Paint Coat Works 23-Mar-11 27-Mar-11 985 985

Toilets 12-Mar-11 17-Apr-11 11,889 5005 6884Waterproofing Membrane for Toi let 26-Mar-11 26-Mar-11 671 671Install Windows and Doors 10-Apr-11 11-Apr-11 5,263 5263Install Windows & Doors Frames 15-Mar-11 16-Mar-11 585 585Install Toilet Accessories 14-Apr-11 17-Apr-11 405 405Install False Ceiling Tiles 12-Apr-11 13-Apr-11 405 405Install False Ceiling Frames 09-Apr-11 09-Apr-11 405 405Floor & Wall Tiles 31-Mar-11 02-Apr-11 810 405 405Blocks Works 12-Mar-11 14-Mar-11 3,345 3345







Kitchen 15-Mar-11 03-May-11 30,568 4600 8641 17327Waterproofing Membrane for Kitchen 30-Mar-11 30-Mar-11 671 671Install Windows and Doors 13-Apr-11 14-Apr-11 5,263 5263Install Windows & Doors Frames 19-Mar-11 20-Mar-11 585 585Install Kitchen Equipment 02-May-11 03-May-11 17,327 17327Install False Ceiling Tiles 16-Apr-11 16-Apr-11 845 845Install False Ceiling Frames 10-Apr-11 12-Apr-11 845 845Floor & Wall Tiles 03-Apr-11 04-Apr-11 1,689 1689Blocks Works 15-Mar-11 17-Mar-11 3,345 3345

Mess Room 19-Mar-11 07-May-11 18,038 8947 8613 479Plaster Works 04-Apr-11 07-Apr-11 957 957Install Windows and Doors 21-Apr-11 23-Apr-11 5,263 5263Install Windows & Doors Frames 24-Mar-11 26-Mar-11 585 585Install False Ceiling Tiles 24-Apr-11 25-Apr-11 479 479Install False Ceiling Frames 18-Apr-11 20-Apr-11 479 479Floor Tiles 09-Apr-11 12-Apr-11 957 957Final Paint Coat Works 04-May-11 07-May-11 479 479Blocks Works 19-Mar-11 23-Mar-11 8,362 8362Base Paint Coat Works 13-Apr-11 17-Apr-11 479 479

Store 24-Mar-11 12-May-11 32,664 4560 20526 7578Plaster Works 09-Apr-11 12-Apr-11 2,740 2740Install Windows and Doors 26-Apr-11 27-Apr-11 10,938 10938Install Windows & Doors Frames 30-Mar-11 31-Mar-11 1,215 1215Install Sinage 08-May-11 12-May-11 6,208 6208Install False Ceiling Tiles 28-Apr-11 30-Apr-11 1,370 1370Install False Ceiling Frames 23-Apr-11 25-Apr-11 1,370 1370Floor Tiles 13-Apr-11 17-Apr-11 2,740 2740Final Paint Coat Works 08-May-11 10-May-11 1,370 1370Blocks Works 24-Mar-11 29-Mar-11 3,345 3345Base Paint Coat Works 18-Apr-11 21-Apr-11 1,370 1370

Roof Level 27-Feb-11 02-Mar-11 34,497 17249 17249Primer and Membrane 27-Feb-11 02-Mar-11 34,497 17249 17249

Mechanical 27-Feb-11 07-May-11 388,617 35823 224410 108782 19601Ground Floor 27-Feb-11 03-May-11 160,836 35823 55884 65379 3750

ADDC Intake Room 28-Mar-11 18-Apr-11 41,361 20060 21301Fire Fighting 28-Mar-11 04-Apr-11 35,105 20060 15045

Install Fire System (FM200 or Pre-Action) 28-Mar-11 04-Apr-11 35,105 20060 15045HVAC 13-Apr-11 18-Apr-11 6,256 6256

Install Split Unit 13-Apr-11 18-Apr-11 6,256 6256Pumps Room 27-Feb-11 27-Apr-11 78,120 35823 35823 6473

Fire Fighting 19-Apr-11 21-Apr-11 223 223Install Extinguishers 19-Apr-11 21-Apr-11 223 223

HVAC 23-Apr-11 27-Apr-11 6,250 6250Install Ventilation 23-Apr-11 27-Apr-11 6,250 6250

Plumbing 27-Feb-11 02-Mar-11 71,647 35823 35823Install Water Supply System Pipes with Fittings 27-Feb-11 02-Mar-11 27,530 13765 13765Install Drain Pipes System Pipes with Fittings 27-Feb-11 02-Mar-11 44,117 22059 22059

Transformers Room 05-Apr-11 03-May-11 41,355 37605 3750Fire Fighting 05-Apr-11 12-Apr-11 35,105 35105

Install Fire System (FM200 or Pre-Action) 05-Apr-11 12-Apr-11 35,105 35105HVAC 28-Apr-11 03-May-11 6,250 2500 3750

Install Ventilation 28-Apr-11 03-May-11 6,250 2500 3750First Floor 12-Mar-11 07-May-11 227,781 168527 43403 15851

Office 12-Mar-11 17-Apr-11 15,611 7021 8590Fire Fighting 12-Mar-11 13-Apr-11 9,361 7021 2340

Install Fire Sprinkler 12-Apr-11 13-Apr-11 2,340 2340Install Fire Pipes 12-Mar-11 16-Mar-11 7,021 7021

HVAC 12-Apr-11 17-Apr-11 6,250 6250Install Split Unit 12-Apr-11 17-Apr-11 6,250 6250

Control Room 17-Mar-11 02-May-11 15,611 7021 6090 2500Fire Fighting 17-Mar-11 28-Apr-11 9,361 7021 2340

Install Fire Sprinkler 27-Apr-11 28-Apr-11 2,340 2340Install Fire Pipes 17-Mar-11 22-Mar-11 7,021 7021

HVAC 27-Apr-11 02-May-11 6,250 3750 2500Install Split Unit 27-Apr-11 02-May-11 6,250 3750 2500

Toilets 15-Mar-11 25-Apr-11 78,098 71626 6473Fire Fighting 23-Apr-11 25-Apr-11 223 223

Install Extinguishers 23-Apr-11 25-Apr-11 223 223HVAC 14-Apr-11 19-Apr-11 6,250 6250

Install Ventilation 14-Apr-11 19-Apr-11 6,250 6250Plumbing 15-Mar-11 19-Mar-11 71,626 71626

Install Water Supply System Pipes with Fittings 15-Mar-11 19-Mar-11 27,521 27521Install Drain Pipes System Pipes with Fittings 15-Mar-11 19-Mar-11 44,104 44104

Kitchen 20-Mar-11 01-May-11 87,237 78647 7420 1170Fire Fighting 23-Mar-11 01-May-11 9,361 7021 1170 1170

Install Fire Sprinkler 30-Apr-11 01-May-11 2,340 1170 1170Install Fire Pipes 23-Mar-11 28-Mar-11 7,021 7021

HVAC 17-Apr-11 21-Apr-11 6,250 6250Install Split Unit 17-Apr-11 21-Apr-11 6,250 6250

Plumbing 20-Mar-11 23-Mar-11 71,626 71626Install Water Supply System Pipes with Fittings 20-Mar-11 23-Mar-11 27,521 27521Install Drain Pipes System Pipes with Fittings 20-Mar-11 23-Mar-11 44,104 44104

Mess Room 29-Mar-11 03-May-11 15,611 4213 7808 3590Fire Fighting 29-Mar-11 03-May-11 9,361 4213 2808 2340

Install Fire Sprinkler 02-May-11 03-May-11 2,340 2340Install Fire Pipes 29-Mar-11 03-Apr-11 7,021 4213 2808

HVAC 26-Apr-11 01-May-11 6,250 5000 1250Install Split Unit 26-Apr-11 01-May-11 6,250 5000 1250

Store 04-Apr-11 07-May-11 15,611 7021 8590







Fire Fighting 04-Apr-11 05-May-11 9,361 7021 2340Install Fire Sprinkler 04-May-11 05-May-11 2,340 2340Install Fire Pipes 04-Apr-11 09-Apr-11 7,021 7021

HVAC 02-May-11 07-May-11 6,250 6250Install Split Unit 02-May-11 07-May-11 6,250 6250

Electrical 17-Feb-11 08-May-11 76,895 4923 28720 37614 5638Ground Floor 17-Feb-11 13-Apr-11 25,741 4923 11421 9396

ADDC Intake Room 19-Feb-11 02-Apr-11 9,400 2276 6857 267Electrical System 19-Feb-11 02-Apr-11 4,944 2276 2401 267

PVC Conduits Installation for Electrical 19-Feb-11 23-Feb-11 942 942Pulling the Wires 24-Feb-11 28-Feb-11 1,334 1334Lighting & Power Fixtuers and Accessories installation 28-Mar-11 02-Apr-11 1,334 1067 267Distribution Board Installation 19-Mar-11 20-Mar-11 1,334 1334

Fire Alarm 28-Mar-11 30-Mar-11 4,457 4457Installation of Fire Alram Devices 28-Mar-11 30-Mar-11 4,457 4457

Pump Room 27-Feb-11 07-Apr-11 6,945 375 3230 3339Electrical System 27-Feb-11 07-Apr-11 4,939 375 3230 1334

PVC Conduits Installation for Electrical 27-Feb-11 03-Mar-11 938 375 563Pulling the Wires 05-Mar-11 08-Mar-11 1,334 1334Lighting & Power Fixtuers and Accessories installation 03-Apr-11 07-Apr-11 1,334 1334Distribution Board Installation 24-Mar-11 26-Mar-11 1,334 1334

Fire Alarm 02-Apr-11 04-Apr-11 2,005 2005Installation of Fire Alram Devices 02-Apr-11 04-Apr-11 2,005 2005

Transformer Room 17-Feb-11 13-Apr-11 9,396 2272 1334 5790Electrical System 17-Feb-11 13-Apr-11 4,939 2272 1334 1334

PVC Conduits Installation for Electrical 17-Feb-11 21-Feb-11 938 938Pulling the Wires 22-Feb-11 24-Feb-11 1,334 1334Lighting & Power Fixtuers and Accessories installation 09-Apr-11 13-Apr-11 1,334 1334Distribution Board Installation 13-Mar-11 14-Mar-11 1,334 1334


First Floor 06-Mar-11 08-May-11 51,155 17299 28218 5638Office 13-Mar-11 16-Apr-11 9,402 3605 5797

Electrical System 13-Mar-11 16-Apr-11 7,174 3605 3569PVC Conduits Installation for Electrical 13-Mar-11 16-Mar-11 1,827 1827Pulling the Wires 17-Mar-11 20-Mar-11 1,778 1778Lighting & Power Fixtuers and Accessories installation 12-Apr-11 16-Apr-11 1,334 1334Install Communication System 12-Apr-11 14-Apr-11 2,235 2235

Fire Alarm 12-Apr-11 14-Apr-11 2,228 2228Installation of Fire Al ram Devices 12-Apr-11 14-Apr-11 2,228 2228

Control Room 06-Mar-11 08-May-11 15,533 3605 9852 2076Electrical System 06-Mar-11 08-May-11 13,305 3605 8366 1334

PVC Conduits Installation for Electrical 06-Mar-11 09-Mar-11 938 938Pulling the Wires 10-Mar-11 13-Mar-11 1,334 1334Lighting & Power Fixtuers and Accessories installation 04-May-11 08-May-11 1,334 1334Installation & Termination of UPS Panel 02-Apr-11 05-Apr-11 8,366 8366Distribution Board Installation to Light&Power 28-Mar-11 31-Mar-11 1,334 1334

Fire Alarm 28-Apr-11 01-May-11 2,228 1486 743Installation of Fire Alram Devices 28-Apr-11 01-May-11 2,228 1486 743

Toilets 17-Mar-11 20-Apr-11 5,830 3605 2225Electrical System 17-Mar-11 20-Apr-11 4,939 3605 1334

PVC Conduits Installation for Electrical 17-Mar-11 21-Mar-11 1,827 1827Pulling the Wires 22-Mar-11 24-Mar-11 1,778 1778Lighting & Power Fixtuers and Accessories installation 17-Apr-11 20-Apr-11 1,334 1334

Fire Alarm 16-Apr-11 18-Apr-11 891 891Installation of Fire Alram Devices 16-Apr-11 18-Apr-11 891 891

Kitchen 22-Mar-11 25-Apr-11 6,053 3605 2448Electrical System 22-Mar-11 25-Apr-11 4,939 3605 1334

PVC Conduits Installation for Electrical 22-Mar-11 26-Mar-11 1,827 1827Pulling the Wires 27-Mar-11 29-Mar-11 1,778 1778Lighting & Power Fixtuers and Accessories installation 21-Apr-11 25-Apr-11 1,334 1334


Mess Room 27-Mar-11 30-Apr-11 7,167 2420 4748Electrical System 27-Mar-11 30-Apr-11 4,939 2420 2519

PVC Conduits Installation for Electrical 27-Mar-11 30-Mar-11 1,827 1827Pulling the Wires 31-Mar-11 03-Apr-11 1,778 593 1186Lighting & Power Fixtuers and Accessories installation 26-Apr-11 30-Apr-11 1,334 1334


Store 31-Mar-11 03-May-11 7,167 457 3149 3562Electrical System 31-Mar-11 03-May-11 4,939 457 3149 1334

PVC Conduits Installation for Electrical 31-Mar-11 04-Apr-11 1,827 457 1370Pulling the Wires 05-Apr-11 07-Apr-11 1,778 1778Lighting & Power Fixtuers and Accessories installation 01-May-11 03-May-11 1,334 1334

Fire Alarm 02-May-11 03-May-11 2,228 2228Installation of Fire Alram Devices 02-May-11 03-May-11 2,228 2228

Compound Wall 14-Nov-10 10-Apr-11 317,707 43248 27984 200545 2192 20411 23327Civil 14-Nov-10 01-Feb-11 273,969 43248 27984 200545 2192

Prepare Foundation Base 25-Nov-10 13-Dec-10 35,616 12720 22896Install the Pre cast Wall Panels 03-Jan-11 26-Jan-11 191,778 191778Excavation 14-Nov-10 04-Dec-10 35,616 30528 5088Backfilling 27-Jan-11 01-Feb-11 10,959 8767 2192

Finishes 24-Mar-11 10-Apr-11 43,738 20411 23327Gate 24-Mar-11 10-Apr-11 43,738 20411 23327

Install the Gate 24-Mar-11 10-Apr-11 43,738 20411 23327Reticulation Piping Network & Fibre Optic Cable 07-Nov-10 27-Apr-11 1,196,427 95894 329741 286610 208174 184989 91020

Pipes & Cables 23-Nov-10 27-Apr-11 1,021,779 46993 279093 255174 174991 174510 91020Inside DCP Plot 19-Dec-10 19-Mar-11 72,356 4738 33701 15828 18089







X-Ray 29-Jan-11 10-Feb-11 9,044 2261 6783Insulation of Pipes 12-Feb-11 28-Feb-11 9,044 9044Install Valves and Accessories 01-Mar-11 07-Mar-11 9,044 9044Install the Pipes Supports 19-Dec-10 04-Jan-11 6,030 4738 1292Install the Pipes 05-Jan-11 27-Jan-11 30,148 30148Hydrostatic Test 08-Mar-11 19-Mar-11 9,044 9044

Outside DCP Plot 23-Nov-10 27-Apr-11 949,423 46993 274355 221472 159163 156421 91020Fibre Optic Cable Laying 01-Mar-11 27-Apr-11 8,425 4550 3876Total Distance 200 m Pipes 23-Nov-10 06-Mar-11 147,882 46993 35260 60203 5427

Reticulation Piping Network 23-Nov-10 06-Mar-11 120,921 46993 35260 33243 5427X-Ray Test 25-Dec-10 30-Dec-10 5,427 5427Warning Tape Installation 19-Jan-11 19-Jan-11 1,507 1507Soft Sand and Compaction Test 01-Dec-10 04-Dec-10 14,849 14849Laying the Pipes 11-Dec-10 23-Dec-10 14,984 14984Installation of Dewatering System Equipment 24-Nov-10 24-Nov-10 1,472 1472Install Butterfly Valve 01-Mar-11 06-Mar-11 5,427 5427Hydrostatic Test 02-Jan-11 06-Jan-11 5,427 5427Filled Joint Insulation 08-Jan-11 15-Jan-11 5,427 5427Excavation ( to be coordinated with hilalco) 23-Nov-10 23-Nov-10 41,763 41763Draw down the Underground Water 25-Nov-10 30-Nov-10 3,758 3758Backfilling with Soft Sand 16-Jan-11 18-Jan-11 20,882 20882

Fibre Optic Cable 20-Jan-11 26-Jan-11 26,961 26961Warning Tape Installation 25-Jan-11 25-Jan-11 5,055 5055Installation of PVC Pipes 20-Jan-11 23-Jan-11 8,425 8425Final Backfilling 26-Jan-11 26-Jan-11 5,055 5055Backfilling with Soft Sand 24-Jan-11 24-Jan-11 8,425 8425

Total Distance 400 m Pipes 01-Dec-10 09-Feb-11 147,654 71834 40391 35429Reticulation Piping Network 01-Dec-10 02-Feb-11 120,693 71834 40391 8468

X-Ray Test 09-Jan-11 15-Jan-11 5,427 5427Warning Tape Installation 02-Feb-11 02-Feb-11 1,507 1507Soft Sand and Compaction Test 12-Dec-10 13-Dec-10 14,664 14664Laying the Pipes 25-Dec-10 08-Jan-11 20,380 10190 10190Installation of Dewatering System Equipment 04-Dec-10 04-Dec-10 1,459 1459Hydrostatic Test 16-Jan-11 20-Jan-11 5,427 5427Filled Joint Insulation 22-Jan-11 29-Jan-11 5,427 5427Excavation 01-Dec-10 01-Dec-10 41,763 41763Draw down the Underground Water 05-Dec-10 11-Dec-10 3,758 3758Backfilling with Soft Sand 30-Jan-11 01-Feb-11 20,882 13921 6961

Fibre Optic Cable 03-Feb-11 09-Feb-11 26,961 26961Warning Tape Installation 08-Feb-11 08-Feb-11 5,055 5055Installation of PVC Pipes 03-Feb-11 06-Feb-11 8,425 8425Final Backfilling 09-Feb-11 09-Feb-11 5,055 5055Backfilling with Soft Sand 07-Feb-11 07-Feb-11 8,425 8425

Total Distance 600 m Pipes 12-Dec-10 26-Feb-11 147,654 61644 27978 58032Reticulation Piping Network 12-Dec-10 17-Feb-11 120,693 61644 27978 31072

X-Ray Test 23-Jan-11 29-Jan-11 5,427 5427Warning Tape Installation 17-Feb-11 17-Feb-11 1,507 1507Soft Sand and Compaction Test 20-Dec-10 21-Dec-10 14,664 14664Laying the Pipes 09-Jan-11 22-Jan-11 20,380 20380Installation of Dewatering System Equipment 13-Dec-10 13-Dec-10 1,459 1459Hydrostatic Test 30-Jan-11 03-Feb-11 5,427 2171 3256Filled Joint Insulation 05-Feb-11 12-Feb-11 5,427 5427Excavation 12-Dec-10 12-Dec-10 41,763 41763Draw down the Underground Water 14-Dec-10 19-Dec-10 3,758 3758Backfilling with Soft Sand 13-Feb-11 16-Feb-11 20,882 20882

Fibre Optic Cable 19-Feb-11 26-Feb-11 26,961 26961Warning Tape Installation 23-Feb-11 23-Feb-11 5,055 5055Installation of PVC Pipes 19-Feb-11 21-Feb-11 8,425 8425Final Backfilling 24-Feb-11 26-Feb-11 5,055 5055Backfilling with Soft Sand 22-Feb-11 22-Feb-11 8,425 8425

Total Distance 800 m Pipes 20-Dec-10 12-Mar-11 147,654 61644 13587 30034 42389Reticulation Piping Network 20-Dec-10 03-Mar-11 120,693 61644 13587 30034 15429

X-Ray Test 06-Feb-11 12-Feb-11 5,427 5427Warning Tape Installation 03-Mar-11 03-Mar-11 1,507 1507Soft Sand and Compaction Test 28-Dec-10 29-Dec-10 14,664 14664Laying the Pipes 23-Jan-11 05-Feb-11 20,380 13587 6793Installation of Dewatering System Equipment 21-Dec-10 21-Dec-10 1,459 1459Hydrostatic Test 13-Feb-11 19-Feb-11 5,427 5427Filled Joint Insulation 20-Feb-11 27-Feb-11 5,427 5427Excavation 20-Dec-10 20-Dec-10 41,763 41763Draw down the Underground Water 22-Dec-10 27-Dec-10 3,758 3758Backfilling with Soft Sand 28-Feb-11 02-Mar-11 20,882 6961 13921

Fibre Optic Cable 05-Mar-11 12-Mar-11 26,961 26961Warning Tape Installation 09-Mar-11 09-Mar-11 5,055 5055Installation of PVC Pipes 05-Mar-11 07-Mar-11 8,425 8425Final Backfilling 10-Mar-11 12-Mar-11 5,055 5055Backfilling with Soft Sand 08-Mar-11 08-Mar-11 8,425 8425

Total Distance 1000 m Pipes 28-Dec-10 26-Mar-11 147,654 43974 17670 26892 59118Reticulation Piping Network 28-Dec-10 17-Mar-11 120,693 43974 17670 26892 32157

X-Ray Test 21-Feb-11 27-Feb-11 5,427 5427Warning Tape Installation 17-Mar-11 17-Mar-11 1,507 1507Soft Sand and Compaction Test 06-Jan-11 08-Jan-11 14,664 14664Laying the Pipes 06-Feb-11 20-Feb-11 20,380 20380Installation of Dewatering System Equipment 29-Dec-10 29-Dec-10 1,459 1459Hydrostatic Test 28-Feb-11 05-Mar-11 5,427 1085 4341Filled Joint Insulation 06-Mar-11 13-Mar-11 5,427 5427Excavation 28-Dec-10 28-Dec-10 41,763 41763Draw down the Underground Water 30-Dec-10 05-Jan-11 3,758 752 3006Backfilling with Soft Sand 14-Mar-11 16-Mar-11 20,882 20882







Fibre Optic Cable 19-Mar-11 26-Mar-11 26,961 26961Warning Tape Installation 23-Mar-11 23-Mar-11 5,055 5055Installation of PVC Pipes 19-Mar-11 21-Mar-11 8,425 8425Final Backfilling 24-Mar-11 26-Mar-11 5,055 5055Backfilling with Soft Sand 22-Mar-11 22-Mar-11 8,425 8425

Total Distance 1200 m Pipes 06-Jan-11 13-Apr-11 202,501 61644 8776 44938 87144Reticulation Piping Network 06-Jan-11 13-Apr-11 177,226 61644 8776 44938 61869

X-Ray Test 07-Mar-11 13-Mar-11 5,427 5427Warning Tape Installation 31-Mar-11 31-Mar-11 1,507 1507Soft Sand and Compaction Test 15-Jan-11 16-Jan-11 14,664 14664Laying the Pipes 21-Feb-11 06-Mar-11 15,044 8776 6268Installation of Dewatering System Equipment 08-Jan-11 08-Jan-11 1,459 1459Install Butterfly Valve 07-Apr-11 13-Apr-11 5,427 5427Hydrostatic Test 14-Mar-11 19-Mar-11 5,427 5427Filled Joint Insulation 20-Mar-11 27-Mar-11 5,427 5427Excavation 06-Jan-11 06-Jan-11 41,763 41763Draw down the Underground Water 09-Jan-11 13-Jan-11 3,758 3758Construct Drain Chamber 07-Apr-11 10-Apr-11 21,163 21163Construct Air Vent Chamber 07-Apr-11 10-Apr-11 35,279 35279Backfilling with Soft Sand 28-Mar-11 30-Mar-11 20,882 20882

Fibre Optic Cable 02-Apr-11 06-Apr-11 25,276 25276Warning Tape Installation 05-Apr-11 05-Apr-11 4,213 4213Installation of PVC Pipes 02-Apr-11 03-Apr-11 8,425 8425Final Backfilling 06-Apr-11 06-Apr-11 4,213 4213Backfilling with Soft Sand 04-Apr-11 04-Apr-11 8,425 8425

Valve Chambers 07-Nov-10 13-Mar-11 174,648 48901 50648 31437 33183 10479Valve Chamber No.01 07-Nov-10 21-Dec-10 43,662 24451 19211

Water Proofing 10-Nov-10 11-Nov-10 3,493 3493Walls 20-Nov-10 30-Nov-10 12,225 12225Slab 01-Dec-10 11-Dec-10 12,225 12225Foundation 13-Nov-10 18-Nov-10 5,239 5239External Water Proofing 12-Dec-10 19-Dec-10 3,493 3493Bl inding 07-Nov-10 09-Nov-10 3,493 3493Backfilling 20-Dec-10 21-Dec-10 3,493 3493

Valve Chamber No.02 07-Nov-10 21-Dec-10 43,662 24451 19211Water Proofing 10-Nov-10 11-Nov-10 3,493 3493Walls 20-Nov-10 30-Nov-10 12,225 12225Slab 01-Dec-10 11-Dec-10 12,225 12225Foundation 13-Nov-10 18-Nov-10 5,239 5239External Water Proofing 12-Dec-10 19-Dec-10 3,493 3493Bl inding 07-Nov-10 09-Nov-10 3,493 3493Backfilling 20-Dec-10 21-Dec-10 3,493 3493

Valve Chamber No.03 22-Dec-10 31-Jan-11 43,662 12225 31437Water Proofing 26-Dec-10 27-Dec-10 3,493 3493Walls 02-Jan-11 12-Jan-11 12,225 12225Slab 13-Jan-11 20-Jan-11 12,225 12225Foundation 28-Dec-10 30-Dec-10 5,239 5239External Water Proofing 22-Jan-11 29-Jan-11 3,493 3493Bl inding 22-Dec-10 25-Dec-10 3,493 3493Backfilling 30-Jan-11 31-Jan-11 3,493 3493

Valve Chamber No.04 01-Feb-11 13-Mar-11 43,662 33183 10479Water Proofing 05-Feb-11 06-Feb-11 3,493 3493Walls 10-Feb-11 22-Feb-11 12,225 12225Slab 23-Feb-11 02-Mar-11 12,225 8732 3493Foundation 07-Feb-11 09-Feb-11 5,239 5239External Water Proofing 03-Mar-11 10-Mar-11 3,493 3493Bl inding 01-Feb-11 03-Feb-11 3,493 3493Backfilling 12-Mar-11 13-Mar-11 3,493 3493

Energy Transfer Stations 18-Jan-11 16-Mar-11 376,097 90263 204221 81613ETS Room (Tower A,B) 18-Jan-11 06-Mar-11 167,476 38684 97707 31084

Plant Pipes / Heat Exchangers Inside ETS Room 18-Jan-11 06-Mar-11 167,476 38684 97707 31084X-RayTest 03-Feb-11 08-Feb-11 15,044 15044Insulation of Pipes 09-Feb-11 17-Feb-11 15,044 15044Install Valves 19-Feb-11 22-Feb-11 18,805 18805Install Pipes 18-Jan-11 02-Feb-11 45,132 38684 6447Install Heat Exchanger Fitting & Accessories 23-Feb-11 06-Mar-11 15,044 7522 7522Install Heat Exchanger 23-Feb-11 06-Mar-11 47,125 23562 23562Hydrostatic for Tower A,B 09-Feb-11 21-Feb-11 11,283 11283

ETS Room (Tower C,D) 18-Jan-11 06-Mar-11 140,397 38684 70252 31461Plant Pipes / Heat Exchangers Inside ETS Room 18-Jan-11 06-Mar-11 140,397 38684 70252 31461

X-RayTest 03-Feb-11 08-Feb-11 7,522 7522Insulation of Pipes 09-Feb-11 17-Feb-11 7,522 7522Install Valves 19-Feb-11 22-Feb-11 15,044 15044Install Pipes 18-Jan-11 02-Feb-11 45,132 38684 6447Install Heat Exchanger Fitting & Accessories 23-Feb-11 06-Mar-11 7,522 3761 3761Install Heat Exchanger 23-Feb-11 06-Mar-11 46,373 23186 23186Hydrostatic for Tower C,D 22-Feb-11 05-Mar-11 11,283 6770 4513

ETS Room (Tower E) 18-Jan-11 16-Mar-11 68,224 12895 36261 19068Plant Pipes / Heat Exchangers Inside ETS Room 18-Jan-11 16-Mar-11 68,224 12895 36261 19068

X-RayTest 03-Feb-11 08-Feb-11 7,522 7522Insulation of Pipes 09-Feb-11 17-Feb-11 7,522 7522Install Valves 19-Feb-11 22-Feb-11 7,522 7522Install Pipes 18-Jan-11 02-Feb-11 15,044 12895 2149Install Heat Exchanger Fitting & Accessories 23-Feb-11 06-Mar-11 7,522 3761 3761Install Heat Exchanger 23-Feb-11 06-Mar-11 15,570 7785 7785Hydrostatic for Tower E 06-Mar-11 16-Mar-11 7,522 7522

External Works 20-Mar-11 28-Apr-11 433,251 275064 158187Sewerage Network 20-Mar-11 05-Apr-11 207,439 152122 55317

uPVC gravity sewers in trench with Manholes 20-Mar-11 05-Apr-11 207,439 152122 55317







Potable Water Network 20-Mar-11 05-Apr-11 167,648 122942 44706uPVC pipe work in trench with wi th Chambers 20-Mar-11 05-Apr-11 167,648 122942 44706

External Lighting 11-Apr-11 27-Apr-11 41,556 41556External Lighting 11-Apr-11 27-Apr-11 41,556 41556

Steel Stairs 12-Apr-11 28-Apr-11 16,608 16608Steel Staircase for Ancillary Building 12-Apr-11 28-Apr-11 16,608 16608

Testing and Commissioning 17-Mar-11 11-May-11 242,322 89612 123717 28993Mechanical 17-Mar-11 11-May-11 242,322 89612 123717 28993

Reticulation Piping Network 14-Apr-11 11-May-11 80,790 51797 28993Chemical Passivation 02-May-11 11-May-11 26,922 26922Chemical Cleaning 19-Apr-11 01-May-11 26,922 24851 2071Air Flushing 14-Apr-11 18-Apr-11 26,946 26946

Energy Transfer Stations 17-Mar-11 06-Apr-11 80,766 51152 29614Chemical Passivation 03-Apr-11 06-Apr-11 26,922 26922Chemical Cleaning 22-Mar-11 02-Apr-11 26,922 24230 2692Air Flushing 17-Mar-11 21-Mar-11 26,922 26922

District Cooling Modular Plant 20-Mar-11 18-Apr-11 80,766 38460 42306Chemical Passivation 09-Apr-11 18-Apr-11 26,922 26922Chemical Cleaning 26-Mar-11 08-Apr-11 26,922 11538 15384Air Flushing 20-Mar-11 25-Mar-11 26,922 26922





Contract Amount : Advance Payment ( 10 % ) : 5,316,601.60 Advance Payment Bond Date :Change Orders Approved to Date : Retention Amount ( 5 % ) : 2,658,300.80 Performance Bond Date :Current Contract Amount : Contract Start Date : 18-Jul-10 Other Bonds :Invoice Currency : AED Contract Completion Date : 13-May-11

Due Date Duration after Approval is : 56 Days

Value of Work Retention Release Advance Payment Retention Money Others Total Deduction Net Invoice Actual

A B C D E (F)=C+D+E Net =(A+B-F) Date Amount Difference(Days)

1 Advance Payment 5,316,602 0 5,316,602 5,316,602 18-Aug-10 21-Sep-102 30-Sep-2010 5,924,236 - 888,635 592,424 - 1,481,059 4,443,177 9,759,778 30-Sep-10 25-Nov-103 31-Oct-2010 2,500,867 - 375,130 250,087 - 625,217 1,875,650 11,635,428 31-Oct-10 26-Dec-104 30-Nov-2010 2,999,945 - 449,992 299,995 - 749,986 2,249,959 13,885,387 30-Nov-10 25-Jan-115 31-Dec-2010 1,655,753 - 248,363 165,575 - 413,938 1,241,815 15,127,202 31-Dec-10 25-Feb-116 31-Jan-2011 7,298,559 1,094,784 729,856 - 1,824,640 5,473,920 20,601,122 31-Jan-11 28-Mar-117 28-Feb-2011 10,336,991 - 1,550,549 620,365 - 2,170,913 8,166,077 28,767,199 28-Feb-11 25-Apr-118 31-Mar-2011 8,775,786 - 709,149 - - 709,149 8,066,637 36,833,836 31-Mar-11 26-May-119 30-Apr-2011 9,300,088 - - - - 0 9,300,088 46,133,924 30-Apr-11 25-Jun-11

10 31-May-2011 999,740 1,329,150.40 - - - 0 2,328,890 48,462,814 31-May-11 26-Jul-1111 30-Jun-2011 307,384 - - - - 0 307,384 48,770,198 30-Jun-11 25-Aug-1112 31-Jul-2011 307,384 - - - - 0 307,384 49,077,582 31-Jul-11 25-Sep-1113 31-Aug-2011 307,063 - - - - 0 307,063 49,384,644 31-Aug-11 26-Oct-1114 30-Sep-2011 307,063 - - - - 0 307,063 49,691,707 30-Sep-11 25-Nov-1115 31-Oct-2011 307,063 - - - - 0 307,063 49,998,770 31-Oct-11 26-Dec-1116 30-Nov-2011 307,063 - - - - 0 307,063 50,305,833 30-Nov-11 25-Jan-1217 31-Dec-2011 307,063 - - - - 0 307,063 50,612,895 31-Dec-11 25-Feb-1218 31-Jan-2012 307,063 - - - - 0 307,063 50,919,958 31-Jan-12 27-Mar-1219 29-Feb-2012 307,063 - - - - 0 307,063 51,227,021 29-Feb-12 25-Apr-1220 31-Mar-2012 342,286 - - - - 0 342,286 51,569,306 31-Mar-12 26-May-1221 30-Apr-2012 133,780 - - - - 0 133,780 51,703,086 30-Apr-12 25-Jun-1222 31-May-2012 133,780 1,329,150.40 - - - 0 1,462,930 53,166,017 31-May-12 26-Jul-12

53,166,017 0 5,316,601.68 2,658,300.82 0.00 7,974,902 53,166,017

53,166,016.00


Forecasting of Monthly Invoices

53,166,016.00

Cert. / Invoice

No.Month Cumulative Invoice Submitted

Date

Forcast Date of Releasing the

Invoices

Total

GROSS INVOICE DEDUCTIONS

Remarks

Release of 5% of Retention Money

Release of 5% of Retention Money

File : Cash Flow Page 2 of 2 Printed On :10/20/10 at 1:06 PM


Section 1.12

Cash In Histogram (EPC Project Period)

Planned Monthly 5,316,602 4,443,177 1,875,650 2,249,959 1,241,815 5,473,920 8,166,077 8,066,637 9,300,088 2,328,890

Planned Accum. 5,316,602 5,316,602 9,759,778 11,635,428 13,885,387 15,127,202 20,601,122 28,767,199 36,833,836 46,133,924 48,462,814

Actual Monthly

Actual Accum.

Forecast Monthly

Forecast Accum.

Sep-10 Jun-11May-11Nov-10 Dec-10 Jan-11Oct-10

ForecastPlanned

Actual


Cash In Histogram (EPC Project Period)

Feb-11 Mar-11 Apr-11 Jul-11

2,328,890

8,166,077

5,473,920

4,443,177

5,316,602

1,875,6502,249,959

1,241,815

8,066,637

9,300,088

Sep-10

Oct-10

Nov-10

Dec-10

Jan-11

Feb-11

Mar-11

Apr-11

May-11

Jun-11

Jul-11

Forecast Date of Releasing the Invoices

AED 0.00

AED 1,000,000.00

AED 2,000,000.00

AED 3,000,000.00

AED 4,000,000.00

AED 5,000,000.00

AED 6,000,000.00

AED 7,000,000.00

AED 8,000,000.00

AED 9,000,000.00

AED 10,000,000.00

Planned Monthly Actual Monthly Forecast Accum. Planned Accum.Actual Accum. Forecast Monthly

File: Cash Flow Page 1 of 1 Printed On : 10/20/10 at 12:42 PM


Section 1.13

Cash In Histogram (Operation and Maintenance Period)

Planned Monthly 307,384 307,384 307,063 307,063 307,063 307,063 307,063 307,063 307,063 342,286 133,780 1,462,930

Planned Accum. 307,384 614,768 921,831 1,228,893 1,535,956 1,843,019 2,150,081 2,457,144 2,764,207 3,106,492 3,240,273 4,703,203

Actual Monthly

Actual Accum.

Forecast Monthly

Forecast Accum.

Jan-12 Feb-12 Apr-12

Forecast

Aug-11 Nov-11 Dec-11

PlannedActual


Cash In Histogram (Operation and Maintenance Period)

Jun-12 Jul-12May-12Mar-12Sep-11 Oct-11

307,063307,063307,063307,384307,384 307,063 307,063 307,063 307,063

342,286

Aug-11

Sep-11

Oct-11

Nov-11

Dec-11

Jan-12

Feb-12

Mar-12

Apr-12

May-12


AED 280,000.00

AED 290,000.00

AED 300,000.00

AED 310,000.00

AED 320,000.00

AED 330,000.00

AED 340,000.00

AED 350,000.00




Section 2

Cash Out Data


Section 2.11

Cash Out-Value of Works & Monthly Invoices


Description Original Budget 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

1.0 - Materials 8,641,274

Civil Works

Imported fill 136,125 7.69% 23.08% 30.77% 15.38% 23.08%

Sand Bedding/Padding 87,300 66.67% 33.33%

Lean Concrete 29,295 50.00% 12.50% 12.50% 25.00%

RC Concrete 376,740 14.29% 35.71% 21.43% 21.43% 7.14%

Rebars 251,680 25.00% 28.57% 21.43% 25.00%

Formworks 342,125 14.29% 35.71% 21.43% 21.43% 7.14%

Blockworks 27,000 44.44% 55.56%

Polythelene Sheets 6,555 100.00%

Water Stop 9,000 100.00%

Floor Screed 6,700 50.00% 25.00% 25.00%

Steel Stairs 14,160 100.00%

Ceramic Floor tiles 5,355 50.00% 50.00%

Plastering 8,856 100.00%

Painting 8,247 100.00%

Manhole Cover 17,400 100.00%

Aluminum Ladder 3,500 100.00%

Pipe Sleeves Inserts 25,200 100.00%

Cable Tiles / Warning Tapes 3,047 100.00%

Furnishings 52,050 100.00%

Geo-Textile Membrane 7,401 100.00%

Electrical Works

Plant Room

MV Cables (Plant) 350,380 10.00% 90.00%

Relay coordination Study and Local Authority Approvals for 11kv Switchgear , Testing

30,000 100.00%

Transformer (Plant) inclusive of Factory Witness Test 589,824 10.00% 90.00%

Cables & Wires (Plants) 203,511 10.00% 55.00% 35.00%

Contaiment (Cable Tray & Trunking) 20,894 100.00%

Isolators (plant) 12,196 100.00%

PVC Duct Bank 1,200 100.00%

Earthing (Plant) 23,922 100.00%

Lignhtning Protection (Plant) 41,466 100.00%

UPS system (Plant) 76,271 100.00%

Support for Electrical System 8,925 100.00%

Miscellaneous (Cable Marker, Rubber Mats, Boards, Consumables) 3,720 100.00%

Building Services

Mubadala Capitaland Real Estate District Cooling Plant for Rihan HeightsCash Out Value of Works & Monthly Invoices

File:Cash Flow Page1 of 7 Printed On:10/20/10 at 12:47 PM




SMDB/Distribution Boards (BS) 14,500 100.00%

Cables & Wires (BS) 56,126 100.00%

Conduit fittings & accessories (BS) 22,286 100.00%

Light Fittings -(BS) 26,602 100.00%

Wiring accessories (BS) 4,188 100.00%

Light Points (BS) 2,100 100.00%

Support for Electrical System (BS) 4,052 100.00%

Mechanical Works

HVAC

Process (DC Plant)

Expansion Tank 32,972 100.00%

Chemical Water Treatment System (Chilled & Condenser Water) /Equipments

454,500 10.00% 90.00%

Air Compressor 15,000 100.00%

Refrigerant Recovery Unuit 75,000 100.00%

Chilled Water /Condenser Water Pipe & Fittings 149,552 100.00%

Chilled/Condenser Water Pipe Insulation 37,280 100.00%

Valves 163,508 100.00%

Aluminium Cladding 31,473 100.00%

Hanger & Supports 42,729 100.00%

Identification & Tag 3,670 100.00%

Fire Stopping Material 10,014 100.00%

Skid & Shed 5,000 100.00%

Consumables-Piping 2,849 100.00%

Consumables-HVAC 8,383 100.00%

HVAC Reticulation Works

Pre Insulated Chilled Water Pipes & Fittings 1,110,481 10.00% 90.00%

Leak Detection System 80,000 100.00%

Valves & Accessories 77,684 100.00%

Radiography Test/ Welding Inspector 55,000 100.00%

Stress Analysis 20,000 100.00%



Warning Tapes, Markup Plates 45,608 100.00%

HVAC Works - ETS Room

Heat Exchangers 1,154,575 10.00% 90.00%

Chilled Water Pipe & Fittings 585,760 10.00% 90.00%

Chilled Water Pipe Insulation 82,634 100.00%

Valves 512,513 10.00% 90.00%






Hanger & Supports 174,922 100.00%

Identification & Tag 4,008 100.00%

Fire Stopping Material 50,000 100.00%


Consumables-HVAC 14,265 100.00%

HVAC Works - Building Services

Split Air Conditioning Units (BS) 33,718 100.00%

Fans (BS) 3,952 100.00%

Condensate Pipe & Fittings (BS) 385 100.00%

Condensate Water Pipe Insulation (BS) 672 100.00%

Vibration Isolator (BS) 600 100.00%

Hanger & Supports (BS) 2,640 100.00%

Identification & Tag (BS) 160 100.00%

Plumbing

Process (DC Plant)

Make Up Water Pump 34,356 100.00%

HDPE Pipes & Fittings 13,639 100.00%

Steel Pipes & Fittings 24,175 100.00%

Valves & Appurtenances 31,038 100.00%

Drainage Specialities 8,140 100.00%

Insulation 5,084 100.00%

Aluminum Cladding 13,272 100.00%

Supports 5,000 100.00%


Consumables-General 2,100 100.00%

Building Services (BS) + External

Booster Water Pump 22,200 100.00%

HDPE Pipes & Fittings 38,813 100.00%

Steel Pipes & Fittings 8,505 100.00%

uPVC Pipes & Fittings 14,707 100.00%

PPR Pipes & Fittings 2,149 100.00%

Valves & Appurtenances 24,717 100.00%

Drainage Specialities 9,110 100.00%

Insulation 9,737 100.00%

Aluminum Cladding 10,750 100.00%

Sanitray Fixtures & Accessories 22,928 100.00%

GRP Cylindrical Tank 2,100 100.00%

Electrical Water Heaters 4,120 100.00%





Supports 13,000 100.00%


Consumables-General 3,400 100.00%

Pantry Items 15,323 100.00%

Supply Stationery 15,000 100.00%

Office Supplies to Client 2,063 100.00%

Safety Supplies 6,518 100.00%

Scaffolding 32,457 33.34% 33.33% 33.33%

Tools 9,236 100.00%

Water for Testing 71,005 100.00%

Gases 3,000 100.00%

Office Equipment to Client 27,500 100.00%

2.0 - Subcontract 26,301,274

Civil Works

Dewatering Works 76,500 100.00%

Waterproofing 132,831 25.00% 25.00% 25.00% 25.00%

Precast Boundary Wall 194,700 33.34% 33.33% 33.33%

Steel Doors 89,676 50.00% 50.00%

Wooden Doors 12,805 50.00% 50.00%

Aluminum Windows, louver windows 40,200 50.00% 50.00%

Metal Works 5,250 100.00%

Suspended Ceiling 11,197 100.00%

Epoxy Floor Coating 15,235 100.00%

Steel Gates 38,750 50.00% 50.00%

GRP Lining 182,280 33.34% 33.33% 33.33%

Geotechnical Report 13,529 100.00%

Material Testing 31,000 16.67% 16.67% 16.67% 16.67% 16.67% 16.67%

GRP Ladder 10,712 100.00%

Kitchen Equipments 15,804 50.00% 50.00%

Electrical Works

HV Cable Laying & Termination 45,500 100%

Fire Alarm System 19,941 50.00% 50%

Telecommunication System 2,000 100%

Cabling 76,500 50.00% 50%

HVAC Works

HVAC Initial Start-up 15,017 100.00%

25,000 100.00%

75,000 100.00%





HVAC Testing, Balancing 40,018 100.00%

10,000 100.00%

30,000 100.00%

Mechanical Works

Fire Fighting System 122,425 10.00% 45.00% 45.00%

Fire Fighting System 826,767 10.00% 45.00% 45.00%

Electric Chain Hoist 40,843 100.00%

Flushing /Chemical Flushing 35,000 50.00% 50.00%

Testing & Commissioning 25,000 50.00% 50.00%

Modular DCP Plant

Modular District Cooling Plant (Stellar)

Purchase Order-Pump 116,644 100.00%

Purchase Order-Chiller 935,874 100.00%

Purchase Order-Cooling Towers 311,427 100.00%

Purchase Order-Electrical Module 864,016 100.00%

Shipping Documents-Chiller 4,958,138 100.00%

Shipping Documents-Cooling Towers 953,726 100.00%

Shipping Documents-Electrical Module 2,999,975 100.00%

Delivery-Pump 357,214 100.00%

Delivery-Chiller 2,866,060 100.00%

Delivery-Cooling Towers 953,726 100.00%

Delivery-MV Switchgear 1,788,802 100.00%

Delivery-LV Switchgear 857,196 100.00%

Delivery-Chiller Base Frame 1,040,918 100.00%

Delivery-Chiller Enclosure 693,945 100.00%

Delivery-Electrical Module Base Frame 212,386 100.00%

Delivery-Electrical Module Enclosure 141,591 100.00%

Signing of Taking Over Certificate 2,227,959 100%

Special System - SCADA Control & Automation (Stellar)

Others /Misc

Design (Stamping Purpose Only) 125,000 45.00% 15.00% 20.00% 10.00% 10.00%

Environment Assessment Study (Budget) 30,000 100.00%

Services during Defect Liability Period 210,675 100.00%

Operation & Maintenance for 12 Months 1,396,524 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8% 8%

3.0 - Manual Manpower 1,692,434

Civil Works 507,503 6.36% 16.36% 18.18% 20.91% 19.09% 10.91% 6.36% 1.82%

HVAC Works 840,899 11.00% 14.67% 18.00% 18.00% 17.00% 13.67% 7.67%

Plumbing Works 83,027 25.00% 25.00% 25.00% 25.00%





Electrical Works 120,500 3.85% 3.85% 6.41% 8.97% 15.38% 20.51% 20.51% 20.51%

Farash, Store Helper, Guards, Drivers, Courier, Tea Boy, Janitor 124,504 2.00% 12.25% 12.25% 12.25% 12.25% 12.25% 12.25% 12.25% 12.25%

Welders Qualifications & Testing 16,000 16.67% 16.67% 16.67% 16.67% 16.67% 16.67%

4.0 - Construction Equipment 1,350,439

Operation 369,147 0.01% 0.57% 6.18% 10.02% 17.64% 19.99% 22.55% 19.72% 3.33%

Equipment Outside Hire 84,151 4.00% 9.00% 15.00% 15.00% 15.00% 15.00% 15.00% 12.00%

Fuels 233,136 2.00% 2.00% 9.00% 15.00% 15.00% 15.00% 15.00% 15.00% 12.00%

481,617 0.01% 0.57% 6.18% 10.02% 17.64% 19.99% 22.55% 19.72% 3.33%

Personal Cars 36,000 2.00% 2.00% 9.00% 15.00% 15.00% 15.00% 15.00% 15.00% 12.00%

Pick - up 146,388 2.00% 2.00% 9.00% 15.00% 15.00% 15.00% 15.00% 15.00% 12.00%

5.0 - Indirect Cost 2,513,857

Purchase, Rental, Construction Cost 170,683 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Maintenance of Temp Facilities 171,786 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Utilities 277,389 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

General Services 84,640 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Progress Photographs 700 100.00%

Courier Service 5,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Mobile Telephone 25,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Communication (tel + fax + internet) 70,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Communication (Wireless Internet Access) 4,949 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Furniture 30,128 80.00% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50%

Furniture to Client 21,000 80.00% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50%

P&D Office Equipment 10,000 80.00% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50% 2.50%

Ropes & Slings 10,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Bank Interest 55,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Contract Expenses 227,590 33.34% 33.33% 33.33%

Costs of Bid Bond 7,532 33.34% 33.33% 33.33%

Letter of Credit 281,250 33.34% 33.33% 33.33%

Charges of CADD 375,000 33.34% 33.33% 33.33%

Charges of IT 20,400 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Containers 40,000 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11% 11.11%

Insurance All Risk & 3rd party 209,295 33.34% 33.33% 33.33%

Workmen's Compensation & Insurance 16,515 33.34% 33.33% 33.33%

Professional Indemnity Insurance 400,000 33.34% 33.33% 33.33%

6.0 - Non Manual Manpower 2,501,187

Salary 2,501,187 7.46% 11.44% 12.44% 11.94% 11.94% 11.94% 10.95% 10.95% 10.95%

7.0 - Management Overhead/Contingency/ G. Expenses

10,165,550





Estimation Errors 300,615 11.85% 5.41% 6.35% 3.82% 14.43% 20.15% 17.21% 18.20% 2.59%

Expected Cost Contingency - Currency Fluctuation 169,183 11.85% 5.41% 6.35% 3.82% 14.43% 20.15% 17.21% 18.20% 2.59%

Provisional Sum 2,488,550 15.53% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 6.92% 8.33%

Area / division Overheads 1,594,980 11.85% 5.41% 6.35% 3.82% 14.43% 20.15% 17.21% 18.20% 2.59%

Corporate Overheads 1,063,320 11.85% 5.41% 6.35% 3.82% 14.43% 20.15% 17.21% 18.20% 2.59%

Management Overhead and Risk 4,548,902

SUBTOTAL 53,166,015 - - 1,283,058 1,256,431 3,318,442 1,810,460 1,784,008 4,509,330 6,435,157 13,694,325 2,641,549 6,575,608 504,063 288,626 288,626 2,516,585 288,626 288,626 288,626 288,626 323,715 116,377 116,377

48,617,243 - - 1,283,058 1,256,431 3,318,442 1,810,460 1,784,008 4,509,330 6,435,157 13,694,325 2,641,549 6,575,608 504,063 288,626 288,626 2,516,585 288,626 288,626 288,626 288,626 323,715 116,377 116,377

- - 1,283,058 2,539,489 5,857,931 7,668,391 9,452,399 13,961,730 20,396,886 34,091,211 36,732,761 43,308,369 43,812,432 44,101,058 44,389,685 46,906,270 47,194,896 47,483,522 47,772,148 48,060,774 48,384,489 48,500,866 48,617,243

0.00% 0.00% 2.41% 4.78% 11.02% 14.42% 17.78% 26.26% 38.36% 64.12% 69.09% 81.46% 82.41% 82.95% 83.49% 88.23% 88.77% 89.31% 89.85% 90.40% 91.01% 91.23% 91.44%

Plan. Value of Work - Month

Plan. Value of Work - Cumulative



Section 2.12

Cash Out Histogram (EPC Project Period)

Planned Monthly 1,283,058 1,256,431 3,318,442 1,810,460 1,784,008 4,509,330 6,435,157 13,694,325 2,641,549 6,575,608 504,063

Planned Accum. 1,283,058 2,539,489 5,857,931 7,668,391 9,452,399 13,961,730 20,396,886 34,091,211 36,732,761 43,308,369 43,812,432

Actual Monthly

Actual Accum.

Forecast Monthly

Forecast Accum.

Sep-10 Jun-11May-11Nov-10 Dec-10 Jan-11Oct-10

ForecastPlanned

Actual


Cash Out Histogram (EPC Project Period)

Feb-11 Mar-11 Apr-11 Jul-11

504,063

13,694,325

6,435,157

3,318,442

1,256,4311,283,058

1,810,460 1,784,008

4,509,330

2,641,549

6,575,608

Sep-10

Oct-10

Nov-10

Dec-10

Jan-11

Feb-11

Mar-11

Apr-11

May-11

Jun-11

Jul-11


AED 0.00

AED 2,000,000.00

AED 4,000,000.00

AED 6,000,000.00

AED 8,000,000.00

AED 10,000,000.00

AED 12,000,000.00

AED 14,000,000.00

AED 16,000,000.00




Section 2.13

Cash Out Histogram (Operation and Maintenance Period)

Planned Monthly 288,626 288,626 2,516,585 288,626 288,626 288,626 288,626 323,715 116,377 116,377

Planned Accum. 288,626 577,252 3,093,837 3,382,464 3,671,090 3,959,716 4,248,342 4,572,057 4,688,434 4,804,811

Actual Monthly

Actual Accum.

Forecast Monthly

Forecast Accum.

Jan-12 Feb-12 Apr-12

Forecast

Aug-11 Nov-11 Dec-11

PlannedActual


Cash Out Histogram (Operation and Maintenance Period)

Jun-12 Jul-12May-12Mar-12Sep-11 Oct-11

323,715288,626

2,516,585

288,626288,626 288,626 288,626 288,626

116,377 116,377

Aug-11

Sep-11

Oct-11

Nov-11

Dec-11

Jan-12

Feb-12

Mar-12

Apr-12

May-12


AED 0.00

AED 500,000.00

AED 1,000,000.00

AED 1,500,000.00

AED 2,000,000.00

AED 2,500,000.00

AED 3,000,000.00




Section 3

Cash Flow


Section 3.11

Project Cash Flow Curve

District Cooling Plant for Rihan HeightsThe Baseline of Project Cash Flow

Month No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23

Cut-Off date Sep-10 Oct-10 Nov-10 Dec-10 Jan-11 Feb-11 Mar-11 Apr-11 May-11 Jun-11 Jul-11 Aug-11 Sep-11 Oct-11 Nov-11 Dec-11 Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12

Cash-In 5,316,602 4,443,177 1,875,650 2,249,959 1,241,815 5,473,920 8,166,077 8,066,637 9,300,088 2,328,890 307,384 307,384 307,063 307,063 307,063 307,063 307,063 307,063 307,063 342,286 133,780 1,462,930

Cash-Out 1,283,058 1,256,431 3,318,442 1,810,460 1,784,008 4,509,330 6,435,157 13,694,325 2,641,549 6,575,608 504,063 288,626 288,626 2,516,585 288,626 288,626 288,626 288,626 323,715 116,377 116,377

Variance 4,033,544 1,256,431 1,124,734 65,190 465,951 3,267,515 961,237 5,528,248 5,425,088 2,724,479 1,824,827 18,758 18,758 2,209,522 18,437 18,437 18,437 18,437 16,652 190,686 225,909 133,780 1,462,930

Cash-in 5,316,602 5,316,602 9,759,778 11,635,428 13,885,387 15,127,202 20,601,122 28,767,199 36,833,836 46,133,924 48,462,814 48,770,198 49,077,582 49,384,644 49,691,707 49,998,770 50,305,833 50,612,895 50,919,958 51,227,021 51,569,306 51,703,086 53,166,017

Cash-out 1,283,058 2,539,489 5,857,931 7,668,391 9,452,399 13,961,730 20,396,886 34,091,211 36,732,761 43,308,369 43,812,432 44,101,058 44,389,685 46,906,270 47,194,896 47,483,522 47,772,148 48,060,774 48,384,489 48,500,866 48,617,243 48,617,243 48,617,243

Cash Flow 4,033,544 2,777,112 3,901,847 3,967,037 4,432,988 1,165,472 204,235 5,324,012 101,075 2,825,555 4,650,382 4,669,139 4,687,897 2,478,375 2,496,811 2,515,248 2,533,684 2,552,121 2,535,469 2,726,155 2,952,063 3,085,844 4,548,774

MO

NTH

LYC

UM

ULA

TIVE

0

2,000,000

4,000,000

6,000,000

8,000,000

10,000,000

12,000,000

14,000,000

16,000,000S

ep-1

0

Oct

-10

Nov

-10

Dec

-10

Jan-

11

Feb-

11

Mar

-11

Apr

-11

May

-11

Jun-

11

Jul-1

1

Aug

-11

Sep

-11

Oct

-11

Nov

-11

Dec

-11

Jan-

12

Feb-

12

Mar

-12

Apr

-12

May

-12

Jun-

12

Jul-1

2

MONTH

Mon

thly

0

10,000,000

20,000,000

30,000,000

40,000,000

50,000,000

60,000,000

Cum

mul

ativ

e

Cash-In Cash-Out

Cash-in Cash-out

Cash Flow

File:Cash Flow Page 1 of 1 Printed On:10/20/10 at 12:50 PM


Section 3.12

Project Cash Liquidity


District Cooling Plant for Rihan HeightsThe Project Cash Liquidity

0

50

100

150

200

250

300

350

400

450

500

550

600

Sep-

10

Oct

-10

Nov

-10

Dec

-10

Jan-

11

Feb-

11

Mar

-11

Apr

-11

May

-11

Jun-

11

Jul-1

1

Aug

-11

Sep-

11

Oct

-11

Nov

-11

Dec

-11

Jan-

12

Feb-

12

Mar

-12

Apr

-12

May

-12

Jun-

12

Jul-1

2

Months

Cash in & Cash out * (100,000)

(240)

(220)

(200)

(180)

(160)

(140)

(120)

(100)

(80)

(60)

(40)

(20)

0

20

40

60

80

Cash Net Datum

Cash Net * (100,000)

Cash net Cash in Cash out