PPP coursera final project

Page 1

Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Point of Comparison

participants

Investor

BOT Airports

ID

4

Reference

El Alamein Airport

Marsa Alam Airport

International Airport Company (IAC)

EMAK Marsa Alam for Management and Operation of Airports

subsidiary of Kato Group, was established to bid for the tender of Al Alamien international airport. It got the tender with a 50 year BOT concession, extendable to 99 years.

subsidiary of El Kharafi Group for development, was established to bid for the tender of Marsa Alam international Airport. It got the tender with 40 years BOT concession, it is a part of EMAk Marsa Alam Group which is responsible for development in Marsa Alam in different aspects (Airport Operation, Construction,Touirsm and Real Estate Development)

Al Alamein International Airport Brochure, International Airport Company, 2006

Consultant Designer

5

Contractors

6

BOT Contract Duration

Main Contractor

Kato Group for Contracting Nile Company for Contracting and Roads

Dr. Ahmed Abd El-Warith Consultants, Al Alamein airport feasibility study, 1998

7

Reference

Reference

Time Schedule

Contract

Performed

4 years

Construction Period

15 years

Period after which the project can start to profit and benefit from the Egyptian government revenue

11 years

Period after which the project can start to profit and benefit from the Egyptian government revenue

31 years

Concession Period

25 years

Concession Period

Total BOT Contract

40 Years

Total BOT Contract

construction 1998

1st phase 2002

.1999 ‫ لعام‬53 ‫ و عدد‬1998 ‫ لعام‬264 ‫ عدد‬،‫ ملحق الوقائع المصرية‬،(BOT) ‫عقد منح التزام و إنشاء و تشغيل مطار مرسى علم الدولى بنظام‬

2nd phase 2015

3rd phase 2028

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

construction 2001

9

Reference

Time Schedule Graph

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

Construction Period

Dr. Ahmed Abd El-Warith Consultants, Al Alamein airport feasibility study, 1998

9

1st phase 2005

3rd phase NA

Estimated study cost 120 Million LE

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Airport Cost

1st phase 2001

2nd phase 2009

3rd phase NA

Marsa Alam Airport succeeded to start the operation of the airport in first phase few months earlier than scheduled. It also succeeded to start the second phase 4 years before the time scheduled for this phase

initial cost estimated 80 Million LE

Estimated study cost 120 Million LE

Construction Cost

12

cost of construction 300 Million LE

total cost NA

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

Construction Cost

170 Million LE

320 Million LE

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010

Airport Cost Estimated‐Marsa Alam

Comment

Comment

350

160 300

140

initial cost of Airport was near the estimated cost of the project which was increased due to the additional projects related to the airport. Performed cost was increased by 40 million LE and was Late 4 years

120

Airport Cost Graph

13

100 80 60 40 20 0 intial Cost

Reference

Project Finance Financial Study

Comment

total cost NA

180

Performed Porject Cost

40 % Self Financing

15

Flight Revenues

Advertisements

Airlines Companies

Free Duty Market

Traveling Agencies

VIP Center

Passengers

Ghazala Bay Resort

Advertisements

Airlines Companies

Parking spots

Local Integrated Market

Cafeteria

Free Duty Market

Traveling Agencies

Advertisement

Cargo Village

Agriculture land

VIP Center

Passengers

industrial & commercial park

Exchange House

Advertisement

Status

include storage, refrigeration, warehousing center

Postponed

Diving Training Center

Training diving center equipped with latest tech.

2nd Phase Constructed

Postponed

Harbor Yacht Club

it accommodate 1000 yachts with different scales

2nd Phase Constructed

Postponed

International Conference Center

Conference Center opposite to Port Ghalib under construction

constructed

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

2500

25000

50000

Hotel capacity (by room) Est.

250

1200

NA

Hotel capacity (by room) Per.

Year

2005

2010

2015

9363

17428

31041

10156

27946

NA

Estimated/Performed Hotel Capacity‐ Marsa Alam

Comment

Performed

Estimated 50000

hotels and resorts along the north coast is extremely under estimated hotel capacity for Al Alamein

40000 25000

20000

1200 Y/2010

Water desalination, Sewage treatment plant, central, medical center, stores, sporting club for residents of region

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

50000

Not Performed Yet Y/2015

45000 40000 35000 30000 25000 20000 15000 10000 5000 0

Comment

Performed Not Performed yet

27946

10156

Hotels and resorts around the airport along the north coast is expected to reach to 17428 room in 2010

31041

it will be doubled during the period from 2010 to 2015

17428

9363 Y/2005

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Y/2010

Y/2015

Tourism Development Authorities, Ministry of Tourism, Report on Tourism in Red Sea, December 2009

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

19

Port Ghalib Marina

Hotel capacity (by room) Est.

250 Y/2005

Cafeteria

Status

Hotel capacity (by room) Per.

2500

Gas Station

