Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.





Info
iconfalse
titleProcess Owner
Excellence Center Demand Management & Purchasing


Info
iconfalse
titleT&E Expert
Claire Boursier


Info
iconfalse
titleD&PS Expert
Marie-Line Ardito


Spend details

......................................... ................................................................................................................................................................
Restricted on Scope, information at employee level


Info
iconfalse
titleTarget Users
  • ExCom
  • Leadership team
  • Financial Directors
  • Purchasing Function
  • Controllers


Info
iconfalse
titleAuthorization & Rights
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.




NameSourceCalculationComments
Image Added
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
Image Added
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
Image Added
Air tickets volumes : Domestic/Regional vs Intercontinental
AmexGBT- Spend Analysis
Filter on Primary product code ="Air"
∑Air Net Tickets in % of "Regional or Intercontinental"

Image Added
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)

Image Added

Air ticket details amount above X EURAmexGBT- Spend Analysis

Filter on Primary product code ="Air"

Details at ticket & traveler level, including Class of Service

One ticket = 2 O&D
Image Added
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
Image Added
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

Image Added
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