The Container Ship that can Carry 29 Billion USD Worth of iPhones

On the south coast (UK) I’m accustom to seeing huge container ships slowly pass through the English Channel.

From many kilometers away these ships look huge, though I never really gave them a second thought.

That was until the Ever Given became stuck in the Suez Canal a few weeks ago, and a photo of a large bulldozer looked like a toy truck when stood next to the ships hull.

Turns out these ships are huge, and much, much bigger than I first thought.

Methodology

Container TEU

The twenty-foot equivalent unit (abbreviated TEU or teu) is an inexact unit of cargo capacity, often used for measuring container ships and container ports. It is based on the volume of a 20-foot-long (6.1 m) intermodal container, a standard-sized metal box which can be easily transferred between different modes of transportation, such as ships, trains, and trucks.

All other costs and analysis can be assumed correct at time of writing (March 30th).

Analysis

Largest Shipping Companies

Rank Company name Headquarters Total TEU Ships
1 Maersk Denmark 4,097,898 705
2 Mediterranean Shipping Company Switzerland, Italy 3,860,388 579
3 COSCO Shipping China, Hong Kong 3,022,882 503
4 CMA CGM France 3,015,485 570
5 Hapag-Lloyd Germany 1,730,615 240
6 Ocean Network Express Japan 1,577,156 218
7 Evergreen Marine Taiwan 1,279,412 195
8 Hyundai Merchant Marine South Korea 719,026 72
9 Yang Ming Marine Transport Corporation Taiwan 623,148 92
10 Zim Integrated Shipping Services Israel 356,201 80

Full table.

Largest shipping companies by total TEU (Mar 2021)

Download chart.

You have probably seen many of these names printing on the side of ships previously.

Maersk, the largest company by TEU capacity, has capacity for almost 4.1 million containers (TEU’s) on 705 ships.

There is a large difference of carrying capacity between largest and tenth largest shipping companies. The tenth largest, Zim Integrated Shipping Services, has a maximum carrying capacity of just over 356,000 TEU’s on 80 ships — about 8% of what Maersk can carry (TEU’s).

Largest Container Ships

Container ships have been built in increasingly larger sizes to take advantage of economies of scale. Though container ships are also subject to certain limitations in size.

Primarily, these are the availability of sufficiently large main engines and the availability of a sufficient number of ports and terminals prepared and equipped to handle ultra-large container ships.

Furthermore, some of the world’s main waterways such as the Suez Canal and Singapore Strait also restrict the maximum dimensions of a ship that can pass through them.

Rank Count of ships in category Built Operator Length overall (m) Beam (m) Maximum TEU Gross Tonnage
1 7 2020 HMM (South Korea) 399.9 61 23,964 228,283
2 5 2020 HMM (South Korea) 399.9 61.5 23,820 232,311
3 6 2019 MSC (Switzerland) 399.9 61.5 23,756 232,618
4 5 2019 MSC (Switzerland) 399.8 61 23,656 228,741
5 6 2020 CMA CGM (France) 399.9 61.3 23,112 236,583
6 6 2017 OOCL (Hong Kong) 399.9 58.8 21,413 210,890
7 6 2018 COSCO (China) 400 58.6 21,237 215,553
8 3 2018 CMA CGM (France) 400 59 20,954 219,277
9 11 2017 Maersk (Denmark) 399 58.6 20,568 214,286
10 2 2017 ONE (Japan) 399 58 20,182 210,691
11 4 2017 ONE (Japan) 400 58.8 20,170 210,678
12 4 2019 Evergreen (Taiwan) 400 58.8 20,160 219,775
13 7 2018 Evergreen (Taiwan) 400 58.8 20,124 219,079
14 5 2018 COSCO (China) 399.8 58.7 20,119 194,864

Full table.

Largest container ships (TEU) by class (2021)

Download chart.

Yes, that’s right… the largest container ship in the world can carry 23,964 containers (TEU)!

To purchase and launch this ship cost its owners, the Korean company, HMM, over $140 million. HMM own 7. Thats a total value of $980 for these 7 ships. Which doesn’t sound to bad considering that a private Airbus A380 (when on sale) was priced at $402m to buy.

Payload Value

You could put 2,660 boxes full of iPhone X’s in 40-foot shipping container. One TEU is half that size, so 1,330 in a standard TEU.

The cheapest iPhone 12 is $799 and most expansive $1,399. Let’s assume an average retail price of $1,099.

Assuming the box size of the iPhone X and price of the iPhone 12, a single TEU could carry $1,241,870 ($1,099 x 1,330) worth of the devices.

If all TEU’s (23,964) on the largest container ship were full of iPhones, that’s a total of 27,079,320 iPhones with a combined retail value of $29,760,172,680 (29 Billion).

For reference, Apple sold 218 million iPhones in 2018. So the largest container ship can supply around 12% of the world total iPhone demand alone.

Fuel costs

The OOCL Hong Kong, in the 6th largest class of ship, can carry 14,904 cubic litres of fuel (or 14,904,000 litres). In comparison, an Airbus A380’s fuel tank can carry 320,000 litres.

Today, the Global 20 Ports Average Bunker Cost (bulk fuel cost) is $500 per US metric tonne. Let’s assume 1 metric ton of fuel = 1.192 kiloliters (note: this is a rough estimate as it assumes fuel is diesel, which is compositionally slightly different to heavy fuel used in ships). Given this, $500 buys 1192 litres, or 1 litre = $0.42.

