Attachment 8 - USFK_Historical Workload Data_v2.xlsx

XLSX spreadsheet 32 KB Posted

Attached to
USFK TMC Services
Solicitation number
47QMCB26R0006
Issued by

About this file

This is a historical workload data file in spreadsheet format that provides baseline information for the USFK Travel Management Company (TMC) services contract. The file contains historical transaction and volume data that establishes the scope and scale of travel management services required by United States Forces Korea (USFK). This workload data serves as a key reference document for offerors to understand the anticipated service demands, including metrics related to travel bookings, passenger volumes, and other relevant operational benchmarks that will inform pricing and resource allocation in their proposals.

The data file was included as Attachment 8 in Amendment 0002 of the solicitation and represents the most current version provided to prospective bidders. As this is a firm-fixed price acquisition limited to Korean firms in accordance with USFK Regulation 700-19 and the US-ROK Status of Forces Agreement, the historical workload information is essential for eligible offerors to accurately estimate costs and develop competitive proposals for the single-award TMC services contract.

View the file

Other files

File Type Posted
Attachment 1 - USFK PNR Validation Worksheet (REV)_Clean_2026-08-05.docx DOCX document
0005_47QMCB26R0006_Korea_TMC_Services_RFP_Tracked_2026-08-05.pdf PDF
47QMCB26R0006_0005_SF30_2026-08-05.pdf PDF
0005_47QMCB26R0006_Korea_TMC_Services_RFP_Clean_2026-08-05.pdf PDF
USFK Regulation 700-19 dated 08-28-12.pdf PDF
Attachment 1 - USFK PNR Validation Worksheet (REV)_Tracked_2026-08-05.docx DOCX document
47QMCB26R0006_0004_SF30_2026-07-15.pdf PDF
47QMCB26R0006_Amendment0004_Questions_Received_2026-07-15.xlsx XLSX spreadsheet
47QMCB26R0006_0003_SF30_2026-07-14.pdf PDF
Attachment 7 - USFK USAF Part 1 USAF CBA Reconciliation Process.docx DOCX document
47QMCB26R0006_Korea_TMC_Services_RFP_Final_2026-07-10_Tracked.pdf PDF
47QMCB26R0006_Korea_TMC_Services_RFP_Final_2026-07-10_Clean.pdf PDF
47QMCB26R0006_0002_SF30_2026-07-10.pdf PDF
Attachment 3 - USFK_TMC_Data_Requirement Guide_v2.pdf PDF
Attachment 7 - USFK Army Part 2 CBARS Reconciliation Process System.docx DOCX document
47QMCB26R0006_Amendment0002_Questions_Received_2026-07-10.xlsx XLSX spreadsheet
47QMCB26R0006_0001_SF30_2026-07-08.pdf PDF
47QMCB26R0006_Amendment0001_Questions_Received_2026-07-08.xlsx XLSX spreadsheet
47QMCB26R0006_Korea_TMC_Services_RFP_Final_2026-07-08_Clean.pdf PDF
47QMCB26R0006_Korea_TMC_Services_RFP_Final_2026-07-08_Tracked.pdf PDF
Attachment 4 - USFK_PastPerformanceQuestionnaire.docx DOCX document
Attachment 10 - USFK Pricing Model.xlsx XLSX spreadsheet
Attachment 9 - USFK GATES Instructions.docx DOCX document
Attachment 8 - USFK_Historical Workload Data.xlsx XLSX spreadsheet
Attachment 14 - USFK_Incentive_Disincentive_Language_Examples.docx DOCX document
Attachment 1 - USFK PNR Validation Worksheet.docx DOCX document
47QMCB26R0006_Korea_TMC_Services_RFP_Final_2026-07-01.pdf PDF
Attachment 13 - USFK GTR-LOPA Instructions.docx DOCX document
Attachment 3 - USFK_TMC_Data_Requirement Guide.pdf PDF
Attachment 5 - USFK QASP.docx DOCX document
Attachment 6 - USFK Site Data Location.xlsx XLSX spreadsheet
Attachment 12 - USFK_PersonnelWorkforcePlanTemplate.docx DOCX document
Attachment 11 - USFK Workload Data Report Example.xlsx XLSX spreadsheet
47QMCB26R0006_SF_1449_2026-07-01.pdf PDF
Attachment 2 - USFK TMC Orientation and User Guide.pdf PDF
Show all 35

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

