The URL can be used to link to this page

Q1-December 2017Quarterly t t t Schertz, Texas XXXXXXXXXXXXX:.:.:. MY OF SC11ERTZ REVENUE AND EXPENSE REPORT (i,1NAUDI;,.f:°D S O DECEMBER R a i t 2017 2 f d - 201 k, :. ., ...... 21,277.05 CURRENT CURRENT Y -T -D BUDGET BUDGET Y-T -D AC' TUAL ENCUMBR BALANCE 25% OF BUDGET General Fund, 101 170,200.00 28,813.27 1,786.08 139,600.65 17.98% Total Revenues 31,354,058.43 10,901,169.58 - 20,953,824.92 33.17% Total General Government 6,751,104.19 1,443,678.97 649,894.99 4,657,530.23 31.01% Total Public Safety 13,475,601.59 3,530,377.96 298,138.55 9,647,085.08 28.41% Total Public Environment 1,353,192.00 270,881.64 32,006.67 1,050,303.69 22.38% Total Parks & Recreation 1,938,281.81 323,916.97 55,081.16 1,559,283.68 19.55% Total Cultural 921,998.00 256,307.78 15,435.26 650,254.96 29.47% Total Health 901,147.00 157,277.00 5,536.25 738,333.75 18.07% Total Internal Services 5,696,878.40 1,245,013.85 123,454.07 4,316,209.62 24.02% Total Misc & Projects 315,855.00 70,689.94 2,535.00 242,630.06 23.18% Total Expenditures 31,354,057.99 7,298,144.11 1,182,081.95 22,861,631.07 27.05% Revenue Over(Under) Expenditures 0.44 3,603,025.47 2,316,327.93 46,311.35 20,359,534.72 12.01% General Fund, 101 Total Cash in Bank & Investments 14,466,808.67 3,380,825.53 Total Revenues 170,200.00 21,277.05 - 148,922.95 12.50% Total Expenditures 170,200.00 28,813.27 1,786.08 139,600.65 17.98% Revenue Over(Under) Expenditures 0.00 (7,536.22) Special Events Fund, 106 Total Cash in Bank & Investments 76,989.89 Peg Fund, 110 Total Revenues 200,000.00 21,430.96 - 178,569.04 10.72% Total Expenditures 200,000.00 0.00 - 200,000.00 0.00% Revenue Over(Under) Expenditures 0.00 21,430.96 Peg Fund, 110 Total Cash in Bank & Investments 638,506.06 Water & Sewer, 202 Total Revenues 22,652,670.00 5,697,153.46 - 16,955,516.54 25.15% Total Expenditures 23,138,974.00 2,316,327.93 46,311.35 20,359,534.72 12.01% Revenue Over(Under) Expenditures (486,304.00) 3,380,825.53 Water & Sewer, 202 Total Cash in Bank & Investments 8,965,834.23 1 of 64 2 of 64 CH'Y OF SCHERTZ REVENUE AND EXPENSE REPORT(U?',IAUDITI ED) Quarterly Statement AS OF DECEMBER 31st, 2017 2017 - 2018 Schertz, Texas CURRENT CURRENT Y-T-D BUDGET 25% OF BUDGET Y- -D ACTUAL ENCUMBIR BALANCE BUDGET EMS, 203 Total Revenues 9,020,712.72 2,664,771.89 - 6,566,835.34 2720% Total Expenditures 9,007,172.81 2,595,609.55 794,220.62 5,617,342.64 37.63% Revenue Over(Under) Expenditures 13,539.91 69,162.34 EMS, 203 Total Cash in Bank & Investments 86,547.54 El= Drainage, 204 Total Revenues 2,763,927.00 462,589.20 - 2,301,337.80 16.74% Total Expenditures 2,279,927.00 317,412.53 873.52 2,063,159.15 9.51% Revenue Over(Under) Expenditures 484,000.00 145,176.67 Drainage, 204 Total Cash in Bank & Investments 1,171,965.37 Hotel Tax, 314 Total Revenues 563,650.00 114,802.45 448,847.55 20.37% Total Expenditures 322,836.00 64,429.56 258,406.44 19.96% Revenue Over(Under) Expenditures 240,814.00 50,372.89 Hotel Tax, 314 Total Cash in Bank & Investments 1,520,698.09 Park, 317 Total Revenues 130,000.00 1,259.70 - 128,740.00 0.97% Total Expenditures 130,000.00 0.00 109,829.69 20,170.31 84.48% Revenue Over(Under) Expenditures 0.00 1,259.70 Park, 317 Total Cash in Bank & Investments 1 1 1 1 i i i i i 369,070.89 1 1 1 1 1 I I I I IN 1 0000000011 Tree Mitigation, 319 Total Revenues 157,000.00 18,522.15 138,477.85 11.80% Total Expenditures 157,000.00 1,890.00 155,110.00 1.20% Revenue Over(Under) Expenditures 0.00 16,632.15 Tree Mitigation, 319 Total Cash in Bank & Investments 348,544.62 Capital Recovery Water, 411 Total Revenues 1,140,200.00 433,373.21 706,826.79 38.01% Total Expenditures 256.00 484.00 255,516.00 0.19% Revenue Over(Under) Expenditures 1,139,944.00 432,889.21 Capital Recovery Water, 411 Total Cash in Bank & Investments 5,278,251.62 2 of 64 Quarterly t t Schertz, Texas .. CH'Y OF SCHERTZ VENUE AND EXPENSE SE I1EPORT (WIMUDITMD) S OF DECEMBER 31st, 201 ..:, .. 2017 - 2018 3,175,441.42 CURRENT CURRENT Y -T -D BUDGET BUDGET Y- -D ACTUAL ENCUMBR BALANCE A1,CE 25% OF BUDGET Capital Recovery Sewer, 421 1 1 - 6,993,982.00 0.01% Total Revenues 590,150.00 281,191.81 - 308,958.19 47.65% Total Expenditures 485,500.00 1,574.82 - 483,925.18 0.47% Revenue Over(Under) Expenditures 104,650.00 279,616.99 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 5,883,159.42 1,045,074.01 - 3,037,798.99 25.60% Total Revenues 6,994,532.00 3,175,441.42 - 3,819,090.58 45.40% Total Expenditures 6,994,532.00 550.00 - 6,993,982.00 0.01% Revenue Over(Under) Expenditures 0.00 3,174,891.42 1 &S, 505 Total Cash in Bank & Investments 4,624,973.55 SED Corporation, 620 Total Revenues 4,082,873.00 1,045,074.01 - 3,037,798.99 25.60% Total Expenditures 2,209,865.00 446,235.49 346.51 1,763,283.00 20.21% Revenue Over(Under) Expenditures 1,873,008.00 598,838.52 SED Corporation, 620 Total Cash in Bank & Investments 13,965,263.77 Total Cash in Bank & Investments 57,396,613.72 3 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 19,581,110.00 8,203,584.82 8,086,841.12 8,203,584.82 - 11,377,525.18 41.90% Franchises 2,229,264.43 537,715.55 518,497.95 537,715.55 - 1,691,548.88 24.12% Permits 1,402,956.00 524,646.04 518,305.00 524,646.04 - 878,309.96 37.40% Licenses 51,160.00 13,802.50 15,165.00 13,802.50 - 37,357.50 26.98% Fees 2,126,546.00 526,207.66 603,701.00 526,357.66 200.00 1,599,988.34 24.76% Fines 20,000.00 5,180.44 5,190.42 5,180.44 - 14,819.56 25.90% Inter - Jurisdictional 873,008.00 135,921.98 229,330.04 135,921.98 - 737,086.02 15.57% Fund Transfers 4,484,614.00 769,914.54 603,938.72 769,914.54 - 3,714,699.46 17.17% Miscellaneous 585,400.00 184,046.02 116,649.24 184,046.05 (23.50) 401,377.45 31.44% TOTAL REVENUES 31,354,058.43 10,901,019.55 10,697,618:49 10,901,169.58 176.50 20,452,712.35 34.77% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 34,699.00 9,370.87 6,976.09 9,370.87 14.40 25,313.73 27.05% Supplies 1,050.00 - 46.81 - 45.60 1,004.40 4.34% City Support Services 41,393.00 11,189.37 33,174.91 11,189.37 - 30,203.63 27.03% Utility Services 641.47 119.20 - 119.20 49.38 472.89 26.28% Operations Support 500.00 29.00 195.64 29.00 19.99 451.01 9.80% Staff Support 28,868.53 12,281.34 13,616.30 12,281.34 4,882.91 11,704.28 59.46% Operating Equipment - 723.00 - - - 0.00% TOTAL CITY COUNCIL 107,152.00 32,98938 54,732.75 32,989.78 5,012.28 69,149.94 35.47% CITY MANAGER Personnel Services 1,088,445.00 313,078.81 255,095.82 313,078.81 - 775,366.19 28.76% Supplies 2,000.00 251.79 5.07 251.79 158.99 1,589.22 20.54% City Support Services 12,674.32 - 4,989.85 - 4,939.93 7,734.39 38.98% Utility Services - 269.77 17.99 269.77 - (269.77) 0.00% Staff Support 27,060.68 3,691.03 3,933.32 3,691.03 4,127.56 19,242.09 28.89% TOTAL CITY MANAGER 1,130,180.00 317,291.40 264,042.05 317,291.40 9,226.48 803,662.12 28.89 %s 4 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 288,987.00 83,741.39 76,616.30 83,741.39 - 205,245.61 28.98% Supplies 2,000.00 357.77 228.92 357.77 70.88 1,571.35 21.43% City Support Services 1,000.00 157.86 37.78 157.86 - 842.14 15.79% Operations Support 3,250.00 - - - - 3,250.00 0.00% Staff Support 8,510.00 1,492.64 439.56 1,492.64 248.39 6,768.97 20.46% Court Support 700.00 - - - - 700.00 0.00% Professional Services 67,960.00 15,000.00 12,700.00 15,000.00 22,200.00 30,760.00 54.74% Maintenance Services 3,000.00 500.00 500.00 500.00 2,500.00 - 100.00% Operating Equipment - - 39.02 - - - 0.00% TOTAL MUNICIPAL COURT 375,407.00 101,249.66 90,561.58 101,249.66 25,019.27 249,138.07 33.64% CUSTOMER RELATIONS -311 Personnel Services 115,904.00 34,168.21 31,066.79 34,168.21 - 81,735.79 29.48% Supplies 150.00 56.40 23.99 56.40 - 93.60 37.60% Staff Support 815.00 - - - - 815.00 0.00% Operating Equipment 600.00 - - - - 600.00 0.00% TOTAL CUSTOMER RELATIONS -311 117,469.00 34,224.61 31,090.78 34,224.61 = 83,24439 29.14% PLANNING & ZONING Personnel Services 202,011.00 55,018.80 46,917.65 55,018.80 - 146,992.20 27.24% Supplies 3,300.00 134.18 - 134.18 28.50 3,137.32 4.93% Operations Support 150.00 - - - - 150.00 0.00% Staff Support 25,490.00 1,010.00 978.98 1,010.00 936.00 23,544.00 7.63% Professional Services 100.00 - 70 - 100.00 0.00% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL PLANNING & ZONING 231,301.00 56,162.98 47,966.63 56,162.98 964.50 174,17152 24.70 %` LEGAL SERVICES Operations Support 5,000.00 331.84 559.66 331.84 156.20 4,511.96 9.76% Professional Services 155,000.00 11,639.48 4,238.79 11,639.48 - 143,360.52 7.51% TOTAL LEGAL SERVICES 160,000.00 11,97132 4,798.45 11,971.32 156.20 147,872.48 7.58% 5 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET CITY SECRETARY Personnel Services 177,703.00 50,872.83 44,856.77 50,872.83 - 126,830.17 28.63% Supplies 1,050.00 332.19 409.95 332.19 - 717.81 31.64% City Support Services 8,500.00 2,059.17 1,865.83 2,059.17 - 6,440.83 24.23% Operations Support 100.00 - - - - 100.00 0.00% Staff Support 6,650.00 964.63 1,596.06 964.63 - 5,685.37 14.51% TOTAL CITY SECRETARY 194,003.00 54,228.82 48,728 61 54,228`.82 - 139,774.18 27.95% NON - DEPARTMENTAL City Support Services 792,092.19 227,045.96 165,434.17 227,045.96 152,919.22 412,127.01 47.97% Operations Support 154,500.00 36,824.82 35,583.66 36,824.82 - 117,675.18 23.83% Staff Support 320.00 80.00 80.00 80.00 - 240.00 25.00% City Assistance 1,741,562.00 139,081.25 126,020.97 139,081.25 417,243.75 1,185,237.00 31.94% Professional Services 44,635.00 16,480.09 11,953.38 16,480.09 29,485.00 (1,330.09) 102.98% Fund Chrgs /Transfrs -Spec Events Fnd 75,550.00 - - - - 75,550.00 0.00% TOTAL NON - DEPARTMENTAL 2,808,659.19 419,512.12 339,072.18 419,512.12 599,647.97 1,789,499.10 36.29% 6 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 283,164.00 80,564.99 70,066.18 80,564.99 - 202,599.01 28.45% Supplies 2,000.00 448.80 94.06 448.80 - 1,551.20 22.44% Operations Support 29,450.00 1,495.30 718.00 1,495.30 - 27,954.70 5.08% Staff Support 3,730.00 149.00 301.00 149.00 - 3,581.00 3.99% Professional Services - - 10,800.00 - - - 0.00% TOTAL PUBLIC AFFAIRS 318,344.00 $2,658.09 81,979.24 82,658.09 - 235,685.91 25.97% RECORDS MANAGEMENT Personnel Services 53,654.00 11,391.29 14,733.01 11,391.29 - 42,262.71 21.23% Supplies 100.00 - - - - 100.00 0.00% Staff Support 355.00 - - - - 355.00 0.00% Professional Services 12,000.00 2,068.09 2,056.05 2,068.09 201.91 9,730.00 18.92% TOTAL RECORDS MANAGEMENT 66,109.00 13,459.38 16,789.06 13,459.38 201.91 52,447.71 20.66% SCHERTZ MAGAZINE Personnel Services 123,853.00 33,567.34 34,232.92 33,567.34 - 90,285.66 27.10% Supplies 200.00 - - - - 200.00 0.00% Opperations Support 2,600.00 - 36.33 2,563.67 1.40% Staff Support 3,330.00 - 18.00 - - 3,330.00 0.00% Professional Services 255,500.00 72,636.34 48,456.59 72,636.34 7,757.20 175,106.46 31.47% Fund Charges /Transfers 10,000.00 - - - 10,000.00 0.00% TOTAL SCHERTZ MAGAZINE 395,483.00 106,203.68 82,707:51 106,203.68 7,793.53 281,485.79 28.82 %` ENGINEERING Personnel Services 589,714.00 166,408.34 98,731.40 166,408.34 - 423,305.66 28.22% Supplies 1,620.00 64.52 54.64 64.52 - 1,555.48 3.98% Utility Services 3,500.00 408.74 4.73 408.74 - 3,091.26 11.68% Staff Support 11,475.00 235.21 198.00 235.21 100.00 11,139.79 2.92% Professional Services 70,800.00 - - - - 70,800.00 0.00% Operating Equipment 400.00 - - - - 400.00 0.00% TOTAL ENGINEERING 677,509.00 167,116.81 98,988.77 167,116.81 100.00 510,292.19 24.68% 7 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 161,063.00 46,089.37 39,610.94 46,089.37 - 114,973.63 28.62% Supplies 1,740.00 - - - 210.00 1,530.00 12.07% Staff Support 4,600.00 - - - - 4,600.00 0.00% Rental /Leasing 2,085.00 520.95 520.95 520.95 1,562.85 1.20 0.00% TOTAL GIS 169,488.00 46,610.32 40,131.89 46,610.32 1,772`.85 121,104.83 28.55% TOTAL GENERAL GOVERNMENT 6,751,104.19 1,443,678.97 1,201,589.50 1`,443,678.97 649,894 99 4,657,530.23 31.01 %` PUBLIC SAFETY POLICE Personnel Services 6,429,458.00 1,734,315.64 1,549,213.65 1,734,315.64 - 4,695,142.36 26.97% Supplies 65,446.80 2,624.98 12,388.13 2,624.98 23,946.12 38,875.70 40.60% City Support Services 21,500.00 24,229.52 21,294.42 24,229.52 - (2,729.52) 112.70% Utility Services 111,957.00 13,255.53 11,986.53 13,255.53 - 98,701.47 11.84% Operations Support 7,935.00 26425 379.84 264.25 - 7,670.75 3.33% Staff Support 148,758.43 21,983.32 11,318.84 21,983.32 6,400.22 120,374.89 19.08% City Assistance 13,222.00 1,267.22 935.18 1,267.22 311.40 11,643.38 11.94% Professional Services 49,948.00 12,010.31 14,863.09 12,010.31 4,252.39 33,685.30 32.56% Maintenance Services 57,645.00 6,745.00 9,785.00 6,745.00 464.99 50,435.01 12.51% Operating Equipment 56,923.80 - 48,503.02 - 45,279.79 11,644.01 79.54% Capital Outlay 552,317.56 252,324.39 - 252,324.39 18,100.70 281,892.47 48.96% TOTAL POLICE 7,515,111.59 2,069,020.16 1,680,667.70 2,069,020.16 98,755.61 5,347,335.82 28.85 %' FIRE RESCUE Personnel Services 4,116,534.00 1,114,451.35 921,269.85 1,114,451.35 - 3,002,082.65 27.07% Supplies 19,550.00 674.10 1,325.63 674.10 805.55 18,070.35 7.57% Utility Services 52,300.00 6,633.92 8,554.35 6,633.92 - 45,666.08 12.68% Operations Support 550.00 - - - 58.00 492.00 10.55% Staff Support 167,875.00 23,751.42 37,931.13 23,751.42 39,027.33 105,096.25 37.40% City Assistance 20,000.00 1,082.19 1,281.94 1,082.19 - 18,917.81 5.41% Professional Services 33,500.00 4,900.00 - 4,900.00 - 28,600.00 14.63% Maintenance Services 55,500.00 469.89 3,089.03 469.89 800.29 54,229.82 2.29% Other Costs - 102.05 - 102.05 - (102.05) 0.00% Rental /Leasing 23,500.00 4,063.19 4,063.19 4,063.19 11,852.46 7,584.35 67.73% Operating Equipment 105,300.00 12,810.91 20,174.46 12,810.91 2,314.50 90,174.59 14.36% Capital Outlay 97,000.00 - 6,800.23 - 62,495.40 34,504.60 64.43% TOTAL FIRE RESCUE 4,691,609.00 1,168,939.02 1,004,489.81 1,168,939.02 117,353.53 3,405,316.45 27.42 %' 8 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 633,629.00 169,710.40 148,353.61 169,710.40 - 463,918.60 26.78% Supplies 4,100.00 486.90 477.40 486.90 44.90 3,568.20 12.97% Utility Services 5,000.00 858.73 505.04 858.73 - 4,141.27 17.17% Operations Support 2,000.00 213.00 354.51 213.00 - 1,787.00 10.65% Staff Support 28,180.00 1,942.08 2,095.87 1,942.08 383.97 25,853.95 8.25% Professional Services 100,000.00 20,600.00 46,100.00 20,600.00 79,400.00 - 100.00% Operating Equipment 5,500.00 - - - - 5,500.00 0.00% TOTAL INSPECTIONS 778,409.00 193,811.11 197,886.43 193,811.11 79,828.87 504,769.02 35.15 %' MARSHAL'S OFFICE Personnel Services 451,997.00 97,047.10 126,735.20 97,047.10 - 354,949.90 21.47% Supplies 3,475.00 272.77 102.43 272.77 1,888.99 1,313.24 62.21% Utility Services 8,500.00 999.86 896.57 999.86 - 7,500.14 11.76% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 11,900.00 287.94 567.01 287.94 275.00 11,337.06 4.73% City Assistance 3,750.00 - - - - 3,750.00 0.00% Maintenance Services 5,100.00 200.00 - 5,100.00 0.00% Operating Equipment 4,750.00 14,503.05 - 36.55 4,713.45 0.77% TOTAL MARSHAL'S OFFICE 490,472.00 98,607.67 143,004.26 98,607.67 2,200.54 389,663.79 20.55 %? TOTAL PUBLIC SAFETY ` 13,475,601.59 3,530,377.96 3,026,048.20 3;530,377.96 298,138.55 9,647,085.08 28.41 %' 9 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT PARKS DEPARTMENT STREETS Personnel Services 526,297.00 130,980.24 140,376.39 130,980.24 - 395,316.76 24.89% Supplies 65,550.00 13,735.97 4,692.99 13,735.97 4,783.38 Personnel Services 783,442.00 City Support Services 222,550.42 578.00 205,074.93 578.00 222,550.42 1,469.63 37.67% - 560,891.58 25,083.03 28.41% 25,083.03 Supplies 66,850.00 15.93% 14,622.55 1,000.00 6,698.86 551.40 14,622.55 - 13,000.04 0.00% 39,227.41 9,850.00 41.32% 2,580.92 Utility Services 149,200.00 5,531.12 27,335.75 Professional Services 26,256.66 19,490.00 27,335.75 19,490.00 269.00 112,439.68 121,595.25 Maintenance Services 18.50% 5,305.01 Staff Support 11,250.00 6,681.09 1,331.04 70.51% 1,860.31 29,675.00 1,331.04 9,701.96 9,057.48 - 9,918.96 91.57% 11.83% 10,100.00 Professional Services 15,750.00 188.68 3,086.15 - 32.42% - 71,000.00 - 1,087.00 6,178.54 14,663.00 64,821.46 6.90% TOTAL PARKS DEPARTMENT Maintenance Services 85,000.00 221,249.02 211,699.76 - 11,215.36 24.15 %? SWIM POOL - - 85,000.00 0.00% Rental /Lease 4,000.00 1,820.79 280.00 1,820.79 259.00 16,935.30 280.00 Utility Services 21,000.00 - 3,720.00 1,123.77 7.00% 19,632.97 Operating Equipment 15,300.00 651,878.00 84,869.12 - 84,869.12 - 566,683.88 - 4,137.13 693,978.00 11,162.87 8,216.76 27.04% 2,912.17 Capital Outlay 222,400.00 4,761.88 - 4,761.88 13,513.50 204,124.62 8.22% TOTAL STREETS 1,353,192.00 270,881.64 251,365.12 270,881 >:64 32,006.67 1,050,303.69 22.38% TOTAL PUBLIC ENVIRONMENT 1,353,192.00 270,881.64 251,365,12 270,881?.64 32,006 67 1,050,303.69 22.38 %' PARKS & RECREATION PARKS DEPARTMENT Personnel Services 526,297.00 130,980.24 140,376.39 130,980.24 - 395,316.76 24.89% Supplies 65,550.00 13,735.97 4,692.99 13,735.97 4,783.38 47,030.65 28.25% City Support Services 2,357.81 578.00 3,426.35 578.00 310.18 1,469.63 37.67% Utility Services 222,000.00 25,083.03 43,290.39 25,083.03 10,289.89 186,627.08 15.93% Operations Support 1,000.00 - 551.40 - - 1,000.00 0.00% Staff Support 9,850.00 1,102.81 2,580.92 1,102.81 3,216.07 5,531.12 43.85% Professional Services 137,500.00 19,490.00 10,810.82 19,490.00 5,570.32 112,439.68 18.23% Maintenance Services 17,000.00 5,305.01 2,822.80 5,305.01 6,681.09 5,013.90 70.51% Rental /Leasing 29,675.00 9,057.48 9,701.96 9,057.48 18,114.96 2,502.56 91.57% Operating Equipment 10,100.00 188.68 2,995.00 188.68 3,086.15 6,825.17 32.42% Capital Outlay 71,000.00 6,178.54 - 6,178.54 - 64,821.46 8.70% TOTAL PARKS DEPARTMENT 1,092,329.81 211,699.76 221,249.02 211,699.76 52,052:04 828,578.01 24.15 %? SWIM POOL Supplies 21,100.00 1,820.79 4,667.58 1,820.79 2,343.91 16,935.30 19.74% Utility Services 21,000.00 1,123.77 2,957.71 1,123.77 243.26 19,632.97 6.51% Maintenance Services 651,878.00 84,869.12 591.47 84,869.12 325.00 566,683.88 13.07% TOTAL SWIM POOL 693,978.00 87,813,68 8,216.76 87,813.68 2,912.17 603,252.15 13.07% 10 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 60,584.00 15,935.32 14,738.67 15,935.32 - 44,648.68 26.30% Supplies 4,500.00 1,313.68 765.66 1,313.68 116.95 3,069.37 31.79% Utility Services 52,600.00 6,424.97 7,964.95 6,424.97 - 46,175.03 12.21% Operations Support 10,700.00 14.59 - 14.59 - 10,685.41 0.14% Staff Support 2,090.00 30.00 981.88 30.00 - 2,060.00 1.44% Operating Equipment 21,500.00 684.97 (1,850.61) 684.97 - 20,815.03 3.19% TOTAL EVENT FACILITIES ` 151,974.00 24,403.53 22,600.55 24,403.53 116.95 127,453.52 16.13 %' TOTAL PARKS &?RECREATION 1,938,281.81 323,916.97 252,066.33 323,916!.97 55,081.16 1,559,283.68 19.55 %`' CULTURAL LIBRARY Personnel Services 728,148.00 209,193.69 178,975.33 209,193.69 - 518,954.31 28.73% Supplies 15,500.00 2,391.07 4,277.49 2,391.07 - 13,108.93 15.43% Utility Services 55,500.00 6,611.87 4,680.09 6,611.87 - 48,888.13 11.91% Operations Support 4,200.00 481.98 231.98 481.98 1,670.00 2,048.02 51.24% Staff Support 7,375.00 1,127.61 957.10 1,127.61 - 6,247.39 15.29% Professional Services 2,275.00 2,318.00 2,252.00 2,318.00 - (43.00) 101.89% Maintenance Services 1,500.00 - - - - 1,500.00 0.00% Operating Equipment 107,500.00 34,183.56 28,006.40 34,183.56 13,765.26 59,551.18 44.60% TOTAL LIBRARY 921,998.00 256,307.78 219,380.39 256,307.78 15,435.26 650,254.96 29.47 %` TOTAL CULTURAL 921,998.00 256,307.78 219,380.39 256,307.78 15,435 26 650,254.96 29.47°lo'i 11 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 338,061.00 76,730.45 81,716.41 76,730.45 - 261,330.55 22.70% Supplies 33,380.00 8,080.56 8,045.59 8,080.56 690.01 24,609.43 26.27% City Support Services 3,500.00 - 1,149.76 - 675.68 2,824.32 19.31% Utility Services 54,500.00 5,472.26 7,516.90 5,472.26 202.36 48,825.38 10.41% Operations Support 1,000.00 256.07 690.00 256.07 - 743.93 25.61% Staff Support 10,750.00 1,152.60 1,601.61 1,152.60 864.88 8,732.52 18.77% City Assistance 18,500.00 2,626.09 2,106.69 2,626.09 782.40 15,091.51 18.42% Professional Services 24,500.00 4,616.10 2,034.76 4,616.10 900.00 18,983.90 22.51% Maintenance Services 43,380.00 975.00 6,270.50 975.00 - 42,405.00 2.25% Operating Equipment 31,000.00 250.00 - 250.00 990.00 29,760.00 4.00% Capital Outlay 62,000.00 - - - - 62,000.00 0.00% TOTAL ANIMAL SERVICES 620,571.00 100,159.1!3 111,132.22 100,159.13 5,105`.33 515,306.54 16.96% ENVIRONMENTAL HEALTH Personnel Services 223,926.00 53,036.92 42,811.45 53,036.92 - 170,889.08 23.69% Supplies 3,700.00 55.96 68.70 55.96 - 3,644.04 1.51% Operations Support 1,800.00 76.00 12.95 76.00 - 1,724.00 4.22% Staff Support 7,350.00 1,829.19 2,112.49 1,829.19 - 5,520.81 24.89% City Assistance 1,000.00 94.80 201.47 94.80 - 905.20 9.48% Professional Services 500.00 - - - - 500.00 0.00% Maintenance Services 15,000.00 2,025.00 1,810.00 2,025.00 - 12,975.00 13.50% Operating Equipment 2,300.00 - - - 430.92 1,869.08 18.74% Capital Outlay 25,000.00 - - - 25,000.00 0.00% TOTAL ANIMAL SERVICES 280,576.00 57,117.87 47,017.06 57,117.87 430.92 223,027.21 20.51% TOTAL HEALTH ' 901,147.00 1!57,277.00 158,149.28 157,277.00 5,536.25 738,33175 18.07 %' 12 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 539,540.00 139,064.92 106,571.16 139,064.92 - 400,475.08 25.77% Supplies 7,100.00 4,099.05 919.42 4,099.05 438.62 2,562.33 63.91% City Support Services 1,043,327.40 105,030.70 78,867.99 105,030.70 1,105.77 937,190.93 10.17% Utility Services 210,474.00 39,541.48 47,992.21 39,541.48 7,378.45 163,554.07 22.29% Staff Support 40,000.00 14,167.72 6,487.49 14,167.72 349.45 25,482.83 36.29% Professional Services 16,000.00 - - - - 16,000.00 0.00% Maintenance Services 14,692.00 949.45 1,322.40 949.45 - 13,742.55 6.46% Rental /Leasing - - 12,681.96 - - - Operating Equipment 251,860.00 32,284.19 48,877.19 32,284.19 10,282.02 209,293.79 16.90% TOTAL INFORMATION TECHNOLOGY 2,122,993.40 335,137.51 303,719:$2 335,137.51 19,554 31 1,768,301.58 1671 %s HUMAN RESOURCES Personnel Services 353,475.00 109,970.06 81,215.23 109,970.06 - 243,504.94 31.11% Supplies 1,000.00 78.99 28.55 78.99 - 921.01 7.90% Human Services 74,500.00 8,402.75 9,712.58 8,402.75 20,639.68 45,457.57 38.98% City Support Services 204.36 204.36 - 204.36 - - 100.00% Utility Services 455.88 75.98 - 75.98 37.99 341.91 25.00% Operations Support 9,339.76 5,855.83 1,367.00 5,855.83 - 3,483.93 62.70% Staff Support 15,000.00 398.66 1,497.21 398.66 579.00 14,022.34 6.52% City Assistance 10,000.00 975.00 708.00 975.00 375.00 8,650.00 13.50% Professional Services 9,600.00 2,234.25 2,234.25 2,234.25 6,702.75 663.00 93.09% Operating Equipment 1,000.00 - - - 1,000.00 0.00% TOTAL HUMAN RESOURCES 474,575.00 128,195.88 96,762.82 128,195.88 28,334.42 318,04410 32.98% FINANCE Personnel Services 584,989.00 169,450.26 159,317.80 169,450.26 - 415,538.74 28.97% Supplies 4,160.00 973.88 1,830.93 973.88 164.40 3,021.72 27.36% Operations Support 2,155.00 - 55.97 - - 2,155.00 0.00% Staff Support 9,495.00 2,269.26 865.00 2,269.26 - 7,225.74 23.90% Professional Sevices 31,970.00 7,252.00 - 7,252.00 - 24,718.00 22.68% Operating Equipment 3,770.00 - 55.99 - - 3,770.00 0.00% TOTAL FINANCE 636,539.00 179,945.40 162,125:69 179,945`.40 164.40 456,429.20 28.30 %< 13 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT 810,968.00 203,501.17 202,947.43 203,501.17 - 607,466.83 Personnel Services 207,405.00 59,037.13 29,893.51 59,037.13 20,664.73 25,131.96 - 148,367.87 28.46% Supplies 1,050.00 80.60 52.71 80.60 24,870.36 - 969.40 7.68% Utility Services 250.00 46.62 16.10 46.62 Operation Support - - 203.38 18.65% Operations Support 150.00 - (9.63) - - 150.00 0.00% Staff Support 6,600.00 660.00 30.00 660.00 7.00 19.42% 5,933.00 10.11% City Assistance 3,000.00 67.00 171.00 67.00 67.00 2,866.00 4.47% Capital Outlay 29,000.00 - - - 81,915.25 - 29,000.00 0.00% TOTAL PURCHASING & ASSET MGT 247,455.00 59,891.35 30,153.69 59,891,35 491.35 74.00 2,060.69 158,489.65 24.23% FLEET SERVICE (1,056.30) 152.82% Operating Equipment 7,000.00 - - Personnel Services 337,173.00 87,162.84 85,810.31 87,162.84 0.00% - 250,010.16 25.85% Supplies 169,500.00 34,251.35 37,063.17 34,251.35 - 8,101.97 0.00% 127,146.68 24.99% City Support Services 6,500.00 2,826.44 2,354.40 2,826.44 49,923.79 1!,070,457.45 - 3,673.56 43.48% Utility Services 7,000.00 1,419.05 1,677.17 1,419.05 29.83 5,551.12 20.70% Operations Support 200.00 - - - - 200.00 0.00% Staff Support 19,810.00 3,779.01 1,552.19 3,779.01 509.25 15,521.74 21.65% Maintenance Services 124,750.00 61,507.26 53,869.08 61,507.26 16,762.10 46,480.64 62.74% Operating Equipment 8,200.00 1,296.86 - 1,296.86 - 6,903.14 15.82% Capital Outlay 89,000.00 - - - - 89,000.00 0.00% TOTAL FLEET SERVICE 762,13100 192,242.81 182,326.32 192,242.81 25,403.15 544,487.04 28.56% FACILITY SERVICES Personnel Services 810,968.00 203,501.17 202,947.43 203,501.17 - 607,466.83 25.09% Supplies 113,500.00 25,131.96 20,664.73 25,131.96 5,408.61 82,959.43 26.91% Utility Services 159,515.00 24,870.36 23,308.92 24,870.36 - 134,644.64 15.59% Operation Support - 6,086.14 - 6,086.14 10,713.00 Staff Support 14,200.00 1,617.86 4,993.95 1,617.86 1,139.24 11,442.90 19.42% Professional Services 50,665.12 5,986.81 - 5,986.81 3,102.20 41,576.11 17.94% Maintenance Services 202,334.88 81,915.25 73,054.98 81,915.25 26,995.79 93,423.84 53.83% Rental /Leasing 2,000.00 491.35 2,060.69 491.35 2,564.95 (1,056.30) 152.82% Operating Equipment 7,000.00 - - - - 7,000.00 0.00% Capital Outlay 93,000.00 - - - - 93,000.00 0.00% TOTAL BUILDING MAINTENANCE 1,453,183.00 349,600.90 327,030.70 349,600.90 49,923.79 1!,070,457.45 27.49 %'' TOTAL INTERNAL SERVICE 5,696,878.40 1,245,013.85 1,102,119.04 1`,245,013.85 123,454.07 4;316,209.62 24.02 %' 14 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31, 2017 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 293,872.00 70,689.94 54,153.89 70,689.94 223,182.06 24.05% TOTAL CITY ASSISTANCE 293,872.00 70,689.94 54,153.89 70,689.94 223,182.06 24.05% COURT - RESTRICTED FUNDS Operating Equipment 21,983.00 2,535.00 19,448.00 11.53% TOTAL CITY ASSISTANCE 21,983.00 2,535.00 19,448.00 11.53% TOTAL MISC & PROJECTS 315,855.00 70,689.94 54,153.89 70,689.94 2,535.00 242,630.06 23.18% TOTAL EXPENDITURES 31,354,057.99 7,298,144.11 6,264,871.75 7,298,144.11 1,182,081:95 22,861,631.07 27.05% REVENUE OVER(UNDER) EXPEND. 0.44 - 3,603,025.47 15 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,726,025.00 6,183,879.02 6,195,642.10 6,183,879.02 - 5,542,145.98 52.74% 000 - 411200 Advalorem Tax - Delinquent 50,000.00 5,090.94 (26,431.35) 5,090.94 - 44,909.06 10.18% 000 - 411300 Advalorem Tax - P &I 50,000.00 4,750.49 6,525.81 4,750.49 - 45,249.51 9.50% 000 - 411500 Sales Tax Revenue -Gen Fund 7,711,085.00 1,998,920.78 1,898,834.48 1,998,920.78 - 5,712,164.22 25.92% 000 - 411600 Bingo Tax - 11.25 - 11.25 (11.25) 0.00% 000 - 411700 Mixed Beverage Tax 44,000.00 10,932.34 12,270.08 10,932.34 - 33,067.66 24.85% TOTAL Taxes 19,581,110.00 8,203,584.82 8,086,841.12 8;203,584.82 - 11;377,525:18 41.90% Franchises 000 - 421200 Center Point /Entex Energy 67,793.07 14,316.42 14,470.92 14,316.42 - 53,476.65 21.12% 000 - 421220 City Public Service 946,887.77 231,582.11 210,168.32 231,582.11 - 715,305.66 24.46% 000 - 421240 Guadalupe Valley Elec Co -op 416,134.03 99,925.40 99,127.80 99,925.40 - 316,208.63 24.01% 000 - 421250 New Braunfels Utilities 75,393.90 17,524.17 16,866.96 17,524.17 - 57,869.73 23.24% 000 - 421300 Time Warner -State Franchise 269,019.90 55,023.42 67,789.44 55,023.42 - 213,996.48 20.45% 000 - 421460 AT &T Franchise Fee 191,123.61 53,413.77 46,717.80 53,413.77 - 137,709.84 27.95% 000 - 421480 Other Telecom Franchise 113,964.44 29,327.28 27,543.27 29,327.28 - 84,637.16 25.73% 000 - 421500 Solid Waste Franchise Fee 148,947.71 36,602.98 35,813.44 36,602.98 - 112,344.73 24.57% TOTAL Franchises 2,229,264.43 537,715.55 518,497.95 537,715.55 - 1,691,548.88 24.12% Permits 000 - 431100 Home Occupation Permit 500.00 210.00 260.00 210.00 - 290.00 42.00% 000 - 431205 Building Permit - Residential 573,156.00 189,909.00 109,959.00 189,909.00 - 383,247.00 33.13% 000 - 431210 Building Permit - Commercial 200,000.00 114,324.00 255,907.00 114,324.00 - 85,676.00 57.16% 000 - 431215 Building Permit - General 150,000.00 44,042.00 31,515.00 44,042.00 - 105,958.00 29.36% 000 - 431300 Mobile Home Permit 300.00 25.00 50.00 25.00 - 275.00 8.33% 000 - 431400 Signs Permit 6,000.00 943.00 798.00 943.00 - 5,057.00 15.72% 000 - 431500 Food Establishmnt Permit 60,000.00 55,540.00 48,435.00 55,540.00 - 4,460.00 92.57% 000 - 431600 Garage Sale Permit 10,500.00 2,135.00 2,158.00 2,135.00 - 8,365.00 20.33% 000 - 431700 Plumbing Permit 121,000.00 42,561.70 25,159.00 42,561.70 - 78,438.30 35.17% 000 - 431750 Electrical Permit 61,000.00 18,900.00 13,260.00 18,900.00 - 42,100.00 30.98% 000 - 431800 Mechanical Permit 62,000.00 16,960.00 12,960.00 16,960.00 - 45,040.00 27.35% 000 - 431900 Solicitor /Peddler Permit 1,500.00 20.00 - 20.00 - 1,480.00 1.33% 000 - 431950 Animal/Pet Permit 1,000.00 90.00 15.00 90.00 - 910.00 9.00% 000 - 432000 Cert. of Occupancy Prmt 7,000.00 1,450.00 1,000.00 1,450.00 - 5,550.00 20.71% 16 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 36,000.00 9,423.00 9,800.00 9,423.00 - 26,577.00 26.18% 000 - 432300 Grading /Clearing Permit 7,000.00 3,474.36 2,414.00 3,474.36 - 3,525.64 49.63% 000 - 432400 Development Permit 81,000.00 16,303.98 - 16,303.98 64,696.02 20.13% 000 - 435000 Fire Permit 25,000.00 8,335.00 4,615.00 8,335.00 - 16,665.00 33.34% TOTAL Permits 1,402,956.00 524,646.04 518,305.00 524,646.04 - 878,309.96 37.40% Licenses 000 - 441000 Alcohol Beverage License 8,000.00 2,937.50 2,995.00 2,937.50 - 5,062.50 36.72% 000 - 441300 Mobile Home License 160.00 40.00 120.00 40.00 - 120.00 25.00% 000 - 442000 Contractors License 40,000.00 10,150.00 11,450.00 10,150.00 - 29,850.00 25.38% 000 - 444000 Pet License 3,000.00 675.00 600.00 675.00 - 2,325.00 22.50% TOTAL Licenses 51,160.00'- 13,802.50 15,165.00 13,802.50 - 37,357.50 26.98% Fees 000 - 451000 Municipal Court Fines 682,252.00 132,591.10 171,542.82 132,591.10 - 549,660.90 19.43% 000 - 451100 Arrest Fee 21,714.00 4,479.11 6,498.02 4,479.11 - 17,234.89 20.63% 000 - 451110 Expunction Fee 120.00 - 60.00 - - 120.00 0.00% 000 - 451200 Warrant Fees 124,000.00 19,332.21 21,548.86 19,332.21 - 104,667.79 15.59% 000 - 451210 Court - Claims & Judgements - - (291.40) - - - 0.00% 000 - 451340 Judicial Fee - City 3,152.00 628.58 882.27 628.58 - 2,523.42 19.94% 000 - 451400 Traffic Fine Costs TTL 10,265.00 2,117.35 3,231.24 2,117.35 - 8,147.65 20.63% 000 - 451510 Juvenile Case Mgmt Fee 26,352.00 5,257.90 7,357.40 5,257.90 - 21,094.10 19.95% 000 - 451520 Truancy Fee 4,464.00 936.81 1,347.36 936.81 3,527.19 20.99% 000 - 451600 Technology Fund Fee 21,983.00 4,147.23 5,911.20 4,147.23 - 17,835.77 18.87% 000 - 451700 Security Fee 15,817.00 3,205.38 4,433.40 3,205.38 - 12,611.62 20.27% 000 - 451800 Time Payment Fee - City 9,689.00 1,406.94 1,600.69 1,406.94 - 8,282.06 14.52% 000 - 451850 State Fines 10% Service Fee 20,488.00 8,502.14 10,245.75 8,502.14 - 11,985.86 41.50% 000 - 451900 DPS Payment - Local 8,829.00 1,517.34 1,635.21 1,517.34 - 7,311.66 17.19% 000 - 452000 Child Safety Fee 3,810.00 1,269.33 790.21 1,269.33 - 2,540.67 33.32% 000 - 452100 Platting Fees 62,000.00 7,750.00 22,500.00 7,750.00 - 54,250.00 12.50% 000 - 452200 Site Plan Fee 43,500.00 14,500.00 6,000.00 14,500.00 - 29,000.00 33.33% 000 - 452300 Plan Check Fee 463,261.00 175,383.00 197,971.00 175,383.00 - 287,878.00 37.86% 000 - 452320 Tree Mitigation Admin Fee 20,000.00 2,319.60 9,441.60 2,319.60 - 17,680.40 11.60% 000 - 452400 BOA/Zoning Fees 5,000.00 500.00 - 500.00 - 4,500.00 10.00% 17 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 14,300.00 12,800.00 13,000.00 12,800.00 - 1,500.00 89.51% 000 - 452710 Zoning Ltr & Dev Rights 1,200.00 450.00 600.00 450.00 - 750.00 37.50% 000 - 453100 Reinspection Fees 90,000.00 33,500.00 28,000.00 33,500.00 - 56,500.00 37.22% 000 - 453110 Swim Pool Inspection Fee 2,600.00 - - - - 2,600.00 0.00% 000 - 453200 Lot Abatement 5,000.00 - 1,325.50 - - 5,000.00 0.00% 000 - 453211 Admin Fee - Inspections 10,400.00 6,400.00 3,800.00 6,400.00 - 4,000.00 61.54% 000 - 453310 Misc Inspection Fee - 1,700.00 - 1,700.00 - (1,700.00) 0.00% 000 - 453710 Foster Care 1,000.00 200.00 150.00 350.00 - 650.00 35.00% 000 - 454200 Pool Gate Admission Fee 24,000.00 - - - - 24,000.00 0.00% 000 - 454300 Seasonal Pool Pass Fee 5,000.00 - - - - 5,000.00 0.00% 000 - 456120 Senior Center Meal Fee - 401.00 401.00 401.00 - (401.00) 0.00% 000 - 456500 Haz Mat Fees 5,000.00 - - - - 5,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 1,000.00 350.00 150.00 350.00 - 650.00 35.00% 000 - 458110 Sale of Merchandise- GovDeal 40,000.00 2,526.09 2,328.15 2,526.09 - 37,473.91 6.32% 000 - 458300 Sale of Property /Auction 3,000.00 - - - - 3,000.00 0.00% 000 - 458400 Civic Center Rental Fees 200,000.00 40,959.75 38,229.00 40,959.75 150.00 158,890.25 20.55% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000.00 300.00 2,885.00 300.00 - 9,700.00 3.00% 000 - 458450 North Center Rental Fees 18,500.00 5,755.00 4,800.00 5,755.00 50.00 12,695.00 31.38% 000 - 458460 Senior Center Rental 15,000.00 - 4,600.00 - - 15,000.00 0.00% 000 - 458500 Community Center Rental Fees 25,000.00 8,404.50 5,928.00 8,404.50 - 16,595.50 33.62% 000 - 458550 Pavilion Rental Fees 20,000.00 3,000.00 1,885.00 3,000.00 - 17,000.00 15.00% 000 - 458560 Chamber of Comm rent 7,800.00 1,950.00 - 1,950.00 - 5,850.00 25.00% 000 - 458570 Non - Resident SYSA League 10,000.00 9,280.00 - 9,280.00 - 720.00 92.80% 000 - 458650 NonResident User Fee -BVYA 10,000.00 - - - - 10,000.00 0.00% 000 - 458660 BVYA Utility Reimbursement 15,000.00 - 9,242.22 - - 15,000.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 10,000.00 2,344.00 3,516.00 2,344.00 - 7,656.00 23.44% 000 - 458700 Vehicle Impoundment 10,000.00 2,860.00 2,070.00 2,860.00 - 7,140.00 28.60% 000 - 459200 NSF Check Fee 250.00 - - - - 250.00 0.00% 000 - 459300 Notary Fee 250.00 24.00 66.00 24.00 - 226.00 9.60% 000 - 459400 Maps, Copies, UDC, & Misc F 250.00 5.00 - 5.00 - 245.00 2.00% 000 - 459600 Animal Adoption Fee 12,500.00 3,891.00 4,746.50 3,891.00 - 8,609.00 31.13% 000 - 459700 Pet Impoundment Fee 7,000.00 1,882.00 1,664.00 1,882.00 - 5,118.00 26.89% 000 - 459800 Police Reports Fee 5,800.00 1,381.30 1,609.00 1,381.30 - 4,418.70 23.82% TOTAL Fees 2,126,546.00 526,207.66 603,701:00 526,357.66 200:00 1,599,988.34 24.76 % ` - 18 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 20,000.00 5,180.44 5,190.42 5,180.44 - 14,819.56 25.90% TOTAL Fines 20,000.00 5,180.44 5,190.42 5,180.44 - 14,819.56 25.90% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077.00 19,321.28 15,808.32 19,321.28 - 1,755.72 91.67% 000 - 473200 City of Seguin - Fire Contract 29,231.00 7,307.70 7,307.70 7,307.70 - 21,923.30 25.00% 000 - 473300 Guad Co - Library 218,000.00 18,096.00 72,384.00 18,096.00 - 199,904.00 8.30% 000 - 473400 Randolph AFB - Animal Cntrl 1,200.00 - - - - 1,200.00 0.00% 000 - 474200 Library Services - Cibolo 35,000.00 1.50 - 1.50 - 34,998.50 0.00% 000 - 474210 Library Services -Selma 20,000.00 - - - - 20,000.00 0.00% 000 - 474400 Dispatch Service - Cibolo 166,000.00 - 40,000.00 - - 166,000.00 0.00% 000 - 474600 School Crossing Guard - Bexar 38,000.00 12,342.74 8,965.67 12,342.74 - 25,657.26 32.48% 000 - 474610 School Cross Guard - Guadalupe 38,000.00 8,852.76 8,614.35 8,852.76 - 29,147.24 23.30% 000 - 474620 School Crossing Guard -Coma) 1,500.00 - - - - 1,500.00 0.00% 000 - 474700 School Officer Funding 255,000.00 63,750.00 63,750.00 63,750.00 - 191,250.00 25.00% 000 - 474750 Crime Victim Liaison Agreement 50,000.00 6,250.00 12,500.00 6,250.00 - 43,750.00 12.50% TOTAL Inter - Jurisdictional 873,008.00 135,921.98 229,330:04 135,921.98 - 737,086 02 15.57 %` Fund Transfers 000 - 480000 Indirect Costs - EMS 170,087.00 42,521.68 37,521.75 42,521.68 - 127,565.32 25.00% 000 - 480100 Indirect Costs - Hotel /Motel 67,605.00 16,601.25 16,601.25 16,601.25 - 51,003.75 24.56% 000 - 481000 Transfer In Reserves 1,473,564.00 - - - - 1,473,564.00 0.00% 000 - 485000 Interfund Charge- Drainage 271,430.00 67,857.43 46,106.25 67,857.43 - 203,572.57 25.00% 000 - 486000 Interfund Chrges -Admin W &S 1,344,140.00 336,034.93 296,703.00 336,034.93 - 1,008,105.07 25.00% 000 - 487000 Interfund Charges -Fleet 344,026.00 86,201.75 99,395.25 86,201.75 - 257,824.25 25.06% 000 - 488000 Interfund Charges -413 441,395.00 220,697.50 107,611.22 220,697.50 - 220,697.50 50.00% 000 - 489000 Transfer In 107,367.00 - - - - 107,367.00 0.00% 000 - 489620 Contribution - SEDC 265,000.00 - - - 265,000.00 0.00% TOTAL Fund Transfers 4,484,614.00 769,914.54 603,938.72 769,914.54 - 3,714,699.46 17.17% 19 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 1,500.00 3,993.55 184.28 3,993.55 - (2,493.55) 266.24% 000 - 491200 Investment Income 150,000.00 34,112.52 22,841.43 34,112.55 - 115,887.45 22.74% 000 - 491800 Gain /Loss - (4,843.84) (5,416.78) (4,843.84) - 4,843.84 0.00% 000 - 491900 Unrealized Gain /Loss (30,000.00) (3,395.78) (9,491.91) (3,395.78) - (26,604.22) 0.00% 000 - 493120 Donations - Public Library 2,500.00 525.15 46.15 525.15 - 1,974.85 21.01% 000 - 493400 Donation - Animal Control 15,000.00 6,728.37 3,220.50 6,728.37 (23.50) 8,295.13 44.70% 000 - 493401 Donations -A /C Microchip 1,000.00 255.00 130.00 255.00 - 745.00 25.50% 000 - 493402 Donations - Spay &Neuter 1,000.00 - 643.50 - 1,000.00 0.00% 000 - 493403 Donations - Animal Adoption Trailer - - 102.00 - - - 0.00% 000 - 493404 Donations -TNR Program 500.00 - - - - 500.00 0.00% 000 - 493465 Donations - Senior Center - 2,850.53 2,289.13 2,850.53 - (2,850.53) 0.00% 000 - 493502 Donations -PD - - 3,500.00 - - - 0.00% 000 - 493503 Donations -Fire Rescue - 350.00 - 350.00 (350.00) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,650.00 - - - - 3,650.00 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund 5,000.00 - 4,892.03 - - 5,000.00 0.00% 000 - 495100 Mobile Stage Rental Fees - 550.00 - 550.00 - (550.00) 0.00% 000 - 497000 Misc Income -Gen Fund 30,000.00 49,765.43 10,744.00 49,765.43 - (19,765.43) 165.88% 000 - 497005 Schertz Magazine Advertising 195,000.00 33,560.00 52,525.00 33,560.00 - 161,440.00 17.21% 000 - 497100 Misc Income - Police 18,500.00 985.80 7,317.40 985.80 - 17,514.20 5.33% 000 - 497150 Misc Income -Fire Department - - 1,750.00 - - - 0.00% 000 - 497200 Misc Income - Library 5,000.00 1,211.49 1,037.75 1,211.49 - 3,788.51 24.23% 000 - 497210 Misc Income - Library Copier 18,000.00 4,903.41 4,270.00 4,903.41 - 13,096.59 27.24% 000 - 497300 Misc Income - Animal Control - 128.75 180.00 128.75 - (128.75) 0.00% 000 - 497400 Misc Income - Streets Dept. 60,000.00 7,976.10 6,141.70 7,976.10 - 52,023.90 13.29% 000 - 497500 Misc Income -TML Insurance 10,000.00 21,955.88 367.46 21,955.88 - (11,955.88) 219.56% 000 - 497550 Misc Income -TML Reimbursemt 20,000.00 119.11 1,748.26 119.11 - 19,880.89 0.60% 000 - 497600 Misc Income - Vending Mach. 2,500.00 389.15 496.68 389.15 - 2,110.85 15.57% 000 - 497610 Misc Income- Muni Court - 2,036.40 - 2,036.40 - (2,036.40) 0.00% 000 - 498000 Reimbursmnt -Gen Fund 35,000.00 2,276.34 335.50 2,276.34 - 32,723.66 6.50% 000 - 498100 Reimbursmnt Fire - Training 500.00 - - - - 500.00 0.00% 000 - 498105 Reimburmnt Police - DEA 5,000.00 - 2,121.89 - - 5,000.00 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 30,000.00 17,612.66 - 17,612.66 - 12,387.34 58.71% 000 - 498150 Reimbursemnt - Library 5,750.00 - 4,673.27 - - 5,750.00 0.00% TOTAL Miscellaneous 585,400.00;! 184,046.02 1`16,649:24 184,046.05 (23.50) 401,377.45 31.44% TOTAL REVENUES 31,354,058.43 10,901,019.55 10,697,618.49 10,901,169.58 176.50 20;452,712;35 34.77% 20 of 64 GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: December 31, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 4,337,121.45 Cash in Investments LOGIC Investment - General Fund 7,761,369.82 LOGIC Investment -Equip Replacement 75,095.67 LOGIC Investment -Veh Replacement 506,352.97 LOGIC Investment -Air Condi Replacment 275,561.29 CAPITAL ONE Investment - General Fund 1,364,725.63 Total Cash in Bank & Investments $14,466,808.67 21 of 64 2017 -18 OCT 100,310 NOV 505,909 DEC 5,577,660 JAN FEB MAR APR MAY JUN JUL AUG SEP 2016 -17 2015 -16 419,931 360,300 328,521 303,202 5,447,189 4,754,503 2,515,077 3,709,486 2,106,927 888,174 120,850 211,253 42,362 50,559 34,666 54,867 58,291 27,116 24,344 21,347 16,511 10,866 13,700 8,696 2014 -15 357,436 356,940 4,463,962 2,741,991 1,198,153 85,775 44,720 25,398 30,488 49,777 14,839 3,787 2013 -14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 20,939 10,460 7,446 22 of 64 Sales Tax - General Fund $900,000 - ....... $800,000 - - -- .6-0 6 - - - - - - - - - 12.2 %bx $700,000sJ $600,000` �4r 4 $500,000 $400,000 - - - - - - - -- - - - -- - $300,000 - - - - - - - - - - - -- - -- - -- - -- $200,000 -- -- - - -- - - - - - - - - - $100,000 - - - - - - - - - -- -- - - - -- $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2017 -18 644,584 686,048 615,170 - ------- - - - - - - -2016 -17 _ - - 574,470 - - 758,598 - -- - 580,171 - 560,431 747,281 486,739 - - - - -- 432,444 - - - - -- 669,542 - - - - -- 553,540 - - -- 566,565 -- - - - - -- 696,536 -- - - - - -- 573,973 2015 -16 479,069 744,668 529,686 493,136 783,019 530,498 531,707 615,841 568,508 523,141 691,061 678,167 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 amomm 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 23 of 64 9 CITY PUBLIC SERVICE I? OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP 2017 -18 271,335 - - -- - -- - - -- — -j - - - -- - -- - - - - - -o 2016-17 201617 252,947 191,140 213,951 259,517 2015 -16 237,314 183,530 173,336 178,081 2014-15 215,257 172,814 172,628 227,438 24 of 64 CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: December 31st, 2017 2017'301O 106-SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Yq-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y�-DACTUAL Yq-DACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 73.000.00 - - - - 73.800.00 0.00% Miscellaneous 96,400.00 21,277.05 27,386.10 21,277.05 75,122.95 22.07% TOTALREVENUES 170,200.00 21,277,05 27,386.10 21,277.05 148,922.95 12.50% CULTURAL FoaUve| of Angels 13.000.00 6.981.23 10.327.90 6.881.23 0.018.77 53.70% Employee Appreciation Event 13.000.00 8.333.70 7.739.80 8,333.76 178.00 4.488.24 05.48% 4th uf July Jubilee 20.000.00 20.000.00 0.00% National Night Out 400.00 - - - - 400.00 0.00% VVi|onobik Walk for Life 20.000.00 109.08 19.830.32 0.85% SohohzFost 30.000.00 585.00 - 585.00 240.00 29.175.00 275% SohoUzSwmotheart 31.250.00 19726 30.00 18726 28.40 31.024.34 072% Hal Baldwin Scholarship 15.050.00 7.852.61 8.047.17 7.852.61 585.00 0.512.39 56J3% Other Events _21,500l00 4763.41 001701 476341 585.00 16,151.59 24.88% TOTAL CULTURA 170,200.00 28,813.27 33,161.88 28,813.27 1,786.08 139,600.65 17.98% TOTAL EXPENDITURES 170,200.00 28,813.27 33,161.88 28,813.27 1,786.08 139,600.65 17.98% 25 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31st, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000 - 486100 Transfer In 9,000.00 - - - - 9,000.00 0.00% 000 - 486101 Transfer In - General Fund 64,800.00 - - - - 64,800.00 0.00% TOTAL Fund Transfers 73,800.00 - - - - 73,800.00 0.00% Miscellaneous 000 - 491200 Investment Income 150.00 57.05 36.10 57.05 - 92.95 38.03% 000 - 492200 Wilenchik Walk for Life 20,000.00 - - - - 20,000.00 0.00% 000 - 493256 Donations - Police Events 3,000.00 - - - - 3,000.00 0.00% 000 - 493000 July 4th Activities 26,000.00 - - - - 26,000.00 0.00% 000 - 493150 SchertzQ 30,000.00 200.00 - 200.00 - 29,800.00 0.67% 000 - 493455 Proceeds - Festival of Angels 700.00 1,215.00 585.00 1,215.00 - (515.00) 173.57% 000 - 493460 Schertz Sweetheart 1,500.00 - - - - 1,500.00 0.00% 000 - 493621 Hal Baldwin Scholarship 15,050.00 19,805.00 25,765.00 19,805.00 - (4,755.00) 131.59% 000 - 497000 Misc Income - - 1,000.00 - - - 0.00% TOTAL Miscellaneous 96,400.00 21,277.05 27,386.10 21,277.05 75,122.95 22.07 %! TOTAL REVENUES 170,200.00 21,277.05 27,386.10 21,277.05 - 148,922 95 12.50 %' 26 of 64 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 59,866.50 Cash in Investments Texas Class- Special Events 17,123.39 Total Cash in Bank & Investments $ 76,989.89 27 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 93,300.00 21,430.96 22,933.36 21,430.96 - 71,869.04 22.97% Fund Transfers 106,700.00 - - - - 106,700.00 0.00% TOTAL REVENUES 200,000.00 21,430.96 22,933.36 -' 21,430:96 - 178,569.04 10.72 %'i EXPENDITURE SUMMARY Ce3k1:1Y_�SeZi .ITT Non Departmental 200,000.00 - - - - 200,000.00 0.00% TOTAL GENERAL GOVERNMENT 200,000.00 - - - - 200,000.00 0.00% MISC & PROJECTS Projects - - 449.00 - - - 0.00% TOTAL MISC & PROJECTS - - 449.00 - - - 0.00 %`s TOTAL EXPENDITURES 200,000.00 - 449.00 - - 200,000.00 0.00% REVENUE OVER(UNDER) EXPEND - 21,430.96 22,484.36' 21,430.96 28 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31st, 2017 k****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 55,000.00 14,010.64 13,060.68 14,010.64 - 40,989.36 25.47% 000 - 421465 AT &T PEG Fee 38,300.00 7,420.32 9,872.68 7,420.32 - 30,879.68 19.37% TOTAL Franchises 93,300.00 21,430.96 22,933.36 21,430.96 - 71,869.04 22.97% Fund Transfers 000 - 481000 Transfer In - Reserves 106,700.00 - - - - 106,700.00 0.00% TOTAL Fund Transfers 106,700.00 - - - - 106,700.00 OM %` TOTAL REVENUES 200,000.00 21,430.96 22,933.36 21,430.96 - 178,569.04 10.72% 29 of 64 PEG FUND CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Cash Balance $ 638,506.06 Total Cash in Bank & Investments $ 638,506.06 30 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 238,260.00 5,000.00 - 5,000 - 233,260.00 2.10% Permits - - 46,445.05 - - - 0.00% Fees 22,013,250.00 5,597,005.84 5,310,415.62 5,597,006 - 16,416,244.16 25.43% Fund Transfers 194,546.00 35,377.50 34,230.00 35,378 - 159,168.50 18.18% Miscellaneous 206,614.00 59,770.12 336,084.56 59,770 - 146,843.88 28.93% TOTAL REVENUES 22,652,670.00 5,697,153.46 ' 5,727,175.23 5,697,153.46 - 16,955;516.54 < 25.`15% *14 =041 k911111:1411.09MWLA WA BUSINESS OFFICE Personnel Services 486,338.00 121,145.01 129,263.72 121,145.01 - 365,192.99 24.91% Supplies 3,800.00 220.00 - 220.00 120.00 3,460.00 8.95% Human Services 400.00 - - - - 400.00 0.00% City Support Services 2,993.00 - - - - 2,993.00 0.00% Utility Services 900.00 156.43 93.41 156.43 82.15 661.42 26,51% Operations Support 150,000.00 17,497.89 21,344.63 17,497.89 4,956.35 127,545.76 14.97% Staff Support 6,250.00 261.45 704.52 261.45 147.30 5,841.25 6.54% Professional Services 120,000.00 46,127.21 23,995.63 46,127.21 520.00 73,352.79 38.87% Maintenance Services 8,040.00 1,260.00 2,760.00 1,260.00 4,300.00 2,480.00 69.15% Operating Equipment 3,607.00 509.95 - 509.95 - 3,097.05 14.14% TOTAL BUSINESS OFFICE 782,328.00 '' 187,1177.94 178,161.91 187,177.94 10,125.80 585,024.26 25.22 %: 31 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,392,934.00 331,003.65 240,438.60 331,003.65 - 1,061,930.35 23.76% Supplies 157,500.00 26,485.11 33,323.09 26,485.11 25,810.14 105,204.75 3120% Human Services 600.00 - 266.00 - - 600.00 0.00% City Support Services 229,000.00 44,440.98 42,702.31 44,440.98 - 184,559.02 19.41% Utility Services 3,522,329.00 50,195.40 675,320.96 50,195.40 460.11 3,471,673.49 1.44% Operations Support 11,600.00 1,329.27 1,317.02 1,329.47 - 10,270.53 11.46% Staff Support 25,750.00 1,744.67 2,396.13 1,744.67 233.48 23,771.85 7.68% City Assistance 1,500.00 - 102.00 - - 1,500.00 0.00% Professional Services 283,000.00 44,691.73 22,296.50 44,691.73 2,335.40 235,972.87 16.62% Fund Charges /Transfers 5,092,110.00 468,507.36 1,651,288.33 468,507.36 - 4,623,602.64 9.20% Maintenance Services 8,609,240.00 1,122,669.30 1,487,874.07 1,122,669.30 415,688.92 7,070,881.78 17.87% Other Costs 37,500.00 36,605.45 36,605.45 36,605.45 - 894.55 97.61% Debt Service 1,626,779.00 - - - - 1,626,779.00 0.00% Rental- Leasing 124,500.00 512.61 497.68 512.61 - 123,987.39 0.41% Operating Equipment 9,000.00 - - - - 9,000.00 0.00% Capital Outlay 387,000.00 - - - - 387,000.00 0.00% TOTAL PUBLIC WORKS 21,510,342.00 ? 2,128,185.53 4,194,428.14 2,1128,185.73 444,528.05 18,937;628.22 11;96 %0 8I6Y01? 1=00111xia PROJECTS Operations Support 965.00 - 964.26 - 0.74 99.92% Professional Services 53,802.00 - - 8,457.50 45,344.50 15.72% Maintenance Services 431,537.00 - - - - 431,537.00 0.00% TOTAL PROJECTS 486,304.00 - - 964.26 8,457.50 476,882.24 1.94% SEWER PROJECT Professional Services 360,000.00 - - - - 360,000.00 0.00% TOTAL SEWER PROJECTS 360,000.00 - - - - 360,000.00 0.00% TOTAL MISC & PROJECTS 846,304.00 - 964 8;458 836,882 1.11% TOTAL EXPENDITURES 23,138,974.00 2,315,363.47 4,372,590.05 2,316,327.93 463,111.35 20,359;534.72 12.01 % % " REVENUE OVER(UNDER)EXPENSES ** (486,304.00) 3,381,789.99 1,354,585.18 3,380,825.53 (463,111.35) (3,404,018.18); 32 of 64 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 238,260.00 5,000.00 - 5,000.00 - 233,260.00 2.10% TOTAL Franchises 238,260.00 5,000.00 - 5,000.00 - 233,260.00 2.10 %` Permits 000 - 432400 Development Permit - - 46,445.05 - - - 0.00% TOTAL Permits - - 46,445.05 - - - 0.00% Fees 000 - 455200 Garbage Collection Fee 4,850,000.00 1,164,746.45 1,159,205.90 1,164,746.45 - 3,685,25155 24.02% 000 - 455600 Fire Line Fees 31,000.00 3,855.00 3,620.00 3,855.00 - 27,145.00 12.44% 000 - 455700 Recycle Fee Revenue 309,750.00 75,130.79 73,122.66 75,130.79 - 234,619.21 24.26% 000 - 455800 W &S Line Constructn Reimbursemnt 20,000.00 9,151.00 7,140.90 9,151.00 - 10,849.00 45.76% 000 - 457100 Sale of Water 9,825,000.00 2,533,675.59 2,307,317.11 2,533,675.59 - 7,291,324.41 25.79% 000 - 457110 Edwards Water Lease 125,000.00 1.00 97,360.00 1.00 - 124,999.00 0.00% 000 - 457120 Water Transfer Charge -Selma 50,000.00 - - - - 50,000.00 0.00% 000 - 457200 Sale of Meters 80,000.00 38,673.33 18,998.00 38,673.33 - 41,326.67 48.34% 000 - 457400 Sewer Charges 6,500,000.00 1,694,973.96 1,580,935.20 1,694,973.96 - 4,805,026.04 26.08% 000 - 457500 Water Penalties 220,000.00 76,023.72 61,965.85 76,023.72 - 143,976.28 34.56% 000 - 459200 NSF Check Fee -Water &Sewer 2,500.00 775.00 750.00 775.00 - 1,725.00 31.00% TOTAL Fees 22,013,250.00 5,597,005.84 5,310,415.62 5,597,005.84 - 16,416,244.16 25.43 %` Fund Transfers 000 - 481000 Transfer In- Reserve 53,036.00 - - - - 53,036.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 141,510.00 35,377.50 34,230.00 35,377.50 - 106,132.50 25.00% TOTAL Fund Transfers 194,546.00 35,377.50 34,230.00 35,377.50 - 159,168.50 18.18% 33 of 64 CITY O F S C H E R T Z REVENUE REPORT (UNAUD|TED) AS OF: December 31st.2O17 2V17'2V18 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF REVENUES BUDGET QUARTER Y'T'DACTUAL ACTUAL ENCUM8R BALANCE BUDGET Miscellaneous 000-490000 K4isuChargon 500.00 2.622.00 279.67671 2.022.00 - (2.122.00) 52440% 000-491808 Interest Earned 1.500.00 6.21011 382.82 0.21011 ' (4.71811) 414.01Y6 000-491200 Investment Income 60,000.00 21,586.05 772702 21,586.05 ' 38/413.95 35.98% 000'497808 K8km|noomo-W&S 15.000.00 1.054.21 10.754.05 1.05421 ' 13.34579 11.03% 000488110 Reimbursement-SSLGC 129,614.00 27,697.75 31,543.96 27,697.75 �_ __-101,916.25 21,37% TOTAL Miscellaneous 206,614,00 59,770.12 336,084.56 59,770A2 146,843.88 28.93% TOTALREVENUES 22,652,670.00 5,697,15146 5,727,17523 5,697,153.46 16,955,516.54 25.15% 34 of 64 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,447,781.33 Cash in Investments Lone Star Investment -Water &Sewer 5,689,312.62 Lone Star Investment -W &S Customer Deposits 301,028.92 Lone Star Investment -W &S Equip Replacement 180,992.74 Lone Star Investment -W &S Veh Replacement 261,460.46 Schertz Bank & Trust - Certificate of Deposit 1,085,258.16 $ 7,518,052.90 Total Cash in Bank & Investments $ 8,965,834.23 35 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: December 31st, 2017 201r-2018 203-EMS CURRENT CURRENT PRIOR YEAR Y�-D YT-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Fees 6,122.000.00 1.571.30026 1.532.127.12 1.*71,300.20 - 4.550,699.74 25.67% Inter-Jurisdictional 2.780.862.72 e88751.13 5670488e e88.751.13 - 1.792.111.5e 35.56% Fund Transfers - - - - - - 0.00% Miscellaneous 117,850.00 104,720.50 16,282.13 104,720.50 13,129.50 88.86% TOTALREVENUES 9,020,712.72 2,664,771,89 2,115,458.24 2,664,771.89 6,355,940.83 29.54% EXPENDITURE SUMMARY PUBLIC SAFETY SCHEBTZ EMS Personnel Services 4.244.739.00 1.106\68084 983219.88 1.100.880.84 3.138.058.10 20�07% Supplies 410,850.00 102,23354 132,2*1.57 102.233.54 28.571.87 280.044.58 31.84% Human Services 238.00 0.00% City Support Services 104,100.00 24�13.10 25,953J5 24,613.10 15,000.00 04,486.80 38.05% Utility Services 118.000.00 19,20889 18.518.75 18.209.33 1.159.75 97.570.91 17.31Yt Operations Support 74.020.00 13,851.0 14.886.28 13.851.0 1.631.50 59.136.67 0.75% Staff Support 70.750.08 6,92754 8.054.33 0.927.54 5.717/3 58.105.03 17.87% City Assistance 508.900.81 137,310.70 138,08770 137.310,70 200.00 431.35011 2417% Professional Services 108.200.00 21.04701 37.003.84 21.047.01 12.989.99 134.152.40 20.24% Fund 2.050.827.00 1.144.070.34 81.70121 1.144.070.34 1.512.150.60 43.88% Maintenance Services 12,000.00 800.00 12,000.00 0.00% Debt Service 288120.00 288120.00 8.00% Rental-Leasing 141,000.00 17,385.21 17,964J2 17,38521 118,74911 4,805.68 96.55% Operating Equipment 118.100.00 1.013.51 3.508.50 1.013.51 3.785.20 113.69129 4.54% Capital Outlay 30,000.00 - - - 606,395.76 (576,395.76) 2021.32% TOTAL PUBLIC SAFETY 9,007,172.81 2,595,608.91 1,464,297.79 2,595,609.55 794,22062 5,617,342.64 37.63% TOTAL EXPENDITURES 9,007,172.81 2,595,608.91 1,464,297.79 2,595,609.55 794,220.62 5,617,342.64 37.63% " REVENUE OVER(UNDER) EXPENSES " 13,539.91 69,16Z98 651,160.45 69,162.34 __g?4,2206J2 738,598.19 36 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,866,200.00 1,476,924.18 1,445,693.87 1,476,924.18 - 4,389,275.82 25.18% 000 - 456110 Subscription Program Fees 30,000.00 17,345.00 17,030.00 17,345.00 - 12,655.00 57.82% 000 - 456120 EMT Class - Fees 96,000.00 17,240.00 9,800.00 17,240.00 - 78,760.00 17.96% 000 - 456122 CE Class - Fees 22,800.00 - - - - 22,800.00 0.00% 000 - 456130 Immunization Fees 7,000.00 1,220.00 1,108.00 1,220.00 - 5,780.00 17.43% 000 - 456140 Billing Fees - External 25,000.00 4,779.93 4,364.80 4,779.93 - 20,220.07 19.12% 000 - 456150 Standby Fees 25,000.00 25,050.15 19,835.45 25,050.15 - (50.15) 100.20% 000 - 456155 Community Services Support 50,000.00 27,156.00 34,295.00 27,156.00 - 22,844.00 54.31% 000 - 456160 MIH Services - 1,585.00 - 1,585.00 - (1,585.00) 0.00% TOTAL Fees 6,122,000.00 1,571,300.26 1,532,127.12 1,571,300.26 4,550,699.74 25.67 % >s Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 843,577.17 210,894.51 147,972.58 210,894.51 - 632,682.66 25.00% 000 - 474300 Cibolo Support 346,467.65 86,616.91 79,774.58 86,616.91 - 259,850.74 25.00% 000 - 475100 Comal Co ESD #6 112,536.60 27,316.41 24,062.50 27,316.41 - 85,220.19 24.27% 000 - 475200 Live Oak Support 213,151.95 53,287.99 51,739.13 53,287.99 - 159,863.96 25.00% 000 - 475300 Universal City Support 281,283.70 70,320.93 65,590.25 70,320.93 - 210,962.77 25.00% 000 - 475400 Selma Support 111,886.35 27,971.59 26,664.02 27,971.59 - 83,914.76 25.00% 000 - 475500 Schertz Support 556,325.00 139,081.25 126,020.97 139,081.25 - 417,243.75 25.00% 000 - 475600 Santa Clara Support 10,447.35 2,611.84 2,588.54 2,611.84 - 7,835.51 25.00% 000 - 475800 Marion Support 15,186.95 3,796.74 3,739.00 3,796.74 - 11,390.21 25.00% 000 - 475910 TASPP Program 290,000.00 366,852.96 38,897.42 366,852.96 - (76,852.96) 126.50% TOTAL Inter - Jurisdictional= 2,7$0,86212 988,751.13 567,048.99 988,751.13 - 1,792,112: 35:56% Miscellaneous 000 - 491000 Interest Earned 100.00 470.45 26.75 470.45 - (370.45) 470.45% 000 - 491200 Investment Income 750.00 2,136.38 190.53 2,136.38 - (1,386.38) 284.85% 000 - 493203 Donations -EMS 2,000.00 350.00 150.00 350.00 - 1,650.00 17.50% 000 - 493205 Donations- Golf Tournament 10,000.00 - - - - 10,000.00 0.00% 000 - 495100 UH Grant Program 40,000.00 - - - - 40,000.00 0.00% 000 - 497000 Misc Income 25,000.00 93,699.37 6,024.98 93,699.37 - (68,699.37) 374.80% 000 - 497100 Recovery of Bad Debt 40,000.00 8,064.30 9,889.87 8,064.30 - 31,935.70 20.16% TOTAL Miscellaneous 117,850.00` 104,720.50' 16,282.13 104,720:50 - 13;129.50 88.86% TOTAL REVENUES 9,020,712.72s 2,664,771.89`- 2,115,458.24 2,664,771.89 - 6,355,940.83 29.54% 37 of 64 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ (3,781.22) Cash in Investments Texas Class- Tax Note 2015 Ambulances 90,328.76 Total Cash in Bank & Investments 86,547.54 38 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 391,652.00 82,555.37 124,475.15 82,555.37 - 309,096.63 Permits 3,000.00 700.00 500.00 700 - 2,300.00 23.33% Fees 1,179,250.00 291,655.57 283,584.71 291,656 - 887,594.43 24.73% Fund Transfers 1,327,327.00 - - - - 1,327,327.00 0.00% Miscellaneous 254,350.00 170,233.63 3,010.59 170,234 - 84,116.37 66.93% TOTAL REVENUES 2,763,927 00 462,589.20 287,095.30 462,589.20 - ` 2,301,337.80 16.74 % all".] II *] "T7.1= DRAINAGE Personnel Services 391,652.00 82,555.37 124,475.15 82,555.37 - 309,096.63 21.08% Supplies 3,700.00 687.17 730.34 687.17 58.62 2,954.21 20.16% Human Services - - 4,576.16 3,437.69 - (3,437.69) 0.00% City Support Services 8,180.00 3,437.69 2,877.58 1,661.90 473.08 6,045.02 26.10% Utility Services 13,200.00 1,661.90 - - - 13,200.00 0.00% Operations Support 1,000.00 - 998.11 1,093.20 - (93.20) 109.32% Staff Support 6,700.00 1,093.20 - - - 6,700.00 0.00% City Assistance 400.00 - - - - 400.00 0.00% Professional Services 117,320.00 1,855.00 1,500.00 1,855.00 - 115,465.00 1.58% Fund Charges/Transfers 497,295.00 124,073.68 106,783.50 124,073.68 - 373,221.32 24.95% Maintenance Services 971,255.00 530.32 352.44 530.32 341.82 970,382.86 0.09% Other costs 200.00 - - - - 200.00 0.00% Debt Service 123,225.00 - - - 123,225.00 0.00% Rental /Leasing 2,000.00 - - - 2,000.00 0.00% Operating Equipment 7,000.00 - - - 7,000.00 0.00% Capital Outlay 136,800.00 - - - - 136,800.00 0.00% TOTAL DRAINAGE 2,279,927.00 215,894.33 242,293.28 215,894.33 873.52 2,063,159.15 9.51 %' PROJECTS Operations Support 650.00 469.00 - 469.00 - 181.00 72.15% Professional Services - 3,626.00 - 3,626.00 4,494.00 (8,120.00) 0.00% Maintenance Services 653,350.00 97,423.20 97,423.20 151,679.20 404,247.60 38.13% TOTAL PROJECTS 654,000.00 101,518.20 - 101,518`.20 156,173.20 396,308.60' 39.40% TOTAL EXPENDITURES 2,933,927.00 317,412.53 242,293.28 317,412.53 157,046.72 2,459,46715 16.17% " REVENUE OVER(UNDER) EXPEND (170,000.00) 145,176.67 145,176.67 39 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000.00 700.00 500.00 700.00 - 2,300.00 23.33% TOTAL Permits 3,000.00 700.00 500.00 700.00 - 2,300.00- 23.33% Fees 000 - 457500 Drainage Penalties 10,000.00 3,694.57 2,413.14 3,694.57 - 6,305.43 36.95% 000 - 457600 Drainage Fee 1,169,250.00 287,961.00 281,171.57 287,961.00 - 881,289.00 24.63% TOTAL Fees 1,179,250.00 291,655,57 283,584.71 291,655.57 - 887594A3f 24.73 % "s Fund Transfers 000 - 481000 Transfer In 1,327,327.00 - - - - 1,327,327.00 0.00% TOTAL Funds Transfers 1,327,327.00 - - - - 1,327,327 0.00°%` Miscellaneous 000 - 491000 Interest Earned 150.00 441.17 27.12 441.17 - (291.17) 294.11% 000 - 491200 Investment Interest 12,000.00 5,547.96 2,983.47 5,547.96 - 6,452.04 46.23% 000 - 497000 Misc Income - Drainage 242,200.00 164,244.50 - 164,244.50 - 77,955.50 67.81% TOTAL Miscellaneous 254,350.00 170,233.63 - 3,010.59 170,233.63 - 84,116.37` 66.93% TOTAL REVENUES 2,763,927.00 462,589.20 287,095.30 462,589.20 - 2,301,337.80 16.74 %' 40 of 64 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool-Checking 179,754.18 Cash in Investments Lone Star Investment-Drainage Maint Fund 992,211.19 Total Cash in Bank & Investments $ 1,171,965.37 41 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 k******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 550,000.00 109,873.72 100,361.36 109,873.72 - 440,126.28 19.98% Miscellaneous 13,650.00 4,928.73 2,272.49 4,928.73 - 8,721.27 36.11% TOTAL REVENUES 563,650.00 114,802.45 `: 102,633.85 114,802.45 - 448,847.55 20.37% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,000.00 44,342.31 19,469.40 44,342.31 - 65,657.69 40.31% Operations Support 68,425.00 3,486.00 18,895.64 3,486.00 - 64,939.00 5.09% Professional Services 3,000.00 - 3,000.00 - - 3,000.00 0.00% Fund Charges /Transfers 67,605.00 16,601.25 16,60125 16,601.25 - 51,003.75 24.56% Maintenance Services 10,000.00 - 561.94 - - 10,000.00 0.00% Capital Outlay 63,806.00 - - - - 63,806.00 0.00% TOTAL NONDEPARTMENTAL 322,836.00!+ 64,429.56 60,528.23 64,429.56 258,406.44 19.96% TOTAL EXPENDITURES 322,836.00: 64,429.56 60,528.23 64,429.56 - 258,406.44 19.96 %' REVENUE OVER(UNDER)'EXPENDITURE 240,814.00 42 of 64 50,372.89 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ 171,018.84 Cash in Investments Texas Class - Hotel Tax 1,349,679.25 Total Cash in Bank & Investments $ 1,520,698.09 43 of 64 HOTEL OCCUPANCY TAX $80,000 $70,000 = - - - - - - - - - - - - -- - - $60,000 $50,000 $40,000 axaua $30,000 $20,000 = - - - - - --- - - - - -- - - - -- - - $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP --------------------- 2017 -18 - - -- -- 37,415 - - - -- - - - - - -- 38,911 - - - - - -- - - - - - -- 30,706 --- - - - - -- --- - - - - -- --- - - - - - - -- - - - - -- - - - - - -- - - - - - -- -- - - - - -- - - -- - -- - - -_ - --------------- - - - - -- --- - - - - -- --- - - - - -- -- - - - - -- --- - - - - -- -- - - - - -- --- - - - - -- -- - - - - -- 2016 -17 33,917 33,203 30,940 32,131 33,710 51,467 47,698 43,479 55,151 57,536 46,685 33,548 - - - - -- -- -- 2015-16 - -- - - -- 40,800 - -- -- - - - - -- 40,351 38,394 - 34,516 _ - -_ - 39,732 -- - - - - -- - - - - -- - 54,142 - -_ - -- -_ 49,741 - 45,524 51,636 - 68,491 _ 48,302 __ -- 33,241 2014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 44 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 - 96,000.00 - - 70,000.00 0.00% Miscellaneous 60,000.00 1,259.70 706.96 1,259.70 - 58,740.30 2.10% TOTAL REVENUES 130,000.00 1,259.70 96,706.96 1,259.70 - 128,740.30 0.97 %1 EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 10,000.00 - 4,005.00 - - 10,000.00 0.00% Capital Outlay 120,000.00 - - - 109,829.69 10,170.31 91.52% TOTAL PARKLAND DEDICATION 130,000.00 4,005.00 - 109,829.69 20,170.31 84.48% TOTAL EXPENDITURES 130,000.00 - 4,005.00 : - 109,829.69 20,170.31 84.48% REVENUE OVER(UNDER) EXPEND - 45 of 64 1,259.70 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31st, 2017 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 70,000.00 - 96,000.00 - - 70,000.00 0.00% TOTAL Fees 70,000`.00 - 96,000.00 - 70,000.00 0.00% Miscellaneous 000 - 491000 Interest Earned 100.00 156.22 7.87 156.22 - (56.22) 156.22% 000 - 491200 Investment Interest 3,000.00 1,103.48 699.09 1,103.48 - 1,896.52 36.78% 000 - 499100 Transfer From Parks Reserve 56,900.00 - - - - 56,900.00 0.00% TOTAL Miscellaneous 60,000.00 1,25970 706.96 1,25970 - 58,740.30 2.10 %' TOTAL REVENUES 130,000':00 1,259.70 96,706.96 1,259.70 - 128,740.30 0.97 %> 46 of 64 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $37,603.67 Cash in Investments Texas Class- Park Fund 331,467.22 Total Cash in Bank & Investments $369,070.89 47 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 t******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 17,402.90 53,502.40 17,403 - 55,097.10 24.00% Fund Transfers 81,400.00 - - - - 81,400.00 0.00% Miscellaneous 3,100.00 1,119.25 68120 1,119 - 1,980.75 36.10% TOTAL REVENUES 157,000.00 18,522.15 54,185.60 18,522.15 - 138,477.85 11.80 %' EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 157,000.00 1,890.00 36,500.00 1,890.00 - 155,110.00 1.20% TOTAL TREE MITIGATION 157,000.00 1,890.00 36,500.00 1,890.00 155,110.00 1.20 %< TOTAL EXPENDITURES 157,000.00 1,890.00 36,500.00 - 1,890.00 - 155,110.00 1.20% REVENUE OVER(UNDER) EXPEND - 16,632.15 17,685.60 16,632.15 - (16,632.15) 48 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31st, 2017 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 72,500.00 17,402.90 53,502.40 17,402.90 - 55,097.10 24.00% TOTAL Fees 72,500.00 17,402.90 53,502.40 17,402.90 55,09710 24.00% Fund Transfers 000 - 481000 Transfer In -Reserves 81,400.00 - - - - 81,400.00 0.00% TOTAL Fund Transfers 81,400.00 - - - 81,400'.00 0.00 %` Miscellaneous 000 - 491000 Interest Earned 100.00 75.87 3.81 75.87 - 24.13 75.87% 000 - 491200 Investment Interest 3,000.00 1,043.38 679.39 1,043.38 - 1,956.62 34.78% TOTAL Miscellaneous- 3,100.00 1,119.25 683.20 1,119.25 - 1,980`.75 36.10 % '_ TOTAL REVENUES 157,000.00 18,522.15 54,185.60 18,522.15 - 138,477.85 11.80 %' 49 of 64 TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $35,103.43 Cash in Investments MBIA Investment -Tree Mitigation 313,441.19 Total Cash in Bank & Investments $348,544.62 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31st, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 416,628.00 266,994.00 416,628.00 - 683,372.00 37.88% Miscellaneous 40,200.00 16,745.21 6,042.78 16,74521 - 23,454.79 41.65% TOTAL REVENUES 1,140,200.00 433,373.21 273,036.78 433,373`.21 - 706,826.79 38.01% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 484.00 1,000.00 484.00 - 255,516.00 0.19% TOTAL NON DEPARTMENTAL 256,000.00 484.00 1,000.00 484:00 - 255,516.00 0.19 %` MISC & PROJECTS PROJECTS Fund Charges/Transfers 0.00% TOTAL MISC & PROJECTS - - - = - 0.00% TOTAL EXPENDITURES 256,000.00 484.00 1,000.00 484.00 - 255,516.00 0.19% REVENUE OVER(UNDER) EXPENDITURES 884,200.00 432,889.21 272,036.78 432,889.21 451,3110.79 51 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery- Water 1,100,000.00 416,628.00 266,994.00 416,628.00 - 683,372.00 37.88% TOTAL Fees 1,100,000.00 416,628.00 266,994.00 416,628.00 - 683,372.00 37.88% Miscellaneous 000 - 491000 Interest Earned 200.00 898.21 6531 898.21 - (698.21) 449.11% 000 - 491200 Investment Income 40,000.00 15,847.00 5,977.47 15,847.00 - 24,153.00 39.62% TOTAL Miscellaneous 40,200.00 16,745.21 6,042.78 16,745.21 - 23,454.79 41.65 %' TOTAL REVENUES 1,140,200.00 433,373.21 273,036.78 433,373.21 - 706,826.79 38.01 %` 52 of 64 CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 451,259.47 Cash in Investments Lone Star Investment - Capital Recovery Water 4,826,992.15 Total Cash in Bank &!Investments $ 5,278,251.62 53 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000.00 271,198.68 102,165.00 271,199 - 278,80132 49.31% Miscellaneous 40,150.00 9,993.13 (4,52929) 9,993 - 30,156.87 24.89% TOTAL REVENUES 590,150.00 281,191.81 97,635.71 281,191.81 - 308,958.19 47.65% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 335,500.00 1,574.82 2,089.27 1,574.82 - 333,925.18 0.47% TOTAL NON DEPARTMENTAL 335,500.00 1,574.82 2,089.27 1,574.82 - 333,925.18 0.47 %' MISC & PROJECTS Professional Services 150,000.00 - - - - 150,000.00 0.00% TOTAL MISC & PROJECTS 150,000.00 - - - - 150,000.00 0.00 % ' TOTAL EXPENDITURES 485,500.00 1,574.82 2,089.27 1,574`.82 - 483,925.18 0.32 % REVENUE OVER(UNDER) EXPENDITURES 104,650.00 279,616.99 95,546.44 279,616.99 - 54 of 64 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31 st, 2017 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 550,000.00 269,398.68 102,165.00 269,398.68 - 280,60132 48.98% 000 - 455913 Cap Recovery -North Sewer Tr - 1,800.00 - 1,800.00 - (1,800.00) 0.00% TOTAL Fees 550,000.00 271,198.68 102,165.00 271,198:68 278,801.32 49.31% Miscellaneous 000 - 491000 Interest Earned 150.00 706.20 26.88 706.20 - (556.20) 470.80% 000 - 491200 Investment Income 40,000.00 19,984.05 13,668.64 19,984.05 - 20,015.95 49.96% 000 - 491800 Gain /Loss - 411.62 (3,091.80) 411.62 - (411.62) 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (11,108.74) (15,133.01) (11,108.74) - 11,108.74 0.00% TOTAL Miscellaneous 40,150.00 9,99313 (4,529.29) 9,993.13 - 30,156.87 24.89 %' TOTAL REVENUES 590,150.00 281,191.81 97,635.71 281,191.81 - 308,958.19 47.65 % r 55 of 64 CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 383,463.39 Cash in Investments Lone Star Investment - Capital Recovery Sewer 3,749,334.67 Capital One - Investment 1,750,361.36 Total Cash in Bank & Investments $ ;5,883,159.42`' 56 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 6,030,353.00 3,170,219.02 3,397,468.56 3,170,219.02 - 2,860,133.98 52.57% Fund Transfers 487,110.00 - - - - 487,110.00 0.00% Miscellaneous 477,069.00 5,222.40 3,288.26 5,222.40 - 471,846.60 1.09% TOTAL REVENUES 6,994,532.00 3,1!75,441.42 3,400,756.82 3,175,441.42 - 3,819,090.58 i! 45.40 %` EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 2,550.00 550.00 550.00 550.00 - 2,000.00 21.57% Debt Service 6,991,982.00 - - - - 6,991,982.00 0.00% Other Financing Sources - - - - - - 0.00% TOTAL GENERAL GOVERNMENT 6,994,532.00` 550.00 550.00 550.00 - 6,993,982.00 0.01% TOTAL EXPENDITURES ' 6,994,532.00' 550.00 550.00 550.00 - 6,993,982.00 0.01% " REVENUE OVER(UNDER) EXPEND 57 of 64 3,174,891.42 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: December 31st, 2017 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 25% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 6,030,353.00 3,170,219.02 3,397,468.56 3,170,219.02 - 2,860,133.98 52.57% TOTAL Taxes 6;030,35100 3,170,219.02 3,397,468.56 3,`170,219.02 2,860;133.98 52;57% 000- 486000 Transfer From Reserves 487,110.00 - - - - 487,110.00 0.00% TOTAL Fund Transfers 487,110.00 - - 487,110.00 0.00% Miscellaneous 000 - 491000 Interest Earned 300.00 576.67 61.77 576.67 - (276.67) 192.22% 000 - 491200 Investment Earnings 16,000.00 4,645.73 3,226.49 4,645.73 - 11,354.27 29.04% 000 - 495015 Contribution from SED 360,769.00 - - - - 360,769.00 0.00% 000 - 495020 Contribution from YMCA 100,000.00 - - - - 100,000.00 0.00% TOTAL Miscellaneous 477,069.00 5,222.40 3,288.26 5,222.40 - 471,846.60 109 %' TOTAL REVENUES 6,994,532.00 3,175,441.42 3,400,756.82 3;!175,441.42 - 3,819,090.58 45.40% 58 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,550.00 550.00 550.00 550.00 - 2,000.00 21.57% TOTAL Professional Services 2,550.00 550.00 550.00 550.00 2,000.00 21.57 %' Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000.00 - - - - 285,000.00 0.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 38,475.00 - - - - 38,475.00 0.00% 101 - 555629 GO Bond 2007 - Principal 290,000.00 - - - - 290,000.00 0.00% 101 - 555629.1 GO Bond 2007 - Interest 136,345.00 - - - - 136,345.00 0.00% 101 - 555630 GO Bond SR2008 Principal 475,000.00 - - - - 475,000.00 0.00% 101 - 555630.1 GO Bond SR2008 Interest 259,055.00 - - - - 259,055.00 0.00% 101 - 555631 GO Bond SR2009 Principal 550,000.00 - - - - 550,000.00 0.00% 101 - 555631.1 BO Bond SR2009 Interest 249,138.00 - - - - 249,138.00 0.00% 101 - 555633 GO SR2011 Principal 240,000.00 - - - - 240,000.00 0.00% 101 - 555633.1 GO SR2011 Interest 327,038.00 - - - - 327,038.00 0.00% 101 - 555634 GO SR2011A Refund Principal 635,000.00 - - - - 635,000.00 0.00% 101 - 555634.1 GO SR2011A Refund Interest 87,783.00 - - - - 87,783.00 0.00% 101 - 555635 GO SR2012 Principal 335,000.00 - - - - 335,000.00 0.00% 101 - 555635.1 GO SR2012 Interest 168,095.00 - - - - 168,095.00 0.00% 101 - 555636 Tax Note - SR2013 - Principal 170,000.00 - - - - 170,000.00 0.00% 101 - 555636.1 Tax Note - SR2013 - Interest 1,445.00 - - - - 1,445.00 0.00% 101 - 555637 Tax Note - SR 2013A - Principal 165,000.00 - - - - 165,000.00 0.00% 101 - 555637.1 Tax Note - SR2013 - Interest 1,073.00 - - - - 1,073.00 0.00% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000.00 - - - - 100,000.00 0.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 289,775.00 - - - - 289,775.00 0.00% 101 - 555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0.00% 101 - 555639.1 Tax Note - SR2015 - Interest 2,538.00 - - - - 2,538.00 0.00% 101 - 555640 Bond -Ref 2015 Bond- Principal 490,000.00 - - - - 490,000.00 0.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 92,725.00 - - - - 92,725.00 0.00% 59 of 64 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: December 31 st, 2017 505 -TAX I& S GENERAL GOVERNMENT NON DEPARTMENTAL *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR BUDGET QUARTER Y -T -D ACTUAL 2 0 1 7 - 2 0 1 8 CURRENT Y -T -D ACTUAL ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D BUDGET 25% OF ENCUMBR BALANCE BUDGET 101 - 555641.1 Tax Note - SR2015A - Interest 11,550.00 - - - - 11,550.00 0.00% 101 - 555641 Tax Note - SR2015A - Principal 145,000.00 - - - - 145,000.00 0.00% 101 - 555641.1 Tax Note - SR2015A - Interest 11,550.00 - - - - 11,550.00 0.00% 101 - 555642 GO Bond SR2016 Principal 205,000.00 - - - - 205,000.00 0.00% 101 - 555642.1 GO Bond SR2016 Interest 167,607.00 - - - - 167,607.00 0.00% 101 - 555643 CO Bond Tax SR2016 Principal 55,000.00 - - - - 55,000.00 0.00% 101 - 555643.1 CO Bond Tax SR2016 Interest 47,238.00 - - - - 47,238.00 0.00% 101 - 555644 CO Bond nonTax SR2016 Principal 165,000.00 - - - - 165,000.00 0.00% 101 - 555644 CO Bond nonTax SR2016 Interest 69,469.00 - - - - 69,469.00 0.00% 101 - 555645 CO Bond SR2017 Principal 245,000.00 - - - - 245,000.00 0.00% 101 - 555645.1 CO Bond SR2017 Interest 178,689.00 - - - - 178,689.00 0.00% 101 - 555646 Bond -GO SR2017 Principal 135,000.00 - - - - 135,000.00 0.00% 101 - 55646.1 Bond - GO SR2017 Interest 143,944.00 - - - - 143,944.00 0.00% TOTAL Debt Service 6,991,982.00 - - 6,991,982.00 0.00% TOTAL EXPENDITURES 6,994,532.00 550.00 550.00 550.00 - 6,993,982.00 0.01% 60 of 64 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: December 31st, 2017 Cash in Bank Claim on Operating Cash Pool-Checking $ 3,229,393.88 IVIBIA Investment -Tax I&S 1,395,579.67 Total Cash in Bank & Investments $ 4,624,973.55 61 of 64 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: September 30th, 2017 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT BUDGET CURRENT PRIOR YEAR CURRENT Y -T -D QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 100% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,962,572.00 999,460.90 949,418.01 999,460.90 - 2,963,111.10 25.22% Miscellaneous 120,301.00 45,613.11 23,270.42 45,613.11 - 74,687.89 37.92% TOTAL REVENUES 4,082,873.00 1,045,074.01 972,688.43 1,045,074:01 3,037,798.99 25.60 %' EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Supplies 750.00 117.82 186.69 117.82 - 632.18 15.71 % Human Services 500.00 - 345.20 - - 500.00 0.00% City Support Services 37,700.00 1,830.67 2,151.99 1,830.67 128.00 35,741.33 5.20% Utility Services 3,870.00 464.81 595.32 464.81 98.76 3,306.43 14.56% Operations Support 172,000.00 19,689.60 13,474.20 19,689.60 - 152,310.40 11.45% Staff Support 21,900.00 2,211.57 4,188.88 2,211.57 119.75 19,568.68 10.65% City Assistance 817,500.00 200,000.00 47.50 200,000.00 - 617,500.00 24.46% Professional Services 82,500.00 117.00 4,104.00 117.00 - 82,383.00 0.14% Fund Charges/Transfers 1,067,945.00 221,088.00 107,764.69 221,088.00 - 846,857.00 20.70% Maintenance Services 1,000.00 140.00 - 140.00 - 860.00 14.00% Operating Equipment 4,200.00 576.02 - 576.02 - 3,623.98 13.71% TOTAL ECONO DEVELOPMENT 2,209,865.00 446,285.49 132,858.47 446,235.49 346.51 1,763,283.00 20.21% TOTAL EXPENDITURES 2,209,865.00 446,235.49 132,858.47 446,235.49 346.51 1,763,283.00 20.21 %> ** REVENUE OVER(UNDER) EXPEND ` 1,873,008.00 598,838.52 839,829.96 598,838.52 (346:51) 1,274,515.99 62 of 64 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: September 30th, 2017 Cash in Bank Claim on Operating Cash Pool- Checking $ 423,261.03 Cash in Investments Texas Class Investment- Economic Development Corl 12,478,616.00 Schertz Bank & Trust - Certificate of Deposit 1,063,386.74 Total Cash in Bank & Investments $ 13,965,263.77 63 of 64 4B SALES TAX By Collection Month $450,000 $400,000 12% $350,000 - - - - - - - c° to �Fo;:� $300,000 - - - - - - - - - - - - - $250,000 $200,000 - - - - - - - - - - - - - - $150,000 $100,000 $50,000 - - - - - ---- - - ----------- - - - - - - - - - - $ FEB OCT NOV DEC JAN MAR APR MAY JUN JUL AUG SEP x 2017 -18 322,292 343,024 307,585 2016 -17 287,235 379,299 290,086 280,216 373,641 243,369 216,222 334,771 276,770 283,282 348,268 286,986 2015 -16 239,534 372,334 264,843 246,568 391,510 265,249 265,854 307,920 284,254 261,570 2014 -15 247,750 319,452 252,513 210,669 397,691 225,482 247,025 361,702 232,983 248,121 379,939 254,153 64 of 64