Attachment_3_Historical_Workload_Data_.xls

XLS spreadsheet 127 KB Posted

Attached to
DTMO Travel Management Company (TMC) Services for Travel Area-3
Solicitation number
H9821018R0035
Issued by

About this file

Attachment 3 Historical Workload Data

View the file

Other files

File Type Posted
Attachment_4_Def_n_Acron_Updtd_18_Sep.docx DOCX document
Attachment_D_-_TA3_POS_Pricing_Model_20Sep2018.xlsx XLSX spreadsheet
Attachment_E_-_TA3_MSF_Pricing_Model_20Sep2018.xlsx XLSX spreadsheet
Attachment_7_GATES_Instruction_18_Sep.docx DOCX document
Att_8_revised_SBTA3_TMC_O_&_Users_Guide_18_Sep.docx DOCX document
Attachment_3_Historical_Workload_Data__14_Sept_18.xls XLS spreadsheet
DTMO_TA3__RFP_H9821018R0035_Amendment_0002_27_Sep_2018.pdf PDF
Attachment_6_PNR_Validation_Configuration_Worksheet_18_Sep.docx DOCX document
DTMO_TA3__RFP_H9821018R0035_Amendment_0001_24_Sep_18.pdf PDF
Attachment_7_GATES_Instruction_17Dec15_Final.docx DOCX document
Attachment_2_TMC_Site_Location_Spreadsheet.xlsx XLSX spreadsheet
Attachment_4_Def_n_Acron_Updtd_041218_Final_(005).docx DOCX document
Attachment_9_Wage_Determiantion_locations.docx DOCX document
Attachment_1_TMC_CTO_Data_Requirements_V4.2.1_2017_05_11.pdf PDF
Attachment_5_Part_2_Army_Reconcillation_Process_2_Feb_11.docm DOCM document
Attachment_E_-_TA3_MSF_Pricing_Model.xlsx XLSX spreadsheet
Attachment_F_-_MSF_CLIN_Schedule.docx DOCX document
Attachment_D_-_TA3_POS_Pricing_Model.xlsx XLSX spreadsheet
DTMO_TA3__RFP_H9821018R0035_31_Aug_2018.pdf PDF
Attachment_6_PNR_Validation_Configuration_Worksheet_Final_16April18.pdf PDF
Attachment_8__CTO_TMC_Orientation_&_Users_Guide__20Feb2018.docx DOCX document
Attachment_5_Part_1_AF_Recon.docm DOCM document
Show all 22

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

FY13

