Sales Activity Report.doc

DOC document 47 KB Posted

Attached to
On-Site Travel Management Services for U. S. Embassy in Gaborone, Botswana
Solicitation number
SBC400-11-R-0002
Issued by

About this file

Sales Activity Report Attachment

View the file

Other files

File Type Posted
TMC Solicitation SBC400-11-C-0421.docx DOCX document
SF-1449.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

QUARTERLY SALES ACTIVITY REPORT

CONTACT NAME AND PHONE NO.

IATA NUMBER

REPORT DATE AND PERIOD COVERED

Page 1 of _____

SUMMARY

AIR TRANSPORTATION

SALES

(IN THOUSANDS)

TICKETS SOLD

INTER-NATIONAL ABSTRACT
OTHER TRANS-PORTATION
OTHER SERVICES
AGENCY NAME (A)
FIPS CODE (B)
YCA/ MCA (C)
TOTAL (D)
COST AVOIDANCE (E)
YCA/ MCA (F)
YDG/ MDG (G)
ALL OTHER (H)
TOTAL (I)
CITY PAIR EXCEPTIONS(J)
SALES (K)
TICKET (L)
TOTAL SALES (M)
TOTAL TICKET (N)
HOTEL BOOKINGS (O)
CAR RENTALS (P)

QUARTERLY SALES ACTIVITY REPORT INSTRUCTIONS

This form shall be used by the Contractor for submission of the Quarterly Sales Activity Report. The form shall be submitted in accordance with the requirements of the contract. This form may be duplicated by the Contractor.

Contact Name and Telephone No. - Name and phone number of the person who can answer questions regarding this report. This should typically be the Contractor's Project Manager, unless the Contracting Officer approves another person for purposes of answering questions regarding this report.

IATA Number - The 5 digit (Air Traffic Code) number within the International Air Transport Association Number

Report Date - Indicate year and month (YYMM) of the reporting period.

NOTE: - The Contracting Officer's Representative will provide instructions to the Contractor regarding presentation of the data by agency. Typically, all travel for each agency supported by the Contractor under this contract will be combined per line. For example, all travel for personnel using Dept. of State funds will be presented on one line; all travel for U.S. Agency for International Development on another line, etc.

(A) Agency Name - List name of agency, e.g., State, AID.

(B) FIPS Code - List the appropriate Federal Information Processing Standard (FIPS) code for each agency name.

Air Transportation - Indicate in this section only data related to airline sales, cost avoidance, and tickets. All refunds and cancellation should be deducted from the dollar values and number of tickets reported. NOTE: The following guidelines shall be used to record Airlines Sales and Ticket entries for multiple leg trips where more than one discount or non-discount combinations are used>

--Use VALIDATING CARRIER OR FIRST LEG to classify the ticket.

--If the VALIDATING CARRIER OR FIRST LEG is one of the following, record the ticket as YCA/MCA, or YDG/MDG, or All Other.

SALES - Dollar amounts for airline transportation. NOTE: ENTRIES MUST BE ENTERED IN THOUSANDS OF DOLLARS ROUNDED TO THE FIRST DECIMAL POINT (e.g., $25,549 would be entered as 25.5).

(C) YCA/MCA - Dollar value of tickets sold at contract city-pair fare.

(D) Total Sales - Total of all air transportations.

(E) Cost Avoidance - Difference between actual fares paid and base fares of lowest UNRESTRICTED available "Y".

(F) YCA/MCA - Tickets sold using unrestricted/restricted contract city-pair discount fare.

(G) YDG/MDG - Tickets sold at noncontract Government discounts.

(H) All Others - Tickets sold at other than YCA, MCA, or YDG/MDG fares

(I) Total Tickets - Total tickets sold; sum of columns (F through H).

(J) City Pair Exceptions - Total number of instances where contract city pairs existed but YCA or MCA Fares were not used.

(K)/(L) International Abstract - Sales, Columns (K) and (L) for International Travel, also reflected in Columns (D) and (I), respectively. (Sales dollars are to be entered in thousands of dollars rounded to the nearest first decimal point.)

(M)/(N) Other Transportation - Total Sales Column (M) and Total Tickets Column (N) with refunds and cancellations deducted, for rail and bus transportation.

Other Services (NOTE: Indicate only one booking per trip/ticket sold, for hotel and car rental, when several hotels and cars were booked for a specific trip.

--(O) Hotel Bookings - The number of times, (one per ticket sold) hotels were booked for travelers.

--(P) Car Rentals - The number of times, (one per ticket sold) car rentals were booked for travelers.

Totals - Add each column of the report on the last page, indicating the grand totals for the reporting period.

File details come from the government source that posted it. Updated .