gbta europe kpi wizard 2012

Document Sample
gbta europe kpi wizard 2012 Powered By Docstoc
					KPI Wizard - How the KPIs featured in the KPI Reference Guide might be used
                     b327495f-04ba-46e3-a27e-9740bae9e137.xls                                                                         KPI Tool
                     Last saved: 5/21/2012




                                                                       Your Total Program Score is: 56%                                                          User Notes:
                                                   sum of weights:        100%                                             Calculated Values
                                                                                                                                                                 Be sure the weights in Column D add to 100%.
                                                                           scoring                             Actual's        % of target
KPI                                                                         weight
                                                                                       actual      target       KPI's           achieved
                                                                                                                                                actual KPI's
      Name of KPI                 Question addressed                                    (enter      (enter                                     contribution to
ID                                                                      (should sum
                                                                                       values)     values)
                                                                                                               Desired        (depends on
                                                                                                                                                 total score     Set each KPI's Actual and Target values in columns E and F.
                                                                          to 100%)                            Direction:    desired direction)
                           What percentage of our travel
                           spend is under contract? (By                                                                                                          To NOT use a KPI, DELETE the KPI's value in Column D - values
 1    Spend Under Contract
                           category, e.g., air, hotel, car
                                                                           5%           60%        100%         Grow              60%               3.0%
                           rental)
                                                                                                                                                                 cannot be set to 0%.
                           What share of our travel is
                           booked via the approved Travel
 2    Booking Visibility   Management Company and                          5%           60%        100%         Grow              60%               3.0%         Setting Actual or Target values to 0% in columns E and F may
                           selfbooking                                                                                                                           cause formula errors.
                           tool (Self Booking Tool)?

                                  What share of our travel spend
 3    Payment Visibility
                                  is paid via the Corporate Card?
                                                                           5%           60%        100%         Grow              60%               3.0%         Be aware that there are formulas in columns G, H and I. These
                                  How much have we saved
                                                                                                                                                                 cells are intended to be auto-calculated, based on the user's data
      Realised Negotiated
                                  through the negotiation and                                                                                                    entered in Columns D, E and F.
 4
      Savings
                                  adoption of our preferred                5%         £ 500,000   £ 900,000     Grow              56%               2.8%
                                  supplier
                                  contracts?
                                  How good are our negotiated
      Contract
 5
      Competitiveness
                                  contracts (air, hotel, car, Travel       5%           60%        100%         Grow              60%               3.0%
                                  Management Company)?

      Cost of Managed             What percentage of our travel
 6
      Travel                      spend goes to managing it?
                                                                           5%          6.0%        3.0%        Shrink             50%               2.5%


      Cabin Non-                  To what degree are travelers not
 7
      compliance                  complying with our cabin policy?
                                                                           5%           60%         20%        Shrink             33%               1.7%

      Lowest Logical              To what extent are we spending
 8    Airfare Non-                more than our lowest logical             5%           60%         20%        Shrink             33%               1.7%
      compliance                  airfare policy suggests?
                                  To what extent are our travellers
      Advance Booking
 9
      Non-compliance
                                  not complying with our advance           5%           60%         20%        Shrink             33%               1.7%
                                  booking travel policy?
                                  How much are our travellers
 10   Online Adoption             using the self-booking tool (Self        3%           60%         80%         Grow              75%               2.3%
                                  Booking Tool)?

                                  How much visibility do we have
 11   Hotel Visibility            about our travelers’ hotel               2%           60%        100%         Grow              60%               1.2%
                                  destinations?
                                  How often are we changing
 12   Re-Booking Rate
                                  bookings after ticketing?
                                                                           5%           60%         20%        Shrink             33%               1.7%

                                  What is the average quality of
 13   Hotel Quality
                                  hotels we are booking?
                                                                           5%               4.5         4.0    Shrink             89%               4.4%

                                  How satisfied are our travellers
 14   Traveler Satisfaction       with our managed travel                  5%           60%        100%         Grow              60%               3.0%
                                  program?
                                  How well are we supporting our
 15   Contract Support
                                  preferred suppliers?
                                                                           5%           60%        100%         Grow              60%               3.0%


                                  How fast is our reimbursement
 16   Reimbursement Days
                                  process?
                                                                           5%              10.0         5.0    Shrink             50%               2.5%

                                  For what share of travellers do
 17   Location Insights           we have information about their          5%           60%        100%         Grow              60%               3.0%
                                  location?
                                  How complete are our travelers’
 18   Profile Completion
                                  profiles?
                                                                           5%           60%        100%         Grow              60%               3.0%

                                  How well do we measure our
 19   Carbon Visibility           travel programme’s carbon                5%           76%        100%         Grow              76%               3.8%
                                  impact?
                                  How often are our travellers
 20   Rail vs. Air                using rail over air in markets that      5%           60%        100%         Grow              60%               3.0%
                                  offer both options?
                                  What percentage of our travel
 21   Data Quality
                                  data appears usable?
                                                                           5%           60%        100%         Grow              60%               3.0%

                                                                          100%




                                                                                                                                      Page 2/3