SBSA TA 3 Attachment 3 - Workload Data
Name of Site FY 13Gross dom air-rail #Gross intl air-rail #Gross air-rail #Gross DTS no-assist #Gross TMC AssistRef, exch, void #Ref, exch, void %Electronic tickets #Electronic tickets %LICWO #LICWO %Car-Htl with air-rail #Car-Htl only #CBA %IBA %GTR/LOPA %
ROME LAB201720819018126%208100%00%221941%99%0%
TINKER ANG0000000%0100%00%000%100%0%
ROBINS AFB16092101819118863117510%1819100%00%19757684%96%0%
HANSCOM AFB, MA4806454445985479%544100%00%56823013%87%0%
EGLIN AFB1598129171712774401448%1717100%372%186935910%90%0%
ARNOLD AFB, TN1711815300%18100%00%2286%94%0
TINKER AFB10901191209875334595%1209100%00%128941911%89%0
HILL AFB1548141168910536361267%1689100%00%175223013%87%0%
EDWARDS AFB4923152348637418%523100%00%5622135%95%0%
KIRTLAND AFB10939111841062122393%1184100%00%12835196%94%0%
CHARLESTON AFB51359572435296612%572100%00%N/AN/A12%88%0%
DOVER AFB40932441923494811%441100%00%N/AN/A15%85%0%
FAIRCHILD AFB68250732237098612%732100%00%N/AN/A25%75%0%
JB MCGUIRE-FT.DIX-LAKEHURST916240115619096618716%1156100%00%N/AN/A14%86%0%
LITTLE ROCK AFB598546521235298012%652100%00%N/AN/A3%97%0%
JB LEWIS-MCCHORD23888735831246728023966665021%31246100%00%N/A14828%92%0%
MACDILL AFB2820120640261346268074118%4026100%00%N/AN/A5%95%0%
SCOTT AFB14371411578553102518312%1578100%00%N/AN/A3%97%0%
TRAVIS AFB1354161151557145814710%1515100%00%N/AN/A4%96%0%
JB ANACOSTIA-BOLLING4221085302153158716%530100%00%000%100%0%
CANNON AFB721200921208713879%921100%00%004%96%0%
DYESS AFB38494478124667716%478100%00%006%94%0%
DAVIS-MONTHAN AFB13502731623257136619812%1623100%00%0013%87%0%
JB LANGLEY-EUSTIS19032842187582160531114%2187100%00%008%92%0%
HOLLOMAN AFB53747584964885910%584100%00%007%93%0%
HURLBURT FIELD23198433162673248955918%3162100%00%0015%85%0%
MOODY AFT52578603465576511%603100%00%003%97%0%
MT. HOME AFB505635684552311568%100100%00%003%97%0%
NELLIS AFB229221025025661936112502%100100%00%000%100%0%
SEYMOUR JOHNSON AFB700154854127727647%854100%00%007%93%0%
SHAW AFB66820987718469310612%877100%00%006%94%0%
ALTUS AFB3004434444300216%344100%103%4907%93%0%
COLUMBUS AFB357403971792185013%397100%00%42020%80%0%
JB SAN ANTONIO-FT. SAM HOUSTON200200201260%20100%210%4065%35%0%
GOODFELLOW AFB103991113047108315814%1130100%878%72078%22%0%
KEESLER AFB23303522682106257634613%2682100%2007%196968%32%0%
LACKLAND AFB84809519431313562967978%9431100%4255%337176149%51%0%
LAUGHLIN AFB24010250140110177%250100%00%1605%95%0%
LUKE AFB10411251166356810968%1166100%00%266021%79%0%
MAXWELL AFB3091262335347528783079%3353100%50%333335%65%0%
RANDOLPH AFB264645030961593150335511%3096100%10%683038%62%0%
SHEPPARD AFB19472552202342168773%2202100%00%87086%14%0%
TYNDALL AFB1192113130547782819115%1305100%141%48906%94%0%
VANCE AFB2762630247255279%302100%10%4605%95%0%
Total76030153769139625956654401292014%88526100%7821%12161609516%84%0%

FY14

