Attachment 8 - USFK_Historical Workload Data.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
USFK TMC Services
Solicitation number
47QMCB26R0006
Issued by

About this file

This is a historical workload data attachment documenting Travel Management Company (TMC) services activity across United States Forces Korea (USFK) installations from fiscal years 2021 through 2024, with additional monthly data for Naval Air Station Dam Neck in Virginia for FY23.

The data encompasses six primary USFK locations in South Korea—Camp Casey, Camp Henry, Camp Humphreys, Kunsan Air Base, Osan Air Base, and Yongsan Army Base—tracking comprehensive travel transaction metrics across four fiscal years. Key performance indicators include total air tickets issued (ranging from 35,105 in FY21 to 44,292 in FY24), distribution of tickets between domestic and international travel, booking methods (DoD OBT versus TMC-assisted), ground transportation arrangements (car rentals and lodging bookings), ancillary services (human remains transport, military working dogs, pet travel), and billing mechanisms (IBA, CBA, UC, and GTR/LOPA). The data reveals that Camp Humphreys consistently represents the largest volume location with approximately 16,917-18,834 total air tickets annually, while the contractor maintains approximately six Cooperative Booking Agreements (CBAs) across all USFK locations. The supplementary NAS Dam Neck dataset for FY23 provides monthly granularity showing 9,447 total air tickets issued with monthly fluctuations ranging from 189 to 1,354 tickets, demonstrating seasonal travel pattern variations. This historical baseline establishes the performance requirements and operational scope for the ongoing USFK TMC Services contract solicitation 47QMCB26R0006.

View the file

Other files

File Type Posted
0005_47QMCB26R0006_Korea_TMC_Services_RFP_Tracked_2026-08-05.pdf PDF
47QMCB26R0006_0005_SF30_2026-08-05.pdf PDF
Attachment 1 - USFK PNR Validation Worksheet (REV)_Clean_2026-08-05.docx DOCX document
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
Attachment 8 - USFK_Historical Workload Data_v2.xlsx XLSX spreadsheet
47QMCB26R0006_Amendment0002_Questions_Received_2026-07-10.xlsx XLSX spreadsheet
47QMCB26R0006_Amendment0001_Questions_Received_2026-07-08.xlsx XLSX spreadsheet
47QMCB26R0006_0001_SF30_2026-07-08.pdf PDF
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 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 4 - USFK_PastPerformanceQuestionnaire.docx DOCX document
Attachment 10 - USFK Pricing Model.xlsx XLSX spreadsheet
Attachment 9 - USFK GATES Instructions.docx DOCX document
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 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

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 .