Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
09-JUNE 2014 FINANCIAL STATEMENT
JUNE 2014 F 0 0 inancial Report CITY OF Prepared By: The Finance Department September 22, 2014 CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JUNE 30th.2U14 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 14.838.072 707.361.35 12.308.881.30 13,440.088.35 1.380.573.05 8083% Franchises 1.778.005 124,49421 1.173.080.60 1.258.285.06 ' 520.319.94 70.75% Permits 1.205.062 144.291.05 1.000.200.00 1.052.209.02 152.79219 87.32% Uoonooa 70.100 5.157.50 61.045.50 00.695.00 - 3.405.00 9514% Fees 2.090.298 250.500.90 2.340.608.23 2.108.697.01 (50.00) 720.050.39 75.07% Fines 30,000 2,674.07 22,519.32 23,193.50 - 6,00644 77.31% Inter-Jurisdictional 085.780 23.15310 857.055.07 448.145.76 238.634.24 05.86% Fund Transfers 1.970.305 140.080.03 1.204.104.25 1.314.071.47 ' 661.493.58 60.53% Miscellaneous 468,200 33,897.74 319,511.91 349,460.89 - 118,739.11 74.64% TOTALREVENUES 23,943,082 1,437,626,83 19,228,802.64 20,128,717.52 (50.00) 3,814,414.48 84.07% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23.575 1.013.46 15.075.87 17,401.32 - 0.093.68 7415% Supplies 508 498.91 470.41 23.59 3528% City Support Services 42.100 41.88 39.872.30 40.507.04 54.88 1.507.37 96.42% Operations Support 300 9.98 418.52 80.88 218.08 20.62 93.13% Staff Support 20.700 186.00 18.975.17 12.78478 18.00 7.88722 61.85% Professional Services 1,200� �_ �_ �_ �_ 1,208I0 0.00% TOTAL CITY COUNCIL 88,375 2,051.43 74,340.83 71,340.84 291.68 16,742.48 81.06% CITY MANAGER Personnel Services 910.718 01.144.80 809.980.34 871.094.82 - 239.023.18 7109% Supplies 3.000 473.89 791.17 2.44820 8275 408.99 84.37% City Support Services - - - 1.762.50 - (1.702.50) 0.00% Operations Support 100 - - - - 100.00 0.00Y6 Staff Support 35.350 3.490.12 17.330.30 13.539.50 2.070.91 19.733.53 44A8Y4 Professional Services ---_-1,200 ---____-_ ----____-_ ---____-_. —____-_ ---__1,200.00 0.00% TOTAL CITY MANAGER 950,368 65,114.81 688,107.81 688,845A4 2,159.66 259,36120 72.71% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 309,881 19,721.99 185,524.83 209,027.45 - 100,853.55 67.45% Supplies 2,000 212.34 1,386.04 1,051.38 11.87 936.75 53.16% City Support Services 1,000 - - - - 1,000.00 0.00% Operations Support 4,000 - 2,230.00 1,131.00 430.00 2,439.00 39.03% Staff Support 7,840 178.17 2,33424 4,159.40 353.09 3,327.51 57.56% Court Support 700 - 120.00 - - 700.00 0.00% Professional Services 65,200 3,390.00 39,573.60 40,217.65 21,564.06 3,418.29 94.76% Maintenance Services 2,800 - 800.00 1,550.00 950.00 300.00 89.29% Operating Equipment 800 - - 37.27 - 762.73 4.66% TOTAL MUNICIPAL COURT 394,221 23,502.50 231,968.71 257,174.15 23,309.02 113,737.83 71.15% CUSTOMER RELATIONS -311 Personnel Services 110,340 8,577.19 74,705.39 80,231.27 - 30,108.73 72.71% Supplies 200 - 17.10 121.35 - 78.65 60.68% Staff Support 1,750 - 336.00 171.00 - 1,579.00 9.77% Operating Equipment 500 - - - - 500.00 0.00% TOTAL CUSTOMER RELATIONS -311 112,790' 8,577.191 75,058.49 80,523.62 32,266:38 71.39% PLANNING & ZONING Personnel Services 133,060 10,023.57 84,052.10 90,828.22 - 42,231.78 68.26% Supplies 2,672 29.49 711.39 648.40 - 2,023.60 24.27% Operations Support 750 - 171.88 - - 750.00 0.00% Staff Support 18,532 - 1,139.42 430.18 300.00 17,801.82 3.94% Professional Services 150 5.00 30,736.02 21.00 - 129.00 14.00% Operating Equipment 318 - - - - 318.00 0.00% TOTAL PLANNING & ZONING 155,4821 10,058.06 1[16,810.81 91,927.80 300.00 63,254.20 59.32% LEGAL SERVICES Operations Support 12,000 - 3,970.00 3,831.04 84.76 8,084.20 32.63% Professional Services 438,000 50,203.10 331,260.12 206,346.15 - 231,653.85 47.11% TOTAL LEGAL SERVICES 450,000' 50,203.10 335,230.12 210,177.19 8416 239,738.05 4672% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 567,475 37,453.68 407,239.91 398,018.22 - 169,456.78 70.14% Supplies 65,450 5,379.37 48,662.79 39,385.78 4,784.58 21,279.64 67.49% Utility Services 99,300 6,815.83 61,752.05 60,644.16 - 38,655.84 61.07% Staff Support 12,147 304.24 5,462.08 6,886.40 883.68 4,376.92 63.97% Maintenance Services 40,530 2,064.62 46,351.81 13,274.85 34.31 27,220.84 32.84% Rental /Leasing - - 458.25 - - - 0.00% Operating Equipment 26,770 - - 9,807.24 - 16,962.76 36.64% TOTAL GENERAL SERVICES 811,672 52,017.74? 569,926.89 528,016.65 5,702.57 277,952.78 65.76% BUILDING 6 -8 MAINTENANCE Supplies 26,100 938.46 16,258.82 20,566.34 872.00 4,661.66 82.14% Utility Services 86,700 5,536.18 48,341.53 49,755.96 - 36,944.04 57.39% Maintenance Services 64,000 10,145.34 31,818.77 38,428.33 1,968.41 23,603.26 63.12% Operating Equipment 24,060 14,358.00 9,249.00 14,358.00 1,049.93 8,652.07 64.04% TOTAL BUILDING 6-8 MAINTENANCE 200,860? 30,977.98! 105,668.12 123,108.63 3,89034 73,861.03 63.23% CITY SECRETARY 0.00% Operating Equipment 2,300 - 269.00 1,955.00 - 345.00 Personnel Services 171,031 12,443.86 107,404.60 115,508.45 - 55,522.55 67.54% Supplies 1,200 - 549.87 423.14 - 776.86 35.26% City Support Services 9,600 5,961.38 3,567.78 9,576.38 - 23.62 99.75% Operations Support 150 50.00 - 50.00 - 100.00 3333% Staff Support 7,895 598.00 3,382.72 3,530.06 834.71 3,530.23 55.29% TOTAL CITY SECRETARY 189,876 1.9,053.24 114,904.97 129,088.03 834.71 59,953.26 68.43 %' NON - DEPARTMENTAL City Support Services 373,511 33,734.49 315,175.27 271,367.04 1,175.82 100,968.14 72.97% Operations Support 128,000 5,998.66 86,436.86 96,007.52 - 31,992.48 75.01% Staff Support 100 19.37 12.88 140.08 - (40.08) 140.08% City Assistance 993,666 71.00 572,196.35 794,592.65 - 199,073.35 79.97% Professional Services 231,350 2,760.58 73,076.08 33,661.98 - 197,688.02 14.55% Fund Chrgs /Transfrs -Spec Events Fnd 475,000 - 165,000.00 - - 475,000.00 0.00% Operating Equipment 2,300 - 269.00 1,955.00 - 345.00 85.00% TOTAL NON- DEPARTMENTAL 2,203,927 42,584.10' 1,212,166.44 1,197,724.27 1,175.82 1,005,026.91 54.40 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 215,900 15,338.56 186,482.38 136,746.15 - 79,153.85 63.34% Supplies 3,400 91.91 2,186.90 1,898.15 45.98 1,455.87 57.18% Operations Support 27,050 - 13,587.35 9,065.03 - 17,984.97 33.51% Staff Support 5,240 280.00 2,620.82 2,664.33 - 2,575.67 50.85% Professional Services 15,000 - - 4,290.00 - 10,710.00 28.60% Operating Equipment 3,100 - - 99.99 - 3,000.01 3.23% TOTAL PUBLIC AFFAIRS 269,690; 1!5,710.47 204,877.45 154,763`65 45.98 114,880.37 57.40% RECORDS MANAGEMENT Personnel Services 49,777 3,669.35 34,181.18 35,175.97 - 14,601.03 70.67% Supplies 400 - 5.28 107.77 - 292.23 26.94% Staff Support 1,860 969.14 911.38 1,064.14 - 795.86 57.21% Professional Services 17,000 150.00 10,177.26 2,989.50 - 14,010.50 17.59% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 69,037 4,788.49 45,275.10 39,337.38 83.77 29,615.85 57.10 %'' SCHERTZ MAGAZINE Personnel Services 133,179 10,239.43 93,655.13 95,292.41 - 37,886.59 71.55% Supplies 200 - 200.00 73.94 - 126.06 36.97% Opperations Support 200 - - - 10.81 189.19 5.41% Staff Support 2,005 - 665.79 808.06 9.73 1,187.21 40.79% Professional Services 260,500 8,010.24 219,811.96 147,634.56 225.00 112,640.44 56.76% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 455.00 - 455.00 - 145.00 75.83% TOTAL SCHERTZ MAGAZINE 406,684 1`8,704.67 314,332:88 244,263.97 245.54 162,174.49 60.12 %' ENGINEERING Personnel Services 231,566 11,970.15 94,840.20 117,489.46 - 114,076.54 50.74% Supplies 1,100 142.13 441.61 567.18 116.93 415.89 62.19% City Support Services 1,380 - - 262.80 - 1,117.20 19.04% Utility Services 1,400 72.63 450.63 523.76 - 876.24 37.41% Operations Support - - 195.00 - - - 0.00% Staff Support 8,580 - 1,064.25 936.29 240.00 7,403.71 13.71% Professional Services 43,000 - 48,504.27 11,671.25 - 31,328.75 27.14% Operating Equipment 8,000 - - 2,001.75 - 5,998.25 25.02% TOTAL ENGINEERING 295,026 12,184.91 145,495.96 133,452.49 356.93 161,216.58 45.36% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 131,043 9,983.52 90,569.93 93,618.69 - 37,424.31 71.44% Supplies 2,855 - 1,031.95 704.61 425.72 1,724.67 39.59% Staff Support 5,000 - 1,570.18 3,327.40 - 1,672.60 66.55% Professional Services - - 306.56 - - - 0.00% Rental /Leasing 3,805 - - - - 3,805.00 0.00% TOTAL GIS 142,703 9,983.52` 93,478.62 97,650.70 425.72 44,626;58 68.73% TOTAL GENERAL GOVERNMENT 6;740,711 365,512.21 4,327,643.20 4;047,394.51 38,906.50 2,654,409.99 60.62 %< PUBLIC SAFETY POLICE Personnel Services 4,842,482 363,194.71 3,321,082.85 3,439,823.37 - 1,402,658.63 71.03% Supplies 31,969 2,315.43 24,171.69 24,373.61 322.29 7,273.10 77.25% City Support Services 23,800 - 20,657.01 26,721.66 - (2,921.66) 112.28% Utility Services 135,880 11,633.03 83,121.81 85,526.47 - 50,353.53 62.94% Operations Support 2,444 94.94 2,053.97 1,424.53 - 1,019.47 58.29% Staff Support 93,355 4,224.52 25,244.74 57,781.61 6,825.87 28,747.52 69.21% City Assistance 5,829 1,499.00 751.36 5,828.15 - 0.85 99.99% Professional Services 35,498 1,960.00 6,018.91 26,312.35 2,400.00 6,785.65 80.88% Fund Charges /Transfers 3,250 - - - - 3,250.00 0.00% Maintenance Services 47,658 6,180.00 24,404.41 35,464.15 - 12,193.85 74.41% Operating Equipment 120,579 3,635.04 115,408.96 85,958.49 10,268.31 24,352.20 79.80% Capital Outlay 128,506 - 164,584.50 128,505.24 - 0.76 100.00% TOTAL POLICE 5;471,250 394,736.67!' 3,787,500.21 3,917,719.63 19,816.47 1,533,713.90 71.97°% FIRE RESCUE Personnel Services 2,706,130 205,419.59 1,913,020.85 1,930,442.54 - 775,687.46 71.34% Supplies 17,000 565.58 2,609.44 6,728.40 1,216.51 9,055.09 46.73% Utility Services 48,260 3,897.20 35,013.22 36,089.31 69.87 12,100.82 74.93% Operations Support 1,200 - 481.29 953.37 - 246.63 79.45% Staff Support 111,765 8,045.73 90,747.57 61,758.20 1,194.73 48,812.07 56.33% City Assistance 16,200 - 3,150.94 - - 16,200.00 0.00% Professional Services 15,000 - 11,430.00 13,218.00 - 1,782.00 88.12% Maintenance Services 54,264 2,534.74 15,897.63 28,612.61 - 25,651.39 52.73% Operating Equipment 70,168 194.25 34,488.37 26,767.81 9,743.92 33,656.27 52.03% Capital Outlay 12,147 - - 5,334.15 6,812.00 0.85 99.99% TOTAL FIRE RESCUE 3,052,134' 220,657.09'r 2,106,839.31 2,109,90439 119,037.03 923,192.58 69.75 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 478,959 43,065.97 301,873.00 330,057.71 - 148,901.29 68.91% Supplies 2,438 90.40 1,594.45 1,020.17 71.39 1,346.44 44.77% Utility Services 6,770 753.65 3,900.09 4,475.65 - 2,294.35 66.11% Operations Support 1,575 - 1,051.88 729.00 169.00 677.00 57.02% Staff Support 8,638 1,185.42 4,172.88 3,771.56 799.95 4,066.49 52.92% Professional Services - - - 45.59 - (45.59) 0.00% Operating Equipment 3,430 - - 429.99 - 3,000.01 12.54% TOTAL INSPECTIONS 501,810r 45,095.441 312,592.30 340,529.67 1,040.34 160,239.99 68.07% MARSHAL'S OFFICE Personnel Services 557,097 41,030.05 386,073.57 411,830.04 - 145,266.96 73.92% Supplies 4,840 457.51 825.37 1,103.67 39.87 3,696.46 23.63% Utility Services 16,000 1,021.98 10,969.44 6,869.51 - 9,130.49 42.93% Operations Support 3,500 113.00 207.46 906.51 217.56 2,375.93 32.12% Staff Support 10,550 386.42 2,602.82 3,228.70 332.40 6,988.90 33.75% City Assistance - - - - - - 0.00% Maintenance Services 16,000 875.00 6,126.00 4,031.14 - 11,968.86 25.19% Operating Equipment 8,000 - 1,322.61 7,354.47 - 645.53 91.93% Capital Outlay 35,000 - - 28,566.00 - 6,434.00 81.62% TOTAL MARSHAL'S OFFICE 650,987 43,883.96 408,127.27 463,890.04 589.83 186,507.13 71.35% TOTAL PUBLIC SAFETY 9,676,181! 704,373.16 6,615,059.09 6,832,043.73 40,48167 2,803,653.60 71.03% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 5,099.52 5,746.08 9,400.01 212.96 11,087.03 STREETS 46.44% Utility Services 29,000 2,085.46 12,792.04 Personnel Services 681,227 48,600.84 466,023.78 483,326.92 - 197,900.08 70.95% Supplies 7,200 321.01 5,111.94 4,247.96 203.71 2,748.33 61.83% Utility Services 124,000 10,286.68 80,277.41 82,718.04 590.52 40,691.44 67.18% Staff Support 9,080 248.14 4,532.70 6,310.26 310.03 2,459.71 72.91% City Assistance 500 - - - - 500.00 0.00% Professional Services 29,875 - - - - 29,875.00 0.00% Maintenance Services 140,620 21,093.59 102,305.05 101,985.75 10,535.61 28,098.64 80.02% Rental /Lease 415 414.72 - 414.72 - 0.28 99.93% Operating Equipment 42,588 - 5,444.13 43,926.34 - (1,338.34) 103.14% Capital Outlay 70,400 233.50 - 63,762.50 6,232.00 405.50 99.42% TOTAL STREETS `` 1,105,905 81,198.48< 663,695.01 786,692.49 17,871.87 301,340.64 72.75% TOTAL` PUBLIC' ENVIRONMENT 1,105,905 81,198.48` 663,695.01 786,692.49 117,871.87 301,340.64 72.75% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 499,070 29,303.52 357,380.26 342,965.26 - 156,104.74 68.72% Supplies 41,905 741.14 21,822.42 18,069.45 4,259.87 19,575.68 53.29% Utility Services 149,220 12,138.88 106,419.21 81,724.47 1,159.79 66,335.74 55.55% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 1,184.35 4,699.29 5,120.43 554.22 2,798.35 66.97% Professional Services 38,250 - 34,493.50 18,800.21 3,691.50 15,758.29 58.80% Maintenance Services 17,480 3,236.94 10,848.33 7,256.49 445.25 9,778.26 44.06% Rental /Leasing 44,000 6,423.83 30,067.25 32,159.97 9,676.20 2,163.83 95.08% Operating Equipment 1,100 - 1,838.28 1,043.45 344.25 (287.70) 126.15% TOTAL PARKS DEPARTMENT 799,748 53,028.66 567,568:54 507,139.73 20,131.08 272,477:99 65.93% SWIM POOL Supplies 20,700 5,099.52 5,746.08 9,400.01 212.96 11,087.03 46.44% Utility Services 29,000 2,085.46 12,792.04 10,464.42 - 18,535.58 36.08% Staff Support 925 - - - - 925.00 0.00% Maintenance Services 203,378 60,688.00 66,967.25 61,567.91 - 141,810.09 30.27% Rental /Lease 500 - - - - 500.00 0.00% TOTAL SWIM POOL 254,503 67,872.98' 85,505.37 81,432.34 212.96 172,857.70 32.08 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 57,195 4,107.37 37,491.96 38,220.24 - 18,974.76 66.82% Supplies 17,000 1,282.19 10,033.68 9,780.90 133.84 7,085.26 58.32% Utility Services 51,200 3,717.64 27,985.82 28,947.77 - 22,252.23 56.54% Operations Support 12,800 1,690.00 11,832.22 9,994.39 - 2,805.61 78.08% Staff Support 2,727 35.00 1,427.61 1,860.47 18.00 848.53 68.88% Professional Services 1,600 - - 528.45 - 1,071.55 33.03% TOTAL EVENT FACILITIES 142,522 10,832.20 88,771.29 89,332.22 151.84 53,037.94 62.79% SENIOR CITIZEN CENTER Supplies 7,759 1,313.27 - 4,465.92 926.39 2,366.69 69.50% Utility Services 4,240 - - 414.00 - 3,826.00 9.76% Operations Support 2,400 - - - - 2,400.00 0.00% City Assistence 25,286 2,567.58 - 12,494.40 2,625.98 10,165.62 59.80% Professional Services 11,530 500.00 - 3,966.74 791.50 6,771.76 41.27% Maintenance Services 2,400 - - 7,548.20 - (5,148.20) 314.51% TOTAL SENIOR CITIZEN CENTER 53,615 4,380.85 - 28,889.26 4,343.87 20,381.87 61.98 %` TOTAL 'PARKS '& RECREATION 1,250,388 136,114.69` 741,845.20 706,793.55 24,839.75 518,754.70 58.51% CULTURAL LIBRARY Personnel Services 678,656 43,631.18 479,381.64 474,081.49 - 204,574.51 69.86% Supplies 12,000 1,076.50 9,103.61 7,138.79 1,606.60 3,254.61 72.88% Utility Services 51,060 3,470.43 31,144.37 28,811.30 - 22,248.70 56.43% Operations Support 3,500 125.79 1,113.70 617.85 - 2,882.15 17.65% Staff Support 5,940 71.97 1,044.46 2,715.76 - 3,224.24 45.72% Professional Services 2,350 - 2,140.00 2,190.00 - 160.00 93.19% Maintenance Services 2,400 - 600.00 - - 2,400.00 0.00% Operating Equipment 80,570 17,670.15 49,439.92 53,006.63 12,191.43 15,371.94 80.92% TOTAL LIBRARY 836,476 66,046.02'- 573,967.70 568,561.82 13,798.03 254,116.15 69.62 %i TOTAL CULTURAL 836,476' 66,046.02? 573,967.70 568,561.82 13,798.03 254,116.15 69.62% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 317,626 21,453.56 188,792.18 191,036.06 - 126,589.94 60.14% Supplies 30,700 5,519.96 13,777.03 20,602.70 326.83 9,770.47 68.17% Utility Services 20,530 2,211.94 7,315.14 13,263.78 59.76 7,206.46 64.90% Operations Support 1,000 - 155.95 - - 1,000.00 0.00% Staff Support 10,450 - 4,369.34 4,572.90 - 5,877.10 43.76% City Assistance 17,550 344.35 7,682.58 6,441.38 - 11,108.62 36.70% Professional Services 21,500 - 8,752.85 19,786.78 435.00 1,278.22 94.05% Maintenance Services 23,200 497.58 3,31184 3,238.35 3070 19,930.95 14.09% Operating Equipment 11,580 - 2,135.83 1,662.44 - 9,917.56 1436% TOTAL ANIMAL SERVICES 454,136 30,027.39: 236,294.74 260,604.39 852.29 192,679.32 57.57% TOTAL HEALTH 454,136 30,027.39 236,294.74 260,604.39 85229 192,679.32 57.57% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 401,949 36,792.82 207,057.18 296,716.33 - 105,232.67 73.82% Supplies 2,000 170.03 444.03 1,548.49 138.10 313.41 84.33% City Support Services 444,823 14,196.18 193,303.40 266,360.93 2,470.69 175,991.38 60.44% Utility Services 195,372 13,346.94 123,834.48 122,311.45 4,412.42 68,648.13 64.86% Staff Support 22,275 595.95 12,825.26 20,083.07 1,170.65 1,021.28 95.42% Maintenance Services 12,500 27.25 5,101.00 7,609.58 511.90 4,378.52 64.97% Operating Equipment 373,483 23,608.44 57,658.02 197,989.95 68,432.87 107,060.18 71.33% TOTAL INFORMATION TECHNOLOGY 1,452,402 88,737.61 600,223.37 912,619.80 77,136.63 462,645.57 68.15% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 310,989 21,711.59 196,848.71 209,229.45 - 101,759.55 67.28% Supplies 1,300 - 317.14 925.01 - 374.99 71.15% Human Services 62,900 4,030.58 23,716.49 28,617.33 124.95 34,157.72 45.70% Operations Support 9,500 85.00 6,555.04 6,991.24 - 2,508.76 73.59% Staff Support 14,919 974.13 10,500.06 10,283.18 214.00 4,421.82 7036% City Assistance 10,000 - 5,792.50 2,439.14 - 7,560.86 24.39% Professional Services 4,000 1,250.00 - 1,250.00 - 2,750.00 31.25% Operating Equipment 900 - - - - 900.00 0.00% TOTAL HUMAN RESOURCES 414,508 28,051.30 243,729.94 259,735.35 338.95 154,433.70 62.74 %!' FINANCE Personnel Services 454,996 34,159.36 311,924.68 321,722.02 - 133,273.98 70.71% Supplies 2,492 143.00 1,831.74 1,995.46 - 496.54 80.07% Operations Support 1,000 - 986.50 834.00 - 166.00 83.40% Staff Support 14,805 695.00 5,322.45 5,889.99 219.00 8,696.01 41.26% Maintenance Services 8 - - - - 8.00 0.00% Operating Equipment - - 1,770.00 - - - 0.00% TOTAL FINANCE 473,301 34,997.36 321,835.37 330,441.47 219.00 142,640.53 69.86% PURCHASING & ASSET MGT Personnel Services 255,024 18,995.56 176,276.68 181,002.81 - 74,021.63 70.97% Supplies 1,200 26.17 459.22 308.26 24.99 866.75 27.77% Utility Services 600 66.39 378.03 212.63 - 387.37 35.44% Operations Support 300 - 13.19 - - 300.00 0.00% Staff Support 7,985 294.87 4,878.85 3,339.38 14.75 4,630.87 42.01% Operating Equipment 2,050 - - 1,840.63 - 209.37 89.79% TOTAL PURCHASING & ASSET MGT 267,159'` 1',9,382.99 182,005.97 186,703.71 39.74 80,415.99 69.90% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JUNE 30th.2U14 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 222.091 10.259.20 128.287.83 153.385.74 - 08.095.26 08.07% Supplies 169,841 20,681.37 120,87018 138,70323 21,917.18 9,140.58 84.62% City Support Services 3.500 - 2.380.00 2.100.00 - 1.400.00 00.00% Utility Services 4.599 340.90 2.431.33 2.902.51 1,096.49 63.11% Operations Support 400 - 142l0 - - 400.00 0�00% Staff Support 4.085 275.44 1.510.30 1.883.23 26.53 2.17544 46.75% City Assistance 180 - - - - 100.00 0�00% Maintenance Services 70.750 17.153.28 74.85815 08.501.75 3.327.71 (1.15946) 101.64% Rental/Lease 200 200.00 0.00% Operating Equipment 5.000 4.893.28 3.188.79 1.81121 03.78% Capital Outlay 10\000 -_ -_ -_ -_ 10\000l0 0l80% TOTAL FLEET SERVICE 490,646 54,716.25 335,583.08 370,835.25 25,271 23 94,539.52 80.73% oU|ummG MAINTENANCE Personnel Services 92.800 7,100.32 44.010.60 70.25471 - 22.711.28 75.57% Supplies 1.543 0.09 203.43 1241 1.32710 13.89% Utility Services 3.850 310.80 1.896.51 2.138.02 - 1.710.80 55.50% Staff Support 2,850 03.42 351f0 1,68813 15.32 1.180.55 58.07% Professional Services 10.000 - 10.642.50 7.645.00 2.100.00 255.00 9745% Maintenance Services 107.928 11.011.01 41.104.22 70.322.86 3.777.73 27.819.41 7422% Rental/Leasing 1,400 - 875.00 ' - 1.400.00 0.00% Operating Equipment 0.00% Capital Outlay 118,000 3,712.50 8,415.00 105,872.50 10.28% TOTAL BUILDING MAINTENANCE 338,529 19,184.24 97,940.63 161,945.65 14,320.46 162,262.89 52.07% TOTAL INTERNAL SERVICE 3,436,545 245,069.75 1,781,318.36 2,222,281.23 117,326.01 1,096,938.20 68.08% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET MISC & PROJECTS CITY ASSISTANCE Patient Assistance 5,000 - 5,000.00 5,000.00 - - 100.00% Transportation Assistance 22,000 - - 22,020.00 - (20.00) 100.09% Children's Advocacy Assistance 5,000 - - - - 5,000.00 0.00% Senior Citizen's Hot Meals 42,000 - 31,500.00 55,628.00 - (13,628.00) 132.45% TOTAL CITY ASSISTANCE 74,000 - 36,500.00 82,648.00 - (8,648.00) 111.69 %< COURT - RESTRICTED FUNDS Operating Equipment 6,400 - 18,185.00 840.00 1,840.00 3,720.00 41.88% TOTAL CITY ASSISTANCE 6,400 - 18,185.00 840.00 1,840.00 3,720.00 41.88 %> TOTAL MISC &PROJECTS 80,400 - 54,685 83,488 1,840 (4,928.00) 106.13% TOTAL EXPENDITURES 23,580,742 1,628,341.70 14;994,508.30 15,507,859.72 255,918.12 7,816,964.60 66.85°% REVENUE OVER(UNDER) EXPEND. 362,340 4,620,857.80 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 7,839,691 18,571.91 7,437,583.67 8,010,382.92 - (170,691.92) 102.18% 000 - 411200 Advalorem Tax - Delinquent 50,000 2,523.35 34,798.59 22,533.92 - 27,466.08 45.07% 000 - 411300 Advalorem Tax - P &I 50,000 2,824.82 34,802.58 34,375.74 - 15,624.26 68.75% 000 - 411500 Sales Tax Revenue -Gen Fund 6,870,981 683,441.27 4,780,593.01 5,351,126.18 - 1,519,854.82 77.88% 000 - 411600 Bingo Tax - - - 30.62 - (30.62) 0.00% 000 - 411700 Mixed Beverage Tax 28,000.00 - 22,203.51 29,648.97 - (1,648.97) 105.89% TOTAL Taxes 14,838,672 707,361.35 12,309,981.36 13,448,098.35 - 1,390,573.65 90.63% Franchises 000 - 421200 Center Point/Entex Energy 72,100 3,762.99 49,842.50 64,532.46 - 7,567.54 89.50% 000 - 421220 City Public Service 460,837 39,569.73 300,860.31 403,873.46 - 56,963.54 87.64% 000 - 421240 Guadalupe Valley Elec Co -op 400,000 27,212.54 276,537.44 203,856.10 - 196,143.90 50.96% 000 - 421250 New Braunfels Utilities 61,800 4,478.41 36,305.51 44,173.45 - 17,626.55 71.48% 000 - 421300 Time Warner -State Franchise 300,000 23,510.71 235,284.76 211,007.03 - 88,992.97 70.34% 000 - 421460 AT &T Franchise Fee 260,868 20,298.22 183,921.10 186,377.59 - 74,490.41 71.45% 000 - 421480 Other Telecom Franchise 115,000 25.52 8,777.80 50,831.02 - 64,168.98 44.20% 000 - 421500 Solid Waste Franchise Fee 108,000 5,636.09 81,559.18 93,633.95 - 14,366.05 86.70% TOTAL Franchises 1,778,605 124,494.21 1,173,088.60` 1,258,285.06 - 520,319.94 70.75% Permits 000 - 431100 Home Occupation Permit 490 105.00 420.00 525.00 - (35.00) 107.14% 000 - 431205 Building Permit - Residential 404,420 30,230.00 338,601.00 285,327.00 - 119,093.00 70.55% 000 - 431210 Building Permit - Commercial 170,000 73,576.00 350,496.00 228,249.00 - (58,249.00) 134.26% 000 - 431215 Building Permit - General 283,296 16,291.00 103,764.00 283,836.00 - (540.00) 100.19% 000 - 431300 Mobile Home Permit 450 100.00 450.00 625.00 - (175.00) 138.89% 000 - 431400 Signs Permit 4,582 420.00 3,992.00 5,886.00 - (1,304.00) 128.46% 000 - 431500 Food Establishmnt Permit 45,000 - 14,145.00 27,190.00 - 17,810.00 60.42% 000 - 431600 Garage Sale Permit 12,000 1,236.00 8,710.00 9,359.00 - 2,641.00 77.99% 000 - 431700 Plumbing Permit 117,324 9,755.05 94,478.10 74,718.80 - 42,605.20 63.69% 000 - 431750 Electrical Permit 50,000 4,340.00 45,940.00 40,144.50 - 9,855.50 80.29% 000 - 431800 Mechanical Permit 50,000 4,240.00 40,540.00 38,340.00 - 11,660.00 76.68% 000 - 431900 Solicitor /Peddler Permit 1,000 80.00 1,560.00 580.00 - 420.00 58.00% 000 - 431950 Animal /Pet Permit 2,000 - 1,325.00 1,515.00 - 485.00 75.75% 000 - 432000 Cert. of Occupancy Prmt 6,500 600.00 4,050.00 5,050.00 - 1,450.00 77.69% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 45,000 2,255.00 36,035.00 27,890.00 - 17,110.00 61.98% 000 - 432300 Grading /Clearing Permit 3,000 - 1,474.50 3,732.52 - (732.52) 124.42% 000 - 435000 Fire Permit 10,000 1,063.00 14,226.00 19,302.00 - (9,302.00) 193.02% TOTAL Permits 1,205,062 144,291.05 1,060,206.60 1,052,269.82 - 152,792.18 87.32% Licenses 000 - 441000 Alcohol Beverage License 5,500 117.50 4,709.50 5,185.00 - 315.00 94.27% 000 - 441300 Mobile Home License 200 - 160.00 160.00 - 40.00 80.00% 000 - 442000 Contractors License 60,200 4,575.00 52,735.00 58,610.00 - 1,590.00 97.36% 000 - 444000 Pet License 4,200 465.00 3,441.00 2,740.00 - 1,460.00 65.24% TOTAL Licenses 70,100 5,157.50 61,045.50 66,695.00 - 3,405.00 95.14 %' Fees 000 - 451000 Municipal Court Fines 1,345,300 99,913.87 1,085,809.40 966,069.78 - 379,230.22 71.81% 000 - 451100 Arrest Fee 56,734 4,515.59 49,130.62 39,348.32 - 17,385.68 69.36% 000 - 451110 Expunction Fee 120 - 30.00 - - 120.00 0.00% 000 - 451200 Warrant Fees 148,500 10,060.25 127,661.48 105,400.09 - 43,099.91 70.98% 000 - 451210 Court - Claims & Judgements - 933.40 (887.00) (773.10) - 773.10 0.00% 000 - 451320 Civil Justice Fee -Court 97 - 76.21 18.40 - 78.60 18.97% 000 - 451321 Civil Justice Fee -State 885 - 686.26 165.94 - 719.06 18.75% 000 - 451340 Judicial Fee - City 8,562 595.83 6,566.70 5,259.23 - 3,302.77 61.43% 000 - 451400 Traffic Fine Costs TTL 32,246 2,268.26 25,062.11 19,490.79 - 12,755.21 60.44% 000 - 451500 Teen Court Admin Fee 200 - 220.00 40.00 - 160.00 20.00% 000 - 451510 Juvenile Case Mgmt Fee 64,384 4,970.36 54,772.96 43,836.88 - 20,547.12 68.09% 000 - 451520 Truancy Fee - 871.88 - 3,802.34 - (3,802.34) 0.00% 000 - 451600 Technology Fund Fee 59,500 3,964.91 43,919.07 35,317.48 - 24,182.52 59.36% 000 - 451700 Security Fee 42,655 2,973.69 32,939.28 26,488.09 - 16,166.91 62.10% 000 - 451800 Time Payment Fee - City 6,238 361.73 4,634.53 5,258.18 - 979.82 84.29% 000 - 451850 State Fines 10% Service Fee 92,278 - 66,671.32 52,265.58 - 40,012.42 56.64% 000 - 451900 DPS Payment - Local 13,981 806.66 10,027.88 8,266.69 - 5,714.31 59.13% 000 - 452000 Child Safety Fee 22,076 932.53 17,072.29 15,631.30 - 6,444.70 70.81% 000 - 452050 Indigent Defense Fee 31,076 - 21,586.48 5,099.02 - 25,976.98 16.41% 000 - 452100 Platting Fees 52,500 6,500.00 33,811.00 40,250.00 - 12,250.00 76.67% 000 - 452200 Site Plan Fee 25,500 - 18,000.00 15,500.00 - 10,000.00 60.78% 000 - 452300 Plan Check Fee 361,264 60,589.50 383,187.00 395,972.50 - (34,708.50) 109.61% 000 - 452310 Miscellaneous Review Fee 1,200 1,200.00 600.00 3,000.00 - (1,800.00) 250.00% 000 - 452320 Tree Mitigation Admin Fee 10,000 - - 40,192.50 - (30,192.50) 401.93% 000 - 452400 BOA/Zoning Fees 3,500 - 2,500.00 4,000.00 - (500.00) 114.29% 000 - 452500 Food Handler Class 26,400 3,120.00 16,574.00 12,450.00 - 13,950.00 47.16% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 25,800 - 20,000.00 11,450.00 - 14,350.00 44.38% 000 - 452710 Zoning Ltr & Dev Rights 1,050 - 900.00 450.00 - 600.00 42.86% 000 - 453100 Reinspection Fees 36,700 5,200.00 24,350.00 25,370.98 - 11,329.02 69.13% 000 - 453110 Swim Pool Inspection Fee 1,500 1,320.00 1,575.00 2,275.00 - (775.00) 151.67% 000 - 453200 Lot Abatement 7,000 - 7,453.04 6,181.42 - 818.58 88.31% 000 - 453211 Admin Fee - Inspections 5,200 1,192.65 3,300.00 6,992.65 - (1,792.65) 134.47% 000 - 453310 Misc Inspection Fee - - - 2,950.00 - (2,950.00) 0.00% 000 - 453710 Foster Care 1,400 100.00 1,000.00 700.00 - 700.00 50.00% 000 - 454200 Pool Gate Admission Fee 22,400 9,456.50 6,861.75 9,594.50 - 12,805.50 42.83% 000 - 454300 Seasonal Pool Pass Fee 5,100 4,873.15 4,450.00 5,293.15 - (193.15) 103.79% 000 - 456110 Senior Center Memberships 5,625 360.00 - 1,650.32 - 3,974.68 29.34% 000 - 456120 Senior Center Meal Fee 30,785 2,250.00 - 5,880.00 - 24,905.00 19.10% 000 - 456500 Haz Mat Fees 12,000 - 1,250.00 810.35 - 11,189.65 6.75% 000 - 456600 Fire Re- inspection Fee 750 100.00 950.00 700.00 - 50.00 93.33% 000 - 458100 Sale of Merchandise - - - 210.00 - (210.00) 0.00% 000 - 458110 Sale of Merchandise- GovDeal 18,000 748.14 12,812.95 11,339.01 - 6,660.99 62.99% 000 - 458300 Sale of Property /Auction 2,000 - 2,756.70 16.82 - 1,983.18 0.84% 000 - 458400 Civic Center Rental Fees 140,916 10,365.00 125,202.25 125,788.00 - 15,128.00 89.26% 000 - 458401 Capital Recovery Fee -Civic Cntr 5,000 300.00 4,200.00 5,440.00 - (440.00) 108.80% 000 - 458450 North Center Rental Fees 20,600 1,925.00 14,680.00 16,947.00 - 3,653.00 82.27% 000 - 458460 Senior Center Rental 18,000 1,300.00 - 5,839.00 - 12,161.00 32.44% 000 - 458500 Community Center Rental Fees 27,026 2,370.00 21,952.26 17,830.07 - 9,195.93 65.97% 000 - 458550 Pavilion Rental Fees 18,500 1,220.00 14,293.50 13,032.50 (50.00) 5,517.50 70.18% 000 - 458560 Chamber of Comm rent 7,800 - 5,850.00 3,919.50 - 3,880.50 50.25% 000 - 458570 Non - Resident SYSA League - - 7,845.00 - - - 0.00% 000 - 458650 NonResident User Fee -BVYA 5,000 - 8,630.00 9,140.00 - (4,140.00) 182.80% 000 - 458660 BVYA Utility Reimbursement 8,400 - 2,952.98 6,571.32 - 1,828.68 78.23% 000 - 458670 SYSA Utility Reimbursement - - 2,999.36 - - - 0.00% 000 - 458675 Lions Futbol Utility Reimbursement 14,000 - 9,288.00 2,700.00 - 11,300.00 19.29% 000 - 458680 Tournament Fees - Soccer - - 600.00 - - - 0.00% 000 - 458700 Vehicle Impoundment 6,000 - 4,380.00 5,490.00 - 510.00 91.50% 000 - 459200 NSF Check Fee 650 - 490.00 195.00 - 455.00 30.00% 000 - 459300 Notary Fee 300 - 180.00 204.00 - 96.00 68.00% 000 - 459400 Maps, Copies, UDC, & Misc F 100 5.00 75.00 89.70 - 10.30 89.70% 000 - 459600 Animal Adoption Fee 17,500 815.00 12,790.00 8,360.00 - 9,140.00 47.77% 000 - 459700 Pet Impoundment Fee 14,000 1,620.00 11,010.55 10,032.01 - 3,967.99 71.66% 000 - 459800 Police Reports Fee 6,000 402.00 4,959.30 3,905.30 - 2,094.70 65.09% TOTAL Fees 2,890,298 250,500.90 ` 2,340,689.23! 2,1'69,697.61 (50.00) 720,650.39 75.07 %' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 30,000 2,674.07 22,519.32 23,193.56 - 6,806.44 77.31% TOTAL Fines 30,000 2;674.07 - 22,519.32 23,193.56 - 6,806.44 77.31% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,072 - 15,808.32 7,025.92 - 14,046.08 33.34% 000 - 473200 City of Seguin - Fire Contract 30,000 2,435.90 30,197.34 21,923.10 - 8,076.90 73.08% 000 - 473300 Guad Co - Library 208,343 17,361.91 138,895.28 156,257.19 - 52,085.81 75.00% 000 - 473400 Randolph AFB - Animal Cntrl 1,500 - 1,400.00 1,100.00 - 400.00 73.33% 000 - 474200 Library Services - Cibolo 25,000 - - - - 25,000.00 0.00% 000 - 474210 Library Services -Selma 26,560 - 26,560.00 28,220.00 - (1,660.00) 106.25% 000 - 474400 Dispatch Service - Cibolo 133,305 - 99,978.75 66,652.50 - 66,652.50 50.00% 000 - 474600 School Crossing Guard - Bexar 40,000 3,355.37 27,671.43 27,544.18 - 12,455.82 68.86% 000 - 474610 School Cross Guard - Guadalupe 40,000 - 27,509.04 18,366.32 - 21,633.68 45.92% 000 - 474620 School Crossing Guard -Coma) - - 1,388.00 1,456.55 - (1,456.55) 0.00% 000 - 474700 School Officer Funding 160,000 - 90,000.00 117,600.00 - 42,400.00 73.50% 000 - 474800 CPS CIED Funding - - 198,247.71 - - - 0.00% TOTAL Inter - Jurisdictional 685,780 23;15118 657,655.87< 446,145.76 - 239,634.24 65.06 %' Fund Transfers 000 - 480000 Indirect Costs - EMS 137,038 11,419.83 65,880.00 102,778.47 - 34,259.53 75.00% 000 - 480100 Indirect Costs - Hotel /Motel 145,385 12,115.42 118,137.78 109,038.78 - 36,346.22 75.00% 000 - 482100 Transfer From Reserves -Ct Tech 10,278 - - - - 10,278.00 0.00% 000 - 482150 Transfer From Court Security 42,569 - - - 42,569.00 0.00% 000 - 485000 Interfund Charge- Drainage 51,800 4,316.67 37,280.97 38,850.03 - 12,949.97 75.00% 000 - 486000 Interfund Chrges -Admin W &S 1,152,350 96,029.17 795,722.22 864,262.53 - 288,087.47 75.00% 000 - 486202 Transfer In -W &S 136,000 - - - - 136,000.00 0.00% 000 - 486203 Transfer In -EMS 1,356 - - - - 1,356.00 0.00% 000 - 486314 Transfer In Hotel /Motel 33,000 - - - - 33,000.00 0.00% 000 - 487000 Interfund Charges -Fleet 130,344 10,861.99 84,570.75 97,757.91 - 32,586.09 75.00% 000 - 488000 Interfund Charges -413 136,245 11,353.75 182,512.53 102,183.75 - 34,061.25 75.00% TOTAL Fund Transfers 1,976,365 i 146'096.83 1,284,104.25 1,314,871.47 - 661,493.53 66.53% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 500 - 350.86 306.80 - 193.20 61.36% 000 - 491200 Investment Income 45,000 2,140.60 33,017.34 20,214.77 - 24,785.23 44.92% 000 - 491800 Gain /Loss - - (17,662.14) (17,122.84) - 17,122.84 0.00% 000 - 491900 Unrealized Gain /Loss (26,000) (2,255.75) (11,599.70) 7,983.00 - (33,983.00) 0.00% 000 - 493120 Donations - Public Library 5,000 6,508.50 7,500.00 7,250.90 - (2,250.90) 145.02% 000 - 493130 Donations - Writing the Next Chap. - - 325.00 - - - 0.00% 000 - 493400 Donation - Animal Control 4,000 15.00 1,716.05 837.97 - 3,162.03 20.95% 000 - 493401 Donations -A/C Microchip 2,000 110.00 1,180.00 945.00 - 1,055.00 47.25% 000 - 493402 Donations - Spay &Neuter 14,000 548.00 9,789.88 6,986.00 - 7,014.00 49.90% 000 - 493403 Donations - Animal Adoption Trailer - - - 2,000.00 - (2,000.00) 0.00% 000 - 493465 Donations - Senior Center - 1,637.39 - 21,516.01 - (21,516.01) 0.00% 000 - 493502 Donations -PD - - 300.00 2,400.00 - (2,400.00) 0.00% 000 - 493503 Donations - Fire Rescue - - 250.00 - - - 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed - - - 3,931.29 - (3,931.29) 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund - - - 4,678.85 - (4,678.85) 0.00% 000 - 495040 Friends of N. Schertz Park - - 885.00 - - - 0.00% 000 - 495060 Grant- Wellmed /Senior Center 3,500 - - - - 3,500.00 0.00% 000 - 495100 Mobile Stage Rental Fees 2,000 - 1,550.00 1,550.00 - 450.00 77.50% 000 - 497000 Misc Income -Gen Fund 20,000 119.91 21,689.06 23,455.37 - (3,455.37) 117.28% 000 - 497005 Schertz Magazine Advertising 220,000 18,350.00 169,033.00 170,175.00 - 49,825.00 77.35% 000 - 497007 Misc Income - Schertz Artz - - 10.00 - - - 0.00% 000 - 497100 Misc Income - Police 12,000 280.00 8,040.76 2,305.40 - 9,694.60 19.21% 000 - 497150 Misc Income -Fire Department - - 292.37 - - - 0.00% 000 - 497200 Misc Income - Library 4,000 422.50 3,134.00 3,462.89 - 537.11 86.57% 000 - 497210 Misc Income - Library Copier 13,000 1,363.85 10,435.12 10,500.20 - 2,499.80 80.77% 000 - 497300 Misc Income - Animal Control - - 190.00 - - - 0.00% 000 - 497400 Misc Income - Streets Dept. 18,000 4,243.54 16,178.68 25,568.70 - (7,568.70) 142.05% 000 - 497500 Misc Income -TML Insurance 25,000 - 17,116.19 4,842.50 - 20,157.50 19.37% 000 - 497550 Misc Income -TML Reimbursemt 15,000 - 17,338.84 19,664.05 - (4,664.05) 131.09% 000 - 497600 Misc Income - Vending Mach. 2,200 - 1,782.44 1,507.40 - 692.60 68.52% 000 - 498000 Reimbursmnt -Gen Fund 60,000 414.20 16,279.10 10,242.98 - 49,757.02 17.07% 000 - 498100 Reimbursmnt Fire - Training - - - 3,206.67 - (3,206.67) 0.00% 000 - 498105 Reimburmnt Police - DEA 9,000 - 4,650.74 3,420.36 - 5,579.64 38.00% 000 - 498107 Reimburmnt Police - Event - - - 3,500.00 - (3,500.00) 0.00% 000 - 498110 Reimbursmnt Fire - Emg. Acti -O 20,000 - 5,739.32 4,131.62 - 15,868.38 20.66% TOTAL Miscellaneous 468,200 33,897.74 ` 319,511.91 349,460.89 - 118,739.11 74.64 %? TOTAL?REVEN,UES 23,943,082 1,437,626.83 ` 19,228,802.64 20,128,717.52 (50.00) 3,814,414.48 84.07 %' GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 661,386.70 Cash in Investments LOGIC Investment - General Fund 6,953,031.71 LOGIC Investment -Equip Replacement 73,631.01 LOGIC Investment -Veh Replacement 211,205.42 LOGIC Investment -Air Condi Replacment 17,159.23 CAPITAL ONE Investment - General Fund 1,346,590.87 Total Cash in Bank & Investments $ 9,409,586.78 - OCT DEC JAN FEB MAR APR MAY JUN JUL AUG 2013-14 363,589 538,568 3,641,091 2,726,044 585,058 72,116 16,554 48,791 18,572 2010-11 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 82009-10 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 29,955 5,346 3,535 Sales Tax - General Fund $200,000 $1 $1 $1 $1 $1 80,000 - - - - - - - - - - - - - - - - - - - - - 60,000 40,000 20,000 00,000 ______ _ - _ _ _ - 80,000 60,000 - - - - - - = - 40,000 20,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP ........ ----------- - 2013 -14 - - - - - -- --------- - - - - -- 133,486 -- - - - - -- --- - - - - -- 115,592 - - - - - -- - - - -- - - - -- - -- - - -- - 176,520 _ -- ----------------------- - -- -- - - - - -- E32012-13 --------------------- - - - - -- 101,440 ____ - -- - 94,054 96,303 - - - - -- --------------------------------------------------------------------- 123,044 - - - - -- -- - _ - -- -------------------------------------- 2011 -12 96,392 76,414 77,398 103,230 2010 -11 83,433 62,692 67,561 95,887 0 2009 -10 77,354 61,468 63,276 80,716 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS FUND CURRENT CURRENT PRIOR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fund Transfers 149,657.00 - - - - 149,657.00 0.00% Wilenchik Walk for Life 25,000.00 - 20,846.16 23,464.72 - 1,535.28 117.32% Hal Baldwin Scholarship 13,800.00 - 19,538.88 23,612.00 - (9,812.00) 0.00% Miscellaneous 11,500.00 1.24 2,002.37 7,033.11 - 4,466.89 97.68% TOTAL REVENUES 199,957.00 1.24 42,387.41 54,109 83 - 145,847.17 30.65 %` EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 5,150.00 - - - - 5,150.00 0.00% TOTAL GENERAL GOVERNMENT 5,150.00 - - - - 5,150.00 0.00% CULTURAL Festival of Angels 15,000.00 - 16,017.55 10,283.94 - 4,716.06 68.56% Employee Appreciation Event 12,000.00 - 5,885.00 11,510.21 - 489.79 95.92% National Night Out 150.00 - - - - 150.00 0.00% Wilenchik Walk for Life 25,000.00 - 20,846.16 4,762.00 18,702.72 1,535.28 93.86% Schertz Sweetheart 37,000.00 365.05 26,949.30 28,554.64 500.00 7,945.36 78.53% Jazzfest 25,000.00 448.00 15,538.41 14,504.83 - 10,495.17 58.02% Hal Baldwin Scholarship 13,800.00 - 11,739.72 8,730.20 - 5,069.80 63.26% Other Events 66,857.00 3,014.77 2,337.13 52,877.26 781.25 13,198.49 80.26% TOTAL CULTURAL` 194,807.00 3,827.82 99,313.27' 131,223.08 19,983.97 43,599.95 77.62% TOTAL' EXPENDITURES 199,957.00 3,827.82 99,313.275 131,223.08 19,983.97 48,749.95 75.62% REVENUE OVER(UNDER) EXPEND - (77,113:25); SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 6,578.52 Cash in Investments MBIA Special Events 16,780.07 Total Cash in Bank & Investments $ 23,358.59 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3- 2 0 1 4 110-PEG FUND CURRENT CURRENT PRIOR CURRENT Y-T-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL Y-T-D ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Franchises 100,950.00 69,409.45 39,385.72 - 61,564.28 39.02% Fund Transfers 260,550.00 - - 260,550.00 0.00% TOTAL REVENUES 361,500.00 69,409.45 39,385.72 - 322,114.28 10.90% EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental 361,500.00 9,511.47 29,693.43 51,893.44 6,811.55 302,795.01 16.24% TOTAL GENERAL GOVERNMENT 361,500.00 9,51;1.47 29,693.43 51,893.44 6,811:55 302,795.01 16.24% TOTAL EXPENDITURES 361,500.00 9,511.47 29,693.43 51,893.44 6,811.55 302,795.01 16.24% REVENUE OVER(UNDER) EXPEND (1 2,507:72)' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 110 -PEG FUND CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Franchises 000 - 421350 Time Warner - PEG Fee 66,950 - 43,50525 39,385.72 - 27,564.28 58.83% 000 - 421465 AT &T PEG Fee 34,000 - 25,904.20 - - 34,000.00 0.00% TOTAL Franchises 100,950` - 69,409.45 39,385.72 61,564.28 39.02% Fund Transfers 000 - 481000 Transfer In - Reserves 260,550 - - - - 260,550.00 0.00% TOTAL Fund Transfers 260,550 - - - - 260,550.00 0.00% TOTAL REVENUES 361,500' - 69,409.45 39,385.72 322,114.28 10.90% PEG FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Cash Balance $ 421, 789.80 Total Cash in Bank & Investments $ 421,789.80 CITY O F S C H E RTZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JUNE 30th.2014 2V13'2014 2V2-VVATER&SEWER CURRENT CURRENT PRIOR YEAR Y�-} Y�-D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Franchises 185.710 - 157,51714 163J17.82 - 31.88218 83.65% Permits 12,00000 513.81 20,923.65 50,903}0 - (44.803.86) 474.20% Fees 16.092.603 1,440.606.04 11.277.055.09 12.104.957.25 - 3.927.725.75 75�58% Fund Transfers 2.317.282 10.353.07 89,473.50 93.237.03 - 2.824.044.97 320% Miscellaneous 165,440 871.09 271,561.05 224,626.88 - (59,186.88 135.78% TOTALREVENUES 19,383,115 1,452,351.51 11,817,131.03 12,703,442.84 - 6,679,672.16 6554% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 440,455 29.689/41 282.521.92 293.158.09 153.296.31 65.66% Supplies 4,600 25587 2,093.43 2,890.42 65419 1,05539 77.00% Human Services 183 122.00 116.95 00.05 63.81'& City Support Services 1.000 - - - - 1.000.00 0.00% Operations Support 122.375 14.566.60 79.28811 87.325.08 43.72 35.00019 71.38% Staff Support 7.100 32143 2,33318 2�06.75 154.85 4,438.40 37A9% Professional Services 24.000 2.758.83 10.18211 18.34521 5.054.78 7044% Maintenance Services 13,440 - 8.120.00 0.540.00 - 0.900.00 48.00% Operating Equipment --__2,547 ---____-_ ----_1,452.44 ----____-_ -------_--' ---_-2,547.00 0D0% TOTAL BUSINESS OFFICE 621,700 47,593.24 392,124.19 410,883.11 852.76 209,964.13 66.23% Personnel Services 1.202.040 87.620.32 759.310.91 813.154.99 - 388.885.01 07.05% Supplies 185.150 8.351.05 122.057.04 107.899.52 10.524.07 76.025.81 60.73% Human Services 1.000 - 141l0 389.95 - 010.05 39.00% City Support Services 91.300 45.088.02 55.876.99 35.023.01 00.98% Utility Services 3.342.400 289.752.99 2.244.158.83 2.191,420.03 833.00 1.150.14571 05�59% Operations Support 9,250 2,048.08 2.148.40 7,100.60 23.24% Staff Support 28.700 1.235.65 14.835.05 19.009.09 2.020.95 8.009.86 71�01% City Assistance 1.900 398.00 70825 1.191.75 37.28% Professional Services 249.113 8.547.02 153.988.70 129.998.90 - 119.114.04 5218% Fund 3,336700 13527734 2.028.781.88 2.347.858.85 988.80115 70.37% Maintenance Services 5.924.250 506.204.72 3.970.034.76 4.300.010.09 115.34421 1,422.887.70 75.98% Other Costs 35,000 - 29,541.85 27,650.20 - 7,349.80 79.00% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ************************ * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 202 -WATER & SEWER FINANCIAL SUMMARY CURRENT BUDGET CURRENT PERIOD PRIOR YEAR Y -T -D ACTUAL Y -T -D ACTUAL Y -T -D ENCUMBR BUDGET BALANCE 75% OF BUDGET Debt Service 1,458,925 - 200,231.02 203,371.92 - 1,255,553.08 1194% Rental- Leasing 6,070 - 3,570.91 2,472.62 - 3,597.38 40.74% Operating Equipment 11,164 - 1,602.76 15,345.80 399.98 (4,581.78) 141.04% Capital Outlay 544,316 261.00 84,450.00 431,787.10 - 112,528.90 7933% TOTAL PUBLIC WORKS :` 16,438,338 1,038,310.09 9,661;260.01 10,735,172.36 129,123.47 5,574,042.17 66.09 %` MISC & PROJECTS PROJECTS Professional Services - - 46,160.80 - - - 0.00% Fund Charges /Transfers 2,185,086 - - - - 2,185,086.00 0.00% Maintenance Services - - 640,726.05 - - - 0.00% TOTAL PROJECTS 2,185,086 686,886.85 - - 2,185,086.00 0.00% TOTAL!MISC &'PROJECTS 2,185,086 - 686;886.85 - - 2,1!85,086.00 0.00% TOTAL EXPENDITURES 19,245,124 1,085,903 10,740,271 11,146,055 129,976 7,969,092 58.59% " REVENUE OVER(UNDER)EXPENSES " 137,991 1,557,387.37 202-WATER & SEWER REVENUES CITY O F S C H E R T Z REVENUE REPORT (UNAUD|TED) AS OF: JUNE 3Oth.2014 2V1 3'2V14 CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 75% OF BUDGET PERIOD Y'T'DACTUAL ACTUAL ENCUMBR BALANCE BUDGET Franchises 000'421490 Tower Leasing 1�95,710 �_ __-157,517]4 163,717.8C2 -_ 31,9e92.18 83.65% TOTAL Franchises 195,710 - 157,517.14 163,717.82 - 31,992.18 83.65% Permits 000432400 Development Permit 12,0X00 513.91 20,923.65 56,903.8K6 -_ 4742DY6 TOTAL Permits ������g --���- ����--- % Fees 000-455200 Garbage Collection Fee 3.600.000 322.220.04 2.686.51540 2.957.709.74 - 042.290�26 8216% 000455000 Fire Line Fees 22.000 - 20.035.00 23.985.00 - (1.985.00) 109.02% 000455700 Recycle Fee Revenue 202.983 22.347.48 195.019.05 196.74321 - 60.23070 74.81% 000455800 VV&S Line CnnotructnReimbumomnt 30.000 1.182.00 16.055.63 18.367.52 - 11.63248 61.23% 000457100 Sale ofWater 8.043.200 685.350.87 5.581.840.92 5.514.243.49 - 2.528.056.51 08.56% 000457110 Edwards Water Lease 127.000 73.441.97 96.942.09 310.930.58 - (183.930.58) 244.83% 000457120 Water Transfer Charge-Selma 42.000 - 29.292.00 28.32827 - 13.67173 0745% 000457130 Water Transfer Charge-U.C. 5.000 - 3.979.44 12.351.39 - (7.351.38) 247.03% 000457140 Water Transfer Charge-Converse 30.000 - 27.188.82 22.97115 - 7.028.85 76.57% 000457200 Sale ofMeters 90.000 4.802.00 42.712.08 40.62046 - 49.378.54 4513% 008457400 Sewer Charges 3.058.000 311.525.89 2/435.815.51 2.885.241.68 - 772.758.32 78.87% 000457500 Water Penalties 180.000 19.453.59 137.777.90 151.00476 - 28.995.24 83.89% 008458000 Sales of General Fixed Assets - - 2.000.00 (2^000.00) - 2.000.00 0.00% 000458110 Sale of Merchandise - Gov Deals - - - 180.00 - (180.00) 0.00% 008458400 Building vanto| Fee ' - - 2.000.00 - (2.000.00) 0.00% 000458200 NSF Check Fee-Watmr&Gavvmr 2,500 275I0 ----_1,880.00 ---_-2,280>I0 -----_--_ --___220.00 91.20% TOTAL 1,6J092,683 1/440,6 1,277,655.69 12,164,95725 3,927,72515 Fund Transfers 000481800 Tmnsfer|n- R000mo 2.185.086 - - - - 2.185.08&00 0�0896 000480102 Transfer In-Equipment Reserves 197.500 - - - - 197.500�00 8.00Y6 000480103 Transfer In-Vehicle R000moo 290.380 - - - - 290.388�00 0.08Y6 000480204 |ntedhdChng'DrainageBill 124.316 10.350.67 89.473.50 03.237.03 ' 31.078.87 75.0096 000480411 Transfer In-Capital Recovery —_-120,0X00 ---____-_ ----____-_ ----____-_ --------- ---120V000�00 0I0% TOTAL Fund Transfers 2,917,282 10,359.67 89,47150 93,23703 - 2,824,04497 120% 202 -WATER & SEWER REVENUES Miscellaneous CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 490000 Misc Charges 700 - 5,862.78 391.50 - 308.50 55.93% 000 - 491000 Interest Earned 2,000 71.22 1,215.71 1,003.09 - 996.91 50.15% 000 - 491200 Investment Income 12,000 250.21 5,807.90 3,674.47 - 8,325.53 30.62% 000 - 496050 SSLG - SAWS Reservation - - 134,500.00 134,500.00 - (134,500.00) 0.00% 000 - 497000 Misc Income -W &S 40,000 549.66 47,316.25 5,420.82 - 34,579.18 13.55% 000 - 498110 Reimbursement -SSLGC 110,740 - 76,858.41 79,637.00 - 31,103.00 71.91% TOTAL Miscellaneous 165,440 871.09 271,561.05 224,626.88 - (59,186.88) 135.78 %' TOTAL REVENUES 19,383,115 1,452,351.51 11,817,131.03 12,703,442.84 6,679,67216 65.54% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $1,507,260.80 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 Lone Star Investment - Water /SSLGC SAWS Schertz Bank & Trust - Certificate of Deposit 638,614.58 295,214.99 177,497.08 256,410.71 675,087.67 1,064,372.78 $ 3,107,197.81 Total Cash in Bank & Investments $4,614,458.61 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 5,583,983 468,388.91 3,519,573.84 4,009,097.12 - 1,574,885.88 71.80% Inter - Jurisdictional 1,556,828 32,585.86 1,112,645.65 1,198,310.38 - 358,517.70 76.97% Miscellaneous 239,500 4,367.71 86,344.73 90,920.00 - 148,580.00 37.96% TOTAL REVENUES 7,380,311 505,342.48 4,718,564.22 5,298,327.50 - 2,081,983.58 71.79% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,863,992 236,349.91 1,982,839.51 2,097,447.64 - 766,544.36 73.24% Supplies 355,484 41,537.05 245,458.32 241,052.01 23,463.77 90,968.22 74.41% Human Services 800 20.00 193.00 343.00 - 457.00 42.88% City Support Services 32,500 - 15,571.98 17,826.32 - 14,673.68 54.85% Utility Services 120,944 11,882.45 91,711.90 93,596.21 544.04 26,803.75 77.84% Operations Support 62,305 3,228.26 42,965.41 45,411.33 1,277.85 15,615.82 74.94% Staff Support 81,300 17,129.76 48,867.15 58,377.71 8,700.94 14,221.35 82.51% City Assistance 14,400 6,460.65 7,711.44 10,522.30 116.25 3,761.45 73.88% Professional Services 132,516 6,760.84 117,009.22 109,282.26 2,269.69 20,964.05 84.18% Fund Charges /Transfers 2,663,429 62,536.87 732,588.20 1,373,364.12 - 1,290,064.88 51.56% Maintenance Services 57,820 2,857.16 24,936.47 14,239.05 6,107.70 37,473.25 35.19% Debt Service 152,772 - 64,766.50 3,531.58 - 149,240.42 2.31% Rental- Leasing 82,000 - - - - 82,000.00 0.00% Operating Equipment 193,600 13,123.00 68,356.85 66,958.31 35,665.29 90,976.40 53.01% Capital Outlay 80,000 - - - - 80,000.00 0.00% TOTAL PUBLIC SAFETY 6,893,862 401,885.95 3,442,975.951 4,131,951.84 78,145.53 2,683,764.63 61.07 %` TOTAL EXPENDITURES 6,893,862 401,885.95 3,442,975.95 < 4,131,951.84' 78,145.53 ` 2,683,764.63'- 61.07% ** REVENUE OVER(UNDER) EXPENSES 486,449 ' 1,166,375.66 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,419,583 466,375.50 3,451,944.86 3,914,871.46 - 1,504,711.54 72.24% 000 - 456110 Subscription Program Fees 40,000 220.00 18,285.00 23,005.00 - 16,995.00 57.51% 000 - 456120 EMT Class - Fees 104,400 (10.00) 46,425.00 57,096.00 - 47,304.00 54.69% 000 - 456130 Immunization Fees - - 20.00 - - - 0.00% 000 - 456140 Billing Fees - Alamo Heights 20,000 1,803.41 2,233.98 14,074.66 - 5,925.34 70.37% 000 - 458110 Sales of Merchandise - GovDeal - - 645.00 - - - 0.00% 000 - 459200 NSF Check Fee - - 20.00 50.00 - (50.00) 0.00% TOTAL Fees 5,583,983 468,388.91 3,519,573.84 4,009,097.12 - 1,574,885.88 71.80% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 23,843.88 214,869.92 238,438.80 - 47,687.20 83.33% 000 - 474300 Cibolo Support 253,757 - 171,622.65 190,317.60 - 63,439.20 75.00% 000 - 475100 Comal Co ESD #6 90,694 7,590.70 64,743.90 68,316.30 - 22,377.78 75.33% 000 - 475200 Live Oak Support 170,178 - 123,890.97 130,782.60 - 39,395.16 76.85% 000 - 475300 Universal City Support 240,149 - 174,830.55 181,511.60 - 58,637.20 75.58% 000 - 475400 Selma Support 71,798 - 52,269.90 55,848.80 - 15,949.60 77.79% 000 - 475500 Schertz Support 420,915 - 296,872.26 315,686.16 - 105,228.72 75.00% 000 - 475600 Santa Clara Support 9,396 - 6,840.36 7,047.00 - 2,349.00 75.00% 000 - 475800 Marion Support 13,815 1,151.28 6,705.14 10,361.52 - 3,453.84 75.00% TOTAL Inter - Jurisdictional 1,556;828 32,585.86 1,112,645.65 1,198,310.38 - 358;517.70 76.97 %< CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned - - - 12.26 - (12.26) 0.00% 000 - 491200 Investment Income - - 344.08 - - - 0.00% 000 - 493203 Donations -EMS 2,000 - 801.00 30.00 - 1,970.00 1.50% 000 - 493204 Donations - Dilworth Fund 3,500 - - - - 3,500.00 0.00% 000 - 493205 Donations- Golf Tournament 4,000 120.00 14,162.00 15,125.00 - (11,125.00) 378.13% 000 - 497000 Misc Income 130,000 2,820.74 66,198.45 72,259.62 - 57,740.38 55.58% 000 - 497100 Recovery of Bad Debt 100,000 1,426.97 4,839.20 3,493.12 - 96,506.88 2.75% TOTAL Miscellaneous 239,500 4,367.71 86,344.73 90,920.00 - 148;580.00 37.96% TOTAL REVENUES 7,380;311 505,342.48 4,718,564.22 5,298,32750 - 2,081 >,983.58 71.79% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 117,912.08 Total Cash in Bank & Investments $ 117,912.08 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 « * * * ** 2 0 1 3- 2 0 14 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY 451,350 29,865.12 252,091.72 Permits - 200.00 - 2,740.00 - (2,740.00) 0.00% Fees 1,041,000 89,059.35 768,905.19 767,843.75 - 273,156.25 115.73% Miscellaneous 1,700 74.16 2,562.10 820.23 - 879.77 52.24% TOTAL REVENUES 1,042,700 89,333.51 771,467.29 771,403.98 - 271,296.02 115.99% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 451,350 29,865.12 252,091.72 259,323.06 - 192,026.94 57.45% Supplies 8,300 686.33 2,637.11 4,195.93 156.08 3,947.99 52.43% Human Services 325 - - 61.00 - 264.00 18.77% City Support Services 25,000 - 3,233.63 2,166.61 - 22,833.39 8.67% Utility Services 29,500 2,007.29 18,280.77 15,438.11 1,534.79 12,527.10 57.54% Operations Support 2,460 - - - - 2,460.00 0.00% Staff Support 7,625 161.83 2,355.70 3,307.40 99.75 4,217.85 44.68% City Assistance 840 - 75.00 - - 840.00 0.00% Professional Services 23,500 - 10,898.06 2,360.01 348.00 20,791.99 11.52% Fund Charges/Transfers 197,304 16,375.34 141,251.94 147,378.06 - 49,925.94 74.70% Maintenance Services 22,000 - 2,241.76 1,733.68 2,161.71 18,104.61 17.71% Other costs 200 100.00 100.00 200.00 - - 100.00% Debt Service 18,574 - 1,345.35 1,036.58 - 17,537.42 5.58% Rental /Leasing 500 - - - - 500.00 0.00% Operating Equipment 11,049 - 11,318.92 11,303.80 - (254.80) 102.31% Capital Outlay 25,083 - 142,480.60 24,322.00 - 761.00 96.97% TOTAL DRAINAGE 823,610 49,195.91 588,310.56 472,826.24 4,300.33 346,483.43 57.93 % ) PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - - - 1,000.00 0.00% Professional Services 41,200 7,600.00 - 21,840.00 8,400.00 10,960.00 73.40% Maintenance Services 169,998 - - 16,800.00 - 153,198.00 9.88% TOTAL PROJECTS 215,398 7,600.00 - 38,640 00 8,400.00' 168,358.00 21.84 %d TOTAL EXPENDITURES 1,039,008 56,795.91 588,310.56 511,466.24 12,700.33! 514,841.43 50.45 %o'i " REVENUE OVER(UNDER) EXPEND 3,692 < 259,937.74 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit - 200.00 - 2,740.00 - (2,740.00) 0.00% TOTAL Permits - 200.00 - 2,740.00 - (2,740.00) 0.00% Fees 000 - 457500 Drainage Penalties 5,000 622.23 5,941.14 6,367.48 - (1,367.48) 127.35% 000 - 457600 Drainage Fee 1,036,000 88,437.12 762,964.05 761,476.27 - 274,523.73 73.50% TOTAL Fees 1,041,000? 89,05935 '? 768,905.19 767,843.75 - 273,156.25 73.76% Miscellaneous 000 - 491000 Interest Earned 100 - 63.89 101.88 - (1.88) 101.88% 000 - 491200 Investment Interest 600 74.16 704.35 652.35 - (52.35) 108.73% 000 - 497000 Misc Income - Drainage 1,000 - 1,793.86 66.00 - 934.00 6.60% TOTAL' Miscellaneous ` 1,700% 74.16 2,562.10 820.23 - 879.77 48.25 %' TOTAL REVENUES 1,042,700- 89,333.51 771,46729 771,403.98 - 271,296.02` 73.98% DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking 117,912.08 Cash in Investments Lone Star Investment - Drainage Maint Fund 605,503.76 Total Cash in Bank & Investments $ 723,415.84 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3 - 2 0 14 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * *•. 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Iy: w: ak, Lei .� 1► i► Ie1:�'1 Taxes 485,000 36,312.76 264,459.19 290,626.52 - 194,373.48 59.92% Fund Transfers 173,810 - - - - 173,810 0.00% Miscellaneous 550 23.40 404.19 269.41 - 280.59 48.98% TOTAL REVENUES 659,360 < 36,336.16 264,863.38 290,895.93 - 368,464:07 44.12 % =, EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 - - - - 2,000.00 0.00% City Support Services 66,787 - 71,759.56 46,221.00 - 20,566.00 69.21% Operations Support 47,841 1,050.00 15,786.41 18,008.66 1,386.00 28,446.34 40.54% Professional Services 5,625 - 11,685.00 2,800.00 - 2,825.00 49.78% Fund Charges/Transfers 435,107 35,615.42 118,137.78 132,538.78 - 302,568.22 30.46% Maintenance Services 26,632 - - 23,462.00 - 3,170.00 88.10% Operating Equipment 55,368 - 39,578.87 7,710.59 1,712.60 45,944.81 17.02% Capital Outlay 20,000 - - - - 20,000.00 0.00% TOTAL NONDEPARTMENTAL 659,360 < 36,665.42 256,947.62 230,741.03 3,098.60 425,520.37 35.46 %' TOTAL EXPENDITURES s 659,360 36,665.42 256,947.62 230,741.03 3,098.60 425,520.37 35.46 %' REVENUE OVER(UNDER) +EXPENDITURE - 60,154.90 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000 - 411800 Hotel Occupancy Tax 485,000 36,312.76 264,459.19 290,626.52 - 194,373.48 59.92% TOTAL Taxes 485,000 36,312.76 264,459.19 290,626.52 - 194,373.48 59.92% Fund Transfers 000 - 481000 Transfer From Reserve 173,810 - - - - 173,810.00 0.00% TOTAL Fund Transfers 173,810 - - - - 173,810.00 0:00% Miscellaneous 000 - 491000 Interest Earned 50 - 40.87 56.91 - (6.91) 113.82% 000 - 491200 Investment Interest 500 23.40 363.32 212.50 - 287.50 42.50% TOTAL Miscellaneous 550 23.40 404.19 269.41 280.59' 48..98 %' TOTAL REVENUES 659,360 36,336.16 264 863.38 290,895.93 - 368,464.07 44.12 %' HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 231,289.30 Cash in Investments IVIBIA - Hotel Tax 299,115.07 Total Cash in Bank & Investments $ 530,404.37 HOTEL OCCUPANCY TAX $70,000 $60,000 $50,000 - -- - _ - -- -- - /------O000 - - $40,000 --------- - - - - - - - - - - - $30,000 $20,000 $10,000 $ OCT NOV DEC JAN FEB MAR APR MAY JUN JUL AUG SEP -- - - - -- 2013-14 - 40,023 -- 40,709 33,342 29,778 - 36,680 - 56,699 - 1 48,081 49,579 -- _ - - 2012 -13 35,851 39,439 32,392 322120 31,531 49,811 39,900 39,692 54,395 61,999 51,840 34,297 2011 -12 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 46,551 29,807 2010 -11 27,689 25,112 _ - - - 23,231 - - -- 19,619 _ 22,667 - - 36,728 -- - - -- 28,215 - -- -- - - - - -- -------- 34,157 -- - 45,854 53,433 42,181 - - -- 32,294 - - - -- -8-2009-101 23,625 22,026 20,768 19,924 23,169 33,638 1 26,531 1 32,368 36,676 46,069 36,697 26,655 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Parkland Dedication Fees 150,000 16,200.00 161,000.00 52,150.00 - 97,850.00 34.77% Miscellaneous 300 0.04 175.38 11.48 - 288.52 3.83% TOTAL REVENUES 150,300 16,200.04 161,175.38 52,161.48 - 98,138.52 34.70 %'' EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - - 545.00 - - - 0.00% Fund Charges /Transfers - - 138,884.00 - - - 0.00% Maintenance Services- Landscape 12,840 - - - - 12,840.00 0.00% Operating Equipment - - 4,386.30 - - - 0.00% Capital Outlay 27,160 - - - - 27,160.00 0.00% TOTAL PARKLAND DEDICATION 40,000 - 143,815.30 - - 40,000.00 0.00 %' TOTAL EXPENDITURES 40,000 - 143,815.30 ? - - 40,000.00 0.00°%< REVENUE OVER(UNDER) EXPEND 110,300 52,161.48 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 150,000 16,200.00 161,000.00 52,150.00 - 97,850.00 34.77% TOTAL Fees 150,000 16,200.00 161,000.00 52,150.00 97,850:00 34.77% Miscellaneous 000 - 491000 Interest Earned - - 30.90 10.12 - (10.12) 0.00% 000 - 491200 Investment Interest 300 0.04 144.48 1.36 - 298.64 0.45% TOTAL Miscellaneous 300 0.04 175.38 11.48 288:52 3.83% TOTAL REVENUES 150,300 16,200.04 161,175.38 52,161.48 ` - 98,138.52 34.70% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $57,611.26 Cash in Investments IVIBIA Investment-Park Fund 1,354.55 Total Cash in Bank & Investments $58,965.81 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Tree Mitigation Fees 35,000 - 600.00 227,757.50 - (192,757.50) 650.74% Miscellaneous 104,525 7.54 1,806.01 14728 - 104,377.72 0.14% TOTAL REVENUES ! 139,525 7.54 2,406.01 227,904.78 - (88,379.7$) 163.34°/%' EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 139,525 - 57,730.00 39,95630 24,300.00 75,268.70 46.05% Capital Outlay - - 23,226.06 - - - 0.00% TOTAL TREE MITIGATION 139,525 80,956.06 39,956.30 24,300.00 75,268.70 46.05 %' TOTAL EXPENDITURES 139,525 80,956.06 39,956.30 24,300.00 75,268.70 46.05 %> REVENUE OVER(UNDER) EXPEND 187,948.48 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 t********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4*********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458900 Tree Mitigation 35,000 - 600.00 227,757.50 - (192,757.50) 650.74% TOTAL Fees 35,000 - 600`.00 227,757.50 (192,757.50) 650.74 % Miscellaneous 000 - 491000 Interest Earned 50 - 16.94 7871 - (28.71) 157.42% 000 - 491200 Investment Interest 150 7.54 99.07 68.57 - 81.43 45.71% 000 - 497000 Misc Income - - 1,690.00 - - - 0.00% 000 - 499000 Transfer In Reserves 104,325 - - - - 104,325.00 0.00% TOTAL Miscellaneous 104,525 7.54 1,806.01 147.28 - 104,377.72 0.14 % TOTAL REVENUES 139,525 7.54 2,406.01 227,904.78 - (88,379.78) 163.34 %I TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $248,291.06 Cash in Investments MBIA Investment-Tree Mitigation 97,316.20 Total Cash in Bank & Investments $345,607.26 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3 - 2 0 1 4 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 880,200 68,949.00 642,546.00 626,409.00 - 253,791.00 71.17% Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 20,300 452.16 25,495.19 4,169.81 - 16,130.19 20.54% TOTAL REVENUES 2,326,109 69,401.16 668,041.19; 630,578.81 - 1,695,530.19 27.11% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 5,000 - - - - 5,000.00 0.00% Operations Support 109 - - - - 109.00 0.00% Professional Services 446,000 - 4,047.50 2,000.00 - 444,000.00 0.45% Maintenance Services 1,000 - - - - 1,000.00 0.00% TOTAL NON DEPARTMENTAL 452,109 - 4' 047.50> 2,000500 - 450,109.00 0.44% MISC & PROJECTS Water Projects 1,750,000 - 9,747.78 - 186,732.71 1,563,267.29 10.67% Schaefer Road Water Improvements - - - - - - 0.00% TOTAL MISC & PROJECTS 1,750000 - 9,747.78 - 186,732.71 1,563,267529 10.67% TOTAL EXPENDITURES 2,202,109 - 13,795.28= 2,000.00 186,732.71 2,013,376.29 8.57% REVENUE OVER(UNDER) EXPENDITURES `' 124,000 628,579 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3- 2 0 1 4********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455900 Capital Recovery - Water 880,200 68,949.00 642,546.00 626,409.00 - 253,791.00 71.17% TOTAL Fees 880,200 68,949.00 642,546.00 626,409.00 - 253,791.00 71.17 %i Fund Transfers 000 - 481000 Transfer from Reserves 1,425,609 - - - - 1,425,609.00 0.00% TOTAL Fund Transfers 1,425,609 - - 1,425,609.00 0.00 % ; Miscellaneous 000 - 491000 Interest Earned 300 - 20,587.30 192.44 - 107.56 64.15% 000 - 491200 Investment Income 45,000 452.16 41,664.26 3,977.37 - 41,022.63 8.84% 000 - 491800 Gain /Loss - - (20,299.30) - - - 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One (25,000) - (16,457.07) - - (25,000.00) 0.00% TOTAL Miscellaneous 20,300 452.16 25,495.19 4,169.81 -' 16,130.19 20.54 %i TOTAL REVENUES 2,326,109 69,401.16 668,041.19 630,578.81 - 1,695,530.19 27.11 % CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 975,299.29 Cash in Investments Lone Star Investment - Capital Recovery Water 3,691,720.60 Total Cash in Bank & Investments $4,667,019.89 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3 - 2 0 1 4 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 569,760 50,431.68 400,861.44 438,209.90 - 131,550.10 76.91% Fund Transfers - - - - - - 0.00% Miscellaneous - (749.85) - 10,326.54 - (10,326.54) 0.00% TOTAL REVENUES 569,760 49,681.83 400,861.44 448,536.44 - 121,223.56 78.72 %' EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 4,000 357.55 5,247.80 3,21473 - 785.27 80.37% Fund Charges/Transfers 120,000 - - - - 120,000.00 0.00% TOTAL NON DEPARTMENTAL 124,000 357.55 5,247.80: 3,214.73 - 120,785.27 2.59 %' MISC & PROJECTS Sewer Projects - - 121,826.30 6,042.30 - (6,042.30) 0.00% TOTAL MISC & PROJECTS - - 121 826.30 6,042.30 - (6,042.30) 0.00 %': TOTAL EXPENDITURES 124,000 357.55 127,074.10! 9,257.03 - 114,742.97 7.47 %I REVENUE OVER(UNDER) EXPENDITURES 445,760 439,279 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 2 0 1 3- 2 0 1 4********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 455910 Capital Recovery -Waste Wtr 500,400 39,631.68 327,061.44 342,143.90 - 158,256.10 68.37% 000 - 455913 Cap Recovery -North Sewer Tr 69,360 10,800.00 73,800.00 96,066.00 - (26,706.00) 138.50% TOTAL Fees 569,760 50,431.68 400,861.44 438,209.90 131,550.10 76.91% Miscellaneous 000 - 491000 Interest Earned - - - 104.59 - (104.59) 0.00% 000 - 491200 Investment Income - 2,274.00 - 24,172.07 - (24,172.07) 0.00% 000 - 491800 Gain /Loss - - - (40,015.93) - 40,015.93 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (3,023.85) - 26,065.81 - (26,065.81) 0.00% TOTAL Miscellaneous - (749.85) - 10,326.54 - (10,326.54) 0.00 %` TOTAL REVENUES 569,760 49,681.83 400,861.44 448,536.44 - 121,223.56 78.72 % CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 654,841.95 Cash in Investments Lone Star Investment-Capital Recovery Sewer 1,451,167.17 Capital One-investment 1,725,853.44. Total Cash in Bank & Investments $ 3,831,862.56 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *� 505 -TAX I &S CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 5,204,493 15,490.92 5,020,470.22 5,260,291.76 - (55,798.76) 101.07% Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 391,213 137.76 367,334.30 346,278.83 - 44,934.17 88.51% TOTAL REVENUES 5,596,775 15,628.68 5,387,804.52 i 5,606,570.59 - (9,795.59) 100.18 %> EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 - 550.00 1,150.00 - 41,200.00 2.72% Debt Service 5,554,425 - 3,890,041.02 4,321,283.86 - 1,233,141.14 77.80% TOTAL GENERAL GOVERNMENT 5,596,775 - 3,890,591.02 4,322,433.86 1,274,341.14 77.23% TOTAL EXPENDITURES 5,596,775 - 3,890,591.02 4,322,433.86 - 1,274,341.14 77.23 %' "REVENUE OVER(UNDER);EXPEND - 1,284,136.73 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 75% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,204,493 15,490.92 5,020,470.22 5,260,291.76 - (55,798.76) 101.07% TOTAL Taxes 5,204,493 15,490.92 5,020,470.22 5,260,291.76 - (55,798.76) 101.07% Fund Transfers 000 - 486000 Transfer From Reserves 1,069 - - - - 1,069.00 0.00% TOTAL Fund Transfers 1,069 - - - 1,069.00 0.00% Miscellaneous 000 - 491000 Interest Earned 75 - 54.47 48.77 - 26.23 65.03% 000 - 491200 Investment Earnings 25,000 137.76 23,273.58 1,16131 - 23,838.69 4.65% 000 - 495015 Contribution from SED 366,138 - 344,006.25 345,068.75 - 21,069.25 94.25% TOTAL Miscellaneous 391,213 137.76 367,334.30 346,278:83 44,934.17 88.51% TOTAL REVENUES 5,596,775 15,628.68 5,387,804.52 5,606,570.59 - (9,795.59) 100.18% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 505 -TAX I& S k******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 75% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101- 541500 Paying Agent 2,350 - - 1,150.00 - 1,200.00 48.94% 101 - 541502 Cost of Bond Issuance 40,000 - 550.00 - - 40,000.00 0.00% TOTAL Professional Services 42,350 - 550.00 1,150.00 - 41,200.00 2.72 %' Debt Service 101- 555612 Bond -GO Refunding 2010 - Principa 260,000 - 250,000.00 260,000.00 - - 100.00% 101 - 555612.1 Bond -GO Refunding 2010 Interest 70,750 - 40,125.00 37,000.00 - 33,750.00 52.30% 101 - 555622 Schertz C O SR2003- Principal - - 210,000.00 - - - 0.00% 101 - 555622.1 Schertz C O SR2003- Interest - - 3,832.50 - - - 0.00% 101 - 555624 Comm Proj Bond -SR04- Principal - - 325,000.00 - - - 0.00% 101 - 555624.1 Comm Proj Bond SR04- Interest - - 6,906.25 - - - 0.00% 101 - 555626 LS &D SR2006- Principal 200,000 - 200,000.00 200,000.00 - - 100.00% 101 - 555626.1 LS &D SR2006- Interest 634,982 - 323,490.64 319,490.64 - 315,491.36 50.31% 101 - 555628 CO Bond 2007 - Principal 112,834 - - - - 112,834.00 0.00% 101 - 555628.1 CO Bond 2007- Interest 14,106 - 9,249.07 7,052.93 - 7,053.07 50.00% 101 - 555629 GO Bond 2007 - Principal 245,000 - 235,000.00 245,000.00 - - 100.00% 101 - 555629.1 GO Bond 2007 - Interest 179,792 - 97,109.43 92,001.36 - 87,790.64 51.17% 101 - 555630 GO Bond SR2008 Principal 430,000 - 385,000.00 430,000.00 - - 100.00% 101 - 555630.1 GO Bond SR2008 Interest 332,259 - 178,519.25 170,569.00 - 161,690.00 51.34% 101 - 555631 GO Bond SR2009 Principal 590,000 - 510,000.00 590,000.00 - - 100.00% 101 - 555631.1 BO Bond SR2009 Interest 314,201 - 167,162.50 160,787.50 - 153,413.50 51.17% 101 - 555633 GO SR2011 Principal 210,000 - 200,000.00 210,000.00 - - 100.00% 101 - 555633.1 GO SR2011 Interest 358,038 - 186,118.75 181,118.75 - 176,919.25 50.59% 101 - 555634 GO SR2011A Refund Principal 615,000 - 70,000.00 615,000.00 - - 100.00% 101 - 555634.1 GO SR2011A Refund Interest 145,916 - 76,948.25 76,132.75 - 69,78125 52.18% 101 - 555635 GO SR2012 Principal 285,000 - 295,000.00 285,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 219,284 - 120,579.38 113,20438 - 106,079.62 51.62% 101 - 555636 Tax Note - SR2013 - Principal 160,000 - - 160,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 11,223 - - 7,079.88 - 4,14112 63.08% 101 - 555637 Tax Note - SR 2013A - Principal 155,000 - - 155,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 11,040 - - 6,846.67 - 4,19333 62.02% TOTAL Debt Service? 5,554,425 - 3,890,041.02 4,321,283.86 - 1,233,141.14 77.80% TOTAL EXPENDITURES 5,596,775 ` - 3,890,591.02 4,322,43186 - 1,274,341.14 77.23 %' TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 2,757.76 Cash in Investments IVIBIA Investment -Tax I&S 1,798,577.59 Total Cash in Bank & Investments $1,801,335.35 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BUDGET 66.67% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,440,944 315,540.73 3,692,603.74 2,697,309.67 - 743,634.33 78.39% Miscellaneous 10,175 2,463.40 4,484.72 6,343.67 - 3,831.33 62.35% TOTAL REVENUES 3,451;119 318,004.13 3,697,088.46 2,703,653.34 - 747,465.66 78.34 %' EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 326,237 25,155.96 209,040.71 226,220.12 - 100,016.88 69.34% Supplies 1,250 30.49 377.30 420.80 43.33 785.87 37.13% Human Services 200 - - - - 200.00 0.00% City Support Services 16,545 - 1,212.05 1,174.29 - 15,370.71 7.10% Utility Services 2,795 236.06 834.62 1,309.91 37.99 1,447.10 48.23% Operations Support 148,200 1,946.19 68,955.15 67,861.26 25,751.70 54,587.04 63.17% Staff Support 18,050 - 3,618.38 3,240.86 666.42 14,142.72 21.65% City Assistance 1,325,000 - 587.95 500,078.59 1,066.61 823,854.80 37.82% Professional Services 102,500 - 101,066.56 16,132.41 - 86,367.59 15.74% Fund Charges /Transfers 503,605 11,455.58 528,935.28 448,168.97 - 55,436.03 88.99% Debt Service 427,672 - 275,526.75 270,270.00 - 157,402.00 63.20% Operating Equipment 2,500 - 362.23 38.99 - 2,461.01 1.56% TOTAL ECONO DEVELOPMENT 2,874,554 38,824.28 1,190,516.98 1,534,916.20 27,566.05 1,312,071.75 54.36% MISC & PROJECTS PROJECTS 200,000 - - - - 200,000.00 0.00% TOTAL MISC& PROJECTS 200,000 - - - 200,000.00 0.00% TOTAL EXPENDITURES 3,074 554 38,824.28 1,190,516.98 1,534,916.20 27,566.05 1,512,071.75 50.82% " REVENUE OVER(UNDER) EXPEND 376,565 1,168,737.14 620 -SED CORPORATION REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JUNE 30th, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4 * * * * * * * * * * * * * * * * * * * * * * * ** CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE 66.67% OF BUDGET Taxes 000 - 411500 Sales Tax Revenue (46) 3,440,944 315,540.73 3,692,603.74 2,697,309.67 - 743,634.33 78.39% TOTAL Taxes 3,440,944 315,540.73 3,692,603.74 2,697,309.67 - 743,634.33 78.39 %i Miscellaneous 000 - 491000 Interest Earned 175 - 86.07 227.78 - (52.78) 130.16% 000 - 491200 Investment Earnings 10,000 2,463.40 4,398.65 6,115.89 - 3,884.11 61.16% TOTAL Miscellaneous 10,175 2,463`.40 4,484.72 6,34167 - 3,831 62.35 %! TOTAL REVENUES 3,451,119 318,00413 3,697,088.46 2,703,65134 - 747,465.66 78.34% SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JUNE 30th, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 381,837.07 Cash in Investments MBIA Investment - Economic Development Corp 5,215,579.63 Schertz Bank & Trust - Certificate of Deposit 1,044,185.44 Total Cash in Bank & Investments $ 6,641,602.14 4B SALES TAX C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JUNE 30th, 2014 C T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JUNE, 30th, 2014 INVESTMENT POOLS Beginning Deposits/ Interest Ending Ending Par Value Maturity Weighted OPERATIONS -BANK CASH Book Value Yiel Purchases Withdrawals Earns Book Value Mkt Value Date Avva Mat. Schertz Bank & Trust - Pooled Cash 5,832,857.38 0.0500 4,689,652.80 3,495,702.61 253.40 7,027,060.97 7,027,060.97 7,027,060.97 N/A Schertz Bank & Trust - PEG Fund 431,301.27 0.0000 - 9,511.47 - 421,789.80 421,789.80 421,789.80 N/A TOTAL OPERATIONS 56,264,158.65 - :4,689;.652.80 3,505,214.08 253.40" 7,448,850.677 7 „448,850.77 ;::7,448.,850.77 - LOGIC General Fund 6,952,410.83 0.1087 - - 620.88 6,953,031.71 6,953,031.71 6,953,031.71 N/A 53 Days G /F- Equipment Replacement 73,624.41 0.1087 - - 6.60 73,631.01 73,631.01 73,631.01 N/A 53 Days G /F- Vehicle Replacement 211,186.57 0.1087 - - 18.85 211,205.42 211,205.42 211,205.42 N/A 53 Days G/F -Air Conditioner Replacement 171,513.92 0.1087 - - 15.31 171,529.23 171,529.23 171,529.23 N/A 53 Days SR2009 Bond- Street Projects(II) 1,033,203.88 0.1087 - - 92.29 1,033,296.17 1,033,296.17 1,033,296.17 N/A 53 Days TOTAL SLOGIC 8,441;939.61 - - 753.93 8,442,693.54 $,442,693.54 ;;8,442,693.54 LONESTAR Capital Recovery - Sewer 1,450,989.43 0.1500 - - 177.74 1,451,167.17 1,451,167.17 1,451,167.17 N/A 61 Days Capital Recovery - Water 3,691,268.44 0.1500 - - 452.16 3,691,720.60 3,691,720.60 3,691,720.60 N/A 61 Days Drainage Fund 605,429.60 0.1500 - - 74.16 605,503.76 605,503.76 605,503.76 N/A 61 Days Facilities Master Plan 95,087.23 0.1500 - - 11.65 95,098.88 95,098.88 95,098.88 N/A 61 Days GO SR2011 Animal Shelter 132,594.42 0.1500 - 96,710.18 15.86 35,900.10 35,900.10 35,900.10 N/A 61 Days GO SR2011 Athletic Fields 1,525,227.89 0.1500 - 647,983.87 184.26 877,428.28 877,428.28 877,428.28 N/A 61 Days GO SR2011 Soccer Fields 576,191.68 0.1500 - - 70.58 576,262.26 576,262.26 576,262.26 N/A 61 Days GO SR2011 Swimming Pool 6,014,394.95 0.1500 - 10,945.81 736.69 6,004,185.83 6,004,185.83 6,004,185.83 N/A 61 Days GO SR2012 Downtown Improvements 1,002,812.53 0.1500 - - 122.84 1,002,935.37 1,002,935.37 1,002,935.37 N/A 61 Days Sewer /CCMA Project 2,057,742.74 0.1500 - - 252.06 2,057,994.80 2,057,994.80 2,057,994.80 N/A 61 Days W /S- Customer Deposits 295,178.83 0.1500 - - 36.16 295,214.99 295,214.99 295,214.99 N/A 61 Days W /S- Equipment Repl /Cap.Imp 177,475.34 0.1500 - - 21.74 177,497.08 177,497.08 177,497.08 N/A 61 Days Water &Sewer 638,536.36 0.1500 - - 78.22 638,614.58 638,614.58 638,614.58 N/A 61 Days W /S- Vehicle Replacement 256,379.30 0.1500 - - 31.41 256,410.71 256,410.71 256,410.71 N/A 61 Days Water /SSLG - SAWS 675,004.99 0.1500 - - 82.68 675,087.67 675,087.67 675,087.67 N/A 61 Days TOTAL`LONESTAR. ` 19,194;313.73 _ - 7551,639.86 2,348.21'. 18,441,022.08 18,441;022.08 18,441,022.08 - TEXAS CLASS Tax I &S 1,760,044.67 0.1000 38,395.16 - 137.76 1,798,577.59 1,798,577.59 1,798,577.59 N/A 52 Days Police Forfeiture 338,881.88 0.1000 - - 26.44 338,908.32 338,908.32 338,908.32 N/A 52 Days Park Fund 1,354.51 0.1000 - - 0.04 1,354.55 1,354.55 1,354.55 N/A 52 Days Economic Development Corporation 5,215,171.94 0.1000 - - 407.69 5,215,579.63 5,215,579.63 5,215,579.63 N/A 52 Days Library Board 44,840.47 0.1000 - - 3.56 44,844.03 44,844.03 44,844.03 N/A 52 Days Tree Mitigation 97,308.66 0.1000 - - 7.54 97,316.20 97,316.20 97,316.20 N/A 52 Days Tax Note 2013 Fire Truck 4,928.37 0.1000 - - 0.34 4,928.71 4,928.71 4,928.71 N/A 52 Days Hotel Tax 299,091.67 0.1000 - - 23.40 299,115.07 299,115.07 299,115.07 N/A 52 Days Special Events Fund 16,778.83 0.1000 - - 1.24 16,780.07 16,780.07 16,780.07 N/A 52 Days Citywide Projects SR2007 844,068.78 0.1000 - 32,746.00 65.65 811,388.43 811,388.43 811,388.43 N/A 52 Days Tax Note 2013 A P25 24,205.65 0.1000 - - 1.84 24,207.49 24,207.49 24,207.49 N/A 52 Days TOTAL: TEXAS CLASS +.8,646,:675.43 38,395.16 32;:746.00 675.50' 8.:653,000;.09 8,653;:000..09 '8,653,000.09 - _ cI:TY OF S cH' E R T MPORT rop, No2dTT4.: morim jum a= ti,,, 2014 ' Seganninq & q�.� Interest �y Ending :4: $` y. 9 4rg par Maturity Capital one General Erma 3. 1'x929 -ya 1.,3$3,488.55 1.3200. ikaR i,L.9i PA...:. YAIng 279..33 5,696.41 1,358,905.67. ... 1,346,590.87 1,323,326.92 N/A 577 Days Capital One Capital Recovery Sewer 1.,736,217.36 1,.4500 - 357:55 10,222,82:. 1,746,082-63 1,725,853.44 ,694,131.51 N/A 589 Oats TOTAL CAJIXTAL 009 3,084,765.:.95 - 636.90 15,919-23 1,104,988.30 3,072,444.31 3,017,468. 43 SB &T -Water &Senses 1,064,372,78 Ca,4006 >- :- 1,064,372.78 1,066,41404 1,064,37278 TAM 1/7/2015: 365 Days Schert4.. Economic Developtient Corp. 1,342,129.73 0,6000 2.,065.71 1,04.4,185,44 1,044,494;40 1,044,185.44 12/10/2014 180 Days TOTAL C,Ya.a 2,206,5021,51 2,055.71 2,108,558.22 2,116,968.45 2,108,558.22 TOTAL POPIT&O1a10 0:24 ;19,9513.27: 48,199,113.00. a 49 169,919,24•, $ 48,111,543..13 103. Days �u _w. e t'",iz9 kFur E'. •" �ELi�i� i�€' ild 1 f °' „v'X'. Finance 17.iF +.'.Y, t �. Assistant F`d'naric- DI- r"L"tor _ - _. 4„„.y -1 nciral 'Iina:jysa r owl TOTAL TEXAS CLASS 180 City Portfolio By Investment Type TOTAT_ ('- D TOTAL LONESTAR 38% TOTAL LOGIC 180 ❑ Special RevenUE Funds, $14,471,013.14 ❑ Debt Service $1,798,57' City Portfolio By Use M Designated Funds, $1,276,248.74 m Projects, $13,169,577.79 0 Operations, $17,453,501.97 MONTHLY YIELDS 2.50 2.00 1.50 1.00 0.50 0.00 OCT -13 NOV -13 DEC -13 JAN -14 FEB -14 MAR -14 APR -14 MAY -14 JUN -14 JUL -14 AUG -14 SEP -14 ®l Month T -Bill 0.0300 0.0500 0.0100 0.0300 0.0400 0.0300 0.0200 0.0400 03 Month T -Bill 0.0400 0.0600 0.0700 0.0200 0.0500 0.0500 0.0300 0.0400 06 Month T -Bill 0.0800 0.1100 0.1000 0.0600 0.0800 0.0700 0.0500 0.0600 OSchertz Portfolio 0.2879 0.2857 0.2394 0.2315 0.2227 0.2324 0.2254 0.2303 0.2438 ®Schertz Bank &Trust 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 0.0500 OCD 365 Days 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 _____ - -- BCD 180 Days 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 0.4000 - 0.6000 ------------------ OLOGIC -- 0.1183 ------ 0.1085 __ -_ 0.0965 0.0884 _ _ -_ _____ 0.0824 _ 0.0874 - -- 0.0829 - -- - - 0.0989 - - - -- - - - -- 0.1087 - -- ------ --- - - - - -- - - - - -- -_ DLoneStar ------ 0.1500 _ 0.1500 0.1600 - -- - 0.1400 - - 0.1200 - _ 0.1300 0.1400 - - 0.1400 _- -------- - ------------------ - 0.1500 OMBIA 0.0900 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 0.1000 ®Capital One 2.0347 1.9734 1.5376 1.5357 1.5356 1.5359 1.4012 1.4000 1.3944 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 6/30/2014 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 29,141.51 29,141.51 29,141.51 19.00 0.07 Total Cash & Equivalents 29,141.51 29,141.51 29,141.51 19.00 0.07° Fixed Income Projected Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 534.00 200,000.00 230,779.00 213,294.00 9,750.00 4.22 Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield 220,000.00 Fidelity Prime Mmkt Port Fd #690 220,574.20 1,650.00 58,326.92 58,326.92 58,326.92 38.00 0.07 Total Cash & Equivalents 1,125.00 0.75 58,326.92 58,326.92 58,326.92 38.00 0.07° Fixed Income 1.34 US Treasury Note 5/31/2016 701.00 350,000.00 364,567.38 358,900.50 6,125.00 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 534.00 100,000.00 116,185.00 106,647.00 4,875.00 4.20 0.63 Federal Natl Mtg Assn 1/30/2017 945.00 100,000.00 102,366.80 101,277.00 1,250.00 1.22 Total Assets ? Federal Home Ln Mtg Corp Reference Nts 11/25/2014 148.00 200,000.00 200,609.40 200,522.00 1,500.00 0.75 US Treasury Note 3/15/2017 989.00 100,000.00 99,835.94 100,004.00 750.00 0.75 US Treasury Note 11/30/2015 518.00 60,000.00 61,936.72 60,978.60 825.00 1.33 US Treasury Note 5/31/2016 701.00 325,000.00 337,135.74 333,264.75 5,687.00 1.69 US Treasury Note 8/31/2016 793.00 275,000.00 277,401.37 277,879.25 2,750.00 0.99 US Treasury Note 9/15/2014 77.00 105,000.00 105,107.78 105,043.05 262.00 0.25 Total Fixed Income 1,265,000.00 1,300,578.75 1,285, 615. 65 17,899.00 1.380 Total Assets ` 576.71 1,323,326.92 1,358,905.67- 1,343,942.57 17,937.00 1.32% Capital Recovery Assets Projected Annual Current Cash & Equivalents Due Maturity Shares Cost Mrk Value Income Yield Fidelity Prime Mmkt Port Fd #690 29,141.51 29,141.51 29,141.51 19.00 0.07 Total Cash & Equivalents 29,141.51 29,141.51 29,141.51 19.00 0.07° Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 534.00 200,000.00 230,779.00 213,294.00 9,750.00 4.22 Federal Natl Mtg Assn 12/21/2015 539.00 100,000.00 99,989.10 100,131.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 148.00 220,000.00 220,078.68 220,574.20 1,650.00 0.75 US Treasury Note 3/15/2017 989.00 150,000.00 149,753.91 150,006.00 1,125.00 0.75 US Treasury Note 11/30/2015 518.00 305,000.00 312,082.23 309,974.55 4,193.00 1.34 US Treasury Note 5/31/2016 701.00 350,000.00 364,567.38 358,900.50 6,125.00 1.68 US Treasury Note 7/15/2016 746.00 340,000.00 339,690.82 341,064.20 2,125.00 0.63 Total Fixed Income 1,665,000.00 1,716,941.12 1,693,944.45 25,343.00 1.480 Total Assets ? 589.00 1,694,141.51 1,746,082.63 1,723,085.96 25,362.'00 1.45%