SBSA TA 3 Attachment 3 - Workload Data
Name of Site FY 14
10/1/13 thru 09/31/14Gross dom air-rail #Gross intl air-rail #Gross air-rail #Gross DTS no-assist #Gross TMC AssistRef, exch, void #Ref, exch, void %Electronic tickets #Electronic tickets %LICWO #LICWO %Car-Htl with air-rail #Car-Htl only #CBA %IBA %GTR/LOPA %
ROME LAB, NY167980176096579529717%1760100%01%16052025%95%0%
TINKER ANG1860186144423117%186100%01%6045257%93%0%
ROBINS AFB1137111231249742268271149012%12497100%01%2047620777%93%0%
HANSCOM AFB45604450042445255972414%5004100%01%39044198%92%0%
EGLIN AFB498735853453443190290617%5345100%1071%451910106%94%0%
ARNOLD AFB2463259118141218%259100%01%300526%94%0
TINKER AFB404938444332248218546510%4433100%01%34086984%96%0%
HILL AFB20681552223144577821310%2223100%01%24218957%93%0%
EDWARDS AFB5541356749374488%567100%01%6352569%91%0%
KIRTLAND AFB93382101593679576%1015100%01%791294%96%0
CHARLESTON AFB3,4795153,994241375344711%3,994100%10%4984120%80%0%
DOVER AFB3,0994223,521769275240111%3,521100%20%5765917%83%0%
FAIRCHILD AFB4,3722984,670289438160213%4,670100%190%7082225%75%0%
JB MCGUIRE-FT.DIX32,9021,72834,6306,595280354,41313%34,630100%200%5,04744712%88%0%
LITTLE ROCK AFB35823663948677327151413%3948100%20%5323613%87%0%
JB LEWIS-MCCHORD37026574142767622836539695716%42767100%00%91982930%70%0%
MACDILL AFB181391032328462835020112477917%28462100%330%71871325%95%0%
SCOTT AFB440648248881143374559312%4888100%20%7984517%83%0%
TRAVIS AFB983111201095191910032132312%10951100%50%12891614%86%0%
JB ANACOSTIA-BOLLING5938167457617686%674100%00%008%92%0%
CANNON AFB461121582165669116%582100%00%004%96%0%
DYESS AFB282910113840847299361716%3840100%00%006%94%0%
DAVIS-MONTHAN AFB22143222536682185433113%2536100%00%0013%87%0%
JB LANGLEY-EUSTIS633546871065818613%687100%00%008%92%0%
HOLLOMAN AFB58566651625897311%651100%00%007%93%0%
HURLBURT FIELD776168944240704788%944100%00%0015%85%0%
MOODY AFT82021010302447869910%1030100%00%003%97%0%
MT. HOME AFB72225197320876511812%973100%00%003%97%0%
NELLIS AFB17353752110913119733716%2110100%00%000%100%0%
SEYMOUR JOHNSON AFB25562362792644214827810%2792100%00%007%93%0%
SHAW AFB1,5613381,899292160723913%1,899100%00%006%94%0%
ALTUS AFB1,0981281,22622120415813%1,226100%141%228413%87%0%
COLUMBUS AFB9365098623575117418%986100%00%1191211%89%0%
JB SAN ANTONIO-FT. SAM HOUSTON26,434455630,990755423436437614%30,990100%13534%9,22511942%58%0%
GOODFELLOW AFB3,2211883,40916732422076%3,409100%2176%243169%31%0%
KEESLER AFB6,51610537,5693007269103214%7,569100%85511%527067%33%0%
LACKLAND AFB25,746226428,01074912051925949%28,010100%7693%6,6554846%54%0%
LAUGHLIN AFB8551501,005372633939%1,005100%30%9018%92%0%
LUKE AFB3,0854693,55493426203239%3,554100%20%8572317%83%0%
MAXWELL AFB7,0875877,67415976077101113%7,674100%100%1,2761038%62%0%
RANDOLPH AFB8,69111869,87732176660127113%9,877100%10%1,9764127%73%0%
SHEPPARD AFB5,8265636,38925561342804%6,389100%00%697176%24%0%
TYNDALL AFB4,1373804,5171639287874516%4,517100%210%1,955406%94%0%
VANCE AFB9393197031965110511%970100%00%14426%94%0%
Total25752538075296014700872259273906513%296014100%34361%80209809216%84%0%

FY15

