Booking Overview

1

Air Overview

• Total Spend

• Number of O&D

• Average O&D cost

AmexGBT- O&D

Filter on Primary product code ="Air"

Spend = ∑O&D Net Amount

Number of O&D = ∑ O&D Net Count

Average O&D cost= ∑O&D Net Amount / ∑ O&D Net Count

2

Volume per airlines alliances

AmexGBT- O&D

Filter on Primary product code ="Air"

∑O&D Net Count in % of airline alliances (or number of tickets per airline alliances)

This metric has 2 dimensions: % or number of tickets

3

Air tickets volumes : Domestic/Regional vs Intercontinental

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Tickets in % of "Regional or Intercontinental"

4

Air Routes Overview

AmexGBT- O&D

Filter on Primary product code ="Air"

Column 1 : Origin -Destination (non directional)

Column 2: ∑O&D Net Amount "Selection"

Column 3: ∑O&D Net Count"Selection"

Column 4: % of ∑O&D Net Amount "Selection" for each Origin - Destination

Column 5: Average cost per Origin - Destination "Selection"

Column 6: Average cost per Origin - Destination "Solvay

NB: 2 Origin - Destination = 1 roundtrip

5

Air Tickets volume per booking class

AmexGBT- O&D

Filter on Primary product code ="Air"

∑O&D Net Count in % of "Class of Service - Invoice (Predominant)

∑O&D Net Amount in % of "Class of Service - Invoice (Predominant)

6

Rail Overview

• • Total Spend

  • Number of O&D

  • Average O&D cost

AmexGBT- O&D

Filter on Primary product code ="Rail"

Spend = ∑O&D Net Amount

Number of O&D = ∑ O&D Net Count

ATP= ∑O&D Net Amount / ∑ O&D Net Count

7

Rail Routes Overview

AmexGBT- O&D

Filter on Primary product code ="Rail"

Column 1 : Origin -Destination (non directional)

Column 2: ∑O&D Net Amount "Selection"

Column 3: ∑O&D Net Count"Selection"

Column 4: % of ∑O&D Net Amount "Selection" for each Origin - Destination

Column 5: Average cost per Origin - Destination "Selection"

Column 6: Average cost per Origin - Destination "Solvay

NB: 2 Origin - Destination = 1 roundtrip

8

Hotel Overview*

• Booked amount

• Number of nights

• Average daily rate

AmexGBT - Hotels

Booked amount = ∑Period 1 Hotel Booked Amount

Nights = ∑ Period 1 Hotel Room Nights

ADR = ∑Period 1 Hotel Booked Amount/∑ Period 1 Hotel Room Nights

9

Volumes per Hotel Chains (based on number of nights)*

AmexGBT - Hotels

∑ Period 1 Hotel Room Nights in % of Hotel Chain

10

Hotel Bookings Overview*

AmexGBT - Hotels

Column 1 : Hotel City

Column 2: ∑Period 1 Hotel Booked Amount "Selection"

Column 3: ∑ Period 1 Hotel Room Nights "Selection"

Column 4: % of ∑Period 1 Hotel Booked Amount "Selection" for each Hotel City

Column 5: Average cost per Hotel City "Selection"

Column 6: Average cost per Hotel City "Solvay

11

Car Overview*

• Booked Amount

• Number of days

• Average daily rate

AmexGBT - Car rental by city

Booked amount = ∑Period 1 Car Booked Amount

Days = ∑ Period 1 Car Days

ADR= ∑Period 1 Car Booked Amount/∑ Period 1 Car Days

12

Volumes per Car Rental Companies (based on number of days)*

AmexGBT - Car rental by city

∑ Period 1 Car Days in % of Car Rental Vendor

13

Car rental Overview*

AmexGBT - Car rental by city

Column 1 : Rental City

Column 2: ∑Period 1 Car Booked Amount "Selection"

Column 3: ∑ Period 1 Car Days "Selection"

Column 4: % of ∑Period 1 Car Booked Amount "Selection" for each Rental City

Column 5: Average cost per Rental City "Selection"

Column 6: Average cost per Rental City "Solvay