20 Kasım 2017 Pazartesi

PASSANGER FORCASTING


AUTHORS: Bilgesu Caferoğlu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)



PASSANGER FORCASTING OF IBERIA AIRLINES

The aim of this assignment is to forecast the number of passengers for one year. First of all in this assignment of Iberia Airlines, we rather used the Passenger Load Factors  instead of using the actual passenger numbers for 2 reasons:

  Firstly, since iberia merged with British airways and became a part of International Air Group, the detailed statistics are published not by each airline but as a group instead, and the only airline-based information available was load factors instead of actual passenger numbers, which is much cleaner and less detailed in the traffic stats reports of International Air group. You can see an example of 2016 here:   http://phx.corporate-ir.net/External.File?item=UGFyZW50SUQ9MzYyNTY1fENoaWxkSUQ9LTF8VHlwZT0z&t=1&cb=636195712997022513

  Second reason is the only reliable source and also the truest information source is the airline itself. So we really wanted to use the information directly coming from the airline’s yearly traffic stats instead of anything we could find online but not confirm.


  Scatter Pattern of Load Factors for past 10 Years














  Linear Scatter Pattern of Load Factors for past 10 Years







Exponential Scatter Pattern of Load Factors for past 10 Years



Since the passanger load factor is increased from 2014 to 2016, we can estimate that 

load factor is going to be increased in 2017. Despite the increasing slope is quite  

steeper  between 2014 and 2015, it is decreased between 2015 and 2016. Therefore in 

2017, we  expect close numbers of load factor to 2016. We can basically say that load 

factor  iaround 83% in 2017.

We think using the exponential graphics is more appropriate for estimating becasue in 
exponential graphic we could see the increasing or decreasing slope much more detailed.
We could see accural more easily and estimate for further years more accurately.


















29 Ekim 2017 Pazar

ANCILLARY REVENUE OF OUR AIRLINES


Authors: Bilgesu Caferoğlu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)


ANCILLARY REVENUE OF PEGASUS & IBERIA AIRLINES


This video created to introduce you about the ancillary revenue of airlines and comparision of ancillary revenue of Full Service Carrier and Low Cost Carrier. Additionally we examined one of the ancillary revenue of Pegasus Airlies in detail. Hope you enjoy it.











               TL to Euro Converter

               Pegasus Baggage Fee

               Pegasus Baggage Fee

21 Ekim 2017 Cumartesi

FUEL CASE STUDY OF OUR AIRLINES

Authors: Bilgesu Caferoğlu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)



FUEL CASE STUDY OF IBERIA & PEGASUS AIRLINES


  This video is created to tell you a little bit about airline fuel costs, and show the importance of fuel compared to other costs. It includes examples of Iberia Airlines as well as Pegasus Airlines, and suggests some ways to reduce the total costs overall profiting the airline more. Hope you enjoy it. 








              Annual Report of Pegasus Airlines 

              Currency Converter
      
              Reducing Cost

              Catering Company

15 Ekim 2017 Pazar

AMSTERDAM- REYKJAVIC ROUTE


Author: Bilgesu Caferoglu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)



AMSTERDAM- REYKJAVİC 



1)CITIES
   
                                                                                                             


 

                                                            





 




Netherlands  17,02 million (2016)                                                                           Iceland 334.252 (2016)

Amsterdam 821.752 (2015)                                                                                    Reykjavic  122.141 (2015)




 From these numbers we can understand that Amsterdam made up 4.8% of the total Netherlands population and Reykjavik made up 36.5% of the total Iceland population. While we calculate this percentage, we assume that cities populations do not increase significantly from 2015 to 2016 because we could not find exact number of population of cities for 2016. Netherlands has much more population than Iceland however most of the population of Iceland is accumulated in capitol Reykjavik.
 

2) AIRPORTS


Reykjavik has two airports. First one is Reykjavic Airport which has IATA code of RKV, ICAO code of BIRK and second one is Keflavik Internatıonal Airport which has IATA code of KEF, ICAO code of BIKF. Amsterdam has one airport called Schiphol Airpot which has IATA code of AMS and ICAO code of EHAM.


You can find the information of number of passangers in RKV, KEF and AMS from following tables;




TYPE OF PASSANGER
NUMBER OF PASSANGER
Domestic
377.672
International
39.637
Total
471.309

Table 2.1 : Reykjavic Airport (2016’s datas)


TYPE OF PASSANGER
NUMBER OF PASSANGER
Domestic
27.481
International
6.821.358
Total
6.848.839

Table 2.2: Keflavik  İnternational Airport (2016’s Data)


TYPE OF PASSANGER
NUMBER OF PASSANGER
Domestic
3.988
International
63.621.546
Total
63.625.534

Table 2.3 : Amsterdam Schiphol Airport (2016’s datas)

Let me calculate Total Air Passangers per Captia( Number of passengers at one airport, divided by the total population) for each airport by using the datas from the above items:

Reykjavic Airport  417.309/ 122.141 = 3,41

Keflavik International Airport  6.848.839/ 122.141= 56,07


Amsterdam Schiphol Airport 63.625.534/ 821.752= 77,42 

3)DIRECT FLIGHTS
There are two direct flights between Amsterdan and Reykjavic which is between AMS and KEF.