2nd Phase Constructed

2015

0

Related projects

Project Description

2010

10000

Parking Projects

30,000 sq. m contains 3 hotels with total cost 200 million

2005

60000

Flight Revenues

Related project

Canceled due to 4 hotels and resort located near the airport location in range of Service Facilities Dabaa Plant

Estimated/Performed Hotel Capacity‐ Al Alamein

Airport Traffic Estimated

Arrival and Departure Halls

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

1st Phase Constructed

Estimated

60% Loans

Cargo Village

Year

30000

Performed Porject Cost

Related projects

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Reference

Estimated Project cost

Parking spots

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

18

intial Cost

Parking Projects

total area 25km2 geared towards export Industrial & Commercial to western markets 16 park 16 km2, perform additional export to Organic agriculture land are European markets

Hotels And resort

Hotel Rooms Graph

0

40 % Self Financing

Project Description

Cargo Village

17

50

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

1st Move pick on North Coast, 19 km from airport with 2500 room

Related project

No. of Hotel Rooms

100

60% Loans

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Reference

150

Project Finance

Exchange House

Related Projects to Airport Facility

200

prepared by the researcher

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Arrival and Departure Halls

Initial Cost of the airport was significantly small. The estimated cost of project increased due to the additional development projects related to the airport project. Performed cost was increased by 20 million LE and was before schedule by 4 months.

250

Project Finance

14

Reference

Fiscal Revenue

Estimated Project cost

prepared by the researcher

Reference

Related Projects

3rd phase 2026

prepared by the researcher

Airport Cost Estimated‐Al Alamein

Hotel Rooms To be served

construction 1998

Al Alamein Airport was delayed in start of construction phase due to problems concerning land acquisition with ECAA. It was ended in 2001 and started to construct the airport

initial cost estimated 72 Million LE

11

Reference

Feasibility study

2nd phase 2013

Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010

prepared by the researcher

Reference

BOT Agreement

1st phase 2002

10

Reference

Performed

construction 1998

.1999 ‫ لعام‬53 ‫ و عدد‬1998 ‫ لعام‬264 ‫ عدد‬،‫ ملحق الوقائع المصرية‬،(BOT) ‫عقد منح التزام و إنشاء و تشغيل مطار مرسى علم الدولى بنظام‬

2nd phase NA

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Comment

Estimated

Netherlands Airports Consultants (NACO) Egyptian Consultants Group (ECG) Main Contractor Nile Company for Contracting and Roads Roads and runways Arab Contractors Interior Contractor

4 years

50 Years

Estimated

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

A.C.C

Roads and runways Reference

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

BOT Airports Evaluation

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

Year

Flights Estimated

Flights Performed

Status

Year

2002

195

0

-195

2002

Flights Estimated 840

Flights Performed

2006

474

277

-197

2007

3750

4891

1141

2015

975

NA

NA

2010

9370

11054

1684

1235

Status 395


Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Point of Comparison

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

BOT Airports Evaluation

BOT Airports

ID

El Alamein Airport

Marsa Alam Airport

Estimated /Performed Flights‐Al Alamein Flights Estimated

Estimated /Performed Flight Rate ‐Marsa Alam

Comment

Flights Performed

1200

Flights Estimated

20

Flights Performed

12000

975

11054

10000

800 Not Performed yet

600 474

400 200

277

195

0

0 year 2002

year 2006

Al Alamein Airport could not afford Estimated Flights due to the delay in construction project and Lack of hotels around the airport

Flights

Airport Traffic Estimated Graph

Flights

1000

9370

8000 4891 3750

4000

0

1235 840 year 2002

year 2015

year 2007

Passenger Traffic Estimated

Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

21

Pax. Estimated

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

Pax. Performed

Status

Year

62,400

0

-62400

2002

94200

169600

75400

17723

-133981

2007

200400

642807

442407

2015

312,226

NA

NA

2010

403200

938858

535658

Estimated/Performed Pax.‐Marsa Alam

Comment

Pax. Performed

Pax. Estimated

250000 200000 151704

150000

Not Performed Yet

100000

0

62400 0 year 2002

17723 year 2006

year 2015

Year

Reference

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010 Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Al Alamein airport Pax. Performed witnessed remarkable retard behind estimated Pax. Due to Late in implementation of airport and lack of tourism attraction potentials around airport

Axis Title

312226

300000

50000

Status

151,704

350000

22

Pax. Performed

2006

Pax. Estimated

Passenger Traffic Estimated Graph

Pax. Estimated

2002

Estimated/Performed Pax.‐Al Alamein

Pax.

Operation

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Year

year 2010

Year

Year

Reference

Marsa Alam Succeeded to afford estimated flights due to the great potentials around the airport

6000

2000

Comment

1000000 900000 800000 700000 600000 500000 400000 300000 200000 100000 0

Comment

Pax. Performed 938858

