Executive Summary

BW- Fixed Costs

Spend = ∑Spend "Selection" N

Evolution = (∑Spend "Selection" N -∑Spend "Selection" N-1 RSB)/∑Spend "Selection" N-1 RSB

"Selection" is YTD by default and can be changed to another period using "Month Year" filters

RSB (FX effect) methodology available in Financial Overview information.

Concur - Expenses

Count number of Employee over period (no duplicates)

Any employee that enter an expense in Concur over the analysis period

AmexGBT - Spend Analysis

Count number of Employee over period (no duplicates)

Any employee that made a booking either online (concur) or offline (travel agency) over the analysis period

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Number of tickets

Including refunds and exchanges

Air average ticket price vs N-1

AmexGBT- Spend Analysis

∑Air Net Ticket Amount "Selection" N / ∑ Air Net Tickets "Selection" N

vs ∑Air Net Ticket Amount "Selection" N-1 / ∑ Air Net Tickets "Selection" N-1

Average ticket price regardless of booking class, country point of sales, ...

Book Online (Online Eligible)

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Tickets "Selection" N with booking channel = "Online" & "Eligible" / ∑ Air Net Tickets "Selection" N

Online = in Concur

Offline = via travel agency

Eligible = country where Concur is implemented for booking & simple trip (no multi-destination or country at risk)

Book in Advance for Domestic & Regional Flights (min 14 days)

AmexGBT- Spend Analysis

Filter on "Regional or Intercontinental" = "Domestic - Regional" & Filter on Primary product code ="Air"

∑Air Net Tickets "Selection" N with compliance = "Yes" / ∑ Air Net Tickets "Selection" N

Book in Advance for International Flights (min 21 days)

AmexGBT- Spend Analysis

Filter on "Regional or Intercontinental" = "Intercontinental" & Filter on Primary product code ="Air"

∑Air Net Tickets "Selection" N with compliance = "Yes" / ∑ Air Net Tickets "Selection" N

Book the lowest logical fare

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Tickets "Selection" N with LLA Acceptance = "Yes" / ∑ Air Net Tickets "Selection" N

% of one day trips vs total of trips (by air)

AmexGBT- Spend Analysis

Filter on Primary product code ="Air"

∑Air Net Tickets "Selection" N with Days traveled = "1 day" / ∑ Air Net Tickets "Selection" N

This metric is including one-way tickets.

% of internal meeting trips (air & rail)

AmexGBT- Spend Analysis

Filter on Primary product code ="Air" & "Rail"

∑Total number of tickets with Trip Purpose Clean = "Internal meeting" / ∑Total number of tickets

Based on number of tickets booked for trip by air or rail

Solvay Benchmark - Online Booking compliance

AmexGBT- Spend Analysis

Metric number 6 with split per GBU/Function for YTD N.

Cannot be filtered by GBU/Function

Solvay Benchmark - Book in Advance for Domestic & Regional Flights (min 14 days) compliance

AmexGBT- Spend Analysis

Metric number 7 with split per GBU/Function for YTD N.

Cannot be filtered by GBU/Function

Solvay Benchmark - Book in Advance for International Flights (min 21 days) compliance

AmexGBT- Spend Analysis

Metric number 8 with split per GBU/Function for YTD N.

Cannot be filtered by GBU/Function

Solvay Benchmark - Book the lowest logical fare compliance

AmexGBT- Spend Analysis

Metric number 9 with split per GBU/Function for YTD N.

Cannot be filtered by GBU/Function

Solvay Benchmark - Average Spend per Employee

Concur - Expenses

∑Approved Amount without reclaimable tax (EUR) / Metric number 2 with split per GBU/Function for YTD N.

Cannot be filtered by GBU/Function

Monthly Update

N/A

Free Text

Monthly update from Purchasing