That means, at todays prices it will cost $6,251,678.27 ((14,904,001*$0.42) to fill the OOCL Hong Kong’s fuel tanks.

I couldn’t find specific data on engine consumption. The amount of fuel actually used on a sailing depends primarily on the ship’s speed. Most ship engines have been designed for top speeds ranging between 20 and 25 knots per hour, which is between 23 and 28 miles per hour.

At a high level I found a Panamax container ship (Panamax and New Panamax are terms for the size limits for ships travelling through the Panama Canal)  consumes about 63,000 gallons of marine fuel per day at optimum speed.

63,000 gallons = 286,403.67 litres. So thats $120,289.54 per day! Enough for 52 days at sea (14,904,000/286,403.67).

The Ever Given Problem

When the Ever Given was blocking the Suez Canal, shipping companies had two options; wait, or head around the Cape of Good Hope.

According to Refinitiv via the New York Times:

A journey from the Suez Canal in Egypt to Rotterdam, in the Netherlands — Europe’s largest port — typically takes about 11 days. Venturing south around Africa’s Cape of Good Hope adds at least 26 more days, according to Refinitiv, the financial data company.

So fuel costs for waiting would be around $1,323,184.94 ($120,289.54*11) for the rest of the journey.

Redirecting via the Cape of Good Hope would cost around $4,450,712.98 ($120,289.54*37). $3,127,528.04 more expensive than via the Suez Canal ($4,450,712.98-$1,323,184.94).

A rough estimate provided using this calculator, puts the cost of the largest ships operated by HMM (South Korea) travelling through the Suez Canal at about $800,000 in fees. Even with these fees factored it, it is still significantly cheaper than going around.

In the end the Suez was only blocked for 6 days, so even with a backlog of ships waiting to move through, it would have been more cost effective (and time effective) to have waited (though hindsight is a wonderful thing!).

Improvements

In the case of converting gross tonnes to litres I use diesel fuel as the fuel type (not heavy marine fuel) to provide a rough estimation. I could not find any liquid conversion measurement tables for marine fuel, but these would make the fuel calculations significantly more accurate.

Access to fuel consumption data for the worlds largest ships would also improve fuel estimations produced in this post.

tl;dr

The worlds largest container ship can hold 23,964 container (TEU) — enough to carry $29 billion USD worth of iPhones.

Footnotes

  1. Data sources + data used in this post.

The Elevator Ride that Costs $0.46 Per Floor

A few years ago I wrote about the costs to climb the world’s highest mountains.

Many man-made mountains, or skyscrapers as most people call them, can also be climbed for price.

In many cities the top attractions are tickets to visit the viewing floors of their highest buildings.

It got me thinking, which of the world’s tallest building that are open to the public offer the best ticket price to height value for visiting their viewing decks?

Methodology

In order to make the comparison as simple as possible I chose the cheapest possible viewing deck ticket price available for an adult in February 2021 direct from each building’s official ticket site.

Prices were converted to local currency into USD using the exchange rate on 19 February provided by XE.com.

Analysis

Highest Viewing Decks

RANK (HEIGHT) NAME CITY FLOORS Height (m) Public Viewing Floor
1 Burj Khalifa Dubai 163 828 TRUE
2 Shanghai Tower Shanghai 128 632 TRUE
3 Makkah Royal Clock Tower Mecca 120 601 FALSE
4 Ping An Finance Center Shenzhen 115 599.1 TRUE
5 Lotte World Tower Seoul 123 554.5 TRUE
6 One World Trade Center New York City 94 541.3 TRUE
7 Guangzhou CTF Finance Centre Guangzhou 111 530 FALSE
7 Tianjin CTF Finance Centre Tianjin 97 530 FALSE
9 CITIC Tower Beijing 109 527.7 FALSE
10 TAIPEI 101 Taipei 101 508 TRUE
11 Shanghai World Financial Center Shanghai 101 492 TRUE
12 International Commerce Centre Hong Kong 108 484 TRUE
13 Central Park Tower New York City 98 472.4 FALSE
14 Lakhta Center St. Petersburg 87 462 FALSE
15 Vincom Landmark 81 Ho Chi Minh City 81 461.2 TRUE
16 Changsha IFS Tower T1 Changsha 94 452.1 FALSE
17 Petronas Twin Tower 1 Kuala Lumpur 88 451.9 TRUE
17 Petronas Twin Tower 2 Kuala Lumpur 88 451.9 TRUE
19 Suzhou IFS Suzhou 95 450 FALSE

Full table.

11 of the top 20 have public observation decks (I am considering the Petronas Twin Towers as one building).

Most expensive ticket

RANK (HEIGHT) NAME CITY Cost (USD) Viewing gallery floor
10 TAIPEI 101 Taipei $6.93 101
15 Vincom Landmark 81 Ho Chi Minh City $11.85 81
5 Lotte World Tower Seoul $16.00 123
17 Petronas Twin Tower 1 Kuala Lumpur $19.47 86
17 Petronas Twin Tower 2 Kuala Lumpur $19.47 86
12 International Commerce Centre Hong Kong $22.92 100
11 Shanghai World Financial Center Shanghai $27.65 100
2 Shanghai Tower Shanghai $27.74 118
4 Ping An Finance Center Shenzhen $29.00 116
1 Burj Khalifa Dubai $40.57 160
6 One World Trade Center New York City $43.00 94

Full table.
Ticket Prices by Worlds Highest Skyscraper Observation Decks

Download chart.

Taipei 101 in Taipei, Taiwan charges less than $7 USD to visit the observation deck, over 7 times cheaper than One World Trade Center in New York City, United States ($43) (and 7 floors higher).

Best value ticket (by floor)

RANK (HEIGHT) NAME CITY Mts/floors Cost USD p/floor
10 TAIPEI 101 Taipei 5.03 $0.07
5 Lotte World Tower Seoul 4.51 $0.13
15 Vincom Landmark 81 Ho Chi Minh City 5.69 $0.15
17 Petronas Twin Tower 1 Kuala Lumpur 5.14 $0.23
17 Petronas Twin Tower 2 Kuala Lumpur 5.14 $0.23
12 International Commerce Centre Hong Kong 4.48 $0.23
2 Shanghai Tower Shanghai 4.94 $0.24
4 Ping An Finance Center Shenzhen 5.21 $0.25
1 Burj Khalifa Dubai 5.08 $0.25
11 Shanghai World Financial Center Shanghai 4.87 $0.28
6 One World Trade Center New York City 5.76 $0.46

Full table.

Ticket Prices per floor by Worlds Highest Skyscraper Observation Decks

Download chart.

I divided the ticket cost by the floor number of each building’s viewing deck. As you climb in the elevators, you’re paying $0.07 USD per floor at Taipei 101. Whilst the Burj Khalifa had the second highest ticket cost ($40.57), it is actually fairly reasonably priced for the number of floors you climb ($0.25 p/floor).

Best value ticket (by height)

RANK (HEIGHT) NAME CITY Est viewing gallery height (m) Cost USD p/m
10 TAIPEI 101 Taipei 508 $0.01
15 Vincom Landmark 81 Ho Chi Minh City 461 $0.03
5 Lotte World Tower Seoul 555 $0.03
17 Petronas Twin Tower 1 Kuala Lumpur 442 $0.04
17 Petronas Twin Tower 2 Kuala Lumpur 442 $0.04
2 Shanghai Tower Shanghai 583 $0.05
4 Ping An Finance Center Shenzhen 604 $0.05
1 Burj Khalifa Dubai 813 $0.05
12 International Commerce Centre Hong Kong 448 $0.05
11 Shanghai World Financial Center Shanghai 487 $0.06
6 One World Trade Center New York City 541 $0.08

Full table.

Ticket Prices per meter by Worlds Highest Skyscraper Observation Decks

Download chart.

Floor heights differ between buildings, so I divided the total building height by number of floors to get an average floor height. This ranged from 4.51 meters in the Lotte World Tower, Seoul, South Korea to 5.76 meters in One World Trade Center in New York City, United States.

Unsurprisingly One World Trade Center was the most expensive again, at $0.08 per meter climbed.

Much cheaper than Mount Everest ($7.35 p/m).

Improvements

My estimation of the average floor height in each building was calculated in a very crude way, because the height each tower extends beyond its highest floor will skew my figures. It would be good to get measurements of exactly how high each viewing deck is for a more accurate analysis.

tl;dr

Taipei 101 in Taipei, Taiwan offers the best value for money when comparing ticket prices for viewing decks in the worlds tallest buildings.

Footnotes

  1. Data sources + data used in this post.

Passport Power Rank 2021

It has been almost three years since my last Passport Power Rank post.

To quote that post:

 every year it appears the world has changed drastically since the last.

Holds true.

Let’s see how visa-free travel has changed over the last three years.

Methodology

Each year Henley & Partners publishes a “Global Passport Index”, a global ranking of countries according to the travel freedom that their citizens enjoy.

Points are awarded to countries for the number of destinations that offer visa-free travel to their citizens. e-Visas are treated the same as visas on arrival. Where the conditions for obtaining an e-visa are straightforward (fee, return ticket, hotel reservation), a visa-free point was assigned.

The ranking is based on exclusive data from the International Air Transport Association (IATA), which maintains the world’s largest and most accurate database of travel information, and is enhanced by extensive in-house research.

There are 219 destination countries (territories) in total. The maximum attainable score is 218 (points are not assigned for a national traveling to their own country).

Analysis

Best passports for travel by country (2021)

Interactive map.

country Visa Free Destinations 2021 2021 rank
Japan 191 1
Singapore 190 2
Germany 189 3
Korea, Democratic People’s Republic of 189 3
Italy 188 5
Spain 188 5
Finland 188 5
Luxembourg 188 5
Yemen 33 194
Somalia 33 194
Pakistan 32 196
Syrian Arab Republic 29 197
Iraq 28 198
Afghanistan 26 199

Full table.

Looking at the map, it’s clear there is an East/West split in passport mobility.

Change in visa-free requirements by country (2019-2021)

2019-2021 change map

Interactive map.

country 2019-2021 % change 2019-2021 point change
Poland 5.23 9.00
Qatar 10.47 9.00
Dominica 5.93 8.00
Saudi Arabia 9.72 7.00
United Arab Emirates 3.59 6.00
New Zealand 2.78 5.00
Holy See (Vatican City State) 3.38 5.00
Macao 3.60 5.00
Colombia 4.03 5.00
Kuwait 5.49 5.00
Thailand 6.76 5.00
China 7.14 5.00
Rwanda 9.09 5.00
Vietnam 10.20 5.00
Taiwan, Province of China -0.68 -1.00
Honduras -0.74 -1.00
El Salvador -0.74 -1.00
Micronesia, Federated States of -0.84 -1.00
Paraguay -1.40 -2.00
Venezuela, Bolivarian Republic of -3.73 -5.00

Full table.

Qatar (86 – 95) and Poland (172 – 181) passports now have 9 extra visa-free travel destinations since 2019. Venezuelan (134 – 129) passport holders on the other hand have lost 5 visa-free travel destinations, owing largely to the ongoing political turmoil in the country.

Changes in global travel freedom (2019 – 2021)

Total Global Visa Free Access

Download chart.

369 new visa-free travel destinations in total became available to global travellers in 2021 since 2019.

Improvements

The results produced by Henley and Partners show aggregated visa data. For example, it does not show which countries have visa-free travel between them. It would be useful to track what countries are added or removed to visa-free travel lists to explain any changes.

tl;dr

The Japanese passport has the largest number of destinations its holders can travel to without a visa.

Get the data

Data sources + data used in this post.

Only 2% of the world’s population travelled internationally in 2018

This years felt a little odd (said everyone, everywhere).

I usually fly a lot for work. 2 or 3 times a month. So far this year, no business flights.

I’m torn on this fact. On one hand, I believe such face-to-face interaction with teams is vital (at least to me), on the other I realise I am part of the environmental problem.

As a human, I try and wrestle with my moral conscious. “I’m not as bad a Sarah”, “I don’t take flights for the sake of points“, I tell myself in a weak attempt to justify my flights.

It got me thinking, how do I compare to the average person?

Methodology

Global Environmental Change (Volume 65, November 2020, 102194) recently released a study titled; The global scale, distribution and growth of aviation: Implications for climate change.

This report used industry statistics, data provided by supranational organisations, and national surveys to develop a pre-COVID understanding of air transport demand at global, regional, national and individual scales.

Whilst I stress these are pre-pandemic estimates (although many suggest air travel will soon bounce back to normal levels).

Some of the processed data detailed in the report is used in this post alongside directly cited data.

Results

% of population that travel

According to IATA (2019), there were 4.378 billion passengers in 2018 (international and domestic). This is not equivalent to trip numbers or individual travellers. Most air trips are symmetrical, i.e. they will involve a departure as well as a return.

As ten percent of all flights involve a transfer, 4.378 billion passengers would thus represent a maximum of 1.99 billion trips.

The share of the global population participating in international air travel is even smaller, as a significant share of all air travel takes place within countries. Domestic air travel included 2.566 billion passengers in 2018, out of this 590 million in the USA, 515 million in China, and 116 million in India (IATA, 2019).

International air travel consequently only comprised 1.811 billion passengers, who are also more likely to move through hubs. On the basis of the conservative assumption that one international trip comprises 2.2 flights (IATA, 2019), some 823 million international trips were made in 2018.

Non flying population

This does not consider that there is a significant share of the population in every country that does not fly, while some air travellers participate in one, two, or multiple trips.

% non-flying pop est. (2018-2019)

Download chart.

% non-flying pop est. (2018-2019)
United States 53
Germany 65
Taiwan 66
UK 59

Full table.

For example, data for the USA suggests that 53% of the adult population do not fly (Airlines for America, 2018). In Germany, 65% of the population do not fly (IFD Allensbach, 2019), while this share is 66% in Taiwan (Tourism Bureau Taiwan, 2019). In the UK, the non-flying share of the population 16 years or older is 59% (DEFRA, 2009).

These national surveys indicate that in high income countries, between 53% and 65% of the population will not fly in a given year. The share of non-fliers is likely larger in low-income, lower-middle and upper-middle income countries. The share of non-fliers is likely larger in low-income, lower-middle and upper-middle income countries.

International multi-trip flyers

An alternative way of calculating the share of the population participating in international air travel is to divide the number of international trips by an average trip number per traveler.

For example, Airlines for America (2018) suggest that the average air traveler makes 5.3 trips per year, with a relatively large share of travellers participating in only one or two trips, and a rather small share accounting for large trip numbers.

Applying the US average of 5.3 trips as an indication of skewed demand, 823 million international trips involved only 155 million unique air travellers, or 2% of the world population (world population of 7.594 billion).

Similarly, for domestic trips, applying this logic, 5.3 trips for the average traveller with 2.566 billion domestic passengers in 2018, means about 6% of the world’s population (456 million) travelled domestically.

Global distribution of aviation fuel use (2019)

Global distribution of aviation fuel use (2019)

Download chart.

Type % share of aviation fuel use
Commercial aviation: Passengers 71
Commercial aviation: Freight 17
Military 8
Private 4

Full table.

There’s some guesswork here, as there is no global data for military operations or private flights.

It has been suggested that military aircraft consumed 22% of US jet fuel in 2008 (Spicer et al., 2009), though a lower recent estimate for the US in absolute numbers is 18.35 Mt CO2 (in 2017; Belcher et al., 2020). In a global estimate for 2002, Eyers et al. (2004) concluded that global military operations required 19.5 Mt of fuel, leading to emissions of 61 Mt CO2, or 11.1% of global emissions from aviation.

For an estimate, the current contribution of military flight to global emissions from aviation is assumed to be 8%. This estimate is uncertain, but highlights the importance of military flight in aviation emissions.

Data on private aviation is equally limited. The global business aviation market is estimated to have included 22,295 jets, 14,241 turboprops, and 19,291 turbine helicopters in 2016 (AMSTAT Market Analysis, 2018). Assuming an average of 400 h of flight time per year for the global fleet of private jets, with an estimate of a 1200 kg/hour fuel use (Gössling, 2019), jet fuel burn was 10.7 Mt in 2016, corresponding to 33.7 Mt of CO2.

Adding the fuel use of turboprops and helicopters, overall emissions from private transport may be in the order of 40 Mt CO2. This would suggest that private aviation accounts for about 4% of global emissions from aviation

At first glance the military and private aviation fuel use might seem low, but considering it on a per passenger basis, this share of fuel is actually comparatively high.

Fuel use Mt CO2 by aviation travel type (2017)

Fuel use Mt CO2 by aviation travel type (2017)

Download chart.

Estimates of global fuel use vary. More recent estimates presented by IATA (2018) suggest that civil aviation – including international and domestic, passengers and freight – emitted 859 Mt CO2 in 2017.

Assuming this is 88% of total consumption (71% passengers + 17% freight), then global fuel consumption in 2017 was 976 Mt CO2.

Therefore, commercial aviation (passengers) contributed 693 Mt CO2 in 2017.

The International Energy Agency (IEA, 2019a) specifies that about 60.4% of this for international aviation (416 Mt CO2), and 39.6% for domestic aviation (277 Mt CO2).

Over the past 20 years, global carbon dioxide (CO2) emissions from fossil fuels and industry have been steadily increasing, and by 2018 reached a record high of 36.6 billion metric tons (Statista).

Looking at all emissions, commercial aviation (passengers) contributed 0.693 Bt CO2 emissions in 2017, which is 1.9% of all global emissions (0.693/36.6).

Thus, 2% of all CO2 emissions (0.693 Bt CO2) are caused by an estimated 6%-8% of the worlds population (from air travel).

Improvements

In many cases the data in the post considers data reported over different time periods, or uses aggregated data. Being able to access like-for-like raw data would improve accuracy.

tl;dr

823 million international trips involved only 155 million unique air travellers, or 2% of the world population

2.566 billion domestic trips involved only 456 million unique air travellers, or 6% of the world population.

Together, these passengers created 2% of all CO2 emissions.

Footnotes

  1. Data sources + data used in this post.

In the USA, 20% of the Population Go Into Debt to Fund Christmas

Suppose you find out about a government program that was spending $80 billion per year, and suppose you found out that the $80 billion could have been achieved with $60 billion in spending. Would you be concerned as a taxpayer?

In 1993 Joel Waldfogel once wrote a paper titled The Deadweight Loss of Christmas, in which estimated that ill-chosen gifts caused between $4 billion and $13 billion a year in economic waste; for comparison, he cited an estimate that put economic costs of the income tax at $50 billion.

But how much does Christmas giving differ in traditionally Christian countries?

Methodology

ING produce a range of yearly Christmas reports that produce analysis from survey’s they’ve commissioned.

For this post I used the latest available published reports in 2016 titled, Presents of Mind and Christmas and New Year.

It is important to note that the study only considers the countries explicitly listed.

Results

How much do you plan on spending this year on Christmas presents? (2016)

How much do you plan on spending this year on Christmas presents? (2016)

Download chart.

Rank Country Median spend (EUR) Do not know (%)
1 United Kingdom 420 44
2 USA 360 33
3 Luxembourg 300 45
4 Austria 250 38
4 France 250 42
6 Australia 200 44
6 Germany 200 37
6 Italy 200 40
6 Spain 200 46
10 Czech Republic 180 39
11 Belgium 150 50
12 Romania 110 40
13 Poland 70 50
14 Netherlands 40 41

Full table.

The UK spend the most, 420 EUR on presents, that’s 60 EUR more than second place, the USA, where the population spends a median average of 360 EUR on gifts.

Citizens in the Netherlands spend the least by far — just 40 EUR on Christmas Day gifts. It is worth noting though, countries hold Christmas-type celebrations at different times. In the Netherlands, Sinterklaas on 5 and 6 December – the feast of St Nicholas – means less may be spent on 24 and 25 December than in other countries that focus on a single day.

Interestingly in all countries, between 30% and 50% of those surveyed has no idea how much they spent, which could mean spending being significantly higher than figures reported!

Potential wasted spending (2016)

Potential wasted spending (2016) 

Download chart.

Country Wasted money EUR (assuming loss 20%)
United Kingdom 84
USA 72
Luxembourg 60
Austria 50
France 50
Australia 40
Germany 40
Italy 40
Spain 40
Czech Republic 36
Belgium 30
Romania 22
Poland 14
Netherlands 8

Full table.

Assuming Joel Waldfogel’s assumption of an average spend of about 20% being spent on unwanted gifts, UK citizens wasted 84 EUR on unwanted gifts in 2016.

Did you get into debt to fund Christmas celebrations? (2016)

Did you get into debt to fund Christmas celebrations? (2016)

Download chart.

Rank Country Went into debt for Christmas %
1 USA 20
2 Romania 16
3 United Kingdom 15
4 Australia 12
5 France 10
6 Spain 9
6 Poland 9
8 Italy 8
9 Czech Republic 7
10 Germany 6
10 Belgium 6
12 Luxembourg 5
13 Austria 4
14 Netherlands 3

Full table.

In the USA, around one-fifth of people spend Christmas in the red, while the people of the Netherlands are least likely to go into debt to finance the festivities (which is understandable given the reported spending).

The report found 40% of people say Christmas is the one time they spend money without worrying about it and also that a significant number of those polled feel forced to spend money.

What type of gifts did you receive for Christmas last year? (2016)

What type of gifts did you receive for Christmas last year? (2016)

Download chart.

Country Practical gifts % Leisure gifts % Money % Gift cards % Luxurious or special gifts % Didn’t receive any % Can’t remember %
United Kingdom 50 31 26 25 22 10 13
USA 53 25 25 40 19 30 8
Luxembourg 40 37 26 14 17 15 11
Austria 41 31 32 34 12 16 7
France 38 30 23 15 12 18 9
Australia 43 21 15 28 11 18 15
Germany 38 25 27 26 15 20 8
Italy 50 23 17 8 12 19 12
Spain 58 30 17 7 15 18 5
Czech Republic 70 44 29 12 10 6 7
Belgium 33 20 18 20 10 25 10
Romania 57 17 14 1 6 18 13
Poland 52 23 18 8 11 15 11
Netherlands 21 14 5 11 10 50 8

Download table.

Across Europe, 46% say they got practical gifts such as household items for Christmas last year. Twenty-six percent received presents related to hobbies or leisure.

Twenty-one percent in Europe say they received money presents in 2015; 16% received gift cards, while 14% got luxuries or other “special” items. More Czechs (70%) are practical gift givers.

Half in the Netherlands say they received no Christmas gifts last year. Potential reasons may include the Sinterklaas festival, marked in the Netherlands and in parts of Belgium earlier in December, as noted previously.

Improvements

This post considers aggregated statistics from a study conducted by ING in 2016. It would be really interesting to consider spending intentions in subsequent year, especially this year, where COVID-19 is likely to have a significant negative impact on spending intentions.

tl;dr

UK citizens spend the most on Christmas gifts (420 EU) with Dutch citizens spending the least (40 EUR). In all countries, a significant number of gift givers actually having no idea what they spend.

Footnotes

  1. Data sources + data used in this post.

COVID-19 and the £1 billion cruise ship

The cruise industry has been hit hard by COVID-19.

Whilst during a trip to the southern coast of the UK this summer I saw 10 large ships moored up off the coast. I think they’re still there.

I imagine it’s a similar picture in many of the world’s harbours.

When you start playing with the numbers of cruising, you quickly realise two things. 1. They’re big. 2. You’ll need a calculator.

The Symphony of the Seas the world’s largest cruise ship by gross tonnage (228,081 GT) measures 361.011 metres in length, cost £959m ($1.35bn) to build, has 18 decks, is able to accommodate 5,518 passengers at double occupancy up to a maximum capacity of 6,680 passengers, as well as a 2,200-person crew.

A week in the Ultimate Family Suite sells for between $20,000 (low season) and $80,000 (Christmas week).

It’s owner Royal Caribbean suspended all service across most of its fleet, including Symphony of the Seas, until September of this year (2020).

How much have cruise operators fortunes changed during the COVID-19 pandemic?

Methodology

At the moment cruise operators are all offering some incentives to attract passengers.

I managed to find an old price list from Royal Caribbean with 2018-2019 prices to get an idea of pre-pandemic prices.

The Symphony of the Seas operates around the world. I used the “starting from” prices for a 9 night cruise (cruise only) around the western Caribbean.Symphony

Results

Cruise cost (2018-19)

Download chart.

Cruise Only
Interior £1,099
Promenade £1,199
Ocean View £1,299
Balcony £1,499
Suites £2,399

Full table.

Estimated Revenue (2018-19)

Symphony of the Seas 9 night cruise (cruise only) Western Caribbean (2018-19 Prices) revenue share by room type

Download chart.

Type Cruise Only Estimated Percentage of rooms Passengers (100% occupancy) Cruise Revenue
Interior £1,099 0.40 2672 £2,936,528
Promenade £1,199 0.30 2004 £2,402,796
Ocean View £1,299 0.16 1069 £1,388,371
Balcony £1,499 0.10 668 £1,001,332
Suites £2,399 0.04 267 £641,013

Full table.

Assuming the above breakdown of room types, prices, and passengers (100% occupancy), the estimated ticket revenue alone for Royal Caribbean is £8,370,040.

Symphony of the Seas 9 night cruise (cruise only) Western Caribbean (2018-19 Prices) revenue estimations

Download chart.

Ticket Revenue (GBP)
100% occupancy £8,370,040.00
90% occupancy £7,533,036.00
80% occupancy £6,696,032.00
70% occupancy £5,859,028.00

Full table.

Let’s assume 80% occupancy as a best-case; £6,696,032, that the ship bills this, on average, for all cruises (it operates other routes), and that the ship is operating with passengers onboard 80% of the year (365 *0.8 = 292 days).

This means the cruise can be operated 32 times a year (292/9 days), giving an estimated income of £214,273,024 per year. Ignoring all operating costs (which will be high — the ship has over 2000 staff onboard), the ship will bill enough in ticket revenue to cover its cost (£959m) in just under 4 years (£959,000,000/£214,273,024).

Pre-COVID.

Assuming cruises were not operating for 5 months (150 days / 12 potential cruises) that’s an estimated £80,352,384 (£6,696,032*12) of lost revenue from this ship alone. Royal Caribbean has 26 ships.

Let’s assume that the both the occupancy rate drops to 40% (estimated revenue £3,348,016) — because ticket costs might not come down — AND that the amount of cruises are reduced by 50% to 16 times a year (16*£3,348,016), reducing revenues to £53,568,256 per year.

When you’re dealing with big numbers, even small changes can have a dramatic impact. It’s clear the cruise industry, like almost all travel industries is in for some very hard time ahead, even if these calculations are not

Improvements

This post contains very rough calculations, from estimated revenues to operational times of the ship.

It also completely ignores operating costs, which must be massive for a cruise ship.

Both of which would make immediate improvement to this post.

tl;dr

Pre-COVID 19 the world’s largest cruise ship, the Symphony of the Seas, could have billed around £7 million in passenger ticket revenue for a 9 day cruise. Revenues could easily be half this figure currently.

Footnotes

  1. Data sources + data used in this post.

The cost of 1GB of mobile data in 228 countries

When travelling, I’ll often purchase a temporary SIM card for data usage in that country.

It’s sometime surprising how little these cost, in reference to US mobile tariffs.

Which got me thinking; where does the USA sit in the mobile data league table?

Methodology

Data from 5,554 mobile data plans in 228 countries were gathered and analysed by Cable.co.uk between 3 February and 25 February 2020. The average cost of one gigabyte (1GB) was then calculated and compared to form a worldwide mobile data pricing league table. Full methodology can be read here.

All prices shown in USD ($).

Results

The country league table

Average price of 1GB of Mobile Data by Country

Download chart.

Average price of 1GB (USD) vs Name

View interactive map.

Rank Name Average price of 1GB (USD)
1 India 0.09
2 Israel 0.11
3 Kyrgyzstan 0.21
4 Italy 0.43
5 Ukraine 0.46
224 São Tomé and Príncipe 28.26
225 Bermuda 28.75
226 Nauru 30.47
227 Falkland Islands 40.41
228 Saint Helena 52.50

Full table.

The five most expensive countries in terms of the average cost of 1GB of mobile data are São Tomé and Príncipe ($28.26), Bermuda ($28.75), Nauru ($30.47), Falkland Islands ($40.41) and Saint Helena ($52.50).

The similarities between these five nations are both striking and obvious. They are all island nations. Islands are less likely to have an extensive fibre infrastructure, and since mobile networks normally rely on connection to a fibre backbone, other more expensive solutions such as satellite uplink have had to be instituted – a cost passed on to the consumer.

The five cheapest countries in terms of the average cost of 1GB of mobile data are India ($0.09), Israel ($0.11), Kyrgyzstan ($0.21), Italy ($0.43), and Ukraine ($0.46).

Conversely to the most expensive, none of these countries are islands. Further, they all either contain excellent fibre broadband infrastructure (Italy, India, Ukraine, Israel), or in the case of Kyrgyzstan rely heavily on mobile data as the primary means to keep its populace connected to the rest of the world.

The global mean average is $5.09, and median is $3.24 for 1GB of mobile data.

The region league table

Average price of 1GB of Mobile Data by Region

Download chart.

Continental region Number of countries Average price of 1GB (USD)
NORTHERN AFRICA 7 2.06
CIS (FORMER USSR) 11 2.16
ASIA (EX. NEAR EAST) 28 2.28
BALTICS 3 2.31
WESTERN EUROPE 29 3.13
CENTRAL AMERICA 8 3.24
EASTERN EUROPE 15 3.42
NEAR EAST 15 4.46
SOUTH AMERICA 13 5.80
SUB-SAHARAN AFRICA 47 6.91
CARIBBEAN 28 7.19
OCEANIA 20 7.85
NORTHERN AMERICA 4 14.71

Full table.

It’s notable when looking at the global league table how far down it you have to read before you get to Canada and the United States. The largest and richest North American nations are ranked 209 and 188 in the world in terms of the price of mobile data with 1GB costing an average $12.55 in Canada and $8.00 in the US.

The other two countries regarded as being part of Northern America are vastly different – there’s the north Atlantic island nation of Bermuda ($28.75), which is easily the most expensive in the region (and fourth most expensive in the world), and Greenland ($9.56), which sits mostly in the Arctic circle and has only one mobile provider.

The seven Northern African countries included in the research appear higher up the table than the majority of countries in Sub-Saharan Africa, although none make it into the top ten cheapest in the world.

The cheapest country in the region is Algeria, with an average of $0.65, followed by Western Sahara and Morocco (both $0.99). These three all make it into the world’s top 40 cheapest and even Libya, the most expensive country in Northern Africa, still avoids the bottom 50 with an average of $4.73.

Improvements

It’s important to stress the word cheap is used in relation to other countries throughout this post.

Whilst $0.09 is cheap for many Westerners, for a large proportion of the Indian population, based on income, this might not be the case.

It would therefore be useful to adjust the calculated cost based on the median income of each country.

tl;dr

India is the cheapest country in which to buy mobile data, with the average cost of 1GB at USD 0.09. The United States is one of the most expensive developed nations for purchasing mobile data, coming in 188th in the world, and with an average 1GB cost of USD 8.00 – well above the global average.

Footnotes

  1. Data sources + data used in this post.

A New Record: Guns Caught at US Airport Security Checkpoints

Belt. Off.

Shoes. Off.

Phone out of pocket. Yes.

Laptop and iPad in separate trays. Done.

Guns. Ermmmm…

Methodology

Travellers who bring firearms to the checkpoint are subject to criminal charges from law enforcement and civil penalties from TSA.

Even if a traveller has a concealed weapon permit, firearms are not permitted to be carried onto an aeroplane.

However, travellers with proper firearm permits can travel legally with their firearms in their checked bags if they follow a few simple guidelines to transport firearms and ammunition safely.

The data reported in this post covers all guns identified, which includes both those authorised to be carried on-board as well as guns seized.

Results

Guns identified at US airports

Year Nationwide
2008 926
2009 976
2010 1,123
2011 1,320
2012 1,556
2013 1,813
2014 2,212
2015 2,653
2016 3,391
2017 3,957
2018 4,239
2019 4,432

View full table.

Number of Weapons Identified by TSA at US Airports (2008 - 2019)

Download chart.

Transportation Security Administration officers caught more firearms at checkpoints nationwide in 2019, more than ever recorded previously.

In total, 4,432 firearms were discovered in carry-on bags or on passengers at checkpoints across the country last year, averaging about 12.1 firearms per day, approximately a 5% increase nationally in firearm discoveries from the total of 4,239 detected in 2018.

What’s more, eighty-seven percent of firearms detected at checkpoints last year were loaded.

Worst airports

Airport Weapons Identified
Hartsfield-Jackson Atlanta International (ATL) 323
Dallas/Fort Worth International (DFW) 217
Denver International (DEN) 140
George Bush Intercontinental (IAH) 138
Phoenix Sky Harbor International (PHX) 132

View full table.

Number of Weapons Identified by TSA at US Airports (2019)

View chart.

Firearms were caught at 278 airport checkpoints in the US.

The top five airports where TSA officers detected guns at checkpoints in 2019 were: Hartsfield-Jackson Atlanta International with 323; Dallas/Fort Worth International with 217; Denver International with 140; George Bush Intercontinental with 138; and Phoenix Sky Harbor International with 132.

Improvements

As noted, there is no distinction between guns authorised to be carried on-board and guns carried illegally. Being able to extrapolate how many guns were seized would add a different perspective to the analysis.

tl;dr

4432 guns were identified at US airports security checkpoints in 2019 (compared to just 926 in 2008).

Footnotes

  1. Data sources + data used in this post.

The Great TSA Robbery

Waiting at a baggage carousel is never enjoyable.

You’ve stepped off the plane, cleared security, and then, the 300 plus people who have just disembarked the plane rush to get as close to where the bags enter the carousel with latecomers forced to pack tightly around its perimeter.

If you’re lucky, or have paid for the privilege, your bag will arrive first. If you’re unlucky, me, you’ll be waiting until the very end.

If you’re really unlucky, your bag won’t arrive at all, and you’ll spend the next hour or two waiting at the baggage information desk to find out what to do next.

In many cases, your bag just wasn’t loaded on your flight, and in such cases the bag will be carried on the next flight.

Though even with highly computerised baggage processes, bags do still inevitably go missing — from hand baggage at security checkpoints to checked luggage at the destination.

But why?

Methodology

The Transport Security Administration (TSA) are responsible for the security of the travelling public in the United States.

This includes everything from checking passengers are not carrying prohibited items into the cabin through to checking bags going into the hold.

The TSA periodically publish claims made against them during a screening process of persons or passenger’s property due to an injury, loss, or damage.

The latest in Excel format is for 2015, and is the version used in this post (I guess it takes them a long time to process and publish claims, as you’ll see even claims from 2015 are still showing as open…)

Results

Overview of claims

Question Answer
Total claims 8667
Total open claims 2066
Total closed claims 3027
Value of all closed claims USD 611,137.05
Mean average payout USD 201.90
Highest claim USD 5,403.46
Lowest claim USD 2.00
Total rejected claims 3574
Most claimed for category Passenger Property Loss (4551)
Most claimed for item type Baggage/Cases/Purses
Most claimed for site Checked baggage (6261)
Most claimed for airport John F. Kennedy International (523)

Full table.

Over $611K USD has been paid out representing just over 3000 claims. 3500 we’re rejected. 200 claims remain open (outcome undecided) for the year 2015.

JFK (New York), the 6th busiest US airport (61 million pax/yr), is the airport that received the most claims from passengers.

Months with most claims

Count of TSA Claims vs Month (2015)

Download chart.

Unsurprisingly the busy summer months (July and August), where passenger traffic is generally at its highest level, saw the most claims.

Most common items stolen

Item Category Count of claims
Baggage/Cases/Purses 1004
Computer & Accessories 736
Clothing 723
663
Other 570
Personal Electronics 561
Jewelry & Watches 509
Travel Accessories 454
Personal Accessories 347
Cosmetics & Grooming 310

Full table.

Computer & accessories, after suitcases and purses, are the items that go missing the most.

Worst airports

Airport Code Airport Name Count of claims (all, inc pending) Value of paid claims USD
JFK John F. Kennedy International 523 50635.31
LAX Los Angeles International Airport 495 28864.61
MCO Orlando International Airport 372 25795.49
ATL Hartsfield-Jackson Atlanta International Airport 362 17725.27
EWR Newark International Airport 312 32630.15
MIA Miami International Airport 306 22801.2
ORD Chicago O’Hare International Airport 261 17446.55
LAS McCarran International 256 9533.35
PHX Phoenix Sky Harbor International 245 22239.19
SEA Seattle-Tacoma International 244 18362.59

Full table.

The TSA at JFK has the highest number of claims made against them (523). Those claims that have been paid out represent $50k total so far.

Improvements

My assumption is many claims go straight to insurance companies and never reach the TSA (I’d love to see a data set covering claims made to insurers). I estimate no more than $1 million will be paid out by the TSA for all claims made in 2015 — significantly lower than the figures I would expect after analysing other data sources.

If the latest data is 2016/2017, there is a significant lag in publishing statistics. I also wonder how much data is actually missing. It would be interesting to see a longer timeseries of data to see changes in the number and types of claims.

tl;dr

Avoid JFK airport in the summer months if you’re travelling with particularly valuable items.

Footnotes

  1. Data sources + data used in this post.

Please Arrive at the Airport 6 Hours Before Your Flight to Clear Security

It has been a little different over the last few months.

Whilst the holiday you’ve been looking forward to since the start of the outbreak might not be going ahead this year, it will come around.

We’ll all be back flying soon. And so will the familiar, often stressful, journey from car to plane.

Wait to check-in. Wait to drop your bags. Wait until the person in front of you at security empties the backpack full of all their electronics (sorry!).

In this period of travel downtime, I decided to take a look at the best and worst performing airports for security waiting times in the UK and US. Perhaps it’ll change my decision on where to fly from once travel restrictions are lifted.

Methodology

Which? asked asked 4,499 passengers to provide an estimated wait time for security on their most recent visit to the airport in their recent annual airport survey (end of 2019). Note: this survey was conducted before any COVID-19 restrictions were put in place.

The passenger numbers from each UK airport are sourced from CAA figures published for 2018, the latest full year dataset available at the time of writing. Note, the numbers are reported per airport. I could not find individual terminal data as is reported in the waiting time data. Therefore to perform my analysis I simply divided airport passenger number by number of terminals at the airport. Clearly this is not perfect.

For US airport data, I used data from Upgraded Points, who compiled wait time data directly from the Transportation Security Administration (TSA) They collected data from late Spring for every hour at each airport to calculate overall averages.

Results

Mean security wait time at UK airports
Mean security wait time at UK airports

Download chart.

This one’s personal. I used to travel to Belfast monthly. I don’t miss the queues.

Belfast International is by-far-and away the worst performing airport for security waiting times, taking on average over 22 minutes  — over 5 minutes longer than any other airport considered.

Compare that with Southend or Southampton, the latter of which I used to fly to and from Belfast coincidently, where queuing can regularly take less than 5 minutes.

Mean security wait (mins) 2019 vs UK airport size

Mean security wait versus airport size

Download chart.

Gatwick and Heathrow have the lowest average security queue times for large UK airports. They are also the only two airports in the UK whose queue targets are set externally – by the Civil Aviation Authority.

They hit their queue targets, which are to get 99% of flyers through security in less than 10 minutes (Heathrow) and 98% in less than 15 minutes (Gatwick).

For a long time, my personal hypothesis was that smaller airports would have slower security primarily due to the fact they often cater for low-cost airlines, and thus people who might not travel as regularly.

How wrong I was.

In fact, larger airports are about 2 minutes slower. When I think more deeply about this, it makes perfect sense. Larger airport, more passengers, slower security queues.

Mean security wait (mins) 2019 vs UK airport passenger number

Number of passengers to add 1 minute to security wait times at UK airports (2019)

Download chart.

Comparing wait times to the number of passengers travelling gives us a better picture of how efficient security at each airport is.

Every 2.68 million passengers adds about a minute to the security waiting times at Gatwick South terminal, making it the most efficient airport considered. The North terminal at Gatwick doesn’t fare much worse with every 2.69 million passengers adding an extra minute.

Compare that to Bournemouth where every 88,000 passengers adds a minute to the security wait times.

Comparing to US airports

Airport Mean security wait (mins) 2019 Country
Southend 5.2 UK
Southampton 5.2 UK
Exeter 6.9 UK
Cardiff 7.1 UK
London City 7.5 UK
Bournemouth 7.7 UK
Newcastle 8.1 UK
Bristol 8.5 UK
Heathrow Terminal 5 8.6 UK
Gatwick South Terminal 8.6 UK
Gatwick North Terminal 8.7 UK
Salt Lake International Airport 9.1 US
Heathrow Terminal 4 9.4 UK
Heathrow Terminal 2 9.6 UK
Liverpool (John Lennon) 10.1 UK
Heathrow Terminal 3 10.3 UK
Dulles International Airport 10.5 US
Edinburgh 10.5 UK
Boston Logan International Airport 10.6 US
Leeds Bradford 10.6 UK
Birmingham 10.6 UK
Luton 11.7 UK
Glasgow International 12.2 UK
East Midlands 12.7 UK
Minneapolis−Saint Paul International Airport 13 US
Detroit Metropolitan Wayne County Airport 13.2 US
Charlotte Douglas International Airport 13.2 US
Philadelphia International Airport 13.3 US
Stanstead 13.7 UK
Denver International Airport 13.8 US
Los Angeles International Airport 14.2 US
Fort Lauderdale-Hollywood International Airport 14.3 US
Phoenix Sky Harbor Airport 14.7 US
Orlando International Airport 14.9 US
Chicago O’Hare International Airport 15 US
San Diego International Airport 15.5 US
Manchester Terminal 2 15.5 UK
Manchester Terminal 3 15.5 UK
Dallas/Fort Worth International Airport 15.9 US
San Francisco International Airport 16 US
John F. Kennedy International Airport 16 US
Seattle-Tacoma International Airport 16.3 US
Hartsfield-Jackson Atlanta International Airport 16.9 US
LaGuardia Airport 17 US
Manchester Terminal 1 17 UK
McCarran International Airport 17.3 US
Baltimore/Washington International Thurgood Marshall Airport 18.2 US
Miami International Airport 19.6 US
Houston Airport System 19.8 US
Belfast International 22.3 UK
Newark Liberty International Airport 23.1 US

Full table.

The best performing airports based on security wait times are all in the UK. Salt Lake International Airport is the best performing airport in the US (9.1 mins).

The worst airport, Newark Liberty International Airport in New York where average security wait times are 23.1 minutes — about one minute slower than Belfast International.

4 of the 5 worst performing airports are all in the US.

US vs UK airports average security wait times 2019

Download chart.

As a result, US airports security queues, are on average, 5 minutes slower than their UK counterparts.

Improvements

The UK figures are based on estimates. Which? collected the data by asking 4,499 passengers to provide an estimated wait time for security on their most recent visit to the airport in our recent annual airport survey.

This is far from accurate. The analysis would be much improved if I was able to use the actual figures similar to the way they are reported by the TSA in the US, although I could not find anywhere where UK airports reported these numbers.

tl;dr

Belfast International is by-far-and away the worst performing UK airport for security waiting times, taking on average over 22 minutes  — over 5 minutes longer than any other airport considered.

In the US it’s Newark Liberty International Airport in New York, where security queues are a little over 23 minutes on average.

Footnotes

  1. Data sources + data used in this post.