excel expert
bissouh
CopyofCSCMay-Dec2019Policy_.xlsxTravel Spend Graph
| Travel Spend (APR18-NOV19) | |||||||||||||||||||||
| Created by E.Badjeck on 01/08/20 | |||||||||||||||||||||
| Travel Spend (APR18-NOV19) | |||||||||||||||||||||
| Created by E.Badjeck on 01/08/20 | |||||||||||||||||||||
| Spend Category | 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 | Sep-19 | Oct-19 | Nov-19 | Total Travel + P2W |
| Travel | 587,973 | 487,116 | 520,638 | 480,758 | 394,350 | 385,517 | 450,385 | 371,763 | 311,713 | 392,722 | 380,071 | 429,063 | 520,387 | 531,794 | 561,659 | 512,050 | 605,982 | 528,962 | 635,491 | 481,646 | 9,570,039 |
| Air | 201,102 | 127,091 | 143,952 | 128,308 | 72,938 | 101,396 | 109,207 | 79,637 | 51,008 | 94,393 | 84,634 | 100,643 | 134,242 | 156,614 | 166,477 | 130,789 | 121,714 | 133,396 | 152,620 | 104,939 | 2,395,102 |
| Hotel | 198,641 | 138,441 | 165,230 | 148,860 | 149,389 | 126,974 | 146,746 | 132,601 | 100,308 | 135,366 | 140,375 | 145,541 | 213,104 | 180,251 | 198,365 | 186,810 | 268,531 | 201,084 | 255,982 | 199,588 | 3,432,187 |
| Meals | 102,111 | 120,534 | 117,178 | 115,513 | 89,060 | 88,204 | 109,592 | 84,548 | 97,736 | 99,944 | 87,894 | 107,223 | 98,211 | 100,511 | 110,065 | 108,600 | 119,867 | 113,116 | 138,833 | 102,144 | 2,110,883 |
| Car Rental | 28,925 | 21,355 | 28,060 | 26,097 | 22,961 | 16,909 | 21,225 | 19,335 | 14,868 | 12,667 | 14,996 | 18,271 | 14,324 | 21,334 | 15,768 | 21,028 | 22,149 | 18,903 | 19,750 | 17,529 | 396,455 |
| Cabs/Tolls/Parking/Fuel | 50,854 | 72,780 | 60,765 | 57,006 | 54,667 | 47,288 | 59,769 | 50,254 | 44,157 | 44,545 | 47,673 | 53,532 | 53,369 | 66,929 | 65,302 | 60,549 | 66,435 | 55,793 | 61,194 | 53,662 | 1,126,523 |
| All Other Travel | 6,340 | 6,916 | 5,454 | 4,974 | 5,335 | 4,745 | 3,844 | 5,389 | 3,635 | 5,807 | 4,498 | 3,852 | 7,137 | 6,154 | 5,682 | 4,272 | 7,286 | 6,670 | 7,114 | 3,783 | 108,888 |
| P2W | 88,485 | 63,817 | 56,774 | 92,476 | 31,618 | 43,249 | 55,603 | 88,320 | 58,192 | 134,346 | 163,502 | 85,523 | 146,315 | 119,047 | 162,262 | 126,694 | 84,713 | 72,146 | 73,814 | 57,176 | 1,804,070 |
| Total Travel + P2W | 676,458 | 550,933 | 577,412 | 573,233 | 425,968 | 428,765 | 505,988 | 460,083 | 369,905 | 527,068 | 543,573 | 514,587 | 666,702 | 650,841 | 723,921 | 638,744 | 690,695 | 601,108 | 709,305 | 538,822 | 11,374,109 |
| Notes: | |||||||||||||||||||||
| Travel spend includes all traveler types. | |||||||||||||||||||||
| Nov numbers will not be final until all travel expenses transacted in Nov have been processed in the Concur Expense system. | |||||||||||||||||||||
| Travel Spend Categories include the following expense types from Concur: | |||||||||||||||||||||
| Air: Airfare, Airline Fees, Baggage Fees | |||||||||||||||||||||
| Hotel: Hotel and Hotel Tax | |||||||||||||||||||||
| Meals: Breakfast, Lunch, Dinner, Travel Meals, Apt Association Meals/Outings | |||||||||||||||||||||
| Car Rental: Car Rental | |||||||||||||||||||||
| Cabs/Tolls/Parking/Fuel: Car Rental, Parking, Tolls/Road Charges, Taxi, Fuel, Public Transport, Personal Car Mileage, Cabs/Tolls/Parking/Other Travel Exp | |||||||||||||||||||||
| All Other Travel: Internet/Online Fees, Service Fee - Travel, Train, Travel Wifi, Tips/Gratuities |
Travel & P2W Expenses (April 2018-November2019)
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 531794 561659 512050 605982 528962 635491 481646 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 43635 43665 43696 43727 43757 43788
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 162262 126694 84713 72146 73814 57176 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 43635 43665 43696 43727 43757 43788
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 650840.58000000007 723920.73999999987 638743.65999999992 690695.30999999994 601108.41 709305.30999999994 538821.61 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 43635 43665 43696 43727 43757 43788
Travel & P2W Expenses (April 2018-November2019)
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 43635 43665 43696 43727 43757 43788 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 531794 561659 512050 605982 528962 635491 481646 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 43635 43665 43696 43727 43757 43788 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 162262 126694 84713 72146 73814 57176 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 43635 43665 43696 43727 43757 43788 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 650840.58000000007 723920.73999999987 638743.65999999992 690695.30999999994 601108.41 709305.30999999994 538821.61
Not Using Concur Travel
| Name | # Transactions | Total Expensed |
| St Clair, Colin | 54 | $ 24,947 |
| Cheung, Brian | 56 | $ 17,934 |
| Madgey, Christopher | 41 | $ 15,326 |
| Rammer, Chantel | 12 | $ 13,394 |
| Thomas, Jace | 66 | $ 13,241 |
| Scott, Bradley | 32 | $ 12,675 |
| Clark Jr, Bobby | 44 | $ 12,097 |
| Fleming, Rhett | 36 | $ 11,279 |
| Kessler, Jason | 37 | $ 10,135 |
| Stockwell, Christian | 27 | $ 9,826 |
| Wooley Jr, Joe | 31 | $ 9,618 |
| White, Ryan | 17 | $ 9,518 |
| Visser, Elizabeth | 20 | $ 9,083 |
| Cloninger, David | 51 | $ 8,985 |
| Larson, Brian | 85 | $ 8,360 |
| Ballard, Richard | 43 | $ 8,240 |
| Gilbert, Matthew | 32 | $ 7,887 |
| Catanzaro, Michael | 41 | $ 7,748 |
| Rembish, Michael | 50 | $ 7,673 |
| Wehner, Chad | 14 | $ 7,345 |
| All Others (445) | 4,048 | $ 766,276 |
| Total | 4,837 | $ 991,590 |
Summary Policy Violations
| SUMMARY POLICY VIOLATIONS | SUMMARY POLICY VIOLATIONS | |||||
| MAY - DEC 2019 | SEP - NOV 2019 | |||||
| Policy Violation Reasons | # of Tickets | Missed Savings | Policy Violation Reasons | # of Tickets | Missed Savings | |
| Flight Time Declined | 58 | $ 18,074 | Flight Time Declined | 22 | $ 6,610 | |
| Routing Declined - Stops/Connections | 42 | $ 13,423 | Routing Declined - Stops/Connections | 16 | $ 4,703 | |
| Declined for Preferred Carrier | 25 | $ 6,734 | Declined for Preferred Carrier | 10 | $ 3,006 | |
| Declined Alternate Carrier (Personal Preference) | 10 | $ 3,040 | Declined Alternate Carrier (Personal Preference) | 3 | $ 807 | |
| Alternate Airport Declined | 2 | $ 577 | Alternate Airport Declined | 1 | $ 333 | |
| Equipment Declined-commuter flights | 1 | $ 287 | Total | 52 | $ 15,459 | |
| Declined Preferred Carrier | 1 | $ 219 | ||||
| Total | 139 | $ 42,354 |
Summary Boookings < 7 Days
| Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance | Top 10 Travelers Who Booked Air Travel Tickets < 1 Week in Advance | ||||||||||||||
| Traveler Name | 19-May | Jun-19 | Jul-19 | Aug-19 | Sep-19 | 19-Oct | 19-Nov | 19-Dec | Total | Traveler Name | Sep-19 | 19-Oct | 19-Nov | Total | |
| REMBISH/MICHAEL JAMES | 2 | 2 | 4 | 2 | 6 | 4 | 1 | 21 | REMBISH/MICHAEL JAMES | 10 | 4 | 1 | 15 | ||
| MAEDER/MICHAEL CHARLES MR | 1 | 2 | 4 | 4 | 4 | 4 | 1 | 20 | GONZALEZ/MARCO ANTONIO MR | 5 | 7 | 2 | 14 | ||
| ST CLAIR/COLIN MR | 1 | 3 | 4 | 5 | 4 | 1 | 18 | ST CLAIR/COLIN MR | 5 | 4 | 2 | 11 | |||
| GONZALEZ/MARCO ANTONIO MR | 1 | 1 | 1 | 2 | 4 | 6 | 1 | 16 | MAEDER/MICHAEL CHARLES MR | 4 | 5 | 9 | |||
| ZETTLEMOYER/ADRIAN F | 5 | 4 | 4 | 13 | ZETTLEMOYER/ADRIAN F | 4 | 5 | 9 | |||||||
| MYERS/RHONDA LEE MRS | 1 | 3 | 1 | 4 | 1 | 1 | 11 | HARPER SR/SEAN ALEXUS MR | 2 | 2 | 2 | 6 | |||
| HARPER SR/SEAN ALEXUS MR | 2 | 2 | 1 | 3 | 2 | 10 | MOORE/KIMBERLY JEAN | 3 | 3 | 6 | |||||
| SACHLEBEN/PATRICK CHRISTIAN MR | 3 | 3 | 2 | 1 | 1 | 10 | THOMAS/JACE M | 2 | 3 | 1 | 6 | ||||
| THOMAS/JACE M | 3 | 3 | 2 | 1 | 9 | MYERS/RHONDA LEE MRS | 4 | 1 | 5 | ||||||
| GILBERT/MATTHEW SCOTT | 1 | 1 | 2 | 2 | 1 | 1 | 8 | CATANZARO/MICHAEL D | 4 | 4 | |||||
| All Others (143) | 40 | 45 | 45 | 58 | 37 | 48 | 43 | 32 | 348 | All Others (65) | 31 | 41 | 40 | 112 | |
| Total | 48 | 56 | 64 | 76 | 63 | 79 | 55 | 43 | 484 | Total | 66 | 74 | 57 | 197 |
Top 10 Traveler Expense
| TOP 10 TRAVELERS BY OVERALL SPENDING | TOP 10 TRAVELERS BY OVERALL SPENDING | ||||||||||||||
| 19-May | Jun-19 | Jul-19 | Aug-19 | Sep-19 | 19-Oct | 19-Nov | 19-Dec | Total | Sep-19 | 19-Oct | 19-Nov | Total | |||
| Cates, Brian L | $ 9,456 | $ 8,526 | $ 8,257 | $ 7,262 | $ 7,368 | $ 6,758 | $ 7,330 | $ 4,801 | $ 59,758 | St Clair, Colin | $ 8,923 | $ 15,422 | $ 12,654 | $ 36,999 | |
| St Clair, Colin | $ - | $ 8,211 | $ 55 | $ 7,653 | $ 8,923 | $ 15,422 | $ 12,654 | $ 2,512 | $ 55,430 | Rembish, Michael James | $ 9,839 | $ 11,848 | $ 4,186 | $ 25,874 | |
| Rembish, Michael James | $ 6,022 | $ 8,237 | $ 5,409 | $ 9,873 | $ 9,839 | $ 11,848 | $ 4,186 | $ - | $ 55,415 | Cates, Brian L | $ 7,368 | $ 6,758 | $ 7,330 | $ 21,456 | |
| Madgey, Christopher Michael | $ 6,382 | $ 6,839 | $ 3,466 | $ 10,302 | $ 3,561 | $ 11,780 | $ 3,645 | $ 1,480 | $ 47,453 | Cheung, Brian D | $ 2,901 | $ 6,292 | $ 10,762 | $ 19,956 | |
| Fleming, Rhett S | $ 5,156 | $ 4,725 | $ 5,293 | $ 5,102 | $ 5,816 | $ 4,567 | $ 4,469 | $ 5,139 | $ 40,267 | Madgey, Christopher Michael | $ 3,561 | $ 11,780 | $ 3,645 | $ 18,986 | |
| Cloninger, David Andrew | $ 7,594 | $ 4,213 | $ 1,026 | $ 4,481 | $ 4,277 | $ 10,295 | $ 3,858 | $ 3,992 | $ 39,735 | Cloninger, David Andrew | $ 4,277 | $ 10,295 | $ 3,858 | $ 18,429 | |
| Scott, Bradley C | $ 6,229 | $ 3,655 | $ 3,979 | $ 4,785 | $ 7,349 | $ 6,797 | $ 3,107 | $ 3,709 | $ 39,609 | Scott, Bradley C | $ 7,349 | $ 6,797 | $ 3,107 | $ 17,253 | |
| Visser, Elizabeth Sokoly | $ 5,931 | $ 5,958 | $ 8,242 | $ 4,899 | $ 820 | $ 2,752 | $ 7,900 | $ 894 | $ 37,395 | Clark Jr, Bobby Joe | $ 5,591 | $ 9,766 | $ 1,431 | $ 16,788 | |
| Stockwell, Christian H | $ 4,015 | $ 3,255 | $ 1,085 | $ 8,039 | $ 5,194 | $ 6,147 | $ 3,108 | $ 5,074 | $ 35,917 | Thomas, Jace M | $ 6,923 | $ 5,723 | $ 3,658 | $ 16,304 | |
| Kessler, Jason Daniel | $ 5,440 | $ 6,077 | $ 3,943 | $ 3,589 | $ 5,623 | $ 6,375 | $ 1,896 | $ 694 | $ 33,635 | Horan, Peter William | $ 7,173 | $ 4,304 | $ 3,514 | $ 14,992 | |
| All Other Travelers (885) | $ 475,570 | $ 501,964 | $ 471,296 | $ 539,998 | $ 470,192 | $ 552,752 | $ 429,493 | $ 253,197 | $ 3,694,461 | All Other Travelers (705) | $ 465,056 | $ 546,508 | $ 427,500 | $ 1,439,063 | |
| Total | $ 531,794 | $ 561,659 | $ 512,050 | $ 605,982 | $ 528,962 | $ 635,491 | $ 481,646 | $ 281,491 | $ 4,139,075 | Total | $ 528,962 | $ 635,491 | $ 481,646 | $ 1,646,099 | |
| Dec 2019 transactions have not been submitted in their entirety | |||||||||||||||
