The URL can be used to link to this page

10-JULY 2014 FINANCIAL STATEMENTJULY 2014 F 0 0 inancial Report CITY OF Prepared By: The Finance Department October 3, 2014 CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31st,2014 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET REVENUE SUMMARY Taxes 14.838.072 489.53016 12.845.81214 13.847.028.51 891.04349 94.00% Franchises 1.778.005 220.216.74 1.319.937.74 1,406.501.80 - 292.103.20 0158% Permits 1.205.062 07.133.75 1.137.863.00 1.119.403.57 85.658.43 92.89% Uoonooa 70.100 0.172.50 06.680.00 72.007.50 - ;2,767.50 103.95% Fees 2.090.298 251.588.00 2.007.325.34 2,421.205.64 408.012.30 03.77% Fines 30,000 3,120.67 25.455.91 26.314.23 - 3.605.77 07J1 Y4 Inter-Jurisdictional 085.780 43.057.40 888.138.35 489.80316 195.976.84 7142% Fund Transfers 1.970.305 140.080.03 1,420.782.50 1,400.808.30 - 515.380.70 73.92% Miscellaneous 468,200 50,697.44 349,832.60 400,158.33 - 68,041.67 85.47% TOTALREVENUES 23,943,082 1,296,213.52 20,465,836.18 21,424,931.04 - 2,518,150.96 89.48% EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services 23.575 1.013.46 16.889.33 19.294.78 - 4.280.22 81.84% Supplies 508 576.60 47641 2159 9528% City Support Services 42.100 54.89 39.578.30 40.592.03 - 1.507.37 96.42% Operations Support 300 218.69 482.70 279.38 20.62 93.13% Staff Support 20.700 18.089.93 12.78478 1.478.00 6.43722 00.90Y6 Professional Services 1,200� �_ �_ �_ �_ 1,200I0 0.00% TOTAL CITY COUNCIL 88,375 2,087.14 76,628.04 73,427.98 1,478.00 13,46902 84.76% CITY MANAGER Personnel Services 910.718 02.040.82 751.422.00 733.141.64 - 177.570.30 80�50% Supplies 3.000 273.79 886.10 2.722.05 - 277.85 90.74Y6 City Support Services - - - 1.762.50 - (1.702.50) 0.00% Operations Support 100 - - - - 100.00 0.00Y6 Staff Support 35.350 2.992.81 21.085.09 16.532.37 290A6 18.52747 47�59Y4 Professional Services ---_-1,200 ---____-_ ---____--_ ---____-_' ---__1,200.00 0.00% TOTAL CITY MANAGER 950,368 65,313.42 773,994.45 754,158.56 290A6 195,919.28 79.38% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31st,2014 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET MUNICIPAL COURT Personnel Services 309.881 19.721.93 205.087.43 228.749.38 - 81.131.62 73.82% Supplies 2,000 104.97 1,686.76 1.150.35 043.65 57.82% City Support Services 1.000 - - - - 1.000.00 O�00% Operations Support 4`000 430.00 3,190.00 1.501l0 2.439.00 39.03% Staff Support 7.040 228.09 2.51671 4.387.49 498.75 2.953.70 02.32% Court Support 700 120.00 700.00 0.00% Professional Services 65.200 4.105.00 43.21577 44.302.65 10.189.00 2.07028 95�09% Maintenance Services 2.800 350.00 1.300.00 1.808.00 600.00 300.00 89.29% Operating Equipment 800 -_ -_ 37.27 -_ 762.73 4.66% TOTAL MUNICIPAL COURT 394,221 24,999.99 257,116.67 282,174.14 19,23781 92,809.05 76A6% CUSTOMER RELATIONS-311 Personnel Services 110.340 0.209.50 82.47028 80.50077 - 21.03923 80.21% Supplies 200 17.10 12135 78.65 60.08Y6 Staff Support 1.750 336.00 171.08 1.579.08 9.77% Operating Equipment 500 - _ -_ -_ 50010 {LVV% TOTAL CUSTOMER RELATIONS-311 112,790 8,269.50 82,823.39 88,793.12 - 23,996.88 78.72% PLANNING & ZONING Personnel Services 133.000 9.067.38 89.227.13 100.095.00 - 32.30440 75.00% Supplies 2.072 105.00 77629 834.00 1.837.94 31.21% Operations Support 750 - 171.08 - - 750.00 0.00Y6 Staff Support 18.532 285.00 1.051.42 715.18 78150 17.023.32 8.14% Professional Services 150 - 34.253.84 21.00 - 129.00 14.00Y4 Operating Equipment ---__318� -----__-_- ---____--_ -----___-_ ----__-_ ----__31V8.00 0J00y% TOTAL PLANNING LEGAL SERVICES Operations Support 12.000 1.421.01 3.970.00 5.252.05 8470 6.003.19 44.47% Professional Services __438,000 ___1,896.22 __367,659.91 __208,242.37 _____-_ __229�57.6c3 47.54% TOTAL LEGAL SERVICES 450,000 3,317.23 371,629.91 213,494.42 8416 236,420.82 47A6% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GENERAL SERVICES Personnel Services 567,475 39,815.67 446,480.62 437,833.89 - 129,641.11 77.15% Supplies 65,450 5,373.03 55,770.83 44,758.81 4,358.36 16,332.83 75.05% Utility Services 100,300 8,281.81 70,554.83 68,925.97 - 31,374.03 68.72% Staff Support 12,147 925.63 6,751.85 7,812.03 1,134.62 3,200.35 73.65% Maintenance Services 39,530 34.31 49,482.58 13,309.16 125.00 26,095.84 33.98% Rental /Leasing - - 458.25 - - - 0.00% Operating Equipment 21,480 - - 9,807.24 - 11,672.76 45.66% Capital Outlay 5,290 - - - - 5,290.00 0.00% TOTAL GENERAL SERVICES 811,672; 54,430.45 629,498:96 582,447.10 5,617.98 223,606.92 72.45% BUILDING 6 -8 MAINTENANCE Supplies 26,100 872.00 17,805.73 21,438.34 1,353.31 3,308.35 87.32% Utility Services 86,700 7,215.15 55,282.51 56,971.11 - 29,728.89 65.71% Maintenance Services 64,000 2,109.91 35,427.21 40,538.24 406.86 23,054.90 63.98% Operating Equipment 24,060 6,145.10 9,249.00 20,503.10 1,049.93 2,506.97 89.58% TOTAL BUILDING 6-8 MAINTENANCE 200,8601 16,342.16 117,764.45 139,450.79 2,810.10 58,599.11 70.83% CITY SECRETARY Personnel Services 171,031 12,443.86 114,962.95 127,952.31 - 43,078.69 74.81% Supplies 1,200 108.63 587.88 531.77 - 668.23 44.31% City Support Services 9,600 - 7,087.78 9,576.38 - 23.62 99.75% Operations Support 150 - - 50.00 - 100.00 33.33% Staff Support 7,895 783.71 3,450.72 4,313.77 51.00 3,530.23 55.29% TOTAL CITY SECRETARY 189,876< 13,336.20' 126,089.33 142,424.23 51.00 47,400.77 75.04% NON - DEPARTMENTAL City Support Services 373,511 1,327.82 316,043.25 272,694.86 918.00 99,898.14 73.25% Operations Support 128,000 21,482.71 104,002.60 117,490.23 - 10,509.77 91.79% Staff Support 100 200.00 12.88 340.08 100.78 (340.86) 440.86% City Assistance 993,666 105,228.72 671,153.77 899,821.37 - 93,844.63 90.56% Professional Services 231,350 3,535.64 88,917.43 37,197.62 - 194,152.38 16.08% 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' 131,774.89 1,345,398.93 1,329,499.16 1,018.78 873,409.06 60.37 %' CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC AFFAIRS Personnel Services 215,900 15,338.55 200,438.72 152,084.70 - 63,815.30 70.44% Supplies 3,400 314.79 2,512.52 2,212.94 45.98 1,141.08 66.44% Operations Support 27,050 1,100.00 14,087.35 10,165.03 - 16,884.97 37.58% Staff Support 5,240 36.00 3,013.41 2,700.33 242.08 2,297.59 56.15% 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" 16,789.34 220,052.00 171,552.99 288.06 97,848.95 63.72% RECORDS MANAGEMENT Personnel Services 49,777 3,700.11 37,774.87 38,876.08 - 10,900.92 78.10% Supplies 400 19.99 5.28 127.76 - 272.24 31.94% Staff Support 1,860 - 1,151.38 1,064.14 - 795.86 57.21% Professional Services 17,000 150.00 10,742.26 3,139.50 - 13,860.50 18.47% Operating Equipment - - - - 83.77 (83.77) 0.00% TOTAL RECORDS MANAGEMENT 69,037 3,870.10! 49,673.79 43,207.48 8177 ;25,745.75 62.71% SCHERTZ MAGAZINE Personnel Services 133,179 10,239.43 103,678.82 105,531.85 - 27,647.15 79.24% Supplies 200 - 200.00 73.94 - 126.06 36.97% Opperations Support 200 - - - 10.81 189.19 5.41% Staff Support 2,005 18.00 730.71 826.06 9.73 1,169.21 41.69% Professional Services 260,500 26,827.73 228,204.82 174,462.29 425.00 85,612.71 67.14% Fund Charges /Transfers 10,000 - - - - 10,000.00 0.00% Operating Equipment 600 - - 455.00 - 145.00 75.83% TOTAL SCHERTZ' MAGAZINE 406,684` 37,085.16' 332,814.35 281,349.14 445.54 124,889.32 69.29 %! ENGINEERING Personnel Services 231,566 8,917.78 105,344.33 126,407.24 - 105,158.76 54.59% Supplies 1,100 - 441.61 567.18 288.15 244.67 77.76% City Support Services 1,380 - - 262.80 - 1,117.20 19.04% Utility Services 1,400 - 517.42 523.76 - 876.24 37.41% Operations Support - - 195.00 - - - 0.00% Staff Support 8,580 490.00 1,126.25 1,426.29 - 7,153.71 16.62% Professional Services 43,000 - 59,160.52 11,671.25 - 31,328.75 27.14% Operating Equipment 8,000 - - 2,001.75 - 5,998.25 25.02% TOTAL ENGINEERING 295,026 9,407.78'' 1;66,785.13 142,860.27 288.15 151,877.58 48.52% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET GIS Personnel Services 131,043 9,983.52 100,228.85 103,602.21 - 27,440.79 79.06% Supplies 2,855 296.00 1,329.17 1,000.61 129.72 1,724.67 39.59% Staff Support 5,000 - 1,570.18 3,327.40 369.88 1,302.72 73.95% Professional Services - - 306.56 - - - 0.00% Rental /Leasing 3,805 - - - - 3,805.00 0.00% TOTAL GIS 142,703{ 10,279.52'! 103,434.76 107,930.22 499.60 34,273.18 75.98% TOTAL GENERAL GOVERNMENT 6,740,7111 407,640.92 4,779,784.72 4,455,035.44 32,987.21 2,252,688.35 66.58 %< PUBLIC SAFETY POLICE Personnel Services 4,842,482 364,412.02 3,685,494.49 3,804,235.39 - 1,038,246.61 78.56% Supplies 31,969 1,394.14 28,494.37 25,767.75 2,502.08 3,699.17 88.43% City Support Services 23,800 - 20,657.01 26,721.66 - (2,921.66) 112.28% Utility Services 135,880 11,877.72 94,706.86 97,404.19 - 38,475.81 71.68% Operations Support 2,444 426.00 2,367.97 1,850.53 - 593.47 75.72% Staff Support 93,355 8,112.69 34,182.99 65,894.30 2,808.80 24,651.90 73.59% City Assistance 5,829 - 751.36 5,828.15 - 0.85 99.99% Professional Services 35,498 2,400.00 6,618.91 28,712.35 200.00 6,585.65 81.45% Fund Charges /Transfers 3,250 - - - - 3,250.00 0.00% Maintenance Services 47,658 123.00 24,973.17 35,587.15 4,000.00 8,070.85 83.07% Operating Equipment 120,579 6,628.93 118,513.25 92,587.42 10,189.12 17,802.46 85.24% Capital Outlay 128,506 - 164,584.50 128,505.24 - 0.76 100.00% TOTAL POLICE 5,471,250 395,374.50 4,1!81,344.88 4,313,094.13 19,700.00 1,138,455.87 79.19 % >> FIRE RESCUE Personnel Services 2,706,130 197,846.31 2,115,199.22 2,128,288.85 - 577,841.15 78.65% Supplies 17,000 1,118.05 2,829.61 7,846.45 515.80 8,637.75 49.19% Utility Services 48,260 4,055.79 38,693.42 40,145.10 - 8,114.90 83.19% Operations Support 1,200 - 620.29 953.37 - 246.63 79.45% Staff Support 111,765 1,596.05 92,208.57 63,354.25 10,335.25 38,075.50 65.93% City Assistance 16,200 - 3,150.94 - 1,020.00 15,180.00 6.30% Professional Services 15,000 - 11,430.00 13,218.00 - 1,782.00 88.12% Maintenance Services 54,264 794.70 16,647.36 29,407.31 1,647.50 23,209.19 57.23% Operating Equipment 70,168 10,541.53 36,778.09 37,309.34 2,852.06 30,006.60 57.24% Capital Outlay 12,147 6,812.00 - 12,146.15 - 0.85 99.99% TOTAL FIRE RESCUE 3,052,134 222,764.43' 2,317,557.50 2,332,668.82 16,370.61 703,094.57 76.96% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET INSPECTIONS Personnel Services 478,959 28,655.14 334,342.25 358,712.85 - 120,246.15 74.89% Supplies 2,392 125.79 1,657.52 1,145.96 69.13 1,176.91 50.80% Utility Services 6,770 562.98 4,506.89 5,038.63 - 1,731.37 74.43% Operations Support 1,575 169.00 1,051.88 898.00 - 677.00 57.02% Staff Support 8,638 856.58 4,835.91 4,628.14 130.00 3,879.86 55.08% Professional Services 46 - - 45.59 - 0.41 99.11% Operating Equipment 3,430 - - 429.99 - 3,000.01 12.54% TOTAL INSPECTIONS 501,810 30,369.49 346,394.45 370,899.16 199.13 130,711.71 73.95 %'' MARSHAL'S OFFICE Personnel Services 557,097 42,227.78 426,194.30 454,057.82 - 103,039.18 81.50% Supplies 4,840 267.44 825.37 1,371.11 - 3,468.89 2833% Utility Services 16,000 1,034.07 12,167.69 7,903.58 - 8,096.42 49.40% Operations Support 3,500 12.49 244.96 919.00 293.56 2,287.44 34.64% Staff Support 10,550 590.45 2,602.82 3,819.15 332.40 6,398.45 39.35% City Assistance - - - - - - 0.00% Maintenance Services 16,000 1,180.00 8,486.00 5,211.14 180.00 10,608.86 33.69% Operating Equipment 8,000 - 1,565.51 7,354.47 304.32 341.21 95.73% Capital Outlay 35,000 - - 28,566.00 - 6,434.00 81.62% TOTAL MARSHAL'S OFFICE 650,987 45,312.23' 452,086.65 509,202.27 1,110.28 140,674.45 7839% TOTAL PUBLIC SAFETY 9,676,181 693,820.65 7,297,383.48 7,525,864.38 37,380.02 2,112,936.60 78.16% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET PUBLIC ENVIRONMENT 20,700 752.18 5,817.72 10,152.19 100.00 10,447.81 49.53% Utility Services 29,000 STREETS 12,600.60 - 16,399.40 43.45% Staff Support 925 - - - Personnel Services 681,227 49,377.44 514,165.91 532,704.36 - 148,522.64 78.20% Supplies 7,200 828.37 5,210.00 5,076.33 735.05 1,388.62 80.71% Utility Services 124,000 5,581.96 100,866.21 88,300.00 - 35,700.00 71.21% Staff Support 9,080 671.19 4,871.88 6,981.45 37.08 2,061.47 77.30% City Assistance 500 - - - - 500.00 0.00% Professional Services 29,875 - - - - 29,875.00 0.00% Maintenance Services 140,620 17,626.16 113,695.18 119,611.91 1,388.29 19,619.80 86.05% Rental /Lease 415 - - 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 - - 63,762.50 6,232.00 405.50 99.42% TOTAL STREETS - 1,105,9054 74,085.12 744,253.31 860,777.61 8,392.42 236,734.97 78.59% TOTAL PUBLIC' ENVIRONMENT 1,105,905 74,085.12' 744,253.31 860,777.61 8,392.42 236,734.97 78.59% PARKS & RECREATION PARKS DEPARTMENT Personnel Services 499,070 30,477.69 395,195.90 373,442.95 - 125,627.05 74.83% Supplies 35,155 3,887.64 24,379.94 21,957.09 3,977.68 9,220.23 73.77% Utility Services 149,220 12,777.48 120,288.28 94,501.95 231.64 54,486.41 6149% Operations Support 250 - - - - 250.00 0.00% Staff Support 8,473 305.73 4,888.10 5,426.16 248.49 2,798.35 66.97% Professional Services 38,250 - 34,493.50 18,800.21 6,152.50 13,297.29 65.24% Maintenance Services 24,230 358.56 11,168.69 7,615.05 6,908.10 9,706.85 59.94% Rental /Leasing 44,000 (3,217.40) 36,518.05 28,942.57 9,676.20 5,381.23 87.77% Operating Equipment 1,100 - 2,176.27 1,043.45 344.25 (287.70) 126.15% TOTAL PARKS DEPARTMENT 799,748< 44,589.70` 629,10813 551,729.43 27,538.86 220,47911 72.43% SWIM POOL Supplies 20,700 752.18 5,817.72 10,152.19 100.00 10,447.81 49.53% Utility Services 29,000 2,136.18 15,772.94 12,600.60 - 16,399.40 43.45% Staff Support 925 - - - - 925.00 0.00% Maintenance Services 203,378 - 126,952.50 61,567.91 17.55 141,792.54 30.28% Rental /Lease 500 - - - - 500.00 0.00% TOTAL SWIM POOL 254,503'+ 2,888.36' 148,543.16 84,320.70 117:55 170,064.75 3118 %i CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET EVENT FACILITIES Personnel Services 57,195 4,107.35 41,527.47 42,327.59 - 14,867.41 74.01% Supplies 17,000 203.97 11,671.19 9,984.87 176.10 6,839.03 59.77% Utility Services 51,200 3,916.08 32,184.13 32,863.85 - 18,336.15 64.19% Operations Support 12,800 - 13,378.99 9,994.39 - 2,805.61 78.08% Staff Support 2,727 18.00 1,497.61 1,878.47 168.00 680.53 75.04% Professional Services 1,600 90.00 90.00 618.45 - 981.55 38.65% TOTAL EVENT FACILITIES 142,522 8,335.40 100,349.39 97,667.62 344.10 44,510.28 68.77% SENIOR CITIZEN CENTER Supplies 7,759 580.30 - 5,046.22 654.90 2,057.88 73.48% 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,625.98 - 15,120.38 160.00 10,005.62 60.43% Professional Services 11,530 3,296.75 - 7,263.49 161.00 4,105.51 64.39% Maintenance Services 2,400 - - 7,548.20 - (5,148.20) 314.51% TOTAL SENIOR CITIZEN CENTER 53,615 6,503.03 - ` 35,392.29 975.90 17,246.81 67.83 %` TOTAL 'PARKS '& RECREATION 1,250,388 62,316.49` 878,001.28 769,110`.04 28,976.41 452,301.55 63.83 %s CULTURAL LIBRARY Personnel Services 678,656 44,975.95 532,074.47 519,057.44 - 159,598.56 76.48% Supplies 12,000 1,598.37 9,484.90 8,737.16 937.08 2,325.76 80.62% Utility Services 51,060 5,188.53 37,307.61 33,999.83 - 17,060.17 66.59% Operations Support 3,500 15.99 1,429.69 633.84 215.99 2,650.17 24.28% Staff Support 5,940 21.00 1,308.36 2,736.76 - 3,203.24 46.07% 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 14,990.25 50,655.86 67,996.88 7,254.31 5,318.81 9140% TOTAL LIBRARY 836,476 66,790.09' 635,000.89 635,351.91 8,40738 192,716.71 76.96 %i TOTAL CULTURAL 836,476' 66,790.09 635,000.89 635,351.91 8,407.38 192,716.71 76.96% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31st,2014 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET HEALTH ANIMAL SERVICES Personnel Services 317.026 22.528.40 207.50225 213.564.54 104.001.40 67.24% Supplies 30.700 3.867.04 17.397.07 24.470.54 489�92 5.729.54 0134% Utility Services 20.530 2.542.15 8.002.05 15.805.93 4.724.07 70.99% Operations Support 1.000 078.00 155.95 670.00 - 322.00 07�80% Staff Support 10.450 4.92440 4.572.80 5.877.10 43J6% City Assistance 17.550 50.32 8.013.75 6.49770 1.030.10 10.022.14 42.09% Professional Services 21.500 555.00 9.203.01 20.341.78 1.802.00 (443J8) 102.08Y6 Maintenance Services 20.285 44.05 3.313.84 3.28240 120.00 10.802.60 16.77% Operating Equipment 14,495� 997.00 2,371.49 2,659.44 1/049.14 10�86.42 25.59% TOTAL Am!MAL SERVICES 454,136 31,268.84 262,345.27 291{,873.23 4,301!.22 157,961.55 65.22p6 TOTAL HEALTH 454,136 31,268.84 262,345.27 291,873.23 4,301.22 157,961.55 6522% INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services 401.949 34.220.82 228.700.00 330.943.15 71.005.85 82.33% Supplies 2.000 138.10 47047 1.680.59 75�88 237.53 08.12% City Support Services 444.823 48.754.80 247.05949 307.115.89 3.033.57 134.073.54 08.88Y6 Utility Services 185.372 10.284.04 134.52740 130.00549 220.47 50.546.04 71.06% Staff Support 22.275 1.170.65 13.280.80 21.25372 53841 481.87 97.84% Maintenance Services 12.500 433.80 5.101.00 8.04248 110.89 4.338.53 6529Y4 Operating Equipment ---373,483 � --_69,017.43 --__81,096.07 ---267/007.38 —38,652.65 ----67�22.97r 81.84% TOTAL INFORMATION' CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31st,2014 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET HUMAN RESOURCES Personnel Services 310.989 25.69118 228.080.65 234.920.63 - 70.008.37 75.54% Supplies 1.300 32.40 493.01 95747 3243% 34253 73.65% Human Services 02.900 2.947.73 32.25471 31.565.06 2.224.04 29.110.30 50.72% Operations Support 9.500 190.80 8.091.04 7.188.04 795.00 1.516.90 84.03% Staff Support 14.919 200.08 10.740.83 10.489.20 606.16 3.763.58 74.77% City Assistance 10.000 1.817.07 7.717.50 4.35021 55.00 5.58079 44.11% Professional Services 4.000 - - 1.250.00 - 2.750.00 3125% Operating Equipment 900 -_ -_ -_ 577.08 322.92 64.12% TOTAL HUMAN RESOURCES FINANCE Personnel Services 454.990 34.159.37 348.903.32 355.881.39 89.114.61 78.22% Gupdhm 2,492 155.71 2.350.52 2.15117 - 340.03 8632% Operations Support 1,000 986.58 834.08 166.00 8340% Staff Support 14.805 219.00 5.40245 0.100.98 - 8.680.01 41�26% Maintenance Services 8 ' 8.00 0.00% Operating Equipment -_ 1,770.00 �_ �_ �_ C.0x% TOTAL FINANCE 473,301 34,534.08 357,492.79 364,975,55 108,325.45 77.11% PURCHASING & ASSET MGT Personnel Services 255.024 18.002.82 184.75851 189.805.03 - 55.210.01 78.35% Supplies 1200 02.82 520.30 37118 17.98 810.83 3243% Utility Services OOO - 378.03 212.03 - 387.37 3544% Operations Support 308 1319 300.00 0.00Y6 Staff Support 0.102 14.75 4.895.05 3.35413 21.87 2.725.80 55.33% Operating Equipment 3,933 - - 1,840.63 - 2,092.37 4&80% TOTAL PURCHASING & ASSET MGT 267,159 18,880.49 200,565.94 205,58420 39.96 61,535.28 76.97% CITY O F S C H E R TZ REVENUE AND EXPENSE REPORT (UNAUD|TED) AS OF: JULY 31st,2014 2V13'2U14 101GENERALFVND CURRENT CURRENT PRIOR YEAR Y�-D Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y�-DACTUAL ACTUAL ENSUMBR BALANCE BUDGET FLEET SERVICE Personnel Services 222.091 15.313.97 141.189.00 108.70971 - 53.381.29 75.90% Supplies 109.901 31.50214 132.00717 170.205.37 9.070.00 (8.46245 ) 105.57% City Support Services 3.500 - 2.380.00 2.100.00 - 1.400.00 00.00% Utility Services 4.599 500.97 2.88140 3.40348 1,195.52 74.00% Operations Support 400 - 142I0 - 18.60 30034 4�92% Staff Support 4.085 120.56 1.570.05 2.003.79 10.58 2.070.62 49.31% City Assistance 180 - - - - 100.00 0�00% Maintenance Services 70.090 16.854.52 00.738.75 05,436.27 073.00 (15.420.0) 121.81% Rental/Lease 200 ' 200.00 0.00% Operating Equipment 5.000 9,451.28 3.188.78 1.81121 03.78% Capital Outlay 10\000 -_ -_ -_ -_ 10\000l0 0l80% TOTAL FLEET SERVICE 490,646 64,292.16 370,946.51 435,127.41 9,782.13 45,736.46 90.68% oU|ummG MAINTENANCE Personnel Services 92.900 7,202.43 51.288.53 77,457.14 - 15,500.00 03.32% Supplies 1.543 2720 238.03 94.97 1.217.40 2110Y6 Utility Services 3.850 230.03 1.711.34 2.808.05 ' 1.480.35 61.55% Staff Support 2,850 0821 389.54 1.737.34 5.30 1.107.30 0115% Professional Services 10.000 2.100.00 12.622.50 9.745.00 - 255.00 9745% Maintenance Services 107.928 4.067.05 45.48346 80.390.51 16,492.31 11.03710 89.77% Rental/Leasing 1,400 - 875.00 - ' 1.400.00 0.00% Operating Equipment 539.50 0.00% Capital Outlay 118,000 3,712.50 8,415.00 105,872.50 10.28% TOTAL BUILDING MAINTENANCE 338,529 13,697.12 112,404.87 175,642.77 25,007.58 137,878.65 59.27% TOTAL INTERNAL SERVICE 3,436,545 324,430.07 2,037,103.20 2,546,711.30 82,388.52 807,445.62 76.50% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% 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 - 42,000.00 55,628.00 - (13,628.00) 132.45% TOTAL CITY ASSISTANCE 74,000 47,000.00 82,648.00 - (8,648.00) 111.69% COURT - RESTRICTED FUNDS Operating Equipment 6,400 - 19,002.73 840.00 1,840.00 3,720.00 41.88% TOTAL CITY ASSISTANCE 6,400! - 19,002.73 840.00 1,840.00 3,720.00 41.88% TOTAL MISC &PROJECTS 80,400 - 66,003 83,488 1,840 (4,928.00) 106.13 %< TOTAL EXPENDITURES 23,580,742 1,660,352.18; 16,699,874.88 17,168,211.91 204,673.18 6,207,857.35 73.67 %! REVENUE OVER(UNDER) EXPEND. 362,340 4,256,719.13 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411100 Advalorem Tax - Current 7,839,691 20,939.34 7,458,361.75 8,031,322.26 - (191,631.26) 102.44% 000 - 411200 Advalorem Tax - Delinquent 50,000 2,232.62 37,271.05 24,766.54 - 25,233.46 49.53% 000 - 411300 Advalorem Tax - P &I 50,000 2,724.03 37,690.42 37,099.77 - 12,900.23 74.20% 000 - 411500 Sales Tax Revenue -Gen Fund 6,870,981 473,634.17 5,282,068.15 5,824,760.35 - 1,046,220.65 84.77% 000 - 411600 Bingo Tax - - - 30.62 - (30.62) 0.00% 000 - 411700 Mixed Beverage Tax 28,000.00 - 30,420.77 29,648.97 - (1,648.97) 105.89% TOTAL Taxes 14,838,672 499,530.16 ' 12,845,812.14 13,947,628.51 - 891,043.49 94.00% Franchises 000 - 421200 Center Point/Entex Energy 72,100 4,729.34 52,719.50 69,261.80 - 2,838.20 96.06% 000 - 421220 City Public Service 460,837 134,272.67 337,025.73 538,146.13 - (77,309.13) 116.78% 000 - 421240 Guadalupe Valley Elec Co -op 400,000 42,256.81 322,188.28 246,112.91 - 153,887.09 61.53% 000 - 421250 New Braunfels Utilities 61,800 6,374.06 41,862.73 50,547.51 - 11,252.49 81.79% 000 - 421300 Time Warner -State Franchise 300,000 22,433.72 265,031.99 233,440.75 - 66,559.25 77.81% 000 - 421460 AT &T Franchise Fee 260,868 15,956.90 201,670.63 202,334.49 - 58,533.51 77.56% 000 - 421480 Other Telecom Franchise 115,000 2,193.24 8,794.09 53,024.26 - 61,975.74 46.11% 000 - 421500 Solid Waste Franchise Fee 108,000 - 90,644.79 93,633.95 - 14,366.05 86.70% TOTAL Franchises 1,778,605 228;216.74 1,319,937.74> 1,486,501.80 - 292,103.20 83.58% Permits 000 - 431100 Home Occupation Permit 490 - 455.00 525.00 - (35.00) 107.14% 000 - 431205 Building Permit - Residential 404,420 26,126.00 377,263.00 311,453.00 - 92,967.00 77.01% 000 - 431210 Building Permit - Commercial 170,000 - 350,496.00 228,249.00 - (58,249.00) 134.26% 000 - 431215 Building Permit - General 283,296 12,975.00 115,670.00 296,811.00 - (13,515.00) 104.77% 000 - 431300 Mobile Home Permit 450 50.00 475.00 675.00 - (225.00) 150.00% 000 - 431400 Signs Permit 4,582 1,004.00 4,252.00 6,890.00 - (2,308.00) 150.37% 000 - 431500 Food Establishmnt Permit 45,000 1,375.00 14,345.00 28,565.00 - 16,435.00 63.48% 000 - 431600 Garage Sale Permit 12,000 1,158.00 10,030.00 10,517.00 - 1,483.00 87.64% 000 - 431700 Plumbing Permit 117,324 7,311.75 102,947.10 82,030.55 - 35,293.45 69.92% 000 - 431750 Electrical Permit 50,000 3,560.00 50,700.00 43,704.50 - 6,295.50 87.41% 000 - 431800 Mechanical Permit 50,000 5,060.00 46,420.00 43,400.00 - 6,600.00 86.80% 000 - 431900 Solicitor /Peddler Permit 1,000 580.00 1,620.00 1,160.00 - (160.00) 116.00% 000 - 431950 Animal /Pet Permit 2,000 - 1,700.00 1,515.00 - 485.00 75.75% 000 - 432000 Cert. of Occupancy Prmt 6,500 350.00 4,550.00 5,400.00 - 1,100.00 83.08% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 432100 Security Alarm Permit 45,000 5,280.00 40,690.00 33,170.00 - 11,830.00 73.71% 000 - 432300 Grading /Clearing Permit 3,000 100.00 1,474.50 3,832.52 - (832.52) 127.75% 000 - 435000 Fire Permit 10,000 2,204.00 14,776.00 21,506.00 - (11,506.00) 215.06% TOTAL Permits 1,205,062 67,133.75 - 1,137,863.60 1,119,40157 - 85,658.43 92.89% Licenses 000 - 441000 Alcohol Beverage License 5,500 1,317.50 4,797.00 6,502.50 - (1,002.50) 118.23% 000 - 441300 Mobile Home License 200 - 160.00 160.00 - 40.00 80.00% 000 - 442000 Contractors License 60,200 4,490.00 57,815.00 63,100.00 - (2,900.00) 104.82% 000 - 444000 Pet License 4,200 365.00 3,916.00 3,105.00 - 1,095.00 73.93% TOTAL Licenses 70,100 6,172.50 > 66,688.00 72,867.50 - (2,767.50) 103.95% Fees 000 - 451000 Municipal Court Fines 1,345,300 101,438.59 1,200,441.59 1,067,508.37 - 277,791.63 79.35% 000 - 451100 Arrest Fee 56,734 4,024.56 54,220.05 43,372.88 - 13,361.12 76.45% 000 - 451110 Expunction Fee 120 - 30.00 - - 120.00 0.00% 000 - 451200 Warrant Fees 148,500 11,984.32 139,892.07 117,384.41 - 31,115.59 79.05% 000 - 451210 Court - Claims & Judgements - - (388.00) (773.10) - 773.10 0.00% 000 - 451320 Civil Justice Fee -Court 97 - 84.06 18.40 - 78.60 18.97% 000 - 451321 Civil Justice Fee -State 885 - 758.46 165.94 - 719.06 18.75% 000 - 451340 Judicial Fee - City 8,562 545.02 7,244.74 5,804.25 - 2,757.75 67.79% 000 - 451400 Traffic Fine Costs TTL 32,246 2,064.09 27,682.08 21,554.88 - 10,691.12 66.85% 000 - 451500 Teen Court Admin Fee 200 - 220.00 40.00 - 160.00 20.00% 000 - 451510 Juvenile Case Mgmt Fee 64,384 4,546.78 60,427.77 48,383.66 - 16,000.34 75.15% 000 - 451520 Truancy Fee - 732.80 - 4,535.14 - (4,535.14) 0.00% 000 - 451600 Technology Fund Fee 59,500 3,690.07 48,405.01 39,007.55 - 20,492.45 65.56% 000 - 451700 Security Fee 42,655 2,767.53 36,303.74 29,255.62 - 13,399.38 68.59% 000 - 451800 Time Payment Fee - City 6,238 417.41 5,205.10 5,675.59 - 562.41 90.98% 000 - 451850 State Fines 10% Service Fee 92,278 16,238.48 88,442.58 68,504.06 - 23,773.94 74.24% 000 - 451900 DPS Payment - Local 13,981 877.34 11,027.88 9,144.03 - 4,836.97 65.40% 000 - 452000 Child Safety Fee 22,076 239.15 17,935.68 15,870.45 - 6,205.55 71.89% 000 - 452050 Indigent Defense Fee 31,076 - 23,823.40 5,099.02 - 25,976.98 16.41% 000 - 452100 Platting Fees 52,500 12,500.00 47,811.00 52,750.00 - (250.00) 100.48% 000 - 452200 Site Plan Fee 25,500 8,000.00 22,500.00 23,500.00 - 2,000.00 92.16% 000 - 452300 Plan Check Fee 361,264 19,646.00 406,683.50 415,618.50 - (54,354.50) 115.05% 000 - 452310 Miscellaneous Review Fee 1,200 - 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 2,480.00 17,154.00 14,930.00 - 11,470.00 56.55% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET 000 - 452600 Specific Use /Zone Chng Fee 25,800 2,000.00 22,000.00 13,450.00 - 12,350.00 52.13% 000 - 452710 Zoning Ltr & Dev Rights 1,050 - 1,350.00 450.00 - 600.00 42.86% 000 - 453100 Reinspection Fees 36,700 3,100.00 26,600.00 28,470.98 - 8,229.02 77.58% 000 - 453110 Swim Pool Inspection Fee 1,500 - 1,575.00 2,275.00 - (775.00) 151.67% 000 - 453200 Lot Abatement 7,000 100.00 8,523.04 6,281.42 - 718.58 89.73% 000 - 453211 Admin Fee - Inspections 5,200 800.00 4,300.00 7,792.65 - (2,592.65) 149.86% 000 - 453310 Misc Inspection Fee - 100.00 - 3,050.00 - (3,050.00) 0.00% 000 - 453710 Foster Care 1,400 100.00 1,000.00 800.00 - 600.00 57.14% 000 - 454200 Pool Gate Admission Fee 22,400 9,819.55 16,854.25 19,414.05 - 2,985.95 86.67% 000 - 454300 Seasonal Pool Pass Fee 5,100 640.00 5,600.00 5,933.15 - (833.15) 116.34% 000 - 456110 Senior Center Memberships 5,625 294.00 - 1,944.32 - 3,680.68 34.57% 000 - 456120 Senior Center Meal Fee 30,785 2,258.00 - 8,138.00 - 22,647.00 26.43% 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 800.00 - (50.00) 106.67% 000 - 458100 Sale of Merchandise - - - 210.00 - (210.00) 0.00% 000 - 458110 Sale of Merchandise- GovDeal 18,000 4,899.99 14,103.14 16,239.00 - 1,761.00 90.22% 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 18,263.25 141,197.75 144,051.25 - (3,135.25) 102.22% 000 - 458401 Capital Recovery Fee -Civic Cntr 5,000 1,450.00 4,575.00 6,890.00 - (1,890.00) 137.80% 000 - 458450 North Center Rental Fees 20,600 3,025.00 15,910.00 19,972.00 - 628.00 96.95% 000 - 458460 Senior Center Rental 18,000 1,750.00 - 7,589.00 - 10,411.00 42.16% 000 - 458500 Community Center Rental Fees 27,026 739.00 24,010.76 18,569.07 - 8,456.93 68.71% 000 - 458550 Pavilion Rental Fees 18,500 1,575.00 15,598.50 14,607.50 - 3,892.50 78.96% 000 - 458560 Chamber of Comm rent 7,800 - 7,800.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,016.00 2,952.98 8,587.32 - (187.32) 102.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 2,190.00 6,440.00 7,680.00 - (1,680.00) 128.00% 000 - 459200 NSF Check Fee 650 - 490.00 195.00 - 455.00 30.00% 000 - 459300 Notary Fee 300 18.00 204.00 222.00 - 78.00 74.00% 000 - 459400 Maps, Copies, UDC, & Misc F 100 10.00 85.00 99.70 - 0.30 99.70% 000 - 459600 Animal Adoption Fee 17,500 1,901.00 14,784.50 10,261.00 - 7,239.00 58.63% 000 - 459700 Pet Impoundment Fee 14,000 1,699.00 12,642.55 11,731.01 - 2,268.99 83.79% 000 - 459800 Police Reports Fee 6,000 548.10 5,405.10 4,453.40 - 1,546.60 74.22% TOTAL Fees 2,890,298 251,588.03 2,607,325.34 2,421,285.64 - 469,012.36 8177 %' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fines 000 - 463000 Library Fines 30,000 3,120.67 25,455.91 26,314.23 - 3,685.77 87.71% TOTAL Fines 30,000 3;120.67 25,455.91 26,314.23 - 3,685.77 87.71% Inter - Jurisdictional 000 - 473100 Bexar Co - Fire 21,072 - 17,564.80 7,025.92 - 14,046.08 33.34% 000 - 473200 City of Seguin - Fire Contract 30,000 2,435.90 33,552.60 24,359.00 - 5,641.00 81.20% 000 - 473300 Guad Co - Library 208,343 34,723.82 156,257.19 190,981.01 - 17,361.99 91.67% 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,117.50 30,597.96 30,661.68 - 9,338.32 76.65% 000 - 474610 School Cross Guard - Guadalupe 40,000 3,380.18 30,591.34 21,746.50 - 18,253.50 54.37% 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 43,657.40 686,138.35' 489,803.16 - 195,976.84 71.42 %' Fund Transfers 000 - 480000 Indirect Costs - EMS 137,038 11,419.83 73,200.00 114,198.30 - 22,839.70 83.33% 000 - 480100 Indirect Costs - Hotel /Motel 145,385 12,115.42 131,264.20 121,154.20 - 24,230.80 83.33% 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 41,423.30 43,166.70 - 8,633.30 83.33% 000 - 486000 Interfund Chrges -Admin W &S 1,152,350 96,029.17 884,135.80 960,291.70 - 192,058.30 83.33% 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 93,967.50 108,619.90 - 21,724.10 83.33% 000 - 488000 Interfund Charges -413 136,245 11,353.75 202,791.70 113,537.50 - 22,707.50 83.33% TOTAL Fund Transfers 1,976,365 i 146'096.83 1,426,782.50` 1,460,968.30 - 5115,396.70 73.92% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ***************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 101 GENERAL FUND CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 491000 Interest Earned 500 - 373.89 306.80 - 193.20 61.36% 000 - 491200 Investment Income 45,000 2,125.88 36,389.07 22,340.65 - 22,659.35 49.65% 000 - 491800 Gain /Loss - - (17,341.83) (17,122.84) - 17,122.84 0.00% 000 - 491900 Unrealized Gain /Loss (26,000) (2,303.10) (12,094.26) 5,679.90 - (31,679.90) 0.00% 000 - 493120 Donations - Public Library 5,000 8.00 7,500.00 7,258.90 - (2,258.90) 145.18% 000 - 493130 Donations - Writing the Next Chap. - - 325.00 - - - 0.00% 000 - 493400 Donation - Animal Control 4,000 325.00 1,736.05 1,162.97 - 2,837.03 29.07% 000 - 493401 Donations -A/C Microchip 2,000 175.00 1,395.00 1,120.00 - 880.00 56.00% 000 - 493402 Donations - Spay &Neuter 14,000 1,827.95 11,167.38 8,813.95 - 5,186.05 62.96% 000 - 493403 Donations - Animal Adoption Trailer - - - 2,000.00 - (2,000.00) 0.00% 000 - 493465 Donations - Senior Center - 8,516.06 - 30,032.07 - (30,032.07) 0.00% 000 - 493502 Donations -PD - - 300.00 2,400.00 - (2,400.00) 0.00% 000 - 493503 Donations - Fire Rescue - - 1,250.00 - - - 0.00% 000 - 494481 LawEnforcemtOfficersStnd &Ed - - - 3,931.29 - (3,931.29) 0.00% 000 - 494482 Grants - Police, Fire, Gen Fund - 820.99 - 5,499.84 - (5,499.84) 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 9,626.98 15,439.46 33,082.35 - (13,082.35) 165.41% 000 - 497005 Schertz Magazine Advertising 220,000 19,775.00 190,633.00 189,950.00 - 30,050.00 86.34% 000 - 497007 Misc Income - Schertz Artz - - 10.00 - - - 0.00% 000 - 497100 Misc Income - Police 12,000 1,773.00 11,211.76 4,078.40 - 7,921.60 33.99% 000 - 497150 Misc Income -Fire Department - - 292.37 - - - 0.00% 000 - 497200 Misc Income - Library 4,000 355.25 3,601.75 3,818.14 - 181.86 95.45% 000 - 497210 Misc Income - Library Copier 13,000 1,253.20 11,893.82 11,753.40 - 1,246.60 90.41% 000 - 497300 Misc Income - Animal Control - - 190.00 - - - 0.00% 000 - 497400 Misc Income - Streets Dept. 18,000 1,775.00 17,528.68 27,343.70 - (9,343.70) 151.91% 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 677.37 19,792.84 20,341.42 - (5,341.42) 135.61% 000 - 497600 Misc Income - Vending Mach. 2,200 404.61 2,018.27 1,912.01 - 287.99 86.91% 000 - 498000 Reimbursmnt -Gen Fund 60,000 1,133.82 16,279.10 11,376.80 - 48,623.20 18.96% 000 - 498100 Reimbursmnt Fire - Training - 1,192.30 - 4,398.97 - (4,398.97) 0.00% 000 - 498105 Reimburmnt Police - DEA 9,000 1,235.13 4,650.74 4,655.49 - 4,344.51 51.73% 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 ; 50 697.44 349,832.60 400,158.33 - 68,041.67 85.47 %? TOTAL?REVENUES 23,943,082 1,296;21152 20,465,836.18? 21,424,931.04 - 2,518,150.96 89.48% GENERALFUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 982,433.39 Cash in Investments LOGIC Investment - General Fund 5,638,876.31 LOGIC Investment -Equip Replacement 73,637.20 LOGIC Investment -Veh Replacement 211,223.19 LOGIC Investment -Air Condi Replacment 171,543.66 CAPITAL ONE Investment - General Fund 1,345,514.67 Total Cash in Bank & Investments $ 8,569,810.26 - 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 20,939 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: JULY 31st, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 106 - SPECIAL EVENTS 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 Fund Transfers 149,657.00 118,222.00 - 118,222.00 - 31,435.00 79.16% 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,598.88 23,762.00 - (9,962.00) 0.00% Miscellaneous 11,500.00 151.28 4,415.53 7,034.39 - 4,465.61 97.70% TOTAL REVENUES 199,957.00 118,373.28 44,860.57 172,483.11 - 27,473.89 97.70 %` 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 - 6,385.23 11,510.21 - 489.79 95.92% National Night Out 150.00 - - - - 150.00 0.00% Wilenchik Walk for Life 25,000.00 18,702.72 20,846.16 23,464.72 - 1,535.28 93.86% Schertz Sweetheart 37,000.00 500.00 27,994.60 29,054.64 3,448.00 4,497.36 87.84% Jazzfest 25,000.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 - 2,337.13 52,877.26 781.25 13,198.49 80.26% TOTAL CULTURAL 194,807.00 19,202.72 100;858.80' 150,425 80 4,229.25 40,151.95 79.39% TOTAL' EXPENDITURES 199,957.00 19,202.72 100,858.80 150,425.80 4,229.25 45,301.95 77.34 %' REVENUE OVER(UNDER) EXPEND - 22,057 31 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 105,045.91 Cash in Investments MBIA Special Events 16,781.35 Total Cash in !Bank & Investments $ 121,827.26 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 2 0 1 3 - 2 0 1 4 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 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 39,204.90 51,893.44 6,811.55 302,795.01 16.24% TOTAL GENERAL GOVERNMENT 361,500.00 39,204.90 51,893.44 6,811:55 302,795.01 16.24% TOTAL EXPENDITURES 361,500.00 39,204.90 51,893.44 6,811.55 302,795.01 16.24% REVENUE OVER(UNDER) EXPEND (12,507:72 }' CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 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 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: JULY 31st, 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: JULY 31st,2014 2V13'2014 2V2-VVATER&SEWER CURRENT CURRENT PRIOR YEAR Y�-} Y�-D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBIR BALANCE BUDGET REVENUE SUMMARY Franchises 185.710 2.500.00 157,51714 168.217.82 - 28,48218 84.93% Permits 12,00.00 - 20�23.65 56�03.86 - (44'903.86) 474.20% Fees 16.092.603 1,420.732.26 12.005.540.80 13.593.089.51 - 2,498.99349 8447% Fund Transfers 2.317.282 10.359.07 89,415.00 103.590.70 - 2.813.885.30 3.55% Miscellaneous 165,440 784.30 277,838.27 225,411.18 - (59,971.18) 136,25% TOTALREVENUES 19,383,115 1,442,376.23 13,161,240.92 14,145,819.07 - 5,237,295.93 72.98% EXPENDITURE SUMMARY BUSINESS OFFICE Personnel Services 440,455 30.016.72 311.803.08 323.175.41 123.279.58 72.38% Supplies 4.000 700.08 2,423.91 3.580.50 17119 832.31 81�91Y4 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 9,400.43 84.628.40 80.725.52 11.84 25.637.04 79.05% Staff Support 7,100 97.10 2,510l0 2,603/91 97.85 4.38824 38.05% Professional Services 24.000 3,445.87 18.201.04 21.78118 2.208.82 80.00% Maintenance Services 13,440 - 9.800.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 43,666.36 431,001.56 454,549,47 280.88 166,869.65 73.16% Personnel Services 1.202.040 89,449.70 835.042.32 902.004.09 - 299435.31 75.09% Supplies 185.150 8.288.01 128.721.73 117.28913 4.88010 72.854.77 02.67% Human Services 1.000 - 141l0 389.95 - 010.05 39.00% City Support Services 91.300 5.375.00 47.615.04 61,051.99 30.248.01 00.87% Utility Services 3.342.400 335.158.05 2.508.03615 2.520.578.08 - 815.821.32 75.59% Operations Support 9,250 0529 2,798.84 2214.68 73.60 6,961.71 2474% Staff Support 28.700 2.717.45 15.095.02 21.700.54 944.60 0.908.80 70�54% City Assistance 1.900 453.00 70825 1.191.75 37.28% Professional Services 249.113 1.102.80 210.090.08 131.100.90 - 118.012.04 52.03% Fund 3,336700 13527734 2.228.378.28 2,483.23618 853.523.81 7442% Maintenance Services 5.924.250 561.40871 4,460.150.73 4.947,420.00 82.887.39 883.835.81 84�91% Other Costs 35,000 29,541.85 27,650.20 7.349.80 78.00% CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 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 83.33% OF BUDGET Debt Service 1,458,925 196,508.56 305,989.36 399,880.48 - 1,059,044.52 27.41% Rental- Leasing 6,070 212.33 3,570.91 2,684.95 - 3,385.05 44.23% Operating Equipment 11,164 - 1,602.76 15,345.80 399.98 (4,581.78) 141.04% Capital Outlay 544,316 - 84,450.00 431,787.10 - 112,528.90 79.33% TOTAL PUBLIC WORKS 16,438,338 1,336,574.04 10,872,892.88 12,071,746.40 89,301.67 4,277,289.93 73.98 %d; MISC & PROJECTS PROJECTS Professional Services - - 64,275.30 - - - 0.00% Fund Charges /Transfers 2,185,086 - - - - 2,185,086.00 0.00% Maintenance Services - - 640,816.05 - - - 0.00% TOTAL PROJECTS 2,185,086 - 705;091.35 - - 2,185,086.00 0.00 % s' TOTAL!MISC &PROJECTS 2,185,086 705,091.35 2,185,086.00 0.00 %< TOTAL EXPENDITURES 19,245,124 1,380,240 12,008,986 12,526,296 89,583 6,629,246 65.55% " REVENUE OVER(UNDER)EXPENSES " 137,991 1,619,523.20 CITY O F S C H E R T Z REVENUE REPORT (UNAUD|TED) AS OF: JULY 31 st, 2014 2V13'3V14 202-WATER & SEWER CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y'T'DACTUAL ACTUAL ENCUM8R BALANCE BUDGET Franchises 000'421490 Tower Leasing 1�95,710 2,500J00 __-157,517]4 166},217.8C2 �_ 29,492.18 84,93% TOTAL Franchises 195,710 2,50000 157,517.14 166,217.82 - 29,492.18 84.93% Permits 000432400 Development Permit 12,0X00 -_ 20,923.65 56,903.8K6 -_ 474.20% � TOTAL Permi�� - �� o�2 ---�8��---'� 90--- Fees 000-455200 Garbage Collection Fee 3.600.000 328.11818 2.978.469.80 3.285.827.92 - 314.172�08 9127% 000455000 Fire Line Fees 22.000 - 20.035.00 23.985.00 - (1.985.00) 108.02% 000455700 Recycle Fee Revenue 202.983 22.366.24 216.092.60 219.10945 - 43.873.55 8332% 000455800 VV&S Line CnnotructnReimbumomnt 30.000 1.107.00 17.829.63 10.534.52 - 10.46548 6512% 000457100 Sale ofWater 8.043.200 735.92414 6.209.87775 6.250.167.63 - 1.793.03237 7771% 000457110 Edwards Water Lease 127.000 - 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.567.00 47.572.08 45.18746 - 44.812.54 5021% 008457400 Sewer Charges 3.058.000 320.45347 2.712.858.04 3.205.095.15 - 452.304.85 87.04% 000457500 Water Penalties 180.000 16.03623 150.50631 167.040.90 - 12.958.01 92.80% 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 10X0.00 -----2,100.00 ---_-2,380.00 -----_--_ --___120.00 95.20% TOTAL 1,6J092,683 1,4 12.605,540.86 689.51 2,498,993 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 09.415.00 103.59670 ' 20.719.30 83.8396 000480411 Transfer In-Capital Recovery —_-120,0X00 ---____-_ ----____-_ -_' --------- --_12[,00{�00 0I0% TOTAL Fund Transfers 2,917,282 10,359.67 99,41500 103,59610 - 2,813,68530 155% CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 *********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 202 -WATER & SEWER CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000 - 490000 Misc Charges 700 - 5,912.78 391.50 - 308.50 55.93% 000 - 491000 Interest Earned 2,000 68.69 1,334.63 1,071.78 - 928.22 53.59% 000 - 491200 Investment Income 12,000 247.13 6,290.27 3,921.60 - 8,078.40 32.68% 000 - 496050 SSLG - SAWS Reservation - - 134,500.00 134,500.00 - (134,500.00) 0.00% 000 - 497000 Misc Income -W &S 40,000 468.48 52,942.18 5,889.30 - 34,110.70 14.72% 000 - 498110 Reimbursement -SSLGC 110,740 - 76,858.41 79,637.00 - 31,103.00 71.91% TOTAL Miscellaneous 165,440 784.30 277,838.27 225,411.18 - (59,97 >1.18) 136.25 %'; TOTAL REVENUES 19,383,115 1,442,376.23 13,161,240:92 14,145,819.07 5,237,295.93 72.98% WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 406,765.39 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,691.84 295,250.70 177, 518.55 256,441.73 675,169.34 1,064,372.78 $ 3,107,444.94 Total Cash in Bank & Investments $ 3,514,210.33 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET REVENUE SUMMARY Fees 5,583,983 519,084.09 3,880,563.26 4,528,181.21 - 1,055,801.79 81.09% Inter - Jurisdictional 1,556,828 325,183.78 1,369,042.46 1,523,494.16 - 33,333.92 97.86% Miscellaneous 239,500 3,072.94 90,910.27 93,992.94 - 145,507.06 39.25% TOTAL REVENUES 7,380,311 847,340.81 5,340,515.99 > 6,145;668.31 - 1,234,642.77 83.27% EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services 2,863,992 235,029.37 2,188,724.78 2,332,477.01 - 531,514.99 81.44% Supplies 354,984 6,679.63 260,592.20 247,731.64 44,325.14 62,927.22 82.27% Human Services 800 - 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 125,744 11,875.10 105,351.42 105,471.31 - 20,272.69 83.88% Operations Support 62,755 3,244.47 47,928.65 48,655.80 1,764.44 12,334.76 80.34% Staff Support 81,500 2,939.23 54,435.53 61,316.94 11,445.26 8,737.80 89.28% City Assistance 14,400 1,025.00 11,177.47 11,547.30 116.25 2,736.45 81.00% Professional Services 127,566 4,443.11 123,950.31 113,725.37 2,489.69 11,350.94 91.10% Fund Charges /Transfers 2,663,429 136,487.15 1,228,698.52 1,509,851.27 - 1,153,577.73 56.69% Maintenance Services 57,820 250.00 27,317.20 14,489.05 8,210.38 35,120.57 39.26% Debt Service 152,772 2,800.33 68,933.00 6,331.91 - 146,440.09 4.14% Rental- Leasing 82,000 - - - - 82,000.00 0.00% Operating Equipment 193,600 14,217.73 86,404.28 81,176.04 24,069.96 88,354.00 54.36% Capital Outlay 80,000 - - - - 80,000.00 0.00% TOTAL PUBLIC SAFETY 6,893,862 418,991.12 4,219 278.34 4,550,942.96 92,421.12 2,250,497.92` 67.36% TOTAL EXPENDITURES 6,893,862 418,991.12 4,219;278.34 4,550,942.961 92,421.12 2,250,497.92' 67.36 %? ** REVENUE OVER(UNDER) EXPENSES 486,449 1,594,725.35 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 203 -EMS CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Fees 000 - 456100 Ambulance /Mileage Transport 5,419,583 505,869.00 3,795,751.70 4,420,740.46 - 998,842.54 81.57% 000 - 456110 Subscription Program Fees 40,000 245.00 18,405.00 23,250.00 - 16,750.00 58.13% 000 - 456120 EMT Class - Fees 104,400 8,560.00 59,795.00 65,656.00 - 38,744.00 62.89% 000 - 456130 Immunization Fees - - 20.00 - - - 0.00% 000 - 456140 Billing Fees - Alamo Heights 20,000 1,640.09 5,926.56 15,714.75 - 4,285.25 78.57% 000 - 458110 Sales of Merchandise - GovDeal - 2,770.00 645.00 2,770.00 - (2,770.00) 0.00% 000 - 459200 NSF Check Fee - - 20.00 50.00 - (50.00) 0.00% TOTAL Fees 5,583;983 519,084.09 3,880,563.26 4,528,181.21 - 1,055;801.79 81.09% Inter - Jurisdictional 000 - 473500 Seguin /Guadalupe Co Support 286,126 23,843.88 170,463.22 262,282.68 - 23,843.32 91.67% 000 - 474300 Cibolo Support 253,757 63,439.20 228,830.20 253,756.80 - - 100.00% 000 - 475100 Comal Co ESD #6 90,694 7,590.70 86,752.61 75,907.00 - 14,787.08 83.70% 000 - 475200 Live Oak Support 170,178 43,594.20 165,187.96 174,376.80 - (4,199.04) 102.47% 000 - 475300 Universal City Support 240,149 60,037.20 233,107.40 241,548.80 - (1,400.00) 100.58% 000 - 475400 Selma Support 71,798 17,949.60 69,693.20 73,798.40 - (2,000.00) 102.79% 000 - 475500 Schertz Support 420,915 105,228.72 395,829.68 420,914.88 - - 100.00% 000 - 475600 Santa Clara Support 9,396 2,349.00 9,120.48 9,396.00 - - 100.00% 000 - 475800 Marion Support 13,815 1,151.28 10,057.71 11,512.80 - 2,302.56 83.33% TOTAL Inter - Jurisdictional 1,556;828 325,183.78 1,369,042.46 1,523,494.16 - 33',333.92 97.86 %> CITY O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JULY31nt,2014 2 013-2Q14 203-EMS CURRENT CURRENT PRIOR YEAR Y-T-D Y-T-D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y-T-D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Miscellaneous 000-491000 Interest Earned - - - 12.20 - (12.20) 0.0096 000-401200 Investment Income - - 344.08 - - - 0.0096 000-483203 Donations-EMS 2.000 50.00 852.00 80.00 - 1.920.00 4.0096 000-493204 Donations-Dilworth Fund 3.500 - - - - 3.500.00 0.0096 000-493205 DonoUons- GolfTounnoment 4.000 400.00 14.162.00 15.525.00 - /11.525.00\ 388.13% 008-407000 K8iao|nouma 130'000 2.472.04 70.587.90 74.732.66 - 55.267.44 57.40% 000-407100 Recovery of Bad Debt 100lX00 1501X0 496420 364312 -_ 8635688 2.75%� TOTAL Miscellaneous 25% TOTALREVENUES 7,380,311 847,340.81 5,340,515.99 6,145,668.31 - 1,234,642.77 83.27% SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 370,056.08 Total Cash in Bank & Investments $ 370,056.08 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 « * * * * * * * * * ** 2 0 1 3- 2 0 14 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR 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 451,350 33,108.17 279,619.39 292,431.23 Permits - 300.00 - 3,040.00 - (3,040.00) 0.00% Fees 1,041,000 88,587.79 855,300.38 856,431.54 - 184,568.46 129.08% Miscellaneous 1,700 73.25 2,999.02 893.48 - 806.52 56.91% TOTAL REVENUES 1,042,700 88,961.04 858,299.40 860,365.02 - 182,334.98 129.36% EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 451,350 33,108.17 279,619.39 292,431.23 - 158,918.77 64.79% Supplies 8,300 333.62 3,188.11 4,529.55 64.16 3,706.29 55.35% Human Services 325 - - 61.00 - 264.00 18.77% City Support Services 24,239 - 3,233.63 2,166.61 - 22,072.39 8.94% Utility Services 29,500 4,192.32 21,229.24 19,630.43 - 9,869.57 66.54% Operations Support 2,460 - - - - 2,460.00 0.00% Staff Support 7,625 808.17 2,674.25 4,115.57 158.53 3,350.90 56.05% City Assistance 840 - 75.00 - - 840.00 0.00% Professional Services 24,261 348.00 11,768.92 2,708.01 - 21,552.99 11.16% Fund Charges/Transfers 197,304 16,375.34 156,946.60 163,753.40 - 33,550.60 83.00% Maintenance Services 22,000 3,861.69 2,266.76 5,595.37 321.04 16,083.59 26.89% Other costs 200 - 100.00 200.00 - - 100.00% Debt Service 18,574 1,036.58 2,690.70 2,073.16 - 16,500.84 11.16% 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 60,063.89 637,592.12 532,890.13 543.73 290,176.14 64.77 % ) PROJECTS City Support Services 3,200 - - - - 3,200.00 0.00% Operations Support 1,000 - - - - 1,000.00 0.00% Professional Services 41,200 400.00 - 22,240.00 8,000.00 10,960.00 73.40% Maintenance Services 169,998 - - 16,800.00 - 153,198.00 9.88% TOTAL PROJECTS 215,398 400.00 ` - 39,040 00 8,000.00 168,358.00 21.84 % s' TOTAL EXPENDITURES 1,039,008 60,463.89> 637,592.12 571,930,13 8,543.73' 458,534.14 55.87 % ;, " REVENUE OVER(UNDER)!EXPEND 3,692 288,434.89 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 **************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 ****************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 204 - DRAINAGE CURRENT CURRENT PRIOR YEAR Y -T -D Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL ACTUAL ENCUMBR BALANCE BUDGET Permits 000 - 432400 Floodplain Permit - 300.00 - 3,040.00 - (3,040.00) 0.00% TOTAL Permits - 300.00 ' - 3,040.00 - (3;040.00) 0.00% Fees 000 - 457500 Drainage Penalties 5,000 684.65 6,435.40 7,052.13 - (2,052.13) 141.04% 000 - 457600 Drainage Fee 1,036,000 87,903.14 848,864.98 849,379.41 - 186,620.59 81.99% TOTAL Fees 1,041,000 88,587.79 855,300.38 856,431.54 - 184,568.46! 82.27°%' Miscellaneous 000 - 491000 Interest Earned 100 - 69.87 101.88 - (1.88) 101.88% 000 - 491200 Investment Interest 600 73.25 795.29 725.60 - (125.60) 120.93% 000 - 497000 Misc Income - Drainage 1,000 - 2,133.86 66.00 - 934.00 6.60% TOTAL' Miscellaneous ` 1,700% 73.25 2,999.02 893.48 - 806.52 52.56 %' TOTAL REVENUES 1,042,700- 88,961.04 858,299.40 860,365.02 - 182,334.98 82.51% DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking 434,507.91 Cash in Investments Lone Star Investment - Drainage Maint Fund 605,577.01 Total Cash in Bank & Investments $ 1,040,084.92 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 2 0 1 3- 2 0 14 314 -HOTEL TAX CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF FINANCIAL SUMMARY BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 485,000 51,002.04 341,655.61 341,628.53 - 143,371.47 70.44% Fund Transfers 173,810 - - - - 173,810 0.00% Miscellaneous 550 24.18 446.57 29159 - 256.41 53.38% TOTAL REVENUES 659,360 51,026.22 ? 342,102.18 341,922.12 - 317,437.88 51.86 %! EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,000 - - - - 2,000.00 0.00% City Support Services 66,787 12,907.00 71,759.56 59,128.00 - 7,659.00 88.53% Operations Support 47,841 2,772.00 19,021.65 20,780.66 4,061.82 22,998.52 51.93% Professional Services 5,625 - 11,685.00 2,800.00 - 2,825.00 49.78% Fund Charges /Transfers 435,107 130,337.42 131,264.20 262,876.20 - 172,230.80 60.42% Maintenance Services 26,632 - - 23,462.00 - 3,170.00 88.10% Operating Equipment 55,368 955.00 43,332.37 8,665.59 1,712.60 44,989.81 18.74% Capital Outlay 20,000 - - - - 20,000.00 0.00% TOTAL NONDEPARTMENTAL 659,360 146,971.42 277,062.78 377,712.45 5,774.42 275,873.13 58.16 %< TOTAL EXPENDITURES 659,360 146,971.42 277,062.78 377,712.45 5,774.42 275,873.13 58.16% REVENUE OVER(UNDER) EXPENDITURE - (35,790.33} CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 14 314 -HOTEL TAX 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 Taxes 000 - 411800 Hotel Occupancy Tax 485,000 51,002.04 341,655.61 341,628.53 - 143,371.47 70.44% TOTAL Taxes 485,000 51,002.04 341,655.61 341,628.53 - 143,371.47 ` 70.44 %` 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 - 47.75 56.91 - (6.91) 113.82% 000 - 491200 Investment Interest 500 24.18 398.82 236.68 - 263.32 47.34% TOTAL Miscellaneous 550 24.18 446.57 293.59 256.41 53.38% TOTAL REVENUES 659,360 51,026.22 342,102.18 341,922.12 - 317;437.88 51.86 %' HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 135,319.92 Cash in Investments MBIA - Hotel Tax 299,139.25 Total Cash in Bank & Investments $ 434,459.17 HOTEL OCCUPANCY TAX $70,000 $60,000 $50,000 - - - - - - - - - - ----------------- - -- -- -- - -- - $40,000 - - - - - - - - - - - - $30,000 oor $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 48,081 49,579 54,858 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 - - - -- -6-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: JULY 31st, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 317 -PARK CURRENT CURRENT PRIOR YEAR 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 Parkland Dedication Fees 150,000 68,000.00 192,000.00 120,150.00 - 29,850.00 80.10% Miscellaneous 300 0.04 196.08 11.52 - 288.48 3.84% TOTAL REVENUES 150,300 68,000.04 192,196.08 120,161.52 - 30,138.48 79.95% 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,38630 - - - 0.00% Capital Outlay 27,160 - - - - 27,160.00 0.00% TOTAL PARKLAND DEDICATION 40,000 - 143,81530 - 40,000.00 0.00% TOTAL EXPENDITURES 40,000 - 143,815.30 - - ;40,000.00 0.00% REVENUE OVER(UNDER) EXPEND 110,300 120,161.52 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 k********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 317 -PARK CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBRANCE BALANCE BUDGET Fees 000 - 458800 Parkland Dedication 150,000 68,000.00 192,000.00 120,150.00 - 29,850.00 80.10% TOTAL Fees 150,000 68,000.00 192,000.00 120,150.00 - 29,850.00 80.10% Miscellaneous 000 - 491000 Interest Earned - - 31.99 10.12 - (10.12) 0.00% 000 - 491200 Investment Interest 300 0.04 164.09 1.40 - 298.60 0.47% TOTAL Miscellaneous 300 0.04 196.08 11.52 - 288.48 3.84 %' TOTAL REVENUES 150,300 68,000.04 192,196.08 120,161.52 - 30,138.48 79.95% PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $125,611.26 Cash in Investments IVIBIA Investment-Park Fund 1,354.59 Total Cash in Bank & Investments $126,965.85 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *, 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR 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 Tree Mitigation Fees 35,000 - 600.00 227,757.50 - (192,757.50) 650.74% Miscellaneous 104,525 7.79 1,820.74 155.07 - 104,369.93 0.15% TOTAL REVENUES 139,525 ! 7.79 2,420.74 227,912.57 - (88,387.57) 163.35% EXPENDITURE SUMMARY TREE MITIGATION Maintenance Services -Trees 139,525 - 57,730.00 39,956.30 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,956.27 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 k********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 319 -TREE MITIGATION CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% 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 - 20.09 78.71 - (28.71) 157.42% 000 - 491200 Investment Interest 150 7.79 110.65 76.36 - 73.64 50.91% 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.79 1,820.74 155.07 - 104,369.93 0.15% TOTAL REVENUES 139`,525 7.79 2,420.74 227,912.57 - (88,387.57) 163.35% TREE MITIGATION FUND CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $248,291.06 Cash in Investments MBIA Investment-Tree Mitigation 97,323.99 Total Cash in Bank & Investments $345,615.05 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 411 - CAPITAL RECOVERY WATER CURRENT CURRENT PRIOR YEAR 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 Fees 880,200 46,944.00 715,896.00 673,353.00 - 206,847.00 76.50% Fund Transfers 1,425,609 - - - - 1,425,609.00 0.00% Miscellaneous 20,300 446.60 49,133.71 4,616.41 - 15,683.59 22.74% TOTAL REVENUES ? 2,326,109 ! 47,390.60 765,029.71 677,969.41 - 1,648,139.59 29.15% 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,000.00 - 450,109.00 0.44% MISC & PROJECTS Water Projects 1,750,000 - 9,747.78 - 186,732.71 1,563,26729 10.67% TOTAL MISC & PROJECTS 1,750,000 - 9,747.78 - 186,732.71 1,563,267.29 10.67 %< TOTAL EXPENDITURES 2,202,109 - 13,795.28 2,000.00 186,732.71 2,013,37629 8.57% REVENUE OVER(UNDER) EXPENDITURES 124,000 675',969 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 411 - CAPITAL RECOVERY WATER 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 Fees 000 - 455900 Capital Recovery - Water 880,200 46,944.00 715,896.00 673,353.00 - 206,847.00 76.50% TOTAL Fees) 880,200 46,944.00 715,896:00 673,353.00 206,847.00 76.50% 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 - 22,397.99 192.44 - 107.56 64.15% 000 - 491200 Investment Income 45,000 446.60 46,011.99 4,423.97 - 40,576.03 9.83% 000 - 491800 Gain /Loss - - (2,059.00) - - - 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One (25,000) - (17,217.27) - - (25,000.00) 0.00% TOTAL Miscellaneous 20,300 446.60 49,133.71 4,616.41 - 15,683.59 22.74 %' TOTAL REVENUES 2,326,109 47,390.60 765,029.71 677,969.41 - 1,648,139.59 29.1!5% CAPITAL RECOVERY WATER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $1,022,243.29 Cash in Investments Lone Star Investment - Capital Recovery Water 3,692,167.20 Total Cash in Bank & Investments $4,714,410.49 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3- 2 0 1 4********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 421 - CAPITAL RECOVERY SEWER CURRENT CURRENT PRIOR YEAR 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 Fees 569,760 (73,716.00) 449,095.44 364,493.90 - 205,266.10 63.97% Fund Transfers - - - - - - 0.00% Miscellaneous - (411.27} - 9,915.27 - (9,915.27) 0.00% TOTAL REVENUES 569,760 (74,127.27) 449,095.44 374,409.17 - 195,350.83 65.71% EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 4,000 358.97 5,603.65 3,573.70 - 426.30 89.34% Fund Charges /Transfers 120,000 - - - - 120,000.00 0.00% TOTAL NON DEPARTMENTAL 124,000 358.97 5,603:65 3,573.70 120,426.30 2.88% MISC & PROJECTS Sewer Projects - - 121,826.30 6,042.30 - (6,042.30) 0.00% TOTAL MISC`& PROJECTS - - 1`21,826.30 6,042.30 (6,042.30) 0.00% TOTAL EXPENDITURES 124,000 358.97 127,429.95 9,616.00 - 114,384.00 7.75 %1 REVENUE OVER(UNDER) EXPENDITURES 445,760 364,793 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 421 - CAPITAL RECOVERY SEWER 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 Fees 000 - 455910 Capital Recovery- Waste Wtr 500,400 21,684.00 371,695.44 363,827.90 - 136,572.10 72.71% 000 - 455913 Cap Recovery-North Sewer Tr 69,360 (95,400.00) 77,400.00 666.00 - 68,694.00 0.96% TOTAL Fees; 569,760 (73,716.00) 449,095.44 364,493.90 205,266.10 6197% Miscellaneous 000 - 491000 Interest Earned - - - 104.59 - (104.59) 0.00% 000 - 491200 Investment Income - 2,307.38 - 26,479.45 - (26,479.45) 0.00% 000 - 491800 Gain /Loss - - - (40,015.93) - 40,015.93 0.00% 000 - 491900 Unrealized Gain /Loss -Cap One - (2,718.65) - 23,347.16 - (23,347.16) 0.00% TOTAL Miscellaneous (411.27) - 9,915.27 - (9,915.27) 0.00% TOTAL REVENUES 569,760 (74,127.27) 449,095.44 374,409.17 - 195,350.83 65.71% CAPITAL RECOVERY SEWER CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 581,125.95 Cash in Investments Lone Star Investment - Capital Recovery Sewer 1,451,342.72 Capital One - Investment 1,724,907.65 Total Cash in Bank & Investments $3,757,376.32 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ********************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 505 -TAX I &S CURRENT CURRENT PRIOR YEAR 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 Taxes 5,204,493 16,597.95 5,037,570.08 5,276,889.71 - (72,396.71) 101.39% Fund Transfers 1,069 - - - - 1,069.00 0.00% Miscellaneous 391,213 140.00 363,270.82 346,418.83 - 44,794.17 88.55% TOTAL REVENUES 5,596,775 16,737.95 5,400,840.90 5,623,308.54 - (26,533.54) 100.47 %> EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services 42,350 600.00 950.00 1,750.00 - 40,600.00 4.13% Debt Service 5,554,425 729,037.84 4,642,144.00 5,050,321.70 - 504,103.30 90.92% TOTAL GENERAL GOVERNMENT 5, 596 ,775 729,637.84 4,643,094.00 5,052,071.70 544,703.30 90.27% TOTAL EXPENDITURES 5,596,775 729,637.84 4,643,094.00 5,052,071.70 - 544,703.30 90.27% "REVENUE OVER(UNDER) EXPEND - 571,236.84 CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 ********************* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 1 4 505 -TAX I & S CURRENT CURRENT PRIOR YEAR CURRRENT Y -T -D BUDGET 83.33% OF REVENUES BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Taxes 000-411900 Property Tax Revenue 5,204,493 16,597.95 5,037,570.08 5,276,889.71 - (72,396.71) 101.39% TOTAL Taxes 5,204,493 16,597.95 5,037,570.08 ` 5,276,889.71 - (72,396.71) 101.39% 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 - 56.26 48.77 - 26.23 65.03% 000 - 491200 Investment Earnings 25,000 140.00 25,631.84 1,30131 - 23,698.69 5.21% 000 - 495015 Contribution from SED 366,138 - 344,006.25 345,068.75 - 21,069.25 94.25% 000 - 497000 Misc Income - - (6,423.53) - - - 0.00% TOTAL Miscellaneous 391,213 140.00 363,270.82 346,418:83 - 44,794.17 88.55 %' TOTAL'REVENUES 5,596,775 16,737.95 5,400,840.90 5,623,308.54 - (26,533.54) 100.47 %` CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 2014 505 -TAX I& S k******************** * * * * * * * * * * * * * * * * * * * * * * * * * * * * * ** 2 0 1 3 - 2 0 14 GENERAL GOVERNMENT CURRENT CURRENT PRIOR YEAR CURRENT Y -T -D BUDGET 83.33% OF NON DEPARTMENTAL BUDGET PERIOD Y -T -D ACTUAL Y -T -D ACTUAL ENCUMBR BALANCE BUDGET Professional Services 101- 541500 Paying Agent 2,350 600.00 400.00 1,750.00 - 600.00 74.47% 101 - 541502 Cost of Bond Issuance 40,000 - 550.00 - - 40,000.00 0.00% TOTAL Professional Services 42,350 600 950.00 1,750.00 - 40,600.00 4.13 %' 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,833.33 109,533.33 112,833.33 - 0.67 100.00% 101 - 555628.1 CO Bond 2007- Interest 14,106 7,052.93 18,498.14 14,105.86 - 0.14 100.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 87,320.16 189,418.72 179,321.52 - 470.48 99.74% 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 161,689.50 349,088.25 332,258.50 - 0.50 100.00% 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 176,918.75 367,237.50 358,037.50 - 0.50 100.00% 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 68,808.78 153,067.41 144,941.53 - 974.47 99.33% 101 - 555635 GO SR2012 Principal 285,000 - 295,000.00 285,000.00 - - 100.00% 101 - 555635.1 GO SR2012 Interest 219,284 106,079.38 233,783.76 219,28176 - 0.24 100.00% 101 - 555636 Tax Note - SR2013 - Principal 160,000 - - 160,000.00 - - 100.00% 101 - 555636.1 Tax Note - SR2013 - Interest 11,223 4,142.50 - 11,22238 - 0.62 99.99% 101 - 555637 Tax Note - SR 2013A - Principal 155,000 - - 155,000.00 - - 100.00% 101 - 555637.1 Tax Note - SR2013 - Interest 11,040 4,192.51 - 11,039.18 - 0.82 99.99% TOTAL Debt Service? 5,554,425 729,037.84 4,642,144.00 5,050,321.70 - 504,103.30 90.92% TOTAL EXPENDITURES 5,596,775 ` 729',637.84 4,643,094.00 5,052,071`.70 - '' 544,703:30 90.27 %' TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool-Checking $ 311,869.87 Cash in Investments IVIBIA Investment- Tax I&S 776,565.59 Total Cash in Bank & Investments $1,088,435.46 620 -SED CORPORATION FINANCIAL SUMMARY CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JULY 31st, 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 83.33% OF BALANCE BUDGET REVENUE SUMMARY Taxes 3,440,944 236,816.88 2,643,341.29 2,912,378.58 - 528,565.42 84.64% Miscellaneous 10,175 421.29 6,957.78 6,764.96 - 3,410.04 66.49% TOTAL REVENUES 3,451;119 237,238.17 2,650,299.07 2,919,143.54 - 531,975.46 84.59% EXPENDITURE SUMMARY ECONOMIC DEVELOPMENT Personnel Services 326,237 17,340.14 233,42137 243,560.26 - 82,676.74 74.66% Supplies 1,250 43.33 481.88 464.13 6.76 779.11 37.67% 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 212.52 936.49 1,522.43 - 1,272.57 54.47% Operations Support 148,200 26,776.70 96,545.31 94,637.96 519.56 53,042.48 64.21% Staff Support 18,050 1,944.57 3,636.73 5,185.43 2,195.07 10,669.50 40.89% City Assistance 1,325,000 1,446.04 587.95 501,524.63 - 823,475.37 37.85% Professional Services 102,500 - 61,934.99 16,132.41 - 86,367.59 15.74% Fund Charges /Transfers 503,605 11,353.75 549,482.95 448,168.97 - 55,436.03 88.99% Debt Service 427,672 157,401.25 428,503.50 427,671.25 - 0.75 100.00% Operating Equipment 2,500 - 362.23 38.99 - 2,461.01 1.56% TOTAL ECONO DEVELOPMENT 2,874,554 216,518.30 1,377,105.45 1,7440,080.75 2,721.39'> 1,131,751.86 60.63% 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 216,518.30 1,377,105.45 1,740,080.75 2;721.39 1,331,751.86 56.68% " REVENUE OVER(UNDER) EXPEND 376,565 ` 1,179,062.79 620 -SED CORPORATION REVENUES CITY OF SCHERTZ REVENUE REPORT (UNAUDITED) AS OF: JULY 31st, 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 83.33% OF BUDGET Taxes 000 - 411500 Sales Tax Revenue (46) 3,440,944 236,816.88 2,643,341.29 2,912,378.58 - 528,565.42 84.64% TOTAL Taxes 3,440,944 236,816`.88 2,643,341.29 ! 2,912,378.58 - 528,565.42 84.64% Miscellaneous 000 - 491000 Interest Earned 175 - 92.57 227.78 - (52.78) 130.16% 000 - 491200 Investment Earnings 10,000 421.29 6,865.21 6,537.18 - 3,462.82 65.37% TOTAL Miscellaneous 10,175 421.29 6,957.78 6,764.96 - 3,410 66.49°/x! TOTAL REVENUES 3,451,119 237,238.17 2,650,299.07 ? 2,919,143.54 - 531,975.46 84.59 %` SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JULY 31st, 2014 Cash in Bank Claim on Operating Cash Pool- Checking $ 177,093.90 Cash in Investments MBIA Investment - Economic Development Corp 5,216,000.92 Schertz Bank & Trust - Certificate of Deposit 1,044,185.44 Total Cash in Bank & Investments $ 6,437,280.26 4B SALES TAX C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st, 2014 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JULY 31st, 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 7,027,060.97 0.0500 5,972,402.11 5,658,691.99 264.24 7,341,035.33 7,341,035.33 7,341,035.33 N/A Schertz Bank & Trust - PEG Fund 421,789.80 0.0000 - - - 421,789.80 421,789.80 421,789.80 N/A TOTAL OPERATIONS 'x7,448 .850.77 ;:5,972,402.11 c;. 5,658,691.99 264.24 7,762,825.13 7.:,762,.825;13 :?7,762,825.13 - - LOGIC General Fund 6,953,031.71 0.0989 - 1,314,736.00 580.60 5,638,876.31 5,638,876.31 5,638,876.31 N/A 51 Days G /F- Equipment Replacement 73,631.01 0.0989 - - 6.19 73,637.20 73,637.20 73,637.20 N/A 51 Days G /F- Vehicle Replacement 211,205.42 0.0989 - - 17.77 211,223.19 211,223.19 211,223.19 N/A 51 Days G/F -Air Conditioner Replacement 171,529.23 0.0989 - - 14.43 171,543.66 171,543.66 171,543.66 N/A 51 Days SR2009 Bond- Street Projects(II) 1,033,296.17 0.0989 - 3,381.07 86.83 1,030,001.93 1,030,001.93 1,030,001.93 N/A 51 Days TOTAL SLOGIC 8,442,693.54 - 1,318,117.07 705.82: 7,125,282.29 7,125,282.29 7,125 282.29 LONESTAR Capital Recovery - Sewer 1,451,167.17 0.1400 - - 175.55 1,451,342.72 1,451,342.72 1,451,342.72 N/A 62 Days Capital Recovery - Water 3,691,720.60 0.1400 - - 446.60 3,692,167.20 3,692,167.20 3,692,167.20 N/A 62 Days Drainage Fund 605,503.76 0.1400 - - 73.25 605,577.01 605,577.01 605,577.01 N/A 62 Days Facilities Master Plan 95,098.88 0.1400 - - 11.50 95,110.38 95,110.38 95,110.38 N/A 62 Days GO SR2011 Animal Shelter 35,900.10 0.1400 - - 4.34 35,904.44 35,904.44 35,904.44 N/A 62 Days GO SR2011 Athletic Fields 877,428.28 0.1400 - - 106.15 877,534.43 877,534.43 877,534.43 N/A 62 Days GO SR2011 Soccer Fields 576,262.26 0.1400 - - 69.71 576,331.97 576,331.97 576,331.97 N/A 62 Days GO SR2011 Swimming Pool 6,004,185.83 0.1400 - - 726.34 6,004,912.17 6,004,912.17 6,004,912.17 N/A 62 Days GO SR2012 Downtown Improvements 1,002,935.37 0.1400 - - 121.33 1,003,056.70 1,003,056.70 1,003,056.70 N/A 62 Days Sewer /CCMA Project 2,057,994.80 0.1400 - - 248.96 2,058,243.76 2,058,243.76 2,058,243.76 N/A 62 Days W /S- Customer Deposits 295,214.99 0.1400 - - 35.71 295,250.70 295,250.70 295,250.70 N/A 62 Days W /S- Equipment Repl /Cap.Imp 177,497.08 0.1400 - - 21.47 177,518.55 177,518.55 177,518.55 N/A 62 Days Water &Sewer 638,614.58 0.1400 - - 77.26 638,691.84 638,691.84 638,691.84 N/A 62 Days W /S- Vehicle Replacement 256,410.71 0.1400 - - 31.02 256,441.73 256,441.73 256,441.73 N/A 62 Days Water /SSLG - SAWS 675,087.67 0.1400 - - 81.67 675,169.34 675,169.34 675,169.34 N/A 62 Days TOTAL LONESTAR. = 18,441.:022.08 _ - _ - 2,230.86' 18,443,252.94 18,443,252.94 18,443,252.94 TEXAS CLASS Tax I &S 1,798,577.59 0.1000 - 1,022,152.00 140.00 776,565.59 776,565.59 776,565.59 N/A 68 Days Police Forfeiture 338,908.32 0.1000 - - 27.32 338,935.64 338,935.64 338,935.64 N/A 68 Days Park Fund 1,354.55 0.1000 - - 0.04 1,354.59 1,354.59 1,354.59 N/A 68 Days Economic Development Corporation 5,215,579.63 0.1000 - - 421.29 5,216,000.92 5,216,000.92 5,216,000.92 N/A 68 Days Library Board 44,844.03 0.1000 - - 3.68 44,847.71 44,847.71 44,847.71 N/A 68 Days Tree Mitigation 97,316.20 0.1000 - - 7.79 97,323.99 97,323.99 97,323.99 N/A 68 Days Tax Note 2013 Fire Truck 4,928.71 0.1000 - - 0.35 4,929.06 4,929.06 4,929.06 N/A 68 Days Hotel Tax 299,115.07 0.1000 - - 24.18 299,139.25 299,139.25 299,139.25 N/A 68 Days Special Events Fund 16,780.07 0.1000 - - 1.28 16,781.35 16,781.35 16,781.35 N/A 68 Days Citywide Projects SR2007 811,388.43 0.1000 - 8,183.28 65.42 803,270.57 803,270.57 803,270.57 N/A 68 Days Tax Note 2013 A P25 24,207.49 0.1000 - - 1.90 24,209.39 24,209.39 24,209.39 N/A 68 Days TOTAL :::TEXAS "CLASS 1:8,653 000.09 - x1,030)335.28 693::25= 7..623,358:.06 7:,623,358:.06 7,623 358.06 C I T Y 0 F S C H E R T INVESTMENT POINT FOR MONTH ENDING JULY 31nt, 2014 aeg -T ing Interest. Eft ag ,mot � Par waturlty.. ... Capital One General Fund 1:.,358 „905.,67 1.32{747.. -. 279:99 628.061: a2ak 1,359,253,69 1,345,514.67 1,323,674;94 K /.A 547 Days Capital,. One Capital R000very Sewer 1,766,082,63 1,4500 - 358'...97 1,063,90. 1,746,787.56 1,724,907.65 :1,594,846,44 N/A 559 days Tom C7s.1+3'tAt OM 3:x.,104,988::30 638.96 1.,691.91 3,106,042,25:: 3,070,422.32 3,018,521,39 C. ml remmFS cap PX8R elm lam 8R&1'- Water3Sewet 1,064,372;.18 8.4000 : ®: ®.. 1,064,372,118:. 118661775.54 1,064,372:.78 1/712015.:. 355 Days SCherts... Ecaaamic Development Corp. 1,044,185,44 0.6000 - 1,044,185,44: 1,045,026.51 1,,044,165 -,44 12/10/2014 180 Days 1't7"TAL C'.,D,s 2,108,558 22 - 2,108,$58a22? 2,111,802.15 2,108,55822 TOTAL PORt1 T1,10 0,25 $ 5;586.08 $ 46, IL69,317. 89 46,.136,942.639 $ 46,081,196..,02 106 .... Days: L ".a t, }r °::2a ;.rfR'.xectattve 't is'erCor. F1nr,tnce Director Assjatana Fire >nc� Dir zt-ar . ,,... -' J7ancij.2 Analyst .. TOTAL TEXAS CLASS 160 City Portfolio By Investment Type TOTAL LONESTAR 400 TOTAL LOGIC 150 0 Special RevenUE Funds, $14,471,775.48 0 Debt Servic $776, 56` City Portfolio By Use M Designated Funds, $1,276,382.54 m Projects, $13,159,535.69 Operations, $16,452,683.59 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 0.0200 0.0100 03 Month T -Bill 0.0400 0.0600 0.0700 0.0200 0.0500 0.0500 0.0300 0.0400 0.0400 0.0300 06 Month T -Bill 0.0800 0.1100 0.1000 0.0600 0.0800 0.0700 0.0500 0.0600 0.0700 0.0500 OSchertz Portfolio 0.2879 0.2857 0.2394 0.2315 0.2227 0.2324 0.2254 0.2303 0.2438 0.2457 ®Schertz Bank &Trust 0.0500 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 ...... 000 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 -- --- ___ - 0.6000 ------------------ ®LOGIC -- 0.1183 ------ 0.1085 __ -_ 0.0965 0.0884 _ _ -_ _____ 0.0824 _ 0.0874 - -- 0.0829 - -- - - 0.0989 - - -- _ 0.1087 - _ -- - 0.0989 - -- ------ --- - - - - -- - - - - -- -_ DLoneStar ------ 0.1500 _ 0.1500 0.1600 - -- - 0.1400 - - 0.1200 - _ 0.1300 0.1400 - - 0.1400 - -- - 0.1500 - - -- ------------------ 0.1400 OMBIA 0.0900 0.1000 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 1.3939 C I T Y OF S C H E R T Z Investment Report Capital One Assets Date: 7/31/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,846.44 29,846.44 29,846.44 19.00 0.06 Total Cash & Equivalents 29,846.44 29,846.44 29,846.44 19.00 0.06° Fixed Income Projected Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 503.00 200,000.00 230,779.00 212,688.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,448.80 1,650.00 58,674.94 58,674.94 58,674.94 37.00 0.06 Total Cash & Equivalents 1,125.00 0.75 58,674.94 58,674.94 58,674.94 37.00 0.06° Fixed Income 1.34 US Treasury Note 5/31/2016 670.00 350,000.00 364,567.38 358,218.00 6,125.00 Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 503.00 100,000.00 116,185.00 106,344.00 4,875.00 4.20 0.63 Federal Natl Mtg Assn 1/30/2017 914.00 100,000.00 102,366.80 100,915.00 1,250.00 1.22 Total Assets ? Federal Home Ln Mtg Corp Reference Nts 11/25/2014 117.00 200,000.00 200,609.40 200,408.00 1,500.00 0.75 US Treasury Note 3/15/2017 958.00 100,000.00 99,835.94 99,731.00 750.00 0.75 US Treasury Note 11/30/2015 487.00 60,000.00 61,936.72 60,901.20 825.00 1.33 US Treasury Note 5/31/2016 670.00 325,000.00 337,135.74 332,631.00 5,687.00 1.69 US Treasury Note 8/31/2016 762.00 275,000.00 277,401.37 277,354.00 2,750.00 0.99 US Treasury Note 9/15/2014 46.00 105,000.00 105,107.78 105,028.35 262.00 0.25 Total Fixed Income 1,265,000.00 1,300,578.75 1,283,312.55 17,899.00 1.380 Total Assets ` 546.90 1,323,674.94 1,359,253.69 1,341,987.49 17,936.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,846.44 29,846.44 29,846.44 19.00 0.06 Total Cash & Equivalents 29,846.44 29,846.44 29,846.44 19.00 0.06° Fixed Income Federal Farm Cr Bks Cons Systemwide Bds 12/16/2015 503.00 200,000.00 230,779.00 212,688.00 9,750.00 4.22 Federal Natl Mtg Assn 12/21/2015 508.00 100,000.00 99,989.10 100,061.00 375.00 0.38 Federal Home Ln Mtg Corp Reference Nts 11/25/2014 117.00 220,000.00 220,078.68 220,448.80 1,650.00 0.75 US Treasury Note 3/15/2017 958.00 150,000.00 149,753.91 149,596.50 1,125.00 0.75 US Treasury Note 11/30/2015 487.00 305,000.00 312,082.23 309,581.10 4,193.00 1.34 US Treasury Note 5/31/2016 670.00 350,000.00 364,567.38 358,218.00 6,125.00 1.68 US Treasury Note 7/15/2016 715.00 340,000.00 339,690.82 340,632.40 2,125.00 0.63 Total Fixed Income 1,665,000.00 1,716,941.12 1,691,225.80 25,343.00 1.480 Total Assets ? 558.29 1,694,846.44 ;1,746,787.56 1,721,072.24 25,362.'00 1.45%