Marsa Alam Airport Succeeded to exceed estimated Pax. By almost the double

642807 403200 169600 94200 year 2002

200400

year 2007

year 2010

Axis Title Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010 EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

due to enrichment of Tourism movement around the airport which affected mutually with each other


Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Point of Comparison

Governmental Operated Airports

ID

Airport City

Governorate

Main Activity

2

3

Reference

Architecture data

El Alamein Airport

Marsa Alam Airport

60 kilometers to the south west of Alexandria

240 kilometers west of Alexandria

600 kilometers from Cairo

106 kilometers west of Alexandria

280 South of Hurghada City

7 kilometers from the shore of Mediterranean sea

22 kilometers from Sallum

82 kilometers along the Red Sea shore

240 Kilometers north west of Cairo

65 kilometers along Red Sea Shore

Alexandria Governorate

Matruh Governorate

Red Sea Governorate

Matruh Governorate

Red Sea Governorate

Touristic investments

Touristic investments

Touristic investments

Touristic investments

Touristic investments

Industrial investments

Diving - Wind Surfing

Historical Sites

Resort Beach

Residential investments

Resort Beaches

Aquatic sports (Wind Surfing, Sailing, Deep sea fishing, Snorkeling and diving)

1

Ministry of Trade & Industry, Alexandria international trade point website, Overview, http://www.alextp.gov.eg/borgloc.html, Accessing (28-042010)

3

Ministry of Trade & Industry, Alexandria international trade point website, City Plane, http://www.alextp.gov.eg/borgplane.html, Accessing (28- Official site for Marsa Matruh Governorate, 04-2010) http://www.matrouh.gov.eg/matrouhsite/egypt.htm/, Accessing 29-5-2011

Official site for Marsa Matruh Governorate, http://www.matrouh.gov.eg/matrouhsite/egypt.htm/, Accessing 29-5-2010

4

Airport Area

Airport Capacity

Airport Area

Airport Capacity

43.69 Kilometers square

600 Pax. / Hour

15.54 Kilometers square

300 Pax. / Hour

Airport Location

Airport Type

Airport Location

Airport Type

43 Km south west of Alexandria East of New Borg El Arab City

International

1.1 sea miles to the south west of the city

Local (opened international flights in 2006)

Airport History

Airport Mission

Airport History

Airport Mission

the Egyptian civil authority started in 1998 to study the possibility of establishing another international airport at Borg El Arab city on part of Borg El Arab Military air base land

To ease the traffic congestion at Alexandria Airport, it will be the replacement of El Nozha international Airport in Alexandria

one of the airports that was delivered to the Egyptian civil company from the English army in 1945. it is operating now for both Military and civil

To serve the Western shores of Mediterranean Sea for Egypt. It is considered the west gate for Egypt.

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/about_comp.aspx 12/4/2010

Reference

Airport Perspective

Hurghada Airport

1

Reference

Airport General Data

BOT Airports

Marsa Matruh airport

Borg El-Arab Airport

Location

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

Airports Evaluation

Worldwide Diving Center

Resort Beach

Official Site for Hurghada City, Site http://www.hurghada-tourism.com/index-ar.php?menu=1, Accessing 29-5-2010.

Official Site for El Alamein City, Maps http://www.el-alamein.world-guides.com/el_alamein_maps.html, 5/5/2010

Wikipedia Marsa Alam city, http://en.wikipedia.org/wiki/Marsa_Alam, Accessing (5/5/2010)

Official Site for Hurghada City, Touristic Features http://www.hurghada.com/index.aspx, Accessing 8/5/2010

Official Site for El Alamein City, Historical Visits, http://www.el-alamein.world-guides.com/el_alamein_landmarks.html, Accessing (5/5/2010)

Marsa Alam Official site, www.marsaalam.co.uk/, Accessing (10/5/2010)

Airport Area

Airport Area

40.3 km Square

21 km square

Airport Capacity

Airport Capacity

2500 Pax. / Hour

600 Pax. / Hour

Airport Location

Airport Location

5 km to the south west of Hurghada Downtown

60 Km North of Marsa Alam city

Airport Type

Airport Type

international

international

Airport History

Airport History

in May 1966 Egypt located 102 thousand Egyptian Pound to prepare Hurghada Airport to receive jet aircrafts carrying tourists in an answer to travel agencies request to land planes arriving directly from Europe

EMAk Marsa Alam Got the tender in 1998 to construct international airport in Marsa Alam under BOT system with the supervision of ECAA. It was first inaugurated in 2001 for international

Airport Mission

Airport Area

Airport Capacity

64 kilometers square

300 Pax. / Hour

Airport Location

Airport Type

located near the coastal road and the road connecting Cairo / Alexandria desert road

international - Cargo Airport

Airport History

Airport Mission

Airport Mission

To serve the Western shores of Mediterranean Sea for Egypt. It is considered the west gate for Egypt.