KPI
             Name of Metric                                           Question addressed                                                                                              Definition
ID

                                                                                                                                 Contracted Spend divided by Total Travel Spend.
                                    What percentage of our travel spend is under contract? (By category, e.g., air, hotel, car   By category, identify suppliers as either Contracted (a.k.a. Preferred), or Non-Contracted.
 1    Spend Under Contract
                                    rental)                                                                                      Divide the total spend on Contracted suppliers into the category’s Total Travel Spend, including Non-Contracted
                                                                                                                                 suppliers.
                                                                                                                                 Total Travel Spend may be obtained via the general ledger, or the Expense Reporting System
                                                                                                                                 (Ticketed and Booked Spend) divided by Total Travel Spend.
                                                                                                                                 Buyer must capture the ticketed airfare and rail spend, and the booked hotel and rental car spend (booked
                                    What share of our travel is booked via the approved Travel Management Company and
 2    Booking Visibility            selfbooking
                                                                                                                                 rate * room nights or rental days), as reported by the approved Travel Management Company, hotel booking
                                    tool (Self Booking Tool)?                                                                    agencies, and Self Booking Tool.
                                                                                                                                 Buyers may choose as the denominator the total travel spend as captured either by their general ledger or by
                                                                                                                                 their Expense Reporting System.
                                                                                                                                 (Travel-related spend on Corporate Credit Card) divided by Total Travel Spend.
 3    Payment Visibility            What share of our travel spend is paid via the Corporate Card?
                                                                                                                                 Total Travel Spend may be obtained via the general ledger or the Expense Reporting System.
                                                                                                                                 (Market rate - Negotiated rate) x Units purchased using the negotiated fare or rate.
                                                                                                                                 A supplier’s contracted prices need to be compared to the relevant undiscounted fares or rates.
                                  How much have we saved through the negotiation and adoption of our preferred supplier          Multiply the difference between the market rate and the negotiated rate (the price savings) by the unit volume
 4    Realised Negotiated Savings
                                  contracts?                                                                                     (e.g. number of room nights) purchased. Sum this amount across all purchases made with the supplier. This is
                                                                                                                                 the contract’s savings for the organisation.
                                                                                                                                 Sum each contract’s savings to obtain the travel program’s Realised Negotiated Savings.
                                                                                                                                 A supplier’s contracted prices need to be compared to the relevant undiscounted fares or rates.
                                                                                                                                 Multiply the difference (the price savings) by the unit volume purchased. Sum this amount across all purchases
                                                                                                                                 made with the supplier. This is the contract’s savings.
                                                                                                                                 Convert all purchases made with the supplier to the supplier’s undiscounted (a.k.a., pre-discounted, or gross)
 5    Contract Competitiveness      How good are our negotiated contracts (air, hotel, car, Travel Management Company)?
                                                                                                                                 spend. This quantifies the amount of pre-discounted spend.
                                                                                                                                 Divide the contract’s savings by the supplier’s undiscounted spend. This is the contract’s savings rate.
                                                                                                                                 Construct a ratio by placing the buyer’s savings rate in the numerator, and the benchmarked peer group’s
                                                                                                                                 average savings rate in the denominator. The result is the Contract Competitiveness Ratio.

                                                                                                                                 (Travel Program Costs) divided by (Total Travel Spend).
                                                                                                                                 Include the buyer’s FTE labor costs, data reporting, consulting and other third-party fees, and all fees paid
 6    Cost of Managed Travel        What percentage of our travel spend goes to managing it?                                     to Travel Management Companies. Include security-related costs, if those costs primarily benefit travellers.
                                                                                                                                 For the denominator, use either the general ledger or the Expense Reporting System to obtain total travel
                                                                                                                                 spend.
                                                                                                                                 (Air and Rail spend in cabins that are higher than policy allowed) divided by (Air and Rail spend in
 7    Cabin Non-compliance          To what degree are travelers not complying with our cabin policy?
                                                                                                                                 all cabins).
      Lowest Logical Airfare Non-
 8                                  To what extent are we spending more than our lowest logical airfare policy suggests?
      compliance                                                                                                                 (Sum of (Ticket Price minus Lowest Logical Airfare)) divided by All Ticketed Air Spend
      Advance Booking Non-                                                                                                       (Ticketed Air Spend booked less than X days in advance) divided by (All Ticketed Air Spend),
 9                                  To what extent are our travellers not complying with our advance booking travel policy?
      compliance                                                                                                                 where X is the number of days in advance specified by the travel policy.

                                                                                                                                 (Number of tickets issued through Self Booking Tool) divided by (All Tickets issued by the buyer’s
10    Online Adoption               How much are our travellers using the self-booking tool (Self Booking Tool)?
                                                                                                                                 Travel Management Company and Self Booking Tool). Alternatively, use Amount of Ticketed Spend instead of
                                                                                                                                 Number of Tickets.

                                                                                                                                 (Sum of Travel Management Company and Self Booking Tool hotel room nights booked) divided