Wow Air and Iceland Air have direct flights between two cities while other airlines such as SAS, Lufthansa, ect have flights via their hubs.


4) ROUTE CAPACITY


Between Reykjavik and Amsterdam, there are 3 direct flights planned daily as shown in the table below.






And between Amsterdam and Reykjavic, there are also 3 daily direct flights.












The aircraft types used on the route are:

WOW 442: Airbus A320                                                         Icelandair 500: Boeing 767-300
WOW 446: Airbus A320                                                         Icelandair 501: Boeing 767-300WOW 443: Airbus A320
WOW 447: Airbus A320

 
   An Airbus A320 is able to carry 174 passengers while a Boeing 767-300 can carry 248. There are 4 A320 trips and 2 767 trips which means total number of passengers travelling from either end of the route can be maximum 1192.

The air distance between Amsterdam and Reykjavik is 2.041 kilometers. Using both data, we can simply calculate daily ASK which is Available Seats times Kilometers which is in this case 1192 x 2041 = 2.432.872


Since this route seems to have daily scheduled flights and nearly no competition to increase the daily trips, we can safely assume that if daily available seat kilometers in total is 2.432.872 we can find weekly, monthly and yearly ASK's by multiplying with the number of days which corresponds to :

Weekly ASK:17.030.104
Monthly ASK: 72.986.160
Yearly ASK: 887.998.280

At this point, we have something to add. To travel from Reykjavik to Amsterdam or vice versa, one has to travel an earth surface distance of 3212 kilometers which include car rides, ferries and ect. Just from this example we can see how time and effort beneficial aviation is.


5) ROUTE TRAFFIC



The graphic below represents the traffic data of the Icelandair in the year 2017.





We can calculate the Load Factor using the formula Revenue Passenger Kilometer / Available Seat Kilometer. Which then corresponds to RP/AS per route. On this route, from the ticket availability of past week per flight, we came to the assumption that daily travellers were around 980-990 pax. Then we calculated the load factor using the ASK which we found above and RPK we found with this assumption, (1192/985=82.63%) which is almost exactly the same as the official  traffic data stated above.


Sources:


5 Ekim 2017 Perşembe

SAFETY RECORD OF AIRLINES



AUTHORS: Bilgesu Caferoğlu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)




Safety Records of Iberia Airlines and Pegasus Airlines




      In this Assignment, our duty is to find the accidents and
incidents of the airlines we work on, and review their safety records
in comparison. Also, at the end of our comparison, we'll review an
accident of Iberia airlines in more detail.



      To make the comparison easier, we created some charts & tables
as following:

                                  







                         



As you can see from the tables, Pegasus Airlines have a nearly-perfect
safety record. The airline only had 2 incidents which did not result
in death of any passenger or crew member. Since the airline did not
have any accidents

 we created a summary of the incidents:

1.     On March 10, 2010, Pegasus Airlines Flight 361/A319) made an
emergecy landing at Frankfurt Airport. The flight landed safely but
blew both front nose gear tires. Runway 07/R25L was closed for 3 hours
and recovered.

2.     On February 7, 2014 Pegasus Airlines flight 751(B737) was the
victim of an attempted hijacking. The hijacker demanded to be flown to
Sochi, but flight landed safely in İstanbul.



Iberia Airlines on the other hand, has 14 accidents and 23 incidents
over the years. But the fact that Iberia Airlines existed for 90 years
while Pegasus is only 28 years-old is worth mentioning. Iberia
Airlines was found in 1927 and the airline saw through the development
of aviation, they owned many historical airplanes but continued to
develop and always stayed on track with current technology. That's why
their safety record is very reliable for past decade, since they did
not have as many occurences as they did on the early years of
aviation.


Since there are a lot of accidents/incidents that Iberia Airlines was
involved, instead of listing all of them here, we provided links for
you to reach the sources.Please click 1, 2, 3.


One of the Iberia Airlines accidents was very tragic and it really did
make us learn a lesson. So we wanted to share that one with you. On
January 7 1972, Iberia airlines Flight 602 crashed into a mountain.
The flight took of from Valencia bound for Ibiza. The aircraft was
approaching RWY 07 when it descended below 2000 ft. Reportedly,
neğither the captain nor the co-pilot noticed the dangerous descent,
as they were discudding a football match with the airport tower
controller. Flight 602 struck Mount Atalaysa approximately 90 ft below
its summit and exploded on impact. All on board was killed.




Sources: https://www.aeroinside.com/incidents/airline/iberia
             
               http://www.airsafe.com/events/airlines/iberia.htm
Attachments area

5 FEATURES OF LOW COST CARRIER VS. FULL SERVICE CARRIER


AUTHOR: Bilgesu Caferoğlu, Burcu Süeda Acar (http://burcusuedaacar219.blogspot.com.tr/)

  

    This video introduces five features of Pegasus Airlines which is Low Cost Carrier and includes comparision of these features with Iberia Airlines which is Full Service Carrier.







SOURCES:  






3 Ekim 2017 Salı

PASSANGER FORCASTING

AUTHORS: Bilgesu Caferoğlu, Burcu Süeda Acar ( http://burcusuedaacar219.blogspot.com.tr/ ) PASSANGER FORCASTING OF IBERIA AIRLINES ...