SBSA TA 3 Attachment 3 - Workload Data
Name of Site FY 15 10/1/14 thru 09/31/15Gross dom air-rail #Gross intl air-rail #Gross air-rail #Gross DTS no-assist #Gross TMC AssistRef, exch, void #Ref, exch, void %Electronic tickets #Electronic tickets %LICWO #LICWO %Car-Htl with air-rail #Car-Htl only #CBA %IBA %GTR/LOPA %
ROME LAB, NY2122107222921488139318%2229100%01%24451545%95%0%
TINKER ANG60820628531978714%628100%00%3814715%85%0%
ROBINS AFB1286612551412183785743182613%14121100%40%1384014325%95%0%
HANSCOM AFB562243160535653400107318%6053100%00%52691588%92%0%
EGLIN AFB6067483655054481102119218%6550100%521%44203126%94%0%
ARNOLD AFB4062042641016389%426100%00%6463512%88%0%
TINKER AFB474853352814239104260611%5281100%00%39352925%95%0%
HILL AFB24663192725202669943216%2725100%00%16204311%89%0%
EDWARDS AFB92285100789111611411%1007100%00%1078439%91%0%
KIRTLAND AFB93382101593679576%1015100%00%791294%96%0%
CHARLESTON AFB3,7475384,285440384547311%4,285100%00%74815820%80%0%
DOVER AFB3,2583053,5631117244639811%3,563100%00%7188610%90%0%
FAIRCHILD AFB4,6202534,873599427455511%4,873100%261%9034330%70%0%
JB MCGUIRE-FT.DIX29,0502,40131,4518,355230964,27314%31,451100%70%5,8741,15930%70%0%
LITTLE ROCK AFB37114194130939319148812%4130100%00%73610515%85%0%
JB LEWIS-MCCHORD37904779845702791637786730316%45702100%30%13359528%92%0%
MACDILL AFB2040212296326981071621982499815%32698100%120%1044055630%70%0%
SCOTT AFB15803110316906596810938174310%16906100%00%573744618%82%0%
TRAVIS AFB10733138012113140310710141712%12113100%80%17229120%80%0%
JB ANACOSTIA-BOLLING1111623471346354727991206715%13463100%00%49132617%93%0%
CANNON AFB5459894635313844969100316%6353100%290%14471673%97%0%
DYESS AFB24643122776508226842415%2776100%00%520603%97%0%
DAVIS-MONTHAN AFB77331631936421187246117413%9364100%00%23001724%96%0%
JB LANGLEY-EUSTIS25209358728795794020855376113%28795100%130%11513187315%85%0%
HOLLOMAN AFB29692783247961228632810%3247100%90%10087622%78%0%
HURLBURT FIELD13278311316391403312358262016%16391100%100%53744333%97%0%
MOODY AFB37334914224443378162015%4224100%10%8091152%98%0%
MT. HOME AFB29913023293533276042713%3293100%341%540454%96%0%
NELLIS AFB120311250132813283999811278%13281100%170%37512574%96%0%
SEYMOUR JOHNSON AFB3589621421079234183127%4210100%551%595529%91%0%
SHAW AFB454614085954769518578513%5954100%130%10191834%96%0%
ALTUS AFB1,0751891,26434292217414%1,264100%60%3341012%88%0%
COLUMBUS AFB1,071711,14233980323420%1,142100%10%1485315%85%0%
JB SAN ANTONIO-FT. SAM HOUSTON28,243545733,7001047523225431313%33,700100%3131%11,74851231%69%0%
GOODFELLOW AFB3,4722933,76528734782457%3,765100%1574%4792053%47%0%
KEESLER AFB5,57110266,597572602595514%6,597100%4487%7254162%38%0%
LACKLAND AFB30,600251433,1141018822926318110%33,114100%2781%8,25226041%59%0%
LAUGHLIN AFB740537933114829712%793100%20%113112%98%0%
LUKE AFB3,2004963,6961086261038810%3,696100%80%1,0108019%81%0%
MAXWELL AFB8,8296339,46219067556130914%9,462100%30%2,13415435%65%0%
RANDOLPH AFB11,365150612,87135419330182414%12,871100%10%4,02619223%77%0%
SHEPPARD AFB5,5696566,22570955162734%6,225100%00%5106879%21%0%
TYNDALL AFB5,4488066,25421814073108917%6,254100%210%2,9942656%94%0%
VANCE AFB812328443734718710%844100%00%130131%99%0%
Total367101597944268341286592981755628313%426834100%15310%1290301151416%84%0%

FY16