11    Hotel Visibility              How much visibility do we have about our travelers’ hotel destinations?
                                                                                                                                 by (Sum of Travel Management Company and Self Booking Tool nights away, as measured by air and rail PNR
                                                                                                                                 departure and return dates)

12    Re-Booking Rate               How often are we changing bookings after ticketing?
                                                                                                                                 (Sum of number of changes made to each ticket) divided by (Total number of tickets issued)

                                                                                                                                 (Sum of (room nights booked in each hotel quality band) multiplied by the quality band’s numeric
13    Hotel Quality                 What is the average quality of hotels we are booking?                                        value)) divided by (sum of all room nights booked in all quality bands).
                                                                                                                                 Requires each hotel property to be assigned to a quality band, e.g., 3 Star, or 4 Crown, or Upper Upscale, etc.
                                                                                                                                 Each quality band is assigned a numeric value, such as 3 Star = 3, 4 Crowns = 4, Upper Upscale = 4, etc.
                                                                                                                                 Traveler satisfaction survey results, often expressed in percentage form as (Average Score from all travelers)
14    Traveler Satisfaction         How satisfied are our travellers with our managed travel program?                            divided by (Highest Potential Score).
                                                                                                                                 An alternative is the Net Promoter Score. See http://www.netpromoter.com/np/index.jsp
                                                                                                                                 (Booked or Ticketed spend (or units) with the preferred supplier) divided by (Contracted or Targeted spend (or
15    Contract Support              How well are we supporting our preferred suppliers?
                                                                                                                                 units) with the preferred supplier).
                                                                                                                                 Average number of days between submission of an expense report by the traveler and the date of funds
16    Reimbursement Days            How fast is our reimbursement process?
                                                                                                                                 disbursement.
                                                                                                                                 (Number of travellers for whom at least one piece of location-related data is known) divided by
                                                                                                                                 (Number of all travellers). Must be measured as a snapshot in time, e.g., on specific dates.
                                                                                                                                 Location-related data includes:
                                                                                                                                 • Airline ticket
17    Location Insights             For what share of travellers do we have information about their location?                    • Hotel booking
                                                                                                                                 • Car rental booking
                                                                                                                                 • Itinerary as entered in the corporate risk management or traveller security system
                                                                                                                                 • Traveller’s mobile phone location via GPS
                                                                                                                                 • Corporate credit card transaction activity


                                                                                                                                 Designate selected fields in the traveller profile as “Essential,” such as the mobile telephone
18    Profile Completion            How complete are our travelers’ profiles?                                                    number.
                                                                                                                                 Create for each profile a completion score by counting the number of essential fields that are complete,
                                                                                                                                 then dividing that number into the total number of essential fields. Then aggregate by creating the average
                                                                                                                                 completion score for all profiles in scope.

                                                                                                                                 For each category, rate the current quality of measuring CO2 emissions associated with corporate
                                                                                                                                 travel. Use a standard scale across each category, such as:
                                                                                                                                 • Excellent – We use a leading-edge carbon calculator designed for the relevant travel category and we
19    Carbon Visibility             How well do we measure our travel programme’s carbon impact?                                 collect sufficient data; score of 5 points
                                                                                                                                 • Adequate—We use a GHG Protocol-approved method for estimating the category’s emissions (see http://
                                                                                                                                 www.ghgprotocol.org/) and we collect sufficient data; score of 3 points
                                                                                                                                 • Inadequate – We don’t capture sufficient data or don’t have a method in place to estimate carbon
                                                                                                                                 emissions for this category; score of 1 point

                                                                                                                                 Identify a set of airline city pairs for which there exists viable rail alternatives, e.g., LON-PAR,
                                                                                                                                 PAR-BRU, etc. This set becomes the Dual Mode Markets.
20    Rail vs. Air                  How often are our travellers using rail over air in markets that offer both options?
                                                                                                                                 For each city pair in the Dual Mode Markets, count the number of tickets issued for travel by rail, and for travel
                                                                                                                                 by air.
                                                                                                                                 Calculate (Number of rail tickets) divided by (Number of rail and air tickets).
                                                                                                                                 (Number of travel data records that pass the data quality definitions) divided by (Total number of
                                                                                                                                 all travel data records).
                                                                                                                                 Data quality definitions may vary, but are expected to be very basic. Examples include:
                                                                                                                                 • Presence or absence of data in a field which is expected to contain data
21    Data Quality                  What percentage of our travel data appears usable?
                                                                                                                                 • Data values that fall within acceptable ranges
                                                                                                                                 • Data that is received in a timely manner
                                                                                                                                 • Data that conforms to the expected format

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:5/21/2012
language:
pages:3