To serve touristic flow directly from Europe to Red Sea Touristic sites

International Airport Company won the tender to

To serve touristic flow construct Al Alamein airport in 1998 under BOT directly from Europe system with the supervision of ECAA. It witnessed to Red Sea Touristic difficulties in land acquisition, it was inaugurated in sites

2005_4 years behind the schedule.

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site, http://www.ehcaan.com/about_comp.aspx 12/4/2010

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/about_comp.aspx 12/4/2010

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998 Kato Group Official Website, http://www.katoinvestment.com/divisions/Logistics.htm, Accessing 2/5/2010

.1999 ‫ لعام‬53 ‫ و عدد‬1998 ‫ لعام‬264 ‫ عدد‬،‫ ملحق الوقائع المصرية‬،(BOT) ‫عقد منح التزام و إنشاء و تشغيل مطار مرسى علم الدولى بنظام‬ EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

5

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/about_comp.aspx 12/4/2010

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/about_comp.aspx 12/4/2010

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/about_comp.aspx 12/4/2010

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

EMAK Marsa Alam, ECAA - Marsa Alam Airport Presentation, 2001

Kato Group Official Website, http://www.katoinvestment.com/divisions/Logistics.htm, Accessing 2/5/2010

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005


Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Governmental Operated Airports

ID

6

Runway

7

Parallel Taxi

8

Terminal Building

9

Hurghada Airport

El Alamein Airport

Runway Width

Runway Length

Runway Width

Runway Length

Runway Width

Runway Length

Runway Width

Runway Length

Runway Width

Runway Length

45 meters

3400 meters

45 meters

3000 meters

45 meters

4000 meters

45 meters

3500 meters

45 meters

3000 meters

Width

Length

Width

Length

Width

Length

Width

Length

Width

Length

30 meters

3000 meters

45 meters

3000 meters

45 meters

4000 meters

30 meters

3500 meters

30 meters

3000 meters

TB Facilities

TB Area

TB Facilities

TB Area

TB Facilities

TB Area

TB Facilities

TB Area

TB Facilities

TB Area

Arrival Hall

1376.25 meters square

Arrival Hall

1570 meters square

Arrival and Departure Halls

15534 meters square

Arrival and Departure Halls

VIP Facilities

13019 meters square

Arrival and Departure Halls

VIP Facilities

2500 meters square

Departure Hall

TB Capacity

Departure Hall

TB Capacity

Free Duty zone

TB Capacity

Free Duty zone

First Aid Center

TB Capacity

Free Duty zone

First Aid Center

TB Capacity

Free Duty zone

600 Pax. / Hour

Free Duty zone

300 Pax. / Hour

Public Lounge

2500 Pax. / Hour

Public Lounge

Tour Agents

600 Pax. / Hour

Public Lounge

Tour Agents

600 Pax. / Hour

Cargo Export

Service Provided

VIP Hall

Service Provided

Airlines Facilities

Service Provided

Airlines Facilities

Banking

Service Provided

Airlines Facilities

Banking

Service Provided

Electronic Check-In Counters

Departure Lounge

Electronic Check-In Counters

Departure Lounge

inspection points

Electronic Check-In Counters

Departure Lounge

inspection points

Electronic Check-In Counters

Visa Counters

Food and Beverage

gov. facilities

Visa Counters

Food and Beverage

gov. facilities

Visa Counters

information center

cargo facilities

Electronic Check-In Counters Visa Counters computerized counters EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

Reference

No. of Phase

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

Planned Delivery of Phase

Performed Delivery of Phase

Status

No. of Phase

Planned Delivery of Phase

Performed Delivery of Phase

Status

NA

2006

NA

No. of Phase

EMAK Marsa Alam Airport Company, International Marsa Alam Airport Brochure, October 2005

No. of Phase

Planned Delivery of Phase

Performed Delivery of Phase

Status

1st Phase

2005

2007

Behind 2 years

1st Phase

2002

2005

Behind 4 years

1st Phase

2002

2001

Advanced 4 Months

2nd Phase (Current)

2015

NA

NA

2nd Phase

2015

NA

NA

2nd Phase

2013

2009

Advanced 4 Years

3rd Phase

2024

NA

NA

3rd Phase

NA

NA

NA

3rd Phase

2028

NA

NA

3rd Phase

2026

NA

NA

1st Phase

Planned/Performed Expansion Plan Hurghada

Not Performed Yet

2016

2014

2012

NA

Current

2010

Year

Year

Expansion Development

Status

NA

Estimated Delivery Performed Delivery

2009

2018 2016 2014 2012 2010 2008 2006 2004 2002 2000 1998

Planned/Performed Expansion Plan Alamein

Not Preformed Yet 2015

2007 Estimated Delivery Performed Delivery

2005

Planned/Performed Expansion Plan Marsa Alam

Not Performed Yet