FY21

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs per location
CAMP CASEYDONGDUCHEONKOREA1,3072,0263,3334972,81938600513191100000111153,3140000000100001,043902,2821
CAMP HENRYDAEGU CITYKOREA1,4812,0333,514823,3951080034355000000226173,478000000038002,24611901,1491
CAMP HUMPHREYSPYEONGTAEKKOREA6,60010,88517,48554717,421551026653530000001,13611117,42100000001,2090010,53140906,5451
KUNSAN AIR BASEGUNSANKOREA1,0471,7062,753632,682492022236000000371242,74100000000002,651102001
OSAN AIR BASEPYEONGTAEKKOREA1,4935,1606,6534836,29226000703206000000512506,77900000000006,184465041
YONGSAN ARMY BASESEOULKOREA4499171,367439936302006601525000008561,37200001006001,0641202911
TOTAL:12,37722,72835,1052,11033,5441,15930509169936000002,43922435,10500001001,3530023,7191,116010,2716

FY22

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs per location
CAMP CASEYDONGDUCHEONKOREA15912,7874,3786942,8391,0630060613245600048361,068794,378057001,27000141002,7822401,7481
CAMP HENRYDAEGU CITYKOREA1,8392,4164,255583,671526002903125000057971,273654,25501001,68000195002,84311801,1111
CAMP HUMPHREYSPYEONGTAEKKOREA4,64414,19018,83464716,7471,3900065528391200001,851154,68020218,8340176004,132007590012,6079906,6071
KUNSAN AIR BASEGUNSANKOREA2,1732,3574,5301474,183200001211137200081731,45134,53002003000004,323207001
OSAN AIR BASEPYEONGTAEKKOREA3,6144,6878,3015146,8041,033004474014040001,00312,0821028,3010000167000007,652649001
YONGSAN ARMY BASESEOULKOREA3481,3361,6849676582303201015990004091673281,684020022200247001,609803121
TOTAL:14,20927,77341,9822,15635,0095,035002,4391051,097410005,1423311,22747941,9820238007,474001,3420031,8161,10509,7786

FY23

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs per location
CAMP CASEYDONGDUCHEONKOREA15543,1774,7311363,1611,2350078117348100001,14331,672824,73101360039800872003,583501,9181
CAMP HENRYDAEGU CITYKOREA1,7702,5504,3201593,726435003408143100049031,187604,32002001,50300155003,27213901,0591
CAMP HUMPHREYSPYEONGTAEKKOREA4,03913,97518,01483515,8961,3830074146406250003,017235,19420318,0140162001,554002,2040012,66712406,9981
KUNSAN AIR BASEGUNSANKOREA2,1432,2844,4271974,082148001611043300076311,284664,42700002000004,225202001
OSAN AIR BASEPYEONGTAEKKOREA3,4085,5038,9116947,2641,0530052656178100001,04332,043758,911000062000008,304607001
YONGSAN ARMY BASESEOULKOREA4452,0502,4951838451,4680052619265400004933823392,49500007300271002,3133703791
TOTAL:13,35929,53942,8982,20434,9745,722003,0751561,383890006,9493612,20352542,8980300003,592003,5020034,3641,114010,3546

FY24

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs per location
CAMP CASEYDONGDUCHEONKOREA11833,6604,8434792,9831,3810089922555620001,22641,703564,84301370013100900004,07070309701
CAMP HENRYDAEGU CITYKOREA1,7413,5455,2863133,1521,8210061922393140001,63712,345465,28609100408001,146005,40560804232
CAMP HUMPHREYSPYEONGTAEKKOREA2,60614,31116,91765415,0701,1930071034445350002,26553,93110416,917022200793001,3750013,6461,83202,8146
KUNSAN AIR BASEGUNSANKOREA2,1642,5984,7621984,412152002072586150001,07871,532574,76201004001004,528235001
OSAN AIR BASEPYEONGTAEKKOREA3,7165,7689,4844488,3247120068365299290001,512142,4311159,484000037000008,875609001
YONGSAN ARMY BASESEOULKOREA4072,5933,0002019891,81000641164712800050198601513,000019001900223002,57331001341
TOTAL:11,81732,47544,2922,29334,9307,069003,7591842,2491830008,2194012,80252944,2920470001,392003,6450039,0974,29704,34112

