Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
11-AUGUST 2012 FINANCIAL STATEMENT
AUGUST 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department September 27, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725453,333.40 10,287,191.35-11,744,971.94 58,753.06 Franchises 1,617,000 155,736.42 1,186,146.66- 1,433,156.79 - 183,843.21 Permits 1,187,800 71,042.15 1,558,508.58- 965,549.25 - 222,250.75 Licenses 48,300 6,890.00 59,255.60- 65,852.50 - (17,552.50) Fees 3,324,727 273,718.41 2,466,784.35- 2,677,816.36 - 646,910.64 Fines 30,000 2,553.28 24,173.36- 25,947.27 (20.91) Inter-Jurisdictional 571,245 27,117.16 373,633.36- 537,047.62 - 34,197.38 Fund Transfers 1,760,658 105,881.84 1,065,052.83- 1,206,500.53 - 554,157.47 Miscellaneous791,01043,272.38449,512.80497,861.64(71.90) - TOTAL REVENUES21,134,4651,139,545.0417,470,258.8919,154,703.90(92.81) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 2,049.45 20,812.37- 19,223.14 - Supplies 700 - - 397.80 595.14 79.48 City Support Services 18,000 65.00 13,447.67- 7,669.38 304.21 Operations Support 100 - - 190.95 - - Staff Support19,900141.11 16,597.86 -13,578.19 - Operating Equipment -- - - - - TOTAL CITY COUNCIL61,5002,255.56 48,426.98-44,085.52383.69 CITY MANAGE R Personnel Services 853,063 105,204.24 649,495.59- 771,920.65 - 81,142.35 Supplies 4,731 59.00 - 1,515.91 2,913.82 220.90 Operations Support - - - 45.00 - - Staff Support 30,400 1,415.68 23,306.01- 24,977.21 1,007.00 Operating Equipment -1,596.70 - - - - TOTAL CITY MANAGER 888,194 106,678.92 675,914.21- 799,856.68 1,227.90 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services259,269 27,587.56 215,600.71- 231,652.00 - 27,617.00 Supplies2,500 8.57 - 1,837.35 1,457.07 155.15 887.78 City Support Services1,000 1,000.00 - 293.00 1,000.00 - Operations Support 3,000 - - 1,951.00 2,506.00 - Staff Support 5,500 240.54 - 2,348.48 2,616.08 62.48 Court Support 800 - - - - - Professional Services 71,100 5,376.24 45,190.25- 48,617.46 4,471.35 Maintenance Services 2,200 - - 800.00 1,499.94 - Operating Equipment1,000 497.14900.00 - - - TOTAL MUNICIPAL COURT 34,212.91346,369 - 268,920.79 289,845.69 4,688.98 51,834.33 CUSTOMER RELATIONS-311 Personnel Services110,839 11,368.37 73,415.41- 91,573.32 - 19,265.68 Supplies300 - - 380.33 150.61 17.00 132.39 Staff Support1,018 1,069.97636.2074.22 - - Operating Equipment500 213.00- - - - TOTAL CUSTOMER RELATIONS-311 112,657 11,368.37 74,865.71- 92,573.13 91.22 PLANNING & ZONING Personnel Services 140,707 14,943.33 118,177.78- 125,033.70 - 15,673.30 Supplies 2,472 65.37 - 492.31 1,214.75 343.79 Operations Support 435 - - 77.95 - 78.00 Staff Support 17,412 250.00 - 4,747.25 2,459.35 3,293.00 Professional Services 76,931 8,501.98 66,236.08- 69,803.04 31.20 Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING241,45723,760.68 190,786.37-200,622.843,745.99 LEGAL SERVICES Operations Support 13,000 677.79 - 9,199.04 1,379.56 - 11,620.44 Professional Services245,00082,337.52202,798.51400,203.24 - - TOTAL LEGAL SERVICES 258,000 83,015.31 211,997.55- 401,582.80 - (143,582.80) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services649,236 65,575.08 551,767.27- 539,521.86 - 109,714.14 Supplies66,535 2,673.75 - 55,266.49 60,424.69 2,135.10 3,975.21 Utility Services112,000 9,924.53 - 73,317.74 81,501.18 47.35 30,451.47 Staff Support13,179 332.29 - 9,468.34 9,192.15 253.53 3,733.32 Maintenance Services99,119 5,357.65 - 105,532.22 86,147.88 7,078.33 5,893.04 Rental/Leasing400 - - 763.92 331.59 - Operating Equipment3,396 6,554.332,789.01 - - - Capital Outlay24,500 --2,312.34 - - TOTAL FACILITIES MAINTENANCE 968,365 83,863.30 802,670.31- 779,908.36 11,826.65 CITY SECRETAR Y Personnel Services 165,391 18,388.93 143,983.66- 149,478.48 - 15,912.52 Supplies1,250 32.79 - 1,365.19 939.52 52.35 258.13 City Support Services9,780 - - 6,788.22 2,606.65 - Staff Support8,605586.20 6,693.103,801.94392.40 - TOTAL CITY SECRETARY 185,026 19,007.92 155,939.01- 159,717.75 444.75 NON-DEPARTMENTA L Supplies2,500--405.3510.71 - City Support Services 577,781 4,607.27 285,383.67- 251,718.02246,762.25 Operations Support 139,000 15,808.56 125,112.42- 130,714.37 18.95 Staff Support 6.08 - 80.00 96.90 - - City Assistance 459,046 - 422,942.47- 481,160.88 - (22,114.88) Professional Services 174,650 2,509.89 55,521.22- 76,519.14 2,902.50 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - 98,185.61- - - 10,850.00 Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,363,827 22,931.80 987,630.74- 940,220.02249,683.70 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services271,136 31,212.23 134,438.83- 247,142.01 - 23,993.99 Supplies2,900 (25.98) - 953.81 2,650.02 84.93 165.05 Operations Support34,585 12,487.50 - 19,230.47 26,548.75 3,871.22 4,165.03 Staff Support4,865 - - 2,230.45 3,418.08 391.49 1,055.43 Operating Equipment300 -2,737.18 - - - TOTAL PUBLIC AFFAIRS 313,786 43,673.75 159,590.74- 279,758.86 4,347.64 RECORDS MANAGEMEN T Personnel Services 48,281 5,104.19 40,552.53- 43,311.36 - Supplies 750 - - 343.79 259.47 - Staff Support 1,500 - - 845.14 1,109.75 - Professional Services 15,000 182.00 10,333.51- 6,812.66 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,531 5,286.19 52,074.97- 51,493.24 - 14,037.76 SCHERTZ TALES MAGAZINE Personnel Services 129,900 14,506.36 110,117.39- 118,159.18 - 11,740.82 Supplies 200 60.84 - - 105.84 69.99 Opperations Support 200 - - 49.58 - - Staff Support 1,500 462.00 - 15.00 1,082.64 12.95 Professional Services302,70047,232.49229,477.44276,210.13 - 10,583.75 TOTAL SCHERTZ TALES MAGAZINE 434,500 62,261.69 339,659.41- 395,557.79 10,666.69 ENGINEERING Personnel Services 124,267 6,713.09 143,334.75- 63,364.24 - 60,902.76 Supplies 1,400 - - 242.15 375.05 808.95 Utility Services 600 59.87 - - 339.17 - Staff Support 2,013 - - 1,124.12 313.95 143.90 Professional Services 85,220 3,552.50 19,066.25- 74,227.50 - 10,992.50 Maintenance Services 4,044 - - 2,844.24 3,345.29 - Operating Equipment3,200 -1,638.30 - - - Capital Outlay26,000 23,714.00-58.99 - - TOTAL ENGINEERING 246,744 10,325.46 166,611.51- 167,317.50 1,011.84 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,941 13,342.45 101,959.97- 110,141.42 - 12,799.58 Supplies3,500 - - 1,451.62 1,450.37 478.53 1,571.10 Staff Support4,050 - - - - - Professional Services2,000 14.00- - - - TOTAL GIS 132,491 13,342.45 103,411.59- 111,605.79 478.53 TOTAL GENERAL GOVERNMENT 5,618,447 521,984.31 4,238,499.89- 4,714,145.97288,597.58 PUBLIC SAFETY POLICE Personnel Services4,552,349 474,611.45 3,658,494.05- 4,002,892.38 - 549,456.62 Supplies37,944 1,329.72 - 21,827.43 26,251.94 7,702.79 3,989.27 City Support Services21,734 - - - 19,518.41 - Utility Services 123,456 10,133.70 89,077.11- 97,112.52 - 26,343.48 Operations Support 1,565 - - 627.50 1,565.00 - Staff Support 47,827 4,099.66 12,555.28- 42,474.88 2,339.84 City Assistance 10,563 2,604.99 - 5,056.18 5,144.73 4,143.51 Professional Services 8,692 2,848.00 - 6,830.16 4,930.85 - Maintenance Services 46,494 97.41 30,840.80- 38,165.64 3,654.50 Operating Equipment 97,801 13,104.70 54,101.46- 83,919.28 4,537.30 Capital Outlay142,522153,726.40142,521.25 - - - TOTAL POLICE 5,090,947508,829.63 4,033,136.37-4,464,496.8822,377.94 FIRE RESCUE Personnel Services 2,521,468 255,318.57 2,115,417.34- 2,255,818.52 - 265,649.48 Supplies 20,500 662.45 - 6,198.98 14,825.40 1,573.63 Utility Services 57,000 3,142.34 43,207.90- 41,871.54 40.00 Operations Support 800 98.64 - 687.00 552.03 - Staff Support 120,185 34.90 84,084.06- 102,035.78 1,437.87 City Assistance 18,600 - 17,885.71- 8,885.80 5,734.71 Professional Services 18,140 - 13,040.00- 12,148.19 - Maintenance Services 56,000 1,510.60 27,263.61- 37,831.10 3,518.01 Operating Equipment58,3004,433.75 27,309.57 -34,719.45 12,633.53 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,905,993 265,201.25 2,342,504.05- 2,532,393.93 24,937.75 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services423,615 45,496.26 317,406.35- 377,966.52 - 45,648.48 Supplies2,123 89.88 - 1,694.80 1,653.06 255.03 214.91 City Support Services595 - - - - 594.50 0.50 Utility Services6,500 534.96 - 4,813.21 4,840.97 - Operations Support 1,305 - - 1,467.87 561.00 - Staff Support 7,977 933.30 - 3,151.85 3,108.80 576.64 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 --47.61 - - TOTAL INSPECTIONS 453,115 47,054.40 328,534.08- 388,130.35 1,473.78 MARSHAL SERVICE Personnel Services 537,373 56,756.01 402,892.54- 466,915.95 - 70,457.05 Supplies 4,600 289.98 - 1,633.87 2,760.38 72.00 Utility Services 12,000 1,152.88 - 9,170.21 12,279.18 - Operations Support 4,000 127.45 - 1,595.39 1,477.84 - Staff Support 15,400 790.00 - 3,622.97 7,071.28 245.58 Maintenance Services 30,700 3,550.00 - 9,965.85 7,334.00 328.31 Operating Equipment16,000 12,102.04 - -22,861.14 - Capital Outlay34,000 31,022.0546,453.40 - - - TOTAL MARSHAL SERVICE 654,073 62,666.32 498,195.37- 540,962.72 645.89 TOTAL PUBLIC SAFETY 9,104,128 883,751.60 7,202,369.87- 7,925,983.88 49,435.36 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services685,341 67,012.40 498,365.10- 601,187.06 - 84,153.94 Supplies7,100 60.91 - 4,331.29 4,582.17 149.07 2,368.76 Utility Services113,900 13,304.65 - 100,285.84 106,971.25 257.24 6,671.51 Staff Support10,265 458.37 - 6,585.04 6,251.65 590.43 3,422.92 Maintenance Services270,800 17,194.43 - 138,319.96 145,963.78 10,490.14 114,346.08 Rental/Lease200 - - - - - Operating Equipment 4,200 - - 5,185.95 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,091,806 98,030.76 766,743.18- 868,441.90 11,486.88 TOTAL PUBLIC ENVIRONMENT1,091,806 98,030.76 766,743.18- 868,441.90 11,486.88 211,877.22 PARKS & RECREATION PARKS DEPARTMENT Personnel Services510,269 51,825.10 412,115.82- 435,017.46 - 75,251.54 Supplies40,555 713.49 - 28,359.58 28,130.45 2,726.75 9,697.80 Utility Services113,000 12,880.55 - 109,103.07 117,538.84 2,105.76 (6,644.60) Operations Support700 - - 880.80 - - Staff Support 8,573 157.86 - 6,660.05 7,031.63 219.75 Professional Services 62,610 - 40,884.50- 51,412.99 5,097.00 Maintenance Services 21,000 180.00 19,737.38- 14,356.77 50.00 Rental/Leasing 43,200 - 39,953.03- 33,334.93 9,676.20 Operating Equipment - - 6,886.98 - - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT 799,907 65,757.00 664,771.77- 686,823.07 19,875.46 SWIM POOL Supplies 17,700 3,545.05 15,740.19- 15,922.56 549.63 Utility Services 25,500 2,758.94 16,143.75- 19,936.63 487.56 Staff Support 925 - - 166.09 750.00 - Maintenance Services 198,378 59,971.32 190,192.20- 192,793.95 50.00 Rental/Lease500 208.20378.00 - - - TOTAL SWIM POOL 66,275.31243,003 222,620.23-229,611.341,087.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET EVENT FACILITIES Personnel Services54,416 6,030.36 70,641.37- 50,533.72 - Supplies 28,300 488.26 - 7,291.27 11,197.46 1,808.96 Utility Services 47,550 4,273.37 32,849.08- 32,362.26 - 15,187.74 Operations Support 15,158 742.50 - 7,924.26 10,909.28 3,784.89 Staff Support 3,342 - - 614.47 1,101.48 860.00 Professional Services 1,600 - - 975.00 150.00 - Operating Equipment5,000 4,999.70285.00 - - - TOTAL COMMUNITY/CIVIC CNTR155,36611,534.49 120,580.45- 111,253.90 6,453.85 37,658.25 TOTAL PARKS & RECREATION1,198,276 143,566.80 1,007,972.45- 1,027,688.31 27,416.50 143,171.19 CULTURAL LIBRARY Personnel Services 698,102 71,886.22 594,136.14- 624,908.41 - 73,193.59 Supplies14,000 25.00 - 10,674.43 8,021.16 1,388.24 4,590.60 Utility Services41,000 5,098.39 - 41,118.23 40,358.04 562.57 79.39 Operations Support2,000 - - 1,110.20 1,157.00 - Staff Support 4,215 - - 1,500.42 1,538.18 16.53 Professional Services 2,100 - - 2,065.00 3,340.00 - (1,240.00) Maintenance Services 2,400 - - 1,200.00 2,000.00 - Operating Equipment75,000 64,137.4467,657.081,094.58 - - TOTAL LIBRARY 77,009.61838,817 - 719,461.50 745,460.23 3,061.92 90,294.85 TOTAL CULTURAL838,817 77,009.61 719,461.50- 745,460.23 3,061.92 90,294.85 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services298,212 25,966.55 260,396.81- 246,213.93 - 51,998.07 Supplies25,000 2,160.61 - 17,309.28 19,684.89 2,311.56 3,003.55 Utility Services11,200 940.64 - 9,422.34 9,040.10 - Operations Support 500 - - - - - Staff Support 12,560 139.08 - 1,981.08 7,912.72 150.99 City Assistance 10,000 1,275.36 - 8,961.78 8,588.31 - Professional Services 13,500 1,427.75 10,344.00- 9,305.75 - Maintenance Services 6,200 - - 3,364.61 4,385.15 120.00 Operating Equipment9,500 4,639.148,493.52 - - - TOTAL ANIMAL SERVICES386,67231,909.99 320,273.42-309,769.992,582.55 TOTAL HEALTH 386,672 31,909.99 320,273.42- 309,769.99 2,582.55 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 261,756 30,792.53 230,201.12- 256,646.65 - Supplies 2,000 - - 1,090.52 336.71 - City Support Services 360,854 25,199.64 218,439.79- 240,694.59150,565.25 Utility Services 164,949 9,905.94 118,335.32- 130,159.67 11,679.16 Staff Support 16,750 - - 9,842.38 14,422.76 2,031.69 Professional Services 2,500 - - - - - Maintenance Services 12,500 - 15,082.52- 9,389.36 2,850.00 Operating Equipment 129,315 5,384.95 127,568.50- 105,300.22 10,019.07 Capital Outlay213,500129.45 129.45- - 46,768.47 TOTAL INFORMATION TECHNOLOGY1,164,124 71,412.51 720,560.15- 757,079.41223,913.64 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services298,343 43,994.98 185,907.35- 241,082.42 - 57,260.58 Supplies2,329 9.35 - 768.52 905.52 19.99 1,403.31 Human Services45,031 3,832.70 - 30,548.99 34,864.85 - 10,166.15 Operations Support11,346 768.00 - 9,317.21 6,438.25 - Staff Support 13,397 (75.00) - 7,017.49 9,244.40 1,000.34 City Assistance 9,860 427.00 - 6,353.00 6,022.50 600.00 Operating Equipment7,575399.00 4,701.13-424.91 - TOTAL HUMAN RESOURCES 49,356.03387,881 239,912.56- 303,259.07 2,045.24 FINANCE Personnel Services432,396 33,007.35 364,607.52- 388,790.08 - 43,605.92 Supplies3,600 340.01 - 2,805.18 2,769.20 17.77 813.03 Operations Support850 100.19 - 342.57 197.50 - Staff Support 15,805 - - 9,155.08 6,333.52 80.00 Rental/Leasing 2,230 - - - 502.32 - Operating Equipment1,000 266.471,077.80 - - - TOTAL FINANCE 455,881 33,447.55 377,988.15- 398,859.09 97.77 PURCHASING & ASSET MG T Personnel Services 243,664 26,245.93 205,021.16- 219,017.78 - 24,646.22 Supplies1,103 5.96 - 711.03 782.83 12.33 307.84 Utility Services650 - - 327.46 419.85 - Operations Support 909 - - 60.68 5.67 28.99 Staff Support 9,097 - - 5,259.30 4,104.15 - Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 263,014 26,251.89 211,379.63- 231,921.10 41.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services218,758 22,037.28 144,980.11- 191,437.70 - 27,320.30 Supplies150,576 11,756.28 - 104,243.99 134,942.58 9,785.53 5,847.89 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 400.44 - 4,544.59 3,197.75 - Operations Support 25 - - 750.00 - - Staff Support 3,835 188.27 - 2,005.70 2,695.55 204.64 Maintenance Services 70,079 13,556.25 52,591.45- 49,751.60 12,033.09 Rental/Lease270 150.00269.80 - - - Operating Equipment5,000 4,931.794,113.89 - - - TOTAL FLEET SERVICE 457,243 47,938.52 314,879.73- 388,726.77 22,023.26 TOTAL INTERNAL SERVICE 2,728,143 228,406.50 1,864,720.22- 2,079,845.44248,121.23 MISC & PROJECTS CITY ASSISTANCE - - 492.52 281.17 Utility Services - - Patient Assistance 5,000 - - 5,000.00 2,500.00 - Children's Advocacy Assistance 5,000 - - 5,000.00 - - Senior Citizen's Hot Meals42,000 42,000.0042,000.00 - - - TOTAL CITY ASSISTANCE52,000- 52,492.52-44,781.17 - COURT - RESTRICTED FUNDS Operating Equipment 15,019.009,237.403,340.00 - - - TOTAL CITY ASSISTANCE - - 9,237.40 15,019.00 3,340.00 - TOTAL MISC & PROJECTS52,000--61,73059,8003,340 TOTAL EXPENDITURES21,018,2891,984,659.57 16,181,770.45-17,731,135.89634,042.02 REVENUE OVER(UNDER) EXPEND.116,1761,423,568.01 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 6,127.12 6,736,333.49- 6,890,444.33 - (5,990.33) 000-411200Advalorem Tax - Delinquent 50,000 1,225.72 46,316.93- 49,971.39 - 000-411300Advalorem Tax - P&I 50,000 1,961.30 44,514.46- 42,561.17 - 000-411500Sales Tax Revenue-Gen Fund4,784,071 444,019.26 3,424,223.84- 4,733,408.76 - 50,662.24 000-411600Bingo Tax 2,200 - - 2,172.67 - - 000-411700Mixed Beverage Ta33,000.0033,629.9628,586.29 x - - - TOTAL Taxes11,803,725 453,333.40 10,287,191.35-11,744,971.94 58,753.06 Franchises 000-421200Center Point/Entex Energy 36,000 2,485.24 38,202.14- 48,275.97 - (12,275.97) 000-421220City Public Service 330,000 33,320.78 281,762.09- 322,493.08 - 000-421240Guadalupe Valley Elec Co-op 440,000 48,523.41 279,411.53- 373,409.10 - 66,590.90 000-421250New Braunfels Utilities 55,000 6,135.56 19,056.95- 49,067.92 - 000-421300Time Warner-State Franchise 345,000 28,299.05 245,760.94- 304,661.97 - 40,338.03 000-421350Time Warner-PEG Fee 65,000 - 49,140.88- - - 65,000.00 000-421460AT&T Franchise Fee 185,000 17,447.06 107,577.46- 177,869.34 - 000-421465AT&T PEG Fees 26,000 7,765.29 18,261.07- 7,765.29 - 18,234.71 000-421480Other Telecom Franchise 35,000 - 59,196.52- 55,644.00 - (20,644.00) 000-421500Solid Waste Franchise Fee100,00011,760.0387,777.0893,970.12 - - TOTAL Franchises1,617,000155,736.42 1,186,146.66-1,433,156.79 - 183,843.21 Permits 000-431100Home Occupation Permit 500 - - 280.00 280.00 - 000-431200Building Permit 26.00 1,214,510.83- 26.00 - - 000-431205Building Permit - Residential 600,000 23,252.00 - 366,064.00- - 233,936.00 000-431210Building Permit - Commercial 300,000 9,364.00 - 203,101.00- - 96,899.00 000-431215Building Permit - General - 103,278.00- - 9,394.00 - (103,278.00) 000-431300Mobile Home Permit 200 - - 80.00 250.00 - 000-431400Signs Permit 1,700 685.00 - 750.00 2,565.00 - 000-431500Food Establishmnt Permit 30,000 6,175.00 18,345.00- 20,825.00 - 000-431600Garage Sale Permit 8,600 1,340.00 10,760.00- 10,645.00 - (2,045.00) 000-431700Plumbing Permit 80,000 6,811.15 107,597.25- 103,362.25 - (23,362.25) 000-431750Electrical Permit 55,000 4,000.00 66,280.00- 42,910.50 - 12,089.50 000-431800Mechanical Permit 59,000 5,020.00 77,940.00- 49,880.00 - 000-431900Solicitor/Peddler Permit 310.00 - 2,790.00 1,580.00 - - 000-431950Animal/Pet Permit 2,000 100.00 - 1,630.00 2,175.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800250.00 6,950.00- 6,950.00 - (3,150.00) 000-432100Security Alarm Permit42,000 3,765.00 - 42,158.00 44,007.50 - (2,007.50) 000-435000Fire Permit5,000550.00 7,650.008,437.50 - - TOTAL Permits 71,042.151,187,800 - 1,558,508.58 965,549.25 - 222,250.75 Licenses 000-441000Alcohol Beverage License 6,300 60.00 - 5,397.50 5,032.50 - 000-441300Mobile Home License - - - 80.00 - - 000-442000Contractors License 39,000 6,380.00 49,785.00- 56,440.00 - (17,440.00) 000-444000Pet License3,000450.00 4,300.004,073.10 - - TOTAL Licenses 48,300 6,890.00 59,255.60- 65,852.50 - (17,552.50) Fees 000-451000Municipal Court Fines 1,665,009 154,974.40 963,689.96- 1,364,738.45 - 300,270.55 000-451100Arrest Fee 50,694 7,677.67 41,547.74- 57,574.96 - (6,880.96) 000-451110Expunction Fee 90 30.00 - 30.00 30.00 - 000-451200Warrant Fees 192,000 16,463.61 121,053.17- 129,790.09 - 62,209.91 000-451210Court - Claims & Judgements - - - 1,842.60 - - (1,842.60) 000-451320Civil Justice Fee-Court 75 12.34 62.20 90.44 - 000-451321Civil Justice Fee-State 111.47 - 560.67 816.60 - - 000-451340Judicial Fee - City 6,826 997.55 - 5,574.19 7,552.34 - 000-451400Traffic Fine Costs TTL 25,984 3,963.73 20,954.33- 29,625.22 - (3,641.22) 000-451500Teen Court Admin Fee 260 - - 280.00 420.00 - 000-451510Juvenile Case Mgmt Fee 55,896 8,322.64 46,480.14- 62,990.31 - (7,094.31) 000-451600Technology Fund Fee 45,601 6,670.98 37,576.51- 50,564.08 - (4,963.08) 000-451700Security Fee 34,220 5,003.22 28,191.39- 37,923.10 - (3,703.10) 000-451800Time Payment Fee - City 7,336 437.80 - 5,210.22 4,969.76 - 000-451850State Fines 10% Service Fee 72,470 - 63,806.36- 68,804.90 - 000-451900DPS Payment - Local 11,858 1,200.74 - 9,857.96 10,217.07 - 000-452000Child Safety Fee 12,243 262.51 - 9,906.56 23,692.78 - (11,449.78) 000-452050Indigent Defense Fee 21,655 3,240.78 18,002.71- 24,505.40 - (2,850.40) 000-452100Platting Fees 98,000 5,000.00 61,500.00- 57,000.00 - 41,000.00 000-452200Site Plan Fee 74,000 - 25,500.00- 19,500.00 - 54,500.00 000-452300Plan Check Fee 465,000 19,998.00 620,774.41- 288,154.50 - 176,845.50 000-452310Miscellaneous Review Fee 13,500 0.02 - 6,300.00 6,000.02 - 000-452320Tree Mitigation Admin Fee 10,500 1,110.00 - 7,680.00 12,200.25 - (1,700.25) 000-452400BOA/Zoning Fees 4,000 - - 1,400.00 3,250.00 - 000-452500Food Handler Class 7,000 5,160.00 - 6,110.00 13,010.00 - (6,010.00) C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452520Fire Training Classes400---- - 000-452600Specific Use/Zone Chng Fee 20,000 - 21,150.00- 30,500.00 - (10,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 - - 450.00 1,800.00 - 000-453100Reinspection Fees 30,000 2,875.00 36,605.00- 35,975.00 - (5,975.00) 000-453110Swim Pool Inspection Fee - - 1,050.00 1,500.00 - - (1,500.00) 000-453200Lot Abatement 12,000 781.85 11,981.26- 2,548.43 - 000-453211Admin Fee-Inspections 7,480 400.00 - 7,700.00 7,940.00 - 000-453310Misc Inspection Fee - - 270.00 69.49 - - 000-453710Foster Care 500 - - 850.00 650.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 5,959.50 22,720.35- 23,949.31 - 000-454300Seasonal Pool Pass Fee 5,500 - - 7,046.00 5,034.50 - 000-456500Haz Mat Fees 800 - - - 6,984.73 - (6,184.73) 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 - - 900.00 650.00 - 000-458100Sale of Merchandise - - 17.00 36.50 - - 000-458300Sale of Property/Auction 22,000 216.32 28,557.55- 20,451.14 - 000-458400Civic Center Rental Fees 171,000 10,519.00 115,627.50- 105,577.25 - 65,422.75 000-458401Capital Recovery Fee-Civic Cntr 7,500 150.00 - 1,680.00 4,640.00 - 000-458450North Center Rental Fees 15,000 1,851.00 10,412.00- 21,958.92 - (6,958.92) 000-458500Community Center Rental Fees 18,000 1,034.10 18,164.82- 25,945.22 - (7,945.22) 000-458550Pavilion Rental Fees 18,500 950.00 17,922.70- 16,707.00 - 000-458560Chamber of Comm rent 11,700 1,950.00 - 7,800.00 7,800.00 - 000-458570Non-Resident SYSA League 12,000 160.00 - 7,060.00 18,025.00 - (6,025.00) 000-458600Ball Field Use - - 1.76 - - - 000-458650NonResident User Fee-BVYA 11,000 - -9,090.008,860.00 - 000-458660BVYA Utility Reimbursement - - - 5,178.24 - - (5,178.24) 000-458670SYSA Utility Reimbursement - - 6,578.61 - 1,651.88 - (6,578.61) 000-458680Tournament Fees-Soccer 15,000 - - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 - - - 1,380.00 - 000-459200NSF Check Fee 250 85.00 - 328.00 539.00 - 000-459300Notary Fee 300 30.00 - 357.00 360.00 - 000-459400Maps, Copies, UDC, & Misc F 400 5.00 - 618.18 78.10 - 000-459600Animal Adoption Fee 15,000 1,735.50 11,021.50- 11,862.50 - 000-459700Pet Impoundment Fee 15,000 2,285.00 17,621.01- 15,514.25 - 000-459800Police Reports Fee6,500441.80 5,780.305,334.20 - - TOTAL Fees 273,718.413,324,727 - 2,466,784.35 2,677,816.36 - 646,910.64 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,553.2824,173.3625,947.27(20.91) - TOTAL Fines30,0002,553.28 24,173.36-25,947.27(20.91) Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 1,756.48 19,321.28- 19,321.28 - 000-473200City of Seguin - Fire Contract 40,263 3,355.26 36,907.86- 36,907.86 - 000-473300Guad Co - Library 180,000 15,901.33 150,680.00- 159,013.30 - 20,986.70 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,900.00 600.00 - 000-474200Library Services - Cibolo 20,000 - - 17.50 20,000.00 - 000-474210Library Services-Selma 19,000 - - 18,392.80- - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 133,305.00 - 000-474600School Crossing Guard-Bexar6,6002,869.0732,383.67 -11,042.15 -(25,783.67) 000-474610School Cross Guard-Guadalupe29,623.71 -3,235.02 -20,459.57 -(29,623.71) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional571,24527,117.16 373,633.36-537,047.62 - 34,197.38 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 80,520.00- 80,520.00 - 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 156,035.90- 130,740.50 - 11,885.50 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 617.50 35,401.50- 35,480.00 - 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 572,712.25- 807,786.87 - 73,435.13 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486317Transfer From Park Fund 13,000 - - - 5,819.26 - 000-486322Transfer-In - Library Grants - - 6,293.53 - - (6,293.53) 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 81,862.90- 90,277.00 - 000-488000Interfund Charges-4B 53,000 4,416.67 50,001.97- 48,583.37 - 000-489000Transfer In- 13,146.26-- - - 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 105,881.84 1,065,052.83- 1,206,500.53 - 554,157.47 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 44.87 - 1,643.52 315.38 - 000-491200Investment Income 30,000 3,670.35 32,898.59- 44,376.98 - (14,376.98) 000-491800Gain/Loss - - (6,057.33)- - - 000-491900Unrealized Gain/Loss (17,368.82)- (20,444.27) - (2,834.75) - 20,444.27 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - 340.00 - - - 000-493130Donations-Writing the Next Chap. 75.00 25,168.00- 5,281.34 - - (5,281.34) 000-493400Donation - Animal Control 1,200 152.50 - 4,705.21 4,382.13 - (3,182.13) 000-493401Donations-A/C Microchip 500 205.00 - 2,075.00 1,845.00 - (1,345.00) 000-493402Donations-Spay&Neuter 13,500 2,822.50 14,629.58- 13,790.50 - 000-493460Donations-Employee Picnic - - 300.00 - - - 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed - - 3,550.22 50.00 - - 000-494482Grants - Police 175,510 - - 648.99 2,893.77 - 172,616.23 000-495040Friends of N. Schertz Park - - - 3,074.00 - - (3,074.00) 000-495100Mobile Stage Rental Fees - - - 2,850.00 - - (2,850.00) 000-497000Misc Income-Gen Fund 81,000 (3,725.68) 12,701.66- 26,158.62 (71.90) 000-497005Misc Income-Publications 290,000 18,241.00 139,974.05- 196,708.00 - 93,292.00 000-497007Misc Income-Schertz Artz - - - 2.00 - - 000-497100Misc Income-Police 25,000 510.60 22,858.49- 18,385.78 - 000-497200Misc Income-Library 19,000 354.90 18,253.95- 3,551.69 - 15,448.31 000-497210Misc Income-Library Copier 13,500 1,115.65 10,871.80 12,292.41 - 000-497300Misc Income-Animal Control 500 - - 1,506.37 105.00 - 000-497400Misc Income-Streets Dept. 20,000 2,175.00 19,913.70- 16,750.51 - 000-497500Misc Income-TML Insurance 78,000 11,447.10 49,728.90- 12,070.46 - 65,929.54 000-497550Misc Income-TML Reimbursemt20,000 - 29,053.61-16,712.47 - 000-497600Misc Income-Parks/Vending Mach.2,500 137.15 - 2,016.23 1,580.67 - 000-498000Reimbursmnt-Gen Fund5,00034.0030,710.92 -10,387.46 -(25,710.92) 000-498100Reimbursmnt Fire - Training 800 - - 1,101.00 - - 000-498105Reimburmnt Police - DEA - - 6,594.28 5,617.36 - - (5,617.36) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 8,847.19 30,936.01- 46,990.40 - (34,990.40) 000-498500Settlement - Litigation25,000.00- - - - - TOTAL Miscellaneous791,010 43,272.38 - 449,512.80 497,861.64 (71.90) 293,220.26 TOTAL REVENUES21,134,465 1,139,545.04 - 17,470,258.89 19,154,703.90 (92.81) 1,979,853.91 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking339,778.68$ Cash in Investments LOGIC Investment-General Fund 1,762,342.04 LOGIC Investment-Equip Replacement 73,458.35 LOGIC Investment-Veh Replacement 7,090.29 LOGIC Investment-Air Condi Replacment 146,665.75 CAPITAL ONE Investment-General Fund1,341,093.06 Total Cash in Bank & Investments$3,817,010.01 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 18,039 26,509 6,127.12 2011-12 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 2010-11 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 2009-10 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 2008-09 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 24,241 6,294 10,447 2007-08 Sales Tax - General Fund $700,000 $600,000 26% -2% $500,000 40% 19% 25% -3% 17% 12% 23% -2% $400,000 $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 365,083 347,395 535,930 398,080 408,851 575,414 2011-12 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2010-11 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2009-10 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2008-09 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2007-08 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 306,696 382,743 298,203 2006-07 CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 76,414 77,398 103,230 2011-12 83,433 62,692 67,561 95,887 2010-11 77,354 61,468 63,276 80,716 2009-10 77,308 53,071 57,506 83,329 2008-09 55,729 50,340 48,120 86,572 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 62,100.00 - 51,250.00- - - 10,850.00 Wilenchik Walk for Life 28,000.00 30,461.91- 26,451.06 - - 1,548.94 TML Dinner - - 194.69 - - - (194.69) Hal Balwin Scholarship 24,000.00 23,615.00- 16,327.00 - - 7,673.00 Miscellaneous175.009.37- 1,408.57469.18 - TOTAL REVENUES114,275.00 9.37 - 54,546.09 95,631.32 - 18,643.68 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - 200.00 10,340.89 - - (5,590.89) Festival of Angels 14,250.00 12,654.23- 13,050.46 - - 1,199.54 Employee Appreciation Event 5,000.00 - 126.00 - - - 5,000.00 4th of July Jubilee - (1,420.64) 218.05 - - - (218.05) National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 30,461.91- 26,451.06 - - 5,048.94 TML Events - - 194.69 - - - (194.69) Schertz Sweetheart 37,000.00 1,066.94 44,385.85- 21,990.04 3,143.14 Hal Baldwin Scholarship11,000.00-10,354.114,767.40 - -6,232.60 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 1,066.94103,600.00 - 97,161.46 77,012.59 3,143.14 23,444.27 TOTAL EXPENDITURES108,750.00 1,066.94 - 97,161.46 77,012.59 3,143.14 28,594.27 REVENUE OVER(UNDER) EXPEND5,525.0018,618.73 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking65,382.85$ Cash in Investments MBIA Special Events46,683.31 Total Cash in Bank & Investments$112,066.16 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises - 84,753.61- - 15,435.78 - (84,753.61) Miscellaneous- 12.49- - - - TOTAL REVENUES 15,435.78 - - 84,766.10 - (84,766.10) - EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental- -- - - - TOTAL GENERAL GOVERNMENT - - - - - - - TOTAL EXPENDITURES - - - - - - - REVENUE OVER(UNDER) EXPEND84,766.10 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Franchises 000-421350Time Warner - PEG Fee - 62,966.10- -15,435.78 -(62,966.10) 000-421465T&T PEG Fee 21,787.51- A - - - - TOTAL Fund Transfers - 84,753.61- -15,436 -(84,753.61) Miscellaneous 000-491000Interest Earned--12.49 - - -(12.49) 000-491200Investment Income -- - - - - TOTAL Miscellaneous - - 12.49 - - -(12.49) TOTAL REVENUES- 84,766.10- -15,435.78 -(84,766.10) PEG FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Cash Balance378,933.27$ Total Cash in Bank & Investments$378,933.27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,00031,944.76 195,780.20-213,461.16 (33,461.16)- Fees14,164,2501,420,238.47 13,151,871.28-13,781,248.13 383,001.87- Fund Transfers634,6747,056.17 73,898.00-77,617.87 557,056.13- Miscellaneous27,527.84317,113.41420,767.79 103,260 - - TOTAL REVENUES15,082,1841,486,767.2413,738,662.8914,493,094.95 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers31,000.00- 27,366 - - - TOTAL NON DEPARTMENTAL- 27,366 - -31,000.00 -27,366.00 BUSINESS OFFICE Personnel Services386,33036,692.89 363,105.89-316,826.24 69,503.76- Supplies5,400168.92-3,120.603,631.35998.93 Human Services100---40.00- Operations Support106,0002,623.83 89,194.03-88,545.36 17,454.64- Staff Support6,705340.49-2,342.363,775.6843.30 Professional Services24,3952,388.25 16,130.18-20,730.86- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300--5,787.955,800.0060.00 Operating Equipmen6,117.625,932.94 t 6,200 - - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE42,214.38445,282.431,102.23 606,430 -485,798.63 W & S ADMINISTRATION Personnel Services1,191,352103,955.51 1,052,854.28-928,493.71 262,858.29- Supplies200,3597,693.47 164,568.87-123,311.761,789.67 Human Services1,000--64.00216.00- City Support Services65,109- 38,874.05-34,379.596,595.00 Utility Services2,571,844386,784.30 2,139,478.89-3,073,935.841,687.08 Operations Support8,750256.01-5,822.646,234.02- Staff Support33,0003,295.78 19,209.10-17,710.691,953.88 City Assistance1,91215.00-441.00538.00- Professional Services208,14020,207.70 181,261.89-139,333.56130.00 Fund Charges/Transfers2,657,007183,675.97 1,997,033.20-2,401,803.6214,500.00 Maintenance Services5,563,827538,418.85 4,577,733.50-4,964,915.5059,746.52 Other Costs35,000- 29,831.85-30,956.44- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,35378,803.12 1,343,096.40-285,232.69 945,120.31- Rental-Leasing6,070--2,508.532,961.71289.50 Operating Equipment20,696- 22,682.70-17,694.692,412.50 Capital Outla99,948.00 y 103,328 - -132,061.40 - -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,897,7471,323,105.71 12,127,665.8289,104.15 -11,707,522.30 MISC & PROJECTS PROJECTS City Support Services29,000---- 29,000.00- Operations Support1,000----- Professional Services45,29016,785.00- 28,485.00- 16,805.00- Maintenance Services -- 312,750 - - - TOTAL PROJECTS16,785.00 28,485.00- 388,040 - -359,555.00 AVIATION HEIGHTS WTR IMPROVEMNTS Operations Support---248.04-- Professional Services25,210- 56,972.38-- 25,210.00- Maintenance Services314,473.42- 136,750 - - - - TOTAL AVIATION HEIGHTS WTR IMP 161,960 - -371,693.84 -161,960.00 FM3009 RD&BRIDGE EXPANSION Professional Services-- 55,278.65-5,588.00 (5,588.00)- Maintenance Services65,789.7871,088.87 - - - - 76,676.87 TOTAL FM3009 RD&BRIDGE EXPANSION - - -121,068.43 -(76,676.87) TOTAL MISC & PROJECTS16,785.00105,161.87 550,000 -492,762.27 -444,838.13 TOTAL EXPENDITURES15,081,5431,382,10512,717,08312,678,11090,206 - ** REVENUE OVER(UNDER)EXPENSES **1,814,984.83 641 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 31,944.76195,780.20213,461.16 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 31,944.76 195,780.20- 213,461.16 - (33,461.16) Fees 000-455200Garbage Collection Fee 3,400,000 278,151.63 2,952,593.98- 3,175,614.82 - 224,385.18 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,711.44 202,199.55- 229,202.75 - 11,797.25 000-455800W&S Line Constructn Reimbursemnt50,000 1,427.00 28,741.60- 22,334.44 - 27,665.56 000-457100Sale of Water 7,210,000 810,584.68 6,948,185.09- 7,059,750.42 - 150,249.58 000-457110Edwards Water Lease 166,250 16,235.00 192,995.00- 204,398.59 - (38,148.59) 000-457120Water Transfer Charge-Selma 5,000 7,582.08 - 2,668.48 25,343.55 - (20,343.55) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 3,845.60 68,458.32- 52,664.58 - 37,335.42 000-457400Sewer Charges 2,800,000 264,354.43 2,576,693.39- 2,823,609.96 - (23,609.96) 000-457500Water Penalties 180,000 17,166.61 158,612.57- 163,909.05 - 16,090.95 000-459200NSF Check Fee-Water&Sewer2,000180.002,292.022,530.00 - - TOTAL Fees14,164,2501,420,238.47 13,151,871.28-13,781,248.13 383,001.87 Fund Transfers 000-481000Transfer In- Reserve550,000---- - 550,000.00 7,056.1773,898.00 77,617.87 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 634,674 7,056.17 73,898.00- 77,617.87 - 557,056.13 Miscellaneous 000-490000Misc Charges 10,000 86.50 - 6,672.28 724.62 - 000-491000Interest Earned 1,000 124.69 - 1,303.13 1,725.94 - 000-491200Investment Income 6,000 598.50 13,877.15 9,809.10 - (3,809.10) 000-493400Donations-Christmas Activities - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - 134,500.00- 269,000.00 - - (269,000.00) 000-497000Misc Income-W&S 567.74 13,049.70- 34,734.11 - - (34,734.11) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 26,150.41 102,014.05- 104,024.02 - (27,709.02) 000-498200W&S Project Reimbursement42,405.76 - - - - - TOTAL Miscellaneous 103,260 27,527.84 317,113.41- 420,767.79 - (317,507.79) TOTAL REVENUES15,082,1841,486,767.24 13,738,662.89- 14,493,094.95 589,089.05 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking240,360.22$ Cash in Investments Lone Star Investment-Water&Sewer 1,360,612.74 Lone Star Investment-W&S Customer Deposits294,293.72 Lone Star Investment-W&S Equip Replacement373,867.15 Lone Star Investment-W&S Veh Replacement 545,143.01 Lone Star Investment-Water/SSLGC SAWS 404,319.13 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $4,034,144.37 Total Cash in Bank & Investments4,274,504.59$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 336,042.93 2,998,835.22- 2,846,744.99 1,242,488.01(300.00) Inter-Jurisdictional1,438,836 47,687.76 1,365,847.34- 1,421,509.70 17,326.30- Miscellaneous10,968.49-104,871.09109,265.33 256,000 - TOTAL REVENUES 394,699.18 - 4,469,553.65 4,377,520.02 (300.00) 1,406,548.98 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,600,871283,198.69 2,336,208.96-2,406,735.11 194,135.89- Supplies 4,496.18 267,878.03- 268,624.66 27,807.67 327,239 Human Services - 614.00 230.00 800 - - City Support Services 10,974.19- 10,277.40 17,525 - - 7,247.60 Utility Services 10,988.01 98,093.82- 103,982.45 15.00 112,500 Operations Support 1,748.32 39,704.11- 44,553.16 1,000.00 52,600 Staff Support 1,475.10 59,538.32- 59,540.18 9,435.18 72,400 City Assistance 174.00 11,781.80- 9,727.28 662.00 9,000 Professional Services 3,603.97 108,060.71- 110,579.91 5,635.06 152,140 Fund Charges/Transfers2,084,785 10,180.36 606,641.58- 763,342.26 - 1,321,442.74 Maintenance Services 13.50 21,779.91- 38,031.37 982.15 39,560 Debt Service 242,270.49- 11,231.00 111,176 - - 99,945.00 Rental-Leasing - 3,604.76 - 20,000 - - Operating Equipment 33,629.38- 41,574.77109,962.35 113,000 - Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 315,878.13 - 3,840,780.06 3,868,429.55 155,499.41 1,689,667.04 5,713,596 TOTAL EXPENDITURE315,878.13-3,840,780.063,868,429.55155,499.41 S 5,713,596 ** REVENUE OVER(UNDER) EXPENSES 509,090.47 * 70,173 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 333,792.93 - 2,911,715.22 2,765,730.79 - 1,053,002.21 72.43% 000-456110Subscription Program Fees55,000 175.00 - 18,700.00 18,160.00 33.02% - 36,840.00 000-456120EMT Class - Fees95,200 2,075.00 - 68,420.00 59,231.00 (300.00) 36,269.00 61.90% 000-459200Paramedic Class Fees120,000 - - - - 000-456130Immunization Fees 3,623.20- - - - - TOTAL Fees4,088,933336,042.93 2,998,835.22- 2,846,744.99 1,242,488.01(300.00) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 47,687.76 - 263,382.50 262,282.68 - 23,843.32 000-474300Cibolo Support 222,018 213,300.00- 222,099.92 100.04% - - 000-475100Comal Co ESD #6 82,875 56,880.00- 75,997.10 - - 6,877.90 000-475200Live Oak Support 148,125 148,125.00- 160,329.52 - - (12,204.52) 000-475300Universal City Support 226,168 204,412.52- 227,101.32 - - 000-475400Selma Support 67,618 68,730.00- 67,643.40 100.04% - - 000-475500Schertz Support 384,046 387,459.48- 384,187.64 - - 000-475600Santa Clara Support 8,849 10,534.68- 8,852.24 100.04% - - 000-475800Marion Support13,01113,023.1613,015.88 - - - TOTAL Inter-Jurisdictional1,438,836 47,687.76 1,365,847.34- 1,421,509.70 17,326.30- Miscellaneous 000-491200Investment Income 60.33 - 520.97 610.27 - - 000-493203Donations-EMS 6,000 200.00 11,450.00- 1,095.00 - 4,905.00 000-493204Donations-Dilworth Fund - 1,000.00 - 0.00% - - - 000-493205Donations- Golf Tournament - 4,430.00 15,550.00 - - - (15,550.00) 000-497000Misc Income 150,000 8,971.00 76,447.71- 86,231.08 - 63,768.92 000-497100Recovery of Bad Debt100,0001,737.1611,022.415,778.98 - - TOTAL Miscellaneous 256,000 10,968.49 104,871.09- 109,265.33 - 146,734.67 TOTAL REVENUES5,783,769394,699.18 4,469,553.65- 4,377,520.02 1,406,548.98(300.00) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank $ (340,303.65) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,358.00 $(38,945.65) Total Cash in Bank & Investments C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60061,731.12 648,746.90- 683,266.65 -26,333.35 Fund Transfers - - - - - - - 0.00% Miscellaneous900986.831,485.16 89.31 - - TOTAL REVENUES 61,820.43710,500649,733.73 -684,751.81 - 25,748.19 EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 375,64630,517.68 314,935.06- 288,021.06 -87,624.94 Supplies 8,300 968.40 - 3,468.91 4,861.25 451.00 Human Services 172.00325 - - 172.00 -153.00 City Support Services 20,861 - 5,832.18 1,508.72 - -19,352.28 Utility Services 24,188 2,231.57 15,585.27- 18,573.43 257.24 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 152.45 - 4,428.91 3,438.24 1,008.79 City Assistance 174.00840 - 15.00 246.00 -594.00 Professional Services 20,698 16,548.52- 14,959.25 - -5,738.75 Fund Charges/Transfers 199,876 8,917.17 119,515.75- 126,776.37 -73,099.63 Maintenance Services 22,000 - 1,987.00 42.12 - -21,957.88 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 17,564 18,137.56- 3,264.14 - - Rental/Leasing 562 - - 561.29 99.87% - - Operating Equipment-- - - - - - TOTAL DRAINAGE 43,133.27701,725500,554.16 1,717.03462,523.87237,484.10 - TOTAL EXPENDITURE 43,133.27701,725500,554.16 1,717.03462,523.87237,484.10 S - ** REVENUE OVER(UNDER) EXPEND8,775222,227.94 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,966.71 4,712.37 4,000 383.38 -(712.37) 000-457600Drainage Fee 61,347.74-644,780.19678,554.28 -27,045.72 705,600 TOTAL Fees61,731.12 648,746.90-683,266.65 26,333.35- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 235.74 82.79 100 9.87 - 000-491200Investment Interest - 580.21 736.10 600 77.13 -(136.10) 000-497000Misc Income-Drainage-170.88666.27 200 2.31 - TOTAL Miscellaneous - 986.83 1,485.16 900 89.31 -(585.16) TOTAL REVENUES61,820.43 649,733.73- 684,751.81 25,748.19- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 175,416.94 Cash in Investments Lone Star Investment-Drainage Maint Fund383,816.74 Total Cash in Bank & Investments$559,233.68 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 85,979.51 269,920.61- 381,007.00 -9,747.00 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50062.43-959.28362.13 - TOTAL REVENUES 86,041.94411,386-270,879.89381,369.13 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 - 2,315.40 1,826.50 - -673.50 City Support Services 85,948 59,630.85- 61,628.00 - -24,320.00 Operations Support 56,425 1,072.00 12,292.68- 21,014.3122,460.73 Professional Services 2,500 - 2,500.00 2,500.00 - - -100.00% Fund Charges/Transfers 193,876 11,885.50 156,035.90- 181,990.50 -11,885.50 Operating Equipment 14,605.0055,337 - 46,695.22- 21,476.25 Capital Outlay -14,800--- - TOTAL NONDEPARTMENTA 27,562.50411,386-232,774.83315,654.53 L 43,936.98 TOTAL EXPENDITURE 27,562.50411,386-232,774.83315,654.53 S 43,936.98 65,714.60 REVENUE OVER(UNDER) EXPENDITURE - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 85,979.51269,920.61381,007.00 -9,747.00 - TOTAL Taxes 390,754 85,979.51 269,920.61- 381,007.00 - 9,747.00 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned3001.44-242.5589.51 - 210.49 000-491200Investment Interest 200 60.99 - 116.73 272.62 136.31% - (72.62) 000-497000Misc Income600.00- - - - - - TOTAL Miscellaneous50062.43-959.28362.13 - 137.87 TOTAL REVENUES 411,386 86,041.94 270,879.89- 381,369.13 - 30,016.87 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking38,833.76$ Cash in Investments MBIA - Hotel Tax250,143.07 Federated Investment-Hotel/Motel78,255.59 Total Cash in Bank & Investments$367,232.42 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 36,215 45,071 36,518 40,335 48,397 53,622 2011-12 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2010-11 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2009-10 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 2008-09 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 26,866 30,247 26,313 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 107,000.00- 148,025.00 - -101,975.00 Tree Mitigation Fees 75,000 43,520.00- 69,134.75 6,290.00 -5,865.25 Miscellaneous600-596.50607.10 53.30 - TOTAL REVENUES 6,343.30325,600-151,116.50217,766.85107,833.15 - EXPENDITURE SUMMARY PARKLAND DEDICATION Professional Services - 23,350.00- - - -(23,350.00) Fund Charges/Transfers 13,000 - - 5,819.26 - -7,180.74 Maintenance Services-Landscape 3,500 28,399.00- 135.88 - -3,364.12 Operating Equipment 32,000 56,748.78- 50,901.17 2,781.20 - Capital Outlay 8,400.00169,000--31,816.00137,184.00 - TOTAL PARKLAND DEDICATION 8,400.00217,500-85,147.78112,022.31102,696.49 2,781.20 TREE MITIGATION Maintenance Services-Trees28,500 31,869.55- 3,923.00 2,412.50 - Capital Outlay -18,000--19,900.00 - TOTAL TREE MITIGATION -46,500-31,869.5523,823.00 2,412.50 TOTAL EXPENDITURE 8,400.00264,000-117,017.33135,845.31122,960.99 S 5,193.70 REVENUE OVER(UNDER) EXPEND 81,921.5461,600 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 107,000.00- 148,025.00 101,975.00- - 000-458900Tree Mitigation 6,290.0075,00043,520.00 -69,134.75 - TOTAL Fees 325,000 6,290.00 150,520.00- 217,159.75 - 107,840.25 Miscellaneous 000-491000Interest Earned 100 8.89 - 214.61 42.16 57.84- 000-491200Investment Interest 44.41500381.89564.94- - TOTAL Miscellaneous 600 53.30 - 596.50 607.10 - TOTAL REVENUES 325,600 6,343.30 151,116.50- 217,766.85 107,833.15- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$154,180.60 Cash in Investments Federated Investment-Park Fund 167,389.00 Federated Investment-Tree Mitigation152,101.09 Total in Investment Pool 319,490.09 Total Cash in Bank & Investments$473,670.69 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 115,812.24 2,333,569.81- 1,419,384.68 -1,306,015.32 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 1,236.49322,619.6917,887.20 - - TOTAL REVENUES13,713,000 117,048.732,656,189.50 -1,437,271.8812,275,728.12 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 355.11 1,121,525.77- 6,255.08 -15,744.92 Maintenance Services 10,000 - - - 5,740.00- Fund Charges/Transfers - - - - 0.00% - - Debt Service - - 108,671.00- - -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000 355.111,129,953.77115,034.58 L - 5,740.00 MISC & PROJECTS Projects13,025,00014,970.0025,458.42 -92,698.20 -12,999,541.580.20% Schaefer RD Water Improvements 599,6432,050.00-5,125.00 - -594,518.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant-- 0.00% - - - - Town Creek Project-- 0.00% - - - - Live Oak Water Plant- 0.00% - - -38,106.38 - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP344,233.90- A - - - - TOTAL MISC & PROJECTS13,624,643 17,020.00475,038.4830,583.4213,594,059.58 - - TOTAL EXPENDITURE13,662,643 17,375.111,604,992.25145,618.0013,511,285.00 S - 5,740.00 REVENUE OVER(UNDER) EXPENDITURES50,357 1,291,654 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 64,548.00 1,273,031.74- 883,447.00 -596,153.00 000-455910Capital Recovery - Waste Wtr613,800 38,664.24 836,139.78- 472,937.68 -140,862.32 000-455913Cap Recovery-North Sewer Tr632,000 12,600.00224,398.2963,000.00 - - TOTAL Fees2,725,400115,812.24 2,333,569.81-1,419,384.68 -1,306,015.32 Fund Transfers 000-481000Transfer from Reserves10,673,600---- 0.00% -10,673,600.00 000-486202Transfer in-Water -- - - - - 000-486406Transfer in-Public Improvement -- - - - - TOTAL Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous 000-491000Interest Earned 500 128.86 - 482.72 381.06 - 000-491200Investment Income 30,000 4,941.88 35,637.89- 49,656.27 -(19,656.27) 000-491800Gain/Loss - - (7,055.28) - - -7,055.28 000-491900Unrealized Gain/Loss-Cap One (19,209.22)- (25,145.16) - (3,834.25) -25,145.16 000-497000Misc Income - - 50.31 - - - 000-498000Reimbursmnt - - - - 0.00% - - 000-498100Reimbursmnt - FM 78 Project 45,833.30- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -259,875.00- - - TOTAL Miscellaneous314,0001,236.49 322,619.69-17,887.20 5.70% -296,112.80 TOTAL REVENUES13,713,000 117,048.73 2,656,189.50- 1,437,271.88 10.48% -12,275,728.12 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking380,117.53$ Cash in Investments Lone Star Investment-Capital Recovery Water2,010,179.76 Lone Star Investment-Capital Recovery Sewer566,185.34 Capital One-Investment1,718,337.56 Total Cash in Bank & Investments4,674,820.19$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 5,487.354,281,098 - 3,420,729.04 4,303,030.76 -(21,932.76) Miscellaneous2,2501,595.2015,493.9213,358.43 - - TOTAL REVENUES 7,082.554,283,3483,436,222.964,316,389.19 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL 400.00 - 1,150.00 37,360.39 Professional Services - -(37,360.39) Debt Service 189,020.004,276,6673,625,353.504,240,294.03 - - TOTAL GENERAL GOVERNMEN 189,420.004,276,6673,626,503.504,277,654.42 T - - TOTAL EXPENDITURE 189,420.004,276,6673,626,503.504,277,654.42 S - - ** REVENUE OVER(UNDER) EXPEND6,68238,734.77 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 5,487.353,420,729.044,303,030.76 - - TOTAL Taxes4,281,0985,487.35 3,420,729.04-4,303,030.76 - (21,932.76) Miscellaneous 000-491000Interest Earned 750 0.26 14,436.81- 41.19 - 000-491200Investment Earnings1,5001,594.941,057.1121,433.29 - -(19,933.29) 000-497000Misc Income- (8,116.05) - - - - TOTAL Miscellaneous 2,250 1,595.20 15,493.92- 13,358.43 - (11,108.43) TOTAL REVENUES4,283,348 7,082.55 3,436,222.96- 4,316,389.19 - (33,041.19) C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent400.00 1,150.001,550.00 - - -(1,550.00) 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services400-1,150.0037,360.39 - -(37,360.39) Debt Service 101-555612Bond-GO Refunding 2010-Principal 240,000 -- 285,000.00 240,000.00 - 101-555612.1Bond-GO Refunding 2010 Interest82,650 40,125.00 80,502.08- 82,650.00 - 101-555622Schertz C O SR2003-Principal200,000 - 190,000.00- 200,000.00 - 101-555622.1Schertz C O SR2003-Interest 53,800 3,832.50 60,820.00- 11,265.00 -42,535.00 101-555624Comm Proj Bond-SR04-Principal315,000 - 325,000.00- 315,000.00 - 101-555624.1Comm Proj Bond SR04-Interest251,009 6,906.25 265,008.13- 20,703.13 -230,305.87 101-555626LS&D SR2006-Principal 100,000 - - 100,000.00- - 101-555626.1LS&D SR2006-Interest 648,982 - 650,981.25- 648,981.25 - 101-555628CO Bond 2007-Principal 102,900 - 99,709.25- 102,900.00 - 101-555628.1CO Bond 2007-Interest 22,625 - 26,523.79- 22,176.64 - 101-555629GO Bond 2007-Principal 225,000 - 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 - 209,096.25- 198,819.50 - 101-555630GO Bond SR2008 Principal 370,000 - 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 - 379,650.25- 364,679.00 - 101-555631GO Bond SR2009 Principal 200,000 - 140,000.00- 200,000.00 - 101-555631.1BO Bond SR2009 Interest138,156.25278,812.50 278,813 -283,062.50 - 101-555633GO SR2011 Principal 90,000.00- 90,000 - - - 101-555633.1GO SR2011 Interest 532,286.46- 532,287 - - - 101-555634GO SR2011A Refund Principal 140,000.00- - - - -(140,000.00) 97,020.55- 101-555634.1GO SR2011A Refund Interest - - - - TOTAL Debt Service4,276,667189,020.00 3,625,353.50-4,240,294.03 -36,372.47 TOTAL EXPENDITURES4,276,667 189,420.00 3,626,503.50- 4,277,654.42 - TAX I&S CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking2,619.76$ Cash in Investments MBIA Investment- Tax I&S 125,396.02 Federated Investment-Tax I&S56.90 Total Cash in Bank & Investments$128,072.68 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET91.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042222,007.22 1,712,111.92- 2,370,114.87 - 21,927.13 Fund Transfers - 100,000 - 0.00% - - - Miscellaneous 650.5917,20015,661.25 -23,686.05 - TOTAL REVENUES 222,657.812,409,2421,827,773.17 -2,393,800.92 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies28,000529.46 18,960.56-23,721.362,604.49 Utility Service 94,300 7,966.76 57,286.68- 67,146.92 513.54 Maintenance Services 58,500 1,280.20 56,113.50- 45,677.21 2,863.88 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 9,776.42180,800139,360.05 5,981.91136,545.49 L - ECONOMIC DEVELOPMEN T Personnel Services 242,092 30,486.38 141,888.74- 220,907.41 - 21,184.59 Supplies 1,100 - 884.02 610.07 88.33 - Human Services 200 - - - - - City Support Services 41,913 156.80 16,659.44- 9,955.12 18.00 Utility Services 7,200 62.95 - 2,621.49 1,235.50 - 5,964.50 Operations Support 63,600 3,346.01 51,503.79- 50,768.33 540.26 Staff Support 112,800 3,334.19 72,275.30- 79,610.47 5,855.86 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 9,494.20 205,790.16- 192,789.54 39,100.47 Fund Charges/Transfers 105,985 4,665.42 100,001.97- 51,319.62 - 54,665.38 Fund Replenish-Fund Balance - - - 0.00% - - - Debt Service 795,154 29,006.25 792,432.00- 795,154.00 100.00% - Operating Equipment -2,3501,112.82161.94 - - TOTAL ECONO DEVELOPMEN 80,552.201,975,8941,385,169.73 45,602.921,412,512.00517,779.08 T - TOTAL EXPENDITURE 90,328.622,156,6941,524,529.78 51,584.831,549,057.49556,051.68 S - ** REVENUE OVER(UNDER) EXPEND252,548 844,743.43 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: AUGUST 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET91.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042222,007.221,712,111.922,370,114.87 - - TOTAL Taxes2,392,042222,007.22 1,712,111.92- 2,370,114.87 -21,927.13 Fund Transfers 000-486000Transfer In100,000.00- - - - - TOTAL Fund Transfers 100,000.00-- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 5.88 - 241.83 140.82 - 000-491200Investment Earnings 15,000 519.71 - 9,924.72 7,689.89 -7,310.11 000-497000Misc Income 2,000 125.00 - 5,494.70 15,855.34 -(13,855.34) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 650.59 15,661.25- 23,686.05 - TOTAL REVENUES2,409,242222,657.81 1,827,773.17-2,393,800.92 -15,441.08 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: AUGUST 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking91,322.89$ Cash in Investments MBIA Investment-Economic Development Corp2,676,592.04 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,037,007.40 Total Cash in Bank & Investments3,804,922.33$ 4B SALES TAX $350,000 $300,000 26% 40% $250,000 -2% 19% 17% 25% -3% -2% 23% $200,000 12% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 182,541 173,698 267,965 199,040 204,426 287,707 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 164,073 180,483 169,043 2007-08 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING AUGUST 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,747,690.18,244,632.24.0500,963,447.13,460,389.19,747,690.18,747,690.18 303422 TOTAL OPERATIONS2,747,690.18,244,632.24,963,447.13,460,389.19,747,690.18,747,690.18 33422 LOGIC General Fund1,762,342.04,912,029.83.192712.2150,000.00,762,342.04 N/A,762,342.04 103111 G/F-Equipment Replacement73,458.3573,446.330.1927 -12.0273,458.35 N/A73,458.35 G/F-Vehicle Replacement7,090.29,089.10.1927 -.19,090.29 N/A,090.29 70177 G/F-Air Conditioner Replacement146,665.75146,641.750.1927 -24.00146,665.75 N/A146,665.75 ,697,534.02.192777.81,000.00,690,811.83,690,811.83 SR2009 Bond-Street Projects(II)1,690,811.83 102711 TOTAL LOGIC3,680,368.26,836,741.0327.2357,000.00,680,368.26,680,368.26 36133 LONESTA R Capital Recovery - Sewer566,185.34566,071.560.2400 -113.78566,185.34 N/A566,185.34 Capital Recovery - Water2,010,179.76,009,775.79.2400 -03.97,010,179.76 N/A,010,179.76 20422 Drainage Fund383,816.74383,739.610.2400 -77.13383,816.74 N/A383,816.74 GO SR2011 Animal Shelter2,137,239.55,139,316.06.240029.99,506.50,137,239.55 N/A,137,239.55 204222 GO SR2011 Athletic Fields1,483,090.151,482,792.100.2400 -298.051,483,090.15 N/A1,483,090.15 GO SR2011 Soccer Fields1,311,208.79,313,451.30.240063.99,506.50,311,208.79 N/A,311,208.79 102211 GO SR2011 Swimming Pool2,876,045.152,880,951.590.2400579.055,485.492,876,045.15 N/A2,876,045.15 W/S-Customer Deposits294,293.7294,234.58.2400 -9.1494,293.72 N/A94,293.72 20522 W/S-Equipment Repl/Cap.Imp373,867.15373,792.020.2400 -75.13373,867.15 N/A373,867.15 Water&Sewer1,360,612.74,360,339.31.2400 -73.43,360,612.74 N/A,360,612.74 10211 W/S-Vehicle Replacement545,143.01545,033.460.2400 -109.55545,143.01 N/A545,143.01 04,237.88.24001.25-04,319.1304,319.13 Water/SSLG - SAWS404,319.13 40844 TOTAL LONESTA13,746,001.233,753,735.26,764.460,498.493,746,001.233,746,001.23 R12111 MBIA Tax I&S125,396.02110,314.170.2400 -15,081.85125,396.02 N/A125,396.02 Police Forfeiture359,843.5559,771.50.2400 -2.0559,843.55 N/A59,843.55 30733 Economic Development Corporation2,676,592.042,476,072.330.2400 -200,519.712,676,592.04 N/A2,676,592.04 Hotel Tax250,143.0750,092.96.2400 -0.1150,143.07 N/A50,143.07 20522 Special Events Fund46,683.3146,673.940.2400 -9.3746,683.31 N/A46,683.31 01,297.67.24000.33-01,358.0001,358.00 EMS Tax Notes 2010301,358.00 30633 TOTAL MBIA3,760,015.99,544,222.57 -15,793.42,760,015.99,760,015.99 3233 FEDERATED SR2007a Bond-City Wide Projects869,156.99869,036.180.1600 -120.81869,156.99 N/A869,156.99 Hotel Occupancy Tax78,255.598,244.71.1600 -0.888,255.59 N/A8,255.59 70177 Park Fund (Developers Fee)167,389.00193,014.270.160025.8325,651.10167,389.00 N/A167,389.00 Park Fund (Tree Mitigation)152,101.0926,431.41.1600 -5,669.6852,101.09 N/A52,101.09 10211 Tax I&S56.9056.890.1600 -0.0156.90 N/A56.90 4,748.48.1600.22-4,754.704,754.70 Library Board Fund44,754.70 40644 TOTAL FEDERATED1,311,714.27,311,531.945,833.435,651.10,311,714.27,311,714.27 12211 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,271,403.231,337,205.762.9600 277.113,562.681,340,491.33 N/A1,341,093.06 ,748,631.47.0900,662.61355.11,752,938.97,718,337.56 Capital One Capital Recovery1,622,509.46 13411 TOTAL CAPITAL ONE2,893,912.69,085,837.23 632.22,225.29,093,430.30,059,430.62 3833 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 7% 9% 10% TOTAL LOGIC 12% TOTAL FEDERATED 4% TOTAL MBIA 12% TOTAL LONESTAR 46% City Portfolio By Use Pooled-Daily Operations, Designated Funds, $2,747,690.18 $7,283,580.91 $10,771,871.59 Special Revenue Funds, Debt Service Fund, $9,053,879.97 $125,452.92 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.04000.08000.05000.07000.03000.07000.07000.0900 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.10000.07000.10000.11000.0900 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.15000.14000.14000.14000.1400 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.53000.51000.50000.50900.5052 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.40000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.30000.30000.30000.30000.30000.30000.30000.3000 CD 180 Days 0.25000.25000.10000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.25130.28600.29420.28640.26830.25140.23790.1927 LOGIC 0.23000.25000.28000.31000.26000.27000.27000.24000.25000.25000.2400 LoneStar 0.14000.15000.19000.21000.25000.24000.25000.26000.26000.24000.2400 MBIA 0.09000.14000.13000.15000.22000.21000.19000.18000.18000.17000.1600 Federated 2.32432.84002.83003.07003.07003.15003.15003.13003.03003.04003.0300 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:8/31/2012 General Fund Assets P DueMaturitySharesCostMrk Value Cash & Equivalents Fidelity Inst Prime Mmkt Cl III #69111,403.2311,403.2311,403.231.000.01 JPMorgan Chase Disc Coml Paper9/21/201221.0040,000.00 39,940.3339,940.33 Total Cash & Equivalents1,403.2351,343.561,343.56 55 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014712.00125,000.00141,987.30137,881.256,875.00 Federal Home Loan Bks Cons Bds6/21/2013294.0080,000.0082,004.4081,083.201,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151202.00100,000.00116,185.00114,459.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/201247.0050,000.0054,010.5050,261.002,250.00 Federal Home Ln Mtg Corp Deb11/15/2013441.00170,000.00191,084.25179,622.008,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013389.00250,000.00250,000.00261,027.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014816.00200,000.00200,609.40201,914.001,500.00 Federal Natl Mtg Assn 7/28/20151061.00125,000.00132,828.63132,262.502,968.00 US Treasury Note11/30/20151186.0020,000.0020,680.4720,673.60275.00 US Treasury Note2/28/2014546.00100,000.0099,757.82100,071.00 Total Fixed Income,220,000.001,289,147.77,279,255.05 113 Total Assets21.70,271,403.231,340,491.33,330,598.61 6113 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #6917,509.467,509.467,509.461.000.01 JPMorgan Chase Disc Coml Paper9/21/201221.0080,000.0079,880.6779,880.67 Total Cash & Equivalents7,509.4687,390.137,390.13 88 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014712.00165,000.00187,423.24182,003.259,075.00 Federal Home Loan Bks Cons Bds6/21/2013294.00100,000.00102,505.50101,354.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151202.00200,000.00230,779.00228,918.009,750.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/201247.00150,000.00162,031.50150,783.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013441.00250,000.00281,006.25264,150.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013410.00200,000.00223,001.60209,876.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014816.00220,000.00220,078.68222,105.401,650.00 Federal Natl Mtg Assn7/28/20151061.00135,000.00143,454.91142,843.503,206.00 US Treasury Note11/30/20151186.0015,000.0015,510.3515,505.20206.00 US Treasury Note/28/201446.0000,000.0099,757.8100,071.00 2511 Total Fixed Income,535,000.001,665,548.84,617,609.35 115 Total Assets610.561,622,509.461,752,938.971,704,999.485