The URL can be used to link to this page

Q2-March-2016 FinancialsCITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL REVENUE SUMMARY 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET Taxes 17,335,590.00 851,228.12 12,682,399.08 13,792,026.80 - 3,543,563.20 79.56% Franchises 2,221,153.00 114,654.36 1,018,528.89 976,025.75 - 1,245,127.25 43.94% Permits 1,249,839.00 64,182.00 635,073.95 570,471.51 - 679,367.49 45.64% Licenses 84,160.00 3,677.50 41,037.50 26,119.50 - 58,040.50 31.04% Fees 2,470,622.00 238,858.02 1,259,008.75 1,232,727.65 (902.00) 1,238,796.35 49.86% Fines 31,000.00 2,041.50 14,205.26 12,154.77 - 18,845.23 39.21% Inter - Jurisdictional 783,847.00 67,754.71 409,016.82 396,001.67 - 387,845.33 50.52% Fund Transfers 1,921,266.00 134,483.05 846,252.48 806,898.23 - 1,114,367.77 42.00% Miscellaneous 462,000.00 65,137.12 242,274.28 280,418.09 (141.90) 181,723.81 60.67% TOTAL REVENUES 26,559,477 1,542,016.38 17,147,797.01 18,092,843.97 _(1,043.90) 8,467,676.93 68.12 % EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23,575 1,902.10 11,211.06 11,306.65 - 12,268.35 47.96% Supplies 2,600 - 301.87 60.24 - 2,539.76 2.32% City Support Services 68,176 - 28,615.12 66,883.04 78.00 1,214.96 98.22% Operations Support 500 9.80 158.20 94.85 - 405.15 18.97% Staff Support 26,500 - 10,092.19 11,202.59 640.32 14,657.09 44.69% TOTAL CITY COUNCIL 121,351 1,911 -90 50,378.44 89,547.37 718.32 31,085.31 74.38 % CITY MANAGER Personnel Services 837,718 64,249.07 403,518.64 413,742.78 - 423,975.22 49.39% Supplies 3,000 156.37 1,007.50 940.33 69.97 1,989.70 33.68% City Support Services 2,770 - 2,035.46 - - 2,770.00 0.00% Staff Support 33,775 820 6,331 8,354 858 24,563 27.27% TOTAL CITY MANAGER 877,263 65,225.69 412,892.22 423,036.89 927.94 453,298.17 48.33 % '' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 278,579 20,868.08 129,142.13 134,332.43 - 144,246.57 48.22% Supplies 3,500 118.99 382.89 523.32 19.96 2,956.72 15.52% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,500 - 1,928.00 941.00 - 3,559.00 20.91% Staff Support 7,710 452.61 1,162.01 2,323.70 468.58 4,917.72 36.22% Court Support 700 - 210.00 - 108.00 592.00 15.43% Professional Services 61,200 4,921.50 22,752.50 22,473.88 27,711.00 11,015.12 82.00% Maintenance Services 2,800 250.00 800.00 950.00 1,050.00 800.00 71.43% Operating Equipment 7,800 2,762.21 17.76 3,137.21 1,230.00 3,432.79 55.99% TOTAL MUNICIPAL COURT 367,789 29,373 39 156,395.29 164,681.54 30,587:54 172,519.92 53.09% CUSTOMER RELATIONS -311 Personnel Services 115,445 6,858.73 48,127.58 53,181.64 - 62,263.36 46.07% Supplies 200 32.24 10.97 47.43 27.50 125.07 37.47% Staff Support 975 - - 133.32 71.00 770.68 20.96% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 117,120 6,890.97 48,138.55 53,362.39 98.50 63,659.11 45.65 % PLANNING & ZONING Personnel Services 144,435 5,428.44 62,364.74 50,332.78 - 94,102.22 34.85% Supplies 2,476 - 157.14 388.16 - 2,087.84 15.68% City Support Services 296 - - - - 296.00 0.00% Operations Support 750 - 31.48 - - 750.00 0.00% Staff Support 23,350 73.91 6,524.45 1,791.87 65.00 21,493.13 7.95% Professional Services 300 - 66 34 - 266 11.33% TOTAL PLANNING & ZONING 171,607 5,502.35 69,14181 52,546.81 65c00 118,995.19 30.66 % ' LEGAL SERVICES Operations Support 10,000 - 4,279.43 950.66 84.76 8,964.58 10.35% Professional Services 275,000 10,336.33 52,952.28 39,510.59 - 235,489.41 14.37% TOTAL LEGAL SERVICES 285,000 10,336:33 57,231.71 40,461.25 8416 244,453.99 14.23 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 619,523 35,953.06 276,239.48 265,474.32 4,631.09 349,417.59 43.60% Supplies 102,544 12,841.35 20,010.00 38,646.74 9,732.11 54,165.15 47.18% Utility Services 188,015 15,807.84 38,771.07 71,965.74 - 116,049.26 38.28% Staff Support 11,749 1,387.85 3,683.92 4,350.94 1,183.33 6,214.73 47.10% Maintenance Services 52,060 380.25 21,215.75 13,636.59 2,634.39 35,789.02 31.25% Rental /Leasing 421 - - - - 421.00 0.00% Operating Equipment 3,600 - - - - 3,600 0.00% Capital Outlay 24,000 - - - 23,087.90 912.10 96.20% TOTAL GENERAL SERVICES 1?,001,91i2 66,370.35 359,920.22 394,074.33 41,268.82 566,568.85 43.45 % ` CITY SECRETARY Personnel Services 169,988 13,233.96 80,431.29 82,505.47 - 87,482.53 48.54% Supplies 1,350 54.96 438.91 (177.07) - 1,527.07 - 13.12% City Support Services 10,500 - - 3,914.02 - 6,585.98 37.28% Operations Support 450 - - - - 450.00 0.00% Staff Support 8,725 46.50 1,547.38 2,359.93 - 6,365.07 27.05% TOTAL CITY SECRETARY ? 191,013 13,335.42 82,417.58 88,602.35 - 102,410.65 46.39 %' NON - DEPARTMENTAL City Support Services 379,174 52,896.31 236,951.21 243,001.96 2,200.00 133,972.04 64.67% Operations Support 134,500 30,057.18 42,715.83 71,556.06 427.32 62,516.62 53.52% Staff Support 9,900 - 80.00 10,000.00 - (100.00) 101.01% City Assistance 1,746,326 516,957.57 804,595.50 756,778.19 - 989,547.81 43.34% Professional Services 63,285 3,500.83 45,077.75 39,257.76 29,450.00 (5,422.76) 108.57% Fund Chrgs /Transfrs -Spec Events Fnd 65,200 - - - - 65,200.00 0.00% Operating Equipment - - - 1,874.00 - (1,874.00} 0.00% TOTAL NON`- DEPARTMENTAL 2,398,385 603,411`.89 1,129,420.29 1,122,467.97 32,077.32 1,243,839.71 48.14 % ` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 272,396 20,059.53 113,603.88 127,207.26 - 145,188.74 46.70% Supplies 3,850 99.10 2,158.72 357.46 27.50 3,465.04 10.00% Operations Support 23,640 1,613.84 9,463.67 9,292.15 758.00 13,589.85 42.51% Staff Support 4,230 36.00 695.47 783.44 42.64 3,403.92 19.53% Professional Services 5,000 - 589.00 - - 5,000.00 0.00% Operating Equipment 1,000 - 1,921.82 - - 1,000.00 0.00% TOTAL PUBLIC AFFAIRS 310,116 21,808.47 128,432.56 137,640.31 828.14 171,647.55 44.65% RECORDS MANAGEMENT Personnel Services 52,540 3,834.02 24,809.44 25,455.36 - 27,084.64 48.45% Supplies 400 40.68 71.67 66.37 - 333.63 16.59% Staff Support 1,250 - 904.61 44.44 - 1,205.56 3.56% Professional Services 10,000 1,048.00 4,483.00 4,368.00 539.00 5,093.00 49.07% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 64,190 4,922.70 30,268.72 29,934.17 622!.77 33,633.06 47.60 %0! SCHERTZ MAGAZINE Personnel Services 140,795 10,174.64 65,888.85 50,159.62 - 90,635.38 35.63% Supplies 200 - 74.00 27.50 - 172.50 13.75% Staff Support 2,220 18.00 273.00 158.10 - 2,061.90 7.12% Professional Services 247,000 20,372.23 80,338.41 110,189.54 375.00 136,435.46 44.76% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% TOTAL SCHERTZ MAGAZINE 400,21`5 30,564`.87 146,574.26 160,534.76 375:00 239,305.24 40.21% ENGINEERING Personnel Services 258,764 14,697.66 86,850.51 90,595.64 - 168,168.36 35.01% Supplies 1,246 98.23 422.54 549.80 116.93 579.27 53.51% City Support Services 591 - 262.80 590.40 - 0.60 99.90% Utility Services 700 28.05 143.85 180.76 - 519.24 25.82% Staff Support 8,503 615.50 114.85 1,051.48 269.00 7,182.52 15.53% Professional Services 35,800 - 3,410.00 495.00 - 35,305.00 1.38% Operating Equipment 400 - 161.49 - - 400.00 0.00% TOTAL ENGINEERING 306,004 15,439.44 91,366.04 93,463.08 385.93 212,154.99 30.67 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 142,882 10,725.92 65,777.91 68,504.15 - 74,377.85 47.94% Supplies 2,200 - - - - 2,200.00 0.00% Staff Support 4,390 - 2,029.40 - 933.92 3,456.08 21.27% Rental /Leasing 3,805 347 - 1,042 868 1,894.85 0.00% TOTAL GIS 153,277 11,073.22 67,80731 69,546.05 1,802.17 81,928.78 46.55 %+ TOTAL GENERAL GOVERNMENT 6,765,242 886,166.99 2,830,387.00 2,919;89927 109,842.21 3,735,500.52 44.78 % < PUBLIC SAFETY POLICE Personnel Services 5,504,509 414,250.12 2,420,514.18 2,740,980.25 - 2,763,528.75 49.80% Supplies 36,906 1,583.07 15,455.99 18,579.22 10,727.18 7,599.67 79.41% City Support Services 19,081 - 24,151.52 19,081.45 - (0.45) 100.00% Utility Services 112,663 3,863.21 33,272.15 25,450.41 - 87,212.89 22.59% Operations Support 2,950 - 818.89 1,566.87 40.97 1,342.16 54.50% Staff Support 114,631 4,371.79 33,903.72 20,395.52 33,853.76 60,382.07 47.32% City Assistance 10,150 586.00 1,057.20 3,057.88 - 7,092.12 30.13% Professional Services 37,288 606.46 16,019.01 20,008.34 298.54 16,981.12 54.46% Maintenance Services 57,780 8,548.02 12,778.96 35,350.59 - 22,429.41 61.18% Operating Equipment 116,090 1,962.94 25,788.57 100,315.15 1,810.23 13,964.52 87.97% Capital Outlay 199,327 - 56,675.00 199,126.25 6,033.51 (5,833.01) 102.93% TOTAL POLICE 6,211,375 435,771.61 2,640,435.19 3,183,911.93 52,764.19 2,974,699.25 52.11 % !' FIRE RESCUE Personnel Services 3,205,808 237,844.79 1,401,002.27 1,547,747.90 - 1,658,060.10 48.28% Supplies 16,500 2,984.72 2,950.82 8,330.52 2,097.23 6,072.25 63.20% Utility Services 60,400 4,631.26 22,789.11 18,230.64 - 42,169.36 30.18% Operations Support 600 - 134.41 669.69 - (69.69) 111.62% Staff Support 110,600 24,600.41 25,439.34 57,502.52 1,537.68 51,559.80 53.38% City Assistance 16,200 6.15 248.50 101.49 - 16,098.51 0.63% Professional Services 26,000 - 160.00 275.00 - 25,725.00 1.06% Maintenance Services 60,000 6,971.75 15,611.97 16,512.05 10,777.05 32,710.90 45.48% Rental /Leasing 14,000 1,316.94 - 8,014.01 7,901.64 (1,915.65) 113.68% Operating Equipment 66,600 24,447.00 24,914.47 42,440.70 10,968.68 13,190.62 80.19% Capital Outlay 150,000 - 67,290.00 - 1,653.75 148,346.25 1.10% TOTAL FIRE RESCUE 3,726,708 302,803.02 1,560,540.89 1,699,824.52 34,936'.03 1,991,947.45 46.55% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL INSPECTIONS 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET Personnel Services 552,775 32,621.90 218,325.96 222,564.89 - 330,210.11 40.26% Supplies 3,585 276.82 765.94 1,062.31 444.54 2,078.15 42.03% Utility Services 6,500 86.48 1,569.53 1,349.19 - 5,150.81 20.76% Operations Support 2,200 - 704.48 294.00 - 1,906.00 13.36% Staff Support 18,600 579.43 2,807.73 3,256.96 465.58 14,877.46 20.01% Professional Services 107,600 1,500.00 - 24,897.00 56,463.00 26,240.00 75.61% Operating Equipment 2,100 - - - - 2,100.00 0.00% TOTAL INSPECTIONS 693,360 35,064`.63 224,17164 253,424.35 57,37112 382,562.53 44.82 %' MARSHAL'S OFFICE Personnel Services 618,483 45,868.42 278,686.26 290,339.92 - 328,143.08 46.94% Supplies 6,211 - 1,240.53 2,089.67 646.29 3,475.04 44.05% Utility Services 16,000 409.68 2,622.19 2,489.14 - 13,510.86 15.56% Operations Support 3,500 118.58 130.92 271.48 337.00 2,891.52 17.39% Staff Support 14,300 390.00 3,929.32 3,551.32 620.00 10,128.68 29.17% City Assistance 2,500 - - - - 2,500.00 0.00% Maintenance Services 16,500 400.00 1,538.00 2,531.00 - 13,969.00 15.34% Operating Equipment 5,039 92.90 11,562.34 1,214.21 709.36 3,115.43 38.17% Capital Outlay 72,950 - - 71,594.85 225.00 1,130.15 98.45% TOTAL MARSHAL'S OFFICE 755,483 47,279.58 299,709.56 374,081.59 2,537 65 378,863.76 49.85 %' TOTAL PUBLIC SAFETY 11,386,926 820,918 84 4,724,859.28 5,511,242.39 147,610.99 5,728,072.99 49.70% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 - 4,392.80 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,011.63 7,012.86 STREETS 16.03% Maintenance Services 208,378 - 2,244.90 - - 208,378.00 PARKS DEPARTMENT TOTAL SWIM POOL Personnel Services 713,763 47,303.91 330,651.05 326,116.76 - 387,646.24 45.69% Supplies 7,100 972.82 3,076.84 2,951.06 612.39 3,536.55 50.19% Utility Services 196,604 11,449.39 20,098.33 60,009.89 - 136,594.11 30.52% Staff Support 10,030 500.58 4,630.55 4,335.74 833.85 4,860.41 51.54% Professional Services 40,000 5,225.00 22,000.00 10,837.15 - 29,162.85 27.09% Maintenance Services 125,400 3,978.49 25,532.26 30,066.86 12,270.41 83,062.73 33.76% Rental /Lease 200 - 175.00 - - 200.00 0.00% Operating Equipment 300 - - - - 300.00 0.00% Capital Outlay 78,000 - - - 76,810.32 1,189.68 98.47% TOTAL STREETS 1,171,397 69,430.19 406,164,03 434,317.46 90,526.97 646,552.57 44.81% TOTAL PUBLIC ENVIRONMENT 1,171,397 69,430:19 406,164.03 434,317.46 90,526:97 646,552.57 44.81% PARKS & RECREATION 20,700 - 4,392.80 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,011.63 7,012.86 4,649.59 - 24,350.41 16.03% Maintenance Services 208,378 - 2,244.90 - - 208,378.00 PARKS DEPARTMENT TOTAL SWIM POOL 258,078 1,011.63 13,650.56 5,091.57 59:96 252,926.47 2.00% Personnel Services 534,975 32,572.51 199,817.71 219,680.89 - 315,294.11 41.06% Supplies 41,905 4,183.52 18,160.43 22,337.77 2,271.49 17,295.74 58.73% City Support Services - - - 989.00 - (989.00) 0.00% Utility Services 173,800 15,183.61 81,077.77 64,044.89 231.64 109,523.47 36.98% Operations Support 1,250 606.04 - 606.04 - 643.96 48.48% Staff Support 9,625 521.98 5,626.58 2,274.23 1,020.90 6,329.87 34.24% Professional Services 79,000 2,671.00 12,477.80 31,660.42 3,691.50 43,648.08 44.75% Maintenance Services 22,000 2,192.87 7,989.01 5,766.76 1,409.53 14,823.71 32.62% Rental /Leasing 39,600 3,019.16 18,114.96 18,114.96 18,114.96 3,370.08 91.49% Operating Equipment 2,000 608.00 1,648.92 1,581.09 344.25 74.66 96.27% Capital Outlay 38,000 - - - 30,279.60 7,720.40 79.68% TOTAL PARKS DEPARTMENT 942,155 61,558.69 344,9113.18 367,056.05 57,36187 517,735.08 45.05 % ` SWIM POOL Supplies 20,700 - 4,392.80 441.98 59.96 20,198.06 2.42% Utility Services 29,000 1,011.63 7,012.86 4,649.59 - 24,350.41 16.03% Maintenance Services 208,378 - 2,244.90 - - 208,378.00 0.00% TOTAL SWIM POOL 258,078 1,011.63 13,650.56 5,091.57 59:96 252,926.47 2.00% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 56,240 4,049.69 26,480.35 24,892.42 - 31,347.58 44.26% Supplies 15,500 2,936.08 5,951.32 5,913.35 823.90 8,762.75 43.47% Utility Services 51,850 5,095.72 19,177.31 19,760.40 - 32,089.60 38.11% Operations Support 16,858 3,804.99 6,629.00 4,654.99 250.00 11,953.01 29.10% Staff Support 2,500 - 899.24 565.00 125.00 1,810.00 27.60% Professional Services 500 - - - - 500.00 0.00% Operating Equipment 7,112 5,029.37 779.26 5,029.37 - 2,082.63 70.72% TOTAL EVENT FACILITIES 150,560 20,915,85 59,916.48 60,815.53 1,198.90 88,545.57 41.19% SENIOR CITIZEN CENTER 877,288 69,552.95 367,066.79 408,437.43 6,98139 461,869.18 47.35 %` Supplies - 96.00 2,988.75 2,180.62 (73.99) (2,106.63) 0.00% Utility Services - - 216.78 - - - 0.00% City Assistence - - 7,420.79 19,136.93 - (19,136.93) 0.00% Professional Services - - 2,457.50 1,016.77 - (1,016.77) 0.00% Maintenance Services - - 245.54 138.50 - (138.50} 0.00% TOTAL SENIOR CITIZEN CENTER - 96.00 13,329.36 22,472.82 (73:99) (22,398.83) 0.00% TOTAL PARKS &RECREATION s 1!,350,793 83,582.17 431,809.58 455,435.97 58,548.74 836,808.29 38.05% CULTURAL LIBRARY Personnel Services 692,689 50,338.98 292,509.17 327,308.40 - 365,380.60 47.25% Supplies 15,000 919.72 5,661.74 7,226.79 1,095.40 6,677.81 55.48% Utility Services 56,500 2,529.05 17,512.44 19,534.51 - 36,965.49 34.57% Operations Support 3,100 15.99 379.95 489.66 - 2,610.34 15.80% Staff Support 7,715 - 1,145.76 2,378.07 - 5,336.93 30.82% Professional Services 2,284 - 2,175.00 2,247.00 - 37.00 98.38% Operating Equipment 100,000 15,749.21 47,682.73 49,253.00 5,885.99 44,861.01 55.14% TOTAL LIBRARY 877,288 69,552.95 367,066.79 408,437.43 6,98139 461,869.18 47.35 %` TOTAL CULTURAL 877,288 69,552'.95 367,066.79 408,437.43 6,981.39 461,869.18 47.35 %b CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 324,954 24,220.05 127,676.70 138,944.26 1,173.18 184,836.56 43.12% Supplies 41,380 698.72 9,556.22 8,790.12 2,124.51 30,465.37 26.38% City Support Services 3,776 - - - 39.00 3,737.00 1.03% Utility Services 43,000 3,878.64 15,157.48 13,608.00 - 29,392.00 31.65% Operations Support 1,000 - - - - 1,000.00 0.00% Staff Support 10,750 1,451.95 1,111.27 3,466.21 230.36 7,053.43 34.39% City Assistance 17,550 857.77 4,534.16 4,253.18 373.56 12,923.26 26.36% Professional Services 32,500 1,192.50 6,891.10 4,648.65 113.70 27,737.65 14.65% Maintenance Services 28,280 385.00 1,229.99 5,751.09 173.08 22,355.83 20.95% Operating Equipment 10,000 - 357.05 1,799.34 - 8,200.66 17.99% Capital Outlay 55,000 - - 22,588.15 29,905.00 2,506.85 95.44% TOTAL ANIMAL SERVICES 568,190 32,684.63 166,511197 203,849.00 < 34,132.39 330,208.61 41.88% TOTAL HEALTH 568,190 32,684.63 166,513.97 203,849.00 34,132.39 330,208.61 41.88% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 462,042 31,858.64 191,088.13 200,617.69 - 261,424.31 43.42% Supplies 3,100 132.77 500.21 573.94 89.82 2,436.24 21.41% City Support Services 541,399 113,912.40 234,759.83 239,627.14 7,807.82 293,964.04 45.70% Utility Services 267,402 24,296.01 81,840.20 97,988.99 169.87 169,243.14 36.71% Operations Support - - 50.00 - - - 0.00% Staff Support 36,050 3,877.74 9,139.59 24,867.81 4,919.32 6,262.87 82.63% Maintenance Services 15,600 2,703.26 5,339.39 6,869.88 4,222.34 4,507.78 71.10% Rental /Leasing 38,047 6,340.98 - 25,363.92 - 12,683.08 Operating Equipment 235,866 4,043.43 124,292.76 84,230.91 4,746.30 146,888.79 37.72% TOTAL INFORMATION TECHNOLOGY 1,599,506 187,165 23 647,010.11 680,140.28 21,955.47 897,4%25 43.89 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 291,703 20,482.85 146,648.30 120,000.05 - 171,702.95 41.14% Supplies 1,000 105.94 420.93 716.36 89.42 194.22 80.58% Human Services 72,000 5,864.92 26,761.18 22,932.09 984.45 48,083.46 33.22% Operations Support 10,000 698.05 776.17 4,201.96 149.00 5,649.04 43.51% Staff Support 14,100 - 8,100.27 10,324.74 125.51 3,649.75 74.12% City Assistance 8,000 1,045.00 2,633.75 7,222.50 - 777.50 90.28% Professional Services 9,600 744.75 3,723.25 4,518.50 744.75 4,336.75 54.83% Operating Equipment 1,800 - - 1,362.96 - 437.04 75.72% TOTAL HUMAN RESOURCES 408,203 28,941.51 189,06185 171,279.16 2,093.13 234,830.71 42.47% FINANCE Personnel Services 597,537 38,311.32 225,489.57 244,634.52 - 352,902.48 40.94% Supplies 3,500 381.55 2,816.45 1,842.09 545.00 1,112.91 68.20% Operations Support 3,000 1,976.65 3,887.60 1,976.65 - 1,023.35 65.89% Staff Support 11,085 2,535.92 1,981.38 5,199.78 1,546.74 4,338.48 60.86% Professional Sevices - - - - 505.00 (505.00) 0.00% Operating Equipment - - 722.00 - - - 0.00% TOTAL FINANCE 615,122 43,205.44 234,897.00 253;653.04 2,59614 358,872.22 41.66% PURCHASING & ASSET MGT Personnel Services 197,453 8,841.17 89,499.89 70,994.61 - 126,458.39 35.96% Supplies 1,100 98.21 243.27 255.31 27.02 817.67 25.67% City Support Services - - 262.80 - - - 0.00% Utility Services 500 28.16 177.81 63.66 - 436.34 12.73% Operations Support 100 - - - 12.64 87.36 12.64% Staff Support 6,600 1,085.16 1,214.90 2,565.14 1,507.72 2,527.14 61.71% City Assistance 2,500 170.00 - 1,884.46 - 615.54 75.38% Operating Equipment - - 1,245.00 - - - 0.00% TOTAL PURCHASING & ASSET MGT 208,253 10,222.70 92,643.67 75,763.18 1,547♦38 130,942.44 37.12 % CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 327,626 18,395.38 113,320.50 137,298.82 - 190,327.18 41.91% Supplies 174,525 25,095.75 75,230.17 70,996.22 9,064.72 94,464.06 45.87% City Support Services 3,500 - 2,232.24 2,244.72 - 1,255.28 64.13% Utility Services 6,200 255.47 1,654.19 1,895.51 - 4,304.49 30.57% Operations Support 300 - - - - 300.00 0.00% Staff Support 5,050 1,071.53 3,827.39 3,603.72 445.00 1,001.28 80.17% Maintenance Services 73,750 12,664.09 33,055.66 69,825.70 28,523.19 (24,598.89) 133.35% Rental /Lease 200 - - - - 200.00 0.00% Operating Equipment 8,200 2,863.50 2,132.08 6,570.02 - 1,629.98 80.12% Capital Outlay 92,000 49,491.00 34,000.00 89,832.47 - 2,167.53 97.64% TOTAL FLEET SERVICE 691,351 109,836.72 265,452.23 382,267.18 < 38,032:91 271,050.91 60.79% BUILDING MAINTENANCE Personnel Services 148,103 12,621.66 54,999.72 70,515.36 - 77,587.64 47.61% Supplies 1,043 11.37 573.96 324.44 23.16 695.40 33.33% Utility Services 2,350 186.00 1,121.52 1,042.52 - 1,307.48 44.36% Staff Support 3,420 86.40 1,331.07 1,292.74 254.98 1,872.28 45.25% Professional Services 43,785 - - 43,784.99 - 0.01 100.00% Maintenance Services 99,985 11,391.55 39,537.85 41,151.78 10,262.01 48,571.21 51.42% Rental /Leasing 1,400 - 296.75 1,263.27 - 136.73 90.23% Operating Equipment - - 1,438.43 - - - 0.00% Capital Outlay - - - - 8,415.00 (8,415.00) 0.00% TOTAL BUILDING MAINTENANCE 300,086 24,296 98 99,299.30 159,375.10 18,955!.15 121,755.75 59.43 %d TOTAL INTERNAL SERVICE 3,822,521 403,668.58 1,528,366.16 1,722,477.94 85,180.78 2,014,862.28 47.29% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** Y -T -D Y -T -D BUDGET 50% OF ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE City's Assistance to Agencies 192,000 26,257.39 36,678.00 60,600.21 77.09 131,322.70 31.60% TOTAL CITY ASSISTANCE 192,000 26,257.39 36,678.00 60,600.21 77.09 131,322.70 31.60 % ' COURT - RESTRICTED FUNDS Operating Equipment 36,660 - - 3,924.25 1,840.00 30,895.75 15.72% TOTAL CITY ASSISTANCE 36,660 - - 3,924.25 1,840.00 30,895.75 15.72 %6i TOTAL MISC & PROJECTS 228,660 26,257.39 36,678.00 64,524.46 1,917,09 162,218.45 29.06 % TOTAL EXPENDITURES 26,171,017 2,392,261;74 10,491,844.81 11,720,183.92 534,740.56 13,916,092.89 46.83 %> REVENUE OVER(UNDER) EXPEND. 388,460 6,372,660.05 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 10,162,766 211,253.25 9,204,257.07 10,226,918.93 - (64,152.93) 100.63% 000 - 411200 Advalorem Tax - Delinquent 45,000 4,525.31 24,623.49 9,865.80 - 35,134.20 21.92% 000 - 411300 Advalorem Tax - P &I 45,000 16,030.93 21,931.04 28,307.38 - 16,692.62 62.91% 000 - 411500 Sales Tax Revenue -Gen Fund 7,036,724 619,418.63 3,409,825.21 3,505,101.95 - 3,531,622.05 49.81% 000 - 411600 Bingo Tax 100 - - 0.62 - 99.38 0.62% 000 - 411700 Mixed Beverage Tax 46,000.00 - 21,762.27 21,832.12 - 24,167.88 47.46% TOTAL Taxes 17,335,590 851,228.12 12,682,399.08 13,792,026.80 - 3,543,563.20 79.56% Franchises 000 - 421200 Center Point/Entex Energy 109,857 438.67 48,695.15 39,531.57 - 70,325.43 35.98% 000 - 421220 City Public Service 815,953 46,583.48 331,002.94 334,784.31 - 481,168.69 41.03% 000 - 421240 Guadalupe Valley Elec Co -op 453,465 30,728.72 223,629.63 211,351.55 - 242,113.45 46.61% 000 - 421250 New Braunfels Utilities 56,736 (9,187.70) 29,366.36 15,220.23 - 41,515.77 26.83% 000 - 421300 Time Warner -State Franchise 275,193 17,961.10 133,672.96 128,008.78 - 147,184.22 46.52% 000 - 421460 AT &T Franchise Fee 251,861 16,718.80 140,085.52 129,548.75 - 122,312.25 51.44% 000 - 421480 Other Telecom Franchise 125,000 11.34 46,233.63 49,979.19 - 75,020.81 39.98% 000 - 421500 Solid Waste Franchise Fee 133,088 11,399.95 65,842.70 67,601.37 - 65,486.63 50.79% TOTAL Franchises 2,221,153 114,654.36 ` 1,018,528.89 976,025.75 - 1,245,127.25 43.94 %' Permits 000 - 431100 Home Occupation Permit 420 - 350.00 420.00 - - 100.00% 000 - 431205 Building Permit - Residential 567,624 27,876.00 253,447.00 206,529.00 - 361,095.00 36.38% 000 - 431210 Building Permit - Commercial 182,270 - 93,235.00 91,217.00 - 91,053.00 50.04% 000 - 431215 Building Permit - General 150,000 10,258.00 83,502.00 65,833.00 - 84,167.00 43.89% 000 - 431300 Mobile Home Permit 525 50.00 250.00 200.00 - 325.00 38.10% 000 - 431400 Signs Permit 3,500 1,020.00 1,891.00 3,474.00 - 26.00 99.26% 000 - 431500 Food Establishmnt Permit 56,000 350.00 53,470.00 58,365.00 - (2,365.00) 104.22% 000 - 431600 Garage Sale Permit 8,000 1,245.00 4,412.00 5,235.00 - 2,765.00 65.44% 000 - 431700 Plumbing Permit 105,000 8,886.00 54,378.95 54,255.00 - 50,745.00 51.67% 000 - 431750 Electrical Permit 51,000 4,980.00 26,220.00 28,860.00 - 22,140.00 56.59% 000 - 431800 Mechanical Permit 53,000 4,640.00 26,800.00 24,980.00 - 28,020.00 47.13% 000 - 431900 Solicitor /Peddler Permit 1,200 20.00 130.00 80.00 - 1,120.00 6.67% 000 - 431950 Animal /Pet Permit 1,800 - 300.00 - - 1,800.00 0.00% 000 - 432000 Cert. of Occupancy Prmt 6,000 450.00 4,600.00 3,550.00 - 2,450.00 59.17% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 40,000 2,485.00 17,926.00 16,307.00 - 23,693.00 40.77% 000 - 432300 Grading /Clearing Permit 3,500 490.00 2,112.00 3,708.51 - (208.51) 105.96% 000 - 435000 Fire Permit 20,000 1,432.00 12,050.00 7,458.00 - 12,542.00 37.29% TOTAL Permits 1,249,839 64;182.00 635,073.95 570,471.51 - 679,367.49 45.64% Licenses 000 - 441000 Alcohol Beverage License 7,000 147.50 3,292.50 3,997.50 - 3,002.50 57.11% 000 - 441300 Mobile Home License 160 - 160.00 160.00 - - 100.00% 000 - 442000 Contractors License 74,000 3,250.00 36,310.00 20,460.00 - 53,540.00 27.65% 000 - 444000 Pet License 3,000 280.00 1,275.00 1,502.00 - 1,498.00 50.07% TOTAL Licenses 84,160 3,677.50 4`1,037.50 26,119.50 - 58,040.50 31.04% Fees 000 - 451000 Municipal Court Fines 1,027,516 112,132.85 555,122.64 521,569.50 - 505,946.50 50.76% 000 - 451100 Arrest Fee 34,750 3,490.54 23,377.98 18,488.67 - 16,261.33 53.20% 000 - 451110 Expunction Fee 60 - 60.00 30.00 - 30.00 50.00% 000 - 451200 Warrant Fees 150,000 17,178.00 60,335.18 68,687.60 - 81,312.40 45.79% 000 - 451210 Court - Claims & Judgements - 1,086.63 - (228.00) - 228.00 0.00% 000 - 451340 Judicial Fee - City 5,250 500.98 3,097.85 2,540.13 - 2,709.87 48.38% 000 - 451400 Traffic Fine Costs TTL 20,000 1,588.04 11,929.98 8,875.87 - 11,124.13 44.38% 000 - 451510 Juvenile Case Mgmt Fee 45,650 4,184.92 25,825.73 21,167.44 - 24,482.56 46.37% 000 - 451520 Truancy Fee 7,225 677.50 4,473.27 3,675.26 3,549.74 50.87% 000 - 451600 Technology Fund Fee 36,660 3,493.58 20,829.72 17,225.89 (902.00) 20,336.11 44.53% 000 - 451700 Security Fee 28,250 2,620.22 15,619.28 12,919.41 - 15,330.59 45.73% 000 - 451800 Time Payment Fee - City 5,690 536.05 3,010.06 3,065.79 - 2,624.21 53.88% 000 - 451850 State Fines 10% Service Fee 64,500 - 30,716.81 24,449.29 - 40,050.71 37.91% 000 - 451900 DPS Payment - Local 7,500 1,234.26 4,499.67 5,048.20 - 2,451.80 67.31% 000 - 452000 Child Safety Fee 30,000 1,292.44 15,876.41 9,336.00 - 20,664.00 31.12% 000 - 452050 Indigent Defense Fee 1,741 - - - - 1,741.00 0.00% 000 - 452100 Platting Fees 57,000 9,000.00 30,000.00 28,500.00 - 28,500.00 50.00% 000 - 452200 Site Plan Fee 25,000 3,500.00 13,000.00 15,500.00 - 9,500.00 62.00% 000 - 452300 Plan Check Fee 455,979 19,819.00 213,461.50 180,876.50 - 275,102.50 39.67% 000 - 452310 Miscellaneous Review Fee 600 - 300.00 300.00 - 300.00 50.00% 000 - 452320 Tree Mitigation Admin Fee 10,000 - 15,502.50 6,645.00 - 3,355.00 66.45% 000 - 452400 BOA/Zoning Fees 5,000 - 2,500.00 1,000.00 - 4,000.00 20.00% 000 - 452500 Food Handler Class - - 6,140.00 - - - 0.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452520 Fire Training Classes 500 - - - - 500.00 0.00% 000 - 452600 Specific Use /Zone Chng Fee 18,000 4,000.00 - 7,300.00 - 10,700.00 40.56% 000 - 452710 Zoning Ltr & Dev Rights 2,400 - 1,200.00 1,050.00 - 1,350.00 43.75% 000 - 453100 Reinspection Fees 35,000 12,695.00 19,770.00 45,530.00 - (10,530.00) 130.09% 000 - 453110 Swim Pool Inspection Fee 2,000 - - - - 2,000.00 0.00% 000 - 453200 Lot Abatement 10,000 - 692.50 670.84 - 9,329.16 6.71% 000 - 453211 Admin Fee - Inspections 6,600 800.00 3,200.00 5,400.00 - 1,200.00 81.82% 000 - 453310 Misc Inspection Fee - - 3.00 100.00 - (100.00) 0.00% 000 - 453710 Foster Care 1,000 150.00 600.00 550.00 - 450.00 55.00% 000 - 454200 Pool Gate Admission Fee 24,750 - - - - 24,750.00 0.00% 000 - 454300 Seasonal Pool Pass Fee 4,900 - - - - 4,900.00 0.00% 000 - 456110 Senior Center Memberships - - 8,369.60 2,988.00 - (2,988.00) 0.00% 000 - 456120 Senior Center Meal Fee - 451.00 5,905.61 864.00 - (864.00) 0.00% 000 - 456500 Haz Mat Fees 12,000 - - 1,630.75 - 10,369.25 13.59% 000 - 456600 Fire Re- inspection Fee 1,000 150.00 600.00 550.00 - 450.00 55.00% 000 - 458110 Sale of Merchandise- GovDeal 5,000 1,919.47 1,092.02 23,826.65 - (18,826.65) 476.53% 000 - 458300 Sale of Property /Auction 4,000 - - 2,194.00 - 1,806.00 54.85% 000 - 458400 Civic Center Rental Fees 159,000 20,013.00 82,914.00 91,548.75 - 67,451.25 57.58% 000 - 458401 Capital Recovery Fee -Civic Cntr 6,500 1,675.00 4,000.00 5,525.00 - 975.00 85.00% 000 - 458450 North Center Rental Fees 18,500 1,500.00 11,005.75 10,525.00 - 7,975.00 56.89% 000 - 458460 Senior Center Rental 8,400 1,950.00 6,430.00 10,312.00 - (1,912.00) 122.76% 000 - 458500 Community Center Rental Fees 24,500 3,050.00 14,279.78 19,596.50 - 4,903.50 79.99% 000 - 458550 Pavilion Rental Fees 17,370 3,395.00 5,415.00 8,803.50 - 8,566.50 50.68% 000 - 458560 Chamber of Comm rent 7,800 200.00 3,900.00 4,100.00 - 3,700.00 52.56% 000 - 458570 Non - Resident SYSA League 3,000 - - - - 3,000.00 0.00% 000 - 458650 NonResident User Fee -BVYA 13,825 120.00 2,740.00 10,120.00 - 3,705.00 73.20% 000 - 458660 BVYA Utility Reimbursement 8,340 1,747.04 5,100.50 10,092.81 - (1,752.81) 121.02% 000 - 458670 SYSA Utility Reimbursement 1,968 - - - - 1,968.00 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,148 - 8,704.00 2,344.00 - 11,804.00 16.57% 000 - 458700 Vehicle Impoundment 9,000 - 4,470.00 2,590.00 - 6,410.00 28.78% 000 - 459200 NSF Check Fee 250 - 50.00 25.00 - 225.00 10.00% 000 - 459300 Notary Fee 250 18.00 72.00 114.00 - 136.00 45.60% 000 - 459400 Maps, Copies, UDC, & Misc F 250 - 55.00 35.00 - 215.00 14.00% 000 - 459600 Animal Adoption Fee 14,000 1,405.00 5,652.51 5,925.00 - 8,075.00 42.32% 000 - 459700 Pet Impoundment Fee 12,000 757.80 4,360.00 6,144.30 - 5,855.70 51.20% 000 - 459800 Police Reports Fee 6,000 526.70 2,748.90 2,600.00 - 3,400.00 43.33% TOTAL Fees 2,470,622 238',858.02 1,259,008.75 1,232,727.65 (902.00) 1,238,796.35 49.86% CITY O F S C H E R T Z REVENUE REPORT (UNAUDnED) AS OF: MARCH 31, 2016 2U15-2V16 101GENERALqJmo CURRENT CURRENT PRIOR YEAR v-T-D v-T-D BUDGET 50% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000403000 Library Fines 31,000 204150 1420520 1215477 1884523 39.21% TOTAL Fines �� !�31.U88 O 14,205.2e - 3 000473100 BnxarCo - Fim 21.072 - 7.025.92 10.25829 - 10.01371 48.08% 000473200 CitynfGoguin - FimConUnrt 29.231 2.435.90 14.01540 14.615.40 - 14.015.60 50.00% 000473300 GuodCn'Library 212.000 17.662.00 105.870.98 123.033.81 - 88.30019 50.32% 000473400 Randolph AFB-Animal Cntd 1.500 500.00 300.00 500.00 - 1.000.00 3133% 000474200 Libna,yGorviuos - Qbn|o 30.000 ' ' 85.000.00 - (s.00O,OO) 110.07% 000474210 LibmryGomico*Go|mo 30.544 - - - - 30.544.00 0.00% 000474400 DispatchGomioo - Cibo|o 100.000 40.000.00 80.000.00 80.020.00 - 79.874.00 50.02% 000474000 School Crossing Guand'Baxar 40.000 3.60025 18.858.03 16.17478 - 23.82522 4044% 000474010 School Cross Guard-Guadalupe 38.000 3.490.56 17.73949 18.28739 19.712.01 48.12% 000474620 School Crossing Guand-Como| 1.500 - - - - 1.500.00 0.00% 000474700 School Officer Funding 170.000 - 165.000.00 85.000.00 - 85.000.00 50.00Y6 000-474750 Crime Victim Liaison Agreement --_-50V000� -------_--_ -_ ---_12�00.00� -----_--- ---_37,500.00 25.00% TOTAL Inter-Jurisdictional 783,84 1 409,016.82 396,001. 387,84533 50.52% Fund Transfers 000480000 |ndivectCoots - EMS 150.308 12.525.03 08.04348 75.15378 - 75.154.22 50.00'& 000480100 Indirect Costs -Hotel/Motel 06^405 - 33.202.50 - - 60.405D0 0.00Y6 000482200 TmnahypVehic|eRep|c*mt 241.088 - - - - 241.088.00 0.00'& 000485000 |nt*dundChan8o-Dminag* 54.150 4.512.50 28.504.98 27.075.00 - 27.075D0 50.00Y6 000480000 |noydundCh,gea`AdminVY&S 1.152.350 90.029.17 578.175.02 570.174.95 - 570.175.05 50.00'& 000487000 |noodundChangnn-F|eeu 206.365 17.247.08 90.118.50 103.482.52 - 103.402.40 50.0096 000488000 |noadundChu 413 50.000 4.160.07 50.140.00 25.011.98 - 24.888.02 50.02Y6 TOTAL Fund Transfers 1,921,266 134,483.05 846,252.48 806,898.23 - 1,114,367.77 42.00% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 50% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 600 84.23 357.18 466.93 - 133.07 77.82% 000 - 491200 Investment Income 26,000 8,250.86 12,727.07 33,335.78 - (7,335.78) 128.21% 000 - 491800 Gain /Loss - 623.05 (609.40) (19,421.45) - 19,421.45 0.00% 000 - 491900 Unrealized Gain /Loss (15,000) (377.77) (723.22) 9,240.28 - (24,240.28) 0.00% 000 - 493120 Donations - Public Library 2,500 292.45 1,531.60 1,452.35 - 1,047.65 58.09% 000 - 493400 Donation - Animal Control 1,000 30.00 132.50 80.00 - 920.00 8.00% 000 - 493401 Donations -A/C Microchip 1,000 160.00 520.00 770.00 - 230.00 77.00% 000 - 493402 Donations - Spay &Neuter 10,000 1,479.50 5,277.00 6,680.50 (75.00) 3,394.50 66.06% 000 - 493403 Donations - Animal Adoption Trailer - 94.00 8,049.52 1,639.00 - (1,639.00) 0.00% 000 - 493460 Donations -Parks - - - 600.00 - (600.00) 0.00% 000 - 493465 Donations - Senior Center - 418.59 3,419.52 2,970.62 - (2,970.62) 0.00% 000 - 493502 Donations -PD - - 500.00 - - - 0.00% 000 - 493618 Donations - Veteran's Memorial - (625.00) - 5,350.67 - (5,350.67) 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed 3,900 3,878.26 3,850.98 - 49.02 98.74% 000 - 494482 Grants - Police, Fire, Gen Fund 15,000 2,133.00 - 2,133.00 - 12,867.00 14.22% 000 - 497000 Misc Income -Gen Fund 36,000 14,720.28 2,403.71 26,439.31 (66.90) 9,627.59 73.26% 000 - 497005 Schertz Magazine Advertising 240,000 13,375.00 142,035.00 96,450.00 - 143,550.00 40.19% 000 - 497100 Misc Income - Police 7,000 1,767.00 3,345.40 7,473.04 - (473.04) 106.76% 000 - 497200 Misc Income - Library 5,000 395.81 3,017.80 2,427.86 - 2,572.14 48.56% 000 - 497210 Misc Income - Library Copier 18,000 1,847.90 9,248.52 10,147.05 - 7,852.95 56.37% 000 - 497300 Misc Income - Animal Control - 70.00 10.00 295.00 - (295.00) 0.00% 000 - 497400 Misc Income - Streets Dept. 20,000 6,994.82 5,273.73 20,280.23 - (280.23) 101.40% 000 - 497500 Misc Income -TML Insurance 20,000 873.33 - 873.33 - 19,126.67 4.37% 000 - 497550 Misc Income -TML Reimbursemt 20,000 4,475.00 2,820.67 11,610.09 - 8,389.91 58.05% 000 - 497600 Misc Income - Vending Mach. 2,500 206.00 1,098.04 1,019.14 - 1,480.86 40.77% 000 - 498000 Reimbursmnt -Gen Fund 32,000 6,337.31 15,989.19 15,924.99 - 16,075.01 49.77% 000 - 498100 Reimbursmnt Fire - Training 1,000 625.00 - 4,360.00 - (3,360.00) 436.00% 000 - 498105 Reimburmnt Police - DEA 6,000 886.76 4,972.19 4,212.11 - 1,787.89 70.20% 000 - 498107 Reimburmnt Police - Event 7,000 - 7,000.00 3,500.00 - 3,500.00 50.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 2,500 - - 26,257.28 - (23,757.28) 1050.29% TOTAL Miscellaneous 462,000 65;137.12 < 242,274.28 280,418.09 (141.90) 181,723.81 60.67 %f TOTAL REVENUES 26,559,477 1,542;01638 17,147,797.01 18,092,843.97 (1,043.90) 8,467,676.93 68.12% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 1,092,369.00 Cash in Investments LOGIC Investment - General Fund 11,203,717.75 LOGIC Investment -Equip Replacement 73,815.00 LOGIC Investment -Veh Replacement 476,788.80 LOGIC Investment -Air Condi Replacment 221,031.85 CAPITAL ONE Investment - General Fund 1,361,209.57 Total Cash in Bank & Investments $14,575,513.81 w,2015-161 OCT 360,300 NOV 303,202 DEC 4,754,503 JAN 3,709,486 FEB 888,174 MAR 211,253 APR 50,559 MAY 54,867 JUN 27,116 JUL 5,863 AUG SEP 2014 -15 2013 -14 357,436 363,589 356,940 538,568 4,463,962 3,641,091 2,741,991 2,726,044 1,198,153 585,058 85,775 72,116 44,720 16,554 25,398 48,791 30,488 18,572 49,777 20,939 14,839 10,460 3,787 7,446 112012-13 292,988 636,964 3,422,107 2,180,145 637,568 177,645 29,444 49,157 11,566 20,778 8,379 7,180 2011-121 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127 6,915 Sales Tax - General Fund CITY PUBLIC SERVICE $250,000 00,000 50,000 00,000 50,000 $2 $1 $1 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP B2015-16 237,314 183,530 173,336 2014 -15 - - - -------------------------------------- 215,257 - - - - -- - -- 172,814 _ 172,628 ___ ----------------------------------------- 227,438 -------------------------- - -- ------------------- - - - - -- 02013 -14 133,486 115,592 176,520 213,412 2012 -13 101,440 94,054 96,303 123,044 - -- - 02011-12 - - - 96,392 76,414 ___ 77, 398 - - - -- -- 103,230 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 84,200.00 - - - - 84,200.00 0.00% Miscellaneous 47,600.00 6,410.74 32,991.05 31,158.78 - 16,441.22 65.46% TOTAL REVENUES 131,800.00 6,41074 32,991.05 31,158.78 - 100,641.22 13.81% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 10,760.00 - - - - 10,760.00 0.00% TOTAL GENERAL GOVERNMENT 10,760.00 - - - - 10,760.00 0.00% CULTURAL Festival of Angels 15,000.00 15.94 11,108.53 11,346.18 1,585.51 2,068.31 86.21% Employee Appreciation Event 13,000.00 - 5,503.12 2,919.95 10,080.05 22.46% National Night Out 290.00 - - - - 290.00 0.00% Wilenchik Walk for Life 25,000.00 2,259.50 4,516.28 2,842.92 125.00 22,032.08 11.87% Schertz Sweetheart 35,000.00 3,344.40 1,427.36 7,770.60 39.90 27,189.50 22.32% Hal Baldwin Scholarship 18,750.00 - 8,085.68 9,247.75 - 9,502.25 49.32% Other Events 14,000.00 313.57 5,309.14 1,845.80 976.25 11,177.95 20.16% TOTAL CULTURAL!' 121,040.00 5,933.41 35,950.11` 35,973 20 2,726.66 82,340.14 31.97 %' TOTAL EXPENDITURES 131,800.00 5,933.41 35,950.11 35,973.20 2,726.66 93,100.14 29.36% REVENUE OVER(UNDER) EXPEND - 475.33 (2;959.06) (4,81442} (2,726.66) 7,541.08 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fund Transfers 000 - 481000 Transfer from Reserves 10,000 - - - - 10,000.00 0.00% 000 - 481314 Transfer from Hotel /Motel - - - - - - 0.00% 000 - 486100 Transfer In 9,000 - - - - 9,000.00 0.00% 000 - 486101 Transfer In - General Fund 65,200 - - - - 65,200.00 0.00% TOTAL Fund Transfers 84,200 - - - 84,200.00 0.00% Miscellaneous 000 - 491200 Investment Income - 7.74 8.51 30.78 - (30.78) 0.00% 000 - 492200 Wilenchik Walk for Life 25,000 6,403.00 13,925.54 13,798.00 - 11,202.00 55.19% 000 - 493256 Donations - Police Events 3,000 - - - - 3,000.00 0.00% 000 - 493455 Proceeds - Festival of Angels - - 255.00 720.00 - (720.00) 0.00% 000 - 493460 Schertz Sweetheart 850 - - - - 850.00 0.00% 000 - 493621 Hal Baldwin Scholarship 18,750 - 18,802.00 16,360.00 - 2,390.00 87.25% 000 - 493650 Donations - Hal Baldwin Legacy - - - - - - 0.00% 000 - 497000 Misc Income - - - 250.00 - (250.00) 0.00% TOTAL Miscellaneous 47,600 6,410.74 ` 32,991.05 31,158.78 - 1?6,441.22 65.46% TOTAL REVENUES 131,800 6,410.74 32,991.05 31,158.78 - 1'00,641.22 23.64 %s' SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: March 31, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 45,950.44 Cash in Investments Texas Class- Special Events 16,836.33 Total Cash in Bank & Investments $ 62,786.77 >i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 107,000.00 - 48,155.50 51,090.80 - 55,909.20 47.75% Fund Transfers 145,500.00 - - - - 145,500.00 0.00% Miscellaneous - - 2.00 - - - 0.00% TOTALREVENUES 252,500.00 - 48,157.50 51,090.80 - 201,409.20 20.23°% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental - - 24,956.13 864.99 2,762.70 (3,627.69} 0.00% TOTAL GENERAL GOVERNMENT - - 24,956.136 864.99 2,76230 (3,627.69) 0.00 %> MISC & PROJECTS Projects 252,500.00 25,755.71 - 25,755.71 1,933.75 224,810.54 10.97% TOTAL'MISC & PROJECTS 252,500.00 25,755.71 - 25,755.71 1,93335 224,810.54 10.97 %`i TOTAL EXPENDITURES 252,500.00 25,755.71 24,956.13' 26,620.70 4,696.45 221,182.85 12.40 %'i REVENUE OVER(UNDER) EXPEND - (25,755.71) 23,201.37 24,470.10 (4,696.45} (19,773.65) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 52,000 - 25,508.73 37,490.66 - 14,509.34 72.10% 000 - 421465 AT &T PEG Fee 55,000 - 22,646.77 13,600.14 41,399.86 24.73% TOTAL Franchises 107,000 - 48,155.50 51,090.80 55,909.20 4775 %'< Fund Transfers 000 - 481000 Transfer In - Reserves 145,500 - - - - 145,500.00 0.00% TOTAL Fund Transfers 145,500 - - - - 145,500.00 0.00% Miscellaneous 000 - 497000 Misc Income - - - 2.00 - (2.00} 0.00% TOTAL Miscellaneous - - - 2.00 - (2.00) 0.00 %` TOTAL REVENUES 252,500 - 48,155.50 51,092.80 - 201,407.20 20.23 %s' PEG FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31, 2016 Cash in Bank Cash Balance $ 496,901.55 Total Cash in Bank & Investments $> 496,901.55 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 ST, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Franchises 220,285 124,180.87 119,404.67 126,680.87 - 93,604.13 57.51% Permits 65,000.00 - 52,353.79 45,625.33 - 19,374.67 70.19% Fees 17,659,700 1,469,098.46 8,321,469.89 9,162,844.64 - 8,496,855.36 51.89% Fund Transfers 813,272 10,830.00 68,556.48 64,980.00 - 748,292.00 7.99% Miscellaneous 143,858 (1,817.73) 62,836.65 49,280.60 - 94,577.40 34.26% TOTAL REVENUES 18,902,115 1,602,291.60 8,624,621.48 9,449,411.44 - 9,452,703.56 49.99% BUSINESS OFFICE Personnel Services 467,483 32,160.02 214,983.06 216,635.63 - 250,847.37 46.34% Supplies 4,600 454.59 1,496.84 2,250.73 25.00 2,324.27 49.47% Human Services 183 - - - - 183.00 0.00% City Support Services 3,035 - 831.00 - - 3,035.00 0.00% Utility Services 700 103.02 - 296.65 - 403.35 42.38% Operations Support 139,340 16,304.83 54,432.36 63,730.15 - 75,609.85 45.74% Staff Support 7,300 1,354.84 1,477.97 1,991.64 66.00 5,242.36 28.19% Professional Services 71,000 17,635.14 34,221.81 47,762.79 - 23,237.21 67.27% Maintenance Services 12,000 940.00 2,620.00 4,020.00 2,500.00 5,480.00 54.33% Operating Equipment 1,550 - - - - 1,550.00 0.00% Capital Outlay 44,000 - - - - 44,000.00 0.00% TOTAL BUSINESS OFFICE 751,191 68,952.44 310,063.04 336,687.59 2,591.00 411,912.41 45.17 %` W & S ADMINISTRATION Personnel Services 1,295,299 91,610.36 563,008.49 604,484.86 - 690,814.14 46.67% Supplies 195,150 4,605.83 107,795.00 112,234.58 1,643.85 81,271.57 58.35% Human Services 1,000 - 476.00 - - 1,000.00 0.00% City Support Services 59,900 885.00 35,702.56 44,282.81 15,617.19 73.93% Utility Services 3,438,500 242,814.00 1,416,656.08 1,590,164.42 - 1,848,335.58 46.25% Operations Support 6,545 1,358.74 708.78 3,809.81 64.66 2,670.53 59.20% Staff Support 33,850 1,983.92 10,676.44 15,424.86 195.76 18,229.38 46.15% City Assistance 1,900 119.00 677.00 464.00 - 1,436.00 24.42% Professional Services 183,838 55,407.26 81,768.03 76,180.02 25,000.00 82,657.98 55.04% Fund Charges /Transfers 3,856,374 322,872.51 1,730,229.08 2,442,263.97 - 1,414,110.03 63.33% Maintenance Services 7,018,115 620,564.89 3,080,720.19 3,324,474.64 31,358.85 3,662,281.51 47.82% Other Costs 35,000 - 27,150.20 27,150.20 - 7,849.80 77.57% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 ST, 2016 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Debt Service 1,453,258 - 211,759.71 614,139.02 - 839,118.98 4226% Rental- Leasing 6,070 483.18 3,091.21 960.74 - 5,109.26 15.83% Operating Equipment 8,000 - 16,060.13 - 399.98 7,600.02 5.00% Capital Outlay 11,881 - 22,276.48 32,904.13 44,129.80 (65,152.93) 648.38% TOTAL PUBLIC WORKS 17,604,680 1,342,704.69 7,308,755.38 8,888,938.06 102,792.90 8,612,949.04 51.08% PROJECTS Fund Charges /Transfers 500,000 - - - 500,000.00 0.00% TOTAL PROJECTS 500,000 - - - - 500,000.00 0.00% TOTAL MISC & PROJECTS 500,000 - - 500,000.00 0.00% TOTAL EXPENDITURES 18,855,871 1,411,657.13 7,618,818.42 9,225,625.65 105,383.90 9,524,861.45 49.49 %? ** REVENUE OVER(UNDER)EXPENSES ** 46,244 190,634.47 1,005,803.06 223,785.79 (105,383.90) (72,157:89)' 202 -WATER & SEWER REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421490 Tower Leasing 220,285 124,180.87 1,119,404.67 126,680.87 - 93,604.13 57.51% TOTAL Franchises 220,285r 124,180.87 1,119,404.67 126,680.87 - 93,604.13 57.51% Permits 000 - 432400 Development Permit 65,000 - 52,353.79 45,625.33 - 19,374.67 70.19% TOTAL Permits 65,000 - 52,353.79 45,625.33 - 19,374.67 70.19% Fees 000 - 455200 Garbage Collection Fee 4,150,000 368,542.24 2,036,579.81 2,191,562.16 - 1,958,437.84 52.81% 000 - 455600 Fire Line Fees 25,700 2,045.00 25,630.00 27,025.00 - (1,325.00) 105.16% 000 - 455700 Recycle Fee Revenue 275,000 23,976.23 135,284.72 140,440.95 - 134,559.05 51.07% 000 - 455800 W &S Line Constructn Reimbursemnt 25,000 1,166.00 10,939.00 11,360.06 - 13,639.94 45.44% 000 - 457100 Sale of Water 8,180,000 613,985.97 3,559,205.86 3,975,185.16 - 4,204,814.84 48.60% 000 - 457110 Edwards Water Lease 97,000 - 135,388.75 81,975.30 - 15,024.70 84.51% 000 - 457120 Water Transfer Charge -Selma 42,000 - 13,689.31 30,288.66 - 11,711.34 72.12% 000 - 457130 Water Transfer Charge -U. C. 10,000 - 4,911.69 203.11 - 9,796.89 2.03% 000 - 457140 Water Transfer Charge- Converse 30,000 - 10,022.12 13,527.69 - 16,472.31 45.09% 000 - 457200 Sale of Meters 90,000 3,944.00 38,035.02 32,167.75 - 57,832.25 35.74% 000 - 457400 Sewer Charges 4,532,000 437,606.00 2,240,619.21 2,541,713.77 - 1,990,286.23 56.08% 000 - 457500 Water Penalties 200,000 17,683.02 110,014.40 116,345.03 - 83,654.97 58.17% 000 - 458300 Sale of Property /Auction 500 - - - - 500.00 0.00% 000 - 459200 NSF Check Fee -Water &Sewer 2,500 150.00 1,150.00 1,050.00 - 1,450.00 42.00% TOTAL Fees 17,659,700 1,469,098.46 8,321,469.89 9,162,844.64 - 8,496,855.36 51.89% Fund Transfers 000 - 481000 Transfer In- Reserve 500,000 - - - - 500,000.00 0.00% 000 - 486103 Transfer In- Vehicle Reserves 44,000 - - - - 44,000.00 0.00% 000 - 486204 Interfnd Chrg- Drainage Bill 129,960 10,830.00 68,556.00 64,980.00 - 64,980.00 50.00% 000 - 486411 Transfer In- Capital Recovery 139,312 - - - - 139,312.00 0.00% TOTAL Fund Transfers 813,272 1'0,830.00 68,556:00 64,980.00 - 748,292.00 7.99 %' 202 -WATER & SEWER REVENUES Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 490000 Misc Charges 500 - 323.00 398.00 - 102.00 79.60% 000 - 491000 Interest Earned 1,500 50.55 663.11 313.28 - 1,186.72 20.89% 000 - 491200 Investment Income 5,000 889.08 3,012.70 11,605.53 - (6,605.53) 232.11% 000 - 497000 Misc Income -W &S 15,000 (2,757.36) (147.74) 7,584.92 - 7,415.08 50.57% 000 - 498110 Reimbursement -SSLGC 121,858 - 58,985.58 29,378.84 - 92,479.16 24.11% 000 - 498300 Reimbursement -City Property - - - - - - 0.00% TOTAL Miscellaneous 143,858 (1,817.73) 62,836:65 49,280.57 - 94,577.43 34.26% TOTAL REVENUES 18,902,115? 1,602,291.60 9,624,621.00 9,449,411.41 9,452,703.59 49.99% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31 ST, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 790,136.08 Cash in Investments Lone Star Investment -Water &Sewer Lone Star Investment -W &S Customer Deposits Lone Star Investment -W &S Equip Replacement Lone Star Investment -W &S Veh Replacement Schertz Bank & Trust - Certificate of Deposit 1,073,647.74 296,262.54 178,126.94 257, 320.58 1,078,650.80 $ 2,884,008.60 Total Cash in Bank & Investments $3,674,144.68 CITY O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: March 31 ST, 2016 2D15'2O1G 2034EK8S CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY F000 5,888,640 441,292.67 2,670.554.27 2,804/915.74 - 3,082.024�28 47.81% Inter-Jurisdictional 1.742.807 26.077.61 820.145.60 825.072.08 - 817.134.92 53.11% K4iooe||eneouu 131,850 —_17,706.97 . 5290190 47,390.28� ----------_ 84,450J2 35.91% TOTALREVENUES 7,741,297 485,07725 3,543,601.77 3,777,678A0 - 3,963,618.90 48.80% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 3,407.571 247.74348 1.508.044.72 1.011.100.40 - 1.790,402�00 47.28% Supplies 418.831 18.933.03 170.975.86 188�69.36 48.100�81 182.260.83 56.48% Human Services 1.000 - 324.00 - - 1.000.00 0.0% City Support Services 34.050 - 14.017.51 10.599�03 - 18.250.97 47.03% Utility Services 134.840 7.445.93 50.73141 39.00155 187.00 84.909.45 28.57% Operations Support 102.235 9.049.08 50.580.92 39.592.58 1.89017 00.752.25 40.58% Staff Support 84.000 2.63271 40.057.35 28.007.72 9.017.25 40.915.03 44.54% City Assistance 13.400 585.50 0.240.53 3.294.95 2.384.43 7.720.02 42.38% Professional Services 107.000 1.90217 58.490.01 42.170.85 25.410.42 39.412.73 03.17% FundChangeo/Transfem 2.556.485 39.715.41 897.29010 1.094.41711 - 1.462.067.89 42.81% Maintenance Services 77.100 1.796.22 19.02217 17.01925 - 58.48075 22.85% Debt Service 205.498 - 1.330.07 7.722.01 - 197.775.39 3J6% Rental-Leasing 81.541 5.795.07 41.145.00 34.770.42 34.770.42 12.00010 85.28% Operating Equipment 234.500 15.112.51 49.924.66 24.557.64 4.090.05 205.846.31 12.22% Capital Outlay —_109\000 -_' - --794,744]}0 ---90�22.36 —(776,466.38) 812.35% TOTAL PUBLIC SAFETY �'��.�.�� TOTAL EXPENDITURES 7,568,451 351,771.11 2,981,400.91 3,942,823.47 217,178.91 3,408,448.62 54.97% '- REVENUE OVER(UNDER) EXPENSES 172,846 133,306.14 562,200.86 (165,145.37) 555,170.28 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31 ST, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,717,640 408,355.58 2,572,369.66 2,673,961.67 - 3,043,678.33 46.77% 000 - 456110 Subscription Program Fees 40,000 515.00 25,300.00 27,415.00 - 12,585.00 68.54% 000 - 456120 EMT Class - Fees 87,000 31,283.50 61,937.45 81,822.97 - 5,177.03 94.05% 000 - 456130 Immunization Fees - 40.00 420.00 8,364.00 - (8,364.00) 0.00% 000 - 456140 Billing Fees - Alamo Heights 22,000 1,098.59 10,372.16 9,089.60 - 12,910.40 41.32% 000 - 458110 Sales of Merchandise - GovDeal - - 155.00 3,937.50 - (3,937.50) 0.00% 000 - 459200 NSF Check Fee - - - 25.00 - (25.00) 0.00% TOTAL Fees 5,866;640 441,292.67 2,670,554.27 2,804,615.74 - 3,062;024.26 47.81% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 294,710 26,077.61 143,063.28 224,716.84 - 69,993.16 76.25% 000 - 474300 Cibolo Support 269,225 - 130,696.50 134,612.50 - 134,612.50 50.00% 000 - 475100 Comal Co ESD #6 98,079 - 46,134.60 47,425.00 - 50,654.00 48.35% 000 - 475200 Live Oak Support 202,826 - 94,785.00 101,302.72 - 101,523.28 49.95% 000 - 475300 Universal City Support 254,788 - 123,687.76 127,393.76 - 127,394.24 50.00% 000 - 475400 Selma Support 104,528 - 36,979.50 38,087.50 - 66,440.50 36.44% 000 - 475500 Schertz Support 494,024 - 232,844.02 239,820.62 - 254,203.38 48.54% 000 - 475600 Santa Clara Support 9,969 - 4,839.38 4,984.38 - 4,984.62 50.00% 000 - 475800 Marion Support 14,658 - 7,115.56 7,328.76 - 7,329.24 50.00% TOTAL Inter - Jurisdictional 1,742,807 26,077.61 820,145.60 925,672.08 - 817,134.92 53.11 %' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: March 31 ST, 2016 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5 - 2 0 1 6 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 100 11.61 30.06 25.04 - 74.96 25.04% 000 - 491200 Investment Income 750 40.72 216.72 426.11 - 323.89 56.81% 000 - 493203 Donations -EMS 2,000 75.00 590.00 427.00 - 1,573.00 21.35% 000 - 493205 Donations- Golf Tournament 9,000 940.00 500.00 940.00 - 8,060.00 10.44% 000 - 497000 Misc Income 110,000 16,218.95 48,670.01 39,643.56 - 70,356.44 36.04% 000 - 497100 Recovery of Bad Debt 10,000 420.69 2,895.11 5,928.57 - 4,071.43 59.29% TOTAL Miscellaneous 131;850 17,706.97 52,901.90 47,390.28 - 84,459.72 35.94 %' TOTAL REVENUES 7,741,297 485,077.25 3,543,601.77 3,777,678.10 - 3,963,618.90 48.80% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: March 31ST, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $ 264,345.37 Cash in Investments Texas Class- Tax Note 2015 Ambulances 88,814.28 Total Cash in Bank & Investments $ 353,159.65x' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31ST, 2016 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 471,053 29,581.90 222,020.33 207,885.93 - 263,167.07 Permits 3,000 180.00 1,460.00 1,400.00 - 1,600.00 46.67% Fees 1,083,000 93,263.03 538,045.78 556,721.02 - 526,278.98 51.41% Fund Transfers 213,920 - - - - 213,920.00 0.00% Miscellaneous 80,700 659.88 25,726.89 2,650.23 - 78,049.77 3.28% TOTAL REVENUES 1,594,540 94,102.91 565,232.67 560,771.25 - 1,033,768.75 35.17% »�t7ir�1��.YlJJi1��F_131 DRAINAGE Personnel Services 471,053 29,581.90 222,020.33 207,885.93 - 263,167.07 4413% Supplies 8,300 314.22 3,683.31 1,737.58 - 6,562.42 20.93% Human Services 325 - - - - 325.00 0.00% City Support Services 28,500 - 2,306.64 2,703.95 - 25,796.05 9.49% Utility Services 30,370 781.95 8,364.36 4,874.01 - 25,495.99 16.05% Operations Support 2,460 - 20.48 - - 2,460.00 0.00% Staff Support 8,116 158.20 2,541.63 1,730.75 - 6,385.25 21.33% City Assistance 840 - - 120.00 - 720.00 14.29% Professional Services 24,500 - 3,941.44 13,000.00 1,500.00 10,000.00 59.18% Fund Charges/Transfers 215,573 17,881.08 110,408.94 107,286.52 - 108,286.48 49.77% Maintenance Services 21,000 - 1,268.00 1,108.23 - 19,891.77 5.28% Other costs 200 - 100.00 100.00 - 100.00 50.00% Debt Service 135,294 - 705.76 6,327.18 - 128,966.82 4.68% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 5,500 - 4,091.64 - 4,594.98 905.02 83.55% Capital Outlay 54,500 15,535.32 - 15,535.32 34,348.40 4,616.28 91.53% TOTAL DRAINAGE 1,007,031 64,252.67 '' 359,452.531 362,409.47 40,443.38 604,178.15 40.00% PROJECTS City Support Services - - - - - - 0.00% Operations Support - - 591.34 - - - 0.00% Professional Services - - 5,133.00 - 8,000.00 (8,000.00) 0.00% Maintenance Services 213,920 - 3,287.67 13.59 - 213,906.41 0.01% TOTAL PROJECTS > 213,920 - 9,012.01r 13:59 8,000.00 205,906.41 3.75 %= TOTAL EXPENDITURES 1,220,951 64;252.67 368,464.54 362,423.06 48,443.38 810,084.56 - 33.65% " REVENUE OVER(UNDER) EXPEND 373,589 29,850.24 196,768.13= 198,348.19 (48,443.38} 223,684.19 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31 ST, 2016 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit 3,000 180.00 1,460.00 1,400.00 - 1,600.00 46.67% TOTAL Permits 3,000 180.00 1,460.00 1,400.00 - ` 1,600.00 46.67 %'! Fees 000 - 457500 Drainage Penalties 8,000 799.23 4,894.29 5,011.93 - 2,988.07 62.65% 000 - 457600 Drainage Fee 1,075,000 92,463.80 533,151.49 551,709.09 - 523,290.91 51.32% TOTAL Fees 1,083,000 93,263.03 538,045.78 556,721.02 - 526,278.98 51.41% Fund Transfers 000 - 481000 Transfer In- Reserves 213,920 - - - - 213,920.00 0.00% TOTAL Fees 213,920 - - - - 213,920 0.00% Miscellaneous 000 - 491000 Interest Earned 100 729 147.63 29.10 - 70.90 29.10% 000 - 491200 Investment Interest 500 652.59 579.26 2,621.13 - (2,121.13) 524.23% 000 - 493204 Donations- Drainage Project 80,000 - 25,000.00 - 80,000.00 0.00% 000 - 497000 Misc Income - Drainage 100 - - - - 100.00 0.00% TOTAL Miscellaneous 80,700 659.88 25,726.89 2,650.23 - 78,049.77 3.28 %i TOTAL REVENUES 1,380,620 94,1;02.91 565,232.67 560,771.25 - 819,848.75 40.62 %`i DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MARCH 31ST, 2016 Cash in Bank Claim on Operating Cash Pool-Checking 162,349.59 Cash in Investments Lone Star Investment-Drainage Maint Fund 808,183.52 Total Cash in Bank & Investments $ 970,533.11 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 ST, 2016 2 0 1 5 - 2 0 1 6 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET I: ajoi,111 l�J�i►� /e1:�'1 Taxes 592,707 70,149.61 219,341.65 232,988.03 - 359,718.97 39.31% Miscellaneous 570 334.36 216.10 1,181.42 - (611.42) 207.27% TOTAL REVENUES 593,277 70,483.97 2119,557.75 234,169.45 - 359,107.55 39.47% EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies - - - - - - 0.00% City Support Services 65,500 - 20,632.27 26,856.53 - 38,643.47 41.00% Operations Support 66,425 1,986.00 9,095.00 13,112.00 - 53,313.00 19.74% Professional Services 3,000 - 1,125.00 3,000.00 - 100.00% Fund Charges/Transfers 114,405 - 56,702.50 - - 114,405.00 0.00% Maintenance Services 10,000 - - 5,555.00 - 4,445.00 55.55% Operating Equipment - - 2,000.00 - 1,712.60 (1,712.60) 0.00% TOTAL NONDEPARTMENTAL 259,330 1;986.00 89,554.77 45,523.53 4,712.60 209,093.87 19.37% TOTAL EXPENDITURES 259,330 1,986.00 89,554.77 45,523.53 4,712.60 209,093.87 19.37 %' REVENUE OVER(UNDER);EXPENDITURE 333,947 68,497.97 130,002.98 188,645.92 (4,712.60) 150,013.68 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31 ST, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 297,627.13 Cash in Investments Texas Class - Hotel Tax $ 700,793.25 Total Cash in Bank & Investments $ 998,420.38 HOTEL OCCUPANCY TAX $80,000 $70,000 - - - - - - - $60,000 ara, $50,000 - - - - - - - 4u¢YC � - I - - - $40,000 $30,000 - - - - -- - - - - - $20,000 $10,000 -- - - - - -- - - - - -- - - - -- $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP I 2015 -16 40,800 40,351 38,394 34,516 39,732 54,142 49,741 45,524 2014 -15 44,724 42,229 35,309 33,055 46,037 58,530 43,715 43,525 53,346 72,297 51,772 39,195 201314 40,023 40,709 33,342 29,778 36,680 56,699 48,081 49,579 54,858 67,329 57,399 34,297 2012 -13 35,851 39,439 32,392 32,120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 201112 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 111,129 - 1,000.00 93,000.00 - 18,129.00 8169% Miscellaneous 100 46.89 56.77 1,028.02 - (928.02) 1028.02% TOTAL REVENUES 111,229 46.89 1,056.77 94,028.02 - 17,200.98 84.54 %i EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges /Transfers - - 32,405.00 - - - 0.00% Operating Equipment 14,800 - - - 950.00 13,850.00 6.42% Capital Outlay 20,000 - 10,930.00 6,150.00 23,891.49 (10,041.49) 150.21% TOTAL PARKLAND DEDICATION 34,800 - 43,335.00 6,150.00 24,841.49 3,808.51 89.06 %` TOTAL EXPENDITURES 34,800 - 43,335.00 6,150.00 24,841.49 3,808.51 89.06% REVENUE OVER(UNDER) EXPEND' 76,429 46.89 (42,278.23); 87,878.02 (24,841.49) 13,392.47 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 111,129 - 1,000.00 93,000.00 - 18,129.00 83.69% TOTAL Fees 111,129 - 1,000.00 93,000.00 ` 18,129.00 83.69 %i Miscellaneous 000 - 491000 Interest Earned 75 11.81 4632 6,319.00 - (6,244.00) 8425.33% 000 - 491200 Investment Interest 25 35.08 10.45 94.71 - (69.71) 378.84% 000 - 497000 Misc Income - - - 870.12 - (870.12) 0.00% TOTAL Miscellaneous 100 46.89 56.77 7,283.83 - (7,183:83) 7283.83 %r TOTAL REVENUES 111,229 46.89 1,056.77 100;283.83 - 10,945.17 90.16 %r PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $245,553.82 Cash in Investments Texas Class- Park Fund 76,451.30 Total Cash in Bank & Investments $322,005.12 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *. 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 40,000 - 85,747.50 37,655.00 - 2,345.00 94.14% Miscellaneous 250 148.62 125.62 625.76 - (375.76) 250.30% TOTAL REVENUES 40,250 148.62 85,873.12 38,280.76 - 1,969.24 95.11 % EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 27,000 - 300.00 140.00 - 26,860.00 0.52% TOTAL TREE MITIGATION 27,000 - 300.00 140.00 - 26,860.00 0.52% TOTAL EXPENDITURES 27,000 - 300.00 14000 - 26,860.00 0.52 % REVENUE OVER(UNDER) EXPEND 13,250 148.62 85,573.12 38,140.76 - (24,890.76) CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 t********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 40,000 - 85,747.50 37,655.00 - 2,345.00 94.14% TOTAL Fees 40,000 - 85,747.50 37,655.00 2,345`.00 =94.14% Fund Transfers 000 - 481000 Transfer In -Reserves - - - - - - 0.00% TOTAL Fund Transfers - - - 0.00 %` Miscellaneous 000 - 491000 Interest Earned 150 2.62 85.95 20.51 - 129.49 13.67% 000 - 491200 Investment Interest 100 146.00 39.70 60525 - (505.25) 605.25% TOTAL Miscellaneous 250 148.62 125.65 625.76 - (375.76) 25030 %` TOTAL REVENUES 40,250 148.62 85,873'.15 38,280.76 < - 1,969.24 95.11 %s' TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool- Checking $51,027.94 Cash in Investments MBIA Investment -Tree Mitigation 318,260.81 Total Cash in Bank & Investments $369,288.75 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 920,000 49,878.00 529,587.00 462,105.00 - 457,895.00 50.23% Fund Transfers 2,550,541 - - - - 2,550,541.00 0.00% Miscellaneous 6,600 2,224.53 2,856.90 8,566.06 - (1,966.06) 129.79% TOTAL REVENUES 3,477,141 52,102.53 532,443.90 470,671.06 - 3,006,469.94 13.54 %o-! EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - Professional Services 106,000 - Maintenance Services 1,000 - 375.00 5,000.00 0.00% 105,000.00 0.94% 1,000.00 0.00% TOTAL NON DEPARTMENTAL 112,000 - 375.00 1,000.00 111,000.00 0.89% MISC & PROJECTS PROJECTS Professional Services Fund Charges /Transfers 315,141 - - - 186,732.71 128,408.29 59.25% 3,050,000 - - 366,594.84 - 2,683,405.16 12.02% TOTAL MISC & PROJECTS 3,365,141 - - 366,594.84 186,732.71 2,811,813`.45 16.44 %' TOTAL EXPENDITURES 3,477,141 - 375.00 366,594.84 187,732.71 2,922,813.45 15.94 %' REVENUE OVER(UNDER) EXPENDITURES - 52,102.53 532;068.90' 1;04,076.22 (1 T,732.71) 83,656.49 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 920,000 49,878.00 529,587.00 462,105.00 - 457,895.00 50.23% TOTAL Fees 920,000 49,878.00 529,587.00 462,105.00 - 457,895.00 50.23 %i Fund Transfers 000 - 481000 Transfer from Reserves 2,550,541 - - - - 2,550,541.00 0.00% TOTAL Fund Transfers 2,550,541 - - - 2,550,541.00 0.00 % ` Miscellaneous 000 - 491000 Interest Earned 600 33.48 359.81 316.80 - 283.20 52.80% 000 - 491200 Investment Income 6,000 2,191.05 2,497.09 8,24926 - (2,249.26} 137.49% TOTAL Miscellaneous 6,600 2,224.53 2,856.90 8,566.06 - (1,966.06) 129.79% TOTAL REVENUES 3,477,141 ? 52,1;02.53 532,443.90 470,671!06 - 3,006,469.94 13.54 %' CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 711,382.08 Cash in Investments Lone Star Investment-Capital Recovery Water 5,207,254.20 Total Cash in Bank & Investments $ 5,918,636.28 CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 2U15'2O1G 421-CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y-T-D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL Y-T-D ACTUAL ENCUKdBR BALANCE BUDGET REVENUE SUMMARY Fees 550.00 33.756.00 280.00.28 230.00136 - 319.098.04 41.82% Fund Transfers 3.077.712 - - - - 3.077.712.00 0.00% K4inoo||anooun 16,000 5�19.88 982808 1479308 -_ 1L206.9C2 82.46% TOTALREVENUES�' m� 139.312.00 EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 84.00 361A6 2.526.97 2.100.03 1.000.08 80.839.97 3.76% FundChargoaAranokern 130.312 139.312.00 0.00Y6 Maintenance Services 320\400 -_ - - -_ 320,40K0lX0 010% TOTAL NON T^.2,526.97 w ,000.,551..�� Professional Services 100.000 - - - - 100.000.00 0.00% Sewer Projects _3,000,000� �_ - - -_ _3,000\000.00 {u}D% TOTAL EXPENDITURES 3,643,712 361.46 2,526.97 2,160.03 1,000.00 3,640,551.97 0.09% REVENUE OVER(UNDER) EXPENDITURES 38,614.42 287,371.39 242,634.41 __(11000.00 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 500,000 28,356.00 245,870.28 210,20136 - 289,798.64 42.04% 000 - 455913 Cap Recovery -North Sewer Tr 50,000 5,400.00 34,200.00 19,800.00 - 30,200.00 39.60% TOTAL Fees 550,000 33,756.00 280,070.28 230,001.36 319,998.64 41.82 % ' Fund Transfers 000 - 481000 Transfer from Reserves 3,077,712 - - - - 3,077,712.00 0.00% TOTAL Fund Transfers 3,077,712 - - - - 3,077,712.00 0.00 % ' Miscellaneous 000 - 491000 Interest Earned 1,000 26.87 209.43 20637 - 79163 20.64% 000 - 491200 Investment Income 15,000 3,969.26 13,795.50 22,937.41 - (7,937.41) 152.92% 000 - 491800 Gain /Loss - 209.96 (2,142.17) (29,620.02) - 29,620.02 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - 1,013.79 (2,034.68) 21,269.32 - (21,269.32) 0.00% TOTAL Miscellaneous 16,000 5,219.88 9,828.08 14,793.08 - 1,206.92 92.46 %i TOTAL'' REVENUES 3,643,712 38,975.88 289,898.36 244,794.44 - 3,398,917.56 6.72% CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 569,972.35 Cash in Investments Lone Star Investment-Capital Recovery Sewer 2,357,777.43 Capital One-investment 1,748,248.96 Total Cash in Bank & Investments $ 4,675,998.74 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,722,162 128,509.18 5,293,024.73 5,692,365.09 - 29,796.91 99.48% Miscellaneous 369,213 769.07 352,111.35 4,543,724.32 - (4,174,51132} 1230.65% TOTAL REVENUES 6,091,375 129,27825 5,645,136.08 ' 10,236,089.41 - (4,144,714.41} 168.04 %< EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 102,500 - 1,550.00 83,574.23 - 18,925.77 81.54% Debt Service 5,718,918 - 4,442,606.03 4,411,781.19 - 1,307,136.81 77.14% Other Financing Sources - - - 4,220,709.38 - (4,220,709.38) 0.00% TOTAL GENERAL GOVERNMENT 5,821,418 - 4,444,156.03 8,716,064.80 (2,894,646.80) 149.72% TOTAL EXPENDITURES 5,821,418 = 4,444,156.03 8,716,064.80 - (2,894,646.80) 149.72 %< ** REVENUE OVER(UNDER) EXPEND 269,957 129,278.25 1,200,980.05 1,520,024.61 - (1,250,067.61)' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: MARCH 31 st, 2016 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 25% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411900 Property Tax Revenue 5,722,162 128,509.18 5,293,024.73 5,692,365.09 - 29,796.91 99.48% TOTAL Taxes 5,722,162 128,509.18 5,293,024.73 5,692,365.09 - 29,796.91 99.48% Miscellaneous 000 - 491000 Interest Earned 75 35.53 61.08 23158 - (158.58) 311.44% 000 - 491200 Investment Earnings 2,000 733.54 981.52 2,371.99 - (371.99) 118.60% 000 - 495015 Contribution from SED 367,138 - 351,068.75 356,118.75 - 11,019.25 97.00% 000 - 498000 Proceeds From Refunding Det - - - 4,185,000.00 - (4,185,000.00) 0.00% TOTAL Miscellaneous 369,213 769.07 352,111.35 4,543,724.32 - (4,174,511.32) 1230.65% TOTAL REVENUES 6,091,375 129,278.25 5,645,136.08 10,236,089.41 - (4,144,714.41) 168.04% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 505 -TAX I& S 2 0 1 5 - 2 0 1 6 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101 - 541500 Paying Agent 2,500 1,550.00 1,350.00 1,150.00 54.00% 101 - 541502 Cost of Bond Issuance 100,000 82,224.23 17,775.77 82.22% TOTAL Professional Services 102,500 1,550.00 83;574.23 18,925.77 81.54 %: Debt Service 101- 555612 Bond -GO Refunding 2010 - Principal 275,000 265,000.00 275,000.00 - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 55,425 33,750.00 29,775.00 25,650.00 53.72% 101 - 555626 LS &D SR2006- Principal 400,000 350,000.00 394,772.50 5,227.50 98.69% 101- 555626.1 LS &D SR2006- Interest 189,419 105,70938 0.01 189,418.99 0.00% 101 - 555628 CO Bond 2007 - Principal 122,800 - - 122,800.00 0.00% 101- 555628.1 CO Bond 2007 - Interest 4,925 4,790.61 2,461.75 2,463.25 49.98% 101 - 555629 GO Bond 2007 - Principal 265,000 255,000.00 264,944.60 55.40 99.98% 101- 555629.1 GO Bond 2007 - Interest 159,036 87,268.47 82,214.00 76,822.00 51.70% 101 - 555630 GO Bond SR2008 Principal 440,000 420,000.00 440,000.00 - 100.00% 101- 555630.1 GO Bond SR2008 Interest 296,946 161,689.50 153,016.50 143,929.50 51.53% 101 - 555631 GO Bond SR2009 Principal 540,000 535,000.00 540,000.00 - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 282,675 153,412.50 145,387.50 137,287.50 51.43% 101 - 555633 GO SR2011 Principal 225,000 220,000.00 225,000.00 - 100.00% 101 - 555633.1 GO SR2011 Interest 341,663 176,918.75 172,518.75 169,144.25 50.49% 101 - 555634 GO SR2011A Refund Principal 605,000 610,000.00 605,000.00 - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 116,675 68,968.00 61,861.50 54,813.50 53.02% 101 - 555635 GO SR2012 Principal 310,000 295,000.00 310,000.00 - 100.00% 101 - 555635.1 GO SR2012 Interest 194,721 106,079.38 100,363.75 94,357.25 51.54% 101 - 555636 Tax Note - SR2013 - Principal 170,000 165,000.00 170,000.00 - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 5,950 4,142.50 3,400.00 2,550.00 57.14% 101 - 555637 Tax Note - SR 2013A - Principal 160,000 160,000.00 160,000.00 - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 5,265 4,192.50 3,152.51 2,112.49 59.88% 101 - 555638 Bond -GO 2014 Refund - Principal 100,000 50,000.00 100,000.00 - 100.00% 101 - 555638.1 Bond -GO 2014 Refund - Interest 294,275 210,684.44 147,637.50 146,637.50 50.17% 101 - 555639 Tax Note - SR2015 - Principal 35,000 - - 35,000.00 0.00% 101 - 555639.1 Tax Note - SR2015 - Interest 3,763 1,875.17 1,887.83 49.83% 101 - 555640 Bond -Ref 2015 Bond- Principal - 80,000.00 (80,000.00) 0.00% 101 - 555640.1 Bond -GO Ref 2015- Interest 27,056.25 (27,056.25) 0.00% 101 - 555900 Debt Service - (83,656.10) 83,656.10 0.00% 101 - 555800 Bond Premium 120,380 120,380.00 0.00% TOTAL Debt Service 5,718,918 4,442,606.03 4,411,781.19 1,307,136.81 77.14 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 505 -TAX I& S 2 0 1 5 - 2 0 1 6 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 25% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Other Financing Sources 101 - 556300 Payment to Refund Debt 4,220,709.38 (4,220,709.38) 0.00% TOTAL Other Financing Sources 4,220,709.38 (4,220,709.38) 0.00% TOTAL EXPENDITURES 5,821,418 - 4,444,156.03 8,716,064.80 - (2,894,646.80) ` 149.72% TAX I&S CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 768,393.13 Cash in Investments IVIBIA Investment- Tax I&S 1,598,808.74 Total Cash in Bank & Investments $ 2,367,201.87 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2016 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 5- 2 0 1 6********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 25% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,518,362 309,709.53 1,704,911.27 1,752,551.47 - 1,765,810.53 49.81% Miscellaneous 10,200 3,519.48 6,966.57 17,218.39 - (7,018.39) 168.81% TOTAL'REVENUES 3,528,562 313,229.01 1,711,877.84 ` 1,769,769.86 - 1,758,79214 50.16 %+ EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 325,458 20,660.49 65,388.73 127,166.15 - 198,291.85 39.07% Supplies 750 - 397.14 53.60 - 696.40 7.15% Human Services 1,000 44.44 - 44.44 - 955.56 4.44% City Support Services 12,545 - 1,114.09 1,643.91 396.00 10,505.09 16.26% Utility Services 4,820 261.90 343.31 1,043.44 - 3,776.56 21.65% Operations Support 139,572 8,632.29 51,013.30 62,432.46 125.77 77,013.77 44.82% Staff Support 19,100 64.04 1,690.32 2,837.21 342.76 15,920.03 16.65% City Assistance 1,005,000 111.00 - 161.70 - 1,004,838.30 0.02% Professional Services 87,500 2,081.50 831.50 7,165.90 7,500.00 72,834.10 16.76% Fund Charges /Transfers 418,138 4,252.00 403,114.73 381,630.75 - 36,507.25 91.27% Debt Service 161,216 - 274,494.00 3,107.25 - 158,108.75 1.93% Operating Equipment 2,628 - 300.18 - - 2,628.00 0.00% Capital Outlay 40,000 - - - - 40,000.00 0.00% TOTAL'ECONO DEVELOPMENT 2,217,727 36,107.66 798,687.30 587,286.81 8,364.53 1,622,075.66 26.86 %! MISC & PROJECTS PROJECTS 441,775 156,335.66 - 158,182.51 9,830.00 273,762.49 38.03% TOTAL MISC & PROJECTS 441,775 156,335.66 158,182.51 9,830.00 ; 273,762.49 0.00 %' FM3009 ROAD &BRIDGE EXPANSION Maintenance Services - - 20,825.51 - - - 0.00% TOTAL FM3009 RD &BRIDGE EXPANSION - - 20,825.51 - - 0.00 %` TOTAL EXPENDITURES 2,659,502 192,443.32 819,512.81 745,469.32 18,194.53 1,895,838.15 28.71 %' " REVENUE OVER(UNDER) EXPEND 869,060 120,785.69 892,365.03 1,024,300.54 (18;194.53) (137,046.0'1) SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2016 Cash in Bank Claim on Operating Cash Pool-Checking $ 625,153.37 Cash in Investments Texas Class Investment-Economic Development Corl 7,590,913.76 Schertz Bank & Trust-Certificate of Deposit 1,053,377.41 Total Cash iin Bank & Investments $ 9,269,444.54 4B SALES TAX By Collection Month 41 �� C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING MARCH 31st, 2016 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING MARCH 31st, 2016 INVESTMENT POOLS Beginning Book Value Yiel Deposits/ Purchases Interest Withdrawals Earns Ending Book Value Ending Mkt Value Par Value Maturity Date Weighted Avva Mat. OPERATIONS -BANK CASH Schertz Bank & Trust - Pooled Cash 8,367,442.47 0.0500 4,564,820.02 4,858,325.70 355.79 8,074,292.58 8,074,292.58 8,074,292.58 N/A Schertz Bank & Trust - PEG Fund 521,801.55 0.0000 - 24,900.00 - 496,901.55 496,901.55 496,901.55 N/A TOTAL OPERATIONS - 58,889,244.02 - 4,564;820.02 ..4,883;225.70 355.791 8;571,194:13 >8!,571,194L13 <:8,571,194.13 - LOGIC General Fund 11,203,717.75 0.5206 - - 4,953.86 11,208,671.61 11,208,671.61 11,208,671.61 N/A 38 Days G /F- Equipment Replacement 73,815.00 0.5206 - - 32.64 73,847.64 73,847.64 73,847.64 N/A 38 Days G /F- Vehicle Replacement 476,788.80 0.5206 - - 210.81 476,999.61 476,999.61 476,999.61 N/A 38 Days G/F -Air Conditioner Replacement 221,031.85 0.5206 - - 97.74 221,129.59 221,129.59 221,129.59 N/A 38 Days SR2009 Bond- Street Projects(II) 1,032,489.35 0.5206 - - 456.54 1,032,945.89 1,032,945.89 1,032,945.89 N/A 38 Days TOTAL SLOGIC 13 ,007;842.75 °- "- 55,751.591 13;013,594.34 13,013,594`.34 13,013,594.34 - LONESTAR Capital Recovery - Sewer 2,356,785.35 0.5000 - - 992.08 2,357,777.43 2,357,777.43 2,357,777.43 N/A 46 Days Capital Recovery - Water 5,205,063.15 0.5000 - - 2,191.05 5,207,254.20 5,207,254.20 5,207,254.20 N/A 46 Days Drainage Fund 807,843.46 0.5000 - - 340.06 808,183.52 808,183.52 808,183.52 N/A 46 Days Facilities Master Plan 145,520.41 0.5000 - - 61.26 145,581.67 145,581.67 145,581.67 N/A 46 Days GO SR2011 Animal Shelter 8,607.62 0.5000 - - 3.62 8,611.24 8,611.24 8,611.24 N/A 46 Days GO SR2011 Soccer Fields 161,993.79 0.5000 - - 68.19 162,061.98 162,061.98 162,061.98 N/A 46 Days GO SR2011 Swimming Pool 4,795,096.60 0.5000 - - 2,018.48 4,797,115.08 4,797,115.08 4,797,115.08 N/A 46 Days GO SR2012 Downtown Improvements 980,828.76 0.5000 - - 412.88 981,241.64 981,241.64 981,241.64 N/A 46 Days SE Elevated Water Tank 812,071.62 0.5000 - - 341.84 812,413.46 812,413.46 812,413.46 N/A 46 Days Sewer /CCMA Project 2,934,712.51 0.5000 - - 1,235.36 2,935,947.87 2,935,947.87 2,935,947.87 N/A 46 Days W /S- Customer Deposits 296,137.88 0.5000 - - 124.66 296,262.54 296,262.54 296,262.54 N/A 46 Days W /S- Equipment Repl /Cap.Imp 178,051.99 0.5000 - - 74.95 178,126.94 178,126.94 178,126.94 N/A 46 Days Water &Sewer 1,073,195.98 0.5000 - - 451.76 1,073,647.74 1,073,647.74 1,073,647.74 N/A 46 Days W /S- Vehicle Replacement 257.212.31 0.5000 - - 108.27 257.320.58 257.320.58 257.320.58 N/A 46 Days TOTAL- :LONESTAR <20,013,121.43 - - .::8,424.46: 20;021,545.89 :20.,021,545.89 20,021 545.89 - TEXAS CLASS Tax I &S 1,598,075.20 0.5400 - - 733.54 1,598,808.74 1,598,808.74 1,598,808.74 N/A 72 Days Police Forfeiture 244,687.76 0.5400 - - 112.34 244,800.10 244,800.10 244,800.10 N/A 72 Days Park Fund 76,416.22 0.5400 - - 35.08 76,451.30 76,451.30 76,451.30 N/A 72 Days Economic Development Corporation 7,596,542.03 0.5400 - - 3,486.85 7,600,028.88 7,600,028.88 7,600,028.88 N/A 72 Days Library Board 44,975.24 0.5400 - - 20.64 44,995.88 44,995.88 44,995.88 N/A 72 Days Tree Mitigation 318,114.81 0.5400 - - 146.00 318,260.81 318,260.81 318,260.81 N/A 72 Days Tax Note 2013 Fire Truck 4,942.85 0.5400 - - 2.26 4,945.11 4,945.11 4,945.11 N/A 72 Days Hotel Tax 700,471.75 0.5400 - - 321.50 700,793.25 700,793.25 700,793.25 N/A 72 Days Special Events Fund 16,828.59 0.5400 - - 7.74 16,836.33 16,836.33 16,836.33 N/A 72 Days Tax Notes 2015 EMS Ambulances 88,773.56 0.5400 - - 40.72 88,814.28 88,814.28 88,814.28 N/A 72 Days Tax Notes 2015 Drainage Equipment 680,886.19 0.5400 - - 312.53 681,198.72 681,198.72 681,198.72 N/A 72 Days Tax Notes 2015 Water Equipment 282,063.01 0.5400 - - 129.44 282,192.45 282,192.45 282,192.45 N/A 72 Days Tax Notes 2015 General Fund Equipme 240,732.94 0.5400 - - 110.50 240,843.44 240,843.44 240,843.44 N/A 72 Days Tax Notes 2015A Fire Trucks & EquiP 625.46 0,5_4.00 - - 0.31 625.77 625.77 625.77 N/A 72 Days TOTAL': TEXAS .:CLASS 11,894,135.61 >5,459.45 11:899,595':.06 11`. .,899,595 -.06 11,899.595.06 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING MARCH 31St, 2016 ve .e Director Beginning Interest Ending Par Maturity I .SaZIAT MANAGED A_.O &T Boo Val= Yield, Zlxa aka H thdrawals Larmad Hook valve Mkt Value Yra1738 Pate Avc Mat, Capital One General Fund 1,364,.370.59 2.6500 - 281.95 (41.12) 1,364,047.52 1,364,128.71 1,301,513.68 N/A 796 Days Capital One Capital Recovery Sewer 1,739,276.22 2.0900 - 361.46 2,294.87 1,741,209.63 1,748,284.96 1,688,902.11 N/A 732 Days TOTAL CAPITAL ONE 3,103,646.81 643 „41 2}.253,78 3,105,257.15 3,112413.67 2,990,415,79 f RTIFI UE19 or DEPOSIT C. D. SBST- Water &Sewer 1,076,645.00 9..8000 - - - 1,076,645.00 1.,078;650.80 1,076,645.00 1/6/2017 365 Days Schertz Economic .Development Corp. 1,052;186.85 0.3500 - - - 1,052,186.85 1,053,377.41 1,052,.186.85 6/2/2016 180 Days Schertz Economic Development Corp. 1,000,000.00 0.8000 - - - 1.,000,000.00 1,.001,841.10 1,000,000.00 1/7/2017 365 Days TOTAL C.D.s 31228,831.85 - 3,128,831.85 3,133;869.81 3,128,831.85 TOTAL PORTFOLIO 0.63 :$22,245.04 '$ 59,740,018.42 ;$ 59,752,212.40 $ 59,625.,177.06 103 Days ve .e Director TOT, TOTAL TEXAS CLASS 20% City Portfolio By Investment Type w1rouY_IiM977M TOTAL LONESTAR 34% TOTAL LOGIC 22% 0 Special RevenUE Funds, $21,117,052.95 0 Debt $1 City Portfolio By Use M Designated Funds, $1,570,464.22 E3 Operations, $23,296,292.99 $12,169,593.49 3.00 2.50 2.00 1.50 1.00 0.50 0.00 MONTHLY YIELDS Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 Mar -16 Apr -16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 Oct -15 Nov -15 Dec -15 Jan -16 Feb -16 I Mar -16 Apr - 16 May -16 Jun -16 Jul -16 Aug -16 Sep -16 01 Month T -Bill 0.0100 0.1100 0.1400 0.2200 0.2300 0.1800 03 Month T -Bill 0.0800 0.2200 0.1600 0.3300 0.3300 0.2100 06 Month T -Bill 0.2300 0.4200 0.4900 0.4300 0.4900 0.3900 BSchertz Portfolio 0.3930 0.4204 0.4328 0.5432 0.5913 0.6349 BSchertz Bank &Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 BCD 365 Days 0.7500 BCD 180 Days 0.6000 -LOGIC 0.1635 0.7500 0.6000 0.1637 0.7500 0.3500 0.2331 0.8000 0.8000 0.8000 0.3500 0.3500 0.3500 - --- ----- - -- 0.3922 0.4823 0.5206 - -- - - ----- - -------- -------- --------- DLoneStar 0.1900 0.2000 0.2900 0.4100 0.4500 0.5000 DMBIA 0.2100 0.2400 0.2900 0.4200 0.4900 0.5400 - Capital One 2.6936 2.6959 2.3028 2.2400 2.2891 2.3359 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 3/31/2016 General Fund Assets Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 6,761.53 6,761.53 6,761.53 28.00 0.41 Total Cash & Equivalents 6,761.53 6,761.53 6,761.53 28.00 0.41° Fixed Income Federal Home LN Mtg Corp Medium Term Nts 2/26/2018 697.00 100,000.00 100,000.00 100,014.00 1,100.00 1.10 Federal Natl Mtg Assn 1/30/2017 305.00 100,000.00 102,366.80 100,482.00 1,250.00 1.24 Federal Home LN Mtg Corp Reference Nts 11/17/2017 596.00 100,000.00 109,860.00 107,053.00 5,125.00 4.79 Federal Home LN Mtg Corp Refrnce 8 6/13/2018 804.00 475,000.00 526,095.45 516,942.50 23,156.00 4.48 Federal Home LN Mtg Federal Natl Mtg Assn 11/1/2027 4232.00 29,752.15 31,081.70 31,150.50 892.00 2.86 US Treasury Note 10/15/2017 563.00 140,000.00 139,698.44 140,361.20 1,225.00 0.87 US Treasury Note 11/15/2017 594.00 200,000.00 199,042.97 200,536.00 1,750.00 0.87 US Treasury Note 11/30/2019 1339.00 100,000.00 99,554.69 99,971.00 1,000.00 1.00 US Treasury Note 2/28/2018 699.00 50,000.00 49,585.94 50,013.50 375.00 0.75 Total Fixed Income 11/30/2019 1339.00 1,294,752.15 1,357,285.99 1,346,523.70 35,873.00 2.66% Total Assets 2/28/2018 795.99 1,301,513.68 1,364,047.52 1,353,285.23 35,901.00 2.65 %> Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Ed #690 13,902.11 13 902.11 13,902.11 57.00 0.41 Total Cash & Equivalents 13,902.11 13,902.11 13,902.11 57.00 0.41% Fixed Income Federal Home LN Mtg Corp Medium Term Nts 2/26/2018 697.00 100,000.00 100,000.00 100,014.00 1,100.00 1.10 Federal Natl Mtg Assn 10/26/2017 574.00 125,000.00 124,588.38 125,265.00 1,093.00 0.87 Federal Home LN Mtg Corp Reference Nts 11/17/2017 596.00 100,000.00 109,860.00 107,053.00 5,125.00 4.79 Federal Home Mtg Corp Refrnce 8 6/13/2018 804.00 350,000.00 387,637.60 380,905.00 17,062.00 4.48 Federal Home LN Mtg Corp 3/27/2019 1091.00 100,000.00 108,297.40 108,252.00 3,750.00 3.46 US Treasury Note 3/15/2017 349.00 150,000.00 149,753.91 150,193.50 1,125.00 0.75 US Treasury Note 10/15/2017 563.00 100,000.00 99,644.53 100,258.00 875.00 0.87 US Treasury Note 10/31/2019 1309.00 100,000.00 100,065.85 101,739.00 1,500.00 1.47 US Treasury Note 11/15/2017 594.00 200,000.00 199,042.97 200,536.00 1,750.00 0.87 US Treasury Note 11/30/2019 1339.00 150,000.00 149,332.03 149,956.50 1,500.00 1.00 US Treasury Note 2/28/2018 699.00 100,000.00 99,175.78 100,027.00 750.00 0.75 US Treasury Note 7/15/2016 106.00 100,000.00 99,909.07 100,083.00 625.00 0.62 Total Fixed Income 1 675, 000. 00 1,727,307.52 1,724,282.00 36,255.00 2.10% Total Assets 731.65 14,688,902.11 ;1,741,209.63' 1,738,184. -11 36,312.00 2.09 %+