The URL can be used to link to this page

Q3- June 2018Quarterly t t Texas MY OF S HERT REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF une 30,2018 017 2018 170,200.00 CURRENT CURRENT Y -T -D BUDGET BUDGET ` -T-D AC'T 1AL ENCUMBIR BALANCE 75% OF BUDGET General Fund, 101 Total Expenditures 170,200.00 69,512.05 23,377.80 77,310.15 Total Revenues 31,594,458.43 26,863,959.92 0.00 6,300,124.86 80.06% Total General Government 6,655,155.92 5,066,118.30 288,772.17 1,300,265.45 80.46% Total Public Safety 13,736,139.18 9,964,681.48 206,924.57 3,564,533.13 74.05% Total Public Environment 1,353,192.00 898,877.91 163,117.22 291,196.87 78.48% Total Parks & Recreation 1,946,281.81 1,075,980.38 97,288.85 773,012.58 6028% Total Cultural 928,598.00 723,423.99 9,892.05 195,281.96 78.97% Total Health 901,147.00 466,701.17 56,347.57 378,098.26 58.04% Total Internal Services 5,714,689.08 3,833,469.03 344,536.54 1,536,683.51 73.11% Total Misc & Projects 335,855.00 217,420.35 33,221.10 85,213.55 74.63% Total Expenditures 31,571,057.99 22,246,672.61 1,200,100.07 8,124,285.31 74.27% Revenue Over(Under) Expenditures 23,400.44 4,617,287.31 23,159,842.00 14,907,704.20 994,369.65 7,257,768.15 General Fund, 101 Total Cash in Bank & Investments Revenue Over(Under) Expenditures 15,696,833.52 (507,172.00) 2,358,252.54 Total Revenues 170,200.00 60,727.92 0.00 1 109,472.08 1 35.68% Total Expenditures 170,200.00 69,512.05 23,377.80 77,310.15 54.58% Revenue Over(Under) Expenditures 0.00 (8,784.13) Special Events Fund, 106 Total Cash in Bank & Investments 75,741.98 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 17,265,956.74 - 5,386,713.26 76.22% Total Expenditures 23,159,842.00 14,907,704.20 994,369.65 7,257,768.15 68.66% Revenue Over(Under) Expenditures (507,172.00) 2,358,252.54 Water & Sewer, 202 Total Cash in Bank & Investments 10,073,493.89 CH'Y OF SCHERTZ REVENUE AND EXPENSE REPORT(U?',IAUDITIED) Quarterly Statement AS O ne €0 2018 2017-21118 Schell Texas CURRENT CURRENT Y-T-D BUDr,'7ET 75% OF BUDGET Y-T-D ACTUAL, ENCUMBR BAL.ANCE BUDGET EMS, 203 Total Revenues 9,020,712.72 6,678,645.08 0.00 2,342,067.64 74.04% Total Expenditures 9,007,172.81 6,587,585.53 136,324.73 2,283,262.55 74.65% Revenue Over(Under) Expenditures 13,539.91 91,059.55 EMS, 203 Total Cash in Bank & Investments 297,564.31 Drainage, 204 Total Revenues 2,763,927.00 1,056,978.48 - 1,706,948.52 38.24% Total Expenditures 2,893,296.00 1,112,258.36 110,715.94 1,670,321.70 42.27% Revenue Over(Under) Expenditures (129,369.00) (55,279.88) Drainage, 204 Total Cash in Bank & Investments 1,676,088.70 Hotel Tax, 314 Total Revenues 563,650.00 383,713.19 179,936.81 68.08% Total Expenditures 322,836.00 156,864.22 165,971.78 48.59% Revenue Over(Under) Expenditures 240,814.00 226,848.97 Hotel Tax, 314 Total Cash in Bank & Investments 1,697,174.17 Park, 317 Total Revenues 239,829.69 143,729.96 - (13,729.96) 59.93% Total Expenditures 239,829.69 95,745.40 96,379.38 47,704.91 80.11% Revenue Over(Under) Expenditures 0.00 47,984.56 Park, 317 Total Cash in Bank & Investments 416,958.59 Tree Mitigation, 319 Total Revenues 157,000.00 107,306.24 49,693.76 68.35% Total Expenditures 157,000.00 3,243.00 153,757.00 2.07% Revenue Over(Under) Expenditures 0.00 104,063.24 Tree Mitigation, 319 Total Cash in Bank & Investments 435,975.71 Capital Recovery Water, 411 Total Revenues 1,140,200.00 1,300,562.34 (160,362.34) 114.06% Total Expenditures 256,000.00 1'000.00 255,000.00 0.39% Revenue Over(Under) Expenditures 884,200.00 1,299,562.34 Capital Recovery Water, 411 Total Cash in Bank & Investments 6,144,924.75 Quarterly Statement Sc hertz, Texas CH'Y OF SCHERTZ REVENUE AND EXPENSE REPORT(WIMUDITMD) AS O ne €0 2018 6,994,532.00 CURRENT CURRENT Y -T -D B Dr,'7E ° BUDGET Y-T -D ACTUAL, ENCU BR BAL.ANCE 75% OF BUDGET Capital Recovery Sewer, 421 Total Expenditures 1 1 5,817,792.93 699,660.01 477,079.06 Total Revenues 949,850.00 730,707.70 - 219,142.30 76.96% Total Expenditures 695,200.00 4,268.02 - 690,931.98 0.61% Revenue Over(Under) Expenditures 254,650.00 726,439.68 Capital Recovery Sewer, 421 Total Cash in Bank & Investments Total Revenues 6,350,493.18 4,307,873.00 3,253,340.81 - 829,532.19 Total Revenues 6,994,532.00 6,501,140.39 - 493,391.61 92.95% Total Expenditures 6,994,532.00 5,817,792.93 699,660.01 477,079.06 93.18% Revenue Over(Under) Expenditures 0.00 683,347.46 1 &S, 505 Total Cash in Bank & Investments 2,133,429.59 SED Corporation, 620 Total Revenues 4,307,873.00 3,253,340.81 - 829,532.19 75.52% Total Expenditures 2,434,865.00 1,317,141.82 586.16 1,117,137.02 54.12% Revenue Over(Under) Expenditures 1,873,008.00 1,936,198.99 Total Cash in Bank & Investments 61,895,870.59 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 19,581,110.00 2,328,210.35 16,466,698.25 18,057,075.80 - 1,524,034.20 92.22% Franchises 2,229,264.43 553,741.43 1,528,508.44 1,626,838.88 - 602,425.55 72.98% Permits 1,573,356.00 683,346.39 1,569,626.35 1,801,572.63 - 1,341,409.72 14.74% Licenses 51,160.00 27,930.00 51,255.00 58,930.00 - (7,770.00) 115.19% Fees 2,126,546.00 706,682.08 1,969,059.00 1,917,587.59 - 208,958.41 90.17% Fines 20,000.00 4,824.76 17,606.54 16,788.84 - 3,211.16 83.94% Inter - Jurisdictional 873,008.00 177,966.88 550,869.12 577,401.34 - 295,606.66 66.14% Fund Transfers 4,484,614.00 548,826.78 1,811,816.24 2,088,655.98 - 2,395,958.02 46.57% Miscellaneous 655,400.00 211,681.55 443,890.65 719,108.86 - (63,708.86) 109.72% TOTAL REVENUES 31,594,458.43 5,243,210.22 24,409,329.59 26,863,959,92 - 6,300,124.86 80.06% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 34,699.00 9,641.17 24,225.74 27,215.43 14.40 7,469.17 78.47% Supplies 1,050.00 79.82 389.96 142.73 - 907.27 13.59% City Support Services 41,393.00 519.34 34,368.74 17,776.31 157.80 23,458.89 43.33% Utility Services 641.47 197.59 - 465.07 - 176.40 72.50% Operations Support 500.00 - 336.04 29.00 19.99 451.01 9.80% Staff Support 28,868.53 139.24 20,084.41 22,065.73 - 6,802.80 76.44% Operating Equipment - 723.00 - - - 0.00% TOTAL CITY COUNCIL 107,152.00 10,577.16 80,127.89 67,694.27 192.19 39,265.54 63.36% CITY MANAGER Personnel Services 1,088,445.00 249,171.27 767,322.24 1,014,294.20 - 74,150.80 93.19% Supplies 2,000.00 - 1,270.67 440.50 - 1,559.50 22.03% City Support Services 12,674.32 - 4,989.85 8,154.32 - 4,520.00 64.34% Utility Services - 433.77 118.49 1,009.05 - (1,009.05) 0.00% Operations Support - - 23.98 - - - 0.00% Staff Support 27,060.68 2,520.13 15,218.74 10,292.73 2,227.12 14,540.83 46.27% TOTAL CITY MANAGER 1,130,180.00 252,125.17 788,94197 1,034,190'.80 2,227.12 93,762.08 91.70 %i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 288,987.00 76,934.10 204,659.50 229,613.43 - 59,373.57 79.45% Supplies 2,000.00 291.83 721.59 949.18 - 1,050.82 47.46% City Support Services 1,000.00 - 37.78 157.86 - 842.14 15.79% Operations Support 3,250.00 - - 69.00 - 3,181.00 2.12% Staff Support 8,510.00 836.32 2,757.39 2,889.63 - 5,620.37 33.96% Court Support 700.00 - 186.00 96.00 - 604.00 13.71% Professional Services 67,960.00 16,322.56 40,840.00 44,629.27 3,540.00 19,790.73 70.88% Maintenance Services 3,000.00 500.00 1,920.00 1,500.00 1,450.00 50.00 98.33% Operating Equipment - - 39.02 - - - 0.00% TOTAL MUNICIPAL COURT- 375,407.00 94,884.81 251,161.28 279,904.37 4,990.00 90,512.63 75.89 %< CUSTOMER RELATIONS -311 Personnel Services 115,904.00 32,075.75 87,481.14 93,101.77 - 22,802.23 80.33% Supplies 150.00 3.37 40.30 72.30 - 77.70 48.20% Staff Support 815.00 46.98 170.00 46.98 - 768.02 5.76% Operating Equipment 600.00 - - 554.62 - 45.38 92.44% TOTAL CUSTOMER RELATIONS -311 117,469.00 32,126.10 87,691.44 93,775.67 - 23,69133 79.83% PLANNING & ZONING Personnel Services 202,143.22 56,226.95 143,479.58 160,369.92 - 41,773.30 79.33% Supplies 3,300.00 239.85 695.23 438.91 - 2,861.09 13.30% Operations Support 150.00 - 70.29 7.20 6.90 135.90 9.40% Staff Support 25,490.00 5,384.30 9,573.78 9,212.22 520.00 15,757.78 38.18% Professional Services 100.00 - 100 - 100.00 0.00% Operating Equipment 250.00 - - - - 250.00 0.00% TOTAL PLANNING & ZONING 231,433.22 61,851.10 153,918.88 170,028.25 526.90 60,878.07 73.70% LEGAL SERVICES Operations Support 5,000.00 949.30 1,422.79 1,636.59 325.00 3,038.41 39.23% Professional Services 155,000.00 25,827.35 69,924.62 72,629.46 - 82,370.54 46.86% TOTAL LEGAL SERVICES 160,000.00 26,776.65 71,347.41 74,266.05 325.00 85,408.95 46.62% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET CITY SECRETARY Personnel Services 177,703.00 49,592.40 133,619.74 143,836.45 - 33,866.55 80.94% Supplies 1,050.00 145.59 1,202.51 762.45 - 287.55 72.61% City Support Services 8,500.00 4,898.58 4,975.46 6,957.75 - 1,542.25 81.86% Operations Support 100.00 12.90 - 59.90 - 4010 59.90% Staff Support 6,650.00 36.00 2,794.66 2,192.98 260.00 4,197.02 36.89% TOTAL CITY SECRETARY 194,003.00 54,685.47 142,592.37 153,809.53 260.00 39,933.47 79.42% NON - DEPARTMENTAL City Support Services 696,011.70 3,046.50 327,906.00 287,499.90 100,166.15 308,345.65 55.70% Operations Support 154,500.00 35,141.58 51,956.73 105,138.31 6,243.36 43,118.33 72.09% Staff Support 320.00 - 165.50 80.00 - 240.00 25.00% City Assistance 1,741,562.00 846,544.03 1,585,307.64 1,566,862.31 139,081.25 35,618.44 97.95% Professional Services 44,635.00 16,680.09 64,066.97 48,399.14 29,450.00 (33,214.14) 174.41% Fund Chrgs /Transfrs -Spec Events Fnd 93,733.00 - - - - 93,733.00 0.00% TOTAL NON- DEPARTMENTAL 2,730,761.70 901,412.20 2,029,40284 2;007,979:66 274,940.76 447,841.28 83.60°loi' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 283,164.00 66,714.00 204,723.80 211,808.37 - 71,355.63 74.80% Supplies 2,770.00 604.61 817.29 1,423.95 - 1,346.05 51.41% Operations Support 25,050.00 5,510.49 11,130.12 12,317.98 771.69 11,960.33 52.25% Staff Support 4,230.00 1,249.13 1,279.00 1,919.87 959.34 1,350.79 68.07% Professional Services 3,100.00 3,120.00 22,900.00 3,120.00 - (20.00) 100.65% Operating Equipment 30.00 27.97 - 27.97 - 2.03 93.23% TOTAL PUBLIC AFFAIRS 318,344.00 77,226.20 240,850.21 230,618.14 1,731.03 85,994.83 72.99 %' RECORDS MANAGEMENT Personnel Services 48,926.00 13,338.11 29,512.68 35,838.70 - 13,087.30 73.25% Supplies 100.00 - 31.22 - - 100.00 0.00% Staff Support 355.00 230.53 - 230.53 - 124.47 64.94% Professional Services 16.728.00 7,305.53 7.000.88 11,708.75 281.79 4.737.46 71.68% TOTAL RECORDS MANAGEMENT 66,109.00 20,874.17 36,544;78 47,777.98 281.79 18,04923 72.70% SCHERTZ MAGAZINE Personnel Services 123,853.00 33,669.66 96,753.24 97,339.05 - 26,513.95 78.59% Supplies 200.00 40.58 180.85 40.58 - 159.42 20.29% Opperations Support 2,600.00 626.17 985.25 1,580.09 - 1,019.91 60.77% Staff Support 3,330.00 681.00 1,245.00 2,071.19 400.15 858.66 74.21% Professional Services 255,500.00 56,853.62 170,351.97 189,790.55 35.00 65,674.45 74.30% Fund Charges /Transfers 10,000.00 - - - - 10,000.00 0.00% Operating Equipment - 125.98 - - - 0.00% TOTAL SCHERTZ MAGAZINE 395,483.00 91,871.03 269,642.29 290,821.46 435.15 104,226.39 73.65% ENGINEERING Personnel Services 589,714.00 163,257.13 312,033.97 472,524.32 - 117,189.68 80.13% Supplies 1,572.30 245.41 408.77 491.77 - 1,080.53 31.28% City Support Services 650.00 650.00 295.20 650.00 - - 100.00% Utility Services 3,500.00 856.69 675.76 1,844.78 - 1,655.22 52.71% Operations Support 47.70 - 71.96 47.70 - - 100.00% Staff Support 11,475.00 1,372.48 1,818.38 2,788.16 107.20 8,579.64 25.23% Professional Services 51,967.00 825.00 27,986.40 3,477.50 2,234.08 46,255.42 10.99% Rental /Leasing - - 2,824.47 - - - 0.00% Operating Equipment 400.00 - - - - 400.00 0.00% TOTAL ENGINEERING 659,326.00 167,206.71 346,114.91 481,824.23 2,341`.28 175,160.49 73.43 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 161,063.00 43,869.70 115,204.44 128,352.36 - 32,710.64 79.69% Supplies 1,740.00 45.39 1,575.07 253.86 - 1,486.14 14.59% Staff Support 4,600.00 2,311.90 931.80 3,258.82 - 1,341.18 70.84% Rental /Leasing 2,085.00 520.95 1,562.85 1,562.85 520.95 1.20 0.00% TOTAL GIS 169,488.00 46,747.94 119,274.16 133,427.89 520.95 35,53916 79.03 %! TOTAL GENERAL GOVERNMENT 6,655,155.92 1,838,36471 4,617,612.43 5,066,118`.30 288,772.17 1,300,265.45 80.46 %'i PUBLIC SAFETY POLICE Personnel Services 6,429,458.00 1,609,105.80 4,432,569.80 4,749,904.74 - 1,679,553.26 73.88% Supplies 65,446.80 6,720.52 69,426.07 37,670.26 1,497.04 26,279.50 59.85% City Support Services 21,500.00 - 21,294.42 24,229.52 - (2,729.52) 112.70% Utility Services 106,957.00 23,180.74 51,444.84 54,464.55 - 52,492.45 50.92% Operations Support 7,935.00 689.00 1,752.70 1,503.25 - 6,431.75 18.94% Staff Support 148,758.43 30,719.67 64,188.01 74,714.28 21,152.92 52,891.23 64.44% City Assistance 18,222.00 3,448.07 9,934.17 7,869.69 3,737.54 6,614.77 63.70% Professional Services 49,948.00 19,341.89 31,836.13 44,614.30 1,080.00 4,253.70 91.48% Maintenance Services 57,645.00 7,073.72 28,164.53 31,367.21 4,339.85 21,937.94 61.94% Rental /Leasing - - 44,158.64 - - - 0.00% Operating Equipment 56,923.80 4,186.78 95,090.24 25,642.45 11,873.52 19,407.83 65.91% Capital Outlay 552,317.56 214,283.58 351,345.30 476,480.06 46,225.30 29,612.20 94.64% TOTAL POLICE 7,515,111.59 1,918,749.77 5;201,204.85 5;528,460,31 89,906.17 1,896,745.11 74.76 %'' FIRE RESCUE Personnel Services 4,186,534.00 1,138,962.27 2,606,284.19 3,166,888.62 - 1,019,645.38 75.64% Supplies 18,200.00 3,330.50 3,569.51 7,081.26 2,586.13 8,532.61 53.12% Utility Services 53,650.00 11,464.71 31,772.33 28,092.79 - 25,557.21 52.36% Operations Support 550.00 - - 58.00 - 492.00 10.55% Staff Support 167,875.00 32,440.26 114,137.27 115,084.25 14,427.15 38,363.60 77.15% City Assistance 20,000.00 3,238.40 3,804.22 6,831.32 - 13,168.68 34.16% Professional Services 33,500.00 18,525.00 32,696.00 23,425.00 - 10,075.00 69.93% Maintenance Services 73,000.00 35,311.70 24,067.86 45,239.53 5,485.83 22,274.64 69.49% Other Costs - 3,318.89 - 3,420.94 - (3,420.94) 0.00% Rental/Leasing 23,500.00 3,950.82 11,964.83 11,964.83 3,950.82 7,584.35 67.73% Operating Equipment 107,800.00 22,547.06 46,923.39 39,397.29 14,235.52 54,167.19 49.75% Capital Outlay 97,000.00 44,772.15 37,207.23 79,652.55 24,863.98 (7,516.53) 107.75% TOTAL FIRE RESCUE 4,781,609.00 1,317,861.76 2,912,426.83 3';527,136.38 65,549.43 1',188,923.19 75.14 %> CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 633,766.59 167,125.25 427,075.26 480,082.48 - 153,684.11 75.75% Supplies 4,100.00 591.85 2,263.24 1,231.63 62.11 2,806.26 31.55% Utility Services 5,000.00 1,146.09 2,227.19 2,925.80 - 2,074.20 58.52% Operations Support 2,000.00 387.00 1,516.47 910.00 310.00 780.00 61.00% Staff Support 28,180.00 6,441.26 12,146.17 10,707.32 805.00 16,667.68 40.85% Professional Services 270,400.00 59,700.00 147,175.00 123,890.00 46,510.00 100,000.00 63.02% Operating Equipment 5,500.00 358.97 - 4,373.06 749.00 377.94 93.13% TOTAL INSPECTIONS 948,946.59 235,750.42 592,403.33 624,12029 48,436 11 276,390.19 70.87% MARSHAL'S OFFICE Personnel Services 451,997.00 92,976.21 340,414.64 269,718.06 - 182,278.94 59.67% Supplies 3,475.00 148.28 1,592.68 2,776.94 38.18 659.88 81.01% Utility Services 8,500.00 1,842.43 4,128.56 4,186.40 - 4,313.60 49.25% Operations Support 1,000.00 106.00 274.85 106.00 - 894.00 10.60% Staff Support 11,900.00 2,390.12 4,707.88 3,989.63 669.68 7,240.69 39.15% City Assistance 2,750.00 - - - - 2,750.00 0.00% Maintenance Services 5,100.00 556.00 1,200.00 1,556.00 200.00 3,344.00 34.43% Operating Equipment 5,750.00 88.95 17,483.79 2,631.47 2,125.00 993.53 82.72% TOTAL MARSHAL'S OFFICE 490,472.00 98,107.99 369,802.40 284,964.50 3,032.86 202,474.64 58.72 %' TOTAL PUBLIC SAFETY 13,736,139.18 3,570,469.94 9,075,837.41 9,964,681!'.48 206,924.57 3,564,53113 74.05 %i' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT STREETS Personnel Services 783,442.00 193,122.30 548,062.97 597,233.65 - 186,208.35 76.23% Supplies 82,850.00 16,661.89 48,670.83 55,051.98 3,340.63 24,457.39 70.48% Utility Services 149,200.00 45,639.17 89,560.22 114,016.31 609.53 34,574.16 76.83% Staff Support 11,250.00 2,460.52 9,375.18 7,072.75 204.32 3,972.93 64.69% Professional Services 15,750.00 - 5,037.50 7,937.00 - 7,813.00 50.39% Maintenance Services 69,000.00 68,82079 38,501.12 68,820.79 2,565.00 (2,385.79) 103.46% Rental /Lease 4,000.00 305.25 1,756.48 3,200.57 - 799.43 80.01% Operating Equipment 6,800.00 599.96 4,686.57 4,809.70 - 1,990.30 70.73% Capital Outlay 230,900.00 7,474.78 135,808.04 40,735.16 156,397.74 33,767.10 85.38% TOTAL STREETS 1,353,192.00 335,084.66 881,458.91 898,877.91 163,117.22 291,196.87 78.48% TOTAL PUBLIC ENVIRONMENT 1,353,192.00 335,084.66 881,458.91 898,877.91 163,117.22 291,196.87 78.48% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 526,297.00 115,512.17 370,533.23 357,700.32 - 168,596.68 67.97% Supplies 65,550.00 18,148.71 26,892.01 51,633.37 9,302.45 4,614.18 92.96% City Support Services 10,357.81 4,855.27 8,452.63 7,480.57 - 2,877.24 72.22% Utility Services 222,000.00 84,904.99 147,983.92 166,911.70 6,752.35 48,335.95 78.23% Operations Support 1,000.00 - 1,673.20 878.97 120.00 1.03 99.90% Staff Support 9,850.00 2,787.92 8,870.72 7,280.55 943.88 1,625.57 83.50% Professional Services 137,500.00 22,238.24 60,291.79 43,018.24 7,613.12 86,868.64 36.82% Maintenance Services 17,000.00 468.25 16,060.56 13,446.56 500.00 3,053.44 82.04% Rental /Leasing 29,675.00 9,771.21 28,080.88 28,530.65 128.47 1,015.88 96.58% Operating Equipment 10,100.00 10,904.24 12,555.07 16,543.49 7,038.97 (13,482.46) 233.49% Capital Outlay 71,000.00 - 14,278.54 56,129.68 591.78 99.17% TOTAL PARKS DEPARTMENT 1,100,329.81 269,591:00 681,394.01 707,702.96 88,528.92 304,097.93 72.36 %? SWIM POOL Supplies 18,570.05 2,468.96 14,582.25 8,225.09 4,404.91 5,940.05 68.01% Utility Services 16,000.00 5,403.40 15,207.57 10,717.14 124.02 5,158.84 67.76% Professional Services - - 3,632.56 - - - 0.00% Maintenance Services 658,407.95 116,845.10 231,315.10 261,592.53 3,908.82 392,906.60 40.32% Operating Equipment 1,000.00 1,031.82 - 1,031.82 - (31.82} 103.18% TOTAL SWIM POOL 693,978.00 125,749.28 264,737.48 281,566.58 8,437.75 403,973.67 41.79 %`. CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 60,584.00 15,892.05 45,231.50 46,066.78 - 14,517.22 76.04% Supplies 5,000.00 1,159.13 2,574.57 3,043.07 322.18 1,634.75 67.31% Utility Services 52,600.00 9,369.94 27,551.03 24,788.14 - 27,811.86 47.13% Operations Support 10,200.00 29.00 4,902.53 3,843.59 - 6,356.41 37.68% Staff Support 2,090.00 331.29 1,305.48 651.83 - 1,438.17 31.19% Operating Equipment 21,500.00 3,092.66 3,671.39 8,317.43 - 13,182.57 38.69% TOTAL EVENT FACILITIES ` 151,974.00 29,874.07 85,236.50 86,710`.84 322.18 64,940.98 57.27% TOTAL PARKS &?RECREATION 1,946,281.81 425,214.35 1,031,367.99 1,075,980.38 97,288.85 773,012.58 60.28% CULTURAL LIBRARY Personnel Services 729,748.00 198,300.90 536,649.30 583,642.46 - 146,105.54 79.98% Supplies 15,500.00 3,314.15 9,230.53 6,615.65 2,334.57 6,549.78 57.74% Utility Services 55,500.00 12,982.49 21,888.43 30,240.62 2,432.62 22,826.76 58.87% Operations Support 4,200.00 547.97 1,127.92 3,147.92 - 1,052.08 74.95% Staff Support 7,375.00 2,386.55 4,426.46 4,718.01 - 2,656.99 63.97% 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 112,500.00 27,379.16 75,486.56 92,741.33 5,124.86 14,633.81 86.99% TOTAL LIBRARY 928,598.00 244,911.22 651,061.20 723,423.99 9,892.05 195,281.96 78.97 %` TOTAL CULTURAL 928,598.00 244,911.22 651,061'.20 723,423.99 9,892.05 195,281.96 78.97°lo'i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 338,061.00 73,841.33 243,275.17 218,982.33 - 119,078.67 64.78% Supplies 33,380.00 4,769.98 24,352.62 20,212.35 - 13,167.65 60.55% City Support Services 3,500.00 116.28 2,052.13 791.96 - 2,708.04 22.63% Utility Services 54,500.00 9,763.07 28,501.77 26,261.80 - 28,238.20 48.19% Operations Support 1,000.00 - 711.98 256.07 - 743.93 25.61% Staff Support 10,750.00 90474 3,422.57 3,269.34 595.38 6,885.28 35.95% City Assistance 18,500.00 4,563.05 7,986.87 11,075.32 - 7,424.68 59.87% Professional Services 24,500.00 4,016.00 12,266.64 11,547.01 - 12,952.99 47.13% Maintenance Services 43,380.00 320.00 8,303.92 2,095.00 160.00 41,125.00 5.20% Operating Equipment 31,000.00 7,709.43 5,657.42 8,044.40 812.99 22,142.61 28.57% Capital Outlay 62,000.00 - 27,870.00 - 54,029.20 7,970.80 87.14% TOTAL ANIMAL SERVICES 620,571.00 106,003.88 364,401.09 302,535.58 55, 597.57 262,437.85 57.71% ENVIRONMENTAL HEALTH Personnel Services 208,926.00 27,576.06 136,730.99 115,779.12 - 93,146.88 55.42% Supplies 3,095.00 188.50 620.60 473.45 - 2,621.55 15.30% Operations Support 1,800.00 135.00 702.61 211.00 - 1,589.00 11.72% Staff Support 7,350.00 459.54 2,815.76 2,738.80 - 4,611.20 37.26% City Assistance 1,000.00 243.18 900.81 337.98 - 662.02 33.80% Professional Services 15,500.00 9,530.00 176.00 12,055.00 - 3,445.00 77.77% Maintenance Services 15,000.00 2,348.50 4,985.00 5,298.50 750.00 8,951.50 40.32% Operating Equipment 2,300.00 - 1,284.88 1,666.74 - 633.26 72.47% Capital Outlay 25,605.00 25,605.00 - 25,605.00 - - 100.00% TOTAL ANIMAL SERVICES 280,576.00 66,085.78 148,216.65 164,165.59 750.00 115,660.41 58.78% TOTAL HEALTH ' 901,147.00 172, 089.66 512,617.74 466,701.17 56,347.57 378,098.26 58.04% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 539,540.00 145,315.15 350,612.36 422,271.75 - 117,268.25 78.27% Supplies 7,100.00 651.45 4,849.81 6,761.48 280.73 57.79 99.19% City Support Services 836,362.40 258,263.18 343,778.04 551,412.47 50,347.54 234,602.39 71.95% Utility Services 210,474.00 56,311.66 140,788.91 145,871.83 426.54 64,175.63 69.51% Staff Support 40,000.00 10,208.44 24,129.39 26,211.63 1,784.60 12,003.77 69.99% Professional Services 249,137.00 5,745.10 - 5,745.10 - 243,391.90 2.31% Maintenance Services 14,692.00 8,469.34 10,917.77 10,098.86 969.12 3,624.02 75.33% Rental /Leasing - - 30,397.92 - - - Operating Equipment 270,498.68 25,976.84 158,443.88 162,360.91 28,584.56 79,553.21 70.59% Capital Outlay - 1,609.96 - 1,609.96 78,774.47 (80,384.43) 0.00% TOTAL INFORMATION TECHNOLOGY 2,167,804.0$ 512,551.12 1,063,918.08 1,332,343.99 161,167 56 674,292.53 68.90 %? HUMAN RESOURCES Personnel Services 353,475.00 102,670.02 220,931.91 307,456.70 - 46,018.30 86.98% Supplies 1,000.00 277.80 397.75 524.02 - 475.98 52.40% Human Services 74,500.00 12,365.88 38,043.73 38,386.91 10,850.00 25,263.09 66.09% City Support Services 204.36 - - 204.36 - - 100.00% Utility Services 455.88 113.97 - 341.91 - 113.97 75.00% Operations Support 9,339.76 337.65 3,181.44 6,306.20 861.12 2,172.44 76.74% Staff Support 15,000.00 6,179.46 7,350.23 7,514.84 258.98 7,226.18 51.83% City Assistance 10,000.00 5,160.00 4,578.00 7,745.00 455.00 1,800.00 82.00% Professional Services 9,600.00 2,234.25 7,202.75 6,927.75 2,234.25 438.00 95.44% Operating Equipment 1,000.00 - 614.94 - - 1,000.00 0.00% TOTAL HUMAN RESOURCES 474,575.00 129,339.03 282,300.75 375,407.69 14,659.35 84,507.96 82.19% FINANCE Personnel Services 584,989.00 131,614.07 419,530.35 416,965.27 - 168,023.73 71.28% Supplies 4,160.00 532.35 3,744.37 2,412.26 36.51 1,711.23 58.86% City Support Services - - - 138.00 - (138.00) 0.00% Operations Support 2,155.00 1,200.00 1,916.64 1,200.00 - 955.00 55.68% Staff Support 9,495.00 3,029.22 3,823.73 5,298.48 270.00 3,926.52 58.65% Professional Sevices 31,970.00 - 24,255.00 16,005.00 - 15,965.00 50.06% Operating Equipment 3,770.00 - 112.23 - - 3,770.00 0.00% TOTAL FINANCE 636,539.00 136,375.64 453,382.32 442,019.01 306.51 194,21148 "69.49% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PURCHASING & ASSET MGT 810,968.00 213,646.88 579,580.25 589,215.89 - 221,752.11 Personnel Services 207,405.00 41,195.46 127,653.89 149,624.08 - 57,780.92 72.14% Supplies 1,050.00 61.13 599.96 180.57 49.88 819.55 21.95% Utility Services 250.00 98.33 107.75 193.35 56.65 77.34% Operations Support 3,150.00 53.15 26.35 53.15 564.00 2,532.85 19.59% Staff Support 6,054.00 463.87 1,825.69 2,566.61 63.95 3,423.44 43.45% City Assistance 3,000.00 251.00 1,036.00 423.00 67.00 2,510.00 16.33% Operating Equipment 546.00 545.99 - 545.99 - 0.01 100.00% Capital Outlay 29,000.00 - - - 28,058.22 941.78 96.75% TOTAL PURCHASING & ASSET MGT 250,455.00 42,668.93 131,249.64 153,586.75 28,803.05 68,065.20 72.82% FLEET SERVICE 5,000.00 - 2,210.69 3,077.95 - 1,922.05 Personnel Services 337,173.00 75,799.21 252,425.96 234,103.75 - 103,069.25 69.43% Supplies 131,500.00 51,756.13 127,340.66 114,243.56 13,061.24 4,195.20 96.81% City Support Services 6,500.00 10,29133 2,354.40 13,117.77 - (6,617.77) 201.81% Utility Services 7,000.00 3,532.10 5,298.56 6,958.86 - 41.14 99.41% Operations Support 200.00 - 59.69 - - 200.00 0.00% Staff Support 19,810.00 895.64 5,255.99 6,525.33 253.64 13,031.03 34.22% Maintenance Services 132,750.00 34,047.07 121,978.33 136,018.52 6,848.71 (10,117.23) 107.62% Operating Equipment 8,200.00 - 4,719.30 1,296.86 - 6,903.14 15.82% Capital Outlay 89,000.00 26,491.00 - 26,491.00 29,658.22 32,850.78 63.09% TOTAL FLEET SERVICE 732,133.00 202,812.48 519,432.89 538,755.65 49,821.81 143,555.54 80.39% FACILITY SERVICES Personnel Services 810,968.00 213,646.88 579,580.25 589,215.89 - 221,752.11 72.66% Supplies 110,500.00 25,459.94 75,395.31 82,776.58 5,576.53 22,146.89 79.96% City Support Services 10,219.00 - - - - 10,219.00 0.00% Utility Services 159,515.00 35,304.31 87,610.44 101,303.28 644.17 57,567.55 63.91% Operation Support - 14,675.87 - 24,734.67 10,713.00 (35,447.67) 0.00% Staff Support 14,200.00 1,299.26 8,524.23 5,231.83 397.92 8,570.25 39.65% Professional Services 48,271.36 16,173.40 - 28,364.61 3,212.60 16,694.15 65.42% Maintenance Services 204,728.64 59,679.40 265,830.86 154,731.11 9,917.60 40,079.93 80.42% Rental /Leasing 5,000.00 - 2,210.69 3,077.95 - 1,922.05 61.56% Operating Equipment 21,520.00 1,920.02 2,107.91 1,920.02 - 19,599.98 8.92% Capital Outlay 68,261.00 - 25,825.70 - 59,316.44 8,944.56 86.90% TOTAL BUILDING MAINTENANCE 1,453,18100 368,159.08 1,047,085.39 991,355.94 89,778.26 372,048.80 74.40% TOTAL INTERNAL SERVICE 5,714,689.08 1,391,906.28 3,497,369 07 3,833,469.03 344,536'.54 1?,536,683.51 73.11% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 2 0 17 - 2 0 18 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 313,872.00 87,596.22 201,912.09 217,420.35 30,686.10 65,765.55 79.05% TOTAL CITY ASSISTANCE 313,872.00 87,596.22 201,912.09 217,420.35 30,686.10 65,765.55 79.05% 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,535x00 19,448.00 11.53% TOTAL MISC & PROJECTS 335,855.00 87,596.22 202,269.09 217,420:35 33,221.10 85,213.55 74.63% TOTAL EXPENDITURES 31,571,057.99 8,065,637.04 20,469,593.84 22,246,672.61 1,200,100.07 8,124,285.31 74.27% REVENUE OVER(UNDER) EXPEND. 23,400.44 - 4,617,287,31 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 11,726,025.00 157,293.22 11,073,815.33 11,771,798.48 - (45,773.48) 100.39% 000 - 411200 Advalorem Tax - Delinquent 50,000.00 18,376.59 (10,541.57) 41,144.33 - 8,855.67 82.29% 000 - 411300 Advalorem Tax - P &I 50,000.00 20,037.26 45,082.59 71,139.17 - (21,139.17) 142.28% 000 - 411500 Sales Tax Revenue -Gen Fund 7,711,085.00 2,121,623.67 5,326,232.12 6,140,195.66 - 1,570,889.34 79.63% 000 - 411600 Bingo Tax - - 31.25 11.25 - (11.25) 0.00% 000 - 411700 Mixed Beverage Tax 44,000.00 10,879.61 32,078.53 32,786.91 - 11,213.09 74.52% TOTAL Taxes 19,581,110.00 2,328,210.35 16,466,698.25 18,057,075.80 - 1,524,034.20 92.22 %d1 Franchises 000 - 421200 Center Point /Entex Energy 67,793.07 15,522.46 54,803.19 66,037.05 - 1,756.02 97.41% 000 - 421220 City Public Service 946,887.77 264,632.34 638,697.26 706,781.81 - 240,105.96 74.64% 000 - 421240 Guadalupe Valley Elec Co -op 416,134.03 94,004.31 289,363.72 308,715.45 - 107,418.58 74.19% 000 - 421250 New Braunfels Utilities 75,393.90 20,141.10 49,586.64 50,966.69 - 24,427.21 67.60% 000 - 421300 Time Warner -State Franchise 269,019.90 56,156.97 203,935.41 199,194.64 - 69,825.26 74.04% 000 - 421460 AT &T Franchise Fee 191,123.61 45,738.84 130,062.71 95,290.55 - 95,833.06 49.86% 000 - 421480 Other Telecom Franchise 113,964.44 31,487.90 55,418.78 99,713.90 - 14,250.54 87.50% 000 - 421500 Solid Waste Franchise Fee 148,947.71 26,057.51 106,640.73 100,138.79 - 48,808.92 67.23% TOTAL Franchises 2,229,264.43 553,741.43 1,528,508.44 1,626,838.88 - 602,425.55 72.98% Permits 000 - 431100 Home Occupation Permit 500.00 70.00 490.00 490.00 - 10.00 98.00% 000 - 431205 Building Permit - Residential 573,156.00 180,158.00 468,917.50 522,865.50 - 50,290.50 91.23% 000 - 431210 Building Permit - Commercial 370,400.00 232,258.50 595,837.00 641,774.50 - (271,374.50) 173.27% 000 - 431215 Building Permit - General 150,000.00 140,025.00 148,094.00 219,748.00 - (69,748.00) 146.50% 000 - 431300 Mobile Home Permit 300.00 200.00 225.00 250.00 - 50.00 83.33% 000 - 431400 Signs Permit 6,000.00 1,280.00 3,930.00 3,579.00 - 2,421.00 59.65% 000 - 431500 Food Establishmnt Permit 60,000.00 1,025.00 57,890.00 57,890.00 - 2,110.00 96.48% 000 - 431600 Garage Sale Permit 10,500.00 - 7,024.00 2,135.00 - 8,365.00 20.33% 000 - 431700 Plumbing Permit 121,000.00 42,843.25 103,712.00 125,972.95 - (4,972.95) 104.11% 000 - 431750 Electrical Permit 61,000.00 24,060.00 53,320.00 61,840.00 - (840.00) 101.38% 000 - 431800 Mechanical Permit 62,000.00 21,660.00 51,240.00 57,220.00 - 4,780.00 92.29% 000 - 431900 Solicitor /Peddler Permit 1,500.00 1,500.00 1,004.50 1,910.00 - (410.00) 127.33% 000 - 431950 Animal/Pet Permit 1,000.00 - 215.00 90.00 - 910.00 9.00% 000 - 432000 Cert. of Occupancy Prmt 7,000.00 1,450.00 5,250.00 4,550.00 - 2,450.00 65.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 36,000.00 15,572.00 30,596.00 36,088.00 - (88.00) 100.24% 000 - 432300 Grading /Clearing Permit 7,000.00 6,481.36 5,900.00 12,641.72 - (5,641.72) 180.60% 000 - 432400 Development Permit 81,000.00 6,063.80 14,456.35 23,554.48 57,445.52 29.08% 000 - 435000 Fire Permit 25,000.00 8,699.48 21,525.00 27,223.48 - (2,223.48) 108.89% 000 - 436010 Network Nodes - - - 1,750.00 - (1,750.00) 0.00% TOTAL Permits 1,573,356.00 683,346.39 1;569,626:35 1,801,572.63 - (228,216.63) 14.7% Licenses 000 - 441000 Alcohol Beverage License 8,000.00 1,890.00 6,110.00 5,515.00 - 2,485.00 68.94% 000 - 441300 Mobile Home License 160.00 40.00 160.00 80.00 - 80.00 50.00% 000 - 442000 Contractors License 40,000.00 25,510.00 42,450.00 51,360.00 - (11,360.00) 128.40% 000 - 444000 Pet License 3,000.00 490.00 2,535.00 1,975.00 - 1,025.00 65.83% TOTAL Licenses 51,160`00 27,930.00 51,255.00 58,930.00 - (7,770.00) 115.19% Fees 000 - 451000 Municipal Court Fines 682,252.00 170,206.85 607,028.82 460,672.85 - 221,579.15 67.52% 000 - 451100 Arrest Fee 21,714.00 6,548.65 21,366.42 16,467.07 - 5,246.93 75.84% 000 - 451110 Expunction Fee 120.00 - 90.00 - - 120.00 0.00% 000 - 451200 Warrant Fees 124,000.00 18,214.50 83,763.88 58,742.81 - 65,257.19 47.37% 000 - 451210 Court - Claims & Judgements - 806.10 (461.40) 806.10 - (806.10) 0.00% 000 - 451340 Judicial Fee - City 3,152.00 865.15 2,957.80 2,253.07 - 898.93 71.48% 000 - 451400 Traffic Fine Costs TTL 10,265.00 2,938.57 10,151.91 7,557.48 - 2,707.52 73.62% 000 - 451510 Juvenile Case Mgmt Fee 26,352.00 7,229.72 24,683.95 18,826.52 - 7,525.48 71.44% 000 - 451520 Truancy Fee 4,464.00 1,221.02 4,340.76 3,237.96 1,226.04 72.53% 000 - 451600 Technology Fund Fee 21,983.00 5,850.39 19,848.62 15,068.61 - 6,914.39 68.55% 000 - 451700 Security Fee 15,817.00 4,387.81 14,886.48 11,396.40 - 4,420.60 72.05% 000 - 451800 Time Payment Fee - City 9,689.00 1,093.80 5,012.05 3,858.78 - 5,830.22 39.83% 000 - 451850 State Fines 10% Service Fee 20,488.00 7,089.26 29,228.42 21,475.76 - (987.76) 104.82% 000 - 451900 DPS Payment - Local 8,829.00 1,400.00 6,198.14 4,625.21 - 4,203.79 52.39% 000 - 452000 Child Safety Fee 3,810.00 2,744.46 2,913.48 4,944.11 - (1,134.11) 129.77% 000 - 452100 Platting Fees 62,000.00 18,500.00 52,500.00 39,750.00 - 22,250.00 64.11% 000 - 452200 Site Plan Fee 43,500.00 6,000.00 24,500.00 32,500.00 - 11,000.00 74.71% 000 - 452300 Plan Check Fee 463,261.00 237,485.50 602,583.00 654,895.50 - (191,634.50) 141.37% 000 - 452320 Tree Mitigation Admin Fee 20,000.00 12,275.10 10,352.70 17,368.50 - 2,631.50 86.84% 000 - 452400 BOA/Zoning Fees 5,000.00 1,277.64 2,610.51 3,277.64 - 1,722.36 65.55% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 14,300.00 1,150.00 15,000.00 20,450.00 - (6,150.00) 143.01% 000 - 452710 Zoning Ltr & Dev Rights 1,200.00 450.00 2,250.00 1,200.00 - - 100.00% 000 - 453100 Reinspection Fees 90,000.00 50,525.00 84,125.00 114,600.00 - (24,600.00) 127.33% 000 - 453110 Swim Pool Inspection Fee 2,600.00 2,620.00 1,760.00 2,620.00 - (20.00) 100.77% 000 - 453200 Lot Abatement 5,000.00 475.00 1,325.50 1,615.00 - 3,385.00 32.30% 000 - 453211 Admin Fee - Inspections 10,400.00 10,200.00 10,800.00 21,600.00 - (11,200.00) 207.69% 000 - 453310 Misc Inspection Fee - 1,213.00 - 3,213.00 - (3,213.00) 0.00% 000 - 453710 Foster Care 1,000.00 400.00 900.00 850.00 - 150.00 85.00% 000 - 454200 Pool Gate Admission Fee 24,000.00 6,881.00 9,020.00 6,881.00 - 17,119.00 28.67% 000 - 454300 Seasonal Pool Pass Fee 5,000.00 3,510.00 5,144.00 3,510.00 - 1,490.00 70.20% 000 - 456120 Senior Center Meal Fee - 401.00 401.00 802.00 - (802.00) 0.00% 000 - 456500 Haz Mat Fees 5,000.00 - 400.00 - - 5,000.00 0.00% 000 - 456600 Fire Re- inspection Fee 1,000.00 445.00 900.00 895.00 - 105.00 89.50% 000 - 456600 Sale of General Fixed Asset - - - 19,251.61 - (19,251.61) 0.00% 000 - 458110 Sale of Merchandise- GovDeal 40,000.00 3,842.89 25,904.77 34,628.95 - 5,371.05 86.57% 000 - 458300 Sale of Property /Auction 3,000.00 - - - - 3,000.00 0.00% 000 - 458400 Civic Center Rental Fees 200,000.00 49,745.50 147,129.00 152,579.50 - 47,420.50 76.29% 000 - 458401 Capital Recovery Fee -Civic Cntr 10,000.00 4,125.00 12,335.00 6,245.00 - 3,755.00 62.45% 000 - 458450 North Center Rental Fees 18,500.00 7,900.00 18,412.50 19,735.00 (1,235.00) 106.68% 000 - 458460 Senior Center Rental 15,000.00 2,500.00 8,100.00 2,500.00 - 12,500.00 16.67% 000 - 458500 Community Center Rental Fees 25,000.00 11,354.00 23,335.50 31,659.50 - (6,659.50) 126.64% 000 - 458550 Pavilion Rental Fees 20,000.00 7,835.00 14,150.50 15,597.50 - 4,402.50 77.99% 000 - 458560 Chamber of Comm rent 7,800.00 1,950.00 5,850.00 5,850.00 - 1,950.00 75.00% 000 - 458570 Non - Resident SYSA League 10,000.00 - - 13,080.00 - (3,080.00) 130.80% 000 - 458650 NonResident User Fee -BVYA 10,000.00 6,090.00 1,506.00 9,090.00 - 910.00 90.90% 000 - 458660 BVYA Utility Reimbursement 15,000.00 13,295.98 17,985.79 13,295.98 - 1,704.02 88.64% 000 - 458670 SYSA Utility Reimbursement - 2,882.29 - 5,464.58 - (5,464.58) 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,400.00 7,330.00 8,070.00 - 1,930.00 80.70% 000 - 459200 NSF Check Fee 250.00 25.00 50.00 25.00 - 225.00 10.00% 000 - 459300 Notary Fee 250.00 12.00 108.00 90.00 - 160.00 36.00% 000 - 459400 Maps, Copies, UDC, & Misc F 250.00 15.00 5.00 25.00 - 225.00 10.00% 000 - 459600 Animal Adoption Fee 12,500.00 5,736.90 14,965.00 12,912.90 - (412.90) 103.30% 000 - 459700 Pet Impoundment Fee 7,000.00 1,115.00 4,927.50 4,797.20 - 2,202.80 68.53% 000 - 459800 Police Reports Fee 5,800.00 1,453.00 4,523.40 4,385.50 - 1,414.50 75.61% TOTAL Fees 2,126,546.00 706,682.08 1;969,059:00 1,917,587.59 - 208,958.41 90.17% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 20,000.00 4,824.76 17,606.54 16,788.84 - 3,211.16 83.94% TOTAL Fines 20,000.00 4,824.76 17,606.54 16,788.84 - 3,211`.16 83.94% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,077.00 - 21,077.76 21,077.76 - (0.76) 100.00% 000 - 473200 City of Seguin - Fire Contract 29,231.00 9,743.60 21,923.10 21,923.10 - 7,307.90 75.00% 000 - 473300 Guad Co - Library 218,000.00 18,096.00 162,864.00 144,768.00 - 73,232.00 66.41% 000 - 473400 Randolph AFB - Animal Cntrl 1,200.00 - 500.00 200.00 - 1,000.00 16.67% 000 - 474200 Library Services - Cibolo 35,000.00 - - 35,001.50 - (1.50) 100.00% 000 - 474210 Library Services -Selma 20,000.00 - - 21,750.00 - (1,750.00) 108.75% 000 - 474400 Dispatch Service - Cibolo 166,000.00 120,000.00 120,000.00 120,000.00 - 46,000.00 72.29% 000 - 474600 School Crossing Guard - Bexar 38,000.00 14,711.56 30,942.65 33,059.39 - 4,940.61 87.00% 000 - 474610 School Cross Guard - Guadalupe 38,000.00 15,405.72 28,561.61 33,361.59 - 4,638.41 87.79% 000 - 474620 School Crossing Guard -Coma) 1,500.00 - - - - 1,500.00 0.00% 000 - 474700 School Officer Funding 255,000.00 - 127,500.00 127,500.00 - 127,500.00 50.00% 000 - 474750 Crime Victim Liaison Agreement 50,000.00 10.00 37,500.00 18,760.00 - 31,240.00 37.52% TOTAL Inter - Jurisdictional 873,008.00 177,966.88 550,869:12 577,401.34 - 295,606.66 66.14 %' Fund Transfers 000 - 480000 Indirect Costs - EMS 170,087.00 42,521.76 112,565.25 127,565.16 - 42,521.84 75.00% 000 - 480100 Indirect Costs - Hotel /Motel 67,605.00 16,601.25 49,803.75 49,803.75 - 17,801.25 73.67% 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.51 138,318.75 203,572.41 - 67,857.59 75.00% 000 - 486000 Interfund Chrges -Admin W &S 1,344,140.00 336,035.01 890,109.00 1,008,104.91 - 336,035.09 75.00% 000 - 487000 Interfund Charges -Fleet 344,026.00 85,811.25 298,185.75 258,214.75 - 85,811.25 75.06% 000 - 488000 Interfund Charges -413 441,395.00 - 322,833.74 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 548,826.78 1;811,816:24 2,088,655.98 - 2,395,958.02 46.57% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 1,500.00 7,949.65 716.76 21,003.29 - (19,503.29) 1400.22% 000 - 491200 Investment Income 150,000.00 77,938.16 100,963.52 167,013.00 - (17,013.00) 111.34% 000 - 491800 Gain /Loss - (11,351.34) (1,049.53) (16,041.86) - 16,041.86 0.00% 000 - 491900 Unrealized Gain /Loss (30,000.00) 9,461.42 (9,220.99) (8.73) - (29,991.27) 0.00% 000 - 493000 Donations - Others - 20.00 - 20.00 - (20.00) 0.00% 000 - 493120 Donations - Public Library 2,500.00 865.36 3,996.65 5,831.16 - (3,331.16) 233.25% 000 - 493400 Donation - Animal Control 15,000.00 2,020.80 13,287.27 12,295.67 - 2,704.33 81.97% 000 - 493401 Donations -A/C Microchip 1,000.00 135.00 250.00 495.00 - 505.00 49.50% 000 - 493402 Donations - Spay &Neuter 1,000.00 - 810.00 87.00 - 913.00 8.70% 000 - 493403 Donations - Animal Adoption Trailer - - 552.29 - - - 0.00% 000 - 493404 Donations -TNR Program 500.00 - - - - 500.00 0.00% 000 - 493460 Donations -Parks - 2,825.00 13,741.09 10,825.00 - (10,825.00) 0.00% 000 - 493465 Donations - Senior Center - 3,064.65 8,066.72 8,232.55 - (8,232.55) 0.00% 000 - 493502 Donations -PD - 28,599.00 5,234.25 28,599.00 - (28,599.00) 0.00% 000 - 493503 Donations -Fire Rescue - 5,000.00 21.00 15,350.00 - (15,350.00) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,650.00 - 3,679.47 3,823.43 - (173.43) 104.75% 000 - 494482 Grants - Police, Fire, Gen Fund 5,000.00 (1,496.33) 4,892.03 1,473.67 - 3,526.33 29.47% 000 - 495100 Mobile Stage Rental Fees - 1,550.00 1,550.00 2,100.00 - (2,100.00) 0.00% 000 - 497000 Misc Income -Gen Fund 30,000.00 10,129.17 12,736.38 68,675.34 - (38,675.34) 228.92% 000 - 497005 Schertz Magazine Advertising 195,000.00 43,570.00 145,525.00 108,055.00 - 86,945.00 55.41% 000 - 497100 Misc Income - Police 18,500.00 2,278.39 16,677.96 4,367.10 - 14,132.90 23.61% 000 - 497150 Misc Income -Fire Department - 1,345.11 1,750.00 1,345.11 - (1,345.11) 0.00% 000 - 497200 Misc Income - Library 5,000.00 1,385.61 3,661.60 3,855.20 - 1,144.80 77.10% 000 - 497210 Misc Income - Library Copier 18,000.00 4,974.55 13,253.10 14,220.15 - 3,779.85 79.00% 000 - 497300 Misc Income - Animal Control - - 390.00 298.75 - (298.75) 0.00% 000 - 497400 Misc Income - Streets Dept. 60,000.00 10,367.87 47,596.30 22,063.97 - 37,936.03 36.77% 000 - 497500 Misc Income -TML Insurance 10,000.00 - 9,252.06 33,050.83 - (23,050.83) 330.51% 000 - 497550 Misc Income -TML Reimbursemt 20,000.00 843.34 10,866.33 1,471.48 - 18,528.52 7.36% 000 - 497600 Misc Income - Vending Mach. 2,500.00 861.76 1,495.39 1,786.33 - 713.67 71.45% 000 - 497610 Misc Income- Muni Court - - - 2,036.40 - (2,036.40) 0.00% 000 - 498000 Reimbursmnt -Gen Fund 35,000.00 6,715.77 19,484.63 8,355.21 - 26,644.79 23.87% 000 - 498100 Reimbursmnt Fire - Training 500.00 - 7.00 - - 500.00 0.00% 000 - 498105 Reimburmnt Police - DEA 5,000.00 2,628.61 5,763.94 2,628.61 - 2,371.39 52.57% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 100,000.00 - 3,267.16 179,445.81 - (79,445.81) 179.45% 000 - 498150 Reimbursemnt - Library 5,750.00 - 4,673.27 6,355.39 - (605.39) 110.53% TOTAL Miscellaneous 655,400.00 211,681.55 443,890.65 719,108.86 - (63,708.86) 109.72 %' TOTAL REVENUES 31,594,458.43 5,243,210.22 24,409,329.59 26,863,959.92 - 4,730,498.51 80.06 %' GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 843,754.50 Cash in Investments LOGIC Investment - General Fund 12,474,571.95 LOGIC Investment -Equip Replacement 75,775.25 LOGIC Investment -Veh Replacement 510,935.17 LOGIC Investment -Air Condi Replacment 278,054.95 CAPITAL ONE Investment - General Fund 1,367,159.86 Total Cash in Bank & Investments $15,696,833.52 OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP F, 2017-18 100,310 505,909 5,577,660 3,375,990 1,936,953 117,684 82,856 52,620 21,817 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 CITY PUBLIC SERVICE OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP - - - - - -- 2017 -18 271,335 - - - - - -- -- - - - - -- -------- - - - - -- 280,083 -- - - - - -- - -- - - -- -- - - - - -- - - - - - - -- -- - - - - -- - - - ------------------------ - -- ---- - - - - -j 213,511 2016 -17 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 CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JUNE 3O.2O18 2017'301D 106-SPECkuL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Yq-D BUDGET 75% 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 _86,400J00 26,826/K9 7339303 6072792 �_ 35,6/72U}8 63.00% TOTALREVENUES 170,20000 26,826.49 73,393.03 60,727.92 109,472.08 35,68% EXPENDITURE SUMMARY CULTURAL Festival ofAngels 13.000.00 10.912.90 10.566.23 2,433.77 81.28% Employee Appreciation Event 13.000.00 2.090.12 10.33872 12.003.97 - 880.03 92.34% 4th uf July Jubilee 20.000.00 42.88 4.212.50 142.88 19.810.10 0.040.80 70.74% National Night Out 400.00 - - - - 400.00 0.00% VVi|onohik Walk for Life 20.000.00 824.00 12.620.00 3.408.68 310.00 10.280.32 18.60% Schertz Fest 30.000.00 33.98 35.00 853.98 240.00 29.100.02 2.98% SohoUzSwmotheart 31.250.00 6.621.80 13.431.04 12.482.01 3.008.04 15.758.35 48.57% Hal Baldwin Scholarship 15.050.00 5.000.00 14.047.17 13.537.61 7.00 1.505.39 80D0% Other Events _21,500/00 __10,365.33 750752 1071508 ____1.00 __4783.31 77.75% TOTAL CULTURAL 170,200.00 25,084.21 73,165.45 69,512.05 23,377.80 77,310.15 54.58% TOTAL EXPENDITURES 170,200.00 25,084.21 73,165.45 69,512.05 23,377.80 77,310.15 54.58% REVENUE OVER(UNDER) EXPEND - 1,742.28 227.58 A-7 8 �41 3 32,161.93 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 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 88.30 12103 214.73 - (64.73) 143.15% 000 - 492200 Wilenchik Walk for Life 20,000.00 (40.00) 12,620.00 10,525.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 22,125.00 26,565.00 22,125.00 - 3,875.00 85.10% 000 - 493150 SchertzQ 30,000.00 - - 200.00 - 29,800.00 0.67% 000 - 493455 Proceeds - Festival of Angels 700.00 - 5,615.00 1,305.00 - (605.00) 186.43% 000 - 493460 Schertz Sweetheart 1,500.00 (20.81) 1,705.00 (20.81) - 1,520.81 -1.39% 000 - 493470 Moving on Main 680.00 - 680.00 000 - 493621 Hal Baldwin Scholarship 15,050.00 - 25,765.00 20,105.00 - (5,055.00) 133.59% 000 - 497000 Misc Income - 3,994.00 1,000.00 5,594.00 - (5,594.00) 0.00% TOTAL Miscellaneous 96,400.00 26,826.49 73,393.03 60,727.92 - 35,672.08 63.00 %1 TOTAL REVENUES 170,200.00 26,826.49 '' 73,393.03 60,727.92 - 109,472.08 35.68 %'s SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 58,460.91 Cash in Investments Texas Class- Special Events 17,281.07 Total Cash in Bank & Investments $ 75,741.98 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 93,300.00 - 67,771.31 21,430.96 - 71,869.04 22.97% Fund Transfers 106,700.00 - - - - 106,700.00 0.00% TOTAL REVENUES 200,000.00 - 67,771.31 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 - - 67,322.31 21,430.96 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 k****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% 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 - 39,887.09 14,010.64 - 40,989.36 25.47% 000 - 421465 AT &T PEG Fee 38,300.00 - 27,884.22 7,420.32 - 30,879.68 19.37% TOTAL Franchises 93,300.00 - 67,771:31 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 - 67,771.31 21,430.96 - 178,569.04 10.72 %> PEG FUND CASH IN BANK AND INVESTMENTS AS OF: June 30, 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: June 30, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 238,260.00 141,743.07 197,221.80 212,931 - 25,328.85 89.37% Permits - - 49,563.52 - - - 0.00% Fees 22,013,250.00 5,774,582.28 15,592,431.39 16,723,833 - 5,289,417.49 75.97% Fund Transfers 194,546.00 35,377.50 102,690.00 106,133 - 88,413.50 54.55% Miscellaneous 206,614.00 75,088.85 421,102.08 223,061 - (16,446.58) 107.96% TOTAL REVENUES 22,652,670.00 6,026,791.70 16,363,008.79 17,265,956.74 - ; 5,386,713.26 76.22% *14 =041 k911111:1411.011MAT A WA BUSINESS OFFICE Personnel Services 480,038.00 119,364.84 318,324.06 346,189.06 - 133,848.94 72.12% Supplies 3,800.00 965.73 467.96 1,501.23 239.62 2,059.15 45.81% Human Services 400.00 - 203.00 - - 400.00 0.00% City Support Services 2,273.00 - 27.50 - - 2,273.00 0.00% Utility Services 900.00 341.27 391.64 750.65 85.40 63.95 92.89% Operations Support 156,300.00 47,283.70 83,999.67 107,682.12 0.99 48,616.89 68.90% Staff Support 6,970.00 1,57736 2,498.34 2,184.21 847.46 3,938.33 43.50% Professional Services 120,000.00 60,434.80 97,924.44 151,675.14 1,040.00 (32,715.14) 127.26% Maintenance Services 8,040.00 840.00 4,860.00 4,860.00 2,200.00 980.00 87.81% Operating Equipment 3,607.00 139.99 - 3,656.94 - (49.94) 101.38% TOTAL BUSINESS OFFICE 782,328.00 230,947.69 508,696.61 618,499.35 4,41'3.47 159,415.18 ` 79:62% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: June 30, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8 * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET W & S ADMINISTRATION Personnel Services 1,382,056.36 327,699.62 785,659.53 913,816.58 - 468,239.78 66.12% Supplies 217,500.00 35,664.99 132,583.23 129,687.81 (17,903.75) 105,715.94 51.39% Human Services 600.00 - 539.00 - - 600.00 0.00% City Support Services 80,500.00 13,546.58 64,271.87 59,227.78 - 21,272.22 73.57% Utility Services 3,522,329.00 898,418.47 2,212,190.79 2,396,639.28 299.47 1,125,390.25 68.05% Operations Support 11,600.00 1,826.13 4,002.06 4,542.20 - 7,057.80 39.16% Staff Support 29,250.00 4,905.13 13,992.74 19,914.82 743.10 8,592.08 70.63% City Assistance 1,500.00 111.00 1,337.00 111.00 - 1,389.00 7.40% Professional Services 368.00 90,319.16 210,894.36 223,289.14 3,853.54 (226,774.68) # # # # # # ## Fund Charges /Transfers 5,092,110.00 839,329.29 3,529,188.73 4,046,556.09 - 1,045,553.91 79.47% Maintenance Services 8,609,240.00 1,662,891.45 5,434,511.62 5,315,601.90 537,729.28 2,755,908.82 67.99% Other Costs 37,500.00 10.00 36,605.45 36,615.45 - 884.55 97.64% Debt Service 1,626,779.00 - 743,932.97 738,634.30 58,381.25 829,763.45 48.99% Rental- Leasing 124,500.00 - 23,501.89 2,782.95 - 121,717.05 2.24% Operating Equipment 9,000.00 799.94 515.00 826.79 3,203.15 4,970.06 4438% Capital Outlay 397,877.64 - - - 397,477.64 400.00 99.90% TOTAL PUBLIC WORKS 21,142,710.00 3,875;521.76 13,193,726.24 13,888,246.09 983,783.68 6,270;680.23 70.34% 8I6Y01? 1=00111x4 < PROJECTS Operations Support 965.00 - 964.26 - 0.74 99.92% Professional Services 53,802.00 3,086.25 24,480.00 8,457.50 6,172.50 39,172.00 27.19% Maintenance Services 820,037.00 161,619.75 - 391,537.00 - 428,500.00 47.75% TOTAL PROJECTS 874;804.00 '' 164,706.00 24,480.00 400,958.76 6,172.50 467;672.74 46.54°%' 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 1,234,804.00 164,706 24,480 400,959 6`,173 827,673 32.97 %' TOTAL EXPENDITURES 23,159,842.00 4,271,175.45 13,726,902.85 14,907,704.20 994,369.65 7,257;768.15 ; 68.66% " REVENUE OVER(UNDER)EXPENSES ** (507,172.00) 1,755,616.25 's 2,636,105.94 2,358,252.54 (994,369.65) (1,871,054.89); 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 238,260.00 141,743.07 197,221.80 212,931.15 - 25,328.85 89.37% TOTAL Franchises 238,260.00 141,743.07 197,221.80 212,931.15 - 25,328.85 89.37 %' 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,271,755.63 3,450,025.96 3,666,297.08 - 1,183,702.92 75.59% 000 - 455500 Water & Sewer Transfer Fee - (10.00) - (10.00) - 10.00 0.00% 000 - 455600 Fire Line Fees 31,000.00 - 29,540.00 29,015.00 - 1,985.00 93.60% 000 - 455700 Recycle Fee Revenue 309,750.00 75,308.63 220,829.71 227,885.96 - 81,864.04 73.57% 000 - 455800 W &S Line Constructn Reimbursemnt 20,000.00 10,829.78 26,175.60 28,379.57 - (8,379.57) 141.90% 000 - 457100 Sale of Water 9,825,000.00 2,656,039.04 6,733,966.66 7,387,177.45 - 2,437,822.55 75.19% 000 - 457110 Edwards Water Lease 125,000.00 - 125,531.25 28,172.25 - 96,827.75 22.54% 000 - 457120 Water Transfer Charge -Selma 50,000.00 6,232.51 24,641.14 6,232.51 - 43,767.49 12.47% 000 - 457200 Sale of Meters 80,000.00 41,066.20 83,574.62 115,295.03 - (35,295.03) 144.12% 000 - 457400 Sewer Charges 6,500,000.00 1,653,314.57 4,715,960.06 5,035,622.96 - 1,464,377.04 77.47% 000 - 457500 Water Penalties 220,000.00 59,470.92 180,336.39 197,564.70 - 22,435.30 89.80% 000 - 459200 NSF Check Fee -Water &Sewer 2,500.00 575.00 1,850.00 2,200.00 - 300.00 88.00% TOTAL Fees 22,013,250.00 5,774,582.28 15;592,431.39 16,723,832.51 - 5,289,417.49 75.97% 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 102,690.00 106,132.50 - 35,377.50 75.00% TOTAL Fund Transfers 194,546.00 35,377.50 >102,690.00 106,132.50 - 88,413.50 54.55 %! CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: June 30, 2018 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 500.00 2,805.00 279,951.71 8,392.00 - (7,892.00) 1678.40% 000 - 491000 Interest Earned 1,500.00 10,961.07 895.75 22,380.68 - (20,880.68) 1492.05% 000 - 491200 Investment Income 60,000.00 31,512.77 39,593.41 91,546.16 - (31,546.16) 152.58% 000 - 496000 Water Construction Reserve - - - 1.00 - (1.00) 0.00% 000 - 497000 Misc Income -W &S 15,000.00 885.28 10,417.19 2,730.99 - 12,269.01 18.21% 000 - 498110 Reimbursement -SSLGC 129,614.00 28,923.73 90,244.02 98,008.75 - 31,605.25 75.62% 000 - 498200 Reimbursement- W &S Project - 1.00 - 1.00 - (1.00) 0.00% TOTAL Miscellaneous 206,614.00 75,088.85 421,102.08 223,060.58 - (16,446.58) 107.96% TOTAL REVENUES 22,652,670.00 6,026,791.70 16,363,008.79 1'7,265,956.74 5,386,713.26 76.22 %! WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: June 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,488,053.00 Cash in Investments Lone Star Investment -Water &Sewer 6,739,048.54 Lone Star Investment -W &S Customer Deposits 303,781.97 Lone Star Investment -W &S Equip Replacement 182,648.01 Lone Star Investment -W &S Veh Replacement 263,851.63 Schertz Bank & Trust - Certificate of Deposit 1,096,110.74 $ 8,585,440.89 Total Cash in Bank & Investments $10,073,493.89 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 6,122,000.00 1,042,252.68 4,386,113.98 3,555,513.12 - 2,566,486.88 58.08% Inter - Jurisdictional 2,780,862.72 1,037,933.07 2,272,356.81 3,002,588.84 - (221,726.12) 107.97% Fund Transfers - - 550,000.00 - - 0.00% Miscellaneous 117,850.00 (5,306.79) 194,852.73 120,543.12 (2,693.12) 102.29% TOTAL REVENUES 9,020,712.72 2,074,878.96 7,403,323.52 6,678,645.08 ' 2,342,067.64 74.04% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 4,244,739.00 1,038,364.02 2,803,228.62 3,060,046.39 - 1,184,692.61 72.09% Supplies 410,850.00 92,253.42 319,026.24 279,912.50 35,896.20 95,041.30 76.87% Human Services - - 651.00 - - - 0.00% City Support Services 104,100.00 2,200.00 51,475.20 47,413.10 597.00 56,089.90 46.12% Utility Services 118,000.00 30,746.52 75,620.66 79,738.00 200.46 38,061.54 67.74% Operations Support 74,620.00 12,723.27 45,830.12 43,629.05 197.30 30,793.65 58.73% Staff Support 70,750.00 17,358.54 39,654.31 39,642.17 4,965.89 26,141.94 63.05% City Assistance 568,866.81 101,298.18 375,507.47 376,251.55 46,414.15 146,201.11 74.30% Professional Services 168,200.00 25,664.43 77,240.89 73,439.10 10,004.68 84,756.22 49.61% Fund Charges /Transfers 2,656,827.00 355,246.55 1,942,656.17 1,709,671.42 - 947,155.58 64.35% Maintenance Services 12,000.00 1,920.00 16,010.04 6,720.00 1,259.00 4,021.00 66.49% Debt Service 288,120.00 - 5,648.72 115,788.13 6,600.00 165,731.87 42.48% Rental- Leasing 141,000.00 17,385.21 52,735.14 119,328.62 17,385.21 4,286.17 96.96% Operating Equipment 119,100.00 19,422.26 11,860.70 30,273.74 12,804.84 76,021.42 36.17% Capital Outlay 30,000.00 605,731.76 34,510.00 605,731.76 - (575,731.76) 2019.11% TOTAL PUBLIC SAFETY 9,007,172.81 2,320,314.16 5,851,655.28 - 6,587;585.53 136,324.73 2,283,262.55 74.65% TOTAL EXPENDITURES 9,007,172.81 2,320,314.16 5,851;655.28 6,587;585.53 136,324.73 2,283,262.55 74.65% — REVENUE OVER(UNDER) EXPENSES ** 13,539.91 (245,435.20) 1,551,668.24 91,059.55 '; (136;324.73) 58,805.09 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,866,200.00 998,893.16 4,157,433.20 3,327,848.13 - 2,538,351.87 56.73% 000 - 456110 Subscription Program Fees 30,000.00 1,290.00 24,740.00 24,775.00 - 5,225.00 82.58% 000 - 456120 EMT Class - Fees 96,000.00 14,400.00 65,123.00 65,465.00 - 30,535.00 68.19% 000 - 456122 CE Class - Fees 22,800.00 2,705.00 14,225.00 21,087.52 - 1,712.48 92.49% 000 - 456130 Immunization Fees 7,000.00 471.36 9,138.00 3,008.17 - 3,991.83 42.97% 000 - 456140 Billing Fees - External 25,000.00 5,701.76 13,934.78 16,744.45 - 8,255.55 66.98% 000 - 456150 Standby Fees 25,000.00 2,961.75 21,848.50 28,300.70 - (3,300.70) 113.20% 000 - 456155 Community Services Support 50,000.00 11,806.69 79,621.50 60,681.19 - (10,681.19) 121.36% 000 - 456160 MIH Services - 3,180.00 - 6,660.00 - (6,660.00) 0.00% 000 - 458110 Sales of Merchandise - GovDeal - 842.96 - 842.96 - (842.96) 0.00% 000 - 459200 NSF Check Fee - - 50.00 100.00 - (100.00) 0.00% TOTAL Fees 6,122,000.00! 1,042,252.68 4,386,113.98 3,555,513.12 2,566,486.88 58.08% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 843,577.17 210,894.51 702,981.70 984,174.38 - (140,597.21) 116.67% 000 - 474300 Cibolo Support 346,467.65 173,233.82 319,098.32 346,467.64 - 0.01 100.00% 000 - 475100 Comal Co ESD #6 112,536.60 59,664.06 106,011.73 116,812.50 - (4,275.90) 103.80% 000 - 475200 Live Oak Support 213,151.95 106,575.98 206,956.52 213,151.96 - (0.01) 100.00% 000 - 475300 Universal City Support 281,283.70 140,641.86 262,361.00 281,283.72 - (0.02) 100.00% 000 - 475400 Selma Support 111,886.35 55,943.18 106,656.08 111,886.36 - (0.01) 100.00% 000 - 475500 Schertz Support 556,325.00 278,162.50 504,083.88 556,325.00 - - 100.00% 000 - 475600 Santa Clara Support 10,447.35 5,223.68 10,354.16 10,447.36 - (0.01) 100.00% 000 - 475800 Marion Support 15,186.95 7,593.48 14,956.00 15,186.96 - (0.01) 100.00% 000 - 475910 TASPP Program 290,000.00 - 38,897.42 366,852.96 - (76,852.96) 126.50% TOTAL Inter - Jurisdictional 2,780,86212< 1,037,93107 2,272,356.81 3,002,588.84 - (221,726.12) 107.97 %` Fund Transfers 000 - 486100 Transfer In - - 550,000.00 - - - 0.00% TOTAL Fund Transfers - - 550,000.00 - - - 0.00 %` Miscellaneous 000 - 491000 Interest Earned 100.00 1,362.37 90.96 2,971.22 - (2,871.22) 2971.22% 000 - 491200 Investment Income 750.00 1,216.83 721.59 5,923.33 - (5,173.33) 789.78% 000 - 493203 Donations -EMS 2,000.00 50.00 150.00 400.00 - 1,600.00 20.00% 000 - 493205 Donations- Golf Tournament 10,000.00 17,995.00 10,060.00 18,595.00 - (8,595.00) 185.95% 000 - 495100 UH Grant Program 40,000.00 - 99,579.03 - - 40,000.00 0.00% 000 - 497000 Misc Income 25,000.00 (41,430.46) 40,566.88 47,814.80 - (22,814.80) 191.26% 000 - 497100 Recovery of Bad Debt 40,000.00 15,499.47 43,684.27 44,838.77 - (4,838.77) 112.10% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 2 0 1 7 - 2 0 1 8 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF REVENUES BUDGET QUARTER Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET TOTAL Miscellaneous 117,850.00 (5,306.79) 194,852.73 120,543.12 (2,69112) 102.29% TOTAL REVENUES 9,020,712.72 2,074,878.96 7,403,323.52 6,678,645.08 - 2,342,067.64 74.04% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 297,564.31 Total Cash in Bank & Investments $ 297,564.31 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 391,652.00 98,282.96 266,642.54 249,384.07 - 142,267.93 Permits 3,000.00 1,360.00 2,080.00 2,820 - 180.00 94.00% Fees 1,179,250.00 283,896.82 857,149.98 867,846 - 311,404.24 73.59% Fund Transfers 1,327,327.00 - - - - 1,327,327.00 0.00% Miscellaneous 254,350.00 8,742.09 11,513.74 186,313 - 68,037.28 73.25% TOTAL REVENUES 2,763,927 00 293,998.91; 870,743.72 1,056,978.48 - 1,706,948.52', 38.24 % »r•t7i��1:��.YlJJi1�5F_131 alL:L�[*] "T701= DRAINAGE Personnel Services 391,652.00 98,282.96 266,642.54 249,384.07 - 142,267.93 63.67% Supplies 5,200.00 1,689.18 2,462.24 3,210.39 - 1,989.61 61.74% City Support Services 8,180.00 1,380.05 4,576.16 6,508.54 - 1,671.46 79.57% Utility Services 13,200.00 4,555.03 11,913.28 8,822.13 400.02 3,977.85 69.86% Operations Support 1,000.00 - - - - 1,000.00 0.00% Staff Support 6,700.00 1,733.06 4,357.77 4,441.71 - 2,258.29 66.29% City Assistance 400.00 - 287.00 98.00 - 302.00 24.50% Professional Services 117,320.00 78.00 33,350.00 8,918.00 - 108,402.00 7.60% Fund Charges/Transfers 497,295.00 124,07176 320,350.50 372,221.16 - 125,073.84 74.85% Maintenance Services - 217.77 5,356.21 1,089.91 - (1,089.91) 0.00% Other costs 200.00 - 100.00 100.00 - 100.00 50.00% Debt Service 123,225.00 5,040.40 4,093.63 - 119,131.37 3.32% Rental /Leasing 500.00 - - - 500.00 0.00% Operating Equipment 7,000.00 - 4,659.23 519.99 - 6,480.01 7.43% TOTAL DRAINAGE 1,171,872:00 232,009.81 659,09533 659,407:53 400.02 512,064.45' 56.30 %` PROJECTS City Support Services 7,354.50 - - - - 7,354.50 0.00% Operations Support 1,950.00 - - 469.00 564.00 917.00 52.97% Professional Services 180,058.50 60,306.58 44,420.00 68,426.58 109,751.92 1,880.00 98.96% Maintenance Services 1,532,061.00 128,900.00 383,955.25 1,148,105.75 25.06% TOTAL PROJECTS 1,721,424;00 189,206.58 44,420.00 452,850.83 110,315.92 1,158,25725 32.72% TOTAL EXPENDITURES 2,893,296.00 421,216.39 703,515.33 1,112,258.36 110,715.94 1,670,321.70 42.27% "* REVENUE OVER(UNDER) EXPEND ; (129,369.00) (12%,217.48) (55,279.88), CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000.00 1,360.00 2,080.00 2,820.00 - 180.00 94.00% TOTAL Permits 3,000.00 1,360.00 2,080.00 2,820.00 - 180.00 94,00% Fees 000 - 457500 Drainage Penalties 10,000.00 2,482.00 7,299.53 8,682.25 - 1,317.75 86.82% 000 - 457600 Drainage Fee 1,169,250.00 281,414.82 849,850.45 859,163.51 - 310,086.49 73.48% TOTAL Fees 1,179,250.00 283,896.82 857,149.98' 867,845.76 - 311,404.24` 73.59 %' 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 214.39 88.89 1,230.02 - (1,080.02) 820.01% 000 - 491200 Investment Interest 12,000.00 8,523.08 10,557.85 20,83127 - (8,831.27) 173.59% 000 - 497000 Misc Income - Drainage 242,200.00 4.62 867.00 164,251.43 - 77,948.57 67.82% TOTAL Miscellaneous 254,350.00 8,742.09 11,513.74' 186,312.72 - 68,037.28 73.25 %` TOTAL REVENUES 2,763,927.00 293,998.91 870,743.72 1,056,978.48 - 1,706';948,52 38.24 %' DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 674,803.27 Cash in Investments Lone Star Investment - Drainage Maint Fund 1,001,285.43 Total Cash in Bank & Investments $ 1,676,088.70 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% 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 193,639.16 339,787.96 364,536.59 - 185,463.41 66.28% Miscellaneous 13,650.00 8,178.22 7,989.39 19,176.60 - (5,526.60) 140.49% TOTAL REVENUES 563,650.00 201,81738 347,777.35 383,713.19 - 1179,936.81 68.08% EXPENDITURE SUMMARY NONDEPARTMENTAL City Support Services 110,000.00 9,869.94 66,506.22 66,916.30 - 43,08170 60.83% Operations Support 68,425.00 19,397.17 30,169.77 28,889.17 - 39,535.83 42.22% Professional Services 3,000.00 - 3,000.00 3,000.00 - - 100.00% Fund Charges /Transfers 67,605.00 16,601.25 49,803.75 49,803.75 - 17,801.25 73.67% Maintenance Services 10,000.00 - 3,511.94 - - 10,000.00 0.00% Capital Outlay 63,806.00 8,255.00 - 8,255.00 - 55,551.00 12.94% TOTAL NONDEPARTMENTAL 322,836.00 54,123.36 152,991.68 156,864.22 165,971:78 48.59 %' TOTAL EXPENDITURES 322,836.00 54,123.36 152,991.68 156,864.22 - 165,971.78 48.59 %' REVENUE OVER(UNDER)iEXPENDITURE 240,814.00'' 226,848.97 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 135,033.07 Cash in Investments Texas Class - Hotel Tax 1,562,141.10 Total Cash in Bank & Investments $ 1,697,174.17 HOTEL OCCUPANCY TAX $80,000 $70,000 = - - - - - - - - - - - - -- - - $60,000 $50,000 � � $40,000 0-ft � x ixm. ,vu $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 -- - - - - - - -- -- 52,258 - - - -- - - - - - -- - 53,747 - - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- --- - - - - -- -- - - - - -- 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: JUNE 30, 2018 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 70,000.00 115,000.00 98,000.00 139,000 - (69,000.00) 198.57% Fund Transfers 109,829.69 - - - - - 0.00% Miscellaneous 60,000.00 1,971.28 2,419.42 4,729.96 - 55,270.04 7.88% TOTAL REVENUES 239,829.69 116,971.28 100,419.42 - 143,729.96 - (13,729.96) 59.93% EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services 26,900.00 - 8,250.00 13,450.00 5,200.00 0.00% Operating Equipment 10,000.00 - 14,176.00 - - 10,000.00 0.00% Capital Outlay 202,929.69 28,356.34 - 87,495.40 82,92938 32,504.91 83.98% TOTAL PARKLAND DEDICATION 239,829.69 28,356.34 14,176.00 95,745.40 96,379.38 47,704.91 80.11 %? TOTAL EXPENDITURES 239,829.69 28,356.34 14,176.00 95,745.40 96,379.38 47,704.91 80.11 %` REVENUE OVER(UNDER) EXPEND - 47,984.56 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 70,000.00 115,000.00 98,000.00 139,000.00 - (69,000.00) 198.57% TOTAL Fees 70,000.00 115,000.00 98,000.00 139,000.00 (69,000.00) 198.57 %? 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 262.81 37.92 574.92 - (474.92) 574.92% 000 - 491200 Investment Interest 3,000.00 1,708.47 2,381.50 4,155.04 - (1,155.04) 138.50% 000 - 499100 Transfer From Parks Reserve 56,900.00 - - - - 56,900.00 0.00% TOTAL Miscellaneous 60,000`00 1,971.28 2,419.42 4,729.96 ` - 55,270.04 7.88% TOTAL REVENUES 239,829.69 116,971.28 100,419.42 143,729.96 - 96,099.73 59.93°%0 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $82,439.81 Cash in Investments Texas Class- Park Fund 334,518.78 Total Cash in Bank & Investments $416,958.59 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 t******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 72,500.00 69,558.90 60,66530 102,680 - (30,180.00) 141.63% Fund Transfers 81,400.00 - - - - 81,400.00 0.00% Miscellaneous 3,100.00 2,082.47 2,30831 4,626 - (1,526.24) 149.23% TOTAL REVENUES 157,000.00 71,641.37 62,973.61 107,306.24 - 49,693.76 68.35% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 157,000.00 800.00 85,901.00 3,243.00 - 153,757.00 2.07% TOTAL TREE MITIGATION 157,000.00 800.00 85,901.00 3,243.00 153,757.00 2.07 %< TOTAL EXPENDITURES 157,000.00 800.00 85,901.00 3,243.00 - 153,757.00 2.07% REVENUE OVER(UNDER) EXPEND - 70,841.37 (22,927.39)' 104,063.24 (104,063.24} CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 72,500.00 69,558.90 60,665.30 102,680.00 - (30,180.00) 141.63% TOTAL Fees ' 72,500.00 69,558.90 60,66530 102,680.00 (30,180100) 141.63 %' 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 466.85 11.86 697.25 - (597.25) 697.25% 000 - 491200 Investment Interest 3,000.00 1,615.62 2,296.45 3,928.99 - (928.99) 130.97% TOTAL Miscellaneous- 3,100.00 2,082.47 2,308.31 4,626.24 - (1,526.24) 149.23 %! TOTAL REVENUES 157,000.00 71,641.37 62,973.61 107,306.24 - 49,693'.76 68.35 %' TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $119,648.91 Cash in Investments MBIA Investment -Tree Mitigation 316,326.80 Total Cash in Bank & Investments $435,975.71 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 1,100,000.00 396,090.00 1,063,575.00 1,232,491.40 - (132,491.40) 112.04% Miscellaneous 40,200.00 29,892.44 24,232.54 68,070.94 - (27,870.94) 169.33% TOTAL REVENUES 1,140,200.00 425,982.44 1,087,807.54 1,300,562.34 - (160,362.34) 114.06 %i EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 256,000.00 - 1,000.00 1,000.00 - 255,000.00 0.39% TOTAL NON DEPARTMENTAL 256,000.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 - 1,000.00 1,000.00 - 255,000.00 0.39% REVENUE OVER(UNDER) EXPENDITURES 884,200.00 425,982.44 1,086,807.54 1,299,562.34 - (415,362.34) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% 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 396,090.00 1,063,575.00 1,232,491.40 - (132,491.40) 112.04% TOTAL Fees 1,100,000.00; 396,090.00 1,063,575.00 1,232,491.40 (132,491.40) 112A4% Miscellaneous 000 - 491000 Interest Earned 200.00 2,314.09 152.15 4,639.32 - (4,439.32) 2319.66% 000 - 491200 Investment Income 40,000.00 27,578.35 24,08039 63,431.62 - (23,431.62) 158.58% TOTAL Miscellaneous 40,200.00 = 29,892.44 ` 24,232.54 68,070.94 - (27,870.94) 169.33% TOTAL REVENUES 1,140,200.00 425,982.44 ! 1,087,807.54 11,300,562.34 - (160,362.34) 114A6 %' CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 270,347.98 Cash in Investments Lone Star Investment-Capital Recovery Water 5,874,576.77 Total Cash in Bank & Investments $ 6,144,924.75 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 550,000.00 205,875.48 568,335.60 676,193 - (126,192.80) 122.94% Fund Transfers 359,700.00 - - - - 359,700.00 0.00% Miscellaneous 40,150.00 28,224.93 20,130.40 54,515 - (14,364.90) 135.78% TOTAL REVENUES 949,850.00 234,100.41 588,466.00 730,707.70 - 219,142.30 76.93 %I EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 335,500.00 1,088.79 4,26372 4,268.02 - 331,231.98 1.27% Maintenance Services 359,700.00 - - - 359,700.00 0.00% TOTAL NON DEPARTMENTAL ` 695,200.00 1,088.79 4,263.72 4,268`.02 690,931`.98 0.61 %% TOTAL EXPENDITURES 695,200.00 1,088.79 4,263.72 4,268.02 690,931.98 0.61 %6 REVENUE OVER(UNDER) EXPENDITURES 254,650.00 233,011.62 584,202.28 726,439'.68 - 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 75% 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 198,675.48 544,935.60 658,192.80 - (108,192.80) 119.67% 000 - 455913 Cap Recovery -North Sewer Tr - 7,200.00 23,400.00 18,000.00 - (18,000.00) 0.00% TOTAL Fees 550,000.00 205,875.48 568,335.60 676,192:80 (126,192.80) 122.94 % ' 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,73174 123.42 3,535.50 - (3,385.50) 2357.00% 000 - 491200 Investment Income 40,000.00 29,086.68 44,893.26 72,247.63 - (32,247.63) 180.62% 000 - 491800 Gain /Loss - (11,732.11) (12,928.67) (11,134.94) - 11,134.94 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - 9,136.62 (11,957.61) (10,133.29) - 10,133.29 0.00% TOTAL Miscellaneous 40,150.00 28,224.93 20,130.40 54,514.90 - ;(14,364.90) 135.78 %' TOTAL REVENUES 949,850.00 234,1':00.41 588,466.00 730,707.70 - 219,14230 76.93% CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool-Checking $ 190,770.81 Cash in Investments Lone Star Investment-Capital Recovery Sewer 4,385,687.82 Capital One-investment 1,774,034.55 Total Cash in Bank & Investments $ 6,350,493.18 505 - TAX I &S FINANCIAL SUMMARY REVENUE SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF BUDGET QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 6,030,353.00 101,091.32 6,108,623.22 6,082,876.52 - (52,523.52) 100.87% Fund Transfers 487,110.00 - - - - 487,110.00 0.00% Miscellaneous 477,069.00 36,681.81 503,012.89 418,263.87 - 58,805.13 87.67% TOTAL REVENUES 6,994,532.00 137,773.13 6,611,636.11 6,501,140.39 - 493,391.61 92.95% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 2,550.00 - 1,550.00 2,150.00 1,600.00 (1,200.00) 147.06% Debt Service 6,991,982.00 - 5,329,583.69 5,815,642.93 698,060.01 478,279.06 93.16% Other Financing Sources - - - - - - 0.00% TOTAL GENERAL' GOVERNMENT' 6,994,532.00` 5,331,133.69 5,817,792.93 699,660.01 477,079.06 s 93.1!8 %? TOTAL EXPENDITURES 6,994,532.00 5,331,133.69 5,817,792.93 699,660.01 477,079.06 93.18% " REVENUE OVER(UNDER) EXPEND - 683,347.46 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 75% 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 101,091.32 6,108,623.22 6,082,876.52 - (52,523.52) 100.87% TOTAL Taxes 6;030,35100 101,091.32 6,108,623.22 6,082,876.52 (52,523.52) 100.87% 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 1,077.21 170.22 4,291.72 - (3,991.72) 1430.57% 000 - 491200 Investment Earnings 16,000.00 10,604.60 41,823.92 28,203.15 - (12,203.15) 176.27% 000 - 495015 Contribution from SED 360,769.00 - 361,018.75 360,769.00 - - 100.00% 000 - 495020 Contribution from YMCA 100,000.00 25,000.00 100,000.00 25,000.00 - 75,000.00 25.00% TOTAL Miscellaneous 477,069.00 36,681.81 503,012.89 418,263.87 - 58,805.13 87.67 %' TOTAL REVENUES 6,994,532.00 137,773.13 '' 6,611,636.11 6,501,140.39 - 493 391.61 ' 92.95% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% 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 - 1,550.00 2,150.00 1,600.00 (1,200.00) 147.06% TOTAL Professional Services 2,550.00 - 1,550.00 2,150.00 1,600.00 (1,200.00) 147.06% Debt Service 101 - 555612 Bond -GO Refunding 2010 - Principal 285,000.00 - 285,000.00 285,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 38,475.00 - 25,650.00 21,375.00 - 17,100.00 55.56% 101 - 555629 GO Bond 2007 - Principal 290,000.00 - 280,000.00 290,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007 - Interest 136,345.00 - 76,821.25 71,123.25 - 65,221.75 52.16% 101 - 555630 GO Bond SR2008 Principal 475,000.00 - 460,000.00 475,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 259,055.00 - 143,930.50 210,487.60 - 48,567.40 81.25% 101 - 555631 GO Bond SR2009 Principal 550,000.00 - 550,000.00 550,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 249,138.00 - 137,287.50 129,037.50 - 120,100.50 51.79% 101 - 555633 GO SR2011 Principal 240,000.00 - 235,000.00 240,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 327,038.00 - 169,143.75 165,618.75 161,418.75 0.50 100.00% 101 - 555634 GO SR2011A Refund Principal 635,000.00 - 620,000.00 635,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 87,783.00 - 54,813.25 47,590.25 - 40,192.75 54.21% 101 - 555635 GO SR2012 Principal 335,000.00 - 320,000.00 335,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 168,095.00 - 94,357.50 87,397.50 80,697.50 - 100.00% 101 - 555636 Tax Note - SR2013 - Principal 170,000.00 - 170,000.00 170,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 1,445.00 - 2,550.00 1,445.00 - - 100.00% 101 - 555637 Tax Note - SR 2013A - Principal 165,000.00 - 160,000.00 165,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 1,073.00 - 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.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 289,775.00 - 146,637.50 145,637.50 144,137.50 - 100.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 - 1,564.26 1,263.02 - 1,274.98 49.76% 101 - 555640 Bond -Ref 2015 Bond- Principal 490,000.00 - 450,000.00 490,000.00 - - 100.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 92,725.00 - 53,312.50 48,812.50 43,912.50 - 100.00% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 505 -TAX I& S *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7 - 2 0 1 8 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF NON DEPARTMENTAL BUDGET 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 - 6,859.42 5,731.58 - 5,818.42 49.62% 101 - 555642 GO Bond SR2016 Principal 205,000.00 - 405,000.00 205,000.00 - - 100.00% 101 - 555642.1 GO Bond SR2016 Interest 167,607.00 - 89,903.13 85,853.13 81,753.13 0.74 100.00% 101 - 555643 CO Bond Tax SR2016 Principal 55,000.00 - 55,000.00 55,000.00 - - 100.00% 101 - 555643.1 CO Bond Tax SR2016 Interest 47,238.00 - 24,856.25 24,031.25 23,206.25 0.50 100.00% 101 - 555644 CO Bond nonTax SR2016 Principal 165,000.00 - 170,000.00 165,000.00 - - 100.00% 101 - 555644 CO Bond nonTax SR2016 Interest 69,469.00 - 39,784.38 36,384.38 33,084.38 0.24 100.00% 101 - 555645 CO Bond SR2017 Principal 245,000.00 - - 245,000.00 - - 100.00% 101 - 555645.1 CO Bond SR2017 Interest 178,689.00 - - 107,075.56 71,612.50 0.94 100.00% 101 - 555646 Bond -GO SR2017 Principal 135,000.00 - - 135,000.00 - - 100.00% 101 - 55646.1 Bond - GO SR2017 Interest 143,944.00 - - 85,706.67 58,237.50 (0.17) 100.00% TOTAL Debt Service 6,991,982.00 - 5,329,583.69 5; ,815,642.93 698,060.01 478,279.06 93.16 %? TOTAL EXPENDITURES 6,994,532.00 i 5,331,133.69 5,817,792.93 699,660.01 477,079.06 93.18% TAX I &S CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 34,292.50 MBIA Investment- Tax I &S 2,099,137.09 Total Cash in Bank &;Investments $ '2,133,429.59' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30, 2018 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 7- 2 0 1 8********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 620 -SED CORPORATION CURRENT 3rd CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET MONTH QUARTER Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 750.00 39.47 117.65 Taxes 3,962,572.00 416,630.87 1,061,104.50 2,663,118.01 3,070,400.60 - 892,171.40 77.49% Fund Transfers 225,000.00 - - - - - - 0.00% Miscellaneous 120,301.00 24,540.48 74,166.31 89,711.47 182,940.21 - (62,639.21) 152.07% TOTAL REVENUES 4,307,873.00 441,171.35 1,135,270.81 2,752,829.48 3,253,340:81 - 829,532.19 75.52% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Supplies 750.00 39.47 117.65 402.08 356.14 - 393.86 47.49% Human Services 500.00 - - 389.64 - - 500.00 0.00% City Support Services 37,700.00 340.55 2,17109 3,894.84 4,589.09 - 33,110.91 12.17% Utility Services 3,870.00 327.33 730.27 1,601.00 1,726.75 - 2,143.25 44.62% Operations Support 172,000.00 5,461.34 13,798.68 41,769.29 56,211.62 288.00 115,500.38 32.85% Staff Support 21,900.00 1,798.84 2,717.06 11,410.66 9,993.75 - 11,906.25 45.63% City Assistance 1,042,500.00 24.00 225,09832 979.02 425,098.32 - 617,401.68 40.78% Professional Services 82,500.00 2,652.00 6,021.00 7,121.37 15,260.13 - 67,239.87 18.50% Fund Charges/Transfers 1,067,945.00 - - 684,312.98 802,945.00 - 265,000.00 75.19% Maintenance Services 1,000.00 105.00 210.00 - 385.00 - 615.00 38.50% Operating Equipment 4,200.00 - - 299.99 576.02 298.16 3,325.82 20.81% TOTAL ECONO'DEVELOPMENT 2 ,434,865.00 10,748.53 250,866.07 752,180.87 1,317,141.82 586.16 1,117,137!02 54.12% TOTAL EXPENDITURES 2,434,865.00 10,748.53 250,866.07 752,180.87 1,317,141.82 586.16 1,117,137.02 54.12% * *:REVENUE OVER(UNDER) EXPEND 1;,873,008.00 430,422.82 884,404.74 2,000,648.61' 1,936,198.99 (586.1;6) (287,604.83) SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JUNE 30, 2018 Cash in Bank Claim on Operating Cash Pool- Checking $ 378,928.67 Cash in Investments Texas Class Investment- Economic Development Corl 13,798,290.73 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 $ 16,258,686.14 4B SALES TAX By Collection Month $450,000 12.1% $400,000 - - - - - - - 2.2 1' aa 12.1 % '� 9.9 ®% a 55.8% ��x� a 15.% 7 /o $350,000 " h +6% $300,000 Ar r $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 - 336,784 - - 375,378 _ 320,141 -- 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