Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08-MAY 2011 STATEMENT
MAY 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department June 30, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes10,912,656 474,913.61 8,308,496.42- 9,684,787.58 -1,227,868.42 Franchises 1,521,000 160,110.66 1,065,742.01- 1,034,920.98 -486,079.02 Permits 1,181,913 68,669.30 649,335.32- 1,305,380.13 -(123,467.13) Licenses 64,547 2,835.00 27,646.50- 26,880.60 -37,666.40 Fees 3,073,872 210,822.22 1,701,731.16- 1,893,764.24 (1,111.55) Fines 35,000 2,143.35 19,627.73- 17,060.91 -17,939.09 Inter-Jurisdictional 405,672 7,200.98 311,105.53- 223,050.63 -182,621.37 Fund Transfers 1,184,474 88,620.07 583,496.59- 786,046.36 -398,427.64 Miscellaneous507,28447,923.01341,285.12353,039.28 - - TOTAL REVENUES18,886,4181,063,238.2013,008,466.3815,324,930.71(1,111.55) - - EXPENDITURE SUMMARY GENERAL GOVERNMENT CITY COUNCIL Personnel Services22,800 1,813.46 - 5,107.14 15,371.99 - Supplies500 - - 120.69 239.97 - City Support Services 20,500 148.00 - 8,649.50 13,080.87 224.01 Operations Support300--116.80127.40 - Staff Support16,400360.29380.00 7,850.6110,778.93834.82 Opertating Equipment -- - - - - TOTAL CITY COUNCIL60,5002,321.75380.0021,844.7439,599.161,058.83 CITY MANAGE R Personnel Services 60,229.80753,457 - 449,300.75 484,139.60 -269,317.40 Supplies1,526 - - 955.62 711.05 132.93 682.02 - - 32.00 - City Support Services - - Operations Support - - - - - - Staff Support 24,850 591.29 438.80 8,773.95 16,644.72 1,343.12 1,393.36-899.95 Operating Equipment1,574 - - TOTAL CITY MANAGER 60,821.09781,407 438.80 459,062.32 502,888.73 2,376.00 276,581.07 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services 18,766.10250,203 - 146,560.92 159,230.90 -90,972.10 Supplies3,200 52.58 - 729.43 697.34 160.40 2,342.26 City Support Services1,000 - - - - - Operations Support3,000 785.00 - 2,253.00 1,951.00 - Staff Support6,200 153.82 33.44 1,922.41 1,690.86 202.52 4,340.06 Court Support800 - - - - - Professional Services 84,600 5,565.00 33,305.23- 34,244.00 10,255.00 Maintenance Services 2,500 - - - 600.00 - Operating Equipment2,000150.00 650.00903.98 - - TOTAL MUNICIPAL COURT 25,472.50353,503 33.44 185,674.97 199,064.10 10,617.92 143,854.42 CUSTOMER RELATIONS-311 Personnel Services88,928 6,325.78 - 59,557.24 54,438.18 -34,489.82 Supplies500 - - 81.95 49.84 36.84 413.32 Staff Support1,105543.00 543.00-261.03 - TOTAL CUSTOMER RELATIONS-311 90,533 6,868.78 59,639.19- 55,031.02 297.87 PLANNING & ZONING Personnel Services 134,105 11,933.24 83,061.24- 88,188.19 -45,916.81 Supplies 4,500 142.35 - 124.75 259.39 - City Support Services - - - - - - Operations Support 2,300 - - 183.16 77.95 - Staff Support 22,100 1,527.12- 7,218.48 3,232.12 178.63 Professional Services 142,300 4,083.77 - 52,072.45- 76.57 Operating Equipment600 1,055.00- - - - TOTAL PLANNING & ZONING 305,905 16,159.36 1,527.12 90,587.63 144,885.10 255.20 LEGAL SERVICES Operations Support 13,000 - - 7,624.24 8,117.96 - Professional Services245,00051,926.5081,077.85 - - TOTAL LEGAL SERVICES 258,000 51,926.50 88,702.09- 124,732.89 -133,267.11 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services 45,892.19630,024 - 375,622.59 410,343.62 -219,680.38 Supplies59,900 4,823.87 638.43 31,320.01 44,233.66 8,069.70 8,235.07 Utility Services93,600 5,940.18 - 56,581.87 46,148.94 -47,451.06 - - - - Operations Support - - Staff Support 10,212 147.71 403.00 3,703.39 6,832.00 1,216.57 Maintenance Services 108,500 8,557.63 6,471.04 66,640.18 92,026.01 11,431.60 Rental/Leasing 2,000 - - 607.35 763.92 - Operating Equipment950989.10 -1,278.55 - - 2,524.53- Capital Outlay24,500 - - - TOTAL FACILITIES MAINTENANCE 929,686 66,350.68 7,512.47 534,475.39 604,151.23 20,717.87 CITY SECRETARY Personnel Services 12,289.48167,842 - 105,859.53 107,115.15 -60,726.85 Supplies1,550 11.98 - 622.23 1,061.95 47.14 440.91 City Support Services6,788 3,348.22 - 4,574.71 6,788.22 - Operations Support - - - - - - Staff Support5,700(140.67)295.00 3,151.102,284.69224.42 TOTAL CITY SECRETARY 181,880 15,509.01 295.00 113,341.16 118,116.42 271.56 NON-DEPARTMENTA L Supplies 3,000 - - 4,781.60 395.35 - City Support Services 361,407 3,272.21 760.00 301,912.52 250,095.57 70.00 Operations Support 115,500 7,964.75 82,283.98- 85,570.12 456.51 City Assistance 390,552 - 426,747.67- 326,077.60 -64,474.40 Professional Services 99,521 (31,709.36) 50,238.75- 47,858.54 -51,662.46 Fund Chrgs/Transfrs-Spec Events Fnd 24,350 - 49,100.00- - -24,350.00 Operating Equipment 500 - - 264.95 - - 17,270.51 - Capital Outlay7,000 - - - TOTAL NON-DEPARTMENTAL 1,001,830 (20,472.40) 760.00 932,599.98 709,997.18 526.51 PUBLIC AFFAIRS Personnel Services 11,476.12138,096 - 133,271.24 95,582.08 -42,513.92 Supplies2,450 (85.81) - 1,572.28 374.24 92.09 1,983.67 Operations Support34,500 2,112.65 - 45,078.74 11,061.68 1,212.97 22,225.35 Staff Support3,750 112.55 - 1,903.01 1,197.45 306.42 2,246.13 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Professional Services - 185,552.47- - - - Operating Equipment6,000 1,894.781,399.71 - - - TOTAL PUBLIC AFFAIRS184,79613,615.51 368,777.45-110,110.231,611.48 RECORDS MANAGEMEN T Personnel Services46,3173,505.16 28,520.87-30,037.06 -16,279.94 Supplies 900 157.27 - 11.20 232.27 - Staff Support 1,500 - - 706.00 641.90 173.24 Professional Services 17,992 1,037.50 - 4,758.90 7,776.64 550.00 -- Operating Equipment - - - - TOTAL RECORDS MANAGEMENT 66,709 4,699.93 33,996.97- 38,687.87 723.24 SCHERTZ TALES MAGAZINE Personnel Services 9,860.38126,426 - - 80,536.25 -45,889.75 Staff Support1,000 - - - - 38.28 961.72 Professional Services258,50020,656.23 148,534.40-11,737.08 - TOTAL SCHERTZ TALES MAGAZINE385,92630,516.61- 229,070.65-11,775.36 ENGINEERING Personnel Services 169,469 12,348.59 103,365.17- 106,288.97 -63,180.03 Supplies 300 - - 39.95 67.35 55.09 Staff Support 2,213 - - 1,130.00 395.00 222.00 Professional Services 24,000 3,053.75 - 4,410.68 18,391.25 - Maintenance Services 4,044 - - 1,200.00 2,745.24 - -- Operating Equipment - - - - TOTAL ENGINEERING 200,026 15,402.34 110,145.80- 127,887.81 277.09 GIS Personnel Services 117,358 8,921.34 72,873.31- 75,195.94 -42,162.06 Supplies 3,300 - - 108.00 1,113.00 1,422.97 Staff Support 1,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 123,708 8,921.34 72,981.31- 76,308.94 1,422.97 TOTAL GENERAL GOVERNMENT 4,924,409 298,113.00 10,946.83 3,071,829.00 3,080,531.33 51,931.90 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,083,030 298,416.10 - 2,654,042.92 2,747,245.67 -1,335,784.33 Supplies50,558 2,439.08 124.50 11,414.16 9,911.66 13,026.32 27,744.52 City Support Services30,000 - - 32,003.00 - -30,000.00 Utility Services100,000 10,247.91 - 53,996.86 57,873.97 -42,126.03 Operations Support2,000 95.00 - 342.50 193.00 - Staff Support31,350 2,471.08 - 5,946.50 8,338.31 729.13 22,282.56 City Assistance13,000 520.00 - 5,135.95 2,184.98 1,949.00 8,866.02 Professional Services8,000 875.00 - 4,803.36 875.00 1,055.16 6,069.84 Maintenance Services76,949 473.95 179.50 40,273.41 22,570.80 492.00 54,065.70 Operating Equipment63,996 11,838.00 5,196.00 33,912.05 43,573.12 6,589.00 19,029.88 Capital Outlay169,998114,837.60153,726.40 - - - TOTAL POLICE 4,628,881327,376.125,500.002,956,708.313,046,492.9123,840.61 FIRE RESCUE Personnel Services 2,410,836 189,076.44 1,459,404.52- 1,584,740.76 -826,095.24 Supplies 20,200 168.13 20.15 5,386.49 4,824.02 171.19 Utility Services 43,900 4,033.70 25,147.37- 27,309.55 1,450.52 Operations Support 1,100 - - 299.97 120.00 - Staff Support 108,800 7,267.80 12,138.00 46,067.13 55,648.70 26,093.92 City Assistance 18,600 10,323.17- 2,715.75 10,323.17 7,567.46 Professional Services 18,140 - - - 1,500.00 12,740.00 Maintenance Services 55,000 3,326.29 13,101.77- 18,509.50 13,830.13 750.15604.5014,810.75 27,365.481,500.94 Operating Equipment52,400 TOTAL FIRE 2,728,976 204,622.51 23,085.82 1,566,933.75 1,730,341.18 63,354.16 INSPECTIONS Personnel Services 364,194 27,479.26 220,760.55- 234,676.86 -129,517.14 Supplies 6,750 51.91 375.00 401.35 642.12 409.27 Utility Services 7,600 426.10 - 2,287.92 3,096.19 - Operations Support 3,200 - - 375.00 439.87 399.00 Staff Support 14,700 106.00 388.20 3,433.83 2,409.15 499.20 Professional Services 10,000 - - 459.00 - -10,000.00 Maintenance Services - - - - - - Operating Equipment -- - - - - TOTAL INSPECTIONS 406,444 28,063.27 763.20 227,717.65 241,264.19 1,307.47 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MARSHAL SERVICE Personnel Services 38,062.94486,250 - 237,122.10 288,590.88 -197,659.12 Supplies6,450 226.65 - 1,170.22 392.95 266.61 5,790.44 Utility Services9,000 1,225.22 - 3,727.38 5,103.77 - Operations Support4,000 462.50 - 375.00 829.99 872.50 2,297.51 Staff Support9,400 268.94 - 2,599.69 1,821.18 185.99 7,392.83 - - - - Professional Services - - Maintenance Services 12,400 36.00 - 2,205.53 7,489.85 255.00 Operating Equipment21,4804,748.77 12,939.75-177.36 - 4,623.76 50,150.03-5,110.50 Capital Outlay65,600 - TOTAL MARSHAL SERVICE 614,580 49,654.78 247,199.92- 367,318.40 6,867.96 TOTAL PUBLIC SAFETY 8,378,881 609,716.68 29,349.02 4,998,559.63 5,385,416.68 95,370.20 PUBLIC ENVIRONMENT STREETS Personnel Services596,591 38,916.37 - 379,763.18 378,723.78 -217,867.22 Supplies6,120 219.50 28.15 2,856.94 3,165.33 323.75 2,659.07 Utility Services101,900 11,962.84 - 58,062.82 69,038.05 444.90 32,417.05 Operations Support1,380 - - - - 21.00 1,359.00 Staff Support9,265 45.88 84.08 3,514.09 4,082.30 992.82 4,273.96 Maintenance Services155,400 14,922.20 16,620.12 58,190.46 107,170.50 1,675.09 63,174.53 Rental/Lease200 - - - - - Operating Equipment 4,380 179.99 - - 4,379.99 - Capital Outlay14,500 13,670.00- - - - TOTAL STREETS 889,736 66,246.78 16,732.35 502,387.49 580,229.95 3,457.56 TOTAL PUBLIC ENVIRONMENT 889,736 66,246.78 16,732.35 502,387.49 580,229.95 3,457.56 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services475,862 36,299.18 - 296,004.14 306,401.32 -169,460.68 Supplies40,355 2,328.18 - 38,630.60 22,013.24 2,939.73 15,402.05 - - - - City Support Services - - Utility Services 110,000 8,420.41 64,468.47- 69,924.24 376.46 Operations Support 700 - 600.00 - 880.80 - Staff Support 7,686 - 202.35 6,198.98 5,801.97 457.27 Professional Services 53,278 5,000.00 - 951.80 24,445.00 -28,833.00 Maintenance Services 21,000 1,953.79 31,237.16- 12,590.94 1,301.57 Rental/Leasing 30,531 3,290.87 3,491.50 5,346.88 27,051.43 - Operating Equipment 200 - - 5,974.00 3,494.99 -(3,295.01) Capital Outlay7,000 2,893.50- - - - TOTAL PARKS DEPARTMENT746,61257,292.434,293.85448,812.03475,497.435,075.03 SWIM POOL Supplies 16,700 1,024.15 123.66 3,922.78 5,994.33 1,545.85 Utility Services 25,500 1,058.44 13,017.31- 7,413.16 -18,086.84 Staff Support 925 - - 439.98 - - Maintenance Services 199,378 45.50 - 3,723.22 4,826.27 1,775.00 378.00- Rental/Lease500 - - - TOTAL SWIM POOL 2,128.09243,003 123.66 21,103.29 18,611.76 3,320.85 221,194.05 COMMUNITY/CIVIC CENTER Personnel Services112,341 7,308.07 - 49,218.93 48,749.16 -63,591.84 Supplies6,423 264.36 - 3,340.26 5,611.38 258.85 552.77 Utility Services47,150 3,408.73 - 22,928.08 19,812.57 -27,337.43 Operations Support14,682 422.75 - 12,019.13 5,667.26 837.00 8,177.74 Staff Support3,250 127.47 - 422.47 377.47 267.96 2,604.57 Professional Services600 - - - 925.00 - Operating Equipment7,17233,303.10 285.003,845.00 - - TOTAL COMMUNITY/CIVIC CNTR 191,618 11,531.38 121,231.97- 81,427.84 5,208.81 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET SENIOR CITIZEN CENTER - - - 124.57 - Supplies - - Utility Services - - 2,754.40 174.42 - - City Assistence - - 4,350.00 - - - Maintenance Services -1,082.50 - - - - TOTAL SENIOR CITIZEN CENTER--8,311.47174.42 - - TOTAL PARKS & RECREATION 1,181,233 70,951.90 4,417.51 599,458.76 575,711.45 13,604.69 CULTURAL LIBRARY Personnel Services 51,041.41667,832 - 388,688.35 437,389.39 -230,442.61 Supplies16,400 10.00 - 11,068.60 5,168.65 3,544.42 7,686.93 Utility Services39,500 3,539.13 - 28,992.92 25,382.87 -14,117.13 Operations Support2,500 - - 1,290.00 70.00 - Staff Support4,185 244.58 23.25 2,624.39 1,243.04 196.77 2,768.44 Professional Services2,100 - - 200.68 2,065.00 - Maintenance Services 3,500 - - 2,896.25 1,200.00 - Operating Equipment 65,000 15,129.93 47.36 38,875.97 38,127.35 15,133.83 Capital Outlay10,500.00 10,500.00- - - - TOTAL LIBRARY 801,017 69,965.05 10,570.61 474,637.16 521,146.30 18,875.02 TOTAL CULTURAL 801,017 69,965.05 10,570.61 474,637.16 521,146.30 18,875.02 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICE S Personnel Services 22,524.11302,083 - 171,025.30 197,200.34 -104,882.66 Supplies24,900 1,479.39 42.00 11,539.20 11,347.31 1,805.12 11,789.57 Utility Services9,900 765.01 - 5,161.97 6,178.48 - Operations Support800 - - 263.00 - - Staff Support 5,800 50.00 - 4,595.84 1,652.00 - City Assistance 13,000 639.52 - 3,780.57 6,471.48 - Professional Services 14,500 1,031.00 - 6,811.50 6,575.00 362.90 Maintenance Services 6,100 - (112.00) 1,043.83 1,926.78 1,414.45 Operating Equipment9,0001,441.55 277.902,004.76385.96 - 3,995.00- Capital Outlay4,000 - - - TOTAL ANIMAL SERVICES 390,083 27,930.58 (70.00) 204,499.11 237,351.15 3,968.43 TOTAL HEALTH 390,083 27,930.58 (70.00) 204,499.11 237,351.15 3,968.43 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 20,850.41261,085 - 145,517.49 168,206.42 -92,878.58 Supplies1,500 94.61 - 497.53 533.62 416.40 549.98 City Support Services337,952 17,950.53 - 65,627.49 166,962.45 11,491.35 159,498.65 Utility Services147,131 16,778.27 - 63,797.13 86,225.51 -60,905.49 Staff Support10,400 1,684.89 1,813.95 2,722.73 4,970.57 919.44 6,323.94 - - - - Professional Services - - Maintenance Services 21,100 1,481.70 22,198.12- 14,604.48 432.65 Operating Equipment 135,836 8,332.08 58,164.35- 53,629.58 39,866.84 35,880.0010,527.00 35,880.009,900.00 Capital Outlay45,809 - TOTAL INFORMATION TECHNOLOGY 960,813 103,052.49 1,813.95 369,051.84 531,012.63 63,026.68 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services222,521 14,539.31 - 133,343.83 138,499.79 -84,021.21 Supplies1,700 (142.56) - 264.00 491.22 - Human Services46,122 2,600.87 - 25,566.13 20,582.45 454.46 25,085.09 Operations Support12,545 - 266.28 8,203.78 6,654.41 3,195.56 2,961.31 Staff Support10,982 15.08 - 5,798.49 5,936.18 316.00 4,729.82 City Assistance9,425 1,566.00 - 6,018.00 4,806.00 - Professional Services2,500 - - - - - -1,491.55 Operating Equipment - - - - TOTAL HUMAN RESOURCES 18,578.70305,795 266.28 180,685.78 176,970.05 3,966.02 125,125.21 FINANCE Personnel Services419,818 29,752.80 - 265,884.44 267,415.21 -152,402.79 Supplies3,600 51.25 - 2,108.18 1,966.69 13.30 1,620.01 Operations Support1,050 - - 155.80 - 350.00 700.00 Staff Support13,370 2,204.00 74.30 5,315.39 7,846.61 647.33 4,950.36 Maintenance Services630 - - - - - 880.68-197.12 Operating Equipment5,699 - - TOTAL FINANCE 444,167 32,008.05 74.30 273,463.81 278,109.19 1,207.75 PURCHASING & ASSET MGT Personnel Services 17,798.79234,220 - 150,893.39 151,624.75 -82,595.25 Supplies2,300 260.14 - 437.39 494.72 65.55 1,739.73 Utility Services1,200 - - 257.92 185.42 - Operations Support150 - - - 60.68 - Staff Support 6,900 803.50 - 3,776.15 4,057.77 746.03 Operating Equipment150 -- - - - TOTAL PURCHASING & ASSET MGT244,92018,862.43 155,364.85-156,423.34811.58 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services148,533 11,062.39 - 96,454.43 101,828.82 -46,704.18 Supplies101,000 7,385.10 4,701.70 67,300.21 68,560.88 7,010.72 30,130.10 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,000 551.81 - 2,922.87 2,746.24 - Operations Support 400 - - - 375.00 - Staff Support 2,435 11.47 - 916.34 1,095.20 412.39 Professional Services - - - - - - Maintenance Services 45,750 16,105.86 474.24 15,278.08 39,630.70 3,369.48 Rental/Lease200 -150.00 - - - 3,193.74 3,973.90- Operating Equipment6,000 - - TOTAL FLEET SERVICE 312,818 38,310.37 5,175.94 184,371.93 219,860.74 10,792.59 TOTAL INTERNAL SERVICE 2,268,513 210,812.04 7,330.47 1,162,938.21 1,362,375.95 79,804.62 MISC & PROJECTS CITY ASSISTANC E Utility Services---214.21 - - Patient Assistance 5,000 - - 5,000.00 5,000.00 - Children's Advocacy Assistance 5,000 - - 5,000.00 - - 31,500.00-10,500.00 Senior Citizen's Hot Meals42,000 - - TOTAL CITY ASSISTANCE 52,000 - 10,000.00- 36,714.21 10,500.00 COURT - RESTRICTED FUNDS Operating Equipment1,090.00 1,090.00-6,480.00 - - TOTAL CITY ASSISTANCE - - 1,090.00 6,480.00 (7,570.00) -1,090.00 TOTAL MISC & PROJECTS52,000 1,090 - 10,000 37,804 16,980 (2,784.21) TOTAL EXPENDITURES18,885,873 1,354,826.03 79,276.79 11,024,309.36 11,780,567.02 283,992.42 6,900,590.02 REVENUE OVER(UNDER) EXPEND.5453,544,363.69 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,704,566 43,107.78 6,211,155.84- 6,697,609.53 - 000-411200Advalorem Tax - Delinquent 50,000 1,728.38 48,835.05- 42,424.47 - 000-411300Advalorem Tax - P&I 50,000 4,228.99 33,835.25- 33,788.28 - 16,211.72 000-411500Sales Tax Revenue-Gen Fund4,071,590 425,848.46 1,987,184.33- 2,884,479.96 - 1,187,110.04 000-411600Bingo Tax 4,500 - - 3,684.07 1,132.33 - 000-411700Mixed Beverage Ta23,801.8825,353.01 x 32,000.00 - - - TOTAL Taxes10,912,656 474,913.61 8,308,496.42- 9,684,787.58 - 1,227,868.42 Franchises 000-421200Center Point/Entex Energy 33,000 9,487.05 23,991.96- 36,110.15 - (3,110.15) 000-421220City Public Service 275,000 67,561.08 202,098.02- 213,685.81 - 61,314.19 000-421240Guadalupe Valley Elec Co-op 430,000 - 349,689.22- 311,679.19 - 118,320.81 000-421250New Braunfels Utilities 30,000 - 12,228.49- 13,037.36 - 16,962.64 000-421300Time Warner-State Franchise 350,000 79,872.30 245,855.96- 249,675.43 - 100,324.57 000-421350Time Warner-PEG Fee 62,000 15,974.46 46,299.97- 48,761.43 - 13,238.57 000-421460AT&T Franchise Fee 220,000 31,008.35 114,037.87- 119,684.64 - 100,315.36 000-421465AT&T PEG Fees 16,000 6,201.67 12,782.24 17,533.57 - (1,533.57) 000-421480Other Telecom Franchise 15,000 17,566.83 - 8,275.55 31,032.86 - (16,032.86) 000-421500Solid Waste Franchise Fee90,00050,482.7361,281.62 - - - TOTAL Franchises1,521,000227,671.74 1,065,742.01-1,102,482.06 - 418,517.94 Permits 000-431100Home Occupation Permit 770 - - 385.00 280.00 - 000-431200Building Permit 837,952 43,691.00 448,861.52- 1,047,285.83 - (209,333.83) 000-431300Mobile Home Permit 671 - - 80.00 80.00 - 000-431400Signs Permit 8,596 50.00 - 340.00 470.00 - 000-431500Food Establishmnt Permit 15,000 600.00 12,875.00- 14,120.00 - 000-431600Garage Sale Permit 9,554 940.00 - 7,485.30 6,785.00 - 000-431700Plumbing Permit 109,769 7,313.30 57,835.50- 83,063.80 - 26,705.20 000-431750Electrical Permit 63,062 3,860.00 37,255.50- 53,720.00 - 000-431800Mechanical Permit 84,211 5,720.00 49,834.00- 59,600.00 - 24,611.00 000-431900Solicitor/Peddler Permit 630.00 - 630.00 950.00 - - 000-431950Animal/Pet Permit 2,000 - - 1,315.00 1,385.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt6,5781,000.00-3,900.004,000.00 - 000-432100Security Alarm Permit 36,000 4,040.00 24,001.00- 27,478.00 - 000-435000Fire Permit7,750825.00 6,162.504,537.50 - - TOTAL Permits1,181,91368,669.30 649,335.32-1,305,380.13 - (123,467.13) Licenses 000-441000Alcohol Beverage License 6,100 235.00 - 3,397.50 3,017.50 - 000-442000Contractors License 55,447 2,150.00 20,853.00- 20,850.00 - 34,597.00 000-444000Pet License3,000450.00 3,013.103,396.00 - - TOTAL Licenses 64,547 2,835.00 27,646.50- 26,880.60 - 37,666.40 Fees 000-451000Municipal Court Fines 1,540,000 94,356.12 818,362.46- 727,107.23 - 812,892.77 000-451100Arrest Fee 60,000 4,026.84 35,111.88- 30,618.03 - 29,381.97 000-451110Expunction Fee 90 - - 30.00 - - 000-451200Warrant Fees 187,500 14,992.20 87,931.65- 90,582.99 - 96,917.01 000-451320Civil Justice Fee-Court 500 6.00 30.48 45.58 - 000-451340Judicial Fee - City 7,000 552.85 - 4,572.10 4,101.67 - 000-451400Traffic Fine Costs TTL 30,000 2,016.48 18,151.89- 15,373.02 - 14,626.98 000-451500Teen Court Admin Fee 500 40.00 - 460.00 260.00 - 000-451510Juvenile Case Mgmt Fee 60,000 4,611.47 38,100.07- 34,199.30 - 25,800.70 000-451600Technology Fund Fee 55,000 3,711.20 31,237.53- 27,772.27 - 27,227.73 000-451700Security Fee 40,000 2,783.40 23,440.32- 20,838.21 - 19,161.79 000-451800Time Payment Fee - City 5,000 291.33 - 2,709.12 4,040.98 - 000-451850State Fines 10% Service Fee 70,000 - 50,640.93- 49,510.11 20,489.89 000-451900DPS Payment - Local 12,250 1,120.55 - 7,081.19 7,438.63 - 000-452000Child Safety Fee 8,000 1,798.36 - 5,711.82 8,528.78 - 000-452050Indigent Defense Fee 22,500 1,804.46 14,687.01- 13,210.78 - 000-452100Platting Fees 66,000 6,500.00 36,750.00- 45,500.00 - 20,500.00 000-452200Site Plan Fee 26,400 500.00 21,149.45- 17,000.00 - 000-452300Plan Check Fee 375,000 22,458.00 225,356.91- 530,274.91 - (155,274.91) 000-452310Miscellaneous Review Fee 900.00 - 3,900.00 900.00 - - 000-452320Tree Mitigation Admin Fee 11,220 - - 9,468.75 - - 11,220.00 000-452400BOA/Zoning Fees 11,000 - - 7,300.00 1,400.00 - 000-452500Food Handler Class 8,000 350.00 - 3,150.00 5,110.00 - 000-452600Specific Use/Zone Chng Fee 14,630 650.00 - 4,000.00 11,650.00 - 000-452610Plat Recording Fee - - - - - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights--375.00300.00 - - 000-453100Reinspection Fees 49,000 3,600.00 32,193.02- 29,250.00 - 19,750.00 000-453110Swim Pool Inspection Fee 225.00 - 1,200.00 1,050.00 - - (1,050.00) 000-453120Inspections Plan Review - - 833.00 - - - 000-453200Mowing Fees - Inspections 75.00 - 2,039.56 11,045.60 - - (11,045.60) 000-453211Admin Fee-Inspections 600.00 - 5,800.00 4,900.00 - - (4,900.00) 000-4532153% Technology Fee - - 531.40 1.98 - 000-453310Misc Inspection Fee - - 40.00 40.00 - 000-453500SubContractor Reg. Fee 12,035.00- 18,555.00 - 1,690.00 - (18,555.00) 000-453710Foster Care 50.00 - 350.00 650.00 - - 000-454100Swim Pool Reservation Fee - - - - - 000-454200Pool Gate Admission Fee 22,000 - - - - - 22,000.00 000-454300Seasonal Pool Pass Fee 5,500 - - - - - 000-456500Haz Mat Fees2,500 - - 370.00 - - 000-456510Fire Plan Review 800 - - - - - 000-456600Fire Re-inspection Fee 450 50.00 - 350.00 700.00 - 000-458100Sale of Merchandise 17.00 - - 17.00 - - 000-458300Sale of Property/Auction 20,000 18,111.71 - 6,050.25 20,557.80 (1,111.55) 000-458400Civic Center Rental Fees 226,000 13,562.25 121,044.70- 83,780.00 - 142,220.00 000-458401Capital Recovery Fee-Civic Cntr - - - 1,060.00 - 000-458450North Center Rental Fees 24,000 1,535.00 - - 6,722.00 000-458500Community Center Rental Fees32,000 1,787.00 21,615.76- 11,316.02 - 20,683.98 000-458550Pavilion Rental Fees - 12,825.70- - 2,509.00 000-458560Chamber of Comm rent - - - 5,850.00 - - (5,850.00) 000-458570Non-Resident SYSA League 18,000 - 17,761.00- 7,060.00 - 10,940.00 000-458600Ball Field Use - - - 1.76 - - 000-458650NonResident User Fee-BVYA9,000--5,230.002,820.00 - 000-458680Tournament Fees-Soccer 14,000 - - - 2,400.00 - 11,600.00 000-458700Vehicle Impoundment 5,000 - - 2,442.75 - - 000-459200NSF Check Fee 100 220.00 - 119.00 548.00 - 000-459300Notary Fee 200 24.00 - 171.00 279.00 - 000-459400Maps, Copies, UDC, & Misc F 200 5.00 - 125.56 608.18 - 000-459600Animal Adoption Fee 10,500 840.00 - 6,977.50 7,506.50 - 000-459700Pet Impoundment Fee 17,500 1,968.00 10,748.00- 14,449.01 - 000-459800Police Reports Fee6,532484.00 4,008.203,995.10 - - TOTAL Fees 3,073,872 210,822.22 1,701,731.16- 1,893,764.24 (1,111.55) 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines35,0002,143.3519,627.7317,060.91 - - TOTAL Fines 35,000 2,143.35 19,627.73- 17,060.91 - 17,939.09 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,078 - - 7,025.92 7,025.92 - 14,052.08 000-473200City of Seguin - Fire Contract 40,293 3,355.26 26,842.08- 26,842.08 - 13,450.92 000-473300Guad Co - Library 180,816 - 120,543.28- 105,476.00 - 75,340.00 000-473400Randolph AFB-Animal Cntrl 2,500 100.00 - 1,808.00 1,400.00 - 000-474200Library Services - Cibolo - - - - - - 000-474210Library Services-Selma 19,000 - 14,940.00- - - 19,000.00 000-474250Non-Resident Library Fees - - - - - - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 66,652.90 - 66,652.10 000-474500Dispatch Service - SCUCISD 2,080 - - 2,080.00 - - 000-474600School Crossing Guard-Bexar6,600623.04 4,561.254,550.97 - - 000-474610School Cross Guard-Guadalupe3,122.68 11,102.76- - - - TOTAL Inter-Jurisdictional 405,672 7,200.98 311,105.53- 223,050.63 - 182,621.37 Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.00 43,920.00-58,560.00 - 29,280.00 000-480100Indirect Costs - Hotel/Motel 170,221 14,185.08 63,816.00- 113,480.66 - 56,740.34 000-482100Transfer From Reserves-Ct Tech - - - - - 000-482150Transfer From Court Security 58,011 - - - 58,011.00 000-485000Interfund Charge-Drainage 38,888 3,191.50 19,149.00- 25,827.00 - 13,061.00 000-486000Interfund Chrges-Admin W&S 624,777 52,064.75 319,473.97- 416,518.00 - 208,259.00 000-486202Transfer In-W&S - 15,420.52- - - - 000-486317Transfer From Park Fund - - 4,133.27 - - - 000-486322Transfer-In - Library Grants 10,000 - - - 10,000.00 000-486402Transfer from City Wide Projects - - 25,372.05- - - (25,372.05) 000-487000Interfund Charges-Fleet 91,737 7,442.08 39,830.03- 59,536.66 - 32,200.34 000-488000Interfund Charges-4B 53,000 4,416.66 27,750.00- 36,751.99 - 16,248.01 000-489000Transfer In - - 3.80 - - - 000-490020Transfer In-SEDC50,00050,000.0050,000.00 - - - TOTAL Fund Transfers 1,184,474 -88,620.07 583,496.59 786,046.36 - 398,427.64 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 5,000 37.99 - 3,979.12 1,565.58 - 000-491200Investment Income 26,000 3,249.85 20,370.02- 23,723.20 - 000-491900Unrealized Gain/Loss 677.21 (4,093.75)- (13,685.29) - - 13,685.29 000-493000Donations-Others - - - 340.00 - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap.20,000 114.00 17,163.94- 24,701.00 - (4,701.00) 000-493400Donation - Animal Control 3,670 214.00 - 2,618.31 2,859.26 - 000-493401Donations-A/C Microchip 3,000 140.00 - 2,147.50 1,605.00 - 000-493402Donations-Spay&Neuter 12,000 710.50 - 7,914.00 10,615.82 - 000-493403Donations-Melvin Boeck A. S. - - - - - - 000-493503Donations - Fire Rescue - - - 25.00 - - 000-494481LawEnforcemtOfficersStnd&Ed 3,800 - - 3,705.94 3,550.22 - 000-495015Contribution from SED - - - - - - 000-497000Misc Income-Gen Fund 40,000 88.31 56,261.66- 29,207.69 - 10,792.31 000-497005Misc Income-Publications 240,000 8,416.00 92,343.30- 97,858.10 - 142,141.90 000-497007Misc Income-Schertz Artz - - - - - - 000-497020Misc Income-Fleet Recycled 400 - - 250.80 - - 000-497100Misc Income-Police 20,000 371.10 17,410.24- 15,277.23 - 000-497200Misc Income-Library 12,131 331.45 - 6,689.03 17,326.95 - (5,195.95) 000-497210Misc Income-Library Copier 3,400 1,131.00 2,274.10 7,300.65 - (3,900.65) 000-497300Misc Income-Animal Control 2,400 267.07 - 1,542.49 1,256.37 - 000-497400Misc Income-Streets Dept. 11,229 3,050.00 - 8,375.00 12,550.00 - (1,321.00) 000-497500Misc Income-TML Insurance 78,043 - 78,042.55- 49,728.90 - 28,314.10 000-497550Misc Income-TML Reimbursemt20,211 - 20,211.02- 22,447.21 - (2,236.21) 000-497600Misc Income-Parks/Vending Mach.500 - - 913.49 1,202.59 - 000-497800Misc Income-Pool Concessions - --- - - 000-498000Reimbursmnt-Gen Fund5,5002,874.53 3,166.364,624.12 - - 000-498100Reimbursmnt Fire - Training - - - 846.00 - - 000-498105Reimburmnt Police - DEA - - - 3,785.61 - - (3,785.61) 000-498110Reimbursmnt Fire - Emg. Acti-O - - 9,328.07 - 1,250.00 - (9,328.07) 000-498500Settlement - Litigation25,000.00 25,000.00- - - - TOTAL Miscellaneous507,284 47,923.01 - 341,285.12 353,039.28 - 154,244.72 TOTAL REVENUES18,886,4181,063,238.20 13,008,466.38-15,324,930.71 (1,111.55) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking321,145.54$ Cash in Investment Pools LOGIC Investment-General Fund3,607,926.06 LOGIC Investment-Equip Replacement73,261.97 LOGIC Investment-Veh Replacement7,071.32 LOGIC Investment-Air Condi Replacment122,288.53 CAPITAL ONE Investment-General Fund1,330,771.52 Total Cash in Bank & Investment Pools$5,584,715.20 17 ADVALOREM TAX $2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $- $(500,000) OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 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 1,223,886 886,430 492,623 1,387,876 474,014 90,756 28,206 35,521 40,691 21,925 12,579 4,162 2006-07 18-A Sales Tax - General Fund $600,000 $500,000 -1% 16% $400,000 24% 23% -2% 13% 11% 3% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 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 212,505 239,854 229,587 248,693 313,084 228,070 222,035 276,537 250,602 272,411 312,562 263,674 2005-06 18-B CITY PUBLIC SERVICE $100,000 $90,000 $80,000 $70,000 $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 83,433 62,692 67,561 - 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 57,413 38,691 42,722 60,515 2006-07 18-C C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET 6 6.67 FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 85,614.00 134,344.00- - - - 85,614.00 Wilenchik Walk for Life 28,000.00 - 28,926.25 30,461.91 - - (2,461.91) TML Dinner 2,100.00 - - 4,774.40 - - 2,100.00 Hal Balwin Scholarship 1,000.00 - - 205.00 23,585.00 - (22,585.00) Miscellaneous22,300.00 69.14-6,032.55445.09 - TOTAL REVENUES139,014.00 69.14 - 174,282.20 54,492.00 - 84,522.00 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - - - - - 4,750.00 Festival of Angels 13,250.00 - 10,358.65 12,645.61 102.00 - Employee Appreciation Event 5,000.00 - - - 126.00 - 4,874.00 4th of July Jubilee - - 411.40 - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 30,500.00 - 28,876.25 30,461.91 - - Blue Santa - - - - - - Schertz Fest - 455.59 306.07 455.91 - - TML Events - - 3,974.40 - - - Schertz Sweetheart 42,945.00 5,260.22 1,058.00 15,887.71 33,010.72 3,666.19 Hal Baldwin Scholarship9,355.0033.95- -8,332.411,021.70 Selma-Schertz 5K400.00- 400.00- - - TOTAL CULTURAL 5,294.17106,300.00 1,513.59 59,814.48 85,432.56 4,789.89 17,591.14 TOTAL EXPENDITURES111,450.00 5,294.17 1,513.59 59,814.48 85,432.56 4,789.89 22,741.14 REVENUE OVER(UNDER) EXPEND27,564.00 (30,940.56) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking45,034.87$ Cash in Investment Pools MBIA Special Events66,523.15 Total Cash in Bank & Investment Pools$111,558.02 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises138,000- 138,734.41-164,765.87 (26,765.87)- Fees13,679,7501,456,312.78 7,928,499.02-9,071,793.49 4,607,956.51- Fund Transfers503,8866,718.00 39,500.03-53,744.00 450,142.00- Miscellaneous471.4982,371.80266,507.54 55,445 - - TOTAL REVENUES14,377,0811,463,502.278,189,105.269,556,810.90 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 31,000.00- 31,000 - - - TOTAL NON DEPARTMENTAL-31,000 31,000 - - - BUSINESS OFFICE Personnel Services458,64029,746.77 279,065.73-274,004.38 184,635.62- Supplies6,049332.88-2,454.221,694.87754.48 Operations Support108,5007,176.71 59,785.77-45,321.52 63,178.48- Staff Support8,450451.95-828.831,822.81328.22 Professional Services14,5013,784.01 11,104.34-10,990.51- Fund Charges/Transfers40,000---- 40,000.00- Maintenance Services12,000420.00-6,470.003,920.002,100.00 Operating Equipmen 6,117.62- t 6,800 - - - TOTAL BUSINESS OFFICE41,912.32343,871.713,182.70 654,940 -359,708.89 W & S ADMINISTRATION Personnel Services1,212,50783,964.58 784,586.70-795,234.33 417,273.09- Supplies213,52010,139.44338.7395,343.65100,799.1050,065.87 Human Services338---64.00- City Support Services74,326- 19,611.65-34,899.05 39,426.95- Utility Services2,780,900361,681.47 1,479,479.68-1,467,506.94 1,312,845.50547.56 Operations Support8,750245.7379.601,506.612,152.43576.56 Staff Support33,0001,879.801,339.009,721.5914,219.871,922.73 City Assistance1,91245.00-636.00296.00- Professional Services177,16839,431.139,870.0098,790.73153,888.68 33,149.32- Fund Charges/Transfers2,368,17656,073.08 462,088.39-1,400,200.04 967,975.96- Maintenance Services4,838,250445,728.63 3,326,223.09116.413,208,681.511,900.30 Other Costs25,000- 23,671.50-28,911.85 (3,911.85)- Debt Service1,435,16527,791.66 1,200,302.92-590,483.94- Rental-Leasing6,0701,846.00-2,301.892,508.53- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Operating Equipment21,7802,679.993,420.00(2,335.00)15,355.085,387.62 Capital Outla - 133,169.40 y 58,000 -52,432.00 -(22,737.40) 357,830.77- - - - Water Line Relocation - TOTAL PUBLIC WORKS13,254,8621,031,506.5167,595.74 7,948,370.757,859,760.17 60,400.64 5,313,686.77 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services3,862----- Operations Support500----248.04 Professional Services64,03810,950.39 29,368.53-52,298.843,151.41 Maintenance Services184,460.40145,754.08184,763.68 329,044 - - 195,410.79237,062.523,399.45 TOTAL AVIATION HEIGHTS WTR IMP 397,444 -175,122.61 FM3009 RD&BRIDGE EXPANSION Professional Services28,676 19,137.50- 30,358.8014,708.06 12,048.01 5,406.69 695,900.7237.74 Maintenance Services 38 - - - 19,138710,60930,396.5412,048.01 TOTAL FM3009 RD&BRIDGE EXPANSION 28,714 - TOTAL MISC & PROJECTS195,410.7919,137.50885,731.39267,459.0615,447.46 426,158 TOTAL EXPENDITURES14,366,9601,268,83086,7339,105,2008,590,70279,031 966,109.38 ** REVENUE OVER(UNDER)EXPENSES ** 10,121 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 3tst, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 138,734.41 164,765.87 000-421490Tower Leasing138,000 - - - TOTAL Franchises 138,000 - 138,734.41- 164,765.87 - (26,765.87) Fees 000-455200Garbage Collection Fee 3,300,000 298,553.47 1,956,181.01- 2,152,235.44 1,147,764.56- 000-455600Fire Line Fees 18,500 - 18,190.00- 18,430.00 - 000-455700Recycle Fee Revenue 155,000 23,197.64 97,844.57- 142,514.67 - 12,485.33 000-455800W&S Line Constructn Reimbursemnt50,000 1,639.00 23,865.64- 19,528.92 - 30,471.08 000-457100Sale of Water 7,200,000 792,299.81 3,738,878.44- 4,556,066.99 2,643,933.01- 000-457110Edwards Water Lease 127,250 39,584.18 34,340.05- 192,995.00 - (65,745.00) 000-457120Water Transfer Charge-Selma 5,000 1,329.28 - 780.18 2,668.48 - 000-457130Water Transfer Charge-U. C. 1,000 - - 3,914.06 1.28 - 000-457200Sale of Meters 86,000 4,297.74 45,495.76- 54,896.06 - 31,103.94 000-457400Sewer Charges 2,560,000 280,789.64 1,899,011.62- 1,821,983.25 738,016.75- 000-457500Water Penalties 175,000 14,482.02 108,266.06- 109,007.92 - 65,992.08 000-459200NSF Check Fee-Water&Sewer2,000140.001,731.631,465.48 - - TOTAL Fees13,679,7501,456,312.78 7,928,499.02-9,071,793.49 4,607,956.51- Fund Transfers 000-486101Transfer In- General Fund423,270---- - 423,270.00 6,718.0039,500.03 53,744.00 000-486204Interfnd Chrg-Drainage Bill80,616 - - TOTAL Fund Transfers 503,886 6,718.00 39,500.03- 53,744.00 - 450,142.00 Miscellaneous 000-490000Misc Charges 15,000 (288.00) 11,136.21- 4,043.88 - 10,956.12 000-491000Interest Earned 500 23.38 - 447.60 1,151.69 - 000-491200Investment Income 5,000 526.51 34,483.49- 7,978.36 - (2,978.36) 000-493130Library Donations - - 5.77 - - - 000-493400Donations-Christmas Activitise - - 1,000.00- - - (1,000.00) 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 20,000 209.60 - 9,245.22 (1,965.78) - 21,965.78 000-497550TML Reimbursements - - 2,291.34- - - (2,291.34) 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC - 25,165.01- 76,314.75 - - (76,314.75) 000-498200W&S Project Reimbursement5,000 41,193.301,888.50 - - - TOTAL Miscellaneous 55,445 471.49 82,371.80- 266,507.54 - TOTAL REVENUES14,377,0811,463,502.27 8,189,105.26- 9,556,810.90 4,820,270.10- 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MAY 31sth 2011 Cash in Bank Claim on Operating Cash Pool-Checking302,099.46$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,291,020.96 Lone Star Investment-W&S Customer Deposits293,416.27 Lone Star Investment-W&S Equip Replacement372,752.46 Lone Star Investment-W&S Veh Replacement543,517.63 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,545,127.32 Total Cash in Bank & Investment Pools3,847,226.78$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees5,436,537 264,580.89 2,893,414.63- 2,164,761.49 3,271,775.51- Inter-Jurisdictional1,432,345 - 988,878.14- 1,013,959.52 418,385.48- Miscellaneous10,596.46-121,592.08120,522.95 334,850 - TOTAL REVENUES 275,177.35 - 4,003,884.85 3,299,243.96 - 3,904,488.04 7,203,732 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,391,410198,144.48 1,689,114.08-1,757,527.60 633,756.40126.00 Supplies 43,475.08 382.34 215,615.89 208,165.12 41,260.54 327,874 Human Services - - 580.00 847 - - City Support Services 14,850.78- 10,974.19 15,000 - - 4,025.81 Utility Services 12,027.02 46,692.57- 63,919.62 80,438 - 16,518.38 Operations Support 1,762.93 21,109.77- 34,663.20 1,434.66 33,500 Staff Support 11,559.58 171.35 62,449.36 44,505.53 9,731.55 75,600 City Assistance 246.00 - 7,513.05 5,743.00 4,308.80 11,753 Professional Services 15,614.25 160.00 91,721.10 88,606.09 3,851.21 136,390 Fund Charges/Transfers3,576,092 9,825.00 2,292,238.05- 304,275.94 - 3,271,816.06 Maintenance Services 1,410.00 26,113.22- 21,779.91 42,320 - 20,540.09 Debt Service - 9,523.75 69,799.33 248,502 - - 178,702.67 Rental-Leasing 1,066.41 - 6,645.83 2,748.61 37,251.39 40,000 - Operating Equipment4,150.31-36,580.2717,577.45 76,600 19,465.53 TOTAL PUBLIC SAFETY 299,281.06 713.69 4,520,167.72 2,630,865.59 80,178.29 4,345,995.81 7,056,326 TOTAL EXPENDITURE299,281.06713.694,520,167.722,630,865.59 S 7,056,326 80,178.29 ** REVENUE OVER(UNDER) EXPENSES 668,378.37 * 147,406 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt5,336,537 264,475.89 - 2,880,347.63 2,146,206.49 - 3,190,330.51 40.22% 000-456110Subscription Program Fees100,000 105.00 - 13,047.00 18,555.00 18.56% - 81,445.00 20.00- 000-459200NSF Check Fee - - - - - TOTAL Fees5,436,537264,580.89 2,893,414.63- 2,164,761.49 3,271,775.51- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 190,750.96- 191,850.89 - - 94,275.11 000-474300Cibolo Support 219,699 159,975.00- 159,975.00 - - 59,724.00 000-475100Comal Co ESD #6 75,369 18,293.44- 37,920.00 - - 37,449.00 000-475200Live Oak Support 152,569 111,093.75- 111,093.75 - - 41,475.25 000-475300Universal City Support 210,545 153,309.39- 153,309.39 - - 57,235.61 000-475400Selma Support 64,689 47,103.75- 51,547.50 - - 13,141.50 000-475500Schertz Support 399,083 290,594.61- 290,594.61 - - 108,488.39 000-475600Santa Clara Support 10,851 - 7,989.87 7,901.01 - - 2,949.99 000-475800Marion Support13,4149,767.379,767.37 - - - TOTAL Inter-Jurisdictional1,432,345 - 988,878.14- 1,013,959.52 418,385.48- Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 41.33 - 100.77 412.17 - - (412.17) 000-493203Donations-EMS 6,000 100.00 - 1,227.75 1,400.00 - 4,600.00 000-493204Donations-Dilworth Fund - 1,000.00- - - - (1,000.00) 000-493205Donations- Golf Tournament - 3,690.00- -3,340.00 - (3,690.00) 000-497000Misc Income 150,000 6,521.79 74,720.70- 59,765.03 - 90,234.97 000-497100Recovery of Bad Debt 100,000 53.34 - 4,435.04 9,175.75 - 90,824.25 000-497500Misc Income-EMT Classes78,850540.0041,107.8245,080.00 - - TOTAL Miscellaneous 334,850 10,596.46 121,592.08- 120,522.95 - 214,327.05 TOTAL REVENUES7,203,732275,177.35 4,003,884.85- 3,299,243.96 3,904,488.04- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank $ (299,108.36) Claim on Operating Cash Pool-Checking Cash in Investment Pools LOGIC Investment-EMS- MBIA Investment-EMS Note 2010300,605.28 Total Cash in Bank & Investment Pools$1,496.92 27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 675,30066,435.59 441,618.91- 469,083.94 -206,216.06 Miscellaneous1,3001,072.34805.34 84.72 - - TOTAL REVENUES 66,520.31676,600442,691.25 -469,889.28206,710.72 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 361,18326,268.06 226,024.01- 236,041.97 -125,141.03 Supplies 8,300 461.96 28.15 1,730.79 1,209.56 205.20 Human Services 100 - - - - -100.00 City Support Services 26,500 - 3,476.00 4,332.18 - -22,167.82 Utility Services 12,888 2,299.73 - 8,004.56 8,598.92 239.56 Operations Support 2,458 - - - - -2,458.00 Staff Support 8,255 26.77 168.83 2,388.83 2,344.61 978.93 City Assistance 840 - 102.00 15.00 - -825.00 Professional Services 19,800 4,280.00 - 6,697.10 14,280.00 -5,520.00 Fund Charges/Transfers 195,44910,838.25 64,652.83- 87,001.00 -108,448.00 Maintenance Services 22,000 - 4,663.26 1,987.00 - -20,013.00 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 18,138 - 2,183.45 1,918.78 16,218.80 - - Rental/Leasing500-- - - - TOTAL DRAINAGE 44,174.77676,511196.98320,022.83 1,423.69357,829.02317,454.85 TOTAL EXPENDITURE 44,174.77676,511196.98320,022.83 1,423.69357,829.02317,454.85 S ** REVENUE OVER(UNDER) EXPEND89112,060.26 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 2,593.04 2,827.84 3,500 334.22 -672.16 000-457600Drainage Fee 66,101.37-439,025.87466,256.10 -205,543.90 671,800 TOTAL Fees66,435.59 441,618.91-469,083.94 206,216.06- 675,300 Miscellaneous 000-491000Interest Earned - 87.25 210.08 100 23.76 -(110.08) 000-491200Investment Interest - 444.40 452.10 600 51.72 -147.90 000-497000Misc Income-Drainage-540.69143.16 600 9.24 - TOTAL Miscellaneous - 1,072.34 805.34 1,300 84.72 -494.66 TOTAL REVENUES66,520.31 442,691.25-469,889.28 206,710.72- 676,600 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 217,777.54 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund282,907.54 Total Cash in Bank & Investment Pools$500,685.08 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 385,000 35,138.32 175,534.24- 191,881.53 -193,118.47 Fund Transfers 55,000 - - - - -55,000 Miscellaneous 624.785,550-260.83874.85 - TOTAL REVENUES 35,763.10445,550-175,795.07192,756.38252,793.62 - EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services 31,841 - - - - -31,841.00 Supplies 1,495.502,526 - - 2,315.40 -210.60 City Support Services 78,228 3,125.00 502.85 48,984.50 47,298.85 -31,432.00 Operations Support 85,898 201.40 - - 6,654.28 -79,243.72 Professional Services 2,500.002,500 - 902.28 2,500.00 - -100.00% Fund Charges/Transfers 231,485 14,185.08 149,060.00- 113,480.66 -118,004.34 Operating Equipment - - - - - - -0.00% Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 21,506.98432,478502.85198,946.78172,249.19260,731.66 L - TOTAL EXPENDITURE 21,506.98432,478502.85198,946.78172,249.19260,731.66 S - REVENUE OVER(UNDER) EXPENDITURE13,072 20,507.19 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax385,000 35,138.32175,534.24191,881.53 -193,118.47 - TOTAL Taxes 385,00035,138.32 175,534.24- 191,881.53 - 193,118.47 Fund Transfers 000-481000Transfer From Reserve55,000 ---55,000.00 - - TOTAL Fund Transfers 55,000 - - - - - 55,000.00 Miscellaneous 000-491000Interest Earned250-181.15181.91 72.76% 1 6.62 - 000-491200Investment Interest 300 - 79.68 92.94 8 .16 - 207.06 000-497000Misc Income 600.005,000-600.004,400.00 - - TOTAL Miscellaneous5,550-260.83874.85 6 24.78 - 4,675.15 TOTAL REVENUES 445,55035,763.10 175,795.07- 192,756.38 - 252,793.62 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking138,654.12$ Cash in Investment Pools Federated Investment-Hotel/Motel78,094.74 Total Cash in Bank & Investment Pools$216,748.86 33 ôíè÷ð íùùçìûîùã èûä $50,000 $45,000 $40,000 $35,000 $30,000 $25,000 $20,000 $15,000 $10,000 $5,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 27,689 25,112 23,231 19,619 22,667 36,728 28,215 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 18,245 18,817 18,521 15,970 17,948 19,220 24,257 22,590 22,959 25,887 27,316 26,568 2006-07 34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 40,000 104,000.00- 107,000.00 - -(67,000.00) Tree Mitigation Fees 40,000 53,756.25- - - -40,000.00 Miscellaneous405-460.63462.79 44.57 - TOTAL REVENUES 44.5780,405-158,216.88107,462.79 - EXPENDITURE SUMMARY PARKLAND DEDICATION Maintenance Services-Landscape 8,000 - 1,286.36 12,234.00 - -(4,234.00) Operating Equipment 30,000 11,244.23 67,534.73 51,768.48 (10,902.45)378.20 3,544.98 Capital Outlay6,000--4,980.30 - - TOTAL PARKLAND DEDICATION 3,544.9844,00011,244.2368,821.0968,982.78 378.20 TREE MITIGATION Fund Charges/Transfers - 4,133.27 - - - - -0.00% Maintenance Services-Trees 36,000 3,133.00 32,288.67 28,004.55 625.00 9,833.55 Capital Outlay--- - - - - TOTAL TREE MITIGATION 9,833.5536,0003,133.0036,421.9428,004.55 625.00 TOTAL EXPENDITURE 13,378.5380,00014,377.23105,243.0396,987.33 S 1,003.20 REVENUE OVER(UNDER) EXPEND40510,475.46 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 40,000 104,000.00- 107,000.00 (67,000.00)- - 000-458900Tree Mitigation -40,00053,756.25-- - TOTAL Fees 80,000 157,756.25- 107,000.00 (27,000.00)- - Miscellaneous 000-491000Interest Earned 20.4060 - 78.90 187.54 (127.54)- 000-491200Investment Interest 280 24.17 - 249.23 275.25 - 000-497000Miscellaneous Income65132.50-- - - TOTAL Miscellaneous40544.57-460.63462.79 (57.79)- TOTAL REVENUES 80,405 44.57 158,216.88- 107,462.79 (27,057.79)- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$178,149.99 Cash in Investment Pools Federated Investment-Park Fund38,838.05 Federated Investment-Tree Mitigation192,418.39 Total in Investment Pool 231,256.44 Total Cash in Bank & Investment Pools$409,406.43 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer 31,000 - 31,000.00- - - - 100.00% Miscellaneous -25,000--- - 25,000.00 TOTAL REVENUES -56,000--31,000.00 - 25,000.00 EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor -56,000-6,567.02- - 56,000.00 TOTAL NONDEPARTMENTA -56,000-6,567.02- L - 56,000.00 TOTAL EXPENDITURE -56,000-6,567.02- S - 56,000.00 REVENUE OVER(UNDER) EXPEND31,000.00 - - 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S -31,000--31,000.00 - - TOTAL Fund Transfers31,000- 31,000.00- - - -100.00% Miscellaneous 000-490210Sale of Recycle Material25,000 ----25,000.00 - TOTAL Miscellaneous 25,000 - - - - -25,000.00 TOTAL REVENUES 56,000 - - 31,000 - - 25,000 39 RECYCLE FUND CASH IN BANK AS OF: MAY 31st, 2011 Cash in Bank (27,365.47) Claim on Operating Cash Pool-Checking $(27,365.47) Total Cash in Bank 40 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees1,190,640 327,875.96 803,154.07- 1,919,918.82 -(729,278.82) Fund Transfers - - - - 0.00% - - Miscellaneous 32,454.29585,500100,926.11232,679.63 - - TOTAL REVENUES 360,330.251,776,140904,080.18 -2,152,598.45 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support1,000---- -1,000.00 Professional Services 1,118,352.6426,800 - 3,977.58 1,120,464.18 -(1,093,664.18) Debt Service - 118,896.50- - 0.00% - - Capital Outlay8,428.00-8,428.00 - - - TOTAL NON DEPARTMENTA 1,118,352.6427,8008,428.00122,874.08 -1,128,892.18(1,092,664.18) L MISC & PROJECTS Projects 230,20018,612.7853,906.78180.0088,719.56 1,614.72 Schaefer RD Water Improvements 599,643-- - - -599,643.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant- 0.00% - - -19,759.00 - Town Creek Project-- 0.00% - - - - Live Oak Water Plant204,531.74 - - -556,812.68 -(204,531.74) Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP -88,252225,148.72160,103.89344,233.90 A - TOTAL MISC & PROJECTS 18,612.78918,095279,055.50736,855.57637,485.20 1,614.72 TOTAL EXPENDITURE 1,136,965.42945,895287,483.50859,729.65 1,614.721,766,377.38 S REVENUE OVER(UNDER) EXPENDITURES830,245 386,221 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 904,200 69,048.00 541,101.87- 1,013,279.74 -(109,079.74) 000-455910Capital Recovery - Waste Wtr272,800 35,029.67 261,602.20- 682,240.79 -(409,440.79) 000-455911Capital Recovery-Wste Wtr Zone 113,640 - - - - -13,640.00 000-455913Cap Recovery-North Sewer Tr223,798.29450.00224,398.29 - - - TOTAL Fees 327,875.961,190,640 - 803,154.07 1,919,918.82 161.25% -(729,278.82) Fund Transfers 000-481000Transfer from Reserves - - - 0.00% - - - 000-486100Transfer In -- - - - - - TOTAL Fund Transfers--- 0.00% - - - Miscellaneous 000-491000Interest Earned 2,000 35.44 - 1,590.95 367.04 -1,632.96 000-491200Investment Income 250,000 3,375.04 - 3,460.19 25,604.40 -224,395.60 000-491900Unrealized Gain/Loss-Cap One - (15,625.13)- -1,252.15 -15,625.13 000-498100Reimbursmnt - FM 78 Project 50,000 4,166.66 24,999.97- 33,333.32 -16,666.68 000-498200Re-imbursement-Water Meters283,500 23,625.0070,875.00189,000.00 - - TOTAL Miscellaneous 585,500 32,454.29 100,926.11- 232,679.63 -352,820.37 TOTAL REVENUES 360,330.251,776,140 - 904,080.18 2,152,598.45 121.20% -(376,458.45) 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking177,041.75$ Cash in Investments: Lone Star Investment-Capital Recovery261,732.87 Capital One-Investment1,704,517.11 Schertz Bank & Trust-Certificate of Deposit524,438.49 Total Cash in Bank & Investment Pools$2,667,730.22 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 24,668.713,368,794 - 3,318,171.90 3,381,844.24 100.39% -(13,050.24) Fund Transfers243,000 - - - - 0.00% -243,000.00 Miscellaneous3,000 117.672,478.9815,294.94 - - TOTAL REVENUES 24,786.383,614,7943,320,650.88 -3,397,139.18217,654.82 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services3,200 - - 1,350.00 350.00 10.94% -2,850.00 Debt Service3,611,124 -2,445,857.55 -2,558,340.591,055,633.41 - TOTAL GENERAL GOVERNMEN -3,614,3242,447,207.55 -2,558,690.591,055,633.41 T - TOTAL EXPENDITURE -3,614,3242,447,207.55 -2,558,690.591,055,633.41 S - ** REVENUE OVER(UNDER) EXPEND470838,448.59 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue3,368,79424,668.713,318,171.903,381,844.24 - - TOTAL Taxes3,368,79424,668.71 3,318,171.90-3,381,844.24 -(13,050.24) Fund Transfers 000-486000Transfer From Reserves243,000 - - - - -243,000.00 -- 000-486103Transfer In - - - - TOTAL Fund Transfers 243,000 - - - - -243,000.00 Miscellaneous 000-491000Interest Earned 1,500 2.91 - 1,350.88 14,414.72 -(12,914.72) 000-491200Investment Earnings1,500114.761,128.10880.22 - - TOTAL Miscellaneous3,000117.67-2,478.9815,294.94 -(12,294.94) TOTAL REVENUES3,614,794 24,786.38 3,320,650.88- 3,397,139.18 -217,654.82 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent3,2001,350.00350.00 - - - TOTAL Professional Services3,200--1,350.00350.00 -2,850.00 Debt Service 101-555612Schertz C O SR2001-Principal210,000 - - 200,000.00 285,000.00 -(75,000.00) 101-555612.1Schertz CO BOND, 2001-Interest141,318 - - 77,090.00 37,977.08 -103,340.92 101-555622Schertz C O SR2003-Principal190,000 - - 180,000.00 190,000.00 - 101-555622.1Schertz C O SR2003-Interest 60,820 - 35,360.00- 32,120.00 -28,700.00 101-555624Comm Proj Bond-SR04-Principal325,000 - 325,000.00- 325,000.00 - 101-555624.1Comm Proj Bond SR04-Interest265,009 - 143,168.14- 136,058.76 -128,950.24 101-555626LS&D SR2006-Principal - 100,000.00- - - - 101-555626.1LS&D SR2006-Interest 650,982 - 327,490.64- 325,490.64 -325,491.36 101-555628CO Bond 2007-Principal 99,567 - - 13,451.11- -86,115.89 101-555628.1CO Bond 2007-Interest 26,617 - - - - -26,617.00 101-555629GO Bond 2007-Principal 275,000 - 250,000.00- 382,346.25 -(107,346.25) 101-555629.1GO Bond 2007-Interest 209,097 - 127,331.56- - -209,097.00 101-555630GO Bond SR2008 Principal 355,000 - 235,000.00- 355,000.00 - 101-555630.1GO Bond SR2008 Interest 379,651 - 198,343.25- 193,490.50 -186,160.50 101-555631GO Bond SR2009 Principal 140,000 - 80,000.00- 140,000.00 - 101-555631.1BO Bond SR2009 Interest -283,063167,073.96142,406.25 - - TOTAL Debt Service3,611,124- 2,445,857.55-2,558,340.59 -1,052,783.41 TOTAL EXPENDITURES3,614,324 - 2,447,207.55- 2,558,690.59 -1,055,633.41 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking4,789.62$ Cash in Investment Pools MBIA Investment- Tax I&S49,010.39 Federated Investment-Tax I&S1,033,862.88 Total Cash in Bank & Investment Pools1,087,662.89$ 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,035,795212,924.22 993,597.50- 1,442,239.97 - 593,555.03 Miscellaneous 1,120.16108,00026,892.04 -6,430.91101,569.09 - ,,,.,,. -,,. TOTALREVENUES214379521404438102048954144867088695 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies23,000993.75623.289,550.1315,415.281,313.98 Utility Service 85,800 2,457.19 43,659.98- 32,889.10 - 52,910.90 Maintenance Services 65,300 3,720.04 5,965.50 33,962.00 41,405.19 2,126.23 Operating Equipment 8,498 18,494.00- 6,999.31 - - 1,498.69 Capital Outlay -6,999.31-- - - TOTAL NONDEPARTMENTA 7,170.98182,59813,588.09105,666.11 3,440.2196,708.88 L ECONOMIC DEVELOPMEN T Personnel Services 202,062 24,404.78 176,818.13- 112,392.44 - 89,669.56 Supplies 1,000 - 405.70 560.22 - - Human Services 100 - - - 54.00 54.00% - City Support Services 34,500 807.95 623.92 36,951.20 13,732.64 154.36 Utility Services 4,850 283.22 - 2,006.12 2,190.00 - 2,660.00 Operations Support 76,100 8,373.98 3,242.89 40,652.28 49,053.53 730.56 Staff Support 97,000 1,745.36 1,782.11 89,951.95 65,368.80 770.76 City Assistance 80,000 - - - - - 80,000.00 Professional Services 349,000 17,010.38 21,340.80 144,871.47 160,792.90 1,458.22 208,089.68 Fund Charges/Transfers 105,432 4,416.66 77,750.00- 86,751.99 - 18,680.01 Fund Replenish-Fund Balance 216,000 - - - - - 216,000.00 Maintenance Services - 781.89 - 0.00% - - - Debt Service 792,432 355,322.21- 606,911.25 185,520.75 - - Operating Equipment -1,500231,833.36-83.27 - TOTAL ECONO DEVELOPMEN 57,042.331,959,97626,989.721,157,344.31 3,251.171,097,753.77885,960.78 T TOTAL EXPENDITURE 64,213.312,142,57440,577.811,263,010.42 6,691.381,194,462.65981,997.78 S ** REVENUE OVER(UNDER) EXPEND1,221 254,208.23 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,035,795212,924.22993,597.501,442,239.97 - - TOTAL Taxes2,035,795212,924.22 993,597.50- 1,442,239.97 -593,555.03 Miscellaneous 000-491000Interest Earned 1,000 28.33 - 374.26 120.45 - 000-491200Investment Earnings 12,000 91.83 15,989.47- 4,956.66 -7,043.34 000-497000Misc Income 15,000 1,000.00 10,528.31- 1,353.80 -13,646.20 000-499000Transfer From Reserves80,000 -- - - - TOTAL Miscellaneous 108,000 1,120.16 26,892.04- 6,430.91 - TOTAL REVENUES2,143,795214,044.38 1,020,489.54- 1,448,670.88 -695,124.12 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking297,719.38$ Cash in Investment Pools MBIA Investment-Economic Development Corp515,313.18 MBIA-Investment-Sysco Infrastructure- MBIA-Investment-EDC Notes 2010153,556.95 Schertz Bank & Trust-Certificate of Deposit505,445.57 Schertz Bank & Trust-Certificate of Deposit1,027,353.23 Total Cash in Bank & Investment Pools2,499,388.31$ 50 4B SALES TAX $300,000 $250,000 -1% 16% $200,000 23% 24% -2% 14% 11% 3% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 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 139,231 152,929 133,224 140,960 179,416 118,361 125,387 159,802 150,107 153,348 191,371 149,102 2006-07 51 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING MAY 31st, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,784,225.61,683,696.27.1000,299,664.41,199,135.07,784,225.61,784,225.61 205522 TOTAL OPERATIONS2,784,225.61,683,696.27,299,664.41,199,135.07,784,225.61,784,225.61 25522 LOGIC General Fund3,607,926.06,007,355.38.178570.6800,000.00,607,926.06 N/A,607,926.06 405433 G/F-Equipment Replacement73,261.9773,250.870.1785 -11.1073,261.97 N/A73,261.97 G/F-Vehicle Replacement7,071.32,070.25.1785 -.07,071.32 N/A,071.32 70177 G/F-Air Conditioner Replacement122,288.53122,270.000.1785 -18.53122,288.53 N/A122,288.53 ,251,581.74.178588.7267,923.76,484,146.70,484,146.70 SR2009 Bond-Street Projects(II)2,484,146.70 304722 TOTAL LOGIC6,294,694.58,461,528.24,090.10,167,923.76,294,694.58,294,694.58 71166 LONESTA R Drainage Fund282,907.54282,855.820.2200 -51.72282,907.54 N/A282,907.54 GO SR2011 Animal Shelter2,266,204.00,265,789.65.2200 -14.35,266,204.00 N/A,266,204.00 20422 GO SR2011 Athletic Fields1,490,372.541,510,526.430.2200276.1120,430.001,490,372.54 N/A1,490,372.54 GO SR2011 Soccer Fields1,510,802.65,510,526.43.2200 -76.22,510,802.65 N/A,510,802.65 10211 GO SR2011 Swimming Pool3,021,605.313,021,052.860.2200 -552.453,021,605.31 N/A3,021,605.31 SR2005-Public Improvement Bond(0.00).01.22000.010.00) N/A0.00) 00-(( W/S-Capital Recovery-Water261,732.87561,663.480.220069.39300,000.00261,732.87 N/A261,732.87 W/S-Customer Deposits293,416.2793,362.62.2200 -3.6593,416.27 N/A93,416.27 20522 W/S-Equipment Repl/Cap.Imp372,752.46372,684.310.2200 -68.15372,752.46 N/A372,752.46 Water&Sewer1,291,020.96,790,740.22.220080.7400,000.00,291,020.96 N/A,291,020.96 102511 W/S-Vehicle Replacement543,517.63543,418.260.2200 -99.37543,517.63 N/A543,517.63 34,521.94.22004.60-34,546.5434,546.54 Water/SSLG - SAWS134,546.54 10211 TOTAL LONESTA11,468,878.772,287,142.03.64,166.7520,430.011,468,878.771,468,878.77 R122811 MBIA Tax I&S49,010.3949,003.690.1600 -6.7049,010.39 N/A49,010.39 Police Forfeiture358,944.8658,895.58.1600 -9.2858,944.86 N/A58,944.86 30433 Economic Development Corporation515,313.18515,242.400.1600 -70.78515,313.18 N/A515,313.18 Special Events Fund66,523.156,514.01.1600 -.146,523.15 N/A6,523.15 60966 SEDC Tax Notes 2010153,556.95153,535.900.1600 -21.05153,556.95 N/A153,556.95 00,563.95.16001.33-00,605.2800,605.28 EMS Tax Notes 2010300,605.28 30433 TOTAL MBIA1,443,953.81,443,755.53.12 -98.28,443,953.81,443,953.81 11111 FEDERATED SR2007a Bond-City Wide Projects1,054,226.711,054,116.520.1200 -110.191,054,226.71 N/A1,054,226.71 Hotel Occupancy Tax78,094.748,086.58.1200 -.168,094.74 N/A8,094.74 70877 Park Fund (Developers Fee)38,838.0538,833.990.1200 -4.0638,838.05 N/A38,838.05 Park Fund (Tree Mitigation)192,418.3992,398.28.1200 -0.1192,418.39 N/A92,418.39 10211 Tax I&S1,033,862.881,033,754.820.1200 -108.061,033,862.88 N/A1,033,862.88 8,656.99.1200.09-8,662.088,662.08 Library Board Fund48,662.08 40544 TOTAL FEDERATED2,446,102.85,445,847.18 -55.67,446,102.85,446,102.85 2222 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,276,233.071,305,423.582.3700 275.444,144.151,309,292.29 N/A1,330,771.52 ,709,560.51.0700,719.28352.64,715,927.15,704,517.11 Capital One Capital Recovery1,641,409.59 12611 TOTAL CAPITAL ONE2,917,642.66,014,984.09 628.080,863.43,025,219.44,035,288.63 3133 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust 5% Capital One Managed 9% FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $2,784,226 Designated Funds, $9,047,699 Special Revenue Funds, $5,475,907 Debt Service Fund $809,074.07 MONTHLY YIELDS 2.50 2.00 1.50 1.00 0.50 0.00 OCT-10NOV-10DEC-10JAN-11FEB-11MAR-11APR-11MAY-11JUN-11JUL-11AUG-11SEP-11 0.13000.18000.07000.15000.13000.05000.02000.0400 1 Month T-Bill 0.11700.17000.12000.15000.15000.09000.04000.0600 3 Month T-Bill 0.16500.21000.19000.17000.18000.17000.11000.1200 6 Month T-Bill 0.61000.61000.58000.52000.53000.54000.45000.4500 Schertz Portfolio 0.15000.15000.1500 JPMorgan Chase 0.25000.25000.25000.10000.10000.10000.10000.1000 Schertz Bank&Trust 0.22940.22440.21380.20900.20840.21000.20000.1785 LOGIC 0.28000.25000.24000.24000.24000.24000.23000.2200 LoneStar 0.26000.24000.23000.22000.18000.17000.17000.1600 MBIA 0.13000.21000.19000.19000.18000.18000.15000.1200 Federated 2.22002.24002.24002.24002.24002.24002.21002.2000 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:5/31/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69191,233.0791,233.0791,233.078.000.01 Bank of Amer NA Disc Bank Accpt 10/17/2011139.0065,000.0064,886.2564,859.710.000.00 General Elec Cap Corp Disc Com Paper7/15/201145.0065,000.0064,805.7264,805.72 Total Cash & Equivalent21,233.0220,925.020,898.5 s27420 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012505.00150,000.00162,031.50158,604.006,750.00 Federal Home Loan Bks Cons Bds10/28/2011150.00135,000.00135,000.00135,101.93337.00 Federal Home Ln Mtg Corp Disc Nts Dtd10/7/2011129.00100,000.0099,746.5099,817.470.00 Federal Home Ln Mtg Corp Deb11/15/2013899.00170,000.00191,084.25187,281.358,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013847.00250,000.00250,000.00271,290.0010,937.00 Federal Natl Mtg Assn 4/20/2012325.00250,000.00250,505.00253,633.75 Total Fixed Incom,055,000.01,088,367.2,105,728.5 e105103 Total Assets452.021,276,233.071,309,292.291,326,627.003 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #691121,409.59121,409.59121,409.5912.000.01 Bank of Amer N A Disc Bankers Accp Prgm10/17/2011139.0085,000.0084,851.2584,816.550.000.00 84,745.9584,745.95 General Elec Cap Corp Disc Coml Paper7/15/201145.0085,000.00 Total Cash & Equivalent91,409.5291,006.790,972.0 s29929 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012505.00250,000.00270,052.50264,340.0011,250.00 Federal Home Loan Bks Cons Bds10/28/2011150.00175,000.00175,000.00175,132.13437.000.25 Federal Home Ln Mtg Corp Disc Nts10/7/2011129.00125,000.00124,683.13124,771.800.000.00 Federal Home Ln Mtg Corp Deb11/15/2013899.00250,000.00281,006.25275,413.7512,187.004.34 Federal Natl Mtg Assn Nts10/15/2013868.00200,000.00223,001.60218,518.009,250.004.15 Federal Natl Mtg Assn10/30/2012518.00250,000.00250,192.50250,603.751,250.000.50 US Treasury Note12/15/2011198.00100,000.00100,984.38100,550.50 Total Fixed Incom,350,000.01,424,920.3,409,329.9 e106133 Total Assets460.451,641,409.591,715,927.151,700,302.023