The URL can be used to link to this page

12-SEPTEMBER 2015 FINANCIAL STATEMENTCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 16,700,082 745,414.46 15,057,989.32 16,378,840.86 - 321,241.14 98.08% Franchises 1,986,159 275,319.40 1,978,422.00 2,160,594.53 - (174,435.53) 108.78% Permits 1,175,803 103,217.25 1,283,672.74 1,369,000.30 - (193,197.30) 116.43% Licenses 91,229 5,282.00 81,951.50 78,814.00 - 12,415.00 86.39% Fees 2,814,366 215,628.84 2,830,672.99 2,623,851.80 - 190,514.20 93.23% Fines 31,000 2,603.13 31,648.25 30,616.10 - 383.90 98.76% Inter - Jurisdictional 720,892 96,673.75 673,620.40 742,604.14 - (21,712.14) 103.01% Fund Transfers 1,835,754 252,758.55 1,751,605.75 1,804,221.43 - 31,532.57 98.28% Miscellaneous 462,650 112,046.39 623,310.64 506,817.30 - (44,167.30) 109.55% TOTAL REVENUES 25,817,935 1,808,943.77 24,312,893.59 25,695,360.46 - 122,574.54 99.53 %' EXPENDITURE SUMMARY GENERALGOVERNMENT CITY COUNCIL Personnel Services 23,575 2,464.44 24,404.86 23,649.53 - (74.53) 100.32% Supplies 1,800 35.12 496.96 643.37 - 1,156.63 35.74% City Support Services 40,600 8,500.22 40,300.82 37,922.51 - 2,677.49 93.41% Operations Support 400 6.75 286.13 226.68 - 173.32 56.67% Staff Support 21,300 227.18 15,559.46 12,269.73 - 9,030.27 57.60% TOTAL CITY COUNCIL 87,675 11,23171 81,048.23 74,711 82 - 12,963.18 85.21 %i' CITY MANAGER Personnel Services 833,454 86,953.05 911,875.15 845,916.51 - (12,462.51) 101.50% Supplies 3,000 304.98 2,919.92 2,916.11 - 83.89 97.20% City Support Services 2,540 - 1,804.00 2,535.46 - 4.54 99.82% Staff Support 28,480 3,514.99 21,436.44 27,417.08 - 1,062.92 96.27% Professional Services - - 1,200.00 - - - 0.00% Operating Equipment 725 - - 724.91 - 0.09 99.99% TOTAL CITY MANAGER 868,199 90,773.02'' 939,235.51 879,510.07 - (11,311.07) 101.30% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 301,231 27,614.00 285,722.31 269,664.31 - 31,566.69 89.52% Supplies 3,500 234.20 1,603.60 1,122.17 19.96 2,357.87 32.63% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 601.46 2,035.00 2,529.46 - 1,970.54 56.21% Staff Support 7,710 1,508.98 5,955.11 3,782.99 260.00 3,667.01 52.44% Court Support 560 - - 210.00 - 350.00 37.50% Professional Services 68,340 3,888.75 53,275.15 45,281.50 - 23,058.50 66.26% Maintenance Services 2,800 2,250.00 1,900.00 - 900.00 67.86% Operating Equipment 800 - 37.27 280.70 - 519.30 35.09% TOTAL MUNICIPAL COURT 390,441s 33,847.39 350,878.44 324,771.13 279.96 65,389.91 8125 %' CUSTOMER RELATIONS -311 Personnel Services 113,241 11,433.43 112,410.99 106,611.67 - 6,629.33 94.15% Supplies 200 34.99 143.88 199.69 - 0.31 99.85% Staff Support 750 - 216.49 484.51 - 265.49 64.60% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 114,691' 11,468.42! 112,771.36 107,295:87 - 7,395.13 9155% PLANNING & ZONING Personnel Services 133,705 14,518.34 129,239.89 133,552.04 - 152.96 99.89% Supplies 4,875 706.34 1,840.48 3,720.71 - 1,154.29 76.32% Operations Support 99 - - 98.56 - 0.44 99.56% Staff Support 18,580 3,493.76 8,996.30 14,880.79 200.00 3,499.21 81.17% Professional Services 82 5.00 30.00 77.00 - 5.00 93.90% Operating Equipment 486 - - 486.00 - - 100.00% TOTAL PLANNING & ZONING 157,827r 1$,72144 140,106.67 152,815.10 200.00 4,811.90 96.95% LEGAL SERVICES Operations Support 10,000 2,380.44 8,809.59 7,482.06 84.76 2,433.18 75.67% Professional Services 350,000 31,654.35 296,714.01 183,078.32 - 166,921.68 52.31% TOTAL LEGAL SERVICES 360,000! 34,034.79 305,523.60 190,56038 84.76' 169,354.86 52.96 %4 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES 167,772 17,269.84 164,513.03 167,539.61 - 232.39 99.86% Supplies Personnel Services 590,190 67,536.36 552,629.97 599,141.74 - (8,951.74) 101.52% Supplies 60,004 6,138.82 45,505.61 52,774.35 191.27 7,038.38 88.27% Utility Services 99,880 23,982.03 97,137.58 102,048.54 - (2,168.54) 102.17% Staff Support 11,749 1,908.75 9,583.99 8,989.89 210.65 2,548.46 78.31% Maintenance Services 31,900 2,536.95 22,291.85 29,451.59 223.89 2,224.52 93.03% Rental /Leasing 421 - - 420.75 - 0.25 99.94% Operating Equipment 10,800 6,717.63 20,339.44 10,078.12 - 721.88 93.32% Capital Outlay - - 5,289.35 - - - 0.00% TOTAL GENERAL SERVICES 804,944 108,820.54 752,777.79 802,904.98 625.81' 1,413.21 99.82 %ss BUILDING 6 -8 MAINTENANCE 107,391.42 29,450.00 85,558.58 61.53% Fund Chrgs/Transfrs -Spec Events Fnd 572,800 549,180.52 549,104.03 Supplies 25,250 3,022.38 22,752.25 26,572.52 - (1,322.52) 105.24% Utility Services 89,235 19,469.95 81,416.53 81,174.86 - 8,060.14 90.97% Maintenance Services 63,700 17,308.25 44,133.52 66,820.18 528.42 (3,648.60) 105.73% Operating Equipment 23,000 - 21,075.29 22,027.00 - 973.00 95.77% TOTAL BUILDING 6 -8 MAINTENANCE 201,185 39,800.58' 1`69,377.59 196,594.56 528.42 4,062.02 97.98 %` CITY SECRETARY Personnel Services 167,772 17,269.84 164,513.03 167,539.61 - 232.39 99.86% Supplies 1,200 455.70 559.27 1,212.75 - (12.75) 101.06% City Support Services 9,700 115.00 9,576.38 2,753.27 - 6,946.73 28.38% Operations Support 150 - 50.00 - - 150.00 0.00% Staff Support 8,795 195.00 4,958.77 4,054.35 - 4,740.65 46.10% TOTAL CITY SECRETARY 187,617 1$,035.54' 179,657.45 175,559.98 - 12,057.02 93.57% NON - DEPARTMENTAL City Support Services 511,427 34,050.20 313,049.24 339,565.18 2,200.00 169,661.82 66.83% Operations Support 141,500 29,315.21 151,908.32 143,333.93 - (1,833.93) 101.30% Staff Support 150 - 440.86 80.00 - 70.00 53.33% City Assistance 1,243,779 144,187.18 899,821.37 1,181,626.70 - 62,152.30 95.00% Professional Services 222,400 3,299.18 44,073.77 107,391.42 29,450.00 85,558.58 61.53% Fund Chrgs/Transfrs -Spec Events Fnd 572,800 549,180.52 549,104.03 549,180.52 - 23,619.48 95.88% Operating Equipment 54,465 - 1,955.00 27,471.81 - 26,993.19 50.44% TOTAL NON- DEPARTMENTAL 2,746,521 760,032.29 1,960,352.59 2,348,649.56 31,650.00 366,221.44 86.67% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 257,970 27,564.27 194,372.63 246,577.37 - 11,392.63 95.58% Supplies 3,500 279.84 3,014.43 3,166.96 - 333.04 90.48% Operations Support 25,341 92.40 14,930.53 13,539.96 453.00 11,348.04 55.22% Staff Support 5,209 116.00 3,087.43 3,668.68 - 1,540.32 70.43% Professional Services 13,500 - 4,290.00 589.00 - 12,911.00 4.36% Operating Equipment 2,700 590.40 1,021.64 2,512.22 - 187.78 93.05% TOTAL PUBLIC AFFAIRS'- 308,220 28,642.91 220,716.66 270,054.19 45100! 37,712.81 87.76 %` RECORDS MANAGEMENT Personnel Services 52,174 5,075.44 49,284.20 50,550.50 - 1,623.50 96.89% Supplies 400 2.60 202.89 262.66 - 137.34 65.67% Staff Support 1,750 - 1,064.14 1,187.87 - 562.13 67.88% Professional Services 10,000 1,088.50 6,813.50 9,468.50 - 531.50 94.69% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,324' 6,166.54< 57,364.73 61,469.53 83.77: 2,770.70 95.69 %'J SCHERTZ MAGAZINE Personnel Services 137,208 9,499.89 134,717.06 133,345.82 - 3,862.18 97.19% Supplies 200 - 73.94 123.99 - 76.01 62.00% Opperations Support 100 - - - - 100.00 0.00% Staff Support 3,000 730.11 1,033.06 2,271.61 - 728.39 75.72% Professional Services 253,500 34,470.05 227,379.80 230,459.61 125.00 22,915.39 90.96% Fund Charges/Transfers 10,000 13,728.00 - 13,728.00 - (3,728.00) 137.28% Operating Equipment 600 - 455.00 - - 600.00 0.00% TOTAL SCHERTZ MAGAZINE 404,608 58,428.05` 363,658.86 379,929.03 125.00' 24,553.97 93.93 %s ENGINEERING Personnel Services 187,058 19,803.46 152,146.90 186,441.78 - 616.22 99.67% Supplies 1,300 136.21 853.87 703.23 116.93 479.84 63.09% City Support Services 1,500 - 262.80 262.80 - 1,237.20 17.52% Utility Services 1,498 87.43 660.32 379.95 - 1,118.05 25.36% Staff Support 10,512 601.21 2,405.19 1,754.93 - 8,757.07 16.69% Professional Services 38,800 3,160.00 13,259.60 30,829.16 - 7,970.84 79.46% Operating Equipment 600 - 5,856.32 161.49 - 438.51 26.92% TOTAL ENGINEERING 241,268 23,788.31! 1;75,445.00 220,533.34 116.93' 20,617.73 91.45 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 135,495 14,381.52 132,934.47 138,225.12 - (2,730.12) 102.01% Supplies 2,910 1,098.72 1,000.61 1,098.72 - 1,811.28 37.76% Staff Support 5,235 - 3,817.28 4,411.50 - 823.50 84.27% Rental /Leasing 3,805 - - - - 3,805.00 0.00% Operating Equipment 7,350 2,796.60 - 5,877.41 - 1,472.59 0.00% TOTAL GIS 154,795 18,276.84: 137,752.36 149,612.75 - 5,182.25 96.65 %` TOTAL GENERAL GOVERNMENT 7,092,315` 1,262,072.37 5,946,666.84 6,334,972.29 34,147.65' 723,195.06 89.80 %` PUBLIC SAFETY POLICE Personnel Services 5,149,607 667,705.43 4,803,655.51 5,112,499.63 - 37,107.37 99.28% Supplies 47,646 17,642.01 31,630.01 48,516.46 138.00 (1,008.46) 102.12% City Support Services 26,750 - 26,721.66 24,151.52 - 2,598.48 90.29% Utility Services 127,140 15,419.17 131,346.20 86,667.37 - 40,472.63 68.17% Operations Support 2,950 475.00 2,199.46 2,600.67 - 349.33 88.16% Staff Support 109,923 37,207.16 91,764.02 121,148.04 90.30 (11,315.34) 110.29% City Assistance 8,723 1,512.79 6,989.65 6,779.49 - 1,943.51 77.72% Professional Services 48,058 5,134.61 34,285.65 39,540.32 - 8,517.68 82.28% Fund Charges/Transfers - - 3,249.76 - - - 0.00% Maintenance Services 57,632 4,925.38 55,109.32 41,196.69 801.00 15,634.31 72.87% Operating Equipment 123,281 41,570.31 120,415.92 117,968.45 - 5,312.55 95.69% Capital Outlay 228,155 43,164.77 128,505.24 260,032.72 - (31,877.72) 113.97% TOTAL POLICE 5,929,865` 834,756.63> 5,435,872.40 5,861,101.36 1,029.30 67,734:34 98.86% FIRE RESCUE Personnel Services 2,987,869 396,379.41 2,726,198.79 2,968,575.62 - 19,293.38 99.35% Supplies 17,050 8,183.79 15,352.64 13,928.98 221.00 2,900.02 82.99% Utility Services 58,700 9,192.62 54,898.86 49,445.14 - 9,254.86 84.23% Operations Support 650 - 953.37 364.41 - 285.59 56.06% Staff Support 109,100 43,278.33 107,328.78 102,106.10 452.68 6,541.22 94.00% City Assistance 16,200 14,431.71 15,046.93 15,570.09 - 629.91 96.11% Professional Services 25,000 45.00 14,102.00 10,058.00 - 14,942.00 40.23% Fund Charges /Transfers - 109,600.00 109,600.00 (109,600.00) 0.00% Maintenance Services 62,932 14,597.02 36,368.61 42,925.21 20,006.79 68.21% Rental /Leasing 14,000 1,316.94 - 5,617.76 - 8,382.24 40.13% Operating Equipment 65,900 5,915.13 53,934.43 61,502.80 295.20 4,102.00 93.78% Capital Outlay 210,600 - 12,146.15 104,880.19 1,653.75 104,066.06 50.59% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET TOTAL FIRE RESCUE 3,568,001 602,939.95 3,036,330.56 3,484,574.30 2,622.63 80,804.07 97.74% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 512,538 69,146.60 441,897.74 485,534.93 - 27,003.07 94.73% Supplies 3,516 496.74 1,864.70 2,570.88 - 945.12 73.12% Utility Services 6,500 923.21 6,664.98 4,286.76 - 2,213.24 65.95% Operations Support 2,000 45.96 898.00 1,850.07 - 149.93 92.50% Staff Support 13,324 3,407.65 6,620.11 10,985.77 865.00 1,473.23 88.94% Professional Services 29,300 13,036.00 45.59 33,946.00 - (4,646.00) 115.86% Operating Equipment 28,668 - 2,352.98 667.95 - 28,000.05 2.33% Capital Outlay - - - 20,435.82 - (20,435.82) 0.00% TOTAL INSPECTIONS 595,846 87,056.16 460,344.10 560,278.18 865.00 34,702.82 94.18% MARSHAL'S OFFICE Personnel Services 583,782 70,627.35 572,402.55 580,526.50 - 3,255.50 99.44% Supplies 6,400 408.60 1,668.76 3,111.05 455.55 2,833.40 55.73% Utility Services 16,000 1,795.83 11,069.96 8,419.00 - 7,581.00 52.62% Operations Support 3,500 22.98 995.00 1,086.83 177.00 2,236.17 36.11% Staff Support 14,800 3,103.11 6,272.36 9,531.94 - 5,268.06 64.41% City Assistance 2,500 - - 979.60 - 1,520.40 39.18% Maintenance Services 17,700 2,330.00 7,091.14 8,198.20 - 9,501.80 46.32% Operating Equipment 19,700 2,127.16 10,699.08 14,971.65 - 4,728.35 76.00% Capital Outlay 8,000 - 28,566.00 - - 8,000.00 0.00% TOTAL MARSHAL'S OFFICE 672,382 80,415.03! 638,764.85 626,824.77 632.55` 44,924.68 93.32% TOTAL PUBLIC SAFETY 10,766,094' 1,605,167.77' 9,571,311.91 10,532,778.61 5,149.48 228,165.91 97.88% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 4,730.85 15,741.32 19,197.28 59.96 1,442.76 93.03% Utility Services STREETS 6,311.65 19,676.19 20,026.54 - 8,973.46 69.06% Maintenance Services 203,378 Personnel Services 696,734 72,260.13 672,855.00 693,862.04 - 2,871.96 99.59% Supplies 5,700 179.47 5,960.81 5,616.53 - 83.47 98.54% Utility Services 136,200 27,546.30 145,190.68 123,100.96 - 13,099.04 90.38% Staff Support 11,805 527.80 7,876.89 11,026.43 - 778.57 93.40% City Assistance 500 - - - - 500.00 0.00% Professional Services 33,225 4,775.00 2,350.00 29,975.00 - 3,250.00 90.22% Maintenance Services 102,500 25,687.25 127,567.15 88,669.50 - 13,830.50 86.51% Rental /Lease 200 - 414.72 175.00 - 25.00 87.50% Operating Equipment 300 - 50,391.84 237.56 - 62.44 79.19% Capital Outlay 28,000 - 63,529.00 25,985.49 - 2,014.51 92.81% TOTAL STREETS 1,015,164 130,975.95 1,076,136.09 978,648.51 - 36,515.49 96.40% TOTAL PUBLIC ENVIRONMENT 1,015,164 130,975.95 1,076,136.09 978,648.51 - 36,515.49 96.40 %' PARKS & RECREATION PARKS DEPARTMENT Personnel Services 470,301 72,785.92 456,490.88 455,588.13 - 14,712.87 96.87% Supplies 41,905 13,550.89 30,558.92 45,126.94 492.85 (3,714.79) 108.86% Utility Services 143,800 57,210.91 160,037.19 192,195.14 231.64 (48,626.78) 133.82% Operations Support 250 - - 876.00 - (626.00) 350.40% Staff Support 8,473 623.17 6,158.62 8,286.18 129.45 57.37 99.32% Professional Services 72,000 10,068.50 26,183.21 34,730.80 3,691.50 33,577.70 53.36% Maintenance Services 20,000 (2,322.72) 24,835.56 16,434.74 500.00 3,065.26 84.67% Rental /Leasing 39,600 3,019.16 34,954.89 37,045.81 - 2,554.19 93.55% Operating Equipment 2,000 - 1,043.45 2,074.01 344.25 (418.26) 120.91% Capital Outlay 60,000 - 133,715.00 59,795.05 - 204.95 99.66% TOTAL PARKS DEPARTMENT 858,329 154,935.83? 873,977.72 852,152.80 5,389.69 786.51 99.91% SWIM POOL Supplies 20,700 4,730.85 15,741.32 19,197.28 59.96 1,442.76 93.03% Utility Services 29,000 6,311.65 19,676.19 20,026.54 - 8,973.46 69.06% Maintenance Services 203,378 60,590.61 181,549.40 189,030.45 - 14,347.55 92.95% TOTAL SWIM POOL =253,078 71,633.11f 216,966.91 228,254.27 59.96! 24,763.77 90.21 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 58,642 5,569.16 54,529.87 50,617.65 - 8,024.35 86.32% Supplies 15,400 1,358.54 12,593.36 12,495.50 716.50 2,188.00 85.79% Utility Services 51,400 11,181.68 46,765.03 50,870.26 - 529.74 98.97% Operations Support 22,411 281.99 9,994.39 15,330.99 250.00 6,830.01 69.52% Staff Support 2,448 205.00 2,073.47 1,667.16 - 780.84 68.10% Professional Services 500 - 736.85 - - 500.00 0.00% Operating Equipment 5,000 1,999.40 - 6,931.91 - (1,931.91) 138.64% TOTAL EVENT FACILITIES 155,801; 20,595.77 126,692.97 137,913.47 966.50 16,921.03 89.14% SENIOR CITIZEN CENTER Supplies 7,650 1,173.39 6,680.18 6,794.55 (73.99) 929.44 87.85% Utility Services 4,240 - 414.00 216.78 - 4,023.22 5.11% Operations Support 1,500 - - 591.92 - 908.08 39.46% City Assistence 20,000 32,154.03 21,858.48 40,804.21 - (20,804.21) 204.02% Professional Services 8,000 436.00 11,053.28 12,622.09 80.50 (4,702.59) 158.78% Maintenance Services 5,000 60.47 10,385.70 396.51 - 4,603.49 7.93% TOTAL SENIOR CITIZEN CENTER 46,390 33,82189 50,391.64 61,426.06 6.51s (115,042.57) 132.43 %' TOTAL PARKS '& RECREATION 1,313,598 280,988.60 1,268,029.24 1,279,746.60 6,422.661 27,428.74 9791 %' CULTURAL LIBRARY Personnel Services 672,828 69,959.30 649,269.33 635,045.81 - 37,782.19 94.38% Supplies 13,500 1,569.69 10,930.43 12,601.81 35.55 862.64 93.61% Utility Services 56,500 14,675.79 51,746.30 53,226.86 - 3,273.14 94.21% Operations Support 3,000 1,078.62 1,741.81 1,726.72 - 1,273.28 57.56% Staff Support 6,345 77.00 3,243.98 2,425.34 - 3,919.66 38.22% Professional Services 2,300 - 2,190.00 2,175.00 - 125.00 94.57% Operating Equipment 88,000 8,702.30 75,311.79 88,234.41 232.16 (466.57) 100.53% TOTAL LIBRARY 842,473 96,062.70 794,43164 795,435.95 267.71s 46,769.34 94.45 %` TOTAL CULTURAL 842,473 96,062.70 794,433.64 795,435.95 267.71 46,769.34 94.45% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 306,397 31,652.03 273,937.22 287,202.09 - 19,194.91 93.74% Supplies 34,783 9,167.05 28,682.81 28,071.78 - 6,711.22 80.71% Utility Services 46,840 8,074.62 23,442.93 34,811.32 - 12,028.68 74.32% Operations Support 1,000 - 798.00 609.24 - 390.76 60.92% Staff Support 11,390 1,512.39 5,367.45 4,866.16 - 6,523.84 42.72% City Assistance 17,550 4,138.99 11,978.84 14,689.15 - 2,860.85 83.70% Professional Services 26,500 4,368.20 31,864.13 21,663.20 - 4,836.80 81.75% Fund Charges/Transfers - 22,588.00 - 22,588.00 - (22,588.00) 0.00% Maintenance Services 23,200 2,490.15 9,607.68 10,453.89 - 12,746.11 45.06% Operating Equipment 11,500 149.04 9,238.65 1,640.95 - 9,859.05 14.27% Capital Outlay 24,100 - - - 22,588.15 1,511.85 93.73% TOTAL ANIMAL SERVICES 503,260 84,140.47 394,917.71 426,595.78 22,588.15 54,076.07 89.25 %` TOTAL HEALTH 503,260 84,140.47> 394,917.71 426,595.78 22,588.15 54,076.07 89.25 %? INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 443,792 46,746.07 424,217.98 422,231.03 - 21,560.97 95.14% Supplies 3,500 1,705.88 1,963.93 2,772.16 82.28 645.56 81.56% City Support Services 581,743 159,272.51 527,586.81 526,871.82 3,364.10 51,507.08 91.15% Utility Services 253,722 26,887.22 170,738.10 187,580.97 - 66,141.03 73.93% Operations Support - - - 50.00 - (50.00) 0.00% Staff Support 37,400 1,708.12 21,994.37 27,735.78 1,175.00 8,489.22 77.30% Fund Charges/Transfers - - 30,274.00 - - - 0.00% Maintenance Services 15,600 1,618.46 10,326.10 11,643.05 558.00 3,398.95 78.21% Operating Equipment 291,571 83,367.64 334,113.48 250,370.42 3,325.00 37,875.58 87.01% TOTAL INFORMATION TECHNOLOGY 1,627,328 321,305.90! 1,521,214.77 1,429,255.23 8,504.38 189,568:39 88.35 %< CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 310,863 20,577.67 305,552.60 247,575.00 - 63,288.00 79.64% Supplies 1,000 302.70 1,208.49 788.11 - 211.89 78.81% Human Services 67,000 31,300.32 60,994.56 118,921.81 - (51,921.81) 177.50% Operations Support 10,500 3,393.58 7,983.04 8,013.75 - 2,486.25 76.32% Staff Support 15,120 476.76 11,249.20 14,219.51 - 900.49 94.04% City Assistance 10,000 1,943.50 8,395.85 9,687.75 - 312.25 96.88% Professional Services 9,200 744.75 3,484.25 8,936.50 744.75 (481.25) 105.23% Operating Equipment - - 1,166.67 - - - 0.00% TOTAL HUMAN RESOURCES 423,683 58,739.28 400,034.66 408,142.43 744.75 14,795.82 96.51 %' FINANCE Personnel Services 516,715 48,891.62 454,827.89 490,036.62 - 26,678.38 94.84% Supplies 6,750 910.28 2,450.67 6,632.98 - 117.02 98.27% Operations Support 1,940 - 834.00 1,937.76 - 2.24 99.88% Staff Support 9,815 1,004.00 8,017.10 7,442.40 111.36 2,261.24 76.96% Maintenance Services - - 7.95 - - - 0.00% Operating Equipment 900 - - 895.86 - 4.14 99.54% TOTAL FINANCE` 536,120 50,805.90 466,137.61 506,945.62 111.36' 29,063.02 94.58% PURCHASING & ASSET MGT Personnel Services 261,548 24,666.65 234,656.27 215,141.60 - 46,406.40 8226% Supplies 1,200 (1,627.24) 7,147.47 (1,081.49) 35.29 2,246.20 - 87.18% City Support Services 800 - - 788.40 - 11.60 98.55% Utility Services 905 253.52 353.89 789.32 - 115.68 8722% Operations Support 300 - - 95.97 - 204.03 31.99% Staff Support 6,165 1,222.23 3,770.58 5,500.27 50.00 614.73 90.03% Operating Equipment 2,550 647.18 3,722.67 2,267.17 - 282.83 88.91% TOTAL PURCHASING & ASSET MGT 273,468 25,16234 249,650.88 223,501.24 85.29' 49,881.47 81.76 %'i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 313,447 28,970.91 209,500.70 262,044.47 - 51,402.53 83.60% Supplies 174,525 10,778.78 196,323.48 165,611.88 1,163.39 7,749.73 95.56% City Support Services 3,500 - 2,100.00 2,386.24 - 1,113.76 68.18% Utility Services 5,000 571.51 4,692.69 4,478.95 - 521.05 89.58% Operations Support 400 - 19.66 75.03 - 324.97 18.76% Staff Support 4,500 158.10 2,803.72 5,094.22 - (594.22) 113.20% City Assistance 180 - - - - 180.00 0.00% Maintenance Services 73,750 (237.67) 101,466.48 73,518.19 - 231.81 99.69% Rental /Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 295.91 8,345.95 7,332.91 878.52 (11.43) 100.14% Capital Outlay 65,000 (4,347.16) 6,650.00 58,021.76 1,371.47 5,606.77 91.37% TOTAL FLEET SERVICE 648,702 36,190.38 531,902.68 578,563.65 3,413.38 66,724.97 89.71% BUILDING MAINTENANCE Personnel Services 140,150 17,336.55 98,492.79 121,166.95 - 18,983.05 86.46% Supplies 1,043 - 1,077.37 684.23 - 358.77 65.60% Utility Services 2,350 463.57 3,414.08 2,479.92 - (129.92) 105.53% Staff Support 2,900 103.20 1,898.49 1,805.59 - 1,094.41 62.26% Professional Services 6,240 - 9,745.00 6,777.60 - (537.60) 108.62% Maintenance Services 93,132 3,558.78 106,074.12 99,722.55 - (6,590.55) 107.08% Rental /Leasing 1,400 - - 467.00 - 933.00 33.36% Operating Equipment 5,500 3,721.91 3,712.50 5,160.34 - 339.66 9182% Capital Outlay 43,510 27,760.02 - 28,694.45 8,415.00 6,400.55 8529% TOTAL BUILDING MAINTENANCE 296,225! 52,944.037 224,414:35 266,958.63 8,415.00! 20,851:37 92.96% TOTAL INTERNAL SERVICE 3,805,526' 545,147.83 3,393,354.95 3,413,366.80 21,274.16 370,885.04 9025% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Transportation Assistance 31,678 - 22,020.00 31,678.00 - - 100.00% Children's Advocacy Assistance 5,000 5,000.00 5,000.00 5,000.00 - - 100.00% Senior Citizen's Hot Meals 45,000 - 55,628.00 - - 45,000.00 0.00% TOTAL CITY ASSISTANCE 86,678 5,000.00- 87,648.00 ;41,678.00 - 45,000.00 48.08% COURT - RESTRICTED FUNDS Fund Charges /Transfers - - 84,000.00 - - - 0.00% Operating Equipment 85,872 - 10,487.00 - 1,840.00 84,032.00 2.14% TOTAL CITY ASSISTANCE 85,872 - 94,487.00 - 1,840.00! 84,032.00 2.14 %' TOTAL MISC &`PROJECTS 172,550 5,000' 182,135 41,678 1,840 129,032.00 25.22% TOTAL` EXPENDITURES 25,510,980 4,009,555.69 22,626,98538 23;803,222:54 91,689.81 1,616,067.65 9167 %> REVENUE OVER(UNDER) EXPEND. 306,955 1,892,137.92 GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 49,881.01 Cash in Investments LOGIC Investment - General Fund 6,844,897.97 LOGIC Investment -Equip Replacement 73,727.43 LOGIC Investment -Veh Replacement 306,989.57 LOGIC Investment -Air Condi Replacment 196,280.50 CAPITAL ONE Investment - General Fund 1,357,601.54 Total Cash in Bank & Investments $ 8,975,959.86 SEP OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG 2014 -15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 3,787 2013 -14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 7,446 2012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 292444 49,157 11,566 20,778 8,379--------7,180----- 2011 -12 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 2010 -11 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 Sales Tax - General Fund $250,000 00,000 $L $1 $1 50,000 00,000 50,000 g OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 215,257 172,814 172,628 227,438 02013 -14 -------------------------- 133,486 ---- - --- -- - - - - -- ------ _ 115,592 176,520 ___ -------------------------------------- 213,412 -------------------------------------- - - -- -- -- - - - - -- -- - - - - -- 2012 -13 101,440 94,054 96,303 123,044 02011 -12 96,392 76,414 77,398 103,230 02010-11 83,433 62,692 67,561 1 95,887 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30st, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 106,125.00 32,682.39 89,416.14 32,68239 - 73,442.61 30.80% Wilenchik Walk for Life 25,000.00 - 23,464.72 13,925.54 - 11,074.46 55.70% Hal Baldwin Scholarship 18,750.00 - 23,762.00 19,102.00 - (352.00) 0.00% Miscellaneous 3,925.00 2.68 7,036.92 1,626.67 - 2,298.33 41.44% TOTAL REVENUES 153,800.00 32,685.07 143,679.78 67,336.60 - 86,463.40 29.84 %` EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,850.00 9,284.91 2,420.53 9,284.91 - 1,565.09 85.58% TOTAL GENERAL GOVERNMENT 10,850.00 9,284.91 2,420.53 9,284.91 - 1,565.09 0.00 %` CULTURAL Festival of Angels 15,000.00 - 10,283.94 12,331.93 - 2,668.07 82.21% Employee Appreciation Event 15,000.00 - 11,510.21 11,155.79 - 3,844.21 74.37% National Night Out 200.00 - - - - 200.00 0.00% Wilenchik Walk for Life 25,000.00 - 23,464.72 13,925.54 - 11,074.46 55.70% Schertz Sweetheart 35,000.00 3,750.00 34,002.64 18,597.34 - 16,402.66 53.14% Jazzfest 20,000.00 (20,000.00) 14,504.83 20.00 - 19,980.00 0.10% Hal Baldwin Scholarship 18,750.00 39.20 8,730.20 12,364.88 - 6,385.12 65.95% Other Events 14,000.00 1,087.95 53,179.41 7,408.27 1,470.00 5,121.73 63.42% TOTAL CULTURAL 142,950.00 (15,122.85) 155,675.95! 75,803.75 1,470.00 65,676.25 5406% TOTAL' EXPENDITURES 153,800.00 (5,837.94) 158,096.48 85,088.66 1,470.00 67,241.34 56.28% REVENUE OVER(UNDER) EXPEND - (17,752 06)' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 52,298.70 Cash in Investments Texas Class- Special Events 16,805.55 Total Cash in Bank & Investments $ 69,104.25 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 119,572.00 5,717.65 94,739.87 103,148.54 - 16,423.46 86.26% Fund Transfers 109,428.00 - - - - 109,428.00 0.00% Miscellaneous - - - 2.00 - (2.00) 0.00% TOTALREVENUES 229,000.00 5,717.65 94,739.87 103,150.54 - 125,849.46 45.04% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 229,000.00 6,047.24 61,404.91 80,668.99 2,762.70 145,568.31 36.43% TOTAL GENERAL GOVERNMENT 229,000.00 6,047.24 61`,404.91 80,668.99 2,762.70 145,568.31 36.43% MISC & PROJECTS Projects - - - 2,456.36 - (2,456.36) 0.00% TOTAL MISC & PROJECTS - - - 2,456.36 - (2,456.36) 0.00 %` TOTAL EXPENDITURES 229,000.00 6,047.24 61,404.91 83,125.35 2,762.70 143,111.95 37.51 %' REVENUE OVER(UNDER) EXPEND - 20,025.19 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Cash Balance $ 471,575.74 Total Cash in Bank & Investments $ 471,575.74? CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 211,813 (38,913.55) 202,983.98 140,635.80 - 71,177.20 66.40% Permits 60,000.00 59,853.81 65,545.21 125,917.65 - (65,917.65) 209.86% Fees 17,169,500 1,791,222.23 16,797,706.25 17,488,824.88 - (319,324.88) 101.86% Fund Transfers 276,425 196,275.03 124,316.04 321,961.91 - (45,536.91) 116.47% Miscellaneous 142,940 4,156,571.72 3,130,234.25 4,285,878.40 - (4,142,938.40) 2998.38% TOTAL REVENUES 17, 860, 678 6,165,009.24 20,320;785.73 22,363,218.64 - (4;502,540.64) 125.21% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 450,477 49,456.99 421,716.65 447,199.73 - 3,277.27 99.27% Supplies 4,600 410.61 4,264.92 3,593.49 25.00 981.51 78.66% Human Services 183 - 116.95 - - 183.00 0.00% City Support Services 24,098 - - 831.00 - 23,267.00 3.45% Utility Services 520 114.83 - 269.09 - 250.91 51.75% Operations Support 123,000 11,350.97 118,360.53 122,109.26 - 890.74 99.28% Staff Support 7,300 136.80 2,809.53 2,510.39 43.30 4,746.31 34.98% Professional Services 77,252 5,331.07 27,639.26 76,128.60 - 1,123.40 98.55% Maintenance Services 13,440 - 6,540.00 10,515.00 - 2,925.00 78.24% Operating Equipment 1,550 - - - - 1,550.00 0.00% TOTAL BUSINESS OFFICE 702,420 66,801.27 581 447.84 663,156.56 68.30 39,195.14 94.42 %' W & S ADMINISTRATION Personnel Services 1,255,365 145,253.25 1,182,446.69 1,174,630.20 - 80,734.80 9157% Supplies 193,150 2,338.73 170,365.79 146,304.27 298.59 46,547.14 75.90% Human Services 1,000 - 389.95 476.00 - 524.00 47.60% City Support Services 103,403 14,149.17 62,051.99 50,548.95 - 52,854.05 48.89% Utility Services 3,454,440 398,568.16 3,280,131.31 3,310,621.53 - 143,818.47 95.84% Operations Support 9,250 7,190.39 2,581.58 14,746.85 - (5,496.85) 159.43% Staff Support 31,150 1,689.71 25,726.06 21,539.34 - 9,610.66 69.15% City Assistance 1,900 - 708.25 1,206.00 - 694.00 6147% Professional Services 259,113 46,588.93 292,091.04 207,795.46 - 51,317.54 80.19% Fund Charges /Transfers 3,492,504 2,143,097.83 4,681,836.51 4,902,724.95 - (1,410,220.95) 140.38% Maintenance Services 6,543,586 1,021,415.79 6,405,028.79 6,765,804.93 7,609.00 (229,827.93) 103.51% Other Costs 35,000 - 27,660.20 31,030.20 - 3,969.80 88.66% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2015 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER FINANCIAL SUMMARY CURRENT BUDGET CURRENT PERIOD PRIOR YEAR Y -T -D ACTUAL Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 100% OF BUDGET Debt Service 1,534,512 (3,700.91) 424,055.40 416,973.89 - 1,117,538.11 27.17% Rental- Leasing 6,070 77.00 2,894.95 3,168.21 - 2,901.79 52.19% Operating Equipment 21,200 7,823.43 16,957.22 24,153.35 399.98 (3,353.33) 115.82% Capital Outlay 124,500 (71,451.64) - - 32,904.13 91,595.87 26.43% TOTAL PUBLIC WORKS 17,066,143 3,713,039.84 16,574;925.73 17,071,724.13 41,211.70 (46,792.83) 100.27 %;' MISC & PROJECTS PROJECTS Fund Charges /Transfers - - - 945,227.88 - (945,227.88) 0.00% TOTAL PROJECTS - - - 945,227.88 - (945,227.88) 0.00% TOTAL MISC & PROJECTS - - 945,227.88 (945,227.88) 0.00 %' TOTAL EXPENDITURES 17, 768,563 3,779,841.11 17,156,373.57 18,680,108.57 41,280.00 (952,82557) 10536 %? " REVENUE OVER(UNDER)EXPENSES " 92,115 3,683,110.07 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 424,083.00 Cash in Investments Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Lone Star Investment - Water /SSLGC SAWS Schertz Bank & Trust - Certificate of Deposit 1,071,818.84 295, 757.87 177,823.50 256,882.26 281,676.95 1,068,630.27 $ 3,152,589.69 Total Cash in Bank & Investments $ 3,576,672.69 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30st, 2015 2D14'2O15 2034EK8S CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY F000 8.418.343 818,940.71 5,277.919.38 5,730.758.02 - 685.584.98 89.32% Inter-Jurisdictional 1.601.070 23.843.92 1.564.050.61 1.596/474.94 - 4.001.06 8871% K4iooe||eneouu 1}9,{500 —_32,484.80 10560277 80,91216 ----------_ --_88,587.84 47.74% TOTALREVENUES 8,186,919 675,278A3 6,947,580.76 7,408,14512 - 778,773.88 90.49% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3.111.898 480.027.64 3.055.52822 3.335.90773 - (224.008.73) 10720% Supplies 386.786 (46�88.73) 287.597.73 274.320.99 24.541�81 87.923.0 77.27% Human Services 1.000 - 424.00 1.151.50 - (151.50) 11515% City Support Services 35.052 9.532.00 17.020.32 24.149�51 - 10.902.48 08.90% Utility Services 135.305 10.39011 142.809.83 109/41115 35813 25.535.72 8113% Operations Support 112.328 10.02813 89.313.93 101.23813 329.09 10.76018 90.42% Staff Support 85.353 4.749.64 82.828.80 74.756.52 8�7.89 2.368.59 97.22% City Assistance 11.900 300.00 12.066.30 12.188.73 - (288.73) 102.43% Professional Services 10.00 10�34.52 96.006.85 115.567.65 - (8.567.65) 108.01% Fund 3,366,084 1,285.18312 2J02.113.77 3,357.132.47 - 8.951.53 99.73% Maintenance Services 42.971 4.266.26 25.061.73 30.990.05 - 11.980.95 7212% Debt Service 270.820 1.80002 5.870.53 14,243.37 - 250.576.63 5.26% Rental-Leasing 81.541 (}3.745.73) - 579.55 - 80.961.45 071% Operating Equipment 205.080 20.05712 54.065.02 177.37110 5.474.05 82.234.85 08.98% Capital Outlay —_138,382 —_<50,746.29 ) - -_- —_789(744J}0 _{651`362.00) 570JI0% TOTAL PUBLIC ee (306,183.02 103.76% TOTAL EXPENDITURES 8,151,501 1,683,053.81 6,573,579.03 7,629,008.45 828,675.57 103.76% " REVENUE OVER(UNDER) EXPENSES 35,418 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 173,285.79 Cash in Investments Texas Class- Tax Note 2015 Ambulances 893,778.50 Total Cash in Bank & Investments $ 1,067,064.29 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 31st, 2015 * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5 * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100.0% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 456,029 48,478.63 396,929.80 454,909.27 - 1,119.73 Permits 3,000 360.00 3,600.00 3,120.00 - (120.00) 104.00% Fees 1,155,500 90,123.91 1,033,536.13 1,084,176.02 - 71, 323.98 93.83% Miscellaneous 25,700 603.76 1,140.85 27,337.44 (1,637.44) 106.37% TOTAL REVENUES 1,184,200 91,087.67 1,038,276.98 1,114,633.46 - 69,566.54 94.13% EXPENDITURE SUMMARY 49R. [SWi[iT:MW DRAINAGE Personnel Services 456,029 48,478.63 396,929.80 454,909.27 - 1,119.73 99.75% Supplies 8,300 364.65 5,573.19 5,577.23 - 2,722.77 67.20% Human Services 325 - 73.72 - - 325.00 0.00% City Support Services 27,932 1,328.87 2,212.44 4,250.66 23,681.34 15.22% Utility Services 30,370 1,896.32 25,279.04 17,513.46 - 12,856.54 57.67% Operations Support 2,460 17.32 19.66 82.29 - 2,377.71 3.35% Staff Support 8,116 645.12 5,307.18 4,808.83 - 3,307.17 59.25% City Assistance 840 - - - - 840.00 0.00% Professional Services 23,500 13,838.50 21,581.48 20,186.82 - 3,313.18 85.90% Fund Charges /Transfers 221,818 76,581.75 238,413.63 278,998.14 - (57,180.14) 125.78% Maintenance Services 47,000 14,800.00 9,046.64 16,257.90 25,920.00 4,822.10 89.74% Other costs 200 - 200.00 100.00 - 100.00 50.00% Debt Service 140,530 1,880.29 1,962.88 11,136.91 - 129,393.09 7.92% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 (500.00) 11,303.80 4,182.65 - 1,317.35 76.05% Capital Outlay - - - - - - 0.00% TOTAL DRAINAGE 973,420 159,331.45 717,903.46 818,004.16 25,920.00 '' 129,495.84 86.70% PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 (591.34) - - - 1,000.00 0.00% Professional Services 7,700 (5,138.75) - - 8,000.00 (300.00) 103.90% Maintenance Services 134,298 _(137,784.59) - - - 134,298.00 0.00% TOTAL PROJECTS 146,198 (143,514.68); - - 8,000.00 138,198.00 5.47 %s TOTAL EXPENDITURES 1,119,618 15,816.77 717,903.46 818,004.16 33,920.00 ? 267,693.84 76.09 %' " REVENUE OVER(UNDER) EXPEND 64,582 296,629.30 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 31st, 2015 Cash in Bank Claim on Operating Cash Pool- Checking 206,707.97 Cash in Investments Lone Star Investment - Drainage Maint Fund 807,843.46 Total Cash in Bank & Investments $ 1,014,551.43 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30st, 2015 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I- ajoff lJ .� 1► i► Ie1:�'1 Taxes 544,753 114,124.27 552,570.10 563,733.79 - (18,980.79) 103.48% Miscellaneous 600 94.63 391.20 64724 - (47.24) 107.87% TOTAL REVENUES 545,353 114,218.90 552,961.30 564,381.03 - (19,028.03) 10149 %' EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - - - - 2,500.00 0.00% City Support Services 61,500 8,912.06 66,786.10 59,575.74 - 1,924.26 96.87% Operations Support 69,500 17,042.56 31,447.67 32,757.71 - 36,742.29 47.13% Professional Services 5,825 - 2,800.00 3,000.00 - 2,825.00 51.50% Fund Charges/Transfers 126,405 25,533.75 373,301.18 109,905.00 - 16,500.00 86.95% Maintenance Services - - 23,653.88 - - - 0.00% Operating Equipment 37,000 3,954.00 9,623.59 9,77224 1,712.60 25,515.16 31.04% TOTAL NONDEPARTMENTAL 302,730 > 55,442.37 507,612.42 215,010.69 1,712.60 86,006.71 71.59 %: TOTAL EXPENDITURES 302,730 55,442.37 507,612.42 215,010.69 1,712.60 86,006.71 71.59 %ll REVENUE OVER(UNDER) EXPENDITURE 242,623 349,370.34' HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30st, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 316,857.77 Cash in Investments Texas Class - Hotel Tax 499,702.45 Total Cash in Bank & Investments $ 816,560.22 HOTEL OCCUPANCY TAX $80,000 $70,000 - - -- - - - - - - - - - - - - $60,000 $50,000 $40,000 - - - - - - - - $30,000 $20,000 $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 201314 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 2012 -13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 -. - -- 2011 -12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 2010-11 27,689 25,112 23,231 19,619 22,667 1 36,728 28,215 34,157 45,854 53,433 42,181 32,294 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2015 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4 - 2 0 1 5 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 100,000 74,000.00 198,150.00 92,000.00 - 8,000.00 92.00% Miscellaneous - 10.42 2,814.15 10623 - (106.23) 0.00% TOTAL REVENUES 100,000 74,010.42 200,964.15 ? 92,106.23 - 7,893.77 92.11% EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges /Transfers 32,405 753.60 - 33,158.60 - (753.60) 102.33% Maintenance Services- Landscape - - 12,840.00 - - - 0.00% Operating Equipment - 3,075.00 - 6,037.81 - (6,037.81) 0.00% Capital Outlay 60,000 - - 10,930.00 7,184.49 41,885.51 30.19% TOTAL PARKLAND DEDICATION 92,405 3,828.60 12,840.00: 50,126.41 7,184.49 35,094.10 62.02% TOTAL EXPENDITURES 92,405 3,828.60 12,840.00 50,126.41 7,184.49 35,094.10 62.02 %' REVENUE OVER(UNDER) EXPEND 7,595 41,979.82 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $232,770.51 Cash in Investments Texas Class- Park Fund 1,356.59 Total Cash in Bank & Investments $234,127.10 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 36,000 - 241,272.50 191,487.50 - (155,487.50) 531.91% Fund Transfers 176,939 - - - - 176,939 0.00% Miscellaneous 210 67.46 230.13 439.77 - (229.77) 209.41% TOTALREVENUES 213`,149 67.46 241,502.63 191,927.27 - 21,221.73 90.04% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 212,939 148,184.47 39,956.30 219,984.39 148,184.47 (155,229.86) 172.90% TOTAL TREE MITIGATION 212,939 148,184.47 39,956.30 219,984.39 148,184.47 (155,229.86) 172.90 %d TOTAL EXPENDITURES 212;939 (148,117.01) 39;956.30 219,984.39 148,184.47 176,451.59 REVENUE OVER(UNDER) EXPEND 210 (28,057.12)' TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $81,676.90 Cash in Investments MBIA Investment-Tree Mitigation 397,655.56 Total Cash in Bank & Investments $479,332.46 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 96,822.00 778,977.00 1,193,728.30 - (313,528.30) 135.62% Miscellaneous 5,300 751.68 5,715.87 6,649.31 - (1,349.31) 125.46% TOTAL REVENUES 885,500 97,57168 784,692.87: 1,200,377.61 - (314,877.61) 135.56 %! EXPENDITURE SUMMARY GENERAL GOVERNMENT a [•1a1.7= I 7I-.40La= Iikr_l� Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 80,000 - 1,058.50 1,000.00 - 79,000.00 1.25% Fund Charges /Transfers 116,000 - 79,865.90 3,579.00 - 112,421.00 3.09% Maintenance Services 1,000 - - - - 1,000.00 0.00% Capital Outlay 450,000 - - - - 450,000.00 0.00% TOTAL NON DEPARTMENTAL 652' 109 - 80,924.40 4,579.00 - 647,530.00 0.70% MISC & PROJECTS Water Projects - - - 85,186.10 186,732.71 (271,918.81) 0.00% TOTAL MISC &PROJECTS - - - 85,186.10 186,732.71 (271,918.81) 0.00 %s' TOTAL EXPENDITURES 652,109 - 80,924.40 89,765.10 186,732.71 375,611.19 42.40 %'; REVENUE OVER(UNDER) EXPENDITURES 233,391 ' 1,110,612.51 CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,315,555.12 Cash in Investments Lone Star Investment - Capital Recovery Water 4,499,004.94 Total Cash in Bank & Investments $ 5,814,560.06 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 2 0 1 4- 2 0 1 5********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 600,400 70,717.44 447,771.38 710,060.88 - (109,660.88) 118.26% Fund Transfers 559,497 - 77,778.00 - - 559,497.00 0.00% Miscellaneous 600 5,689.44 12,171.24 20,725.50 - (20,125.50) 3454.25% TOTAL REVENUES 1,160,497 76,406.88 537,720.62 730,786.38 - 429,710.62 6297 %(' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 3,143 359.30 5,290.66 5,309.16 - (2,166.16) 168.92% Fund Charges/Transfers 139,312 139,312.00 - 139,312.00 - - 100.00% TOTAL NON DEPARTMENTAL'; 142,455 139,67130 5,290.66 144,621.16 (2,166.16) 101.52 %' MISC & PROJECTS Sewer Projects 1,018,042 - - - - 1,018,042.00 0.00% TOTAL MISC &PROJECTS 1,018 042 - - - - 1,018,042.00 0.00 %s' TOTAL EXPENDITURES 1,160,497 139,67130 5,290.66 144,621.16 - 1,015,875.84 12.46 %!' REVENUE OVER(UNDER) EXPENDITURES - 586,165.22 CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 739,764.62 Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,954,145.45 Capital One-Investment 1,739,490.26 Total Cash in Bank & Investments $ 4,433,400.33 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 4- 2 0 1 5******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 100% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,338,513 5,144.04 5,295,576.53 5,415,058.64 - (76,545.64) 101.43% Miscellaneous 368,763 16,248.03 8,817,615.64 369,763.47 - (1,000.47) 100.27% TOTAL REVENUES 5,707,276 21,392.07 14,113,192.17 5,784,822.11 - (77,546.11) 101.36 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 400.00 165,650.00 3,150.00 - 39,200.00 7.44% Debt Service 5,593,807 (33,742.43) 4,657,056.56 5,559,928.85 - 33,878.15 99.39% TOTAL GENERAL GOVERNMENT 5,636,157 (33,342.43) 14,004,956.79 5,563,078.85 73,078.15 98.70% TOTAL EXPENDITURES 15,636,157 (33,342.43) 14,004,956.79 5,563,078.85 - 73,078.15 98.70 %' " REVENUE OVER(UNDER)iEXPEND 71,119 221,74126 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 50,740.51 Cash in Investments IVIBIA Investment- Tax I&S 796,436.75 Total Cash in Bank & Investments $ 847,177.26 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2015 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 14 - 2 0 1 5********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 100% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,682,057 374,071.52 3,521,337.71 3,442,819.12 - 239,237.88 93.50% Miscellaneous 10,200 3,220.22 9,598.58 15,921.93 - (5,721.93) 156.10% TOTAL REVENUES 3,692,257 377,29174 3;530,936.29 3,458,741.05 - 233515.95 93.68 %' Immaklialloul ECONOMIC DEVELOPMENT Personnel Services 364,312 25,662.06 317,696.03 187,590.38 - 176,721.62 51.49% Supplies 1,050 25.98 474.27 632.13 - 417.87 60.20% Human Services 1,000 - - 135.00 - 865.00 13.50% City Support Services 16,545 635.00 1,174.29 1,753.09 - 14,791.91 10.60% Utility Services 4,120 241.21 1,917.71 1,149.66 - 2,970.34 27.90% Operations Support 147,145 10,304.25 100,167.65 67,041.24 525.00 79,578.76 45.92% Staff Support 18,250 4,154.56 8,614.15 7,170.56 - 11,079.44 39.29% City Assistance 1,025,000 9.39 501,524.63 86.30 - 1,024,913.70 0.01% Professional Services 92,500 3,951.04 17,633.91 15,506.04 - 76,993.96 16.76% Fund Charges /Transfers 471,280 20,510.05 503,653.25 466,996.43 - 4,283.57 99.09% Debt Service 430,608 - 427,671.25 430,609.25 - (1.25) 100.00% Operating Equipment 2,000 - 38.99 368.77 - 1,631.23 18.44% TOTAL ECONO DEVELOPMENT 2,573,81,0 65,493.54 1,880,566.13 1,179,038.85 ? 525.00 1,394 246.15` 45.83% MISC & PROJECTS PROJECTS 450,000 3,109.90 - 250,474.79 - 199,525.21 55.66% TOTAL MISC &'PROJECTS 450,000 3,109:90 250,474.79 - 199,525.21 ! 0.00 %< TOTAL EXPENDITURES 3,023,810 68,603.44 1,880,566.13 1,429,513.64 525.00 s 1,593,771.36 47.29 %' -* REVENUE OVER(UNDER) EXPEND 668,447 2,029,227.41 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2015 Cash in Bank Claim on Operating Cash Pool-Checking $ 594,824.34 Cash in Investments Texas Class Investment-Economic Development Corl 7,586,145.17 Schertz Bank & Trust-Certificate of Deposit 1,049,082.71 Total Cash iin Bank & Investments $ 9,230,052.22 4B SALES TAX By Collection Month 41 �� C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2015 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2015 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending Par Value Maturity Weighted OPERATIONS -BANK CASH Book Value Yiel Purchases Withdrawals Earns Book Value Mkt Value Date Avva Mat. Schertz Bank & Trust - Pooled Cash 6,928,774.05 0.0500 5,373,516.47 4,666,661.52 289.29 7,635,918.29 7,635,918.29 7,635,918.29 N/A Schertz Bank & Trust - PEG Fund 430,464.72 0.0000 50,328.75 6,849.80 - 473,943.67 473,943.67 473,943.67 N/A TOTAL OPERATIONS 7, 359 238.77 5,423,845.22 4,673,511.32 289.297 8, 309, 861:96 81,109,861.96 8,109,861.96 - LOGIC General Fund 7,444,075.09 0.1354 - 1,100,000.00 822.88 6,344,897.97 6,344,897.97 6,344,897.97 N/A 37 Days G /F- Equipment Replacement 73,719.22 0.1354 - - 8.21 73,727.43 73,727.43 73,727.43 N/A 37 Days G /F- Vehicle Replacement 306,955.39 0.1354 - - 34.18 306,989.57 306,989.57 306,989.57 N/A 37 Days G/F -Air Conditioner Replacement 196,258.65 0.1354 - - 21.85 196,280.50 196,280.50 196,280.50 N/A 37 Days SR2009 Bond- Street Projects(II) 1,031,149.26 0.1354 - - 114.76 1,031,264.02 1,031,264.02 1,031,264.02 N/A 37 Days TOTAL SLOGIC 9, 052, 157.61 °- -1,100,000.00 (:1,001.88 7,953,159:49 :7,953,159.49 ',7,953,159.49 - LONESTAR Capital Recovery - Sewer 1,953,845.58 0.1900 - - 299.87 1,954,145.45 1,954,145.45 1,954,145.45 N/A 37 Days Capital Recovery - Water 4,498,314.56 0.1900 - - 690.38 4,499,004.94 4,499,004.94 4,499,004.94 N/A 37 Days Drainage Fund 806,683.02 0.1900 - - 123.81 806,806.83 806,806.83 806,806.83 N/A 37 Days Facilities Master Plan 145,311.37 0.1900 - - 22.30 145,333.67 145,333.67 145,333.67 N/A 37 Days GO SR2011 Animal Shelter 11,530.77 0.1900 - - 1.77 11,532.54 11,532.54 11,532.54 N/A 37 Days GO SR2011 Soccer Fields 210,247.47 0.1900 - - 32.27 210,279.74 210,279.74 210,279.74 N/A 37 Days GO SR2011 Swimming Pool 5,787,923.43 0.1900 - - 888.30 5,788,811.73 5,788,811.73 5,788,811.73 N/A 37 Days GO SR2012 Downtown Improvements 980,094.28 0.1900 - - 150.42 980,244.70 980,244.70 980,244.70 N/A 37 Days SE Elevated Water Tank 810,801.69 0.1900 103.43 - 124.45 811,029.57 811,029.57 811,029.57 N/A 37 Days Sewer /CCMA Project 2,930,496.90 0.1900 - - 449.76 2,930,946.66 2,930,946.66 2,930,946.66 N/A 37 Days W /S- Customer Deposits 295,712.49 0.1900 - - 45.38 295,757.87 295,757.87 295,757.87 N/A 37 Days W /S- Equipment Repl /Cap.Imp 177,796.21 0.1900 - - 27.29 177,823.50 177,823.50 177,823.50 N/A 37 Days Water &Sewer 1,571,582.69 0.1900 - 500,000.00 236.15 1,071,818.84 1,071,818.84 1,071,818.84 N/A 37 Days W /S- Vehicle Replacement 256,842.84 0.1900 - - 39.42 256,882.26 256,882.26 256,882.26 N/A 37 Days Water /SSLG - SAWS 103.43 0.1900 - 103.43 - 0.00 0.00 0.00 N/A 37 Days TOTAL LONESTAR. - :20,437;286.73 103.43 -: 500;.103.43 3,131.57: 19,940,418:30 :19,940,418.30 .:19,940,418.30 - TEXAS CLASS Tax I &S 796,309.54 0.1900 - - 127.21 796,436.75 796,436.75 796,436.75 N/A 65 Days Police Forfeiture 244,313.87 0.1900 - - 39.05 244,352.92 244,352.92 244,352.92 N/A 65 Days Park Fund 1,356.33 0.1900 - - 0.26 1,356.59 1,356.59 1,356.59 N/A 65 Days Economic Development Corporation 7,584,933.45 0.1900 - - 1,211.72 7,586,145.17 7,586,145.17 7,586,145.17 N/A 65 Days Library Board 44,906.52 0.1900 - - 7.18 44,913.70 44,913.70 44,913.70 N/A 65 Days Tree Mitigation 397,592.05 0.1900 - - 63.51 397,655.56 397,655.56 397,655.56 N/A 65 Days Tax Note 2013 Fire Truck 4,935.18 0.1900 - - 0.85 4,936.03 4,936.03 4,936.03 N/A 65 Days Hotel Tax 499,622.65 0.1900 - - 79.80 499,702.45 499,702.45 499,702.45 N/A 65 Days Special Events Fund 16,802.87 0.1900 - - 2.68 16,805.55 16,805.55 16,805.55 N/A 65 Days Citywide Projects SR2007 506,135.68 0.1900 - - 80.87 506,216.55 506,216.55 506,216.55 N/A 65 Days Tax Notes 2015 EMS Ambulances 893,778.50 0.1900 - 10,788.24 141.91 883,132.17 883,132.17 883,132.17 N/A 65 Days Tax Notes 2015 Drainage Equipment 625,562.83 0.1900 54,287.06 - 104.39 679,954.28 679,954.28 679,954.28 N/A 65 Days Tax Notes 2015 Water Equipment 327,284.88 0.1900 - 45,656.47 48.54 281,676.95 281,676.95 281,676.95 N/A 65 Days Tax Notes 2015 General Fund Equipme 238,207.56 0.1900 2,157.65 - 38.25 240,403.46 240,403.46 240,403.46 N/A 65 Days TOTAL':: TEXAS 'CLASS 12,181,741.91 56:444.71 56;:444.71 :':1,946.22' 12;:183,688.13 12:,183;:688.13 :12,183';:688.13 - C I T Y 0 F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2015 TOTAL PORTFOLIO 0.37 $ 5,810.21 $ 53,422,110.76 $ 53,409,778.69 $ 53,254,813.15 91 Days City MdhagerlExecutive Director -Fi-Kance D-i-rlct* I Ile 04-'inancial Analyst Beginning Value Interest Withdrawals Ending Par value Maturity Aver 1h=SMENT UM&UD ACCOUNT Capital One General Fund Book 1,367,419.15 Yield Purchases 2.9600 Earne 280.50 (1,784.04) Book Value 1,365,354.61 Mkt Y-allie 1,357,601.54 1,281,999.19 Date N/A 697 Mat, Days Capital One Capital Recovery Sewer 1,751,049.30 2.4700 - 359.30 1,225.29 1,751,915.29 1,739,490.26 1,667,973.10 N/A 675 Days TOTAL CAPITAL ONE 3,118,468.45 - 639.80 (558.75) 3,117,269,90 3,097,091.80 2,949,972.29 - C. D. CERTIFICATES OF DEPOSIT Ter SB&T-Water&Sewer 1,068,630.27 0.7500 - - 1,068,630.27 1,074,493.10 1r068f630.27 1/7/2016 365 Days Schertz Economic Development Corp. 1,049,082.71 0.6000 - 1,049,082.71 1,051,065.91 1,049,082.71 12/5/2015 180 Days TOTAL C.Ds 2,117,712.98 - 2,117,712.98 2,125,559.01 2,117,712.98 TOTAL PORTFOLIO 0.37 $ 5,810.21 $ 53,422,110.76 $ 53,409,778.69 $ 53,254,813.15 91 Days City MdhagerlExecutive Director -Fi-Kance D-i-rlct* I Ile 04-'inancial Analyst Q TOTAL TEXAS CLASS 230 City Portfolio By Investment Type TOTAL C. D 370 TOTAL LOGIC 150 0 Special RevenUE Funds, $18,779,726.08 $7 City Portfolio By Use M Designated Funds, $1,374,116.41 M Operations, $17,958,673.41 'ojects, $14,500,826.04 3.00 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS Oct -14 Nov -14 Dec -14 Jan -15 Feb -15 Mar -15 Apr -15 May -15 Jun -15 Jul -15 Aug -15 Sep -15 Oct -14 Nov -14 Dec -14 Jan -15 Feb -15 Mar -15 Apr_ -15 May -15 Jun -15 Jul -15 Aug -15 Sep -15 01 Month T -Bill 0.0100 0.0400 0.0300 0.0100 0.0200 0.0500 0.0000 0.0100 0.0200 0.0400 0.0000 0.0000 03 Month T -Bill 0.0100 0.0200 0.0400 0.0200 0.0200 0.0300 0.0100 0.0100 0.0100 0.0800 0.0800 0.0000 06 Month T -Bill 0.0500 0.0700 0.1200 0.0700 0.0700 0.1400 0.0600 0.0600 0.1100 0.1400 0.2700 0.0800 BSchertz Portfolio 0.2422 0.2371 0.2197 0.2265 0.2262 0.2283 0.2368 0.2339 0.3006 0.3148 0.3258 0.3748 BSchertz Bank &Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 BCD 365 Days - - -- ------------------------------ BCD 180 Days ------------------------ -LOGIC 0.4000 - - - 0.6000 - 0.0879 0.4000 -- - -- - 0.6000 _ ___ 0.0871 0.4000 -_ -- 0.3500 -- _ 0.0974 0.7500 __ 0.3500 _ - __ -- 0.0843 0.7500 - - - - ---- 0.3500 -_ 0.0921 0.7500 -- --- - -- 0.3500 - - -- - -- 0.0999 0.7500 -- - 0.3500 - - ----- 0.1130 0.7500 - __ - 0.3500 0.1122 0.7500 __ - -- 0.6000 _ -_ -_ 0.1249 0.7500 - -- -- ------------------------ 0.6000 - 0.1265 0.7500 0.6000 - 0.1354 1 0.7500 --- ---- -_ - ------ 0.6000 - -- - - -- 0.1354 DLoneStar 0.1300 0.1400 0.1400 0.1300 0.1300 1 0.1400 0.1400 0.1500 0.1600 0.1600 0.1700 1 0.1900 DMBIA 0.1000 0.1000 0.1000 0.1100 0.1100 0.1200 0.1400 0.1400 0.1500 0.1600 0.1600 0.1900 - Capital One 1.4135 1.3208 1.4416 1.4858 1.4594 1.4575 1.4587 1.4596 2.2923 2.2949 2.3005 2.6858 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 9/30/2015 General Fund Assets Capital Recovery Assets Projected Projected Annual Current Annual Current Cash & Equivalents Shares Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 52,973.10 64.00 6,999.19 6,999.19 6,999.19 8.00 0.11 Total Cash & Equivalents 52,973.10 64.00 0.12° 6,999.19 6,999.19 6,999.19 8.00 0.11° Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 77.00 200,000.00 230,779.00 201,968.00 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 77.00 100,000.00 116,185.00 100,984.00 4,875.00 4.83 1,093.00 Federal Natl Mtg Assn 1/30/2017 488.00 100,000.00 102,366.80 100,968.00 1,250.00 1.24 5,125.00 Federal Home LN Mtg Corp Reference Nts 11/17/2017 779.00 100,000.00 109,860.00 109,100.00 5,125.00 4.70 4.41 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 987.00 475,000.00 526,095.45 525,003.25 23,156.00 4.41 US Treasury Note 3/15/2017 10/15/2017 746.00 100,000.00 99,875.00 100,431.00 875.00 0.87 US Treasury Note US Treasury Note 746.00 11/15/2017 777.00 100,000.00 99,425.78 100,373.00 875.00 0.87 10/31/2019 US Treasury Note 50,000.00 11/30/2015 61.00 60,000.00 61,936.72 60,132.00 825.00 1.37 777.00 US Treasury Note 99,425.78 5/31/2016 244.00 90,000.00 93,360.67 90,908.10 1,575.00 1.73 100,000.00 US Treasury Note 99,939.00 2/28/2018 882.00 50,000.00 49,585.94 49,969.50 375.00 0.75 239,781.76 US Treasury Note 1,500.00 7/15/2017 654.00 100,000.00 99,664.06 100,484.00 875.00 0.87 Total Fixed Income 2.55° Total Assets 1,275,000.00 1,358,355.42 1,338,352.85 39,806.00 2.970 Total Assets 696.50 1,281,999.19 1,365,f354.61i 1,345,352.04 39,814.00 2.96% Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 52,973.10 52,973.10 52,973.10 64.00 0.12 Total Cash & Equivalents 52,973.10 52,973.10 52,973.10 64.00 0.12° Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 77.00 200,000.00 230,779.00 201,968.00 9,750.00 4.83 Federal Natl Mtg Assn 10/26/2017 757.00 125,000.00 124,588.38 125,401.25 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 779.00 100,000.00 109,860.00 109,100.00 5,125.00 4.70 Federal Home Mtg Corp Refrnce 8 6/13/2018 987.00 350,000.00 387,637.60 386,844.50 17,062.00 4.41 Federal Home LN Mtg Corp 3/27/2019 1274.00 100,000.00 108,297.40 108,888.00 3,750.00 3.44 US Treasury Note 3/15/2017 532.00 150,000.00 149,753.91 150,534.00 1,125.00 0.75 US Treasury Note 10/15/2017 746.00 100,000.00 99,644.53 100,431.00 875.00 0.87 US Treasury Note 10/31/2019 1492.00 50,000.00 49,998.05 50,559.00 750.00 1.48 US Treasury Note 11/15/2017 777.00 100,000.00 99,425.78 100,373.00 875.00 0.87 US Treasury Note 2/28/2018 882.00 100,000.00 99,175.78 99,939.00 750.00 0.75 US Treasury Note 7/15/2016 289.00 240,000.00 239,781.76 240,609.60 1,500.00 0.62 Total Fixed Income 1 615, 000. 00 1,698,942.19 1,674,647.35 42,655.00 2.55° Total Assets 674.04 1,667,973.10 1,751 „915.29 1,727,620.45 42,719.00 2.47 %'