excel expert
bissouh
TravelchartsJan20.pptxTravel is Substantially Up
1
Travel & P2W Expenses (April 2018-Aug2019)
Travel
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 587972.76999999979 487116.16999999969 520638.35000000021 480757.56999999948 394350.19 385516.54000000004 450385.07000000018 371762.63 311712.96000000002 392722.1300000003 380070.58999999968 429063.30999999994 520387.19000000018 533706 551748 504864 563866 P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 88484.859999999986 63816.539999999994 56774.020000000011 92475.599999999977 31617.780000000013 43248.819999999985 55602.639999999985 88320.160000000033 58191.73000000001 134345.77000000025 163501.95999999996 85523.370000000024 146314.63999999993 119047 162106 126133 73933 Total Travel + P2W
Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 676457. 62999999977 550932.70999999973 577412.37000000023 573233.16999999946 425967.97000000003 428765.36000000004 505987.7100000002 460082.79000000004 369904.69000000006 527067.90000000061 543572.54999999958 514586.67999999993 666701.83000000007 652753 713854 630997 637799
Travel Reports
Top 10 Travelers – Sep to Nov
Outside Policy Air Travel Sep - Nov
Top 10 Travelers – May to Aug
Outside Policy Air Travel May - Aug
Top 20 Travelers not Booking with Concur Travel Sep - Nov
Need to:
Use Concur
Travel less
Comply with travel policy
Pick low rates of stay
2
Spend CategoryApr-18May-18Jun-18Jul-18Aug-18Sep-18Oct-18Nov-18Dec-18Jan-19Feb-19Mar-19Apr-19May-19Jun-19Jul-19Aug-19Total
Travel587,973487,116520,638480,758394,350385,517450,385371,763311,713392,722380,071429,063520,387533,706551,748504,864563,8667,866,639
Air201,102127,091143,952128,30872,938101,396109,20779,63751,00894,39384,634100,643134,242156,106164,597128,603115,2191,993,077
Hotel198,641138,441165,230148,860149,389126,974146,746132,601100,308135,366140,375145,541213,104178,883197,638185,696252,0482,755,842
Meals102,111120,534117,178115,51389,06088,204109,59284,54897,73699,94487,894107,22398,211114,971113,476117,087117,3011,780,582
Car Rental28,92521,35528,06026,09722,96116,90921,22519,33514,86812,66714,99618,27114,32421,33415,76820,12821,376338,600
Cabs/Tolls/Parking/Fuel50,85472,78060,76557,00654,66747,28859,76950,25444,15744,54547,67353,53253,36956,26154,58949,12151,614908,244
All Other Travel6,3406,9165,4544,9745,3354,7453,8445,3893,6355,8074,4983,8527,1376,1515,6804,2296,30890,295
P2W88,48563,81756,77492,47631,61843,24955,60388,32058,192134,346163,50285,523146,315119,047162,106126,13373,9331,589,437
Total Travel + P2W676,458550,933577,412573,233425,968428,765505,988460,083369,905527,068543,573514,587666,702652,753713,854630,997637,7999,456,076
NameMay-19Jun-19Jul-19Aug-19Grand Total
Cates, Brian L$9,456$8,526$8,257$7,262$33,500
Rembish, Michael James$6,022$8,237$5,409$9,873$29,541
Madgey, Christopher Michael$6,382$6,839$3,466$8,785$25,471
Visser, Elizabeth Sokoly$5,931$5,958$8,242$4,899$25,029
Gomez, Jesus$1,009$6,889$6,519$8,350$22,768
Rasmussen, Eric T$3,602$3,371$4,552$10,548$22,073
Fleming, Rhett S$5,156$4,725$5,293$5,102$20,275
Martella Jr, Richard Vincent$7,655$4,858$4,995$2,579$20,087
Kessler, Jason Daniel$5,440$6,077$3,943$3,589$19,048
Scott, Bradley C$6,229$3,655$3,979$4,437$18,300
All Other Travelers (761)$472,812$498,913$450,018$505,972$1,927,715
Grand Total$529,693$558,046$504,672$571,395$2,163,807
Traveler NameMayJunJulAugTotal
MAEDER/MICHAEL CHARLES MR1 2 4 4 11
SACHLEBEN/PATRICK CHRISTIAN MR3 2 2 1 8
CHUI/COLIN3 3 1 - 7
ST CLAIR/COLIN MR- 1 3 3 7
REMBISH/MICHAEL JAMES2 1 3 - 6
ROSADO/GILBERTO R MR2 1 3 - 6
OLIVENCIA SANCHEZ/MONICA2 - 3 - 5
WILLIAMSON/JACK W MR1 2 2 - 5
WOODS/JARVIS CORDELL MR- 1 3 1 5
CLONINGER/DAVID ANDREW- - - 4 4
ALL OTHERS (80)20 32 30 45 127
Grand Total34 45 54 58 191
Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance
Policy Violation Reasons# of TicketsMissed Savings
Flight Time Declined36$11,464
Routing Declined - Stops/Connections26$8,720
Declined for Preferred Carrier15$3,728
Declined Alternate Carrier7$2,233
Alternate Airport Declined1$244
Grand Total85$26,390
