Booking Overview

Name	Source	Calculation	Comments
Air Overview Total Spend Number of O&D Average O&D cost	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
Volume per airlines alliances	AmexGBT- Spend Analysis	Filter on Primary product code ="Air" ∑Air Net Ticket Count in % of airline alliances (or number of tickets per airline alliances)	This metric has 2 dimensions: % or number of tickets
Air tickets volumes : Domestic/Regional vs Intercontinental	AmexGBT- Spend Analysis	Filter on Primary product code ="Air" ∑Air Net Tickets in % of "Regional or Intercontinental"
Air Tickets volume per booking class	AmexGBT- Spend Analysis	Filter on Primary product code ="Air" ∑Air Net Ticket Count in % of "Class of Service - Invoice (Predominant) ∑O&D Net Amount in % of "Class of Service - Invoice (Predominant)
Air ticket details amount above X EUR	AmexGBT- Spend Analysis	Filter on Primary product code ="Air" Details at ticket & traveler level, including Class of Service	One ticket = 2 O&D
Rail Overview Total Spend Number of O&D Average O&D cost	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
Hotel Overview* Booked amount Number of nights Average daily rate	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
Car Overview* Booked Amount Number of days Average daily rate	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

Page tree

Booking Overview

Excellence Center Demand Management & Purchasing

Claire Boursier

Marie-Line Ardito

Restricted on Scope, information at employee level

ExCom

Leadership team

Financial Directors

Purchasing Function

Controllers

All the accesses must be validated by:

Excellence Center / Purchasing

Click here for the Access form to get access to the T&E Dashboard.

Current authorizations are available on this file.

Air Overview

Total Spend

Number of O&D

Average O&D cost

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

Volume per airlines alliances

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Ticket Count in % of airline alliances (or number of tickets per airline alliances)

This metric has 2 dimensions: % or number of tickets

Air tickets volumes : Domestic/Regional vs Intercontinental

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

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

Air Tickets volume per booking class

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Ticket Count in % of "Class of Service - Invoice (Predominant)

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

Rail Overview

Total Spend

Number of O&D

Average O&D cost

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

Hotel Overview*

Booked amount

Number of nights

Average daily rate

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

Car Overview*

Booked Amount

Number of days

Average daily rate

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

* booking costs might be different from final invoiced costs