2035 2030 2025 2020 2015 2010 2005 2000 1995 1990 1985

2028 Not Performed yet 2015 Estimated Delivery

2005 2002

Performed Delivery

2030 2025 2020 2015 2010 2005 2000 1995 1990 1985

2026 Not Performed yet 2013 2009

2002

Estimated Delivery

2001

Performed Delivery

1st Phase (Current)

2nd Phase

1st Phase

2nd Phase (Current)

1st Phase

2nd Phase

3rd Phase

1st Phase

2nd Phase

3rd Phase

Estimated Delivery

2009

2014

Estimated Delivery

2005

2015

Estimated Delivery

2002

2015

2028

Estimated Delivery

2002

2013

2026

Performed Delivery

2010 Current

2016

Performed Delivery

2007

2017

Performed Delivery

2005

2018

2031

Performed Delivery

2001

2009

2022

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

No. of Phase

Planned Cost of Phase

Performed Cost of Phase

Status

Planned Cost of Phase

Performed Cost of Phase

Status

No. of Phase

Planned Cost of Phase

Performed Cost of Phase

Status

1st Phase

52 Million USD

NA

NA

NA

NA

NA

1st Phase

60 Million USD

115 Million USD

Almost Doubled

No. of Phase 1st Phase

Egyptian Airport Company Official Website, http://www.eac-airports.com/OurAirports_BorgElarab.aspx, Accessing 12/5/2010

12

Investment

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010

No. of Phase

Planned Cost of Phase

Performed Cost of Phase

Status

1st Phase

120 Million LE

170 million LE

Increased by 42 %

Zawya Network, Major Airport Projects in the MENA Region, August 2005.

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

ACI World with Corporation of Momberger airport information, Airport Development News, February 2010

Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Planned Cost of Phase

Performed Cost of Phase

Status

1st Phase

300 Million LE

320 Million LE

Increase by 6.6 %

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996 Meeting with Eng. Abd El Aal El Zarie, Deputy Manager of Marsa Alam Airport, April 2010

Terminal Building Capacity

No. of Phase

Terminal Building Capacity

No. of Phase

Terminal Building Capacity

No. of Phase

Terminal Building Capacity

No. of Phase

1st Phase

600 Pax. / Hour

1st Phase

300 Pax. / Hour

1st Phase

2500 Pax. / Hour

1st Phase

600 Pax. / Hour

1st Phase

600 Pax. / Hour

2nd Phase

1000 Pax. / Hour

2nd Phase

4700 Pax. / Hour

2nd Phase

1200 Pax. / Hour

2nd Phase

1200 Pax. / Hour

3rd Phase

NA

3rd Phase

NA

3rd Phase

2000 Pax. / Hour

3rd Phase

2000 Pax. / Hour

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

2007

2010

2015

4127

6804

NA

NA

NA

NA

Investment

72 project

80 project

NA

No. of projects

Hotel Capacity (by rooms)

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

2007

2010

2015

4881

14811

NA

NA

NA

NA

47 project

83 project

NA

2007

2010

2015

35027

28935

51185

Investment

NA

5663 million LE

8360 million LE

No. of projects

NA

86 Project

149 project

Hotel Capacity (by rooms)

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

Hotel Capacity (by rooms) Investment No. of projects

Borg El Arab witnessed large rise in hotel capacity

Ministry of Tourism, Report on Tourism in Egypt, 2007

Comment

Marsa Matruh has large potentials in tourism, it witnessed remarkable Comment rise in hotel capacity

Ministry of Tourism, Report on Tourism in Egypt, 2007

Hurghada witnessed remarkable development in tourism movement that exceeded expectations for this area

Tourism Development Authorities, Ministry of Tourism, Report on Tourism in Red Sea, December 2009

Terminal Building Capacity

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

2007

2010

2015

206

206

2500

NA

NA

NA

Investment

1 project

1 project

NA

No. of projects

Hotel Capacity (by rooms)

4 projects were postponed due to the location of these hotels is near El Dabaa necular plant in Egypt, this led to delay of these projects that affected tourism in Al Alamein

16 Comment

No. of Phase

No. of Phase

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

No. of projects

Reference

Performed Delivery of Phase

Behind 1 years

Hotel Capacity (by rooms)

No. of Hotel Rooms

Planned Delivery of Phase

NA

2004

Reference

No. of Phase

current

2006

Terminal Building Capacity

Status

2009

2014

Reference

Performed Delivery of Phase

2014

2018

11

Kato Group Official Website, http://www.katoinvestment.com/divisions/Logistics.htm, Accessing 2/5/2010

Planned Delivery of Phase

1st Phase (Current)

2008

Airport Expansion Cost

P.M.P. Services, Marsa Alam Airport Feasibility study, 1996

2nd Phase

10

Reference

information center

Dr. Ahmed Abd El-Warith Consultants, Al Alamein feasibility study, 1998

