The URL can be used to link to this page

Q2-March 2018Quarterly t t t Schertz, Texas MY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) �t AS O M rcth 1 s 2018 80 7 q 7 - 2018 170,200.00 CURRENT CURRENT Y -T D BUDGET BUDGET Y-T -D AC'TUAL ENCUMBR BALANCE 50% OF BUDGET General Fund, 101 Total Expenditures 170,200.00 44,327.84 2,667.44 123,204.72 Total Revenues 31,424,058.43 21,665,629.71 (190.00) 10,686,014.22 65.99% Total General Government 6,723,104.19 3,226,319.04 432,317.11 3,064,468.04 54.42% Total Public Safety 13,565,601.59 6,393,852.08 297,099.73 6,874,649.78 49.32% Total Public Environment 1,353,192.00 563,793.25 159,852.30 629,546.45 53.48% Total Parks & Recreation 1,946,281.81 650,699.63 93,297.39 1,202,284.79 3823% Total Cultural 921,998.00 478,512.77 11,478.48 432,006.75 53.14% Total Health 901,147.00 294,611.51 29,885.25 576,045.24 36.01% Total Internal Services 5,696,878.40 2,518,766.41 237,573.65 2,961,310.14 48.38% Total Misc & Projects 315,855.00 129,824.13 72,202.15 113,828.72 63.96% Total Expenditures 31,424,057.99 14,256,378.82 1,333,706.06 15,854,139.91 49.61% Revenue Over(Under) Expenditures 0.44 7,409,250.89 23,138,974.00 10,675,140.46 604,520.47 11,859,313.07 General Fund, 101 Total Cash in Bank & Investments Revenue Over(Under) Expenditures 17,901,647.48 (486,304.00) 577,169.92 Total Revenues 170,200.00 33,651.43 (40.00) 136,628.57 19.72% Total Expenditures 170,200.00 44,327.84 2,667.44 123,204.72 27.61% Revenue Over(Under) Expenditures 0.00 (10,676.41) Special Events Fund, 106 Total Cash in Bank & Investments 73,849.70 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 11,252,310.38 - 11,400,359.62 49.67% Total Expenditures 23,138,974.00 10,675,140.46 604,520.47 11,859,313.07 48.75% Revenue Over(Under) Expenditures (486,304.00) 577,169.92 Water & Sewer, 202 Total Cash in Bank & Investments 7,528,583.21 CH'Y OF SCHERTZ REVENUE AND EXPENSE REPORT(U?',IAUDITIED) Quarterly Statement AS OFAIlarch, 31st, 2018 2017 - 2018 Schell Texas CURRENT CURRENT Y-T-D BUDr,'7ET 50% OF BUDGET Y-T-D ACTUAL, ENCUMBR BAI.ANCE BUDGET EMS, 203 Total Revenues 9,020,712.72 4,518,107.55 (65,00) 4,502,670.17 50.09% Total Expenditures 9,007,172.81 4,314,849.11 747,515.04 3,944,808.66 56.20% Revenue Over(Under) Expenditures 13,539.91 203,258.44 EMS, 203 Total Cash in Bank & Investments 386,853.52 Drainage, 204 Total Revenues 2,763,927.00 762,979.57 - 2,000,947.43 27.60% Total Expenditures 2,933,927.00 661,193.07 1,042.98 2,271,690.95 22.57% Revenue Over(Under) Expenditures (170,000.00) 101,786.50 Drainage, 204 Total Cash in Bank & Investments 1,124,713.32 Hotel Tax, 314 Total Revenues 563,650.00 181,895.81 - 381,754.19 32.27% Total Expenditures 322,836.00 102,740.86 25,712.16 194,382.98 39.79% Revenue Over(Under) Expenditures 240,814.00 79,154.95 Hotel Tax, 314 Total Cash in Bank & Investments 1,549,480.15 Park, 317 Total Revenues 239,829.69 26,758.68 - 103,241.32 20.58% Total Expenditures 239,829.69 59,139.06 107,672.88 73,017.75 69.55% Revenue Over(Under) Expenditures 0.00 (32,380.38) Park, 317 Total Cash in Bank & Investments 335,430.81 Tree Mitigation, 319 Total Revenues 157,000.00 35,664.87 121,335.13 22.72% Total Expenditures 157,000.00 2,443.00 154,557.00 1.56% Revenue Over(Under) Expenditures 0.00 33,221.87 Tree Mitigation, 319 Total Cash in Bank & Investments 340,748.36 Capital Recovery Water, 411 Total Revenues 1,140,200.00 874,579.90 265,620.10 76.70% Total Expenditures 256,000.00 1'000.00 255,000.00 0.39% [Revenue Over(Under) Expenditures 884,200.00 873,579.90 lCapital Recovery Water, 411 Total Cash in Bank & Investments 5,718,942.31 Quarterly Statement Sc hertz, Texas XXXXXXXXXYXX CH'Y OF SCHERTZ REVENUE AND EXPENSE REPORT(WIMUDITMD) AS OFAIlarch, 31st, 01 .K;F ; 'fi'fi'frKK YX K'Y x its 2017 2018 {x+v ktxi e3,i >:v' d4rX .4 .4 .4 8t tt 1 :.:Si 6,363,367.26 CURRENT CURRENT Y -T -D BUDr,'7E BUDGET Y T -D ACTUAL, ENCUMBR BAI ANCE 50% OF BUDGET Capital Recovery Sewer, 421 6,994,532.00 1 1 - 1,377,417.92 80.31 % Total Revenues 949,850.00 496,607.29 - 453,242.71 5228% Total Expenditures 695,200.00 3,179.23 - 692,020.77 0.46% Revenue Over(Under) Expenditures 254,650.00 493,428.06 Capital Recovery Sewer, 421 Total Cash in Bank & Investments 6,096,970.49 2,137,855.95 - 1,945,017.05 49.63% Total Revenues 6,994,532.00 6,363,367.26 - 631,164.74 90.98% Total Expenditures 6,994,532.00 5,617,114.08 - 1,377,417.92 80.31 % Revenue Over(Under) Expenditures 0.00 746,253.18 1 &S, 505 Total Cash in Bank & Investments 2,196,335.31 SED Corporation, 620 Total Revenues 4,307,873.00 2,137,855.95 - 1,945,017.05 49.63% Total Expenditures 2,434,865.00 1,066,275.75 282.90 1,368,306.35 43.80% Revenue Over(Under) Expenditures 1,873,008.00 1,071,580.20 SED Corporation, 620 Total Cash in Bank & Investments 15,400,624.60 Total Cash in Bank & Investments 59,292,685.32 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 19,581,110.00 7,430,054.46 14,470,014.51 15,767,851.10 - 3,813,258.90 80.53% Franchises 2,229,264.43 497,712.96 1,000,904.64 1,085,304.92 - 1,143,959.51 48.68% Permits 1,402,956.00 593,580.20 927,395.50 1,118,226.24 - 1,212,125.26 13.60% Licenses 51,160.00 17,197.50 34,207.50 31,000.00 - 20,160.00 60.59% Fees 2,126,546.00 678,663.49 1,274,931.49 1,205,021.15 (190.00) 921,714.85 56.66% Fines 20,000.00 6,783.64 11,279.78 11,964.08 - 8,035.92 59.82% Inter - Jurisdictional 873,008.00 263,512.48 431,152.43 399,434.46 - 473,573.54 45.75% Fund Transfers 4,484,614.00 769,914.66 1,207,877.48 1,539,829.20 - 2,944,784.80 34.34% Miscellaneous 655,400.00 317,336.98 273,731.05 506,998.56 - 148,401.44 77.36% TOTAL REVENUES 31,424,058.43 10,574,756.37 19,631,494.38 21,665,629171 (190!.00) 10,686,014.22 65.99% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 34,699.00 8,203.39 14,856.59 17,574.26 14.40 17,110.34 50.69% Supplies 1,050.00 62.91 136.78 62.91 - 987.09 5.99% City Support Services 41,393.00 6,067.60 33,581.20 17,256.97 216.05 23,919.98 42.21% Utility Services 641.47 148.28 - 267.48 49.45 324.54 49.41% Operations Support 500.00 - 336.04 29.00 19.99 451.01 9.80% Staff Support 28,868.53 9,645.15 18,653.89 21,926.49 103.24 6,838.80 76.31% Operating Equipment - 723.00 - - - 0.00% TOTAL CITY COUNCIL 107,152.00 24,127.33 68,287.50 57,117.11 403.13 49,631.76 53.68 %< CITY MANAGER Personnel Services 1,088,445.00 452,044.12 488,617.66 765,122.93 - 323,322.07 70.30% Supplies 2,000.00 188.71 548.92 440.50 - 1,559.50 22.03% City Support Services 12,674.32 4,939.93 4,989.85 4,939.93 - 7,734.39 38.98% Utility Services - 305.51 65.99 575.28 - (575.28) 0.00% Staff Support 27,060.68 7,295.96 8,646.18 10,986.99 997.62 15,076.07 44.29% TOTAL CITY MANAGER 1,130,180.00 464,774.23 502,868'.60 782,065.63 997:62 347,116.75 69.29 %s CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 288,987.00 68,937.94 139,829.65 152,679.33 - 136,307.67 52.83% Supplies 2,000.00 200.43 442.35 558.20 - 1,441.80 27.91% City Support Services 1,000.00 - 37.78 157.86 - 842.14 15.79% Operations Support 3,250.00 69.00 - 69.00 - 3,181.00 2.12% Staff Support 8,510.00 560.67 978.13 2,053.31 160.16 6,296.53 26.01% Court Support 700.00 102.00 186.00 102.00 - 598.00 14.57% Professional Services 67,960.00 13,306.71 28,150.00 28,306.71 12,400.00 27,253.29 59.90% Maintenance Services 3,000.00 500.00 1,470.00 1,000.00 2,000.00 - 100.00% Operating Equipment - - 39.02 - - - 0.00% TOTAL MUNICIPAL COURT 375,407.00 83,676.75 171,132.93 184,926.41 14,560.16 175,920.43 53.14% CUSTOMER RELATIONS -311 Personnel Services 115,904.00 26,857.81 56,650.70 61,026.02 - 54,877.98 52.65% Supplies 150.00 12.53 40.30 68.93 - 81.07 45.95% Staff Support 815.00 - 99.00 - - 815.00 0.00% Operating Equipment 600.00 554.62 - 554.62 - 45.38 92.44% TOTAL CUSTOMER RELATIONS -311 117,469.00 27,424.96 56,790.00 61,649.57 - 55,819.43 52.48% PLANNING & ZONING Personnel Services 202,011.00 49,124.17 90,953.26 104,142.97 - 97,868.03 51.55% Supplies 3,300.00 64.88 270.49 199.06 - 3,100.94 6.03% Operations Support 150.00 7.20 13.50 7.20 - 142.80 4.80% Staff Support 25,490.00 2,817.92 3,553.79 3,827.92 520.00 21,142.08 17.06% Professional Services 100.00 - 89 - 100.00 0.00% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL PLANNING & ZONING 231,301.00 52,014.17 94,880.04 108,177.15 520.00 122,603.85 46.99% LEGAL SERVICES Operations Support 5,000.00 355.45 559.66 687.29 - 4,312.71 13.75% Professional Services 155,000.00 35,162.63 28,715.18 46,802.11 - 108,197.89 30.19% TOTAL LEGAL SERVICES 160,000.00 35,518:08 29,274 84 47,489,40 - 112,510.60 29.68% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET CITY SECRETARY Personnel Services 177,703.00 43,371.22 85,895.44 94,244.05 - 83,458.95 53.03% Supplies 1,050.00 284.67 786.81 616.86 - 433.14 58.75% City Support Services 8,500.00 - 2,025.03 2,059.17 - 6,440.83 24.23% Operations Support 100.00 47.00 - 47.00 - 53.00 47.00% Staff Support 6,650.00 1,192.35 2,430.44 2,156.98 - 4,493.02 32.44% TOTAL CITY SECRETARY 194,003.00 44,895.24 91,137.72 99,124.06 - 94,878.94 51.09% NON - DEPARTMENTAL City Support Services 764,092.19 57,407.44 276,441.94 284,453.40 101,946.15 377,692.64 50.57% Operations Support 154,500.00 33,171.91 11,395.15 69,996.73 1,560.84 82,942.43 46.32% Staff Support 320.00 - 165.50 80.00 - 240.00 25.00% City Assistance 1,741,562.00 584,963.75 739,817.78 720,318.28 278,162.50 743,081.22 57.33% Professional Services 44,635.00 9,429.67 27,559.93 30,398.65 29,689.00 (15,452.65) 134.62% Fund Chrgs /Transfrs -Spec Events Fnd 93,733.00 - - - - 93,733.00 0.00% TOTAL NON- DEPARTMENTAL 2,798,842.19 684,972.77 1,055,380.30 1,105,247.06 411,358.49 1,282,236.64 54.19 %ii CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 283,164.00 64,529.38 131,924.42 145,094.37 - 138,069.63 51.24% Supplies 2,000.00 349.54 544.74 798.34 - 1,201.66 39.92% Operations Support 29,450.00 5,312.19 5,219.90 6,807.49 600.00 22,042.51 25.15% Staff Support 3,730.00 521.74 699.00 670.74 960.00 2,099.26 43.72% Professional Services - - 22,900.00 - - - 0.00% TOTAL PUBLIC AFFAIRS 31!8,344.00 70,712.85 161,288.06 153,370.94 1,560.00 163,41106 48.67 %` RECORDS MANAGEMENT Personnel Services 53,654.00 11,109.30 22,246.83 22,500.59 - 31,153.41 41.94% Supplies 100.00 - 31.22 - - 100.00 0.00% Staff Support 355.00 - - - 179.00 176.00 50.42% Professional Services 12,000.00 2,335.13 4,712.55 4,403.22 7,596.78 36.69% TOTAL RECORDS MANAGEMENT - 66,109.00 13,444.43 26,990.60 26,903,81 179.00 39,026.19 40.97 %' SCHERTZ MAGAZINE Personnel Services 123,853.00 30,102.05 64,488.88 63,669.39 - 60,183.61 51.41% Supplies 200.00 - 29.49 - - 200.00 0.00% Opperations Support 2,600.00 953.92 - 953.92 338.81 1,307.27 49.72% Staff Support 3,330.00 1,390.19 496.00 1,390.19 85.00 1,854.81 44.30% Professional Services 255,500.00 60,300.59 127,436.55 132,936.93 - 122,563.07 52.03% Fund Charges /Transfers 10,000.00 - - - 10,000.00 0.00% TOTAL SCHERTZ MAGAZINE 395,483.00 92,746.75 192,450.92 198,950.43 423.81 196,108.76 50.41 %` ENGINEERING Personnel Services 589,714.00 142,858.85 190,153.77 309,267.19 - 280,446.81 52.44% Supplies 1,620.00 181.92 124.96 246.36 38.00 1,335.64 17.55% City Support Services 650.00 - - - 650.00 - 100.00% Utility Services 3,500.00 579.35 282.14 988.09 - 2,511.91 28.23% Operations Support - - 35.98 47.70 - (47.70) 0.00% Staff Support 11,475.00 1,138.17 772.79 1,415.68 585.00 9,474.32 17.44% Professional Services 51,967.00 2,742.50 27,986.40 2,652.50 - 49,314.50 5.10% Rental /Leasing - - 2,824.47 - - - 0.00% Operating Equipment 400.00 - - - - 400.00 0.00% TOTAL ENGINEERING 659,326.00 147, 500.79 222,180.51 314,617.52 1,273.00 343,435.48 47.91% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 161,063.00 38,393.29 74,312.44 84,482.66 - 76,580.34 52.45% Supplies 1,740.00 208.47 - 208.47 - 1,531.53 11.98% Staff Support 4,600.00 946.92 931.80 946.92 - 3,653.08 20.59% Rental /Leasing 2,085.00 520.95 868.25 1,041.90 1,041.90 1.20 0.00% TOTAL GIS'i 169,488.00 40,069:63 76,112:49 86,679.95 1,041.90 81,76615 51.76 %' TOTAL GENERAL GOVERNMENT 6,723,104.19 1,781,877.98 2,748,774.51 3,226,319.04 432,317.11 3,064,468.04 54.42% PUBLIC SAFETY POLICE Personnel Services 6,429,458.00 1,406,48330 2,875,235.95 3,140,798.94 - 3,288,659.06 48.85% Supplies 65,446.80 28,090.35 19,710.25 30,715.33 2,499.38 32,232.09 50.75% City Support Services 21,500.00 - 21,294.42 24,229.52 - (2,729.52) 112.70% Utility Services 111,957.00 18,028.28 30,114.51 31,283.81 - 80,673.19 27.94% Operations Support 7,935.00 550.00 1,443.75 814.25 1,836.16 5,284.59 33.40% Staff Support 148,758.43 22,011.29 26,783.05 43,994.61 6,551.14 98,212.68 33.98% City Assistance 13,222.00 3,154.40 6,462.67 4,421.62 79.98 8,720.40 34.05% Professional Services 49,948.00 13,262.10 27,518.37 25,272.41 5,147.50 19,528.09 60.90% Maintenance Services 57,645.00 17,548.49 20,905.48 24,293.49 - 33,351.51 42.14% Rental /Leasing - - 44,219.48 - - - 0.00% Operating Equipment 56,923.80 21,455.67 85,219.48 21,455.67 4,026.70 31,441.43 44.77% Capital Outlay 552,317.56 9,872.09 - 262,196.48 155,366.38 134,754.70 75.60% TOTAL POLICE 7,515,111.59 1,540,455.97 3,158,907:41 3;609,476:13 175,507.24 3;730,12822 50.36% FIRE RESCUE Personnel Services 4,186,534.00 913,475.00 1,713,834.73 2,027,926.35 - 2,158,607.65 48.44% Supplies 19,550.00 2,996.69 2,779.66 3,670.79 649.68 15,229.53 22.10% Utility Services 52,300.00 9,994.16 19,492.56 16,628.08 250.70 35,421.22 32.27% Operations Support 550.00 58.00 - 58.00 - 492.00 10.55% Staff Support 167,875.00 58,892.57 84,007.78 82,643.99 7,431.58 77,799.43 53.66% City Assistance 20,000.00 2,510.73 2,557.85 3,592.92 - 16,407.08 17.96% Professional Services 33,500.00 - - 4,900.00 18,525.00 10,075.00 69.93% Maintenance Services 73,000.00 9,457.94 12,287.94 9,927.83 2,590.46 60,481.71 17.15% Other Costs - - - 102.05 - (102.05) 0.00% Rental/Leasing 23,500.00 3,950.82 8,014.01 8,014.01 7,901.64 7,584.35 67.73% Operating Equipment 107,800.00 4,039.32 37,169.32 16,850.23 10,978.08 79,971.69 25.81% Capital Outlay 97,000.00 34,880.40 37,207.23 34,880.40 34,615.00 27,504.60 71.64% TOTAL FIRE RESCUE 4,781,609.00 1,040,255.63 1,917,351.08 2;209,194165 82,942.14 2,489,472.21 47.94 %i' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 633,629.00 143,246.83 274,618.20 312,957.23 - 320,671.77 49.39% Supplies 4,100.00 116.76 1,622.72 603.66 182.48 3,313.86 19.17% Utility Services 5,000.00 920.98 1,231.27 1,779.71 - 3,220.29 35.59% Operations Support 2,000.00 310.00 968.51 523.00 - 1,477.00 26.15% Staff Support 28,180.00 2,323.98 6,820.89 4,266.06 157.93 23,756.01 15.70% Professional Services 100,000.00 43,590.00 85,750.00 64,190.00 35,810.00 - 100.00% Operating Equipment 5,500.00 4,014.09 - 4,014.09 - 1,485.91 72.98% TOTAL INSPECTIONS 778,409.00 194,522.64 371,011.59 388,333.75 36,150.41 353,924.84 54.53% MARSHAL'S OFFICE Personnel Services 451,997.00 79,694.75 228,072.76 176,741.85 - 275,255.15 39.10% Supplies 3,475.00 2,346.93 1,219.59 2,619.70 - 855.30 75.39% Utility Services 8,500.00 1,344.11 2,381.55 2,343.97 - 6,156.03 27.58% Operations Support 1,000.00 - - - 109.96 890.04 11.00% Staff Support 11,900.00 1,311.57 1,148.11 1,599.51 2,145.03 8,155.46 31.47% City Assistance 3,750.00 - - - - 3,750.00 0.00% Maintenance Services 5,100.00 1,000.00 800.00 1,000.00 156.00 3,944.00 22.67% Operating Equipment 4,750.00 2,542.52 17,483.79 2,542.52 88.95 2,118.53 55.40% TOTAL MARSHAL'S OFFICE 490,472.00 88,239.88 251,105.80 186,847.55 2,499.94 301,124.51 38.61 %? TOTAL PUBLIC SAFETY 13,565,601.59 2,863,474.12 5,698,375.88 6,393,852.08 297,099.73 6,874,649.78 49.32°la'' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT PARKS DEPARTMENT STREETS Personnel Services 526,297.00 111,207.91 243,442.61 242,188.15 - Personnel Services 783,442.00 181,560.93 65,550.00 367,242.28 404,111.35 33,484.66 - 379,330.65 51.58% City Support Services Supplies 66,850.00 23,767.54 2,625.30 16,304.74 38,390.09 2,954.56 Utility Services 25,505.35 61.85% 101,933.37 Utility Services 149,200.00 41,041.39 36.94% 65,541.72 68,377.14 500.00 551.40 80,322.86 46.16% 121.03 Staff Support 11,250.00 3,281.19 3,389.82 4,465.47 4,612.23 962.79 - 6,637.77 41.00% 137,500.00 Professional Services 15,750.00 7,937.00 5,967.52 5,037.50 7,937.00 Maintenance Services - 7,813.00 50.39% 12,978.31 Maintenance Services 85,000.00 79.28% - 21,032.94 - 19,023.40 - 85,000.00 0.00% 93.74% Rental /Lease 4,000.00 2,615.32 4,924.13 259.00 2,895.32 (4,825.05) - 1,104.68 72.38% 8,100.00 Operating Equipment 15,300.00 4,209.74 591.78 1,515.99 4,209.74 1,100,329.81 - 11,090.26 27.51% 87,875.09 Capital Outlay 222,400.00 28,498.50 5,300.00 33,260.38 156,397.74 32,741.88 85.28% Supplies TOTAL STREETS 1,353,192.00 292,911.61 5,756.13 486,699.64 563,793.25 159,852.30 Utility Services 629,546.45 53.48% 11,633.67 TOTAL PUBLIC ENVIRONMENT 1,353,192.00 292,911.61 486,699.64 563,793.25 159,852.30 629,546.45 53.48% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 526,297.00 111,207.91 243,442.61 242,188.15 - 284,108.85 46.02% Supplies 65,550.00 19,748.69 10,107.09 33,484.66 4,887.29 27,178.05 58.54% City Support Services 10,357.81 2,047.30 5,575.93 2,625.30 1,084.53 6,647.98 35.82% Utility Services 222,000.00 56,923.68 101,933.37 82,006.71 - 139,993.29 36.94% Operations Support 1,000.00 878.97 551.40 878.97 - 121.03 87.90% Staff Support 9,850.00 3,389.82 5,327.31 4,492.63 962.79 4,394.58 55.38% Professional Services 137,500.00 1,290.00 39,439.95 20,780.00 5,967.52 110,752.48 19.45% Maintenance Services 17,000.00 7,673.30 15,133.44 12,978.31 500.00 3,521.69 79.28% Rental /Leasing 29,675.00 9,701.96 19,023.40 18,759.44 9,057.48 1,858.08 93.74% Operating Equipment 10,100.00 5,450.57 4,924.13 5,639.25 9,285.80 (4,825.05) 147.77% Capital Outlay 71,000.00 8,100.00 - 14,278.54 56,129.68 591.78 99.17% TOTAL PARKS DEPARTMENT 1,100,329.81 226, 412.20 445,458563 438,111.96 87,875.09 574,342.76 47.80 %? SWIM POOL Supplies 21,100.00 3,93534 7,823.77 5,756.13 133.03 15,210.84 27.91% Utility Services 21,000.00 4,189.97 11,633.67 5,313.74 - 15,686.26 25.30% Maintenance Services 651,878.00 59,878.31 106,500.17 144,747.43 1,866.55 505,264.02 22.49% TOTAL SWIM POOL 693,978.00 68,003,62 125,957.61 155,817,30 1,999.58 536,161.12 22.74% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 60,584.00 14,239.41 28,808.48 30,174.73 - 30,409.27 49.81% Supplies 4,500.00 503.86 1,544.64 1,817.54 655.97 2,026.49 54.97% Utility Services 52,600.00 8,993.23 17,113.84 15,418.20 - 37,181.80 29.31% Operations Support 10,700.00 3,800.00 1,102.53 3,814.59 - 6,885.41 35.65% Staff Support 2,090.00 290.54 1,305.48 320.54 - 1,769.46 15.34% Operating Equipment 21,500.00 4,539.80 (1,850.61) 5,224.77 2,766.75 13,508.48 37.17% TOTAL EVENT FACILITIES ` 151,974.00 32,366.84 48,024.36 56,770.37 3,422.72 91,780.91 39.61 %' TOTAL PARKS &?RECREATION 1,946,281.81 326,782.66 619,440.60 650,699.63 93,297.39 1,202,284.79 3823% CULTURAL LIBRARY Personnel Services 728,148.00 176,147.87 341,691.56 385,341.56 - 342,806.44 52.92% Supplies 15,500.00 910.43 5,645.78 3,301.50 2,064.44 10,134.06 34.62% Utility Services 55,500.00 10,646.26 12,856.93 17,258.13 - 38,241.87 31.10% Operations Support 4,200.00 2,117.97 879.95 2,599.95 31.98 1,568.07 62.67% Staff Support 7,375.00 1,203.85 1,705.73 2,331.46 1,539.95 3,503.59 52.49% Professional Services 2,275.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 31,178.61 53,644.35 65,362.17 7,842.11 34,295.72 68.10% TOTAL LIBRARY 921,998.00 222,204.99 418,676.30 478,512.77 11,478.48 432,006.75 53.14 %` TOTAL CULTURAL 921,998.00 222,204.99 418,676'.30 478,512`.77 11,478'_48 432,006.75 53.14°% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 338,061.00 68,410.55 157,088.19 145,141.00 - 192,920.00 42.93% Supplies 33,380.00 7,361.81 13,049.89 15,442.37 554.33 17,383.30 47.92% City Support Services 3,500.00 675.68 2,052.13 675.68 - 2,824.32 19.31% Utility Services 54,500.00 11,026.47 19,739.35 16,498.73 - 38,001.27 30.27% Operations Support 1,000.00 - 690.00 256.07 - 743.93 25.61% Staff Support 10,750.00 1,212.00 1,983.61 2,364.60 327.88 8,057.52 25.05% City Assistance 18,500.00 3,886.18 5,886.43 6,512.27 - 11,987.73 35.20% Professional Services 24,500.00 2,914.91 7,021.26 7,531.01 255.00 16,713.99 31.78% Maintenance Services 43,380.00 800.00 7,189.52 1,775.00 - 41,605.00 4.09% Operating Equipment 31,000.00 84.97 1,510.66 334.97 - 30,665.03 1.08% Capital Outlay 62,000.00 - 27,870.00 - - 62,000.00 0.00% TOTAL ANIMAL SERVICES 620,571.00 96,372.57 244,081.04 196,531.70 1,137121 422,902.09 31.85 %?' ENVIRONMENTAL HEALTH Personnel Services 218,926.00 35,166.14 85,556.17 88,203.06 - 130,722.94 40.29% Supplies 3,095.00 228.99 312.56 284.95 188.50 2,621.55 15.30% Operations Support 1,800.00 - 43.29 76.00 174.00 1,550.00 13.89% Staff Support 7,350.00 450.07 2,353.49 2,279.26 409.54 4,661.20 36.58% City Assistance 1,000.00 - 201.47 94.80 - 905.20 9.48% Professional Services 5,500.00 2,525.00 176.00 2,525.00 2,150.00 825.00 85.00% Maintenance Services 15,000.00 925.00 2,485.00 2,950.00 221.00 11,829.00 21.14% Operating Equipment 2,300.00 1,666.74 433.44 1,666.74 - 633.26 72.47% Capital Outlay 25,605.00 - - 25,605.00 - 100.00% TOTAL ANIMAL SERVICES 280,576.00 40,961.94 91,561.42 98,079.81 28,748.04 153,748.15 45.20°/% TOTAL HEALTH ' 901,147.00 137,334.51 335,642.46 294,611`.51 29,885:25 576,650.24 36.01% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 539,540.00 137,891.68 215,740.40 276,956.60 - 262,583.40 51.33% Supplies 7,100.00 1,906.20 1,625.50 6,005.25 193.08 901.67 87.30% City Support Services 1,043,327.40 188,118.59 235,706.88 293,149.29 2,771.30 747,406.81 28.36% Utility Services 210,474.00 50,018.69 91,135.76 89,560.17 6,872.14 114,041.69 45.82% Staff Support 40,000.00 2,735.47 15,589.70 16,903.19 1,827.31 21,269.50 46.83% Professional Services 16,000.00 - - - - 16,000.00 0.00% Maintenance Services 14,692.00 680.07 4,772.38 1,629.52 - 13,062.48 11.09% Rental /Leasing - - 22,193.43 - - - Operating Equipment 251,860.00 104,099.88 115,438.86 136,384.07 10,127.36 105,348.57 58.17% TOTAL INFORMATION TECHNOLOGY 2,122,993.40 485, 450.58 702,202.91 820,588`.09 21,791:19 1,280,614.12 39.68 %' HUMAN RESOURCES Personnel Services 353,475.00 94,816.62 150,218.19 204,786.68 - 148,688.32 57.94% Supplies 1,000.00 167.23 188.08 246.22 134.96 618.82 38.12% Human Services 74,500.00 17,618.28 24,303.45 26,021.03 16,073.70 32,405.27 56.50% City Support Services 204.36 - - 204.36 - - 100.00% Utility Services 455.88 151.96 - 227.94 227.94 50.00% Operations Support 9,339.76 112.72 3,146.44 5,968.55 42.50 3,328.71 64.36% Staff Support 15,000.00 936.72 2,268.44 1,335.38 3,458.58 10,206.04 31.96% City Assistance 10,000.00 1,610.00 2,862.00 2,585.00 375.00 7,040.00 29.60% Professional Services 9,600.00 2,459.25 4,968.50 4,693.50 4,468.50 438.00 95.44% Operating Equipment 1,000.00 67.80 - - 1,000.00 0.00% TOTAL HUMAN RESOURCES 474,575.00 117,872.78 188,022.90 246,068.66 24,553.24 203,953.10 57.02% FINANCE Personnel Services 584,989.00 115,900.94 272,522.50 285,351.20 - 299,637.80 48.78% Supplies 4,160.00 906.03 2,803.48 1,879.91 - 2,280.09 45.19% City Support Services - 138.00 - 138.00 - (138.00) 0.00% Operations Support 2,155.00 - 1,880.66 - - 2,155.00 0.00% Staff Support 9,495.00 - 1,015.00 2,269.26 2,294.06 4,931.68 48.06% Professional Sevices 31,970.00 8,753.00 - 16,005.00 - 15,965.00 50.06% Operating Equipment 3,770.00 59.99 - - 3,770.00 0.00% TOTAL FINANCE 636,539.00 125,697.97 278,281`.63 305,643.37 2,294.06 328,601.57 48.38% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT 810,968.00 172,067.84 378,983.61 375,569.01 - 435,398.99 46.31% Supplies Personnel Services 207,405.00 49,391.49 72,878.55 108,428.62 47,189.34 - 98,976.38 52.28% Supplies 1,050.00 32.61 104.82 113.21 26.00 Operation Support 910.79 13.26% Utility Services 250.00 48.40 61.50 95.02 Staff Support - 154.98 38.01% Operations Support 150.00 - 26.35 - 24.95 6,204.40 125.05 16.63% Staff Support 6,600.00 1,442.74 1,370.52 2,102.74 63.95 178,823.66 4,433.31 32.83% City Assistance 3,000.00 105.00 765.00 172.00 67.00 3,823.34 2,761.00 7.97% Capital Outlay 29,000.00 - - - 28,058.22 1,760.03 941.78 96.75% TOTAL PURCHASING & ASSET MGT 247,455.00 51,020.24 75,206.74 110,911` >.59 28,240:92 33,683.56 108,303.29 56.23°/x' FLEET SERVICE 350,010:63 680,302.54 699,611.53 94,034.01 659,537.46 54.61 %< TOTAL INTERNAL SERVICE 5,696,878.40 Personnel Services 337,173.00 71,141.70 163,218.06 158,304.54 48.38 %' - 178,868.46 46.95% Supplies 161,500.00 28,236.08 88,794.21 62,487.43 8,340.81 90,671.76 43.86% City Support Services 6,500.00 - 2,354.40 2,826.44 - 3,673.56 43.48% Utility Services 7,000.00 2,007.71 3,255.73 3,426.76 - 3,573.24 48.95% Operations Support 200.00 - 59.69 - - 200.00 0.00% Staff Support 19,810.00 1,850.68 3,570.70 5,629.69 536.40 13,643.91 31.13% Maintenance Services 132,750.00 40,464.19 85,410.20 101,971.45 1,634.60 29,143.95 78.05% Operating Equipment 8,200.00 - 3,122.74 1,296.86 - 6,903.14 15.82% Capital Outlay 89,000.00 - - - 56,149.22 32,850.78 63.09% TOTAL FLEET SERVICE 762,13100 143,700.36 349,785`.73 335,94117 66,661.03 359,528.80 52.83% FACILITY SERVICES Personnel Services 810,968.00 172,067.84 378,983.61 375,569.01 - 435,398.99 46.31% Supplies 110,500.00 32,183.57 55,072.39 57,315.53 5,995.13 47,189.34 57.29% Utility Services 159,515.00 41,128.61 57,771.67 65,998.97 - 93,516.03 41.37% Operation Support - 3,972.66 - 10,058.80 10,713.00 (20,771.80) 0.00% Staff Support 14,200.00 2,314.71 7,440.52 3,932.57 498.64 9,768.79 31.21% Professional Services 50,665.12 6,204.40 - 12,191.21 6,646.00 31,827.91 37.18% Maintenance Services 202,334.88 88,806.85 178,823.66 170,722.10 8,867.30 22,745.48 88.76% Rental /Leasing 5,000.00 3,331.99 2,210.69 3,823.34 237.47 939.19 81.22% Operating Equipment 7,000.00 - - - 1,760.03 5,239.97 25.14% Capital Outlay 93,000.00 - - - 59,316.44 33,683.56 63.78% TOTAL BUILDING MAINTENANCE 1,453,183.00 350,010:63 680,302.54 699,611.53 94,034.01 659,537.46 54.61 %< TOTAL INTERNAL SERVICE 5,696,878.40 1,273,752.56 2,273,802.45 2,518,766..41 237,573.65 2,940,538.34 48.38 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 293,872.00 59,134.19 123,018.85 129,824.13 69,667.15 94,380.72 67.88% TOTAL CITY ASSISTANCE 293,872.00 59,134.19 123,018.85 4129,82413 69,667.15 94,380.72 67.88% COURT - RESTRICTED FUNDS Operating Equipment 21,983.00 - 357.00 - 2,535.00 19,448.00 11.53% TOTAL CITY ASSISTANCE 21,983.00 - 357.00 - 2,535.00 19,448.00 11.53% TOTAL MISC & PROJECTS 315,855.00 59,134.19 123,375:85 129,824.13 72,202 15 113,828.72 63.96 %' TOTAL EXPENDITURES 31,424,057.99 6,957,472.62 12,704,787.69 14,256,378`.82 1,333,706.06 15,833,973.11 49.61% REVENUE OVER(UNDER) EXPEND. 0.44 < 7,409,250'.89 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,726,025.00 5,430,626.24 10,938,496.60 11,614,505.26 - 111,519.74 99.05% 000 - 411200 Advalorem Tax - Delinquent 50,000.00 19,182.01 (15,187.90) 24,272.95 - 25,727.05 48.55% 000 - 411300 Advalorem Tax - P &I 50,000.00 44,846.21 25,957.14 49,596.70 - 403.30 99.19% 000 - 411500 Sales Tax Revenue -Gen Fund 7,711,085.00 1,924,425.04 3,498,360.30 4,057,557.64 - 3,653,527.36 52.62% 000 - 411600 Bingo Tax - - 31.25 11.25 - (11.25) 0.00% 000 - 411700 Mixed Beverage Tax 44,000.00 10,974.96 22,357.12 21,907.30 - 22,092.70 49.79% TOTAL Taxes 19,581,110.00 7,430,054.46 14,470,014.51 15,767,851.10 - 3,813,258.90 80.53% Franchises 000 - 421200 Center Point /Entex Energy 67,793.07 24,379.16 39,113.20 40,586.75 - 27,206.32 59.87% 000 - 421220 City Public Service 946,887.77 210,567.36 390,254.51 442,149.47 - 504,738.30 46.70% 000 - 421240 Guadalupe Valley Elec Co -op 416,134.03 91,256.19 192,834.80 194,571.76 - 221,562.27 46.76% 000 - 421250 New Braunfels Utilities 75,393.90 16,326.20 31,088.73 32,271.44 - 43,122.46 42.80% 000 - 421300 Time Warner -State Franchise 269,019.90 54,350.16 134,749.42 109,373.58 - 159,646.32 40.66% 000 - 421460 AT &T Franchise Fee 191,123.61 49,551.72 90,057.71 102,965.49 - 88,158.12 53.87% 000 - 421480 Other Telecom Franchise 113,964.44 13,803.87 52,345.65 89,305.15 - 24,659.29 78.36% 000 - 421500 Solid Waste Franchise Fee 148,947.71 37,478.30 70,460.62 74,081.28 - 74,866.43 49.74% TOTAL Franchises 2,229,264.43 497,712.96 1,000,904.64 1,085,304.92 - 1,143,959.51 48.68 %' Permits 000 - 431100 Home Occupation Permit 500.00 210.00 420.00 420.00 - 80.00 84.00% 000 - 431205 Building Permit - Residential 573,156.00 152,798.50 267,083.00 342,707.50 - 230,448.50 59.79% 000 - 431210 Building Permit - Commercial 200,000.00 295,192.00 357,333.00 409,516.00 - (209,516.00) 204.76% 000 - 431215 Building Permit - General 150,000.00 35,681.00 81,353.00 79,723.00 - 70,277.00 53.15% 000 - 431300 Mobile Home Permit 300.00 25.00 100.00 50.00 - 250.00 16.67% 000 - 431400 Signs Permit 6,000.00 1,356.00 2,072.00 2,299.00 - 3,701.00 38.32% 000 - 431500 Food Establishmnt Permit 60,000.00 1,325.00 54,530.00 56,865.00 - 3,135.00 94.78% 000 - 431600 Garage Sale Permit 10,500.00 - 4,076.00 2,135.00 - 8,365.00 20.33% 000 - 431700 Plumbing Permit 121,000.00 40,568.00 61,535.00 83,129.70 - 37,870.30 68.70% 000 - 431750 Electrical Permit 61,000.00 18,880.00 30,940.00 37,780.00 - 23,220.00 61.93% 000 - 431800 Mechanical Permit 62,000.00 18,600.00 29,600.00 35,560.00 - 26,440.00 57.35% 000 - 431900 Solicitor /Peddler Permit 1,500.00 390.00 64.50 410.00 - 1,090.00 27.33% 000 - 431950 Animal/Pet Permit 1,000.00 - 15.00 90.00 - 910.00 9.00% 000 - 432000 Cert. of Occupancy Prmt 7,000.00 1,650.00 3,000.00 3,100.00 - 3,900.00 44.29% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 36,000.00 11,093.00 19,206.00 20,516.00 - 15,484.00 56.99% 000 - 432300 Grading /Clearing Permit 7,000.00 2,686.00 3,323.00 6,160.36 - 839.64 88.01% 000 - 432400 Development Permit 81,000.00 1,186.70 - 17,490.68 63,509.32 21.59% 000 - 435000 Fire Permit 25,000.00 10,189.00 12,745.00 18,524.00 - 6,476.00 74.10% 000 - 436010 Network Nodes - 1,750.00 - 1,750.00 - (1,750.00) 0.00% TOTAL Permits 1,402,956.00 593,580.20 927,395.50 1,118,226.24 - 284,729:76 13.60% Licenses 000 - 441000 Alcohol Beverage License 8,000.00 687.50 3,277.50 3,625.00 - 4,375.00 45.31% 000 - 441300 Mobile Home License 160.00 - 160.00 40.00 - 120.00 25.00% 000 - 442000 Contractors License 40,000.00 15,700.00 29,150.00 25,850.00 - 14,150.00 64.63% 000 - 444000 Pet License 3,000.00 810.00 1,620.00 1,485.00 - 1,515.00 49.50% TOTAL Licenses 51,160`00 17,197.50 34,207.50 31,000.00 - 20,160.00 60.59% Fees 000 - 451000 Municipal Court Fines 682,252.00 157,874.90 418,673.47 290,466.00 - 391,786.00 42.57% 000 - 451100 Arrest Fee 21,714.00 5,439.31 14,495.39 9,918.42 - 11,795.58 45.68% 000 - 451110 Expunction Fee 120.00 - 90.00 - - 120.00 0.00% 000 - 451200 Warrant Fees 124,000.00 21,196.10 61,086.70 40,528.31 - 83,471.69 32.68% 000 - 451210 Court - Claims & Judgements - - (291.40) - - - 0.00% 000 - 451340 Judicial Fee - City 3,152.00 759.34 2,023.40 1,387.92 - 1,764.08 44.03% 000 - 451400 Traffic Fine Costs TTL 10,265.00 2,501.56 6,925.79 4,618.91 - 5,646.09 45.00% 000 - 451510 Juvenile Case Mgmt Fee 26,352.00 6,338.90 16,872.02 11,596.80 - 14,755.20 44.01% 000 - 451520 Truancy Fee 4,464.00 1,080.13 2,937.17 2,016.94 2,447.06 45.18% 000 - 451600 Technology Fund Fee 21,983.00 5,070.99 13,625.48 9,218.22 - 12,764.78 41.93% 000 - 451700 Security Fee 15,817.00 3,803.21 10,219.12 7,008.59 - 8,808.41 44.31% 000 - 451800 Time Payment Fee - City 9,689.00 1,358.04 3,727.73 2,764.98 - 6,924.02 28.54% 000 - 451850 State Fines 10% Service Fee 20,488.00 - 18,612.49 8,502.14 - 11,985.86 41.50% 000 - 451900 DPS Payment - Local 8,829.00 1,707.87 4,523.33 3,225.21 - 5,603.79 36.53% 000 - 452000 Child Safety Fee 3,810.00 930.32 2,005.71 2,199.65 - 1,610.35 57.73% 000 - 452100 Platting Fees 62,000.00 13,500.00 37,500.00 21,250.00 - 40,750.00 34.27% 000 - 452200 Site Plan Fee 43,500.00 12,000.00 16,000.00 26,500.00 - 17,000.00 60.92% 000 - 452300 Plan Check Fee 463,261.00 242,027.00 351,399.50 417,410.00 - 45,851.00 90.10% 000 - 452320 Tree Mitigation Admin Fee 20,000.00 2,773.80 10,187.70 5,093.40 - 14,906.60 25.47% 000 - 452400 BOA/Zoning Fees 5,000.00 1,500.00 2,000.00 2,000.00 - 3,000.00 40.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 14,300.00 6,500.00 13,000.00 19,300.00 - (5,000.00) 134.97% 000 - 452710 Zoning Ltr & Dev Rights 1,200.00 300.00 900.00 750.00 - 450.00 62.50% 000 - 453100 Reinspection Fees 90,000.00 30,575.00 55,075.00 64,075.00 - 25,925.00 71.19% 000 - 453110 Swim Pool Inspection Fee 2,600.00 - - - - 2,600.00 0.00% 000 - 453200 Lot Abatement 5,000.00 1,140.00 1,325.50 1,140.00 - 3,860.00 22.80% 000 - 453211 Admin Fee - Inspections 10,400.00 5,000.00 6,200.00 11,400.00 - (1,000.00) 109.62% 000 - 453310 Misc Inspection Fee - 300.00 - 2,000.00 - (2,000.00) 0.00% 000 - 453710 Foster Care 1,000.00 100.00 550.00 450.00 - 550.00 45.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) 0.00% 000 - 456500 Haz Mat Fees 5,000.00 - - - - 5,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 1,000.00 100.00 550.00 450.00 - 550.00 45.00% 000 - 456600 Sale of General Fixed Asset - 19,251.61 - 19,251.61 - (19,251.61) 0.00% 000 - 458110 Sale of Merchandise- GovDeal 40,000.00 28,259.97 21,439.30 30,786.06 - 9,213.94 76.97% 000 - 458300 Sale of Property /Auction 3,000.00 - - - - 3,000.00 0.00% 000 - 458400 Civic Center Rental Fees 200,000.00 61,874.25 85,619.00 102,834.00 50.00 97,116.00 51.44% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000.00 1,820.00 6,560.00 2,120.00 - 7,880.00 21.20% 000 - 458450 North Center Rental Fees 18,500.00 6,080.00 11,862.50 11,835.00 6,665.00 63.97% 000 - 458460 Senior Center Rental 15,000.00 - 6,700.00 - - 15,000.00 0.00% 000 - 458500 Community Center Rental Fees 25,000.00 11,901.00 15,078.00 20,305.50 (150.00) 4,844.50 80.62% 000 - 458550 Pavilion Rental Fees 20,000.00 4,762.50 6,782.50 7,762.50 (90.00) 12,327.50 38.36% 000 - 458560 Chamber of Comm rent 7,800.00 1,950.00 3,900.00 3,900.00 - 3,900.00 50.00% 000 - 458570 Non - Resident SYSA League 10,000.00 3,800.00 - 13,080.00 - (3,080.00) 130.80% 000 - 458650 NonResident User Fee -BVYA 10,000.00 3,000.00 1,500.00 3,000.00 - 7,000.00 30.00% 000 - 458660 BVYA Utility Reimbursement 15,000.00 - 17,985.79 - - 15,000.00 0.00% 000 - 458670 SYSA Utility Reimbursement - 2,582.29 - 2,582.29 - (2,582.29) 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 10,000.00 - 5,860.00 2,344.00 - 7,656.00 23.44% 000 - 458700 Vehicle Impoundment 10,000.00 2,810.00 4,880.00 5,670.00 - 4,330.00 56.70% 000 - 459200 NSF Check Fee 250.00 - 50.00 - - 250.00 0.00% 000 - 459300 Notary Fee 250.00 54.00 90.00 78.00 - 172.00 31.20% 000 - 459400 Maps, Copies, UDC, & Misc F 250.00 5.00 5.00 10.00 - 240.00 4.00% 000 - 459600 Animal Adoption Fee 12,500.00 3,285.00 9,749.00 7,176.00 - 5,324.00 57.41% 000 - 459700 Pet Impoundment Fee 7,000.00 1,800.20 3,109.00 3,682.20 - 3,317.80 52.60% 000 - 459800 Police Reports Fee 5,800.00 1,551.20 3,146.30 2,932.50 - 2,867.50 50.56% TOTAL Fees 2,126,546.00! 678,663.49 1,274,931:49 1,205,021.15 (190.00) 921,714.85 56.66% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 20,000.00 6,783.64 11,279.78 11,964.08 - 8,035.92 59.82% TOTAL Fines 20,000.00 6,783.64 11,279.78 11,964.08 - 8,035.92 59.82% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077.00 1,756.48 21,077.76 21,077.76 - (0.76) 100.00% 000 - 473200 City of Seguin - Fire Contract 29,231.00 4,871.80 14,615.40 12,179.50 - 17,051.50 41.67% 000 - 473300 Guad Co- Library 218,000.00 108,576.00 126,672.00 126,672.00 - 91,328.00 58.11% 000 - 473400 Randolph AFB - Animal Cntrl 1,200.00 200.00 500.00 200.00 - 1,000.00 16.67% 000 - 474200 Library Services - Cibolo 35,000.00 35,000.00 - 35,001.50 - (1.50) 100.00% 000 - 474210 Library Services -Selma 20,000.00 21,750.00 - 21,750.00 - (1,750.00) 108.75% 000 - 474400 Dispatch Service - Cibolo 166,000.00 - 80,000.00 - - 166,000.00 0.00% 000 - 474600 School Crossing Guard - Bexar 38,000.00 6,005.09 18,085.31 18,347.83 - 19,652.17 48.28% 000 - 474610 School Cross Guard - Guadalupe 38,000.00 9,103.11 17,701.96 17,955.87 - 20,044.13 47.25% 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 127,500.00 127,500.00 - 127,500.00 50.00% 000 - 474750 Crime Victim Liaison Agreement 50,000.00 12,500.00 25,000.00 18,750.00 - 31,250.00 37.50% TOTAL Inter - Jurisdictional 873,008.00 263,512.48 431,152.43 399,434.46 - 473,573.54 45.75 %` Fund Transfers 000 - 480000 Indirect Costs - EMS 170,087.00 42,521.72 75,043.50 85,043.40 - 85,043.60 50.00% 000 - 480100 Indirect Costs - Hotel /Motel 67,605.00 16,601.25 33,202.50 33,202.50 - 34,402.50 49.11% 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.47 92,212.50 135,714.90 - 135,715.10 50.00% 000 - 486000 Interfund Chrges -Admin W &S 1,344,140.00 336,034.97 593,406.00 672,069.90 - 672,070.10 50.00% 000 - 487000 Interfund Charges -Fleet 344,026.00 86,201.75 198,790.50 172,403.50 - 171,622.50 50.11% 000 - 488000 Interfund Charges -413 441,395.00 220,697.50 215,222.48 441,395.00 - - 100.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.66 1,207,877.48 1;539,829.20 - 2,944,784.80 34.34% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 1,500.00 9,060.09 641.12 13,053.64 - (11,553.64) 870.24% 000 - 491200 Investment Income 150,000.00 54,962.29 57,853.69 89,074.84 - 60,925.16 59.38% 000 - 491800 Gain /Loss - 153.32 (6,337.61) (4,690.52) - 4,690.52 0.00% 000 - 491900 Unrealized Gain /Loss (30,000.00) (6,074.37) (11,297.74) (9,470.15) - (20,529.85) 0.00% 000 - 493120 Donations - Public Library 2,500.00 4,440.65 190.65 4,965.80 - (2,465.80) 198.63% 000 - 493400 Donation - Animal Control 15,000.00 3,546.50 9,494.00 10,274.87 - 4,725.13 68.50% 000 - 493401 Donations -A /C Microchip 1,000.00 105.00 130.00 360.00 - 640.00 36.00% 000 - 493402 Donations - Spay &Neuter 1,000.00 87.00 806.50 87.00 - 913.00 8.70% 000 - 493403 Donations - Animal Adoption Trailer - - 102.00 - - - 0.00% 000 - 493404 Donations -TNR Program 500.00 - - - - 500.00 0.00% 000 - 493460 Donations -Parks - 8,000.00 - 8,000.00 - (8,000.00) 0.00% 000 - 493465 Donations - Senior Center - 2,317.37 5,100.36 5,167.90 - (5,167.90) 0.00% 000 - 493502 Donations -PD - - 3,600.00 - - - 0.00% 000 - 493503 Donations -Fire Rescue - 10,000.00 - 10,350.00 - (10,350.00) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,650.00 3,823.43 3,679.47 3,823.43 - (173.43) 104.75% 000 - 494482 Grants - Police, Fire, Gen Fund 5,000.00 2,970.00 4,892.03 2,970.00 - 2,030.00 59.40% 000 - 495100 Mobile Stage Rental Fees - - - 550.00 - (550.00) 0.00% 000 - 497000 Misc Income -Gen Fund 30,000.00 2,299.40 11,582.65 58,117.42 - (28,117.42) 193.72% 000 - 497005 Schertz Magazine Advertising 195,000.00 30,925.00 104,150.00 64,485.00 - 130,515.00 33.07% 000 - 497100 Misc Income - Police 18,500.00 1,102.91 13,285.70 2,088.71 - 16,411.29 11.29% 000 - 497150 Misc Income -Fire Department - - 1,750.00 - - - 0.00% 000 - 497200 Misc Income - Library 5,000.00 1,258.10 2,414.35 2,469.59 - 2,530.41 49.39% 000 - 497210 Misc Income - Library Copier 18,000.00 4,342.19 8,600.85 9,245.60 - 8,754.40 51.36% 000 - 497300 Misc Income - Animal Control - 170.00 390.00 298.75 - (298.75) 0.00% 000 - 497400 Misc Income - Streets Dept. 60,000.00 3,720.00 38,522.55 11,696.10 - 48,303.90 19.49% 000 - 497500 Misc Income -TML Insurance 10,000.00 11,094.95 5,587.95 33,050.83 - (23,050.83) 330.51% 000 - 497550 Misc Income -TML Reimbursemt 20,000.00 509.03 3,852.43 628.14 - 19,371.86 3.14% 000 - 497600 Misc Income - Vending Mach. 2,500.00 535.42 889.84 924.57 - 1,575.43 36.98% 000 - 497610 Misc Income- Muni Court - - - 2,036.40 - (2,036.40) 0.00% 000 - 498000 Reimbursmnt -Gen Fund 35,000.00 (199.84) 1,944.08 1,639.44 - 33,360.56 4.68% 000 - 498100 Reimbursmnt Fire - Training 500.00 - 7.00 - - 500.00 0.00% 000 - 498105 Reimburmnt Police - DEA 5,000.00 - 3,958.75 - - 5,000.00 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 100,000.00 161,833.15 3,267.16 179,445.81 - (79,445.81) 179.45% 000 - 498150 Reimbursemnt - Library 5,750.00 6,355.39 4,673.27 6,355.39 - (605.39) 110.53% TOTAL Miscellaneous 655,400.00 317,336.98 273,731 05 506,998.56 - 148,401.44 77.36 %s' TOTAL REVENUES 31,424,058.43, 10,574,756.37 19,631,494.38 21,665,629.71 (190.00) 9,758,618.72 65.99% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: March 31, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 2,123,768.00 Cash in Investments LOGIC Investment - General Fund 13,407,067.88 LOGIC Investment -Equip Replacement 75,394.65 LOGIC Investment -Veh Replacement 508,368.76 LOGIC Investment -Air Condi Replacment 276,658.31 CAPITAL ONE Investment - General Fund 1,363,808.04 Total Cash in Bank & Investments $17,901,647.48 F, 2017-18 OCT 100,310 NOV 505,909 DEC 5,577,660 JAN 3,375,990 FEB 1,936,953 MAR 117,684 APR MAY JUN JUL AUG SEP or 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 Sales Tax - General Fund p p p p p CITY PUBLIC SERVICE 9 11 I?- OCT NOV DEC JAN_ MAR APR MAY JUN JUL AUG ----- - ---- -------------- - ............ ....... ...... ------------ - --- ------------- 2017-18 271,335 - ----- ------- - -FEB -------------- 280,083 ---------- ----------- ---------- ------------- ----- ------ -------- ------- ---------- ------------ --------------------- ----------- ------ _-SEP - - -o' 2016-17 -------------------------------------- ...... 252,947 191,140 213,951 - - -- -------------------------------------- -------------------------------------- -- - - - - 259,517 --------- w 2015-16 237,314 183,530 173,336 178,081 M 2014-15 215,257 - - - - - - - --------------------------------------- I 172,814 - 172,628 227,438 - - - - - ------------------------------------------------------------------------------------------ CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: March 31st, 2018 2017'301D 106-SPECkuL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Yq-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y�-DACTUAL Yq-DACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 73.000.00 - - - - 73.800.00 0.00% MinomUnnooun _86,400J00 12,374.38 3080684 33651.43 (40.00 02,7188.57 34.87% TOTALREVENUES 170,20000 12,374.38 38,866.84 33,651.43 __j80.00 136,628.57 19.72% EXPENDITURE SUMMARY CULTURAL Festival ofAngels 13.000.00 3.585.00 10.912.90 10.566.23 2,433.77 81.28% Employee Appreciation Event 13.000.00 1.474.09 8.085.83 9.807.85 234.74 2.857.41 7725% 4th uf July Jubilee 20.000.00 100.00 100.00 25.800.00 0.38% National Night Out 400.00 - - - - 400.00 0.00% VVi|onohik Walk for Life 20.000.00 2.485.08 3.503.00 2.485.68 020.00 16.894.32 15.53% Schertz Fest 30.000.00 35.00 35.00 820D0 240.00 29.140.00 2.87% SohoUzSweoiheart 31.250.00 5.062.85 3.322.35 5.860.11 880.40 24.388.48 21.82% Hal Baldwin Scholarship 15.050.00 585.00 9.047.17 8.537.61 6.512.39 5073% Other Events _21,500/00 1,586.95 750752 035030 58%2.30 14,567.34 32.24% � TOTAL CULTURAL 170,200 15,514I7 � �27.61g6 TOTAL EXPENDITURES ,,514.��° 43,074.45 `^ 44,327.84 ^��.,204..��s, REVENUE OVER(UNDER) EXPEND - �140. 19 (4,207.61) (10,676.41 13,423.85 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% 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 69.38 76.84 126.43 - 23.57 84.29% 000 - 492200 Wilenchik Walk for Life 20,000.00 10,565.00 11,410.00 10,565.00 (40.00) 9,475.00 52.63% 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 - 29,800.00 0.67% 000 - 493450 Holiday Lock -up /Blue Santa - - - - - - 0.00% 000 - 493455 Proceeds - Festival of Angels 700.00 90.00 615.00 1,305.00 - (605.00) 186.43% 000 - 493460 Schertz Sweetheart 1,500.00 - - - - 1,500.00 0.00% 000 - 493621 Hal Baldwin Scholarship 15,050.00 300.00 25,765.00 20,105.00 - (5,055.00) 133.59% 000 - 497000 Misc Income - 1,350.00 1,000.00 1,350.00 - (1,350.00) 0.00% TOTAL Miscellaneous 96,400.00 12,374.38 38,866.84 33,651.43 (40.00) 62,788.57 34.87 %! TOTAL REVENUES 170,200.00 12,374.38 ? 38,866.84 33,651.43 (40.00) 1'36,588.57 19.75 %; SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 56,656.93 Cash in Investments Texas Class- Special Events 17,192.77 Total Cash in Bank & Investments $ 73,849.70 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF:March 31st, 2018 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 93,300.00 - 45,772.60 21,430.96 - 71,869.04 22.97% Fund Transfers 106,700.00 - - - - 106,700.00 0.00% TOTAL REVENUES 200,000.00 - 45,772.60 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% TOTAL` EXPENDITURES 200,000.00 - 449.00 - 200,000.00 0.00% REVENUE OVER(UNDER) EXPEND - - 45,323.60 21,430.96 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF:March 31st, 2018 k****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% 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 - 26,55636 14,010.64 - 40,989.36 25.47% 000 - 421465 AT &T PEG Fee 38,300.00 - 19,216.24 7,420.32 - 30,879.68 19.37% TOTAL Franchises 93,300.00 - 45,772.60 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 0.00% TOTAL REVENUES 200,000.00 - 45,772.60 21,430.96 - 178,569.04 10.72 %' PEG FUND CASH IN BANK AND INVESTMENTS AS OF:March 31st, 2018 Cash in Bank Cash Balance $ 638,506.06 Total Cash in Bank & Investments $ 638,506.06 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 238,260.00 66,188.08 68,477.24 71,188 - 167,071.92 29.88% Permits - - 49,563.52 - - - - Supplies 0.00% Fees 22,013,250.00 5,365,461.88 10,363,266.87 2,926.24 10,962,493 - 11,050,757.28 400.00 49.80% Fund Transfers 194,546.00 35,377.50 68,460.00 0.00% 70,755 - 123,791.00 - 36.37% Miscellaneous 206,614.00 88,104.46 377,493.56 Utility Services 147,875 - 58,739.42 165.01 71.57% TOTAL REVENUES 22,652,670.00 5,555,131.92 10,927,261.1`9 150,000.00 11,252,310.38 - 11,400;359.62 60,398.42 49.67% *14 =041 k911111:1411.011MAT A WA BUSINESS OFFICE Personnel Services 486,338.00 105,679.21 218,706.85 226,824.22 - 259,513.78 46.64% Supplies 3,800.00 95.00 - 315.00 558.76 2,926.24 22.99% Human Services 400.00 - 203.00 - - 400.00 0.00% City Support Services 2,993.00 - 27.50 - - 2,993.00 0.00% Utility Services 900.00 252.95 165.01 409.38 85.40 405.22 54.98% Operations Support 150,000.00 42,900.53 57,759.14 60,398.42 0.99 89,600.59 40.27% Staff Support 6,250.00 345.40 1,233.87 606.85 147.30 5,495.85 12.07% Professional Services 120,000.00 44,267.64 57,928.20 91,156.34 10,105.00 18,738.66 84.38% Maintenance Services 8,040.00 2,760.00 3,600.00 4,020.00 3,040.00 980.00 87.81% Operating Equipment 3,607.00 3,007.00 - 3,516.95 - 90.05 97.50% TOTAL BUSINESS OFFICE 782,328.00 '' 199,307.73 339,623.57 387,247.16 13,937.45 381,143.39 51.28/0: CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,382,056.36 255,113.31 447,183.06 586,116.96 - 795,939.40 42.41% Supplies 157,500.00 - 67,537.71 59,249.53 94,022.82 8,172.68 55,304.50 64.89% Human Services 600.00 21.46% - 337.00 - - 600.00 0.00% City Support Services 225,500.00 486;304.00 1,240.22 43,422.05 45,681.20 58.82 179,759.98 20.28% Utility Services 3,522,329.00 812,214.77 1,417,793.92 1,537,137.02 476.93 1,984,715.05 43.65% Operations Support 11,600.00 360,000.00 1,386.60 2,687.38 2,716.07 - 8,883.93 23.41% Staff Support 29,250.00 TOTAL MISC & PROJECTS 13,265.02 6,466.52 15,009.69 600.62 13,639.69 53.37% City Assistance 1,500.00 - 797.00 - - 1,500.00 0.00% Professional Services 283,000.00 88,278.25 103,189.86 132,969.98 1,250.00 148,780.02 47.43% Fund Charges /Transfers 5,092,110.00 1,169,654.21 2,814,750.89 3,207,226.80 - 1,884,883.20 62.98% Maintenance Services 8,609,240.00 2,530,041.15 3,437,871.04 3,652,710.45 14,754.08 4,941,775.47 42.60% Other Costs 37,500.00 - 36,605.45 36,605.45 - 894.55 97.61% Debt Service 1,626,779.00 738,634.30 743,932.97 738,634.30 - 888,144.70 45.40% Rental- Leasing 124,500.00 2,270.34 23,501.89 2,782.95 - 121,717.05 2.24% Operating Equipment 9,000.00 26.85 - 26.85 - 8,973.15 0.30% Capital Outlay 397,877.64 - - - 397,477.64 400.00 99.90% TOTAL PUBLIC WORKS 21,510,342.00 ';5,679;662.73 9,137,788.56 10,051,640.54 422,790.77 11,035;910.69 48.69% 8I6Y01? 1=00111xia PROJECTS Operations Support 965.00 - 964.26 - 0.74 99.92% Professional Services 53,802.00 5,371.25 - 5,371.25 6,172.50 42,258.25 21.46% Maintenance Services 431,537.00 229,917.25 - 229,917.25 161,619.75 40,000.00 90.73% TOTAL PROJECTS 486;304.00 '' 235,288.50 - 236,252.76 167,792.25 82,258.99 ` 83.08% 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 235,289 - 236,253 167,792 442,259 47:74 %' TOTAL EXPENDITURES 23,138,974.00 6,114,258.96 9,477,412.13 10,675,140.46 604,520.47 11,859,313.07 48.75% " REVENUE OVER(UNDER)EXPENSES ** (486,304.00) (559,127.04) s 1,449,849.06 577,169.92 (604,520.47) (458,953.45); 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31 st, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 238,260.00 66,188.08 68,477.24 71,188.08 - 167,071.92 29.88% TOTAL Franchises 238,260.00 66,188.08 68,477.24 71,188.08 - 167,071.92 29.88 %' Permits 000 - 432400 Development Permit - - 49,563.52 - - - 0.00% TOTAL Permits - - 49,563.52 - - - 0.00% Fees 000 - 455200 Garbage Collection Fee 4,850,000.00 1,243,037.49 2,279,880.86 2,407,783.94 - 2,442,216.06 49.65% 000 - 455600 Fire Line Fees 31,000.00 25,160.00 29,540.00 29,015.00 - 1,985.00 93.60% 000 - 455700 Recycle Fee Revenue 309,750.00 77,446.54 146,752.49 152,577.33 - 157,172.67 49.26% 000 - 455800 W &S Line Constructn Reimbursemnt 20,000.00 8,398.79 14,339.90 17,549.79 - 2,450.21 87.75% 000 - 457100 Sale of Water 9,825,000.00 2,197,462.82 4,393,308.90 4,731,138.41 - 5,093,861.59 48.15% 000 - 457110 Edwards Water Lease 125,000.00 28,171.25 125,531.25 28,172.25 - 96,827.75 22.54% 000 - 457120 Water Transfer Charge -Selma 50,000.00 - 18,080.31 - - 50,000.00 0.00% 000 - 457200 Sale of Meters 80,000.00 35,555.50 46,406.00 74,228.83 - 5,771.17 92.79% 000 - 457400 Sewer Charges 6,500,000.00 1,687,334.43 3,184,041.92 3,382,308.39 - 3,117,691.61 52.04% 000 - 457500 Water Penalties 220,000.00 62,070.06 124,160.24 138,093.78 - 81,906.22 62.77% 000 - 459200 NSF Check Fee -Water &Sewer 2,500.00 825.00 1,225.00 1,625.00 - 875.00 65.00% TOTAL Fees 22,013,250.00 5,365,461.88 10,363,266.87 110,962,492.72 - 11,050,757.28 49.80°% 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 68,460.00 70,755.00 - 70,755.00 50.00% TOTAL Fund Transfers 194,546.00 35,377.50 68,460.00 70,755.00 ` - 123,791.00 36.37% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31 st, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 500.00 2,965.00 279,951.71 5,587.00 - (5,087.00) 1117.40% 000 - 491000 Interest Earned 1,500.00 5,209.50 639.33 11,419.61 - (9,919.61) 761.31% 000 - 491200 Investment Income 60,000.00 38,447.34 26,869.58 60,033.39 - (33.39) 100.06% 000 - 496000 Water Construction Reserve - 1.00 - 1.00 - (1.00) 0.00% 000 - 497000 Misc Income -W &S 15,000.00 94.35 6,863.37 1,748.56 - 13,251.44 11.66% 000 - 498110 Reimbursement -SSLGC 129,614.00 41,387.27 63,169.57 69,085.02 - 60,528.98 53.30% TOTAL Miscellaneous 206,614.00 88,104.46 377,493.56 147,874.58 = - 58,739.42 71:57 %< TOTAL REVENUES 22,652,670.00 5,555,131.92 10,927,261.19 1'1,252,3;10.38 - 1;1,400,359.62 49:67% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 973,245.82 Cash in Investments Lone Star Investment -Water &Sewer 4,712,782.42 Lone Star Investment -W &S Customer Deposits 302,228.25 Lone Star Investment -W &S Equip Replacement 181,713.84 Lone Star Investment -W &S Veh Replacement 262,502.14 Schertz Bank & Trust - Certificate of Deposit 1,096,110.74 $ 6,555,337.39 Total Cash in Bank & Investments $ 7,528,583.21 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: March 31st, 2018 2017-2018 203-EMS CURRENT CURRENT PRIOR YEAR Y�-D YT-D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Fees 6,122.000.00 723,420.05 2.940563.90 2.294.728.31 (65.00) 3.827.338.69 3748% | 2.780.862.72 624�13.79 1,491.36378 2.105,25211 - 675.610.61 75.70% Fund Transfers ' - ' - - - 0.00% Miscellaneous 117,850.00 13,408.63 111,400.96 118,129.13 (279.13 100.24% TOTALREVENUES 9,020,712.72 1,361,248,47 4,543,328.64 4,518,110755 ___(§5.OJO 4,502,670.17 50.09% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4.244.739.00 915,001.53 1.832.743.50 2.021.882.37 2,223.056.63 47�63% Supplies 410,850.00 85,398.82 211,200.09 187.030.38 48.090.07 174.523.57 57.52% Human Services 238.00 0.00% City Support Services 104,100.00 20,60000 51.375.20 45.213.10 58.886.80 43.43% Utility Services 118,000.00 29,722.15 45,824.59 48,98 .48 1,36033 07,64818 42.67% Operations Support 74.020.00 17.053.85 32.454.32 30.905J8 1.050.05 42.003.57 42.83% Staff Support 70.750.08 15.350.09 21.298.84 22.283.03 8.883.54 38.482.83 45.61% City Assistance 508.900.81 137.030.07 184.281.80 274.953.37 2.083.00 291.218.84 48.81% Professional Services 108.200.00 26.727.00 55.294.40 47.774.07 13.000.00 107.425.33 36.13% FundChergem1nonsfem 2.050.827.00 257.300.88 1.251.002.43 1.402.031.33 1.254.795.07 52.77% Maintenance Services 12.000.00 4.800.00 14.290.04 4.800.00 7.200.00 40.00% Debt Service 288.120.00 115.798.13 5,648.72 115.78813 172.33187 4819Yt Rental-Leasing 141.000.00 84.558.20 35.349.93 101.943.41 45.477.01 (6.421.02) 104.55% Operating Equipment 118.100.00 8.23787 7.021.88 10.851.48 18.857.48 88.391.04 24.84% Capital Outlay 30,000.00 - 34,510.00 - 606,395.76 (576,395.76) 2021.32% TOTAL PUBLIC SAFETY 9,007,172.81 1,719,239.56 3,783,742.74 4,314,849.11 747,515.04 3,944,808.66 56.20% TOTAL EXPENDITURES 9,007,172.81 1,719,239.56 3,783,742.74 4,314,849.11 747,515.04 3,944,80&66 56.20% — REVENUE OVER(UNDER) EXPENSES 13,539.91 (357,991.09) 759,585.90 203,258.44 __(717,580OJ4 557,861.51 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,866,200.00 633,496.66 2,777,387.77 2,110,420.84 - 3,755,779.16 35.98% 000 - 456110 Subscription Program Fees 30,000.00 6,140.00 23,915.00 23,485.00 (65.00) 6,580.00 78.07% 000 - 456120 EMT Class - Fees 96,000.00 33,825.00 41,348.00 51,065.00 - 44,935.00 53.19% 000 - 456122 CE Class - Fees 22,800.00 18,382.52 - 18,382.52 - 4,417.48 80.63% 000 - 456130 Immunization Fees 7,000.00 1,316.81 1,128.00 2,536.81 - 4,463.19 36.24% 000 - 456140 Billing Fees - External 25,000.00 6,262.76 9,174.18 11,042.69 - 13,957.31 44.17% 000 - 456150 Standby Fees 25,000.00 288.80 19,835.45 25,338.95 - (338.95) 101.36% 000 - 456155 Community Services Support 50,000.00 21,718.50 67,725.50 48,874.50 - 1,125.50 97.75% 000 - 456160 MIH Services - 1,895.00 - 3,480.00 - (3,480.00) 0.00% 000 - 459200 NSF Check Fee - 100.00 50.00 100.00 - (100.00) 0.00% TOTAL Fees 6,122,000.00 723,426.05 2,940,563.90 2,294,726.31 (65.00) 3,827,338.69 ? 37.48°%` Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 843,577.17 210,894.51 225,646.99 913,876.21 - (70,299.04) 108.33% 000 - 474300 Cibolo Support 346,467.65 86,616.91 319,098.32 173,233.82 - 173,233.83 50.00% 000 - 475100 Comal Co ESD #6 112,536.60 29,832.03 78,695.32 57,148.44 - 55,388.16 50.78% 000 - 475200 Live Oak Support 213,151.95 53,287.99 155,217.39 106,575.98 - 106,575.97 50.00% 000 - 475300 Universal City Support 281,283.70 70,320.93 196,770.75 140,641.86 - 140,641.84 50.00% 000 - 475400 Selma Support 111,886.35 27,971.59 79,992.06 55,943.18 - 55,943.17 50.00% 000 - 475500 Schertz Support 556,325.00 139,081.25 378,062.91 278,162.50 - 278,162.50 50.00% 000 - 475600 Santa Clara Support 10,447.35 2,611.84 7,765.62 5,223.68 - 5,223.67 50.00% 000 - 475800 Marion Support 15,186.95 3,796.74 11,217.00 7,593.48 - 7,593.47 50.00% 000 - 475910 TASPP Program 290,000.00 - 38,897.42 366,852.96 - (76,852.96) 126.50% TOTAL Inter - Jurisdictional 2,780,862.72 624,413.79 1,491,363.78 2,105,252.11 - 675,611 7510 %' Miscellaneous 000 - 491000 Interest Earned 100.00 1,138.40 51.13 1,608.85 - (1,508.85) 1608.85% 000 - 491200 Investment Income 750.00 2,570.12 405.37 4,706.50 - (3,956.50) 627.53% 000 - 493203 Donations -EMS 2,000.00 - 150.00 350.00 - 1,650.00 17.50% 000 - 493205 Donations- Golf Tournament 10,000.00 600.00 - 600.00 - 9,400.00 6.00% 000 - 495100 UH Grant Program 40,000.00 - 63,262.27 - - 40,000.00 0.00% 000 - 497000 Misc Income 25,000.00 (12,174.89) 24,871.64 81,524.48 - (56,524.48) 326.10% 000 - 497100 Recovery of Bad Debt 40,000.00 21,275.00 22,660.55 29,339.30 - 10,660.70 73.35% TOTAL Miscellaneous 117,850.00' 13,408.63;' 111,400.96 11,8,129.13 - (279.13) 100.24 % >; TOTAL REVENUES 9,020,712.72 1,361,248.47 4,543,328.64 4,51;8,107.55 (65.00),!, 4,502,670.17 50.09% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 296,158.76 Cash in Investments Texas Class- Tax Note 2015 Ambulances 90,694.76 Total Cash in Bank & Investments $ 386,853.52 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 391,652.00 68,545.74 225,720.19 151,101.11 - 240,550.89 38.58% Supplies Permits 3,000.00 760.00 1,521.21 1,280.00 1,460 - 1,540.00 48.67% 8,180.00 Fees 1,179,250.00 292,293.37 - 569,369.19 583,949 - 595,301.06 49.52% 2,605.20 Fund Transfers 1,327,327.00 - 8,474.48 - - - 1,327,327.00 0.00% - Miscellaneous 254,350.00 7,337.00 0.00% 7,333.59 177,571 - 76,779.37 69.81% 2,708.65 TOTAL REVENUES 2,763,927 00 300,390.37 City Assistance 577,982.78 762,979.57 2,000,947.43; 27.60 % »r•t7i��1:��.�lJJi1�5F_131 alL:L�[*] "T701=0 DRAINAGE Personnel Services 391,652.00 68,545.74 225,720.19 151,101.11 - 240,550.89 38.58% Supplies 5,200.00 834.04 1,438.53 1,521.21 366.79 3,312.00 36.31% City Support Services 8,180.00 1,690.80 4,576.16 5,128.49 - 3,051.51 62.70% Utility Services 13,200.00 2,605.20 6,604.90 4,267.10 458.42 8,474.48 35.80% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 6,700.00 1,615.45 2,777.97 2,708.65 - 3,991.35 40.43% City Assistance 400.00 98.00 - 98.00 - 302.00 24.50% Professional Services 117,320.00 6,985.00 1,500.00 8,840.00 - 108,480.00 7.53% Fund Charges/Transfers 497,295.00 124,073.72 213,567.00 248,147.40 - 249,147.60 49.90% Maintenance Services - 341.82 1,660.18 872.14 217.77 (1,089.91) 0.00% Other costs 200.00 100.00 100.00 100.00 - 100.00 50.00% Debt Service 123,225.00 4,093.63 5,040.40 4,093.63 - 119,131.37 3.32% Rental /Leasing 500.00 - - - - 500.00 0.00% Operating Equipment 7,000.00 519.99 360.00 519.99 - 6,480.01 7.43% TOTAL DRAINAGE 1,171,872:00 21`1,503.39 463,34533 427,397.72 1,042.98 743,431.30 36.56 % ` PROJECTS City Support Services 7,354.50 - - - - 7,354.50 0.00% Operations Support 1,950.00 - - 469.00 - 1,481.00 24.05% Professional Services 180,058.50 4,494.00 - 8,120.00 - 171,938.50 4.51% Maintenance Services 1,572,692.00 127,783.15 225,206.35 1,347,485.65 14.32% TOTAL PROJECTS 1,762,055.00 132,277.1`5 - 233,795.35 1,528,259.65 13.27 % TOTAL EXPENDITURES 2,933,927.00 343,780.54 463,345.33 661,193.07 1,042.98 2,271,690.95` 22:57 %a -- REVENUE OVER(UNDER) EXPEND ; (170,000.00) (43,390.17 }; 101,786.50 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000.00 760.00 1,280.00 1,460.00 - 1,540.00 48.67% TOTAL Permits 3,000.00 760.00 1,280.00 1,460.00 - 1,540.00 - 48.67% Fees 000 - 457500 Drainage Penalties 10,000.00 2,505.68 4,942.10 6,200.25 - 3,799.75 62.00% 000 - 457600 Drainage Fee 1,169,250.00 289,787.69 564,427.09 577,748.69 - 591,501.31 49.41% TOTAL Fees 1,179,250.00 292,293.37 569,369.19 583,948.94 - 595,301.06 49.52% 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 574.46 53.51 1,015.63 - (865.63) 677.09% 000 - 491200 Investment Interest 12,000.00 6,760.23 6,425.08 12,308.19 - (308.19) 102.57% 000 - 497000 Misc Income - Drainage 242,200.00 2.31 855.00 164,246.81 - 77,953.19 67.81% TOTAL Miscellaneous 254,350.00 7,337.00 7,333.59 177,570.63 - 76,779.37 69.81% TOTAL REVENUES 2,763,927.00 300,390,37 577,982.78 762,979.57 - 2,000,947.43 27.60 %' DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 128,549.05 Cash in Investments Lone Star Investment-Drainage Maint Fund 996,164.27 Total Cash in Bank & Investments $ 1,124,713.32 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *: 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET (: ajok,l1J�al�J�i►� /e1:�'1 Taxes 550,000.00 61,023.71 197,143.14 170,897.43 - 379,102.57 31.07% Miscellaneous 13,650.00 6,069.65 4,834.39 10,998.38 - 2,651.62 80.57% TOTAL REVENUES 563,650.00 67,093.36 `i 201,977.53 181,895.81 - 381,754.19 32.27% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,000.00 11,455.72 58,457.22 57,046.36 - 52,953.64 51.86% Operations Support 68,425.00 8,092.00 24,001.64 9,492.00 17,48716 41,445.84 39.43% Professional Services 3,000.00 3,000.00 3,000.00 3,000.00 - 100.00% Fund Charges /Transfers 67,605.00 16,601.25 33,202.50 33,202.50 - 34,402.50 49.11% Maintenance Services 10,000.00 - 561.94 - - 10,000.00 0.00% Capital Outlay 63,806.00 - - - 8,225.00 55,581.00 12.89% TOTAL NONDEPARTMENTAL 322,836.00 39,1!48.97 121,223.30 102,740.86 25,712.16 194,382.98 39.79% TOTAL EXPENDITURES 322,836.00 39,148.97 121,223.30 102,740.86 25,712.16 194,382.98 39.79 %'i REVENUE OVER(UNDER) EXPENDITURE 240,814.00 =` 79,154.95 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 194,332.21 Cash in Investments Texas Class - Hotel Tax 1,355,147.94 Total Cash in Bank & Investments $ 1,549,480.15 HOTEL OCCUPANCY TAX $80,000 $70,000 = - - - - - - - - - - - - -- - - $60,000 $50,000 tt s 0 �9A •a;e�w,. $40,000 mom $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 --- - - - - -- -- - - - - -- 31,786 --- - - - - - - - - 48,161 - - - -- - - - - -- - - - - - -- 52,784 -- - - - - -- - - -- - -- - - -_ - --------------- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- -- - - - - -- 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 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 24,000.00 97,000.00 24,000 - 46,000.00 34.29% Fund Transfers 109,829.69 - - - - - 0.00% Miscellaneous 60,000.00 1,498.98 1,509.04 2,758.68 - 57,241.32 4.60% TOTAL REVENUES 239,829.69 25,498.98 98,509.04 " 26,758.68 - 103,241.32 11.16 %` EXPENDITURE SUMMARY PARKLAND DEDICATION Operating Equipment 10,000.00 - 4,005.00 - - 10,000.00 0.00% Capital Outlay 229,829.69 59,139.06 - 59,139.06 107,672.88 63,017.75 72.58% TOTAL PARKLAND DEDICATION 239,829.69 59,139.06 4,005.00 59,139.06 107,672.88 73,017.75 69.55% TOTAL EXPENDITURES 239,829.69 59,139.06 4,005.00 ? 59,139.06 107,672.88 73,017.75 69.55 %' REVENUE OVER(UNDER) EXPEND` - (32,380.38): CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 70,000.00 24,000.00 97,000.00 24,000.00 - 46,000.00 34.29% TOTAL Fees - 70,000.00 24,000.00 97,000.00 24,000.00 ` 46,000.00 34.29% Fund Transfers 000 -48100 Transfer In- Reserves 109,829.69 - - - - 109,829.69 0.00% TOTAL Fund Transfers 109,829.69 - 109,829.69 0.00% Miscellaneous 000 - 491000 Interest Earned 100.00 155.89 21.49 312.11 - (212.11) 312.11% 000 - 491200 Investment Interest 3,000.00 1,343.09 1,487.55 2,446.57 - 553.43 81.55% 000 - 499100 Transfer From Parks Reserve 56,900.00 - - - - 56,900.00 0.00% TOTAL Miscellaneous 60,000`00 1,498.98 1,509.04 2,758.68 < - 57,241.32 4.60% TOTAL REVENUES ! 239,829.69 25,498.98 98,509.04 26,758.68 - 213,071.01 11.16 %! PARK FUND CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $2,620.50 Cash in Investments Texas Class- Park Fund 332,810.31, Total Cash in Bank & Investments $335,430.81 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 419,773.40 629,343.00 836,401.40 - 263,598.60 76.04% Miscellaneous 40,200.00 21,433.29 14,07434 38,178.50 - 2,021.50 94.97% TOTAL REVENUES 1,140,200.00 441,206.69 643,417.34 874,579 >90 - 265,620.10 76.70 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 516.00 1,000.00 1,000.00 - 255,000.00 0.39% TOTAL NON DEPARTMENTAL 256,000.00 516.00 1,000.00 1,000.00 - 255,000.00 0.39% MISC & PROJECTS PROJECTS Fund Charges/Transfers 0.00% TOTAL MISC & PROJECTS - - - = - 0.00% TOTAL EXPENDITURES 256,000.00 516.00 1,000.00 1,000.00 - 255,000.00 0.39% REVENUE OVER(UNDER) EXPENDITURES 884,200.00 440,690.69 642,417.34 873,579.90 - 10,620.10 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% 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 419,773.40 629,343.00 836,401.40 - 263,598.60 76.04% TOTAL Fees 1,100,000.00 419,773.40 629,343.00 ;836,401.40 263,598.60 76.04% Miscellaneous 000 - 491000 Interest Earned 200.00 1,427.02 100.06 2,325.23 - (2,125.23) 1162.62% 000 - 491200 Investment Income 40,000.00 20,006.27 13,97428 35,853.27 - 4,146.73 89.63% TOTAL Miscellaneous 40,200.00 21,433.29 14,074.34 38,178.50 - 2,021.50 94.97 %' TOTAL REVENUES 1,140;200.00 441,206.69 643,41734 874,579.90 - 265,620.10 76.70 %I CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 371,943.89 Cash in Investments Lone Star Investment - Capital Recovery Water 5,346,998.42 Total Cash in Bank &'Investments $ 5,718,942.31 'i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT 3rd CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET MONTH QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000.00 87,818.76 199,118.64 268,089.00 470,317 - 79,682.68 85.51% Fund Transfers 359,700.00 - - - - - 359,700.00 0.00% Miscellaneous 40,150.00 9,116.12 16,296.84 7,796.32 26,290 - 13,860.03 65.48% TOTAL REVENUES 949,850.00 = 96,934.88 215,41!5.48 275,885.32 496,60729 - 453,242.71 52.28 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 335,500.00 87839 1,604.41 3,175.49 3,179.23 - 332,320.77 0.95% Maintenance Services 359,700.00 - - - - 359,700.00 0.00% TOTAL NON DEPARTMENTAL 695,200.00 878.39 1,604.41 3,175.49 ' 3,179.23 - 692,020.77 0.46 %? TOTAL EXPENDITURES 695,200.00 i 878.39 1,604.41 3,175.49 3,179.23 692,020.77 0.46% REVENUE OVER(UNDER) EXPENDITURES 254,650.00 ? 96,056.49 213,811.07 272,709.83 493,428.06 - 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 50% 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 190,118.64 257,289.00 459,517.32 - 90,482.68 83.55% 000 - 455913 Cap Recovery -North Sewer Tr - 9,000.00 10,800.00 10,800.00 - (10,800.00) 0.00% TOTAL Fees 550,000.00 199,118.64 268,089.00 470,31732 79,682.68 85.51 % ' Fund Transfers 000 - 481000 Transfer from Reserves 359,700.00 - - - - 359,700.00 0.00% TOTAL Fund Transfers 359,700.00 ` - - - 359,700.00 0.00% Miscellaneous 000 - 491000 Interest Earned 150.00 1,095.56 62.15 1,801.76 - (1,651.76) 1201.17% 000 - 491200 Investment Income 40,000.00 23,176.90 28,598.43 43,160.95 - (3,160.95) 107.90% 000 - 491800 Gain /Loss - 185.55 (3,532.18) 597.17 - (597.17) 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (8,161.17) (17,332.08) (19,269.91) - 19,269.91 0.00% TOTAL Miscellaneous 40,150.00 16,296.84 7,796.32 26,289.97 - 13,860.03 65.48 %' TOTAL REVENUES 949,850.00 215,4'15.48 275,885.32 496,607.29 - 453,242.71 52.28 % > CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 283,161.59 Cash in Investments Lone Star Investment - Capital Recovery Sewer 4,064,737.44 Capital One - Investment 1,749,071.46 Total Cash in Bank & Investments $ 6,096,970.49 505 - TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 6,030,353.00 2,811,566.18 6,021,412.59 5,981,785.20 - 48,567.80 99.19% Fund Transfers 487,110.00 - - - - 487,110.00 0.00% Miscellaneous 477,069.00 376,359.66 108,075.56 381,582.06 - 95,486.94 79.98% TOTAL REVENUES 6,994,532.00 3,1187,925.84 6,129,488.15 6,363,367.26 - 631,164.74 = 90.98 %` EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services Debt Service 2,550.00 1,600.00 1,550.00 2,150.00 6,991,982.00 5,614,964.08 5,329,583.69 5,614,964.08 400.00 84.31% 1,377,017.92 80.31% Other Financing Sources - - - - - - 0.00% TOTAL GENERAL GOVERNMENT 6,994,532.00` 5,616,564.08 5,331,133.69 5,617,114.08 - 1,377,417.92 80.31 %` TOTAL EXPENDITURES 6,994,532.00 5,616,564.08 5,331,133.69 5,617,114.08 1,377,4`17.92 80.31 %` " REVENUE OVER(UNDER) EXPEND - 746,25118 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31st, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 50% 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 2,811,566.18 6,021,412.59 5,981,785.20 - 48,567.80 99.19% TOTAL Taxes 6;030,35100 2,811,566.18 6,021,412.59 5,981,785.20 48,567.80 99.19% 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 2,637.84 129.35 3,214.51 - (2,914.51) 1071.50% 000 - 491200 Investment Earnings 16,000.00 12,952.82 7,946.21 17,598.55 - (1,598.55) 109.99% 000 - 495015 Contribution from SED 360,769.00 360,769.00 - 360,769.00 - - 100.00% 000 - 495020 Contribution from YMCA 100,000.00 - 100,000.00 - - 100,000.00 0.00% TOTAL Miscellaneous 477,069.00 376,359.66 108,075.56 381,582.06 - 95,486.94 79,98% TOTAL REVENUES 6,994,532.00 3,187,925.84 '' 6,129,488.1!5 6,363,367.26 - 631,164.74 90.98% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT 3rd CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF NON DEPARTMENTAL BUDGET MONTH QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,550.00 - 1,600.00 1,550.00 2,150.00 - 400.00 84.31% TOTAL Professional Services 2,550.00 - 1,600.00 1,550.00 2,150.00 400.00 84.31 %' Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000.00 285,000.00 285,000.00 285,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 38,475.00 21,375.00 25,650.00 21,375.00 - 17,100.00 55.56% 101 - 555629 GO Bond 2007 - Principal 290,000.00 290,000.00 280,000.00 290,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007 - Interest 136,345.00 71,123.25 76,821.25 71,123.25 - 65,221.75 52.16% 101 - 555630 GO Bond SR2008 Principal 475,000.00 475,000.00 460,000.00 475,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 259,055.00 9,808.75 143,930.50 9,808.75 - 249,246.25 3.79% 101 - 555631 GO Bond SR2009 Principal 550,000.00 550,000.00 550,000.00 550,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 249,138.00 129,037.50 137,287.50 129,037.50 - 120,100.50 51.79% 101 - 555633 GO SR2011 Principal 240,000.00 240,000.00 235,000.00 240,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 327,038.00 165,618.75 169,143.75 165,618.75 - 161,419.25 50.64% 101 - 555634 GO SR2011A Refund Principal 635,000.00 635,000.00 620,000.00 635,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 87,783.00 47,590.25 54,813.25 47,590.25 - 40,192.75 54.21% 101 - 555635 GO SR2012 Principal 335,000.00 335,000.00 320,000.00 335,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 168,095.00 87,397.50 94,357.50 87,397.50 - 80,697.50 51.99% 101 - 555636 Tax Note - SR2013 - Principal 170,000.00 170,000.00 170,000.00 170,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 1,445.00 1,445.00 2,550.00 1,445.00 - - 100.00% 101 - 555637 Tax Note - SR 2013A - Principal 165,000.00 165,000.00 160,000.00 165,000.00 - - 100.00% 101- 555637.1 Tax Note - SR2013 - Interest 1,073.00 1,072.49 2,112.50 1,072.49 - 0.51 99.95% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000.00 100,000.00 100,000.00 100,000.00 - - 100.00% 101- 555638.1 Bond -GO 2014 Refund - Interest 289,775.00 145,637.50 146,637.50 145,637.50 - 144,137.50 50.26% 101 - 555639 Tax Note - SR2015 - Principal 35,000.00 - - - - 35,000.00 0.00% 101- 555639.1 Tax Note - SR2015 - Interest 2,538.00 1,263.02 1,564.26 1,263.02 - 1,274.98 49.76% 101 - 555640 Bond -Ref 2015 Bond- Principal 490,000.00 490,000.00 450,000.00 490,000.00 - - 100.00% 101- 555640.1 Bond -GO Ref 2015- Interest 92,725.00 48,812.50 53,312.50 48,812.50 - 43,912.50 52.64% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT 3rd CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 50% OF NON DEPARTMENTAL BUDGET MONTH QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET 101 - 555641 Tax Note - SR2015A - Principal 145,000.00 - - - - 145,000.00 0.00% 101 - 555641.1 Tax Note - SR2015A - Interest 11,550.00 5,731.58 6,859.42 5,731.58 - 5,818.42 49.62% 101 - 555642 GO Bond SR2016 Principal 205,000.00 205,000.00 405,000.00 205,000.00 - - 100.00% 101 - 555642.1 GO Bond SR2016 Interest 167,607.00 85,853.13 89,903.13 85,853.13 - 81,753.87 51.22% 101 - 555643 CO Bond Tax SR2016 Principal 55,000.00 55,000.00 55,000.00 55,000.00 - - 100.00% 101 - 555643.1 CO Bond Tax SR2016 Interest 47,238.00 24,031.25 24,856.25 24,031.25 - 23,206.75 50.87% 101 - 555644 CO Bond nonTax SR2016 Principal 165,000.00 165,000.00 170,000.00 165,000.00 - - 100.00% 101 - 555644 CO Bond nonTax SR2016 Interest 69,469.00 36,384.38 39,784.38 36,384.38 - 33,084.62 52.37% 101 - 555645 CO Bond SR2017 Principal 245,000.00 245,000.00 - 245,000.00 - - 100.00% 101 - 555645.1 CO Bond SR2017 Interest 178,689.00 107,075.56 - 107,075.56 - 71,613.44 59.92% 101 - 555646 Bond -GO SR2017 Principal 135,000.00 135,000.00 - 135,000.00 - - 100.00% 101 - 55646.1 Bond - GO SR2017 Interest 143,944.00 85,706.67 - 85,706.67 - 58,237.33 59.54% TOTAL Debt Service 6,991,982.00 - 5,614,964.08 5,329,583.69 ` 5,614,964.08 - 1,377,017.92 ` 80.31% TOTAL EXPENDITURES 6,994,532.00 - 5,616,564.08 5,331,133.69- 5,617,114.08 - 1,377,417.92 80.31% TAX I &S CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 487,802.82 MBIA Investment -Tax 1 &S 1,708,532.49 Total Cash in Bank &'Investments $ 12,196,335.31 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31st, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 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 50% OF BALANCE BUDGET REVENUE SUMMARY 750.00 120.67 355.12 Taxes 3,962,572.00 1,029,318.07 1,749,181.47 2,028,778.97 - 1,933,793.03 51.20% Fund Transfers 225,000.00 - - - - - 0.00% Miscellaneous 120,301.00 63,463.87 56,780.67 109,076.98 - 11,224.02 90.67% TOTAL REVENUES 4,307,873.00 1,092,781.94 1,805,962.14 2,137,855.95 -' 1,945,017.05 49.63 %! EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Supplies 750.00 120.67 355.12 238.49 - 511.51 31.80% Human Services 500.00 - 345.20 - - 500.00 0.00% City Support Services 37,700.00 585.33 2,763.33 2,416.00 109.00 35,175.00 6.70% Utility Services 3,870.00 531.67 1,035.34 996.48 98.90 2,774.62 28.30% Operations Support 172,000.00 22,723.34 17,082.34 42,412.94 75.00 129,512.06 24.70% Staff Support 21,900.00 5,064.91 5,667.12 7,276.69 - 14,623.31 3123% City Assistance 1,042,500.00 - 94.59 200,000.00 - 842,500.00 19.18% Professional Services 82,500.00 9,122.13 4,175.77 9,239.13 - 73,260.87 11.20% Fund Charges/Transfers 1,067,945.00 581,857.00 215,529.46 802,945.00 - 265,000.00 75.19% Maintenance Services 1,000.00 35.00 - 175.00 - 825.00 17.50% Operating Equipment 4,200.00 - 299.99 576.02 - 3,623.98 13.71% TOTAL ECONO DEVELOPMENT 2,434,865.00 620,040.05 247,348.26 1;066,275;75 282.90 1,368,306.35 43.80 %! TOTAL EXPENDITURES 2,434,865.00 620,040.05 247,348.26 1,066,275.75 282.90 1,368,306.35 43.80% ** REVENUE OVER(UNDER) EXPEND 1 ",873,008.00 472,741.89 1,558,613.88 1,071,580.20 (282.90} 576,710.70 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: March 31st, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 88,876.88 Cash in Investments Texas Class Investment - Economic Development Corl 13,230,280.98 Schertz Bank & Trust - Certificate of Deposit 1,018,080.00 Schertz Bank & Trust - Certificate of Deposit 1,063,386.74 Total Cash in Bank & Investments $ 15,400,624.60 4B SALES TAX By Collection Month $450,000 4 $400,000 - -- - - - - - - - 12.2% 12.1% 19.9 ®l4 $350,000 4 "xh � +6% 3 �""Y9yYU'E.'.o.+t!NY.SSOL`te s wvtivrxv,' �"o $300,000 00F .. "5v, $250,000 - - - - - - - $200,000 $150,000 - - - - - -- - - - - -- $100,000 - - - - - - -- - - - - - - $50,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP - - - -- -- 2017 -18 - - - - -- - - - - - -- 322,292 - ------- 343,024 307,585 313,990 372,357 291,909 - - - _ -- 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