RFP_Attachment_A_-_Minimum_Capbilities.pdf

RFP QMAC-CY-140001-N

Attachment A – Minimum Capabilities - Page 1

ATTACHMENT – A - TMIS 2.0 Minimum Capabilities

Introduction

The TMIS 2.0 solution shall meet or exceed all minimum capabilities outlined in Section C. These capabilities are needed to support government-wide travel data service sourcing programs and policy stakeholders. Reporting capabilities can be delivered through traditional transactional / summary report, or may be delivered via more advanced capabilities such as multi-dimensional reporting data sets / tools (w/drill down, drill across capabilities), or visualization tools The selection of reporting type(s)/level(s) shall be based on the optimal method to streamline and provide greatest ease for display of information, to enhance further travel management analysis and decisions, etc.

In the tables below, each capability has been placed into one of four categories: Sourcing – CPP, Sourcing – FedRooms®, Policy and Governance and Quality Checks and Enhancements. Additionally, for each capability, a column has been added that identifies the minimum data source to use to meet the capability (corresponds to source, e.g. ETS, TMC, GSA SmartPay) , if applicable. The Contractor shall specify, as part of its proposal, any other additional data source it will provide along with which report(s) addresses the minimum capabilities, what data is contained in the report(s), and how the report(s) can be used to meet the capability.

1. Sourcing - City Pairs Program

Minimum Capability Minimum Data Source Additional Data Source Provided Report(s)

A) Basic acquisition sourcing data - true one way O&D passenger counts (by market/city-pair)

Reservation, ARC

B) Government-wide and agency summary behavior metric reports, including advanced reservation and ticketing, online/offline utilization, ancillary fee charges, fare type utilization and average fare paid

Expense, Reservation

C) Market benchmark data to support bid analysis, negotiation, award

3rd party, CPP award and bid lists

D) Market characterization reporting for all

3rd party, CPP award and bid lists

Attachment A – Minimum Capabilities - Page 2 potential, bid, and flown markets including QSI

E) Total air spend by channel (reservation, card, expense) to assess leakage, establish a leakage factor if necessary, and communicate with agencies exhibiting high leakage re: price or visibility impacts

Reservation, expense, charge card, ARC

2. Sourcing - FedRooms

Minimum Capability Minimum Data Source Additional Data Source Provided Report(s)

A) Basic acquisition sourcing data - raw Charge Card data

Charge Card, supplier

B) Government-wide summary property reports, including roll-up of total room nights and spend (base rate AND total) by property, chain, brand.

Expense, reservation, master hotel table (normalization)

C) Market benchmark data to support procurement process

3rd party

D) Total spend by channel (reservation, card, expense) to assess leakage, establish a leakage factor if necessary, and communicate with agencies exhibiting high leakage to communicate price impacts

Expense, reservation, charge card

E) Summary and by market FedRooms® utilization, Expense, reservation, per diem tables

Attachment A – Minimum Capabilities - Page 3 including rate paid differential to per diem

F) FedRooms® non-use summary (exception summary) including rate paid compared to per diem and FedRooms®

Expense, reservation, per diem tables

G) Non-contract cities total room nights and spend for destinations without a hotel under contract

Expense, reservation

H) Non-FedRooms use at FedRooms® properties room nights and spend differential to per diem and FedRooms®

Expense, reservation, per diem tables

3. Policy and Governance

Minimum Capability Minimum Data Source Additional Data Source Provided Report(s)

A) Room nights by per diem zone (per diem adjustment impacts)

Charge Card, per diem tables

B) Airfare Spend Expense

C) Airfare Losses Expense, reservation, fare basis code matching

D) Lodging Spend Expense

E) Rental Car Spend Expense

F) Unrealized Airfare Savings

Expense, reservation, fare basis code matching

G) Per Diem Differential Expense, reservation, per diem tables, master hotel table (normalization)

H) Advanced Booking Reservation

I) Distribution Channel Expense, reservation

Attachment A – Minimum Capabilities - Page 4

Leakage

J) Card Issuance Charge Card, expense

K) Card Usage Charge Card, expense

L) Hotel Attachment Reservation

M) Self-Service Adoption Reservation, expense

N) Trip Purpose Expense

O) Trip Duration Expense

P) Ticket Changes Reservation

Q) Use of Lowest Fare Expense, reservation, fare basis processing

R) TMC After Hours Services Billing

S) Use of Preferred Hotels Expense, reservation, FedRooms property and rate tables, master hotel table (normalization)

T) Use of Preferred Car Rentals

Reservation

U) Rental Car Attachment Reservation, supplier

V) Exception Codes (such as non-US carrier, non-CPP fare, etc.)

Reservation, authorization / expense

4. Quality Checks and Enhancements

Minimum Capability

Additional Data Source Provided Report(s)

Mileage

One-Way / Round Trip / Circle Trip Indicator

Trip Duration (Number of Days)

Travel Time (for each O&D, Hours:Minutes)

Class of Service (for each flight/leg)

CPP (City Pair Program) Fare Indicator (_CA / YCA / BCA) (for each flight - If a connection is allowed under CPP

Attachment A – Minimum Capabilities - Page 5 contract on a particular O&D, than all flights in that O&D would be CPP flights)

Restricted Fare Indicator (for each flight/leg)

Contract Carrier Indicator (for each flight/leg)

GHG Emission (for each flight/leg) [If CLIN is offered]

Refund Indicator (Is this transaction a refund? Full or partial refund?)

Exchange Indicator (Is this transaction an exchange?)

Base Fare (for each flight/leg)

Taxes (for each flight)

Connection (XO) indicator (for each flight) and process for assigning when missing / error

Currency

Name, address consistency - process to normalize vendor, carrier, hotel, etc. names and addresses