FY25

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs per location
CAMP CASEYDONGDUCHEONKOREA12363,6234,8599012,8561,10200791316152050001,39241,874575,857012300100998004,5311,326001
CAMP HENRYDAEGU CITYKOREA1,3104,1755,4851,3602,4621,6630068640534620001,70232,328706,5850610067001,100005,5541,031092
CAMP HUMPHREYSPYEONGTAEKKOREA3,91411,62415,53863214,3031,4060048237352760004,91686,32510719,415025900716003,8770016,2783,107006
KUNSAN AIR BASEGUNSANKOREA1318231936372303,126281001601675120003490659633,63702004000003,474163001
OSAN AIR BASEPYEONGTAEKKOREA2,2276,0918,3187206,71788100648924001110001,086361,9181388,318000032000007,866452001
YONGSAN ARMY BASESEOULKOREA2932,9933,2868671,3591,06001664335171710005169939453,45101800300162002,942509001
TOTAL:10,29830,82541,1234,71030,8236,393013,4312492,4936370009,9616014,04348047,263046300823006,1370040,6456,5880912

FY23 DAM NECK

Location (Site, Base, Installation, etc.)CityStateCountryNumber of Domestic Air Tickets issuedNumber of International Air Tickets issuedNumber of Total Air Tickets issuedNumber of Air Tickets issued via DoD OBTNumber of Air Tickets issued via TMC Assist (TMC created PNR)Number of Air Tickets issued via TMC Assist (DoD OBT created PNR with TMC Assist)Number of Domestic Rail Tickets issuedNumber of International Rail Tickets issuedNumber of Car bookings with Air/Rail TicketNumber of Car Only bookings without Air/Rail TicketNumber of Lodging bookings with Air/Rail TicketNumber of Lodging Only bookings without Air/Rail TicketNumber of Air Group movementsNumber of Bus ChartersNumber of Individual Bus ReservationsNumber of Tickets reissued after Ticket issuanceNumber of Enroute changesNumber of Refunds / Exchanges / VoidsNumber of Tickets issued on day of travelNumber of Tickets issued electronicallyNumber of Paper Tickets issued (where applicable)Number of Tickets issued for LICWONumber of Human Remains transactionsNumber of Military Working Dog transactionsNumber of Pet Travel transactionsNumber of Ferry arrangementsNumber of Contractor Travel transactionsNumber of AMC/PE transactions (where applicable)Number of Traveler Requested Paper Tickets issuedNumber of Leisure Only travel transactions (where applicable)Number of Tickets issued utilizing IBA billingNumber of Tickets issued utilizing CBA billingNumber of Tickets issued utilizing UC billingNumber of Tickets issued utilizing GTR/LOPANumber of CBAs utilized per location
OCTNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES6061707760776000261811311670009345249247760000000000N/AN/AN/AN/A
NOVNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES44515459905990002171051811130001004918525990000000000N/AN/AN/AN/A
DECNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES630177807080700025863179930009751271128070000000000N/AN/AN/AN/A
JANNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES79518097509750003031341347300010642287139750000000000N/AN/AN/AN/A
FEBNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES53722676307630002251241467900013673333217630000000000N/AN/AN/AN/A
MARNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES8463011,1470114700033720519066000115543653411470000000000N/AN/AN/AN/A
APRNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES4931346270627000219117877800016849353256270000000000N/AN/AN/AN/A
MAYNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES68211079207920003172019712200012159232227920000000000N/AN/AN/AN/A
JUNENAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES59825485208520002476718913800014182275278520000000000N/AN/AN/AN/A
JULYNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES407159566056600018714911317200011649249115660000000000N/AN/AN/AN/A
AUGNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES1,1092451,35401,35400042825039017100014968378713540000000000N/AN/AN/AN/A
SEPTNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES123661890189000681275513000015976313131890000000000N/AN/AN/AN/A
TOTALNAS DAM NECKVIRGINIA BEACHVIRGINIAUNITED STATES7,2712,1769,4470944700030671623189214020001501697349021194470000000000N/AN/AN/AN/A

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