EGYPTIAN HOLDING COMPANY FOR AIRPORTS AND AIR NAVIGATION (EHCAAN) Official site http://www.ehcaan.com/main_airports.aspx, Accessing 12/4/2010

Planned/Performed Expansion Plan ‐ Borg El Arab Airport Expansion Time schedule

Marsa Alam Airport

Year

General Data

Borg El-Arab Airport

Airport Layout

BOT Airports

Marsa Matruh airport

Year

Point of Comparison

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

Airports Evaluation

Comment

2007

2010

2015

4746

5337

36528

840 million LE

2319 million LE

NA

NA

56 Project

123 project

Marsa Alam witnessed remarkable development in tourism movement that exceeded expectations for this area Comment

Tourism in North Coast depends on local tourism in resorts and hotels that are focused in summer semester (June, July, August, September) Meeting with Eng. Hamdi Abd El Azim, General Manager of Al Alamein Airport, April 2010

Marsa Alam Airport and Tourism Development in Marsa Alam has large mutual influence on each other that enriched both Tourism Development Authorities, Ministry of Tourism, Report on Tourism in Red Sea, December 2009


Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Governmental Operated Airports

Point of Comparison

Marsa Alam Airport 1

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.4

0.2

0.2

0.4

0.4

0.4

0.2

0.2

0.2

0 YEAR 2007

YEAR 2008

0

YEAR 2009

YEAR 2005

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2009

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2009

YEAR 2005

YEAR 2006

Years

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2009

1

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6 Rating

Rating

0.8

0.4

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

YEAR 2005

YEAR 2006

YEAR 2007

YEAR 2008

0

YEAR 2009

0

0 YEAR 2005

YEAR 2006

Years

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2009

YEAR 2006

Years

YEAR 2008

1

0.8

0.8

0.6

0.6

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2009

1

1

0.8

0.8

0.8

0.6

0.6

0.6

Rating

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0 YEAR 2005

YEAR 2006

YEAR 2007

YEAR 2008

0

YEAR 2009

YEAR 2005

YEAR 2006

Years

YEAR 2007

YEAR 2008

YEAR 2009

0 YEAR 2005

YEAR 2006

Years

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2009

YEAR 2005

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

Rating

Rating

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0

0

year 2009

Year 2005

year 2006

year 2007

year 2008

Year 2005

year 2009

0.6

0.6

0.6

Rating

Axis Title

0.6

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0

0 YEAR 2005

YEAR 2009

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2009

YEAR 2006

Years

YEAR 2007

YEAR 2008

1

1

0.8

0.8

0.6

0.6

YEAR 2005

YEAR 2006

YEAR 2008

YEAR 2005

YEAR 2009

1

1

0.8

0.8

0.8

0.6

0.6

0.6

Rating 0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0

0 YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2009

YEAR 2005

YEAR 2006

Years

YEAR 2007

YEAR 2008

0 YEAR 2005

YEAR 2009

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2005

YEAR 2006

YEAR 2007

YEAR 2008

YEAR 2009

YEAR 2005

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.2 0 year 2006

Year 2007

Year 2008

Year 2009

Year 2005

year 2006

Years

Year 2007

Year 2008

Year 2005

Year 2009

year 2006

Year 2007

Year 2008

year 2006

Year 2007

Year 2008

Year 2009

Year 2005

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

Rating

0.2

0.2

0.2

0 year 2006

year 2007

year 2008

0.4

0.4

0.2

0.2

0

0 year 2005

year 2009

year 2005

year 2006

Years

year 2007

year 2008

year 2006

year 2007

year 2008

year 2009

year 2005

year 2006

Years

year 2007

year 2008

year 2005

year 2009

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

Rating

Rating 0.4

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0 Year 2007

Year 2008

0

Year 2009

Year 2005

Year 2006

Year 2007

Year 2008

0 Year 2005

Year 2009

Year 2006

Years

Year 2007

Year 2008

Year 2005

Year 2006

Year 2007

Year 2008

Year 2005

Year 2009

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.2

0.2

0

0.2

0 Year 2005

Year 2006

Year 2007

Year 2008

Year 2009

0.4 0.2

0 Year 2005

Year 2006

Years

Year 2007

Year 2008

Year 2009

Rating

0.8

Rating

1

Rating

1

0.4

Year 2006

Years

Year 2007

Year 2008

Year 2009

Year 2006

Years

Year 2007

Year 2008

Year 2009

Year 2005

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

Rating

Rating 0.4

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0

0 Year 2008

Year 2009

Year 2005

Year 2006

Year 2007

Year 2008

Year 2006

Year 2007

Year 2008

Year 2009

Year 2005

Year 2006

Years

Year 2007

Year 2008

Year 2005

Year 2009

1

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0 Years

Year 2008

Year 2009

0 Year 2005

Year 2006

Year 2007 Years

Year 2008

Year 2009

0 Year 2005

