Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Q4-September-2016 Financials
CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 17,335,590.00 748,540.39 16,378,840.86 24,366.25 17,781,461.91 - (445,871.91) 102.57% Franchises 2,221,153.00 212,352.31 2,160,594.53 455.75 2,151,790.71 - 69,362.29 96.88% Permits 1,249,839.00 111,396.37 1,369,000.30 67,018.33 1,178,391.14 - 71,447.86 94.28% Licenses 84,160.00 3,895.00 - 78,814.00 221.56 55,657.00 - 28,503.00 66.13% Fees 2,470,622.00 225,555.44 2,595,352.98 15,028.60 2,474,120.72 - (3,498.72) 100.14% Fines 31,000.00 2,197.54 30,616.10 107,090.49 25,738.67 - 5,261.33 83.03% Inter - Jurisdictional 783,847.00 106,791.80 742,604.14 791,548.63 - (7,701.63) 100.98% Fund Transfers 1,921,266.00 200,888.05 1,804,221.43 807,431.06 1,680,224.09 - 241,041.91 87.45% Miscellaneous 462,000.00 64,462.84 506,204.55 1,826.80 581,844.62 - (119,844.62) 125.94% TOTAL REVENUES 26,559,477 1,676,079.74 25,666,248.89 26,720,777.49 - (161,300.49} 100.61 % EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 2,598.05 23,649.53 24,366.25 - (791.25) 103.36% Supplies 2,600 25.65 643.37 455.75 - 2,144.25 17.53% City Support Services 68,176 (168.66) 37,922.51 67,018.33 - 1,157.67 98.30% Operations Support 500 - 226.68 221.56 - 278.44 44.31% Staff Support 26,500 205.98 12,269.73 15,028.60 - 11,471.40 56.71% TOTAL CITY COUNCIL 121,351 2,661.02 74,711.82 107,090.49 '- 14,260.51 88.25 % CITY MANAGER Personnel Services 815,887 73,162.64 845,916.51 807,431.06 - 8,455.94 98.96% Supplies 3,000 85.96 2,916.11 1,826.80 - 1,173.20 60.89% City Support Services 2,270 383.00 2,535.46 1,071.22 - 1,198.78 47.19% Utility Services - - - 114.82 - (114.82) 0.00% Staff Support 34,275 2,180 27,417 21,310.14 - 12,965 62.17% Operating Equipment - - 724.91 - - - 0.00% TOTAL CITY MANAGER 855,432 75,811.71 879,510.07 831,754.04 - 23,677.96 97.23 %0! CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 278,579 27,532.65 269,664.31 278,965.72 - (386.72) 100.14% Supplies 3,500 705.68 1,122.17 1,566.70 - 1,933.30 44.76% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 2,184.00 2,529.46 3,125.00 - 1,375.00 69.44% Staff Support 7,710 922.28 3,782.99 5,585.58 260.00 1,864.42 75.82% Court Support 700 - 210.00 192.00 - 508.00 27.43% Professional Services 61,200 3,493.50 45,281.50 46,290.88 - 14,909.12 75.64% Maintenance Services 2,800 100.00 1,900.00 1,800.00 - 1,000.00 64.29% Operating Equipment 7,800 287.89 280.70 3,835.13 358.77 3,606.10 53.77% TOTAL MUNICIPAL COURT 367,789 35,226.00 324,77,1.13 341,361.01 618.77 25,809.22 92.98% CUSTOMER RELATIONS -311 Personnel Services 115,445 11,307.78 106,611.67 108,939.63 - 6,505.37 94.36% Supplies 200 100.96 199.69 175.89 - 24.11 87.95% Staff Support 975 - 484.51 348.82 - 626.18 35.78% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 117,120 11,408.74 107,295.87 109,464.34 - 7,655.66 93.46 % PLANNING & ZONING Personnel Services 144,435 18,547.85 133,552.04 145,345.71 - (91071) 100.63% Supplies 2,746 951.29 3,720.71 2,568.35 - 177.65 9153% City Support Services 296 - - 295.20 - 0.80 99.73% Operations Support 750 100.96 98.56 264.09 - 485.91 35.21% Staff Support 19,449 5,161.60 14,880.79 9,684.59 65.00 9,699.41 50.13% Professional Services 300 - 77 39 - 261 1100% Operating Equipment 3,631 - 486.00 129.98 3,400.40 100.62 9723% TOTAL PLANNING & ZONING 171,607 24,761.70 152,815.10 158,326.92 3,465:40 9,814.68 94.28 %a LEGAL SERVICES Operations Support 10,000 4,034.87 7,482.06 5,432.28 84.76 4,482.96 55.17% Professional Services 119,401 37,832.88 183,078.32 124,931.49 - (5,530.49) 104.63% TOTAL LEGAL SERVICES ! 129,401 41,867.75 190,560.38 130,36177 8416 (1,047.53) 100.81 %0? CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDUED) AS OF: SEPTEMBER 30,2016 2U15-2V1V 101GENER4 qJwo CURRENT CURRENT PRIOR YEAR Y�o Y�o BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 503.569 57.803.70 570.707.54 522.520.58 41.04241 92.72% Supplies 01.458 12.38449 40.890.87 78.06349 ' 5.39539 93.38Y6 Utility Services 38000 4,699.94 17,852.70 3O8 O3 TOTAL GENERAL SERVICES 683,628 75,028,13 635,517.11 637,46591 - 46,161.97 93.25% CITY SECRETARY Personnel Services 109.908 17.92350 107.539.01 173.572.08 - (3.584.08) 102.11% Supplies 1.350 137.58 1.21275 872.33 - 877.07 2758% City Support Services 10.500 - 2.75327 8.871.37 - 528.03 94.97% Operations Support 450 - ' 42.50 - 407.50 844% Staff Support ------_8,725� ------1,325.68� ----_4,054.35 ---_4^741.11 -----_--_ -----3,983.89 54.34% TOTAL CITY SECRETARY 191,013 19,386.76 175,559.98 188,699.99 - 2,313.01 98.79% NON-DEPARTMENTAL City Support Services 308.793 1.308.04 339.565.18 329,413.50 2.208.00 37.179.50 89.92% Operations Support 134.500 35.044.08 143.333.33 145.725.02 (11.225.02) 10835Y6 Staff Support 9.900 - 80.00 10.10521 - (20521) 102.08% City Assistance 1.086.326 - 1.181.02070 1.061.880.94 - 24.439.00 98.55Y6 Professional Services 83.285 3.253.06 107.391.42 03.778.24 29.450.00 (28.843.24) 147.31.& Fund Chrgorrmno0rs-Spec Events Fnd 125.200 99^673.65 549.180.52 98.073.05 - 25.520.35 78.61Y6 Operating Equipment -_ -_ 27,471.81 1,874/00L -_ (1,87n4.00) 0.00Y6 TOTAL NON-DEPARTMENTAL 2,388,004 139,941.63 2,348,649.56 2,312,517A6 31,65000 43,836.84 98A6% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS 243,764 20,476.29 186,441.78 193,599.98 - 50,164.02 79.42% Personnel Services 272,396 27,838.93 246,577.37 265,910.00 - 6,486.00 97.62% Supplies 3,850 11.95 3,166.96 1,942.28 - 1,907.72 50.45% Operations Support 23,640 2,737.39 13,539.96 19,617.91 - 4,022.09 82.99% Staff Support 5,230 1,622.90 3,668.68 3,649.23 - 1,580.77 69.77% Professional Services 1,400 - 589.00 - - 1,400.00 0.00% Operating Equipment 3,600 - 2,512.22 3,378.83 - 221.17 93.86% TOTAL PUBLIC AFFAIRS 310,116 32,211.17 270,054.19 294,498.25 - 15,617.75 94.96 %` RECORDS MANAGEMENT 268,504 23,93613 220,533.34 208,652.45 - 59,851.55 77.71 % Personnel Services 52,540 4,909.76 50,550.50 51,517.55 - 1,022.45 98.05% Supplies 400 8.00 262.66 74.37 - 325.63 18.59% Staff Support 1,250 43.19 1,187.87 87.63 - 1,162.37 7.01% Professional Services 10,000 542.50 9,468.50 8,492.50 700.00 807.50 91.93% TOTAL RECORDS MANAGEMENT 64,190 5,503.45 61,469.53 60,172.05 700.00 3,317.95 94.83 %i SCHERTZ MAGAZINE Personnel Services 140,795 13,291.47 133,345.82 119,363.15 - 21,431.85 84.78% Supplies 200 - 123.99 127.50 - 72.50 63.75% Staff Support 2,220 117.00 2,271.61 1,297.90 - 922.10 58.46% Professional Services 245,500 26,444.98 230,459.61 235,083.81 - 10,416.19 95.76% Fund Charges /Transfers 10,000 9,825 13,728 9,825 - 175.00 98.25% Operating Equipment 1,500 999.98 - 999.98 - 500.02 66.67% TOTAL SCHERTZ MAGAZINE 400,215 50,678.43 379,929.03 366;697.34 - 33,517.66 91.63% 1c]IN:14 71►10 Personnel Services 243,764 20,476.29 186,441.78 193,599.98 - 50,164.02 79.42% Supplies 1,246 219.44 703.23 785.89 - 460.11 63.07% City Support Services 886 295.20 262.80 885.60 - 0.40 99.95% Utility Services 700 79.09 379.95 397.86 - 302.14 56.84% Operations Support - 221.71 - 221.71 - (221.71) 0.00% Staff Support 8,503 670.00 1,754.93 3,250.57 - 5,252.43 38.23% Professional Services 13,300 1,975.00 30,829.16 9,510.84 - 3,789.16 71.51% Operating Equipment 105 - 161.49 - - 105.00 0.00% TOTAL ENGINEERING 268,504 23,93613 220,533.34 208,652.45 - 59,851.55 77.71 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 142,882 14,650.55 138,225.12 143,556.99 - (674.99) 100.47% Supplies 2,200 - 1,098.72 1,454.13 - 745.87 66.10% Staff Support 4,390 - 4,411.50 4,515.32 - (125.32) 102.85% Rental /Leasing 3,805 - - 2,084 - 1,721.20 0.00% Operating Equipment - - 5,877.41 - - - 0.00% TOTAL GIS 153,277 14,650.55 149,612.75 151,610.24 - 1,666.76 98.91 %' TOTAL GENERAL GOVERNMENT 6,221,647 553,073.77 5,970,989.86 5,898,67196 36,518.93 286,453.99 95.40 %` PUBLIC SAFETY POLICE Personnel Services 5,575,209 574,863.49 5,112,499.63 5,633,876.16 - (58,667.16) 101.05% Supplies 36,906 1,718.43 48,516.46 35,440.64 - 1,465.43 96.03% City Support Services 19,081 - 24,151.52 19,081.45 - (0.45) 100.00% Utility Services 93,887 13,386.73 86,667.37 70,333.35 - 23,553.95 74.91% Operations Support 2,950 22.98 2,600.67 2,657.73 292.27 90.09% Staff Support 114,631 17,092.32 121,148.04 97,223.19 5,544.72 11,863.44 89.65% City Assistance 13,179 5,330.17 6,779.49 14,173.72 - (994.72) 107.55% Professional Services 37,288 4,126.08 39,540.32 40,492.07 - (3,204.07) 108.59% Maintenance Services 58,581 6,235.79 41,196.69 56,961.38 - 1,619.62 97.24% Operating Equipment 126,004 26,493.98 117,968.45 146,722.23 - (20,718.33) 116.44% Capital Outlay 205,160 (24,776.25) 260,032.72 180,183.50 - 24,976.25 87.83% TOTAL POLICE 6,282,876.37 624,493.72 5,861,101.36 6,297,145.42 5,544 >.72 (19,813.77) 10032% FIRE RESCUE Personnel Services 3,285,930 337,370.97 2,968,575.62 3,244,317.12 - 41,612.88 98.73% Supplies 17,100 1,560.32 13,928.98 15,820.31 316.00 963.69 94.36% Utility Services 48,137 4,925.69 49,445.14 39,832.91 - 8,304.09 82.75% Operations Support 1,100 9.72 364.41 918.30 - 181.70 83.48% Staff Support 120,778 17,906.39 102,106.10 119,383.28 945.14 449.58 99.63% City Assistance 16,200 11,873.46 15,570.09 16,082.46 - 117.54 99.27% Professional Services 19,123 37.00 10,058.00 13,680.00 - 5,443.00 71.54% Fund Charges/Transfers - 152,267.99 109,600.00 152,267.99 - (152,267.99) 0.00% Maintenance Services 54,507 5,053.64 42,925.21 45,561.56 - 8,945.71 83.59% Rental /Leasing 16,500 1,316.94 5,617.76 15,915.65 - 584.35 96.46% Operating Equipment 77,455 25,550.01 61,502.80 76,827.31 - 627.42 99.19% Capital Outlay 150,000 - 104,880.19 - - 150,000.00 0.00% TOTAL FIRE RESCUE 3,806,830 557,872.13 3,484,574.30 3,740,606.89 1,261.14 64,961.97 98.29% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 542,775 52,012.60 485,534.93 470,221.05 - 72,553.95 86.63% Supplies 5,965 2,670.27 2,570.88 5,639.91 - 325.09 94.55% Utility Services 3,724 772.56 4,286.76 3,790.87 - (66.87) 101.80% Operations Support 2,200 - 1,850.07 1,266.97 - 933.03 57.59% Staff Support 18,600 5,778.18 10,985.77 15,052.00 130.00 3,418.00 81.62% Professional Services 117,600 49,189.50 33,946.00 141,369.00 - (23,769.00) 120.21% Operating Equipment 2,496 129.98 667.95 2,188.25 - 307.75 87.67% Capital Outlay - - 20,435.82 - - - 0.00% TOTAL INSPECTIONS 693,360 110,553.09 560,278.18 639,528.05 130.00 53,701.95 92.25 %` MARSHAL'S OFFICE Personnel Services 618,483 62,913.50 580,526.50 612,059.94 - 6,423.06 98.96% Supplies 6,211 1,557.14 3,111.05 4,547.90 - 1,663.10 73.22% Utility Services 16,000 1,300.22 8,419.00 6,946.47 - 9,053.53 43.42% Operations Support 3,500 40.97 1,086.83 1,504.46 177.00 1,818.54 48.04% Staff Support 14,300 3,210.48 9,531.94 10,817.12 - 3,482.88 75.64% City Assistance 2,500 460.76 979.60 1,422.76 - 1,077.24 56.91% Maintenance Services 16,500 7,738.28 8,198.20 17,184.28 - (684.28) 104.15% Operating Equipment 5,039 8,206.12 14,971.65 13,732.63 - (8,693.63) 272.53% Capital Outlay 72,950 (7,162.00) - 62,950.00 - 10,000.00 86.29% TOTAL MARSHAL'S`` OFFICE 755,483 78,265 47 626,824.77 731,165.56 177.00 24,140.44 96.80 %0, TOTAL PUBLIC SAFETY 11,538,549.37 1,371,184.41 10,532,778.61 11,408,445.92 7,112'86 122,990.59 98.93 %! CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 28,700 387.42 19,197.28 19,928.06 359.96 8,411.98 70.69% Utility Services 29,000 PARKS DEPARTMENT 14,978.57 - STREETS 51.65% Maintenance Services 197,878 - 189,030.45 184,104.77 - Personnel Services 530,975 53,260.87 455,588.13 Personnel Services 713,763 63,927.60 88.76% 693,862.04 43,405 666,992.66 - 46,770.34 93.45% Supplies 7,100 353.10 - 5,616.53 - 6,060.08 - 1,039.92 85.35% Utility Services 149,604 24,258.89 192,195.14 123,100.96 - 151,241.18 - (1,637.18) 101.09% Staff Support 11,630 1,215.36 - 11,026.43 51.44% 10,265.31 - 1,364.69 88.27% Professional Services 107,000 808.00 60.60% 29,975.00 82,500 39,416.81 66,667.00 916.19 99.14% Maintenance Services 97,100 7,221.05 20,000 88,669.50 16,434.74 95,089.36 - 2,010.64 97.93% Rental /Lease 200 3,019.16 - 175.00 - - - 200.00 0.00% Operating Equipment 18,600 31,921.46 675.80 237.56 212.20% 38,261.09 1,810.00 (21,471.09) 215.44% Capital Outlay 81,400 (18,414.12) 25,985.49 65,625.40 - 15,774.60 80.62% TOTAL STREETS 1,186,397 111,291.34 51,052.39 978,648.51 1,072,951.89 68,477.00 44,968.11 96.21 % ' TOTAL PUBLIC ENVIRONMENT 1,186,397 111,29134 978,648.51 1,072,951.89 68,477.00 44,968.11 96.21% PARKS & RECREATION 28,700 387.42 19,197.28 19,928.06 359.96 8,411.98 70.69% Utility Services 29,000 PARKS DEPARTMENT 14,978.57 - 14,021.43 51.65% Maintenance Services 197,878 - 189,030.45 184,104.77 - Personnel Services 530,975 53,260.87 455,588.13 471,271.32 - 59,703.68 88.76% Supplies 43,405 2,979.39 45,126.94 39,258.91 936.47 3,209.62 92.61% City Support Services - 2,210.50 - 5,199.50 - (5,199.50) 0.00% Utility Services 173,800 34,271.44 192,195.14 209,641.81 - (35,841.81) 120.62% Operations Support 1,250 36.98 876.00 643.02 - 606.98 51.44% Staff Support 10,125 255.30 8,286.18 6,136.18 - 3,988.82 60.60% Professional Services 82,500 11,437.35 34,730.80 68,768.77 3,691.50 10,039.73 87.83% Maintenance Services 20,000 715.46 16,434.74 14,722.41 1,367.03 3,910.56 80.45% Rental /Leasing 39,600 3,019.16 37,045.81 36,319.97 - 3,280.03 91.72% Operating Equipment 2,500 - 2,074.01 4,629.32 675.80 (2,805.12) 212.20% Capital Outlay 38,000 - 59,795.05 27,840.60 - 10,159.40 73.26% TOTAL PARKS DEPARTMENT 942,155 108,186A5 852,152.80 884,431.81 6,670.80 51,052.39 94.58 % l SWIM POOL Supplies 28,700 387.42 19,197.28 19,928.06 359.96 8,411.98 70.69% Utility Services 29,000 3,362.76 20,026.54 14,978.57 - 14,021.43 51.65% Maintenance Services 197,878 - 189,030.45 184,104.77 - 13,773.23 93.04% Operating Equipment 2,500 - - 212.21 - 2,287.79 8.49% TOTAL SWIM POOL 258,078 3,750.18 228,254.27 219,223.61 359.96 38,494.43 85.08 %d CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 56,240 5,843.47 50,617.65 54,522.51 - 1,717.49 96.95% Supplies 15,500 (27.78) 12,495.50 9,298.79 79.99 6,121.22 60.51% Utility Services 51,850 8,055.38 50,870.26 49,864.67 - 1,985.33 96.17% Operations Support 9,358 (876.00) 15,330.99 3,964.47 - 5,393.53 42.36% Staff Support 2,500 53.00 1,667.16 893.00 - 1,607.00 35.72% Professional Services 500 - - - - 500.00 0.00% Operating Equipment 14,612 1,955.23 6,931.91 14,941.47 (1,850.61) 1,521.14 89.59% TOTAL EVENT FACILITIES ; 150,560 15,003,30 137,913.47 133,484.91 (1,770.62) 18,845.71 87.48 % SENIOR CITIZEN CENTER Supplies - (2,170.98) 6,794.55 - - - 0.00% Utility Services - - 216.78 - - - 0.00% Operations Support - - 591.92 - - - 0.00% City Assistence - (19,136.93) 40,804.21 - - - 0.00% Professional Services - (1,016.77) 12,622.09 - - - 0.00% Maintenance Services - (138.50) 396.51 - - - 0.00% TOTAL SENIOR CITIZEN CENTER - (22,463 18) 61,426.06 - - - 0.00 % TOTAL PARKS &RECREATION :! 1,350,793 104,476`.75 1,279,746.60 1,237,140.33 5,260,14 108,392.53 91.98 %'i CULTURAL LIBRARY Personnel Services 692,689 68,666.12 635,045.81 669,870.51 - 22,818.49 96.71% Supplies 15,000 1,596.22 12,601.81 14,507.31 - 492.69 96.72% Utility Services 56,500 9,229.85 53,226.86 50,901.37 - 5,598.63 90.09% Operations Support 3,100 231.98 1,726.72 2,924.03 - 175.97 94.32% Staff Support 7,715 74.49 2,425.34 4,195.74 - 3,519.26 54.38% Professional Services 2,284 - 2,175.00 2,247.00 - 37.00 98.38% Maintenance Services - - - (200.00) - 200.00 0.00% Operating Equipment 100,000 15,563.83 88,234.41 99,156.83 232.16 611.01 99.39% TOTAL LIBRARY 877,288 95,362.49 795,435.95 843,602.79 232.16 33,453.05 96.19 %d TOTAL CULTURAL 877,288 95,362`.49 795,435.95 843,602.79 232.16 33,453.05 96.19 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES INFORMATION TECHNOLOGY Personnel Services 310,532 32,392.17 287,202.09 302,214.91 - 8,317.09 97.32% Supplies 36,380 3,417.13 28,071.78 33,048.17 - 3,331.83 90.84% City Support Services 2,976 - - 367.91 - 2,608.09 12.36% Utility Services 39,000 8,898.64 34,811.32 37,015.72 - 1,984.28 94.91% Operations Support 1,000 - 609.24 158.50 - 841.50 15.85% Staff Support 10,750 584.77 4,866.16 7,938.56 - 2,811.44 73.85% City Assistance 14,550 1,077.18 14,689.15 15,045.44 - (495.44) 103.41% Professional Services 25,500 1,052.50 21,663.20 21,413.00 - 4,087.00 83.97% Fund Charges /Transfers - - 22,588.00 - - - 0.00% Maintenance Services 54,280 1,069.04 10,453.89 51,283.59 10,530.00 (7,533.59) 113.88% Operating Equipment 16,300 9,890.00 1,640.95 11,689.34 - 4,610.66 71.71% Capital Outlay 86,922 - - 56,060.00 27,870.00 2,992.00 96.56% TOTAL ANIMAL SERVICES ` 598,190 58,381.43 426,595.78 536,235.14 38,400.00 23,554.86 96.06 % TOTAL HEALTH 598,190 58,381.43 426,595.78 536,235.14 38,400:00 23,554.86 96.06 %` INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 462,042 44,681.94 422,231.03 418,565.16 - 43,476.84 90.59% Supplies 3,100 195.50 2,772.16 1,361.03 - 1,738.97 43.90% City Support Services 541,399 11,809.91 526,871.82 432,054.73 44,030.10 65,314.17 87.94% Utility Services 252,402 29,187.64 187,580.97 202,871.35 - 49,530.65 80.38% Operations Support - - 50.00 - - - 0.00% Staff Support 36,608 690.85 27,735.78 36,968.40 - (360.39) 100.98% Maintenance Services 15,600 518.70 11,643.05 14,260.25 79.00 1,260.75 91.92% Rental /Leasing 38,047 283.68 - 35,159.07 - 2,887.93 Operating Equipment 235,308 10,021.87 250,370.42 169,236.16 15,037.38 51,034.45 78.31% TOTAL INFORMATION TECHNOLOGY 1,584,506 97,390.09 1,429,255.23 1,310,476.15 59,146.48 214,883.37 86.44 %i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 286,483 29,357.99 247,575.00 274,662.51 2,000.00 9,820.49 96.57% Supplies 1,000 82.62 788.11 990.24 - 9.76 99.02% Human Services 63,144 6,486.61 118,921.81 50,953.21 4.95 12,185.84 80.70% Operations Support 10,000 874.72 8,013.75 7,920.23 - 2,079.77 79.20% Staff Support 19,356 2,393.79 14,219.51 17,702.57 120.61 1,532.82 92.08% City Assistance 16,100 4,691.00 9,687.75 16,150.00 - (50.00) 100.31% Professional Services 10,320 744.75 8,936.50 10,316.00 - 4.00 99.96% Operating Equipment 1,800 412.04 - 1,775.00 - 25.00 98.61% TOTAL HUMAN RESOURCES 408,203 45,043.52 408,142.43 380,46916 2,125.56 25,607.68 93.73% FINANCE Personnel Services 540,401 58,879.44 490,036.62 525,090.47 - 15,310.73 97.17% Supplies 3,636 - 6,632.98 3,724.03 - (88.23) 102.43% Operations Support 3,000 857.00 1,937.76 3,439.69 - (439.69) 114.66% Staff Support 11,085 1,608.12 7,442.40 11,138.64 - (53.64) 100.48% Professional Sevices 17,000 - - 505.00 - 16,495.00 2.97% Operating Equipment - - 895.86 - - - 0.00% TOTAL FINANCE 575,122 61,344 56 506,945.62 543;897.83 - 31,224.17 94.57 % ' PURCHASING & ASSET MGT Personnel Services 141,242 11,724.55 215,141.60 130,455.53 - 10,786.47 92.36% Supplies 925 3,616.11 (1,081.49) 4,178.37 - (3,253.37) 451.72% City Support Services - - 788.40 - - - 0.00% Utility Services 350 43.03 789.32 252.56 - 97.44 72.16% Operations Support 100 - 95.97 29.10 - 70.90 29.10% Staff Support 6,600 629.49 5,500.27 6,124.27 - 475.73 92.79% City Assistance 2,650 622.00 - 3,111.46 - (461.46) 117.41% Operating Equipment 175 166.72 2,267.17 166.72 - 8.28 95.27% TOTAL PURCHASING & ASSET MGT 152,042 16,801.90 223,501.24 144,318.01 - 7,723.99 94.92 %d CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 312,521 30,381.88 262,044.47 288,892.07 - 23,628.60 92.44% Supplies 138,401 8,800.11 165,611.88 136,213.56 174.93 2,012.59 98.55% City Support Services 3,500 - 2,386.24 2,244.72 - 1,255.28 64.13% Utility Services 6,454 1,176.37 4,478.95 6,158.05 66.95 229.00 96.45% Operations Support 300 22.95 75.03 32.95 - 267.05 10.98% Staff Support 6,114 236.75 5,094.22 5,791.92 - 322.08 94.73% Maintenance Services 148,684 27,016.56 73,518.19 169,777.84 - (21,093.59) 114.19% Rental /Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 8,365.70 7,332.91 17,787.92 - (9,587.92) 216.93% Capital Outlay 93,372 (8,200.00) 58,021.76 80,261.00 - 13,111.00 85.96% TOTAL FLEET SERVICE 717,746 67,800.32 578,563.65 707,160.03 241.88 10,344.09 98.56 % ' BUILDING MAINTENANCE Personnel Services 148,103 15,136.33 121,166.95 150,923.23 - (2,820.23) 101.90% Supplies 1,043 2,053.97 684.23 4,513.10 - (3,470.10) 432.70% Utility Services 2,350 170.75 2,479.92 2,368.05 - (18.05) 100.77% Staff Support 3,420 189.28 1,805.59 3,309.51 - 110.49 96.77% Professional Services 43,785 - 6,777.60 43,784.99 - 0.01 100.00% Maintenance Services 202,842 67,477.18 99,722.55 196,114.25 420.00 6,307.75 96.89% Rental /Leasing 1,400 - 467.00 1,263.27 - 136.73 90.23% Operating Equipment - - 5,160.34 - - - 0.00% Capital Outlay - - 28,694.45 - 8,415.00 (8,415.00) 0.00% TOTAL BUILDING MAINTENANCE ` 402,943 85,027.51 266,958.63 402,276.40 8,835.00 (8,168.40) 102.03 %' TOTAL INTERNAL SERVICE 3,840,562 373,407.90 3,413,366.80 3,488,598.18 70,348.92 281,614.90 92.67% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 REVENUE OVER(UNDER) EXPEND. 668,544 ;1,991,989.33 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 240,847 53,116.70 41,678.00 237,815.70 - 3,031.30 98.74% TOTAL CITY ASSISTANCE 240,847 53,116.70 41,678.00 237,815.70 - 3,031.30 98.74 % ' COURT - RESTRICTED FUNDS Operating Equipment 36,660 1,400.00 - 5,324.25 1,840.00 29,495.75 19.54% TOTAL CITY ASSISTANCE 36,660 1,400.00 - 5,324.25 1,840.00 29,495.75 19.54% TOTAL MISC & PROJECTS 277,507 54,516.70 41,678.00 243,1?39.95 1,840.00 32,527.05 88.28% TOTAL EXPENDITURES 25,890,93125 2,721,694.79 23,439,240.11 24,728,788.16 228,190.01 933,955.08 96.39 %` REVENUE OVER(UNDER) EXPEND. 668,544 ;1,991,989.33 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 10,162,766 8,696.30 9,373,266.24 10,400,371.05 - (237,605.05) 102.34% 000 - 411200 Advalorem Tax - Delinquent 45,000 4,014.27 41,977.19 26,530.54 - 18,469.46 58.96% 000 - 411300 Advalorem Tax - P &I 45,000 2,476.65 47,635.06 50,098.94 - (5,098.94) 111.33% 000 - 411500 Sales Tax Revenue -Gen Fund 7,036,724 733,353.17 6,872,306.22 7,261,388.28 - (224,664.28) 103.19% 000 - 411600 Bingo Tax 100 - 103.13 0.62 - 99.38 0.62% 000 - 411700 Mixed Beverage Tax 46,000.00 - 43,553.02 43,072.48 - 2,927.52 93.64% TOTAL Taxes 17,335,590 748,540.39 16,378,840.86 17,781,461.91 - (445,871.91) 102.57 %< Franchises 000 - 421200 Center Point/Entex Energy 109,857 4,226.29 75,256.23 66,404.93 - 43,452.07 60.45% 000 - 421220 City Public Service 815,953 124,552.26 805,194.07 842,999.91 - (27,046.91) 103.31% 000 - 421240 Guadalupe Valley Elec Co -op 453,465 40,310.98 474,896.76 437,020.92 - 16,444.08 96.37% 000 - 421250 New Braunfels Utilities 56,736 8,678.52 65,197.29 70,398.74 - (13,662.74) 124.08% 000 - 421300 Time Warner -State Franchise 275,193 22,276.44 253,737.49 258,405.26 - 16,787.74 93.90% 000 - 421460 AT &T Franchise Fee 251,861 11,489.33 262,005.25 236,715.80 - 15,145.20 93.99% 000 - 421480 Other Telecom Franchise 125,000 (11,566.35) 96,320.15 103,485.13 - 21,514.87 82.79% 000 - 421500 Solid Waste Franchise Fee 133,088 12,384.84 127,987.29 136,360.02 - (3,272.02) 102.46% TOTAL Franchises 2,221,153 212,352.31 ! 2,160,594.53 2,151,790.71 - 69,362:29 96.88 %' Permits 000 - 431100 Home Occupation Permit 420 - 455.00 595.00 - (175.00) 141.67% 000 - 431205 Building Permit - Residential 567,624 42,246.50 622,847.00 441,467.00 - 126,157.00 77.77% 000 - 431210 Building Permit - Commercial 182,270 14,027.00 100,950.00 150,272.00 - 31,998.00 82.44% 000 - 431215 Building Permit - General 150,000 21,987.00 222,044.00 197,374.00 - (47,374.00) 131.58% 000 - 431300 Mobile Home Permit 525 - 375.00 275.00 - 250.00 52.38% 000 - 431400 Signs Permit 3,500 392.00 9,194.00 6,001.00 - (2,501.00) 171.46% 000 - 431500 Food Establishmnt Permit 56,000 3,585.00 60,325.00 63,475.00 - (7,475.00) 113.35% 000 - 431600 Garage Sale Permit 8,000 1,345.00 11,129.00 11,617.00 - (3,617.00) 145.21% 000 - 431700 Plumbing Permit 105,000 10,415.00 130,984.75 115,876.25 - (10,876.25) 110.36% 000 - 431750 Electrical Permit 51,000 5,280.00 65,895.00 59,080.00 - (8,080.00) 115.84% 000 - 431800 Mechanical Permit 53,000 4,620.00 69,800.00 56,120.00 - (3,120.00) 105.89% 000 - 431900 Solicitor /Peddler Permit 1,200 - 1,620.00 1,170.00 - 30.00 97.50% 000 - 431950 Animal /Pet Permit 1,800 - 1,425.00 1,015.00 - 785.00 56.39% 000 - 432000 Cert. of Occupancy Prmt 6,000 - 7,100.00 6,800.00 - (800.00) 113.33% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 40,000 5,553.87 38,878.75 40,046.87 - (46.87) 100.12% 000 - 432300 Grading /Clearing Permit 3,500 670.00 5,024.80 7,887.02 - (4,387.02) 225.34% 000 - 435000 Fire Permit 20,000 1,275.00 20,953.00 19,320.00 - 680.00 96.60% TOTAL Permits 1,249,839 111!,396.37 ' 1,369,000.30 1,178,391.14 - 71,447.86 94.28 %< Licenses 000 - 441000 Alcohol Beverage License 7,000 435.00 6,365.00 7,505.00 - (505.00) 107.21% 000 - 441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000 - 442000 Contractors License 74,000 3,000.00 68,790.00 44,410.00 - 29,590.00 60.01% 000 - 444000 Pet License 3,000 460.00 3,499.00 3,582.00 - (582.00) 119.40% TOTAL Licenses 84,160 3,895.00 ` 78,814.00 55,657 00 - 28,50100 66.13% Fees 000 - 451000 Municipal Court Fines 1,027,516 74,465.75 1,098,757.58 989,430.14 - 38,085.86 96.29% 000 - 451100 Arrest Fee 34,750 2,438.93 44,502.09 36,255.84 - (1,505.84) 104.33% 000 - 451110 Expunction Fee 60 - 90.00 90.00 - (30.00) 150.00% 000 - 451200 Warrant Fees 150,000 10,060.35 125,724.56 124,364.15 - 25,635.85 82.91% 000 - 451210 Court - Claims & Judgements - 572.00 169.00 72.40 - (72.40) 0.00% 000 - 451340 Judicial Fee - City 5,250 347.31 5,940.80 4,937.54 - 312.46 94.05% 000 - 451400 Traffic Fine Costs TTL 20,000 1,122.57 22,533.55 17,435.23 - 2,564.77 87.18% 000 - 451510 Juvenile Case Mgmt Fee 45,650 2,894.47 49,521.86 41,136.10 - 4,513.90 90.11% 000 - 451520 Truancy Fee 7,225 499.89 8,675.87 7,277.75 (52.75) 100.73% 000 - 451600 Technology Fund Fee 36,660 2,310.47 37,028.33 32,507.45 - 4,152.55 88.67% 000 - 451700 Security Fee 28,250 1,732.83 30,031.77 25,057.05 - 3,192.95 88.70% 000 - 451800 Time Payment Fee - City 5,690 432.79 6,024.01 5,218.85 - 471.15 91.72% 000 - 451850 State Fines 10% Service Fee 64,500 - 60,449.08 50,200.64 - 14,299.36 77.83% 000 - 451900 DPS Payment - Local 7,500 770.39 9,438.60 9,252.75 - (1,752.75) 123.37% 000 - 452000 Child Safety Fee 30,000 324.87 23,126.53 13,637.20 - 16,362.80 45.46% 000 - 452050 Indigent Defense Fee 1,741 - - - - 1,741.00 0.00% 000 - 452100 Platting Fees 57,000 1,500.00 59,500.00 60,500.00 - (3,500.00) 106.14% 000 - 452200 Site Plan Fee 25,000 3,000.00 23,500.00 40,150.00 - (15,150.00) 160.60% 000 - 452300 Plan Check Fee 455,979 37,839.00 471,408.00 391,659.00 - 64,320.00 85.89% 000 - 452310 Miscellaneous Review Fee 600 - 300.00 300.00 - 300.00 50.00% 000 - 452320 Tree Mitigation Admin Fee 10,000 15,180.00 34,162.50 22,462.50 - (12,462.50) 224.63% 000 - 452400 BOA/Zoning Fees 5,000 500.00 6,500.00 3,500.00 - 1,500.00 70.00% 000 - 452500 Food Handler Class - - 8,860.00 - - - 0.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452520 Fire Training Classes 500 - - - - 500.00 0.00% 000 - 452600 Specific Use /Zone Chng Fee 18,000 - 4,150.00 15,300.00 - 2,700.00 85.00% 000 - 452710 Zoning Ltr & Dev Rights 2,400 - 1,500.00 1,500.00 - 900.00 62.50% 000 - 453100 Reinspection Fees 35,000 6,850.00 40,684.00 95,650.00 - (60,650.00) 273.29% 000 - 453110 Swim Pool Inspection Fee 2,000 - 2,530.00 2,530.00 - (530.00) 126.50% 000 - 453200 Lot Abatement 10,000 2,125.00 1,310.00 3,125.17 - 6,874.83 31.25% 000 - 453211 Admin Fee - Inspections 6,600 1,400.00 8,400.00 15,600.00 - (9,000.00) 236.36% 000 - 453310 Misc Inspection Fee - - 150.00 100.00 - (100.00) 0.00% 000 - 453710 Foster Care 1,000 50.00 1,100.00 1,100.00 - (100.00) 110.00% 000 - 454200 Pool Gate Admission Fee 24,750 1,158.05 25,421.75 21,733.85 - 3,016.15 87.81% 000 - 454300 Seasonal Pool Pass Fee 4,900 - 5,932.10 5,280.00 - (380.00) 107.76% 000 - 456110 Senior Center Memberships - - 13,403.60 2,988.00 - (2,988.00) 0.00% 000 - 456120 Senior Center Meal Fee - - 5,905.61 1,265.00 - (1,265.00) 0.00% 000 - 456500 Haz Mat Fees 12,000 - - 2,941.00 - 9,059.00 24.51% 000 - 456600 Fire Re- inspection Fee 1,000 50.00 1,050.00 1,100.00 - (100.00) 110.00% 000 - 458110 Sale of Merchandise- GovDeal 5,000 3,956.02 15,560.75 40,069.21 - (35,069.21) 801.38% 000 - 458300 Sale of Property /Auction 4,000 - 5,108.75 2,194.00 - 1,806.00 54.85% 000 - 458400 Civic Center Rental Fees 159,000 22,417.34 170,685.25 184,530.59 - (25,530.59) 116.06% 000 - 458401 Capital Recovery Fee -Civic Cntr 6,500 1,150.00 10,855.00 11,650.00 - (5,150.00) 179.23% 000 - 458450 North Center Rental Fees 18,500 2,055.72 19,527.00 22,630.72 - (4,130.72) 122.33% 000 - 458460 Senior Center Rental 8,400 700.00 25,842.00 22,012.00 - (13,612.00) 262.05% 000 - 458500 Community Center Rental Fees 24,500 6,240.19 27,961.99 36,529.19 - (12,029.19) 149.10% 000 - 458550 Pavilion Rental Fees 17,370 1,895.00 17,365.04 21,256.00 - (3,886.00) 122.37% 000 - 458560 Chamber of Comm rent 7,800 - 7,800.00 6,050.00 - 1,750.00 77.56% 000 - 458570 Non - Resident SYSA League 3,000 11,870.00 - 11,870.00 - (8,870.00) 395.67% 000 - 458650 NonResident User Fee -BVYA 13,825 - 3,912.00 10,120.00 - 3,705.00 73.20% 000 - 458660 BVYA Utility Reimbursement 8,340 - 5,100.50 10,092.81 - (1,752.81) 121.02% 000 - 458670 SYSA Utility Reimbursement 1,968 - - - - 1,968.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,148 5,016.00 13,352.00 9,704.00 - 4,444.00 68.59% 000 - 458700 Vehicle Impoundment 9,000 - 7,330.00 10,245.90 - (1,245.90) 113.84% 000 - 459200 NSF Check Fee 250 - 75.00 75.00 - 175.00 30.00% 000 - 459300 Notary Fee 250 6.00 198.00 186.00 - 64.00 74.40% 000 - 459400 Maps, Copies, UDC, & Misc F 250 - 85.00 60.00 - 190.00 24.00% 000 - 459600 Animal Adoption Fee 14,000 1,015.00 11,138.01 12,482.89 - 1,517.11 89.16% 000 - 459700 Pet Impoundment Fee 12,000 1,153.50 10,182.00 11,127.80 - 872.20 92.73% 000 - 459800 Police Reports Fee 6,000 456.00 5,493.50 5,577.00 - 423.00 92.95% TOTAL Fees 2,470,622 225,555.44 2,595,352.98 2,474,120.72 - (3,49812) 100.14% CITY O F S C H E R T Z REVENUE REPORT (UNAUDnED) AS OF: SEPTEMBER 30,2016 2U15-2V16 101GENERALqJmo CURRENT CURRENT PRIOR YEAR v-T-D v-T-D BUDGET 75% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000403000 Library Fines 31,000 219754 3001010 2573807 520133 83.03% TOTAL Fines 31,000 2,197.54 30,616.10 25,738.67 - 5,261.33 83.03% 000473100 BnxarCo - Fim 21.072 - 21.077.70 10.25829 - 10.01371 48.08% 000473200 CitynfGoguin - FimConUort 29.231 2.435.90 28.230.80 28.11028 - 1.12072 9017% 000473300 GuodCn'Library 212.000 - 211.954.00 211.854.00 - 40.00 99.88% 000473400 Randolph AFB-Animal Cntd 1.500 800.00 500.00 2.100.00 - (aOO.UO) 140.00% 000474200 Libna,yGorviuos - Qbn|o 30.000 ' 30.000.00 85.000.00 - (5.000.00) 110.07% 000474210 Library Services-Selma 30.544 - 30.544.00 31.540.00 - (996.00) 10326% 000474400 DispatchGomioo - Cibo|o 100.000 40.000.00 100.000.00 100.026.00 - (20.00) 100.02% 000474000 School Crossing Guand'Baxar 40.000 3.383.04 38.80079 87.487.82 - 2.512.18 93J2% 000474010 School Cross Guard-Guadalupe 38.000 3.400.19 38.119.80 38.339.59 (1.339.59) 103.53% 000474620 School Crossing Guand-Como| 1.500 - 1.543.06 1.505.98 - (05.98) 104.40% 000474700 School Officer Funding 170.000 56.006.67 168.33333 184.106.67 - (14.160.67) 10833Y6 000-474750 Crime Victim Liaison Agreement --_-50V000� - 12,500.00 --__50��00.0x0 -----_--- 100/00% TOTAL Inter-Jurisdictional 783,847 106,791.80 742.604.74 79 00.98%� Fund Transfers 000480000 |ndiveutCoots - EMS 150.308 12.525.03 136.086.90 150.307.56 - 0.44 100.00Y6 000480100 Indirect Costs -Hotel/Motel 06^405 06^405.00 00.405.00 00.405.00 - - 100.00Y6 000482200 TmnahypVohio|*Rep|c*mt 241.088 - - - - 241.088.00 0.00'& 000485000 |nt*dundChango-Dminag* 54.150 4.512.50 57.129.90 54.150.00 - - 100.00Y6 000480000 |noydundCh,gea`AdminVY&S 1.152.350 90.029.17 1.152.350.04 1.152.350.00 - - 100.00'& 000486402 Transfer from City Wide Pro ' - ' 22.53 - (22.53) 0.00Y6 000487000 |noedundChungoo-F|eeu 206.965 17.247.08 100.237.00 200.965.00 - - 100.00Y6 000480000 |noodundChangno4B 50.000 4.108.07 96.012.47 50.024.00 - (24.00) 100.05% 000489000 Tmnufor|n _____-_ ______-_ __116,000.00 -_ _____-_ -_ 0.00% TOTAL Fund Transfers 1,921,266 200,888.05 1,804,221 A3 1,680,224.09 - 241,041.91 87.45% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 600 62.25 586.48 787.35 - (187.35) 131.23% 000 - 491200 Investment Income 26,000 6,585.11 31,609.04 74,649.53 - (48,649.53) 287.11% 000 - 491800 Gain /Loss - 141.66 (6,653.61) (27,797.77) - 27,797.77 0.00% 000 - 491900 Unrealized Gain /Loss (15,000) (266.06) (1,194.29) 11,003.24 - (26,003.24) 0.00% 000 - 492100 Proceeds -Sale of Land - - 10,000.00 - - - 0.00% 000 - 493120 Donations - Public Library 2,500 28.65 1,803.85 2,248.63 - 251.37 89.95% 000 - 493400 Donation - Animal Control 1,000 25.00 462.50 211.40 - 788.60 21.14% 000 - 493401 Donations -A/C Microchip 1,000 195.00 1,225.00 1,980.00 - (980.00) 198.00% 000 - 493402 Donations - Spay &Neuter 10,000 847.50 10,502.50 13,654.00 (3,654.00) 136.54% 000 - 493403 Donations - Animal Adoption Trailer - - 10,557.37 2,222.00 - (2,222.00) 0.00% 000 - 493404 Donations -TNR Program - - - 600.00 - (600.00) 0.00% 000 - 493460 Donations -Parks - - 500.00 - - - 0.00% 000 - 493465 Donations - Senior Center - 841.95 9,466.89 9,643.57 - (9,643.57) 0.00% 000 - 493502 Donations -PD - - 500.00 5,299.68 - (5,299.68) 0.00% 000 - 493618 Donations - Veteran's Memorial - - 2,520.00 5,500.67 - (5,500.67) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900 3,878.26 3,850.98 - 49.02 98.74% 000 - 494482 Grants - Police, Fire, Gen Fund 15,000 - - 5,131.63 - 9,868.37 34.21% 000 - 495100 Mobile Stage Rental Fees - 550.00 1,550.00 2,100.00 - (2,100.00) 0.00% 000 - 497000 Misc Income -Gen Fund 36,000 15,974.12 37,221.74 55,367.24 - (19,367.24) 153.80% 000 - 497005 Schertz Magazine Advertising 240,000 16,225.00 274,555.00 196,500.00 - 43,500.00 81.88% 000 - 497100 Misc Income - Police 7,000 2,493.92 6,965.13 18,494.04 - (11,494.04) 264.20% 000 - 497200 Misc Income - Library 5,000 395.75 5,927.90 4,949.91 - 50.09 99.00% 000 - 497210 Misc Income - Library Copier 18,000 1,778.75 19,245.77 20,193.99 - (2,193.99) 112.19% 000 - 497300 Misc Income - Animal Control - 15.00 10.00 400.00 - (400.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 20,000 9,947.19 22,797.98 44,730.45 - (24,730.45) 223.65% 000 - 497500 Misc Income -TML Insurance 20,000 430.00 - 4,088.25 - 15,911.75 20.44% 000 - 497550 Misc Income -TML Reimbursemt 20,000 - 4,585.39 11,828.59 - 8,171.41 59.14% 000 - 497600 Misc Income - Vending Mach. 2,500 212.48 2,584.13 2,317.43 - 182.57 92.70% 000 - 498000 Reimbursmnt -Gen Fund 32,000 - 18,535.27 44,867.09 - (12,867.09) 140.21% 000 - 498100 ReimbursmntFire - Training 1,000 1,657.31 - 6,017.31 - (5,017.31) 601.73% 000 - 498105 Reimburmnt Police - DEA 6,000 665.07 8,044.18 5,637.26 - 362.74 93.95% 000 - 498107 Reimburmnt Police - Event 7,000 - 10,500.00 3,500.00 - 3,500.00 50.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 2,500 5,657.19 17,918.07 51,868.15 - (49,368.15) 2074.73% TOTAL Miscellaneous 462,000 64,462.84 506,204.55 581,844.62 - (119,844.62) 125.94% TOTAL REVENUES 26,559,477 1,676,079.74 25,666,248.89 26,720,777.49 (161,300.49) 100.61% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30,2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 791,546.36 Cash in Investments LOGIC Investment - General Fund 7,135,119.05 LOGIC Investment -Equip Replacement 74,068.58 LOGIC Investment -Veh Replacement 499,427.40 LOGIC Investment -Air Condi Replacment 271,792.36 CAPITAL ONE Investment - General Fund 1,370,179.18 Total Cash in Bank & Investments $10,288,714.77 w,2015-161 OCT 360,300 NOV 303,202 DEC 4,754,503 JAN 3,709,486 FEB 888,174 MAR 211,253 APR 50,559 MAY 54,867 JUN 27,116 JUL 5,863 AUG 10,866 SEP 8,696 2014 -15 - --------- 2013-14 357,436 363,589 356,940 - 538,568 4,463,962 - -- - 3,641,091 2,741,991 2,726,044 1,198,153 -_ 585,058 85,775 __ - - - -- 72,116 44,720 --- - - - - -- - - -- 16,554 25,398 -- - - - - -- 48,791 30,488 - - - - -- 18,572 49,777 - 20,939 14,839 10,460 3,787 - 7,446 112012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,180 2011-121 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 Sales Tax - General Fund $900,000 --- ---- -------- ------------------------------------- ---------------------- ---------------------- % -14.90o $800,000 16-.60/6- - ------ ---- A 22.00/6 33.4% $700,000 - 4.9% $600,000 - -3. 17.1. 7.6% $500,000 - $400,000 $300,000 $200,000 $100,000 $- OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP -2015-16 479,069 1 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 691,061 678,167 ------- - -- - - - - -- --- ------ a-9-2014-15 - ------ 495,499 638,904 505,026 421,339 795,382 450,965 494,050 723,404 465,966 496,241 759,879 508,305 --s-2013-14 481,247 657,271 554,578 416,261 728,443 487,933 541,476 781,057 692,446 448,577 680,332 547,431 2012-13659,150 575,041 474,246 424,191 632,716 415,8294052378 660,648 544,6-75--------563-,636 650,1244872170 - - -------- -- 2011-12 - ------- 428,994 -------- 463,636 ------------------ 339,192 399,061 ------------------ 461,400 365,083 347,395 ------------------ 535,930 398,080 408,851 575,414 440,250 CITY PUBLIC SERVICE $250,000 00,000 50,000 00,000 $2 $1 $1 50,000 $ JUN OCT NOV DEC JAN FEB MAR APR MAY JUL AUG SEP 2015 -16 237,314 183,530 173,336 178,081 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 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 2O15'2O18 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y�-DACTUAL ENCUKdBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 84.200.00 42.880.48 32.882.30 42.889A8 - 41.530.52 50.88% Miscellaneous _47,60000 10.64 3465421 3310854 -_ 14,431.46 69.686 TOTAL REVENUES 131,800.00 42,680A2 67,336.60 75,838.02 - 55,961.98 33.61% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental _10,760J00 3,835�78 928491 383578 -__ 6,924.22 35.65% TOTAL GENERAL GOVERNMENT 10,760.00 3,83578 9,284.91 3,835.78 - 6,924.22 000% CULTURAL Festival ofAngels 15.000.00 - 12.331.93 11.871.69 - 3.128.31 79.14% Employee Appreciation Event 13.000.00 5486 11.15579 4.327.31 8.072.09 3329% National Night Out 290.00 223.73 - 223.73 - 6627 77.15% VVi|enchik Walk for Life 25.000.00 10.780.08 13.925.54 14.513.00 - 10.487.00 58.05% SohortzSwoethoart 35.000.00 1.12077 18.597.34 18.042.74 ' 16.357.20 5320% Hal Baldwin Scholarship 18.750.00 12.304.88 14.255.35 ' 4.404.05 76.03% Other Events --14,0}0J}0 ----_105.14 740827 597823 ----470IK0 —_7,551J,7 46.06% TOTAL CULTURAL 1121,04000 12,284.58 75,783.75 69,812.05 470.00 50,757.95 58.07% TOTAL EXPENDITURES 131,800.00 16,120.36 85,068.66 73,647.83 470.00 57,682.17 56.24% REVENUE OVER(UNDER) EXPEND - 26,559.76 6 2,190.19 __(4700JO CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000 - 481000 Transfer from Reserves 10,000 - - - - 10,000.00 0.00% 000 - 481314 Transfer from Hotel /Motel - - - - - - 0.00% 000 - 486100 Transfer In 9,000 2,995.83 3,301.87 2,995.83 - 6,004.17 33.29% 000 - 486101 Transfer In - General Fund 65,200 39,673.65 29,380.52 39,673.65 - 25,52635 60.85% TOTAL Fund Transfers 84,200 42,669 32,682.39 42,669.48 - 41,530.52 50.68% Miscellaneous 000 - 491200 Investment Income - 10.64 21.67 85.54 - (85.54) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000 - 13,925.54 14,513.00 - 10,487.00 58.05% 000 - 493256 Donations - Police Events 3,000 - 500.00 - - 3,000.00 0.00% 000 - 493455 Proceeds - Festival of Angels - - 255.00 720.00 - (720.00) 0.00% 000 - 493460 Schertz Sweetheart 850 - 850.00 1,240.00 - (390.00) 145.88% 000 - 493621 Hal Baldwin Scholarship 18,750 - 19,102.00 16,360.00 - 2,390.00 87.25% 000 - 497000 Misc Income - - - 250.00 - (250.00) 0.00% TOTAL Miscellaneous 47,600' 10.64 34,654.21 33,168.54 - 14,431.46 69.68%` - TOTAL REVENUES 131,800` 42,680.12 67,336.60 75,838.02 - 55,961.98 57.54% SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 64,104.00 Cash in Investments Texas Class- Special Events 16,891.09 Total Cash in Bank & Investments $ 80,995.09 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 107,000.00 9,689.80 103,148.54 99,024.23 - 7,975.77 92.55% Fund Transfers 145,500.00 - - - - 145,500.00 0.00% Miscellaneous - - 2.00 - - - 0.00% TOTALREVENUES 252,500.00 9,689.80 103,150.54 99,024.23 - 153,475.77 39.22% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 80,668.99 864.99 2,762.70 (3,627.69} 0.00% TOTAL GENERAL GOVERNMENT - - 80,668.99' 864.99 2,762.70 (3,627.69) 0.00% MISC & PROJECTS Projects 252,500.00 - 2,456.36 30,103.49 - 222,396.51 11.92% TOTAL'MISC & PROJECTS 252,500.00 2,456.36' 30,103.49 - 222,396.51 11.92 %`i TOTAL EXPENDITURES 252,500.00 - 83;125.35 30,968.48 2,762.70 21!8,768.82 13.36 %< REVENUE OVER(UNDER) EXPEND - 9,689.80 20,025.19' 68,055.75 (2,762.70) (65,293.05) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 52,000 (11,743.62) 50,747.49 51,681.06 - 318.94 99.39% 000 - 421465 AT &T PEG Fee 55,000 21,433.42 52,401.05 47,343.17 - 7,656.83 86.08% TOTAL Franchises 107,000 9,689.80 103,148.54 99,024.23 - 7,975.77 92.55 %' Fund Transfers 000 - 481000 Transfer In - Reserves 145,500 - - - - 145,500.00 0.00% TOTAL Fund Transfers 145,500 - - - - 145,500.00 0.00% Miscellaneous 000 - 497000 Misc Income - - 2.00 - - - 0.00% TOTAL Miscellaneous - 2.00 - 0.00 %' TOTAL REVENUES 252,500 9;689.80 103,150.54 99,024.23 153,475.77 39.22 %s' PEG FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Cash Balance $ 516,923.07 Total Cash in Bank & Investments $ 516,923.07 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 220,285 (4,676.43) 140,635.80 231,045.29 - (10,760.29) 104.88% Permits 65,000.00 9,879.32 125,917.66 142,025.93 - (77,025.93) 218.50% Fees 17,659,700 1,726,012.49 17,488,824.88 19,167,625.13 - (1,507,925.13) 108.54% Fund Transfers 813,272 183,926.40 321,961.91 303,056.40 - 510,215.60 37.26% Miscellaneous 143,858 2,865,343.33 4,285,878.40 3,026,067.73 - (2,882,209.73) 2103.51% TOTAL REVENUES 18,902,115 4,780,485.11 22,363,218.65 22,869,820.48 - (3,967,705.48) 120.99% NON DEPARTMENTAL Fund Charges /Transfers - 500,000.00 860,041.78 500,000.00 - (500,000.00) 0.00% TOTAL NON DEPARTMENTAL - 500,000 860,041.78 500,000.00 - (500,000.00) 0.00 %> BUSINESS OFFICE Personnel Services 467,483 45,908.87 447,199.73 444,194.73 - 23,288.27 95.02% Supplies 4,600 552.99 3,593.49 3,735.77 25.00 839.23 81.76% Human Services 183 - - 201.00 - (18.00) 109.84% City Support Services 3,035 - 831.00 - - 3,035.00 0.00% Utility Services 700 103.04 269.09 605.71 - 94.29 86.53% Operations Support 139,340 21,715.52 122,109.26 132,036.06 - 7,303.94 94.76% Staff Support 7,300 179.40 2,510.39 4,198.81 43.30 3,057.89 58.11% Professional Services 71,000 23,339.60 76,128.60 114,080.19 - (43,080.19) 160.68% Maintenance Services 12,000 420.00 10,515.00 8,040.00 100.00 3,860.00 67.83% Operating Equipment 1,550 - - - 3,400.40 (1,850.40) 219.38% Capital Outlay 44,000 (44,129.80} - - - 44,000.00 0.00% TOTAL BUSINESS OFFICE 751,191 48,089.62 663,156.56< 707,092.27 3,568.70 40,530.03 94.60% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,295,299 104,750.39 1,174,630.20 1,160,550.56 - 134,748.44 89.60% Supplies 187,150 (9,152.15) 146,304.27 142,878.54 20.79 44,250.67 76.36% Human Services 1,000 80.00 476.00 362.00 - 638.00 36.20% City Support Services 59,900 231.35 50,548.95 47,470.33 - 12,429.67 79.25% Utility Services 3,366,500 266,412.77 3,310,621.53 3,221,941.26 - 144,558.74 95.71% Operations Support 6,545 1,424.02 14,746.85 7,209.01 - (664.01) 110.15% Staff Support 33,850 1,763.45 21,539.34 28,234.23 - 5,615.77 83.41% City Assistance 1,900 198.00 1,206.00 1,598.00 - 302.00 84.11% Professional Services 183,838 38,231.67 207,795.46 192,497.53 - (8,659.53) 104.71% Fund Charges /Transfers 3,856,374 2,492,861.18 4,902,724.95 6,086,078.91 - (2,229,704.91) 157.82% Maintenance Services 7,098,115 1,139,330.67 6,765,804.93 7,563,245.56 5,477.07 (470,607.63) 106.63% Other Costs 35,000 - 31,030.20 27,260.20 - 7,739.80 77.89% Debt Service 1,453,258 (1,063,880.25) 416,973.89 389,333.17 - 1,063,924.83 26.79% Rental- Leasing 6,070 - 3,168.21 2,623.19 - 3,446.81 43.22% Operating Equipment 8,000 6,954.43 24,153.35 6,954.43 399.98 645.59 91.93% Capital Outlay 11,881 (43,968.57) - - - 11,881.00 0.00% TOTAL PUBLIC WORKS 17,604,680 2,935,236.96 ;17,071;724.13'; 18,878,236.92 5,897.84 (1,279,454.76) ;i 107.27% PROJECTS Fund Charges /Transfers 500,000 - 85,186.10 - - 500,000.00 0.00% TOTAL PROJECTS 500,000 - 85,186.10': - - 500,000.00 0.00% TOTAL MISC & PROJECTS 500,000 - 85,186.10 - - 500,000.00 0.00 %' TOTAL EXPENDITURES 18,855,871 3,483,326.58 18,680,108.57! 20,085,329.19 9,466.54 (1,238,924.73} 106.57% ** REVENUE OVER(UNDER)EXPENSES ** 46,244 1,297,158.53 3,683,110.08 2,784,491.29 (9,466'.54) (2,72$,780.75} 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 220,285 (4,676.43} 140,635.80 231,045.29 - (10,760.29) 104.88% TOTAL Franchises 220,285 (4,676.43) 140,635:80 231,045.29 - (10,760.29) 104.88 %' Permits 000 - 432400 Development Permit 65,000 9,879.32 125,917.66 142,025.93 - (77,025.93) 218.50% TOTAL Permits 65,000< 9,879.32 1`25,917.66 142,025.93 - (77,025.93) 218.50% Fees 000 - 455200 Garbage Collection Fee 4,150,000 391,451.13 4,138,255.61 4,433,299.14 - (283,299.14) 106.83% 000 - 455600 Fire Line Fees 25,700 - 25,630.00 27,025.00 - (1,325.00) 105.16% 000 - 455700 Recycle Fee Revenue 275,000 25,336.27 273,222.12 286,555.55 - (11,555.55) 104.20% 000 - 455800 W &S Line Constructn Reimbursemnt 25,000 2,192.00 27,108.00 34,456.87 - (9,456.87) 137.83% 000 - 457100 Sale of Water 8,180,000 781,525.77 7,943,694.77 8,543,050.14 - (363,050.14) 104.44% 000 - 457110 Edwards Water Lease 97,000 - 141,773.50 81,975.30 - 15,024.70 84.51% 000 - 457120 Water Transfer Charge -Selma 42,000 - 31,445.57 59,050.34 - (17,050.34) 140.60% 000 - 457130 Water Transfer Charge -U. C. 10,000 - 4,911.69 203.11 - 9,796.89 2.03% 000 - 457140 Water Transfer Charge- Converse 30,000 - 28,782.36 13,527.69 - 16,472.31 45.09% 000 - 457200 Sale of Meters 90,000 6,888.00 88,659.02 71,157.35 - 18,842.65 79.06% 000 - 457400 Sewer Charges 4,532,000 499,059.46 4,567,851.37 5,394,426.63 - (862,426.63) 119.03% 000 - 457500 Water Penalties 200,000 19,284.86 212,187.74 220,198.01 - (20,198.01) 110.10% 000 - 458110 Sale of Merchandise - Gov Deals - - 1,478.13 - - - 0.00% 000 - 458300 Sale of Property /Auction 500 - 1,575.00 - - 500.00 0.00% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 275.00 2,250.00 2,700.00 - (200.00) 108.00% TOTAL Fees 17,659,700 1,726,012.49 17,488,824.88 19,167,625.13 - (1,507,925.13) 108.54% % Fund Transfers 000 - 481000 Transfer In- Reserve 500,000 - - - - 500,000.00 0.00% 000 - 486100 Transfer In - 33,784.40 45,536.95 33,784.40 - (33,784.40) 0.00% 000 - 486103 Transfer In- Vehicle Reserves 44,000 - - - - 44,000.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 129,960 10,830.00 137,112.96 129,960.00 - - 100.00% 000 - 486411 Transfer In- Capital Recovery 139,312 139,312.00 139,312.00 139,312.00 - - 100.00% TOTAL Fund Transfers 813,272 183,926.40 321,961:91 303,056.40 - 510,2115.60 37.26 %? 202 -WATER & SEWER REVENUES Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 490000 Misc Charges 500 - 536.00 623.00 - (123.00) 124.60% 000 - 491000 Interest Earned 1,500 253.25 1,107.28 1,012.72 - 487.28 67.51 % 000 - 491200 Investment Income 5,000 2,232.69 11,041.58 19,468.01 - (14,468.01) 389.36% 000 - 495013 Capital Contribution - W &S - 2,831,126.27 4,133,552.35 2,831,126.27 - (2,831,126.27) 0.00% 000 - 497000 Misc Income -W &S 15,000 31,731.12 22,591.43 54,831.11 - (39,831.11) 365.54% 000 - 498110 Reimbursement -SSLGC 121,858 - 117,049.76 115,136.87 - 6,721.13 94.48% 000 - 498200 Reimbursement- W &S Project - - - 3,869.75 - (3,869.75) 0.00% TOTAL Miscellaneous `- 143,858 2,865,343.33 4,285,878.40 3,026,067.73 - (2,882,209.73) 2103.51 %i TOTAL REVENUES 18,902,115 4,780,485.11 22,363,218.65 22,869,820.48 - (3,967,705.48) 120.99% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 829,140.09 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 Schertz Bank & Trust - Certificate of Deposit 2,481,586.30 297,134.07 178,650.96 258,077.57 1,082,969.18 $ 4,298,418.08 Total Cash in Bank & Investments $ 5,127,558.17 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 2 0 1 5- 2 0 1 6 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Fees 5,866,640 435,970.79 5,730,758.02 5,569,980 - 296,660 94.94% Inter-Jurisdictional 1,742,807 - 1,596,475 1,757,826 - (15,019) 100.86% Miscellaneous 300,347 12,764 80,912 169,045 - 131,302 56.28% TOTAL REVENUES 7,909,794 448,734.66 7,408,145.12 7,496,85136 - 412,942.64 94.78% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,479,251 395,148.04 3,335,907.73 3,462,736.42 - 16,514.58 99.53% Supplies 430,731 102,505.64 274,320.99 422,423.71 8,307.29 98.07% Human Services 1,000 - 1,151.50 362.50 - 637.50 36.25% City Support Services 18,450 1,000.00 24,149.51 17,854.03 - 595.97 96.77% Utility Services 136,653 15,571.28 109,411.15 92,081 .75 - 44,571.25 67.38% Operations Support 102,335 7,875.78 101,238.13 67,940.79 39.17 34,355.04 66.43% Staff Support 86,192 3,224.93 74,756.52 63,604.06 970.40 21,617.54 74.92% City Assistance 13,400 338.00 12,188.73 7,873.72 - 5,526.28 58.76% Professional Services 117,000 7,175.01 115,567.65 96,314.95 - 20,685.05 82.32% Fund Charges/Transfers 2,616,485 90,518.40 3,357,132.47 1,969,400.69 - 647,084.31 75.27% Maintenance Services 67,380 1,720.00 30,990.05 27,759.37 - 39,620.63 41.20% Debt Service 205,498 (190,686.00) 13,414.62 14,782.11 - 190,715.89 7.19% Rental-Leasing 81,541 5,795.07 579.55 69,540.84 - 12,000.16 85.28% Operating Equipment 152,811 13,461.00 177,371.10 68,024.86 - 84,786.36 44.52% Capital Outlay 218,221 (906,454.78 ) - - - - 218,220.78 0.00% TOTAL PUBLIC SAFETY 7,726,948 (452,807.63 ) 7,628,179.70 6,380,699.80 1,009.57 1,345,238.63 82.59% TOTAL EXPENDITURES 7,726,948 (452,807.63) 7,628,179.70 6,380,699.80 1,009.57 1,345,238.63 82.59% '- REVENUE OVER(UNDER) EXPENSES - 182,846 901,542 (220,035) 1,116,152 (1,019) (932,296) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,717,640 418,614.37 5,548,261.88 5,366,058.75 - 351,581.25 93.85% 000 - 456110 Subscription Program Fees 40,000 145.00 26,410.00 28,340.00 - 11,660.00 70.85% 000 - 456120 EMT Class - Fees 87,000 15,435.00 130,121.92 142,924.47 - (55,924.47) 164.28% 000 - 456130 Immunization Fees - 84.00 1,156.00 8,448.00 - (8,448.00) 0.00% 000 - 456140 Billing Fees - Alamo Heights 22,000 1,667.42 20,715.72 20,196.58 - 1,803.42 91.80% 000 - 458110 Sales of Merchandise - GovDeal - Schertz Support 4,092.50 3,937.50 - (3,937.50) 0.00% 000 - 459200 NSF Check Fee - 25.00 - 75.00 - (75.00) 0.00% TOTAL Fees 5,866,640 435,970.79 5,730,758.02 5,569,980.30 296,659.70 94.94 %' Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 294,710 - 241,719.90 355,104.90 - (60,394.90) 120.49% 000 - 474300 Cibolo Support 269,225 - 261,393.00 269,225.00 - - 100.00% 000 - 475100 Comal Co ESD #6 98,079 - 92,859.60 95,550.00 - 2,529.00 97.42% 000 - 475200 Live Oak Support 202,826 - 189,570.00 202,715.84 - 110.16 99.95% 000 - 475300 Universal City Support 254,788 - 247,375.52 254,787.52 - 0.48 100.00% 000 - 475400 Selma Support 104,528 - 73,959.00 76,175.00 - 28,353.00 72.88% 000 - 475500 Schertz Support 494,024 - 465,688.04 479,641.24 - 14,382.76 97.09% 000 - 475600 Santa Clara Support 9,969 - 9,678.76 9,968.76 - 0.24 100.00% 000 - 475800 Marion Support 14,658 - 14,231.12 14,657.52 - 0.48 100.00% TOTAL Inter - Jurisdictional 1,742,807 - 1,596,474.94 1,757,825.78 - (15,019) 100.86% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30,2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 100 5.12 93.80 98.65 - 1.35 98.65% 000 - 491200 Investment Income 750 56.10 920.41 715.24 - 34.76 95.37% 000 - 493203 Donations -EMS 2,000 1.00 780.00 559.15 - 1,440.85 27.96% 000 - 493205 Donations- Golf Tournament 9,000 - 7,380.00 11,485.00 - (2,485.00) 127.61% 000 - 495100 UH Grant Program 168,497 - - - - 168,497.00 0.00% 000 - 497000 Misc Income 110,000 11,812.72 60,947.89 146,007.25 - (36,007.25) 132.73% 000 - 497100 Recovery of Bad Debt 10,000 888.93 10,740.06 10,179.99 - (179.99) 101.80% 000 - 498300 Reimbursement- City Property - - 50.00 - - - 0.00% TOTAL Miscellaneous 300,347 12,763.87 80,912.16 169,04528 131,301.72 56.28% TOTAL REVENUES 8,097,999 496,387.02 7,458,891.41 8,360,982.72 5,831.00 (268,814.72) 103.32% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30,2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 22,720.25 Cash in Investments Texas Class- Tax Note 2015 Ambulances 89,103.41 Total Cash in <Bank & Investments $ 111,823.66 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 471,053 44,319.25 454,909.27 414,974.62 56,078.38 Permits 3,000 280.00 3,120.00 2,820.00 - 180.00 94.00% Fees 1,083,000 98,313.26 1,084,176.02 1,123,418.25 - (40,418.25) 103.73% Fund Transfers 213,920 202,033 - 202,033.35 - 11,886.65 94.44% Miscellaneous 80,700 893.86 27,337.44 7,298.06 - 73,401.94 9.04% TOTAL REVENUES 1,380,620 301,520.47 ; 1,114,633.46 1,335,569.66 - 45,050.34 ` 96.74 % 01-1111111 A. Personnel Services 471,053 44,319.25 454,909.27 414,974.62 56,078.38 8810% Supplies 8,300 2,264.59 5,577.23 5,406.75 199.75 2,693.50 67.55% Human Services 325 167.00 - 167.00 - 158.00 51.38% City Support Services 28,500 6,662.96 4,250.66 9,366.91 - 19,133.09 32.87% Utility Services 30,370 2,636.90 17,513.46 13,886.51 - 16,483.49 45.72% Operations Support 2,460 - 82.29 - - 2,460.00 0.00% Staff Support 8,116 1,504.27 4,808.83 6,439.71 129.30 1,546.99 80.94% City Assistance 840 - - 120.00 - 720.00 14.29% Professional Services 24,500 25,920.00 20,186.82 43,920.00 - (19,420.00) 179.27% Fund Charges /Transfers 215,573 156,911.90 278,998.14 353,603.82 - (138,030.82) 164.03% Maintenance Services 21,000 2,535.58 16,257.90 24,902.02 - (3,902.02) 118.58% Other costs 200 - 100.00 100.00 - 100.00 50.00% Debt Service 135,294 (123,023.87) 11,136.91 12,249.94 - 123,044.06 9.05% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 6,684.72 4,182.65 11,491.70 - (5,991.70) 208.94% Capital Outlay 54,500 (50,063.72) - - - 54,500.00 0.00% TOTAL DRAINAGE 1,007,031 76,519.58 818,004.16 896,628.98 329.05 ; 110;072.97 89.07% PROJECTS Professional Services - - - - 8,000.00 (8,000.00) 0.00% Maintenance Services 213,920 (13.59) - - - 213,920.00 0.00% Capital Outlay - (33,713.59) - - - - 0.00% TOTAL PROJECTS 213,920 (33,727.18); - - 8,000.00 205 920.00 174% TOTAL EXPENDITURES 1,220,951 42,792.40 81`8,004.16 896,628.98 8,329.05 < 315,992.97 74.121 " REVENUE OVER(UNDER) EXPEND 159,669 438,940.68 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 k******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000 280.00 3,120.00 2,820.00 - 180.00 94.00% TOTAL Permits '` 3,000 280.00 3,120.00 2,820.00 - 180.00 94.00% Fees 000 - 457500 Drainage Penalties 8,000 685.54 9,762.08 9,288.93 - (1,288.93) 116.11% 000 - 457600 Drainage Fee 1,075,000 97,627.72 1,074,413.94 1,114,129.32 - (39,129.32) 103.64% TOTAL Fees 1,083,000 98,313.26 1,084,176.02 1,123,418.25 - (40,418.25) 103.73 %' Fund Transfers 000 - 481000 Transfer In 213,920 202,033.35 - 202,033.35 - 11,886.65 94.44% TOTAL Funds Transfers 213,920 202,033.35 - 202,033.35 - 11,887 94.44% Miscellaneous 000 - 491000 Interest Earned 100 6.56 215.23 81.65 - 18.35 81.65% 000 - 491200 Investment Interest 500 887.30 1,755.19 7,216.41 - (6,716.41) 1443.28% 000 - 493204 Donations- Drainage Project 80,000 - 25,000.00 - 80,000.00 0.00% 000 - 497000 Misc Income - Drainage 100 - 367.02 - - 100.00 0.00% TOTAL Miscellaneous 80,700 893.86 27,337.44 7,298.06 - 73,401.94 9.04 %? TOTAL REVENUES 1,380,620 301,520.47 1,114,633.46 1,335,569.66 - 45,050.34 96.74 %`i DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool- Checking 140,442.25 Cash in Investments Lone Star Investment - Drainage Maint Fund 810,561.00 Total Cash in Bank & Investments $ 951,003.25 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30TH, 2016 2 0 1 5 - 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I: ajok,l1J�al�J�i►� /e1:�'1 Taxes 592,707 42,347.84 563,733.79 544,870.68 - 472,361.60 91.93% Miscellaneous 570 643.32 647.24 3,954.40 - 207.41 693.75% TOTAL REVENUES 593,277 42,991.16 564,381.03 548,825.08 - 472,569.01 92.51% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 65,500 14,966.66 59,575.74 66,218.66 - (718.66) 101.10% Operations Support 66,425 18,881.76 32,757.71 36,552.00 - 29,873.00 55.03% Professional Services 3,000 - 3,000.00 3,000.00 - - 100.00% Fund Charges /Transfers 114,405 114,405.00 109,905.00 114,405.00 - - 100.00% Maintenance Services 10,000 - - 5,555.00 - 4,445.00 55.55% Operating Equipment - - 9,772.24 2,000.00 (1,176.40} (823.60) 0.00% TOTAL NONDEPARTMENTAL 259,330 148,253.42 215,010.69 227,730.66 (1,176.40) 32,775.74 87.36% TOTAL EXPENDITURES 259,330 148,253.42 215,010.69 227,730.66 (1,176.40) 32,775.74 87.36 %' REVENUE OVER(UNDER)> EXPENDITURE 333,947 321,094.42 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30TH, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 149,523.31 Cash in Investments Texas Class - Hotel Tax 1,053,480.18 Total Cash in Bank & Investments $ 1,203,003.49 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 - - -- - - -- - -- _ - -- - 2015 -16 40,800 ------------ --- - ------------ 40,351 -- - - - - -- - - - - - -- 38,394 --- - - - - -- - - - - - -- 34,516 -- - - - - -- - - - - - -- - - - - -- - -- - - - - - -- ----------------------- - - - - -- 39,732 54,142 49,741 45,524 -- - - - - -- -- - - - - -- 51,636 --- - - - - -- -- - - - - -- 68,491 - - - - - -- - - - - - -- - - - - - -- ---- - - - - -1 48,302 33,241 2014 -15 44,724 42,229 35,309 33,055 462037 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 201213 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 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2016 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 111,129 2,000.00 92,000.00 132,000.00 - (20,871.00) 118.78% Miscellaneous 100 178.31 106.23 1,598.06 - (1,498.06) 1598.06% TOTAL REVENUES 111,229 2,178.31 92,106.23 133,598.06 - (22,369.06) 120.11 °poi EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges /Transfers - - 33,158.60 - - - 0.00% Operating Equipment 14,800 (603.50) 6,037.81 146.50 - 14,653.50 0.99% Capital Outlay 20,000 - 10,930.00 22,857.00 7,184.49 (10,041.49) 150.21% TOTAL PARKLAND DEDICATION 34,800 (603.50) 50,126.41 23,003.50 7,184.49 4,612.01 86.75% TOTAL EXPENDITURES 34,800 (603.50) 50,126.41 23,003.50 7,184.49 4,612.011 86.75% REVENUE OVER(UNDER) EXPEND 76,429 110,594.56 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2016 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 111,129 2,000.00 92,000.00 132,000.00 - (20,871.00) 118.78% TOTAL Fees 111,129 2,000.00 92,000,00 132,000.00 (20,871.00) 118.78 %? Miscellaneous 000 - 491000 Interest Earned 75 2.84 94.23 113.74 - (38.74) 151.65% 000 - 491200 Investment Interest 25 175.47 12.00 614.20 - (589.20) 2456.80% 000 - 497000 Misc Income - - - 870.12 - (870.12) 0.00% TOTAL Miscellaneous 100 178.31 106.23 1,598.06 ' (1,498:06) 1598.06% TOTAL REVENUES 111,229 2,178.31 92,106.23 133,598.06 - (22,369.06) 120.11% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $17,750.87 Cash in Investments Texas Class- Park Fund 326,970.79 Total Cash in Bank & Investments $344,721.66 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 40,000 86,020.00 191,487.50 127,287.50 - (87,287.50) 318.22% Fund Transfers 5,000 - - - - 5,000.00 0.00% Miscellaneous 250 141.09 439.77 1,514.97 - (1,264.97) 605.99% TOTAL REVENUES 45,250 86,161.09 191,927.27 128,802.47 - (83,552.47) 284.65% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 32,000 - 219,984.39 119,564.00 - (87,564.00) 373.64% TOTAL TREE MITIGATION 32,000 - 219,984.39 > 119,564.00 - (87,564.00) 373.64 %> TOTAL EXPENDITURES 32,000 - 219,984.39 ? 119,564.00 - (87,564.00) 373.64 %? REVENUE OVER(UNDER) EXPEND 13,250 86,161.09 (28,057.12); 9,238.47 4,011.53 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 t********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 40,000 86,020.00 191,487.50 127,287.50 - (87,287.50) 318.22% TOTAL Fees 40,000 86,020.00 191,487.50 127,287.50 (87,287.50) 318.22% Fund Transfers 000 - 481000 Transfer In -Reserves 5,000 - - - - 5,000.00 0.00% TOTAL Fund Transfers 5,000 - - - - 5,000.00 0.00% Miscellaneous 000 - 491000 Interest Earned 150 1.36 133.64 25.61 - 124.39 17.07% 000 - 491200 Investment Interest 100 139.73 306.13 1,48936 - (1,389.36) 1489.36% TOTAL Miscellaneous 250 141.09 439.77 1,514.97 - (1,264.97) 605.99 %' TOTAL REVENUES 45,250 86,161.09 191,927.27 128,802.47 - (83,552.47) 284.65% TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $26,423.09 Cash in Investments MBIA Investment -Tree Mitigation 299,144.92 Total Cash in Bank & Investments $325,568.01 CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 2U15'2O1G 411 -CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL Y�-DACTUAL ENCUKdBR BALANCE BUDGE[ REVENUE SUMMARY Fees 020,000 98�89.00 1.193.728.30 852,08100 - (32.08100) 10.49% Fund Transfers 2.550.541 - - - - 2.550.541.00 0.00% Miscellaneous 6,600 3^352.5K0 864931 2498730 -__ (18,3673X9) 378^29% TOTA ' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 Professional Services 108.000 FundChargoo/Trandbm Maintenance Services 1,000 1.O0O�00 3,579.00 - - 5,000.00 0.00% 105.000.00 0.94% 0,00% TOTAL NON DEPARTMENTAL 112,000 4,579.00 1,000.00 111,000.00 0.89% PROJECTS Professional Services FundChergoo/Transfem Capital Outlay 315.141 - - - 3,050,000 3,050,000.00 85.186.10 3416.594.84 180.73271 128,408.29 59.25% - (360.594.84) 112.02% 500.00 0.00% TOTAL MISC & PROJECTS 3,365,141 3,049,500.00 85,186.10 3,416,094.84 186,732.71 _(g3T,686.5j5 107.06% TOTAL EXPENDITURES 3,477,141 3,049,500.00 89,765.10 3,417,094.84 186,732.71 __(I_? �,686.55 103.64% REVENUE OVER(UNDER) EXPENDITURES (2,947,858.f�Oj 1,110,612.51 (2,440,044A5j _(jq�,7�3271 2,626,777.16 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 920,000 98,289.00 1,193,728.30 952,083.00 - (32,083.00) 103.49% TOTAL Fees 920,000 ; 98,289.00 1,193,728.30 952,083.00 - (32,08100) 103.49 % ' Fund Transfers 000 - 481000 Transfer from Reserves 2,550,541 - - - - 2,550,541.00 0.00% TOTAL Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00 % ` Miscellaneous 000 - 491000 Interest Earned 600 14.61 676.45 501.80 - 98.20 83.63% 000 - 491200 Investment Income 6,000 3,337.89 5,972.86 24,465.59 - (18,465.59} 407.76% TOTAL Miscellaneous 6,600 3,352.50 6,649.31 24,967.39 - (18,367.39) 378.29% TOTAL REVENUES 3,477,141 101,641.50 1,200,377.61 977,050.39 - 2,500,090.61 28.10 % CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 401,045.08 Cash in Investments Lone Star Investment-Capital Recovery Water 2,973,470.53 Total Cash in Bank & Investments $ 3,374,515.61 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000 57,662.76 632,660.88 508,336.65 - 41,663.35 92.42% Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00% Miscellaneous 16,000 3,935.41 20,725.50 31,238.95 - (15,238.95) 195.24% TOTAL REVENUES 3,643 712 61,598.17 653,386.38 539,57560 - 3,104,136.40 14.81 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84,000 36152 5,309.16 5,339.50 - 78,660.50 6.36% Fund Charges /Transfers 139,312 139,312.00 139,312.00 139,312.00 - - 100.00% Maintenance Services 320,400 - - - - 320,400.00 0.00% TOTAL NON DEPARTMENTAL 543,712 139,675.52 144,621.16 144,651.50 - 399,060.50 26.60 %' MISC & PROJECTS Professional Services 100,000 - - - - 100,000.00 0.00% Sewer Projects 3,000,000 - - - - 3,000,000.00 0.00% TOTAL MISC &PROJECTS 3,100,000 - - - - 3,100,000.00 0.00% TOTAL EXPENDITURES 3,643,712 139,675.52 144,621.16 144,651.50 - 3,499,060.50 3.97 %'' REVENUE OVER(UNDER) EXPENDITURES - (78,077.35) 508,765.22'' 394,924.10 - CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 500,000 57,662.76 632,660.88 466,936.65 - 33,063.35 93.39% 000 - 455913 Cap Recovery -North Sewer Tr 50,000 1,800.00 77,400.00 41,400.00 - 8,600.00 82.80% TOTAL Fees 550,000 59,46276 710,060.88 508,336.65 - 41,66335 92.42 %p> Fund Transfers 000 - 481000 Transfer from Reserves 3,077,712 - - - - 3,077,712.00 0.00% TOTAL Fund Transfers 3,077,712 - - - 3,077,712.00 0.00% Miscellaneous 000 - 491000 Interest Earned 1,000 9.13 422.58 341.42 - 658.58 34.14% 000 - 491200 Investment Income 15,000 3,992.09 31,361.16 45,367.81 - (30,367.81) 302.45% 000 - 491800 Gain /Loss - 135.96 (14,934.77) (35,245.19) - 35,245.19 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (201.77) 3,876.53 20,774.91 - (20,774.91) 0.00% TOTAL Miscellaneous 1!6,000 3,935.41 20,725.50 31,238.95 - (15,238.95) 195.24 %{ TOTAL REVENUES 3,643,712 63,398.17 ' 730,786.38 539,575'.60 - 3,104,136.40 14.81 % ' CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 107,739.47 Cash in Investments Lone Star Investment-Capital Recovery Sewer 2,965,821.81 Capital One-investment 1,754,763.15 Total Cash in Bank & Investments $ 4,828,324.43 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,722,162 8,558.92 5,415,058.64 5,810,724.11 - (88,562.11) 101.55% Miscellaneous 369,213 26,560.51 369,763.47 4,575,557.32 - (4,206,344.32) 1239.27% TOTAL REVENUES 6,091,375 35,119.43 5,784,822.11 10,386,281.43' - (4,294,906.43) 170.51 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 - 3,150.00 84,77423 - 17,725.77 82.71% Debt Service 5,718,918 - 5,559,928.85 5,616,398.20 - 102,519.80 98.21% Other Financing Sources - - - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL GENERAL GOVERNMENT 5,821,418 - 5,563,078.85 9,921,881.81 ? - (4,100,463.81) 170.44% TOTAL EXPENDITURES 5,821,418 5,563,078.85 9,921,881.81 ' - (4,100,463.81) 170.44 %':' " REVENUE OVER(UNDER) EXPEND 269,957 464;399.62 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 5,722,162 8,558.92 5,415,058.64 5,810,724.11 - (88,562.11) 101.55% TOTAL Taxes 5,722,162 8,558:92 5,415,058.64 5,810,724.11 - (88,562.11) 101.55% Miscellaneous 000 - 491000 Interest Earned 75 1.51 23.02 257.99 - (182.99) 34199% 000 - 491200 Investment Earnings 2,000 26,559.00 2,552.45 34,180.58 - (32,180.58) 1709.03% 000 - 495015 Contribution from SED 367,138 - 367,188.00 356,118.75 - 11,019.25 97.00% 000 - 498000 Proceeds From Refunding Dek - - - 4,185,000.00 - (4,185,000.00) 0.00% TOTAL Miscellaneous 369,213 26,560.51 369,763.47 4,575,557.32 - (4,206,344.32) 1239.27 %0 TOTAL REVENUES 6,091,375 35,119:43 5,784,822.11 10,386,281.43 - (4,294,906.43) 170.51% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500 - 3,150.00 2,550.00 - (50.00) 102.00% 101 - 541502 Cost of Bond Issuance 100,000 - - 82,224.23 - 17,775.77 82.22% TOTAL Professional Services 102,500 3,150.00 84,774.23 - 17,725.77 82.71% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principa 275,000 - 265,000.00 275,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 55,425 - 33,750.00 55,425.00 - - 100.00% 101 - 555626 LS &D SR2006- Principal 400,000 - 350,000.00 394,772.50 - 5,227.50 98.69% 101 - 555626.1 LS &D SR2006- Interest 189,419 - 200,451.31 0.01 - 189,418.99 0.00% 101 - 555628 CO Bond 2007 - Principal 122,800 - 116,133.33 122,800.00 - - 100.00% 101 - 555628.1 CO Bond 2007 - Interest 4,925 - 9,581.22 4,923.89 - 1.11 99.98% 101 - 555629 GO Bond 2007 - Principal 265,000 - 255,000.00 264,944.60 - 55.40 99.98% 101 - 555629.1 GO Bond 2007 - Interest 159,036 - 169,367.15 158,975.33 - 60.67 99.96% 101 - 555630 GO Bond SR2008 Principal 440,000 - 420,000.00 440,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 296,946 - 314,706.00 296,947.00 - (1.00) 100.00% 101 - 555631 GO Bond SR2009 Principal 540,000 - 535,000.00 540,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 282,675 - 298,800.00 282,675.00 - - 100.00% 101 - 555633 GO SR2011 Principal 225,000 - 220,000.00 225,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 341,663 - 349,437.50 341,662.50 - 0.50 100.00% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 101 - 555634 GO SR2011A Refund Principal 605,000 - 610,000.00 605,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 116,675 - 130,632.10 116,596.44 - 78.56 99.93% 101 - 555635 GO SR2012 Principal 310,000 - 295,000.00 310,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 194,721 - 206,443.13 194,721.25 - (0.25) 100.00% 101 - 555636 Tax Note - SR2013 - Principal 170,000 - 165,000.00 170,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 5,950 - 7,542.50 5,950.00 - - 100.00% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 - 160,000.00 160,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 5,265 - 7,345.00 5,265.01 - (0.01) 100.00% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000 - 50,000.00 100,000.00 - - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 294,275 - 358,321.94 294,275.00 - - 100.00% 101 - 555639 Tax Note - SR2015 - Principal 35,000 - 30,000.00 35,000.00 - - 100.00% 101 - 555639.1 Tax Note - SR2015 - Interest 3,763 2,417.67 3,756.42 - 6.58 99.83% 101 - 555640 Bond -Ref 2015 Bond- Principal - - - 80,000.00 - (80,000.00) 0.00% 101 - 555640.1 Bond -GO Ref 2015- Interest - - - 80,368.75 - (80,368.75) 0.00% 101 - 555641 Tax Note - SR2015A- Principal - - - 125,000.00 - (125,000.00) 0.00% 101 - 555641.1 Tax Note - SR2015A- Interest - - - 10,995.60 - (10,995.60) 0.00% 101 - 555900 Debt Service 120,380 - - - - 120,380.00 0.00% 101 - 555800 Bond Premium - - - (83,656.10) - 83,656.10 0.00% TOTAL Debt Service 5,718,918 - 5,559,928.85 5,616,398.20 - 102,519.80 98.21% Other Financing Sources 101 - 556300 Payment to Refund Debt - - - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL Other Financing Sources - - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL EXPENDITURES 5,821;418 - 5,563,078.85 9,921,881.81 - 120,245.57 170.44 %' TAX I&S CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 37,716.84 Cash in Investments IVIBIA Investment- Tax I&S 1,273,860.04 Total Cash in Bank & Investments $ 1,311,576.88 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 75% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,518,362 396,082.00 3,442,819.12 3,660,101.11 - (141,739.11) 104.03% Miscellaneous 10,200 11,555.14 15,939.40 52,546.54 - (42,346.54) 515.16% TOTAL REVENUES 3,528,562 407,637.14 3,458,758.52 ? 3,712,647.65 - (184,085.65) 105.22% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 325,458 21,086.04 187,613.83 253,099.89 - 72,358.11 77.77% Supplies 750 - 632.13 122.83 133.96 493.21 34.24% Human Services 1,000 - 135.00 44.44 - 955.56 4.44% City Support Services 12,545 61.37 1,753.09 2,225.71 - 10,319.29 17.74% Utility Services 4,820 578.14 1,201.97 2,631.20 - 2,188.80 54.59% Operations Support 139,572 7,130.06 67,04124 98,153.04 396.00 41,022.96 70.61% Staff Support 19,100 708.84 7,170.56 6,326.32 67.34 12,706.34 33.47% City Assistance 1,005,000 - 86.30 100,331.27 - 904,668.73 9.98% Professional Services 87,500 5,164.81 15,506.04 23,762.69 - 63,737.31 27.16% Fund Charges/Transfers 418,138 4,252.00 466,996.43 407,142.75 - 10,995.25 97.37% Debt Service 161,216 - 430,609.25 161,215.00 - 1.00 100.00% Operating Equipment 2,628 (124.26) 368.77 1,953.54 - 674.46 74.34% Capital Outlay 40,000 - - 28,533.00 - 11,467.00 71.33% TOTAL ECONO DEVELOPMENT 2,217,727 38,857.00 1,179,114.61 1,085,541.68 597.30 1,131,588.02 48.98% MISC & PROJECTS PROJECTS 441,775 10,513.00 229,649.28 221,673.35 - 220,101.65 50.18% TOTAL MISC & PROJECTS 441,775 10,513.00 229,649.28 221,673.35 - 220,101.65 0.00% FM3009 ROAD &BRIDGE EXPANSION Maintenance Services - - 20,825.51 - - - 0.00% TOTAL'sFM3009 RD &BRIDGEs',EXPANSION - 20,825.51 - - 0.00 %' TOTAL EXPENDITURES 2,659,502 ;49,370.00 1,429,589.40 1,307,215.03 597.30 1,351,689.67 49.18 % ** REVENUE OVER(UNDER) EXPEND 869,060 358,267.14 2,029,1'69.12 2,405,432.62 (597.30) (1,535,775.32)' SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 748,339.20 Cash in Investments Texas Class Investment-Economic Development Corl 8,212,119.96 Schertz Bank & Trust-Certificate of Deposit 1,054,002.95 Total Cash iin Bank & Investments $ 10,014,462.11 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, 2016 I T Y O F S C H E R T i INVESTMENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2016 INVESTMENT POOLS Beginning Book Value Yiel Deposits/ Purchases Withdrawals Interest Earns Ending Book Value Ending Mkt Value Par Value Maturity Date Weighted Avva Mat. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cash 5,652,579.46 0.0500 16,848,307.55 12,977,537.33 381.80 9,523,731.48 9,523,731.48 9,523,731.48 N/A Schertz Bank & Trust - PEG Fund 529,941.69 0.0000 - - - 529,941.69 529,941.69 529,941.69 N/A TOTAL OPERATIONS 6, 182, 521.15 16,848;307.55 12,977,537.33 381.806 10 053, 673.17 10!,053,673 =.17 10,053;673.17 - LOGIC General Fund 7,730,865.08 0.7248 400,000.00 1,000,000.00 4,253.97 7,135,119.05 7,135,119.05 7,135,119.05 N/A 45 Days G /F- Equipment Replacement 74,024.49 0.7248 - - 44.09 74,068.58 74,068.58 74,068.58 N/A 45 Days G /F- Vehicle Replacement 478,142.13 0.7248 21,000.00 - 285.27 499,427.40 499,427.40 499,427.40 N/A 45 Days G/F -Air Conditioner Replacement 221,659.29 0.7248 50,000.00 - 133.07 271,792.36 271,792.36 271,792.36 N/A 45 Days SR2009 Bond- Street Projects(II) 872,188.55 0.7248 - - 519.57 872,708.12 872,708.12 872,708.12 N/A 45 Days TOTAL SLOGIC 9,376,879.54 - 471,000.00 :1,000,000.00 (5,235.97 8,853,115.51 (8.,853,115.51 ;!8,853,115.51 - LONESTAR Capital Recovery - Sewer 2,963,758.59 0.6900 391.22 - 1,672.00 2,965,821.81 2,965,821.81 2,965,821.81 N/A 51 Days Capital Recovery - Water 6,020,132.64 0.6900 - 3,050,000.00 3,337.89 2,973,470.53 2,973,470.53 2,973,470.53 N/A 51 Days Drainage Fund 810,103.98 0.6900 - - 457.02 810,561.00 810,561.00 810,561.00 N/A 51 Days Facilities Master Plan 26,018.06 0.6900 - - 14.68 26,032.74 26,032.74 26,032.74 N/A 51 Days GO SR2011 Animal Shelter 8,623.10 0.6900 - - 4.86 8,627.96 8,627.96 8,627.96 N/A 51 Days GO SR2011 Soccer Fields 162,447.09 0.6900 - - 91.64 162,538.73 162,538.73 162,538.73 N/A 51 Days GO SR2011 Swimming Pool 1,393,450.02 0.6900 2,000,000.00 - 1,879.68 3,395,329.70 3,395,329.70 3,395,329.70 N/A 51 Days GO SR2012 Downtown Improvements 982,665.12 0.6900 - - 554.37 983,219.49 983,219.49 983,219.49 N/A 51 Days SE Elevated Water Tank 775,245.35 0.6900 1,650,000.00 - 468.91 2,425,714.26 2,425,714.26 2,425,714.26 N/A 51 Days Sewer /CCMA Project 2,851,180.65 0.6900 - - 1,608.48 2,852,789.13 2,852,789.13 2,852,789.13 N/A 51 Days W /S- Customer Deposits 296,966.54 0.6900 - - 167.53 297,134.07 297,134.07 297,134.07 N/A 51 Days W /S- Equipment Repl /Cap.Imp 178,550.23 0.6900 - - 100.73 178,650.96 178,650.96 178,650.96 N/A 51 Days Water &Sewer 2,076,798.20 0.6900 404,000.00 391.22 1,179.32 2,481,586.30 2,481,586.30 2,481,586.30 N/A 51 Days W /S- Vehicle Replacement 257.932.06 0.6900 - - 145.51 258.077.57 258.077.57 258.077.57 N/A 51 Days TOTAL- LONESTAR = 18,803;871.63 4,054,391.22 x;:3,050 391.22 ':11,682.62: 19;819,554:25 :19,819,554 -.25 .19,819;554.25 - TEXAS CLASS Tax I &S 1,273,058.03 0.7700 - - 802.01 1,273,860.04 1,273,860.04 1,273,860.04 N/A 71 Days Justice Forfeiture 245,442.47 0.7700 - - 154.62 245,597.09 245,597.09 245,597.09 N/A 71 Days Park Fund 276,795.32 0.7700 50,000.00 - 175.47 326,970.79 326,970.79 326,970.79 N/A 71 Days Economic Development Corporation 8,821,866.58 0.7700 300,000.00 - 5,564.39 9,127,430.97 9,127,430.97 9,127,430.97 N/A 71 Days Library Board 45,113.91 0.7700 - - 28.41 45,142.32 45,142.32 45,142.32 N/A 71 Days Tree Mitigation 219,005.19 0.7700 80,000.00 - 139.73 299,144.92 299,144.92 299,144.92 N/A 71 Days Tax Note 2013 Fire Truck 4,958.24 0.7700 - - 3.12 4,961.36 4,961.36 4,961.36 N/A 71 Days Hotel Tax 1,002,847.29 0.7700 50,000.00 - 632.89 1,053,480.18 1,053,480.18 1,053,480.18 N/A 71 Days Special Events Fund 16,880.45 0.7700 - - 10.64 16,891.09 16,891.09 16,891.09 N/A 71 Days Tax Notes 2015 EMS Ambulances 89,047.31 0.7700 - - 56.10 89,103.41 89,103.41 89,103.41 N/A 71 Days Tax Notes 2015 Drainage Equipment 682,986.24 0.7700 - - 430.28 683,416.52 683,416.52 683,416.52 N/A 71 Days Tax Notes 2015 Water Equipment 282,932.98 0.7700 - - 178.25 283,111.23 283,111.23 283,111.23 N/A 71 Days Tax Notes 2015 General Fund Equipme 241,475.42 0.7700 - - 152.13 241,627.55 241,627.55 241,627.55 N/A 71 Days Tax Notes 2015A Fire Trucks & EquiP 627.33 0.7700 - - 0.34 627.67 627.67 627.67 N/A 71 Days 2016 CO Roads - 0.7700 1,000,000.00 - 610.05 1,000,610.05 1,000,610.05 1,000,610.05 N/A 71 Days 2016 CO Building Repairs - 0.7700 172,736.00 - 105.39 172,841.39 172,841.39 172,841.39 N/A 71 Days 2016 CO Rec Center Windows - 0.7700 727,264.00 - 443.64 727,707.64 727,707.64 727,707.64 N/A 71 Days 2016 GO Fire Station 3 - 0.7700 4,000,000.00 - 2,440.21 4,002,440.21 4,002,440.21 4,002,440.21 N/A 71 Days TOTAL TEXAS CLASS 13,203,036.76 >.6,380;:000.00 `- 11,927.67 19;594,964.43 19,594,964 =.43 19,594,.964.43 - C I T Y 0 F S C H E R T Z INVES'T'MENT REPORT FOR MONTH ENDING SEPTEMBER 30th, 2016 Cit-k PVnagerlExecutive Director This investment portfolio represents a liquid and diverse holding by the City of Schertz. The investment strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested, it can be determined that it is in best interest of the City to invest in securities over 1 year to maximize yield while still maintaining all collateral and other safety requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. Beginning Purchases Interest Ending Par Maturity jNYE69=Ni M611LUD LQQQjMj Capital One General Fund Book -YA11Le 1,370,701.34 Xipld 1.6900 HithdLAWAIZ Lamed 283.72 (238.44) BQQk Value 1,370,179.18 mkt-yAlile 1,368,371.63 YA111e 1,340,254.25 Date N/A Avg -Mat. 685 Days Capital One Capital Recovery Sewer 1,748,356.30 1.6300 - 363.52 2,198.92 1,750,191.70 1,754,763.15 1,719,072.77 N/A 676 Days TOTAL CAPITAL ONE 3,119,057.64 - 647.24 1,960.48 3,120,370.88 3,123,134.78 3,059,327.02 - C. D. CERTIFICATES --Q3--DEPOSIT SB&T-Water&Sewer 1,076,645.00 0.8000 - - - 1,076,645.00 1,082,969.18 1,076,645.00 1/6/2017 Term 365 Days Schertz; Economic Development Corp. 1,054,002.95 0.6000 - - - 1,054,002.95 1,056,099.41 1,054,002.95 11/29/2016 1B0 Days Schertz; Economic Development Corp. 1,000,000.00 0.8000 - - - 1,000,000.00 1,005,852.05 1,000,000.00 1/7/2017 365 Days TOTAL C.D.s 3,130,647.95 - - 3,,130,647.95 3,144,920.64 3,130,647.95 TOTAL PORTFOLIO 0.78 $31,188.54 $ 64,572,326.19 $ 64,589,362.78 $ 64,511,282.33 95 Days Cit-k PVnagerlExecutive Director This investment portfolio represents a liquid and diverse holding by the City of Schertz. The investment strategy is to hold the monthly operating funds in the bank while investing other funds. By looking at the purpose of the funds being invested, it can be determined that it is in best interest of the City to invest in securities over 1 year to maximize yield while still maintaining all collateral and other safety requirements. This portfolio is in compliance with the City's Investment Policy and with the Public Funds Investment Act. KI TOTAL TEXAS CLASS 300 City Portfolio By Investment Type 31% TOTAL LOGIC 140 0 Special RevenUE Funds, $21,619,191.90 ❑ Debt Ser $1,27-` City Portfolio By Use M Designated Funds, $1, 646, 145.71 E3 Operations, $22,121,719.33 ects, $17,928,445.80 3.00 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr - 16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 01 Month T -Bill 0.0100 0.1100 0.1400 0.2200 0.2300 0.1800 0.1600 0.2700 0.2000 0.1900 0.2600 0.2000 03 Month T -Bill 0.0800 0.2200 0.1600 0.3300 0.3300 0.2100 0.2200 0.3400 0.2600 0.2800 0.3300 0.2900 06 Month T -Bill 0.2300 0.4200 0.4900 0.4300 0.4900 0.3900 0.4000 0.4900 0.3600 0.3800 0.4700 0.4500 BSchertz Portfolio 0.3930 0.4204 0.4328 0.5432 0.5913 0.6349 0.6619 0.6313 0.6551 0.6697 0.7120 0.7819 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 BLOGIC 0.7500 0.6000 0.1635 0.7500 0.6000 0.1637 0.7500 0.3500 0.2331 0.8000 0.3500 0.3922 0.8000 0.3500 0.4823 0.8000 0.3500 - - - --- - - -- 0.5206 0.8000 0.3500 -_ _- 0.5439 0.8000 0.3500 ___ _____ 0.5496 0.8000 0.6000 _ -__ 0.5640 0.8000 0.6000 0.5740 0.8000 0.6000 -- 0.6218 0.8000 0.6000 - -__ - _____ 0.7248 DLoneStar 0.1900 0.2000 0.2900 0.4100 0.4500 1 0.5000 0.5300 0.5500 0.5600 0.5800 0.6100 0.6900 BMBIA 0.2100 0.2400 0.2900 0.4200 0.4900 0.5400 0.5700 0.5900 0.6300 0.6400 0.7000 0.7700 BCapital One 2.6936 2.6959 2.3028 2.2400 2.2891 2.3359 2.3733 1.5805 1.5726 1.5942 1.6311 1.6561 Capital Recovery Assets C I T Y OF S C H E R T Z Projected Investment Report Capital One Assets Annual Current Cash___ Date: 9/30/2016 Maturity Shares Cost Mrk Value General Fund Yield Fidelity Imm Government Fund #2642 69,_072_77 Assets 69,072,77_ 208.00, 0.30 Total Cash & Equivalents 69,072.77 69,072.77 69,072.77 Projected 208.00 0.30% Fixed Income Annual Current Cash..& Equivalents Due Maturity Shares Cost Mrk Value Income Yield 125,000.00 Fidelity Imm Government Fund #2642 125,218.75 75,254_25 75,254.25 75,254.25 227.00 0.30 Total Cash & Equivalents 100,000.00 75,254.25 75,254.25 75,254.25 227.00 0.309 Fixed Income Federal Home Mtg Corp Refrnce 8 6/13/2018 621.00 100,000.00 110,753.60 106,832.00 Federal Natl Mtg Assn 1/30/2017 122.00 100,000.00 102,366.80 100,263.00 1,250.00 1.25 100,000.00 Federal Home LN Mtg Corp Reference Nts 11/17/2017 413.00 100,000.00 109,860.00 104,872.00 5,125.00 4.89 3/15/2017 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 621.00 100,000.00 110,756.94 106,832.00 4,875.00 4.56 0.75 US Treasury Note 10/15/2017 380.00 40,000.00 39,913.84 40,083.60 350.00 0.87 100,209.00 US Treasury Note 10/31/2019 1126.00 100,000.00 101,875.00 101,772.00 1,500.00 1.47 100,000.00 US Treasury Note 11/15/2017 411.00 200,000.00 199,042.97 200,418.00 1,750.00 0.87 11/15/2017 US Treasury Note 12/15/2018 806.00 125,000.00 126,181.64 126,190.00 1,562.00 1.24 0.87 US Treasury Note 11/30/2019 1156.00 100,000.00 99,554.69 100,213.00 1,000.00 1.00 100,952.00 US Treasury Note 1/31/2020 1218.00 100,000.00 101,312.50 101,325.00 1,375.00 1.36 50,000.00 US Treasury Note 2/28/2018 516.00 50,000.00 49,585.94 50,021.50 375.00 0.75 11/30/2019 US Treasury Note 7/31/2018 669.00 100,000.00 101,359.38 101,100.00 1,375.00 1.36 1.00 US Treasury Note 10/31/2018 761.00 100,000.00 101,101.56 100,926.00 1,250.00 1.24 50,662.50 US Treasury Note 5/31/2021 1704.00 50,000.00 52 013.67 51 909.50 1,000.00 1.93 Total Fixed income 100,043.00 1,265,000.00 1,294,924.93 1,285,925.60 22,787.00 1.770 Total Assets 684.20 1,340r,254.25s 1,370,179.18 1,361,179.85 23,014.00 1.69% Capital Recovery Assets Projected Annual Current Cash___ &_E uivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Imm Government Fund #2642 69,_072_77 69_072_,_77_ 69,072,77_ 208.00, 0.30 Total Cash & Equivalents 69,072.77 69,072.77 69,072.77 208.00 0.30% Fixed Income Federal Hall Mtg Assn 10/26/2017 391.00 125,000.00 124,588.38 125,218.75 1,093.00 0.87 Federal Home Ln Mtg Corp Reference Nts 11/17/2017 413.00 100,000.00 109,860.00 104,872.00 5,125.00 4.89 Federal Home Mtg Corp Refrnce 8 6/13/2018 621.00 100,000.00 110,753.60 106,832.00 4,875.00 4.56 Federal Home LN Mtg Corp 3/27/2019 908.00 100,000.00 108,297.40 106,926.00 3,750.00 3.51 US Treasury Note 3/15/2017 166.00 150,000.00 149,753.91 150,210.00 1,125.00 0.75 US Treasury Note 10/15/2017 380.00 100,000.00 99,644.53 100,209.00 875.00 0.87 US Treasury Note 10/31/2019 1126.00 100,000.00 100,065.85 101,772.00 1,500.00 1.47 US Treasury Note 11/15/2017 411.00 200,000.00 199,042.97 200,418.00 1,750.00 0.87 US Treasury Note 12/15/2018 806.00 100,000.00 100,945.31 100,952.00 1,250.00 1.24 US Treasury Note 4/30/2021 1673.00 50,000.00 49,970.70 50,531.50 687.00 1.36 US Treasury Note 11/30/2019 1156.00 150,000.00 149,332.03 150,319.50 1,500.00 1.00 US Treasury Note 1/31/2020 1218.00 50,000.00 50,656.25 50,662.50 687.00 1.36 US Treasury Note 2/28/2018 516.00 100,000.00 99,175.78 100,043.00 750.00 0.75 US Treasury Note 6/30/2018 638.00 75,000.00 75,916.99 75,797.25 1,031.00 1.36 US Treasury Note 10/31/2018 761.00 100,000.00 101,101.56 100,926.00 1,250.00 1.24 US Treasury Note 5/31/2021 1704.00 50,_000.00 52.013._67 51,909.50 1,_000.00 1.93 Total Fixed Income 1,650,000.00 1,681,118.93 1,677,599.00 28,248.00 1.680 Total Assets 675.85 1,719;072.77 1,750,191.70 'r 1,746;671.77 28,45'6.00 1.63 %`