SBSA TA 3 Attachment 3 - Workload Data
Name of Site FY16
10/1/15-09/30/16Gross dom air-rail #Gross intl air-rail #Gross air-rail #Gross DTS no-assist #Gross TMC AssistRef, exch, void #Ref, exch, void %Electronic tickets #Electronic tickets %LICWO #LICWO %Car-Htl with air-rail #Car-Htl only #CBA %IBA %GTR/LOPA %
ROME LAB, NY31021263268315811053116%3268100%00%63857437%93%0%
TINKER ANG8501521,0029059716617%1,002100%01%86022111%89%0%
ROBINS AFB, GA16597192518522117636759271415%18522100%173%2262926017%93%0%
HANSCOM AFB, MA830360689098460449146016%8909100%00%118744245%95%0%
EGLIN AFB, FL19453122520698178252873377118%20698100%30016%3031520715%95%0%
ARNOLD AFB, TN5791159056624569%590100%00%10671619%91%0%
TINKER AFB, OK12510124613756109602796189814%13756100%30%1781325745%95%0%
HILL AFB, UT16226106017286154151871309718%17286100%31%205178678%92%0%
EDWARDS AFB, CA711732774446831613133018%7444100%10%1671347177%93%0%
KIRTLAND AFB, NM12656113261230961219%1326100%00%1569466%94%0%
CHARLESTON AFB4,1324004,532654387853212%4,532100%10%10654484%96%0%
DOVER AFB3,7903534,1431232291152213%4,143100%30%9831728%92%0%
FAIRCHILD AFB5,1582885,446763468373313%5,446100%220%1,2299710%90%0%
JB MCGUIRE-FT.DIX31,0362,99634,0329,394246384,62814%34,032100%120%9,7133,20314%86%0%
LITTLE ROCK AFB433543647711022374960613%4771100%10%114140130%70%0%
JB LEWIS-MCCHORD36381804944430788536545737017%44430100%90%150216825%95%0%
MACDILL AFB2294112286352271133823889498214%35227100%70%1574610493%97%0%
SCOTT AFB17673169919372596513407215211%19372100%100%86849022%98%0%
TRAVIS AFB11841190113742170412038173713%13742100%180%23473324%96%0%
JB ANACOSTIA-BOLLING1178722121399955218478226616%13999100%00%66175384%96%0%
CANNON AFB62811063734417055639114916%7344100%140%26357222%98%0%
DYESS AFB32843913675684299159816%3675100%00%7161214%96%0%
DAVIS-MONTHAN AFB959318731146623449122171715%11466100%00%30371933%97%0%
JB LANGLEY-EUSTIS30581276233343924924094464914%33343100%140%1651036924%96%0%
HOLLOMAN AFB382466344871176331154312%4487100%40%13691514%96%0%
HURLBURT FIELD14900339418294504013254285016%18294100%50%787211432%98%0%
MOODY AFT40514024453803365060814%4453100%10%10563444%96%0%
MT. HOME AFB28703593229536269337612%3229100%190%652464%96%0%
NELLIS AFB12570150614076351910557136210%14076100%100%50414234%96%0%
SEYMOUR JOHNSON AFB547952960081096491263311%6008100%490%8852144%96%0%
SHAW AFB54011590699111955796104215%6991100%120%18064843%97%0%
ALTUS AFB1,0221921,21433687813411%1,214100%00%5641079%91%0%
COLUMBUS AFB926971,02322180212012%1,023100%00%274867%93%0%
JB SAN ANTONIO-FT. SAM HOUSTON27,194565032,844971023134412013%32,844100%1761%15,961111128%72%0%
GOODFELLOW AFB3,9313474,27861636623117%4,278100%2766%77011445%55%0%
KEESLER AFB6,3479227,2696136656131118%7,269100%5788%9509263%37%0%
LACKLAND AFB35,178305638,2341023727997387510%38,234100%480%14,81574037%63%0%
LAUGHLIN AFB7241048281926369712%828100%00%194824%96%0%
LUKE AFB3,3803423,7221329239343612%3,722100%40%1,34313412%88%0%
MAXWELL AFB10,43076611,19626968500150113%11,196100%00%3,70449230%70%0%
RANDOLPH AFB14,131158515,716543310283198513%15,716100%50%6,49632223%77%0%
SHEPPARD AFB6,1277586,88563062553185%6,885100%20%68517680%20%0%
TYNDALL AFB6,42311597,58219435639134118%7,582100%220%4,5426244%96%0%
VANCE AFB711747852205659612%785100%61%129185%95%0%
Total450434669435174371841143333237184414%517437100%16521%2707753488012%88%0%

File details come from the government source that posted it.