Year 2006

Year 2007 Years

Year 2008

Year 2009

Year 2009

Year 2008

Year 2009

Rating

0.4

Year 2007

Year 2008

1

Rating

Rating

Rating

1

Year 2006

Year 2007 Years

1

Year 2005

Year 2006

Years

1

0

Year 2009

0

0 Year 2005

Year 2009

Years

Year 2008

Rating

0.8

Rating

0.8

Rating

1

Years

Year 2007 Years

1

Year 2007

Year 2006

Years

1

Year 2006

Year 2009

0 Year 2005

1

Year 2005

Year 2008

0.2

1

0

Year 2007

0.4

0 Year 2005

year 2009

Years

1

0.4

Year 2006

Years

1

0.4

year 2008

0

Year 2009

Years

1

Rating

Rating

Years

year 2007

Rating

1

Rating

1

Rating

1

Year 2006

Year 2009

Years

1

Year 2005

year 2006

Axis Title

1

0

Year 2008

0

0 year 2005

year 2009

Years

Year 2007

Rating

0.8

Axis Title

1

Rating

1

Rating

1

0.4

YEAR 2009

Years

1

0.4

year 2006

Years

1

0.4

YEAR 2008

0 Year 2005

Year 2009

YEAR 2007

0.2

Years

Years

YEAR 2009

0.4

0

0

0 Year 2005

0.4 0.2

0.2

0.2

Rating

0.8

Rating

0.8

Rating

1

Rating

1

Rating

1

0.4

YEAR 2008

Years

1

0.4

YEAR 2006

Years

1

0.4

YEAR 2007

0

YEAR 2009

Years

Years

year 2009

Years

0.4

YEAR 2005

YEAR 2006

Years

Rating

Rating

YEAR 2007

0.4

0

year 2007

0

0

YEAR 2009

Years

1

year 2006

Years

0.8

Years

Rating

year 2008

0.8

0 YEAR 2008

year 2007 Years

Rating

0.2

year 2006

0.8

Rating

Rating 0.4

Year 2005

0.8

0.6

year 2008

0

year 2009

1

0.8

YEAR 2007

year 2008

Years

1

1

YEAR 2006

year 2007

YEAR 2009

0.2

1

1

YEAR 2005

year 2006

YEAR 2008

0.4

0 Year 2005

year 2009

Years

YEAR 2007

Rating

year 2008

Years

Axis Title

0.8

Rating

1

Rating

1

year 2007

YEAR 2009

Years

1

year 2006

YEAR 2006

Years

1

Year 2005

YEAR 2008

0

YEAR 2009

Years

1

0

YEAR 2007 Years

0.4

0

YEAR 2006

Years

Rating

Rating

1

YEAR 2009

0 YEAR 2005

YEAR 2009

Years

1

Rating

YEAR 2007

YEAR 2008

Rating

0

YEAR 2007 Years

1

1

YEAR 2006

Years

1

1

Rating

0

0 YEAR 2005

Years

Rating

YEAR 2006

Rating

0

Rating

Rating 0.4

Rating

1

Rating

1

Rating

International Flight share rate Domestic Flight share rate Total Passengers share rate International passengers share rate Domestic passenger share rate Total flights per floor area rate International flights per floor area rate Domestic flights per floor area rate Total passengers per floor area International passenger per floor area rate

El Alamein Airport

1

Years

Domestic passengers per floor area

Hurghada Airport

1

YEAR 2005

Airport share rate

BOT Airports

Marsa Matruh airport

Rating

Total flights Share rate

Borg El-Arab Airport

Airport Share per floor area rate

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

Statical Evaluation

0

Year 2005

Year 2006

Year 2007 Years

Year 2008

Year 2009

Year 2005

Year 2006

Year 2007 Years


Public‐Private Partnerships (PPP): How can PPPs help deliver better services? Coursera Online Course Final Project Governmental Operated Airports

Point of Comparison

Marsa Matruh airport

Hurghada Airport

El Alamein Airport

Marsa Alam Airport

100

100

100

100

80

80

80

80

80

40

20

60 40

20

0

Hurghada Airport

60 40

20

0 range 1 range 2 range 3 range 4 range 5 range 6 range 7 Ranges

60

20

0 range 1 range 2 range 3 range 4 range 5 range 6 range 7 Ranges

0 range 1 range 2 range 3 range 4 range 5 range 6 range 7 Ranges

range 1 range 2 range 3 range 4 range 5 range 6 range 7 Ranges

100

100

100

80

80

80

80

80

40

20

20

0

60 Hurghada Airport

40

60 40

20

0

Al Alamein Airport

60

Rating

Marsa Matruh Airport

Rating

40

60

Rating

Borg El Arab Airport

Rating

100

Rating

100

60

Marsa Alam Airport

40

20

0

Marsa Alam Airport

40

20

0

