It’s me Mert. I am 23 years old Aviation Management student at Özyeğin University, in Istanbul/Turkey. In this blog you will find our group projects related to AVM 301 course. It’s my last year at University. Therefore, I found love of my life at this university so I am so lucky. 🙂
Follow my blog and enjoy !
G3 – Group Assignment: Amsterdam – Reykjavik Route
CİTİES
Currently there are 17.081.507 people living in the Netherlands. Since 1 January 2018, 833.624 people lives in Amsterdam. It is the most populated city in the Netherlands and 4.88% of the people in Netherlands live in Amsterdam. In Iceland there are currently 335.275 inhabitants. 118.918 people live in the capital, Reykjavik. 118.918 of all Icelandic people live in Reykjavik. It is clear there is a difference about the percentage living in the capitals of each country. In the Netherlands the population is scattered to multiple cities. In Iceland the majority of the inhabitants live in the capital.
AİRPORTS
Reykjavik has two airports, which have their own business area. Reykjavik Keflavik Airport serves only international routes and Reykjavik Domestic Airport only domestic routes. Amsterdam Schiphol Airport does not have domestic routes and only serves international. In the following table, the total domestic and international passengers of the three airports in Amsterdam and Reykjavik are given.
Amsterdam has in total 76,3 Air Passenger per capita and Reykjavik has in total 60,9 Air Passenger per capita. In Amsterdam there is a higher air passenger per capita, because the population of the Netherlands are spread out in different big cities. Also Schiphol Airport is an important hub for transfer flights.
DIRECT FLIGHTS
There are two airlines, WOW air and Icelandair, flying the route Amsterdam-Reykjavik. Only Reykjavik Keflavik International Airport (KEF) is served since the other airport in Reykjavik only operates domestic flights. WOW air (WW) operates every day return flights between Reykjavik and Amsterdam (table 2). On some days WOW air arrives 10 minutes later.
Icelandair (FI) operates also everyday a return flight between the two cities
ROUTE CAPACİTY
WOW air and Icelandair use different aircraft with different capacity (table 4). The flying distance and flight time remain the same. The ASK is been retrieved by multiplying the available seats with the frequency and the flight distance.
ROUTE TRAFFİC
The average general load factor of Icelandair in September 2017 was 81.0%. WOW air does not have a load-factor registered and therefore the standard 80% is used. RP and RP is been calculated using this information (table 5).
SOURCES
http://statline.cbs.nl/StatWeb/publication/?VW=T&DM=SLEN&PA=37296eng&LA=EN
http://worldpopulationreview.com/countries/iceland-population/
https://www.schiphol.nl/en/schiphol-group/page/facts-and-figures/
https://centreforaviation.com/data/profiles/airports/amsterdam-schiphol-airport-ams/traffic
https://www.isavia.is/english/about-isavia/reports-and-statistics/statistics/
12_des_2016_tolur_fyrir_vefsiduna-(1).pdf erişimi için tıklayın
https://centreforaviation.com/data/profiles/airports/amsterdam-schiphol-airport-ams/schedules
https://www.travelmath.com/from/Amsterdam,+Netherlands/to/Reykjavik,+Iceland
G7 – Group Assignmentt – Forecasting
DELTA AIRLINES PASSENGER TRAFFIC BY YEARS
2011 to 2017 (OCT)
2011 113,485 ( In Millions)
2012 116,445
2013 164,659
2014 171,350
2015 179,382
2016 183,741
2017 (OCT) 157,129 (2016 OCT Number is 154,423 ) Aready 3 million bigger than last year.
SCATTER PLOT CHART
FORECAST OF 2017
2017 estimated number of passenger boarded is 209,521 (in millions)
Calculated with excel forecast formula
LINEAR TRENDLINE
Calculated with linear trendline forecasting on excell
It shows us linear forecasting is more clear than trendline also we use it to calculate for forecasting.
A linear trend line is a best-fit straight line that is used with simple linear data sets. Our data is linear if the pattern in its data points resembles a line.
G6 – Group Assignment: Ticket Prices
This post is specifically about the ticket price differences between airlines for the same route. After watching this you will be able to understand the differences between fares. Enjoy
G5 – Group Assignment: Ancillary Revenue
Here is our video about ancillary revenue generated by airlines and how it works. Ancillary revenue is one of the most important revenue sources for LCC airlines. We prepared a video for you to get a deeper insight about ancillary revenue topic. Enjoy!
What is Ancillary Revenues ?
Revenue generated from goods or services that differ from or enhance the main services or product lines of a company. By introducing new products and services or using existing products to branch into new markets, companies create additional opportunities for growth.
Referances
Press-Release-89-Ancillary-Revenue-Top-10.pdf erişimi için tıklayın
https://www.vueling.com/en/vueling-services/supplementary-service-rates
https://en.wikipedia.org/wiki/Ancillary_revenue
http://phx.corporate-ir.net/External.File?item=UGFyZW50SUQ9MjA1NTkzfENoaWxkSUQ9LTF8VHlwZT0z&t=1
https://flightchic.com/2016/12/29/5-most-innovative-ancillary-strategies/
https://www.forbes.com/sites/gradsoflife/2017/10/19/cyber-attacks-against-you-will-get-worse/#6650b7823870
https://www.delta.com/content/www/en_US/traveling-with-us/onboard-services/food-and-beverage.html
2016-Top-10-Airline-Ancillary-Revenue-Rankings.pdf erişimi için tıklayın
G4 – Group Assignment: Fuel Cost
This video is mainly about fuel costs of the LCC and FSC airlines and how to reduce it. Hope you can benefit from it
You can reach the video via this link
https://www.dosyaupload.com/dsTf
RESOURCES
https://www.transtats.bts.gov/fuel.asp?pn=1
https://www.transtats.bts.gov/fuel.asp?pn=0&display=data4
http://blog.rusada.com/blog/five-ways-airlines-can-reduce-operating-costs
G2 – Group Assignement: 5 Features of your LCCs vs. FSC Assignment
Here is the video that me and my group members prepared to examine the differences between a low cost carrier and full service carrier.
Enjoy
FSC vs LCC
LCC : A low-cost carrier or low-cost airline (also known as no-frills, discount or budget carrier or airline, or LCC) is an airline without most of the traditional services provided in the fare, resulting in lower fares and fewer comforts. To make up for revenue lost in decreased ticket prices, the airline may charge for extras such as food, priority boarding, seat allocating, and baggage
FSC : Full service Carriers would usually have three classes of service—Economy, business and first class. The ticket price includes charges for baggage, meals, drinks etc, whether we avail them or not.
Resources
G1 : Group Assignment 1: Safety Record
Group Assignment 1: Safety RecordGroup Assignment 1: Safety Record
Accidents/Years Ratio
In this chart, you can see the ratio of total accidents over the years of history of each airline. As this chart represents Delta and American Airlines has the highest ratio of accident and Vueling airlines has the lowest ratio of accidents. We can easily indicate that, through these 5 airlines, Delta and American Airlens are the less trustable and safe airlines. In conclusion these results are shows that Delta and American Airlines are the oldest ones because of that their flight numbers are so high, in the past airport and airline safety were too low because of technology but now, improvement technologies offer us low accident rates.
It is understandable to think of the consequences of such a setback once you have identified the causes of a win. Not only is the accident an economic resource loss for both the participating airlines and the community, but also an irreplaceable loss of human life. In addition, for reasons of safety, the risk category of airlines – image and reputation damage, legal proceedings by the victim families to the airline, increased insurance premiums, job loss caused by the passengers due to the increase of the risk category of the airline will likely be transferred to other airlines and if the crew is injured in production, when paying crew members or their families still, displacement must be found and trained, resulting in lost time and cost. Generally, the national economy as a whole is not greatly affected by a single crisis.
DELTA AIRLINES DL1288 – Accident
Delta Flight 1288 was an internal flight from Pensacola (PNS) to Atlanta (ATL). The MD-88 was cleared for 17 bindi on the piste and departure at 14:23. The first officer, the flying pilot, developed the gas butterfly system and requested that the guardrails be adjusted when the engine pressure ratio (EPR) reaches 1.35. When the flight bus heard an “explosion” with a loud noise, the gas mantle rose in the guardrail mode behind the cockpit lighting and the loss of instrumentation. The plane reached a speed of about 40 knots. The captain took control of the aircraft and stopped both gas cylinders at idle. He applied manual brakes and stopped the flight progressively. The captain did not command the reverse engine thrust and the floor spoiler could not be deployed. It looked as no. There was an ungainly breakdown of the engines of aircraft 1. The trash entered the passenger cabin and caused the death of two passengers 37 (seat A and C).
CausesBreaking of the left motor front fan fan core due to the fact that the fluorescent penetrant inspection process of the Delta Air Lines does not detect an initiable fatigue fracture from a microstructure area formed during drilling Volvo for Pratt & Whitney and not noticed at the time of production. There was not enough redundancy in the in-service audit program. ” ConsequencesAs we mentioned above, The fracture of the left engine’s front compressor fan hub, which resulted failure of the left engine during the beginning of the takeoff roll. Therefore, The MD-88 type and N927DA registration number flight accident damaged Delta Airline’s reputation due to the technical’ mistake. Also, the damaged aircraft MD-88 and the lawsuits from victims families against the company caused an economic loss to the Delta Airlines. Neither of the consequences can be as important as the passengers’ precious lives.
Resources
https://aviation-safety.net/database/operator/airline.php?var=6345
https://www.aeroinside.com/incidents/airline/delta-airlines
http://www.airsafe.com/events/airlines/delta.htmhttps://www.delta.com/
http://www.planecrashinfo.com/
http://www.popularmechanics.com/flight/g73/12-airplane-crashes-that-changed-aviation/
Delta Airlines
The first assignment was introducing the airline we choose with a video presentation. My airline is Delta Airlines and I introduced this airline briefly in the video, you can see the video below link
http://www.zentation.com/viewer2/webcast/tH7ezRXKj9/delta-airline#.Wdaqg1uCzDc
mertcikoglu 