range 1 range 2 range 3 range 4 range 5 range 6 range 7 Ranges

Al Alamien Airport

Rating

Marsa Matruh Airport

Rating

40

60

Rating

Borg El Arab Airport

Rating

Rating

60

20

0

0

range 1 range 2 range 3 range 4 range 5 range 6 range 7

range 1 range 2 range 3 range 4 range 5 range 6 range 7

range 1 range 2 range 3 range 4 range 5 range 6 range 7

range 1 range 2 range 3 range 4 range 5 range 6 range 7

range 1 range 2 range 3 range 4 range 5 range 6 range 7

Ranges

Ranges

Ranges

Ranges

Ranges

20 Mean

18

Mode

35

Median

Median

Mode

16 12

Median

15

8 6 4 2

4

5

2

R (600‐514) R (514‐428) R (428‐342) R (342‐256) R (256‐170) R (170‐84)

30 Median

R (164‐144) R (144‐124) R (124‐104) R (104‐84)

R (84 ‐ 0)

R (84‐64)

R (64‐44)

45

Mode

Median

40

25

Mode

25 15

20 Mean

15

10

R (19K‐16K) R (16K‐13K) R (13K‐11K) R (11K‐8K)

R (8K ‐ 0)

R (3160‐ 2750)

R (2750‐ 2340)

R (8K‐6K)

R (6K‐3K)

8

15

6

10

4

5

2 0

0 R (175‐150) R (150‐125) R (125‐100) R (100‐75)

R (75‐50)

R (50‐25)

18

Median

Mode

35

Mean

R (870‐774) R (774‐678) R (678‐582) R (582‐486) R (482‐390) R (390‐294) R (294‐198)

R (25‐0)

Mode

Mode

16 14

30

Median Mean

12

10

25

8

20

6

15

10 8 Median

6

Mean

4

10

2

5 R (760K‐ 696K)

R (3K‐940)

R (696K‐ 632K)

R (632K‐ 568K)

R (568K‐ 504K)

R (504K‐ 440K)

R (440K‐ 376K)

R (376K‐ 312K)

0

0 R (9K‐8K)

R (8K‐6K)

R (6K‐5K)

R (5K‐4K)

R (4K‐2K)

R (2K‐1K)

R (115K‐ 102K)

R (1K‐0)

18

18

18

18

18

16

16

16

16

16

14

14

14

14

14

12

12

12

12

12

10

10

10

10

10

8

8

8

8

8

6

6

6

6

6

4

4

4

4

4

2

2

2

2

2

0

0

0

0

0

1

1

1

1

1

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.4

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0

0

0

0

0

1

1

1

1

1

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.4

0.4

0.4

0.4

0.4

0.2

0.2

0.2

0.2

0.2

0

0

0

0

0

1

1

0.8

0.8

0.8

0.8

0.8

0.6

0.6

0.6

0.6

0.6

0.2

0.4 0.2

0

0.2

0 Year 2005

Year 2006

Year2007 Years

Year 2008

Year 2009

0.4

Year 2006

Year2007 Years

Year 2008

Year 2009

0.4 0.2

0 Year 2005

Rating

1

Rating

1

Rating

1

0.4

Median

10

40

16

0

0 R (59K‐50K) R (50K‐42K) R (42K‐33K) R (33K‐25K) R (25K‐16K) R (16K‐8K)

R (3570‐ 3160)

2

5

0

R (3980‐ 3570)

4

Mean

10 5

R (4390‐ 3980)

12

30

20

R (4800‐ 4390)

14

35

Mean

20

R (5210‐ 4800)

R (44‐24)

Mean

12

0

0

0

16 14

25

6

Mean

10

Median

30

8

10

Mode Mode

35

Mean

10

20

18

40

Mode

12

25

14

16 14

30

Rating

Passengers frequency distribution bar chart Mean Monthly Passengers Airport Passengers / Month . Airport Airport Passengers / Month . Hotel m2 Capacity Airport revenue analysis

BOT Airports

100

Rating

Flights frequency distribution bar chart

Passengers cumulative frequency distribution

Cumulative frequency distribution

Flights cumulative frequency distribution

Borg El-Arab Airport

Frequency distribution bar chart

Arch. Walid Elshmay Teacher Assistant At German University in Cairo Egypt

Statical Evaluation

Year 2006

Year2007 Years

Year 2008

Year 2009

0.4 0.2

0 Year 2005

R (102K‐ R (88K‐74K) R (74K‐60K) R (60K‐46K) R (46K‐32K) R (32K‐19K) 88K)

0 Year 2005

Year 2006

Year2007 Years

Year 2008

Year 2009

Year 2005

Year 2006

Year2007 Years

Year 2008

Year 2009


Turn static files into dynamic content formats.

Create a flipbook
Issuu converts static files into: digital portfolios, online yearbooks, online catalogs, digital photo albums and more. Sign up and create your flipbook.