Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
12-SEPTEMBER 2011 STATEMENT
SEPTEMBER 2011 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department November 30, 2011 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes10,912,6561,287,443.63 10,571,479.42- -11,574,522.28 (661,866.28) Franchises 1,521,000 1,512,067.58 - -1,448,620.31 - Permits 1,181,913 80,392.20 1,638,900.78 -1,016,075.66 -(456,987.78) Licenses 64,547 1,172.50 35,193.10 -40,640.00 -29,353.90 Fees 3,073,872 166,175.85 2,663,230.90 -2,598,796.95 -410,641.10 Fines 35,000 1,905.45 26,078.81 -30,756.86 - Inter-Jurisdictional 405,672 46,966.53 420,599.89 -421,250.90 -(14,927.89) Fund Transfers 1,282,660 128,825.77 1,193,878.60 -1,097,435.09 -88,781.01 Miscellaneous28,380.0509,244.6530,325.1 573 507,284 - - TOTAL REVENUE18,984,6041,741,261.917,734,299.819,594,797.0 S867 - - - EXPENDITURE SUMMARY GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 3,052.39 23,864.76 -13,049.09 -(1,064.76) Supplies500 114.09 164.23 511.89 - - City Support Services 14,650 747.29 14,194.96 219.98 -12,637.90 Utility Services 1,318.73- -1,318.73 - -(1,318.73) Operations Support 300 296.17 190.95 - - - Staff Suppor(438.91)380.0010,774.2813,139.28 t 22,250 2,150.00 Operating Equipmen- - t - - - - TOTAL CITY COUNCIL 60,500 4,793.59 380.00 36,921.67 53,220.57 2,369.98 CITY MANAGER Personnel Services 753,457 93,367.87 742,863.46 -695,518.84 -10,593.54 Supplies 4,526 1,636.36 1,688.64 3,152.27 310.49 - City Support Services 91.50 - - - - - Operations Support 178.00 - - - - - Staff Support 33,850 4,607.15 438.80 27,913.1626,159.34 2,968.61 3,407.03 Operating Equipmen 1,596.7049.99 t 1,574 - - - TOTAL CITY MANAGER 793,407 99,611.38 438.80 723,686.31 775,525.59 3,279.10 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services250,203 30,188.11 245,788.82 -230,830.50 - Supplies 3,200 82.59 1,162.05 1,919.94 183.80 - City Support Services 1,000 10.06 - 303.06 - - Operations Support 3,000 3,162.00 1,951.00 700.00 - - Staff Support 6,200 810.87 33.44 2,886.08 3,159.35 305.00 Court Support 800 - - - - - Professional Services 84,600 3,963.75 49,154.00 2,432.50 -49,372.98 Maintenance Services 2,500 200.00 1,000.00- - - Operating Equipmen103.89 1,003.89903.98 t 2,000 - 500.00 TOTAL MUNICIPAL COURT 353,503 35,359.27 33.44 288,317.59 304,280.06 4,121.30 CUSTOMER RELATIONS-311 Personnel Services 88,928 10,420.17 83,835.58 -88,237.54 - Supplies 500 599.38 380.33 - - - - 1,069.97 Staff Support 1,105 - - - TOTAL CUSTOMER RELATIONS-311 10,420.1790,533 85,285.88 -88,836.92 - PLANNING & ZONING Personnel Services 134,105 16,347.57 134,525.35 -128,278.07 - Supplies 4,500 239.86 1,140.16 732.17 191.60 - City Support Services - - - - - - Operations Support 2,300 183.16 77.95 - - - Staff Support 22,100 6,368.50 1,527.12 12,338.03 11,115.75 2,377.05 Professional Services 142,300 17,729.03 83,965.11 1,366.40 -17,753.36 Operating Equipmen 1,055.0054.98 t 600 - - - TOTAL PLANNING & ZONING 40,684.96305,905 1,527.12 159,747.76 231,471.33 3,935.05 72,025.74 LEGAL SERVICES Operations Support13,000 9,199.04 - -10,766.11 - Professional Services89,244.77203,045.8292,043.2 98 245,000 - - TOTAL LEGAL SERVICES 258,000 89,244.77 301,242.32 -213,812.00 -(43,242.32) 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services628,024 65,440.44 617,207.71 -578,206.40 -10,816.29 Supplies59,900 1,333.74 638.43 54,880.51 56,600.23 4,872.87 (934.67) Utility Services93,600 23,699.30 97,017.04 -109,534.08 -(3,417.04) - - Operations Support - - - - Staff Support 10,212 1,022.65 403.00 6,065.00 10,490.99 241.35 Maintenance Services 110,500 4,786.81 6,471.04 101,265.29 110,319.03 9,534.00 Rental/Leasing 2,000 832.35 763.92 - - - Operating Equipmen 1,788.496,554.33 t 950 - - - - - Capital Outlay 24,500 - - - TOTAL FACILITIES MAINTENANCE 929,686 96,282.94 7,512.47 852,572.12 898,953.25 14,648.22 CITY SECRETARY Personnel Services 167,842 20,247.98 164,231.64 -163,986.48 - Supplies 1,550 16.45 988.94 1,381.64 - - City Support Services 6,788 4,613.71 6,788.22 - - - Staff Suppor275.00295.00 4,076.943,530.54 t 2,700 - TOTAL CITY SECRETARY 178,880 20,539.43 295.00 173,119.67 176,478.44 - NON-DEPARTMENTAL Supplies 3,000 4,786.32 405.35 10.00 - - City Support Services 349,407 34,720.01 760.00 393,800.55 320,103.68 1,364.02 Operations Support 115,500 15,874.14 140,986.56 6,076.05 -133,390.51 Staff Support - 80.00 - - - - City Assistance 390,552 422,942.47 - -535,289.29 -(32,390.47) Professional Services 99,521 135.26 48,600.18 -66,593.03 -50,920.82 Fund Chrgs/Transfrs-Spec Events Fnd 122,536 294,165.96 392,351.57 -51,252.85 -(269,815.96) Operating Equipment 500 264.95 - - - - Capital Outla398.8436,124.51398.84 y 7,000 - - TOTAL NON-DEPARTMENTAL 1,088,016 345,294.21 1,221,502.01760.00 1,325,868.65 7,450.07 PUBLIC AFFAIRS Personnel Services 138,096 26,082.00 160,520.83 -224,040.18 -(22,424.83) Supplies 2,450 936.22 2,024.31 1,890.03 - - Operations Support 34,500 5,927.47 25,157.94 5,489.75 -49,138.95 Staff Support 3,750 151.44 4,427.75 2,381.89 196.44 - 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Professional Services- - - -260,061.30 - Operating Equipmen 2,737.182,926.20 t 3,500 - - - TOTAL PUBLIC AFFAIRS 182,296 33,097.13 192,687.87 5,686.19 -542,618.69 RECORDS MANAGEMENT Personnel Services 46,317 5,605.99 46,158.52 -44,281.43 - Supplies 900 16.45 27.68 360.24 - - Staff Support 1,500 805.01 845.14 - - - Professional Services 23,302 12,439.00 6,209.40 22,772.51 - - Operating Equipmen- - t - - - - TOTAL RECORDS MANAGEMENT 72,019 18,061.44 70,136.41 -51,323.52 - SCHERTZ TALES MAGAZINE Personnel Services 126,426 15,998.16 126,115.55- - - Opperations Support 3,266.98- -3,217.40 - -(3,266.98) Staff Support 1,000 - 15.00 - - - Professional Services24,354.86 253,832.301,171.00 261,000 - 25.00 TOTAL SCHERTZ TALES MAGAZINE 388,426 43,570.42 1,171.00 383,229.83 25.00 - ENGINEERING Personnel Services 169,469 20,772.79 164,107.54 -159,542.03 - Supplies 300 68.07 59.38 310.22 - - City Support Services 3,995.00 - - - - - Staff Support 2,213 353.00 1,517.10 1,477.12 - - Professional Services 24,000 6,003.00 8,253.43 25,069.25 - -(1,069.25) Maintenance Services 4,044 2,400.00 2,844.24 - - - Operating Equipmen- - t - - - - TOTAL ENGINEERING 200,026 27,196.86 193,808.37 -175,766.94 - GIS Personnel Services 117,358 14,499.22 116,459.19 -113,128.84 - Supplies 3,300 823.00 378.25 2,274.62 116.10 - Staff Support 2,050 - - - - - Professional Services -250.00 1,000 - - - TOTAL GIS 15,322.22123,708 118,733.81 116.10 -113,757.09 TOTAL GENERAL GOVERNMENT 5,024,905 879,478.79 10,946.83 4,643,153.29 5,110,922.38 41,631.01 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC SAFETY POLICE Personnel Services4,083,030 507,450.40 4,165,944.45 -4,070,214.06 -(82,914.45) Supplies49,058 5,415.53 124.50 17,308.33 27,242.96 17,676.91 4,262.63 City Support Services30,000 - - -32,003.00 -30,000.00 Utility Services 100,000 18,913.26 107,990.37 -94,945.02 -(7,990.37) Operations Support 2,000 135.00 365.00 762.50 - - Staff Support 34,450 9,481.46 6,537.67 22,036.74 2,140.85 - City Assistance 13,000 1,174.65 5,235.95 6,230.83 190.00 - Professional Services 8,000 400.00 4,903.36 7,230.16 - - Maintenance Services 77,449 1,188.00 179.50 49,527.86 32,028.80 496.56 Operating Equipment 65,596 4,471.41 5,196.00 38,349.83 58,572.87 5,185.10 Capital Outla138,142.60153,726.40 y 166,298 - - 12,554.80 TOTAL POLICE 4,628,881548,629.715,500.004,457,532.684,581,766.0838,244.22 FIRE RESCUE Personnel Services 2,410,836 296,612.02 2,412,029.36 -2,225,227.93 -(1,193.36) Supplies 20,200 1,905.78 20.15 10,379.71 8,104.76 9,416.65 Utility Services 49,600 7,694.95 50,902.85 79.83 -51,096.01 Operations Support 800 419.97 687.00 - - - Staff Support 108,800 4,001.67 12,138.00 71,122.37 88,085.73 25,476.12 City Assistance 18,600 2,726.60 10,323.17 5,882.71 20,612.31 8,122.00 Professional Services 14,240 13,040.00- 1,200.00 - - Maintenance Services 53,500 9,733.92 36,997.53 3,810.01 -25,510.71 Operating Equipmen6,649.45604.5028,948.1841,368.90 t 52,400 15,560.97 TOTAL FIRE 329,324.392,728,976 23,085.82 2,418,587.59 2,671,828.44 63,665.58 16,567.80 INSPECTIONS Personnel Services364,194 45,360.71 362,767.06 -344,884.80 - Supplies 6,511 488.14 375.00 1,441.62 2,182.94 90.33 Utility Services 7,600 1,191.99 4,995.68 6,005.20 - - Operations Support 3,200 811.00 1,467.87 - - - Staff Support 14,700 1,335.05 388.20 4,473.22 4,486.90 747.77 Professional Services 10,000 5,240.47 - - - -10,000.00 Maintenance Services - - - - - - Operating Equipmen239.00- 239.00 t 239 - - TOTAL INSPECTIONS 48,614.89406,444 763.20 361,846.79 377,148.97 838.10 29,220.13 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MARSHAL SERVICE Personnel Services486,250 62,068.35 464,960.89 -361,650.55 -21,289.11 Supplies6,450 1,401.57 1,633.87 205.82 - - Utility Services 9,000 2,336.92 5,896.01 11,507.13 - -(2,507.13) Operations Support 4,000 2,293.88 434.50 3,889.27 - - Staff Support 9,400 837.69 2,653.13 4,460.66 410.00 - Professional Services - - - - - - Maintenance Services 12,400 285.00 5,157.53 10,250.85 - - Operating Equipmen7,074.84 650.0029,935.98 t 21,480 - 5,247.44 - 46,453.40 Capital Outlay 65,600 - - - TOTAL MARSHAL SERVICE 614,580 74,896.68 573,092.05 5,863.26 -377,843.29 TOTAL PUBLIC SAFETY 8,378,8811,001,465.67 29,349.02 7,615,810.35 8,203,835.54108,611.16 PUBLIC ENVIRONMENT STREETS Personnel Services596,591 66,515.80 564,880.90 -577,342.28 -31,710.10 Supplies6,167 160.04 28.15 4,732.06 4,491.33 21.04 1,682.78 Utility Services121,900 15,650.46 115,936.30 -109,390.69 - Operations Support 1,308 - 21.00 - - - Staff Support 9,265 1,643.23 84.08 6,516.11 8,228.27 79.91 Maintenance Services 136,900 9,884.78 16,620.12 119,645.32 148,204.74 631.21 Rental/Lease 200 173.50 - - - - Operating Equipment 4,380 (860.61) 5,185.95 - - - Capital Outla- 13,670.00 y 14,500 - - - TOTAL STREETS 93,854.31891,211 16,732.35 816,939.35 860,618.49 732.16 46,592.70 TOTAL PUBLIC ENVIRONMENT891,211 93,854.31 16,732.35 816,939.35 860,618.49 732.16 46,592.70 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PARKS & RECREATION PARKS DEPARTMENT Personnel Services475,862 57,517.59 469,633.41 -459,004.18 - Supplies 37,055 3,740.52 32,100.10 1,320.46 -63,907.33 City Support Services 475.39 - - - - - Utility Services 113,300 38,925.59 148,028.66 -124,124.45 -(34,728.66) Operations Support 700 600.00 - 880.80 - - Staff Support 7,686 516.16 202.35 7,959.71 7,176.21 140.92 Professional Services 53,278 3,976.50 3,661.80 44,861.00 7,143.00 - Maintenance Services 21,000 4,262.89 24,000.27 235.38 -34,277.70 Rental/Leasing 30,531 3,225.40 3,491.50 20,208.03 43,178.43 -(9,155.93) Operating Equipment 200 5,974.00 6,886.98 - - -(6,687.00) Capital Outla- 190.56 y 7,000 - - - TOTAL PARKS DEPARTMENT746,612112,164.654,293.85719,592.59776,936.428,839.76 SWIM POOL Supplies 16,700 523.39 123.66 20,310.88 16,263.58 392.93 Utility Services 25,500 6,613.10 22,756.85 -26,271.92 - Staff Support 925 439.98 166.09 - - - Maintenance Services 199,378 190,192.20 4,000.00 - -194,119.38 Rental/Lease 378.00300.00 500 - - - TOTAL SWIM POOL 243,003 7,136.49 123.66 241,442.16 229,756.72 4,392.93 COMMUNITY/CIVIC CENTER Personnel Services 112,341 5,544.07 76,185.44 -74,263.26 -36,155.56 Supplies 6,923 2,080.09 5,278.07 9,371.36 1,190.16 - Utility Services 47,150 10,047.66 42,896.74 -47,958.29 - Operations Support 14,682 5,860.05 13,784.31 -17,619.55 - Staff Support 2,750 230.83 782.45 845.30 439.45 - Professional Services 600 - 975.00 150.00 - - Operating Equipmen1,746.6033,303.102,031.60 t 7,172 - 4,245.00 TOTAL COMMUNITY/CIVIC CNTR 191,618 25,509.30 146,089.75 6,024.61 -179,204.72 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET SENIOR CITIZEN CENTER 855.89 - Supplies - - - - Utility Services 3,563.39 278.31 - - - - City Assistence - - - -18,350.00 - Maintenance Services -1,082.50 - - - - TOTAL SENIOR CITIZEN CENTER 278.31 - - -23,851.78 - TOTAL PARKS & RECREATION 1,181,233 144,810.44 4,417.51 1,164,091.25 1,153,061.20 19,257.30 CULTURAL LIBRARY Personnel Services667,832 86,724.53 680,860.67 -610,001.51 -(13,028.67) Supplies16,400 4,239.55 14,913.98 132.47 1,353.55 -14,772.52 Utility Services39,500 13,398.45 54,516.68 -58,221.24 -(15,016.68) Operations Support2,500 416.00 1,290.00 1,526.20 174.00 - Staff Support 4,185 219.57 23.25 2,850.93 1,719.99 94.97 Professional Services 2,100 200.68 2,065.00 - - - Maintenance Services 3,500 600.00 3,696.25 1,800.00 - - Operating Equipment 65,000 5,435.62 47.36 74,015.72 62,592.70 2,571.17 Capital Outla10,500.00- 10,500.00 y - - - TOTAL LIBRARY 801,017 111,033.72 10,570.61 765,048.85 830,495.22 2,972.61 TOTAL CULTURAL 801,017 111,033.72 10,570.61 765,048.85 830,495.22 2,972.61 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services302,083 33,615.17 294,011.98 -268,865.67 - Supplies 24,900 3,007.01 42.00 22,384.22 20,316.29 362.81 Utility Services 10,900 2,082.86 8,912.88 11,505.20 - - Operations Support 800 263.00 - - - - Staff Support 5,800 21.65 5,037.60 2,002.73 34.48 - City Assistance 13,000 1,495.26 6,862.47 10,457.04 - - Professional Services 14,500 1,673.00 12,017.00 -17,132.20 - Maintenance Services 6,100 526.22 (112.00) 2,402.05 3,890.83 - Operating Equipmen1,013.72 866.169,507.24 t 8,000 - - Capital Outla- - y 4,000 - - - TOTAL ANIMAL SERVICES390,08343,434.89(70.00)332,726.25363,708.31397.29 TOTAL HEALTH 390,083 43,434.89 (70.00) 332,726.25 363,708.31 397.29 INTERNAL SERVICE INFORMATION TECHNOLOGY Personnel Services261,085 33,961.86 264,162.98 -226,094.28 -(3,077.98) Supplies1,500 654.08 1,090.52 - - - City Support Services 337,952 106,880.18 78,975.69 374,552.00 331,869.28 5,435.00 Utility Services 147,131 19,068.19 137,403.51 3,170.34 -127,016.75 Staff Support 10,400 1,160.35 1,813.95 6,323.20 11,002.73 2,036.38 Professional Services - - - - - - Maintenance Services 21,100 15,082.52 - -25,465.83 - Operating Equipment 135,836 38,000.76 119,789.26 8,947.96 -89,042.10 Capital Outla10,527.0045,780.00 y 45,809 - - - TOTAL INFORMATION TECHNOLOGY 960,813 199,071.34 80,789.64 859,675.24 926,180.80 19,589.68 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services222,521 24,181.60 210,088.95 -217,697.64 -12,432.05 Supplies769 536.86 768.52 - - - Human Services 43,265 4,133.28 34,682.27 688.00 -33,626.10 Operations Support 11,946 1,571.40 266.28 15,576.50 10,888.61 798.84 Staff Support 10,982 346.07 6,163.94 7,363.56 550.72 - City Assistance 9,425 2,569.00 8,922.00 -11,801.00 - Professional Services 190 - - - - - Operating Equipmen -1,491.55 t 4,387 - - 4,386.57 TOTAL HUMAN RESOURCES303,48532,801.35266.28286,893.59272,713.916,424.13 FINANCE Personnel Services 419,818 52,056.20 416,663.72 -406,619.67 - Supplies 3,600 426.00 (99.58) 3,373.15 3,231.18 - Operations Support 1,050 133.36 489.50 475.93 - - Staff Support 13,370 347.31 74.30 8,914.46 9,502.39 80.00 Maintenance Services 630 - - - - - Operating Equipmen- 1,077.80 t 5,699 - - 266.47 TOTAL FINANCE 52,962.87444,167 (25.28) 419,396.78 430,951.02 346.47 12,844.23 PURCHASING & ASSET MGT Personnel Services234,220 28,915.82 233,936.98 -231,172.49 - Supplies 2,350 14,410.26 640.89 15,121.29 (12,775.79)4.50 - Utility Services 1,150 82.57 409.31 410.03 - - Operations Support 150 - 60.68 - - - Staff Support 6,900 770.00 5,023.65 6,029.30 - - Operating Equipmen- - t 150 - - - TOTAL PURCHASING & ASSET MGT 244,920 44,178.65 255,558.28 (10,642.78)4.50 -237,246.34 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services148,533 23,770.53 168,750.64 -147,054.88 -(20,217.64) Supplies103,862 15,247.52 4,701.70 103,406.48 119,491.51 3,426.39 (14,354.20) City Support Services1,500 1,500.00 1,500.00 - - - Utility Services 7,000 678.73 6,471.08 5,223.32 - - Operations Support 750 - 750.00 - - - Staff Support 2,960 307.36 1,624.26 2,313.06 620.41 - Professional Services - - - - - - Maintenance Services 43,563 2,172.85 474.24 43,371.37 54,764.30 1,685.29 Rental/Lease35.00 -185.00 200 - - Operating Equipmen 4,113.89- t 4,450 - - - Capital Outla25,869.00- 25,869.00 y - - - TOTAL FLEET SERVICE 312,818 68,080.99 5,175.94 303,428.07 382,960.72 5,732.09 TOTAL INTERNAL SERVICE 2,266,203 397,095.20 86,206.58 2,106,640.02 2,268,364.73 32,096.87 MISC & PROJECTS CITY ASSISTANCE 47.35 214.21 Utility Services - - - - Patient Assistance 5,000 5,000.00 5,000.00 - - - Children's Advocacy Assistance 5,000 5,000.00 5,000.00 - - - Senior Citizen's Hot Meals- 42,000.00 42,000 - - - TOTAL CITY ASSISTANCE 52,000 52,214.21 - -10,047.35 - COURT - RESTRICTED FUNDS 2,460.00 11,697.40249.98 Operating Equipment - - 1,920.00 TOTAL CITY ASSISTANCE249.9811,697.401,920.00 -2,460.00 - TOTAL MISC & PROJECTS 52,000 2,460 10,297 63,912 1,920 - TOTAL EXPENDITURES18,985,5332,673,633.02 158,152.9017,454,706.69 207,618.4018,854,917.48 REVENUE OVER(UNDER) EXPEND.(929)739,879.5 9 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,704,566 5,355.95 6,271,917.07- 6,741,571.32 - (37,005.32) 000-411200Advalorem Tax - Delinquent 50,000 2,718.14 60,617.04- 49,040.49 - 000-411300Advalorem Tax - P&I 50,000 1,376.85 41,655.29- 45,891.31 - 000-411500Sales Tax Revenue-Gen Fund4,071,590 1,277,992.69 4,160,495.14- 4,702,216.53 - (630,626.53) 000-411600Bingo Tax 4,500 - - 4,651.28 2,172.67 - 000-411700Mixed Beverage Ta32,143.6033,629.96 x 32,000.00 - - - TOTAL Taxes10,912,6561,287,443.63 10,571,479.42-11,574,522.28 (661,866.28) Franchises 000-421200Center Point/Entex Energy 33,000 - 23,991.96- 47,076.51 - (14,076.51) 000-421220City Public Service 275,000 - 282,814.38- 309,573.17 - (34,573.17) 000-421240Guadalupe Valley Elec Co-op 430,000 - 460,216.22- 404,250.28 - 25,749.72 000-421250New Braunfels Utilities 30,000 - 19,067.60- 26,460.65 - 000-421300Time Warner-State Franchise 350,000 - 328,880.83- 333,655.67 - 16,344.33 000-421350Time Warner-PEG Fee 62,000 - 62,904.94- 65,557.47 - (3,557.47) 000-421460AT&T Franchise Fee 220,000 - 157,235.35- 150,808.59 - 69,191.41 000-421465AT&T PEG Fees 16,000 - 18,167.37 23,758.36 - (7,758.36) 000-421480Other Telecom Franchise 15,000 - 16,708.62- 63,149.80 - (48,149.80) 000-421500Solid Waste Franchise Fee90,00078,633.0487,777.08 - - - TOTAL Franchises1,521,000- 1,448,620.31-1,512,067.58 - Permits 000-431100Home Occupation Permit 770 - - 490.00 280.00 - 000-431200Building Permit 837,952 40,871.00 692,073.79- 1,255,381.83 - (417,429.83) 000-431300Mobile Home Permit 671 - - 80.00 80.00 - 000-431400Signs Permit 8,596 150.00 - 615.00 900.00 - 000-431500Food Establishmnt Permit 15,000 20,500.00 33,150.00- 38,845.00 - (23,845.00) 000-431600Garage Sale Permit 9,554 975.00 12,025.30- 11,735.00 - (2,181.00) 000-431700Plumbing Permit 109,769 6,146.00 87,654.50- 113,743.25 - (3,974.25) 000-431750Electrical Permit 63,062 2,580.00 57,275.50- 68,860.00 - (5,798.00) 000-431800Mechanical Permit 84,211 4,660.00 77,814.00- 82,600.00 - 000-431900Solicitor/Peddler Permit 210.00 - 1,000.00 3,000.00 - - (3,000.00) 000-431950Animal/Pet Permit 2,000 - - 2,085.00 1,630.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt6,578350.00-6,250.007,300.00 - 000-432100Security Alarm Permit 36,000 3,575.20 38,375.07- 45,733.20 - (9,733.20) 000-435000Fire Permit7,750375.00 8,812.507,187.50 - - TOTAL Permits1,181,91380,392.20 1,016,075.66-1,638,900.78 - (456,987.78) Licenses 000-441000Alcohol Beverage License 6,100 157.50 - 6,230.00 5,555.00 - 000-442000Contractors License 55,447 725.00 29,403.00- 25,275.00 - 30,172.00 000-444000Pet License3,000290.00 4,363.105,007.00 - - TOTAL Licenses 64,547 1,172.50 40,640.00- 35,193.10 - 29,353.90 Fees 000-451000Municipal Court Fines 1,540,000 83,999.23 1,195,414.86- 1,048,290.29 - 491,709.71 000-451100Arrest Fee 60,000 3,165.87 57,091.43- 44,713.61 - 15,286.39 000-451110Expunction Fee 90 - - 60.00 30.00 - 000-451200Warrant Fees 187,500 8,228.00 127,798.75- 129,281.17 - 58,218.83 000-451320Civil Justice Fee-Court 500 4.70 65.62 66.90 - 000-451321Civil Justice Fee-State 41.90 - - 602.57 - - 000-451340Judicial Fee - City 7,000 421.27 - 7,386.07 5,995.46 - 000-451400Traffic Fine Costs TTL 30,000 1,581.84 29,923.56- 22,536.17 - 000-451500Teen Court Admin Fee 500 20.00 - 480.00 300.00 - 000-451510Juvenile Case Mgmt Fee 60,000 3,511.32 61,576.80- 49,991.46 - 10,008.54 000-451600Technology Fund Fee 55,000 2,807.72 50,299.77- 40,384.23 - 14,615.77 000-451700Security Fee 40,000 2,105.78 37,730.25- 30,297.17 - 000-451800Time Payment Fee - City 5,000 490.47 - 4,382.81 5,700.69 000-451850State Fines 10% Service Fee 70,000 - 72,008.75- 68,238.98 - 000-451900DPS Payment - Local 12,250 641.67 10,370.57- 10,499.63 - 000-452000Child Safety Fee 8,000 1,300.64 - 8,098.73 11,207.20 - (3,207.20) 000-452050Indigent Defense Fee 22,500 1,366.04 23,923.50- 19,368.75 - 000-452100Platting Fees 66,000 - 62,250.00- 61,500.00 - 000-452200Site Plan Fee 26,400 4,500.00 27,949.45- 30,000.00 - (3,600.00) 000-452300Plan Check Fee 375,000 22,335.00 352,099.41- 643,109.41 - (268,109.41) 000-452310Miscellaneous Review Fee - 6,300.00 9,000.00 - 2,700.00 - (9,000.00) 000-452320Tree Mitigation Admin Fee 11,220 - - 9,468.75 7,680.00 - 000-452400BOA/Zoning Fees 11,000 350.00 - 8,000.00 1,750.00 - 000-452500Food Handler Class 8,000 1,130.00 - 6,070.00 7,240.00 - 000-452600Specific Use/Zone Chng Fee 14,630 - - 4,000.00 21,150.00 - (6,520.00) 000-452610Plat Recording Fee - -- - - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452710Zoning Ltr & Dev Rights150.00-450.00600.00 - - 000-453100Reinspection Fees 49,000 3,975.00 58,468.02- 40,580.00 - 000-453110Swim Pool Inspection Fee - - 1,200.00 1,050.00 - - (1,050.00) 000-453120Inspections Plan Review - - 833.00 - - - 000-453200Mowing Fees - Inspections 130.00 - 3,626.27 12,111.26 - - (12,111.26) 000-453211Admin Fee-Inspections 200.00 10,800.00- 7,900.00 - - (7,900.00) 000-4532153% Technology Fee - - 531.40 1.98 - 000-453310Misc Inspection Fee - - 10.00 270.00 - 000-453500SubContractor Reg. Fee 17,196.50- 26,820.00 - 1,585.00 - (26,820.00) 000-453710Foster Care - - 500.00 850.00 - - 000-454100Swim Pool Reservation Fee - 669.84 - - - 000-454200Pool Gate Admission Fee 22,000 - 23,820.37- 22,720.35 - 000-454300Seasonal Pool Pass Fee 5,500 - - 5,421.50 7,046.00 - (1,546.00) 000-456500Haz Mat Fees2,500 - - 370.00 - - 000-456510Fire Plan Review 800 - - - - - 000-456600Fire Re-inspection Fee 450 - - 500.00 900.00 - 000-458100Sale of Merchandise - - - 17.00 - - 000-458300Sale of Property/Auction 20,000 41.75 20,909.88- 28,599.30 - (8,599.30) 000-458400Civic Center Rental Fees 226,000 10,481.25 170,344.79- 126,108.75 - 99,891.25 000-458401Capital Recovery Fee-Civic Cntr 586.00 - - 2,266.00 - 000-458450North Center Rental Fees 24,000 663.00 - 11,075.00- 000-458500Community Center Rental Fees32,000 2,830.90 36,139.26- 20,995.72 - 11,004.28 000-458550Pavilion Rental Fees - 19,292.70- - 1,370.00 000-458560Chamber of Comm rent - - - 7,800.00 - - (7,800.00) 000-458570Non-Resident SYSA League 18,000 - 38,086.00- 7,060.00 - 10,940.00 000-458600Ball Field Use - - 288.63 1.76 - - 000-458650NonResident User Fee-BVYA9,000--5,980.009,090.00 - 000-458680Tournament Fees-Soccer 14,000 - - 3,650.00 2,400.00 - 11,600.00 000-458700Vehicle Impoundment 5,000 - - 2,442.75 - - 000-459200NSF Check Fee 100 - - 179.00 328.00 - 000-459300Notary Fee 200 12.00 - 285.00 369.00 - 000-459400Maps, Copies, UDC, & Misc F 200 - - 125.56 618.18 - 000-459600Animal Adoption Fee 10,500 810.50 11,175.00- 11,832.00 - (1,332.00) 000-459700Pet Impoundment Fee 17,500 1,997.00 15,853.00- 19,618.01 - (2,118.01) 000-459800Police Reports Fee6,532642.00 5,976.206,192.10 - - TOTAL Fees 3,073,872 166,175.85 2,598,796.95- 2,663,230.90 - 410,641.10 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines35,0001,905.4530,756.8626,078.81 - - TOTAL Fines 35,000 1,905.45 30,756.86- 26,078.81 - Inter-Jurisdictional 000-473100Bexar Co - Fire 21,078 1,756.48 21,077.76- 21,077.76 - 000-473200City of Seguin - Fire Contract 40,293 3,355.26 40,263.12- 40,263.12 - 000-473300Guad Co - Library 180,816 15,068.00 180,814.92- 165,748.00 - 15,068.00 000-473400Randolph AFB-Animal Cntrl 2,500 400.00 - 2,608.00 2,300.00 - 000-474200Library Services - Cibolo - 20,030.00- - 20,012.50 - (20,030.00) 000-474210Library Services-Selma 19,000 - 34,196.00- - - 19,000.00 000-474250Non-Resident Library Fees - - - - - - 000-474400Dispatch Service - Cibolo 133,305 - 133,305.00- 133,305.00 - 000-474500Dispatch Service - SCUCISD 2,080 - - 2,080.00 - - 000-474600School Crossing Guard-Bexar6,6003,165.69 6,906.1014,207.84 - - 000-474610School Cross Guard-Guadalupe3,208.60 23,668.17- - - - TOTAL Inter-Jurisdictional 405,672 46,966.53 421,250.90- 420,599.89 - (14,927.89) Fund Transfers 000-480000Indirect Costs - EMS87,8407,320.00 87,840.00-87,840.00 - 000-480100Indirect Costs - Hotel/Motel 170,221 14,185.10 127,632.00- 170,221.00 - 000-481000Transfer From Reserves 98,186 - - - - - 98,185.61 000-482100Transfer From Reserves-Ct Tech - - - - - 000-482150Transfer From Court Security 58,011 - - - 58,011.00 000-485000Interfund Charge-Drainage 38,888 3,486.25 38,297.50- 38,887.75 - 000-486000Interfund Chrges-Admin W&S 624,777 52,064.70 638,947.97- 624,776.95 - 000-486202Transfer In-W&S 15,420.52- 25,869.00 - 25,869.00 - (25,869.00) 000-486317Transfer From Park Fund - - 4,133.27 - - - 000-486322Transfer-In - Library Grants 10,000 13,028.67 13,028.67- - (3,028.67) 000-486402Transfer from City Wide Projects - - 25,372.05- - - (25,372.05) 000-487000Interfund Charges-Fleet 91,737 7,442.05 79,660.03- 89,304.95 - 000-488000Interfund Charges-4B 53,000 5,430.00 55,500.00- 55,431.97 - (2,431.97) 000-489000Transfer In -- - 3.80 13,146.26 - (13,146.26) 000-490020Transfer In-SEDC50,000 50,000.0050,000.00 - - - TOTAL Fund Transfers 1,282,660 -128,825.77 1,097,435.09 1,193,878.60 - 88,781.01 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ************************************************ 2 0 1 0 - 2 0 1 1 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 5,000 43.01 - 4,814.40 1,686.53 - 000-491200Investment Income 26,000 2,862.50 27,700.62- 35,761.09 - (9,761.09) 000-491900Unrealized Gain/Loss - 1,541.25 (20,468.45) - (3,099.63) - 20,468.45 000-493000Donations-Others - - - 340.00 - - 000-493120Donations-Public Library - - 14.00 - - - 000-493130Donations-Writing the Next Chap.20,000 171.00 18,756.80- 25,339.00 - (5,339.00) 000-493400Donation - Animal Control 3,670 619.00 - 6,108.79 5,324.21 - (1,654.21) 000-493401Donations-A/C Microchip 3,000 135.00 - 3,037.50 2,210.00 - 000-493402Donations-Spay&Neuter 12,000 744.00 13,453.00- 15,373.58 - (3,373.58) 000-493403Donations-Melvin Boeck A. S. - - - - - - 000-493460Donations-Employee Picnic - - (243.62) - (543.62) - 000-493503Donations - Fire Rescue - - - 25.00 - - 000-494481LawEnforcemtOfficersStnd&Ed 3,800 - - 3,705.94 3,550.22 - 000-494482DOJ-PD GRANT - - - 648.99 - - 000-497000Misc Income-Gen Fund 40,000 9,569.12 81,070.16- 76,371.98 - (36,371.98) 000-497005Misc Income-Publications 240,000 13,083.20 151,272.20- 153,057.25 - 86,942.75 000-497007Misc Income-Schertz Artz - - 1,000.00 - - - 000-497020Misc Income-Fleet Recycled 400 - - 250.80 - - 000-497100Misc Income-Police 20,000 507.70 33,222.92- 23,366.19 - (3,366.19) 000-497200Misc Income-Library 12,131 281.90 - 8,109.64 18,535.85 - (6,404.85) 000-497210Misc Income-Library Copier 3,400 1,006.00 6,675.85 11,877.80 - (8,477.80) 000-497300Misc Income-Animal Control 2,400 - - 1,619.85 1,506.37 - 000-497400Misc Income-Streets Dept. 11,229 264.42 19,119.11- 20,178.12 - (8,949.12) 000-497500Misc Income-TML Insurance 78,043 - 77,914.65- 49,728.90 - 28,314.10 000-497550Misc Income-TML Reimbursemt20,211 - 45,318.59- 29,053.61 - (8,842.61) 000-497600Misc Income-Parks/Vending Mach.500 247.06 -1,372.242,263.29 - (1,763.29) 000-498000Reimbursmnt-Gen Fund5,50047.07 3,166.3610,434.53 - - 000-498100Reimbursmnt Fire - Training - - - 1,101.00 - - (1,101.00) 000-498105Reimburmnt Police - DEA - - 7,367.68 - 2,442.32 - (7,367.68) 000-498110Reimbursmnt Fire - Emg. Acti-O - - 30,936.01- - - (30,936.01) 000-498500Settlement - Litigation 25,000.00- - - - - TOTAL Miscellaneous507,284 28,380.05 - 509,244.67 530,325.13 - (23,041.13) TOTAL REVENUES18,984,6041,741,261.98 17,734,299.86-19,594,797.07 (610,193.46) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking361,947.96$ Cash in Investment Pools LOGIC Investment-General Fund954,756.60 LOGIC Investment-Equip Replacement73,298.24 LOGIC Investment-Veh Replacement7,074.82 LOGIC Investment-Air Condi Replacment122,349.07 CAPITAL ONE Investment-General Fund1,333,486.96 Total Cash in Bank & Investment Pools$2,975,163.91 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 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 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% 17% $400,000 24% 23% -2% 5% 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 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 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 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 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 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: SEPTEMBER 30th, 2011 ************************************************** 2 0 1 0 - 2 0 1 1 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET100% OF 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 - - 3,974.40 - - 2,100.00 Hal Balwin Scholarship 1,000.00 - - 285.00 23,685.00 - (22,685.00) Miscellaneous22,300.00 1,477.75-6,440.771,876.68 - TOTAL REVENUES139,014.00 1,477.75 - 173,970.42 56,023.59 - 82,990.41 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - - 707.55 200.00 - 4,550.00 Festival of Angels 13,250.00 - 10,358.65 12,654.23 - - 595.77 Employee Appreciation Event 5,000.00 435.22 - 1,758.45 561.22 - 4,438.78 4th of July Jubilee - 2,210.88 693.74 218.05 - 2,114.38 National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 30,500.00 - 29,059.36 30,461.91 - - Blue Santa - - 5,276.68 - - - Schertz Fest 455.59 3,381.64 1,855.91 - 1,400.00 - (1,400.32) TML Events - - 4,036.67 - - - Schertz Sweetheart 42,945.00 1,058.00 35,978.72 44,385.85 13.44 - Hal Baldwin Scholarship9,355.00-1,000.0010,354.11 - -(999.11) Selma-Schertz 5K400.00- 400.00- - - TOTAL CULTURAL 3,949.60106,300.00 1,513.59 93,768.60 101,566.97 231.49 6,015.13 TOTAL EXPENDITURES111,450.00 3,949.60 1,513.59 93,768.60 101,566.97 231.49 11,165.13 REVENUE OVER(UNDER) EXPEND27,564.00 (45,543.38) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking31,766.51$ Cash in Investment Pools MBIA Special Events66,554.74 Total Cash in Bank & Investment Pools$98,321.25 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises138,0002,500.00 153,684.41-198,280.20 (60,280.20)- Fees13,679,7501,564,782.35 12,692,170.42-14,716,653.63 (1,036,903.63)- Fund Transfers503,8866,718.00 79,000.03-80,616.00 423,270.00- Miscellaneous52,664.801,124,047.99359,716.65 55,445 - - TOTAL REVENUES14,377,0811,626,665.1514,048,902.8515,355,266.48 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers 31,000.00- 31,000 - - - TOTAL NON DEPARTMENTAL 31,000.00- 31,000 - - - BUSINESS OFFICE Personnel Services458,64043,448.09 429,379.82-406,553.98 52,086.02- Supplies5,549388.46-4,231.193,509.06484.88 Operations Support108,5007,454.85 101,121.50-96,648.88 11,851.12- Staff Support7,450631.85-2,228.302,974.2194.26 Professional Services15,501(1,127.60) 16,534.97-5,500.21395.00 Fund Charges/Transfers40,000---- 40,000.00- Maintenance Services12,000420.00 12,477.00-6,207.95- Operating Equipmen776.10 6,117.62500.00 t 7,300 - - TOTAL BUSINESS OFFICE51,215.65527,511.911,474.14 654,940 -566,748.88 W & S ADMINISTRATION Personnel Services1,212,507124,332.67 1,181,089.59-1,177,186.95 35,320.47- Supplies214,031(17,358.25)338.73107,644.19147,210.624,538.13 Human Services338---64.00- City Support Services51,9409,610.75 23,926.26-48,484.802,200.00 Utility Services2,802,065360,553.66 2,196,818.48-2,500,032.55 302,032.45- Operations Support8,750302.6179.604,635.256,125.25- Staff Support33,0003,264.261,339.0021,764.2722,473.36294.54 City Assistance1,912348.00-778.00789.00- Professional Services165,38626,306.619,870.00312,597.09207,568.50 (32,312.50)- Fund Charges/Transfers2,368,1761,670,377.25 3,717,322.01-3,667,410.45 (1,299,234.45)- Maintenance Services4,845,660714,523.25 5,150,932.61116.415,292,256.7512,372.43 Other Costs29,832- 23,671.50-29,831.85- Debt Service1,435,165(933,508.30) 379,725.95-409,588.10- Rental-Leasing6,320--2,902.622,508.53- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Operating Equipment21,7802,500.003,420.007,648.2325,182.70- Capital Outla52,432.00-- y 58,000(132,061.40) -110,432.00 -- Water Line Relocation - - - 260,403 TOTAL PUBLIC WORKS13,515,2651,829,191.1167,595.74 13,536,713.4119,405.1013,131,456.05 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services3,862----- Operations Support500(248.04)---- Professional Services64,038(56,972.38)-- 1,750.79- Maintenance Services(306,384.72) 8,088.70- 329,044 - - (363,605.14)-8,088.701,750.79 TOTAL AVIATION HEIGHTS WTR IMP 397,444 - FM3009 RD&BRIDGE EXPANSION Professional Services79,505(55,278.65)19,137.50-- 98,642.50- Maintenance Services(65,789.78) -- 137,256 - - (121,068.43)19,137.50-- TOTAL FM3009 RD&BRIDGE EXPANSION 216,761 -235,898.50 TOTAL MISC & PROJECTS(484,673.57)19,137.50-8,088.701,750.79 614,205 TOTAL EXPENDITURES14,815,4101,395,73386,73313,698,20514,103,31422,630 ** REVENUE OVER(UNDER)EXPENSES **(438,329)1,251,952.46 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 2,500.00153,684.41198,280.20 000-421490Tower Leasing138,000 - - TOTAL Franchises 138,000 2,500.00 153,684.41- 198,280.20 - (60,280.20) Fees 000-455200Garbage Collection Fee 3,300,000 338,904.60 3,010,551.43- 3,291,498.58 - 000-455600Fire Line Fees 18,500 5,940.69 18,378.67- 24,370.69 - (5,870.69) 000-455700Recycle Fee Revenue 155,000 22,858.58 151,227.62- 225,058.13 - (70,058.13) 000-455800W&S Line Constructn Reimbursemnt50,000 1,348.00 33,521.58- 30,089.60 - 19,910.40 000-457100Sale of Water 7,200,000 868,524.77 6,361,401.18- 7,816,709.86 - (616,709.86) 000-457110Edwards Water Lease 127,250 6,617.50 71,997.50- 199,612.50 - (72,362.50) 000-457120Water Transfer Charge-Selma 5,000 - - 780.18 2,668.48 - 000-457130Water Transfer Charge-U. C. 1,000 - - 3,914.06 1.28 - 000-457200Sale of Meters 86,000 3,355.26 67,340.66- 71,813.58 - 14,186.42 000-457400Sewer Charges 2,560,000 298,262.46 2,808,278.67- 2,874,955.85 - (314,955.85) 000-457500Water Penalties 175,000 18,586.72 161,792.55- 177,199.29 - (2,199.29) 000-459200NSF Check Fee-Water&Sewer2,000383.772,986.322,675.79 - - TOTAL Fees13,679,7501,564,782.35 12,692,170.42-14,716,653.63 (1,036,903.63) Fund Transfers 000-481000Transfer In- Reserve423,270---- - 423,270.00 6,718.0079,000.03 80,616.00 000-486204Interfnd Chrg-Drainage Bill80,616 - - TOTAL Fund Transfers 503,886 6,718.00 79,000.03- 80,616.00 - 423,270.00 Miscellaneous 000-490000Misc Charges 15,000 291.74 11,842.71- 6,964.02 - 000-491000Interest Earned 500 205.89 - 1,030.75 1,509.02 - (1,009.02) 000-491200Investment Income 5,000 8,722.61 25,582.34- 17,816.77 - (12,816.77) 000-493130Library Donations - - 6.36 - - - 000-493400Donations-Christmas Activitise - - - 1,000.00 - - (1,000.00) 000-495013Capital Contribution - W&S - 973,437.00- - - - 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S 20,000 43,444.56 35,213.40- 51,215.69 - (31,215.69) 000-497550TML Reimbursements - - - 2,291.34 - - (2,291.34) 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC - 75,046.93- 102,014.05 - - (102,014.05) 000-498200W&S Project Reimbursement5,0001,888.50 - - - TOTAL Miscellaneous 55,445 52,664.80 1,124,047.99- 359,716.65 - (304,271.65) TOTAL REVENUES14,377,0811,626,665.15 14,048,902.85- 15,355,266.48 (978,185.48) 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking618,568.08$ Cash in Investment Pools Lone Star Investment-Water&Sewer857,487.32 Lone Star Investment-W&S Customer Deposits293,595.81 Lone Star Investment-W&S Equip Replacement372,980.54 Lone Star Investment-W&S Veh Replacement543,850.20 Lone Star Investment-Water/SSLGC SAWS134,628.87 Schertz Bank & Trust-Certificate of Deposit1,044,420.00 $3,246,962.74 Total Cash in Bank & Investment Pools3,865,530.82$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees5,436,537 285,021.63 4,575,032.52- 3,215,436.85 2,221,100.15- Inter-Jurisdictional1,432,345 22,743.94 1,398,528.35- 1,388,591.28 43,753.72- Miscellaneous4,217.64-159,532.36177,508.73 334,850 - TOTAL REVENUES 311,983.21 - 6,133,093.23 4,781,536.86 - 2,422,195.14 7,203,732 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,391,410325,727.90 2,557,315.75-2,661,936.86 (270,594.86)68.00 Supplies 12,036.45 382.34 280,227.60 279,914.48 43,738.69 332,874 Human Services 40.00 - - 654.00 847 - City Support Services 3,239.93 14,908.67- 14,214.12 15,000 - Utility Services 20,630.93 89,119.63- 118,724.75 (38,297.16)10.41 80,438 Operations Support 7,606.68 30,123.95- 47,310.79 1,084.65 33,500 Staff Support 2,136.81 171.35 89,461.68 61,675.13 3,307.25 75,600 City Assistance 1,049.00 13,245.82- 12,830.80 250.00 13,753 Professional Services 6,843.91 160.00 116,888.40 114,476.71 435.21 141,390 Fund Charges/Transfers3,576,092 164,560.27 3,166,496.21- 771,201.85 - 2,804,890.15 Maintenance Services (845.87) 32,828.86- 20,934.04 42,320 - 21,385.96 Debt Service 19,047.50- 242,270.49 248,502 - - 6,231.51 Rental-Leasing (3,604.76) - 9,988.82 - 40,000.00 40,000 - Operating Equipment 5,236.69 73,907.22- 38,866.07 921.50 64,600 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 544,657.94 713.69 6,493,560.11 4,385,010.09 49,815.71 2,622,213.89 7,056,326 TOTAL EXPENDITURE 544,657.94713.696,493,560.114,385,010.0949,815.71 S 7,056,326 ** REVENUE OVER(UNDER) EXPENSES 396,526.77 * 147,406 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt5,336,537 284,876.63 - 4,561,965.52 3,196,591.85 - 2,139,945.15 59.90% 000-456110Subscription Program Fees100,000 145.00 - 13,047.00 18,845.00 18.85% - 81,155.00 20.00- 000-459200NSF Check Fee - - - - - TOTAL Fees5,436,537285,021.63 4,575,032.52- 3,215,436.85 2,221,100.15- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 22,743.94 - 285,576.27 286,126.44 100.00% - 000-474300Cibolo Support 219,699 213,300.00- 213,300.00 - - 6,399.00 000-475100Comal Co ESD #6 75,369 73,173.76- 56,880.00 - - 18,489.00 000-475200Live Oak Support 152,569 148,125.00- 148,125.00 - - 4,444.00 000-475300Universal City Support 210,545 204,412.52- 204,412.52 - - 6,132.48 000-475400Selma Support 64,689 62,805.00- 68,730.00 - - (4,041.00) 000-475500Schertz Support 399,083 387,459.48- 387,459.48 - - 11,623.52 000-475600Santa Clara Support 10,851 10,653.16- 10,534.68 - - 000-475800Marion Support13,41413,023.1613,023.16 - - - TOTAL Inter-Jurisdictional1,432,345 22,743.94 1,398,528.35- 1,388,591.28 43,753.72- Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 33.65 - 293.88 554.62 - - (554.62) 000-493203Donations-EMS 6,000 300.00 - 1,252.75 11,750.00 - (5,750.00) 000-493204Donations-Dilworth Fund - 1,000.00- - - - (1,000.00) 000-493205Donations- Golf Tournament - 4,430.00- - - - (4,430.00) 000-497000Misc Income 150,000 3,333.99 93,867.91- 79,781.70 - 70,218.30 000-497100Recovery of Bad Debt 100,000 400.00 - 11,422.41- - 88,577.59 000-497500Misc Income-EMT Classes78,850150.0064,117.8268,570.00 - - TOTAL Miscellaneous 334,850 4,217.64 159,532.36- 177,508.73 - 157,341.27 TOTAL REVENUES7,203,732311,983.21 6,133,093.23- 4,781,536.86 2,422,195.14- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank $ (445,182.85) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,747.73 $(144,435.12) Total Cash in Bank & Investment Pools 27 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 675,30065,696.41 680,266.83- 714,443.31 -(39,143.31) Fund Transfers - - 12,800 -12,800 -(12,800) Miscellaneous1,3001,652.521,053.64 66.81 - - TOTAL REVENUES 78,563.60676,600681,919.35 -728,297.33(51,697.33) - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 361,18330,778.87 343,585.33- 345,713.93 -15,469.07 Supplies 8,300 502.18 28.15 3,361.83 3,971.09 -4,357.06 Human Services 100 - - - - -100.00 City Support Services 10,500 - 4,981.37 5,832.18 - -4,667.82 Utility Services 22,888 4,265.64 15,454.88- 19,850.91 -3,037.09 Operations Support 2,458 - - - - -2,458.00 Staff Support 1,524.148,255 168.83 4,230.57 5,953.05 2,427.7643.02 City Assistance 840 - 102.00 15.00 - -825.00 Professional Services 25,800 151.01 - 6,819.22 16,699.53 -9,100.47 Fund Charges/Transfers 195,44982,744.12 122,912.23- 202,259.87 -(6,810.87) Maintenance Services 22,000 43.67 11,663.26- 2,030.67 -19,969.33 Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 18,138 - 4,366.89 18,137.56 100.00% - - Rental/Leasing500-- - - -500.00 Operating Equipment116.00- - - - - - TOTAL DRAINAGE 120,009.63676,511196.98517,693.58 43.02620,563.79 56,100.75 TOTAL EXPENDITURE 120,009.63676,511196.98517,693.58 43.02620,563.79 S 56,100.75 ** REVENUE OVER(UNDER) EXPEND89107,733.54 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 3,849.36 4,360.85 3,500 394.14 -(860.85) 000-457600Drainage Fee 65,302.27-676,417.47710,082.46 -(38,282.46) 671,800 TOTAL Fees65,696.41 680,266.83-714,443.31 (39,143.31)- 675,300 Fund Transfers 000-486100Transfer In - - - - - - -0.00% 000-486202Transfer In-Water12,800.38--12,800.38 -(12,800.38) - TOTAL Fees - - 12,800.38 0.00% -12,800.38 -(12,800.38) Miscellaneous 000-491000Interest Earned - 237.39 243.70 100 7.96 -(143.70) 000-491200Investment Interest - 749.26 625.20 104.20% 600 44.99 - 000-497000Misc Income-Drainage-665.87184.74 600 13.86 - TOTAL Miscellaneous - 1,652.52 1,053.64 1,300 66.81 -246.36 TOTAL REVENUES78,563.60 681,919.35-728,297.33 (51,697.33)- 676,600 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Ban k Claim on Operating Cash Pool-Checking 87,916.81 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,080.64 Total Cash in Bank & Investment Pools$370,997.45 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 121,260.60385,000 348,147.04- 391,181.21 -(6,181.21) Fund Transfers 55,000 - - - - -55,000 Miscellaneous 25.875,550-4,818.44985.15 - TOTAL REVENUES 121,286.47445,550-352,965.48392,166.36 - EXPENDITURE SUMMARY NONDEPARTMENTAL Personnel Services 31,841 - - - - -31,841.00 Supplies 8,312 990.12 - - 3,305.52 213.00 City Support Services 20,000.0078,228 502.85 65,465.80 79,630.85 101.15% -(900.00) Operations Support 52,458.1070,862 - 3,510.00 64,750.78 1,046.04 Professional Services 2,500 - 902.28 2,500.00 - - -100.00% Fund Charges/Transfers 231,485 14,185.10 212,876.00- 170,221.00 -61,264.00 Operating Equipment 9,250 - 542.98 9,250.00- - -100.00% Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 87,633.32432,478502.85283,297.06320,408.15 L 10,509.04 TOTAL EXPENDITURE 87,633.32432,478502.85283,297.06320,408.15 S 10,509.04 REVENUE OVER(UNDER) EXPENDITURE13,072 71,758.21 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax385,000 121,260.60348,147.04391,181.21 -(6,181.21) - TOTAL Taxes 121,260.60385,000 348,147.04- 391,181.21 - (6,181.21) Fund Transfers 000-481000Transfer From Reserve55,000 ---55,000.00 - - TOTAL Fund Transfers 55,000 - - - - - 55,000.00 Miscellaneous 000-491000Interest Earned25018.36-280.39260.91 104.36% - (10.91) 000-491200Investment Interest 300 7.51 - 144.13 124.24 - 175.76 000-497000Misc Income -5,0004,393.92600.004,400.00 - - TOTAL Miscellaneous5,55025.87-4,818.44985.15 - 4,564.85 TOTAL REVENUES 121,286.47445,550 352,965.48- 392,166.36 - 53,383.64 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking181,656.12$ Cash in Investment Pools Federated Investment-Hotel/Motel78,126.04 Total Cash in Bank & Investment Pools$259,782.16 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 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 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: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 40,000 220,000.00- 107,675.00 675.00 -(67,675.00) Tree Mitigation Fees 40,000 53,756.25- 43,520.00 - -(3,520.00) Miscellaneous-3,481.09638.59 405 42.09 - TOTAL REVENUES-277,237.34151,833.59 80,405 717.09 - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Transfers-10,021.08- - - - TOTAL PARKLAND DEDICATION-10,021.08- - - - PARKLAND DEDICATION Supplies - 105.95 - - - - Maintenance Services-Landscape 8,000 - 1,621.36 28,399.00 - -(20,399.00) Operating Equipment 30,000 11,244.23 78,762.61 57,028.78 (16,162.75)378.20 280.00 Capital Outlay-- - 6,000 - - TOTAL PARKLAND DEDICATION11,244.2380,489.9285,427.78 44,000 280.00 378.20 TREE MITIGATION Fund Charges/Transfers-4,133.27- - - - Maintenance Services-Trees 36,000 3,133.00 80,387.61 33,944.55 2,075.00 -5,188.45 Capital Outlay-- - - - - TOTAL TREE MITIGATION3,133.0084,520.8833,944.55 36,000 2,075.00 - TOTAL EXPENDITURE14,377.23175,031.88119,372.33 S 80,000 2,355.00 378.20 REVENUE OVER(UNDER) EXPEND32,461.26 405 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 40,000 675.00 220,000.00- 107,675.00 (67,675.00) 000-458900Tree Mitigation40,00053,756.2543,520.00 - - TOTAL Fees 80,000 675.00 273,756.25- 151,195.00 (71,195.00) Miscellaneous 000-491000Interest Earned 60 5.01 - 251.02 219.62 (159.62) 000-491200Investment Interest 280 37.08 - 440.07 418.97 (138.97) 000-497000Miscellaneous Income652,790.00- - - TOTAL Miscellaneous40542.09-3,481.09638.59 (233.59) TOTAL REVENUES 80,405 717.09 277,237.34- 151,833.59 (71,428.59) 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking$44,120.99 Cash in Investment Pools Federated Investment-Park Fund252,690.39 Federated Investment-Tree Mitigation126,234.76 Total in Investment Pool 378,925.15 Total Cash in Bank & Investment Pools$423,046.14 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *********************************************** 2 0 1 0 - 2 0 1 1 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer 31,000 - 31,000.00- - - Miscellaneous-- - 25,000 - - TOTAL REVENUES-- 31,000.00 56,000 - - EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor-33,453.88- 56,000 - - TOTAL NONDEPARTMENTA-33,453.88- L 56,000 - - TOTAL EXPENDITURE-33,453.88- S 56,000 - - 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: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S31,000-- 31,000.00 - - TOTAL Fund Transfers31,000- 31,000.00- - - Miscellaneous 000-490210Sale of Recycle Material25,000-- - - - TOTAL Miscellaneous 25,000 - - - - -25,000.00 TOTAL REVENUES 56,000 - - 31,000 - - 25,000 39 RECYCLE FUND CASH IN BANK AS OF: SEPTEMBER 30th, 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: SEPTEMBER 30th, 2011 ******************************************************* 2 0 1 0 - 2 0 1 1 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees1,190,640 104,154.85 1,356,976.96- 2,437,724.66 -(1,247,084.66) Fund Transfers 347,024.92- 46,539.29 -46,539.29 -(46,539.29) Miscellaneous585,500(305,908.72)10,369.1616,710.97 - - TOTAL REVENUES1,776,140(155,214.58)1,714,371.042,500,974.92 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Operations Support1,000---- -1,000.00 Professional Services 26,800 (14,982.57) - 3,977.58 1,106,543.20 -(1,079,743.20) Fund Charges/Transfers 130,369.52- 228,802.73 -128,802.73 -(228,802.73) Debt Service - 118,896.50- - - - Capital Outlay8,428.00 8,428.00- - - - TOTAL NON DEPARTMENTA27,800113,820.168,428.00253,243.601,343,773.93 L - MISC & PROJECTS Projects230,200(91,310.70)53,906.78 -1,387.50 233,628.0849,091.20 Schaefer RD Water Improvements599,643 -- - - -599,643.00 Northcliffe Elevated Tnk -- - - - - Northcliffe Water Plant -- - - - - Town Creek Project -- - - - - Live Oak Water Plant -- -(38,106.38) - - Loop Feed Water Line -- - - - - viation Heights WTR IMP88,252(344,233.90)225,148.72 -- A - TOTAL MISC & PROJECTS918,095(473,650.98)279,055.50 1,387.50- 49,091.20 TOTAL EXPENDITURE945,895(359,830.82)287,483.50253,243.601,345,161.43 S 49,091.20 REVENUE OVER(UNDER) EXPENDITURES830,2451,155,813 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 **************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 904,200 65,638.85 880,386.28- 1,338,670.59 - (434,470.59) 000-455910Capital Recovery - Waste Wtr272,800 36,716.00 475,390.68- 872,855.78 - (600,055.78) 000-455911Capital Recovery-Wste Wtr Zone 113,640 - - - - - 13,640.00 000-455913Cap Recovery-North Sewer Tr1,800.001,200.00 226,198.29 - - - TOTAL Fees1,190,640104,154.85 1,356,976.96- 2,437,724.66 - (1,247,084.66) Fund Transfers 000-481000Transfer from Reserves - - - - - - 000-486202Transfer in-Water 46,539.29- -46,539.29 - -(46,539.29) 347,024.92- 000-486406Transfer in-Public Improvement - - - - TOTAL Fund Transfers46,539-347,02546,539 - - (46,539.29) Miscellaneous 000-491000Interest Earned2,00013.36-3,659.56496.08 - 1,503.92 000-491200Investment Income 250,000 3,371.33 - 5,038.76 39,009.22 - 210,990.78 000-491900Unrealized Gain/Loss-Cap One - (22,794.33)- -(3,585.11) - 22,794.33 000-497000Misc Income - 1,670.84 - - - - 000-498100Reimbursmnt - FM 78 Project (45,833.30)50,000 - - - - 50,000.00 (259,875.00)- - 000-498200Re-imbursement-Water Meters 283,500 - - TOTAL Miscellaneous (305,908.72)585,500 10,369.16- 16,710.97 - 568,789.03 TOTAL REVENUES1,776,140(155,214.58) 1,714,371.04- 2,500,974.92 - (724,834.92) 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking246,221.17$ Cash in Investments: Lone Star Investment-Capital Recovery Water452,571.25 Lone Star Investment-Capital Recovery Sewer280,362.07 Capital One-Investment1,708,113.64 Schertz Bank & Trust-Certificate of Deposit525,404.70 Total Cash in Bank & Investment Pools$3,212,672.83 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ****************************************************** 2 0 1 0 - 2 0 1 1 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 4,797.383,368,794 - 3,363,045.67 3,425,585.48 -(56,791.48) Fund Transfers243,000 64,486.34 - - 64,486.34 -178,513.66 Miscellaneous3,00010.473,363.9215,504.39 - - TOTAL REVENUES 69,294.193,614,7943,366,409.593,505,576.21 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Professional Services3,200 400.00 - 3,550.00 1,550.00 -1,650.00 Debt Service3,611,124 -3,521,014.173,625,353.50 - - TOTAL GENERAL GOVERNMEN 400.003,614,3243,524,564.173,626,903.50 T - - TOTAL EXPENDITURE 400.003,614,3243,524,564.173,626,903.50 S - - ** REVENUE OVER(UNDER) EXPEND470(121,327.29) 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue3,368,7944,797.383,363,045.673,425,585.48 - - TOTAL Taxes3,368,7944,797.38 3,363,045.67-3,425,585.48 -(56,791.48) Fund Transfers 000-486000Transfer From Reserves243,000 - - - - -243,000.00 -- 000-486103Transfer In - - - - 000-486401Transfer In Fund 40164,486.34 64,486.34- - - - TOTAL Fund Transfers 243,000 64,486.34 - 64,486.34- -178,513.66 Miscellaneous 000-491000Interest Earned 1,500 0.55 - 1,692.74 14,437.36 -(12,937.36) 000-491200Investment Earnings1,5009.921,671.181,067.03 - - TOTAL Miscellaneous 3,000 10.47 - 3,363.92 15,504.39 -(12,504.39) TOTAL REVENUES3,614,794 69,294.19 3,366,409.59- 3,505,576.21 -109,217.79 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 505-TAX I & S***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent400.00 1,550.003,550.00 3,200 - - TOTAL Professional Services3,200400.00-3,550.001,550.00 -1,650.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 - - 149,980.00 80,502.08 -60,815.92 101-555622Schertz C O SR2003-Principal190,000 - - 180,000.00 190,000.00 - 101-555622.1Schertz C O SR2003-Interest 60,820 - 67,480.00- 60,820.00 - 101-555624Comm Proj Bond-SR04-Principal325,000 - 325,000.00- 325,000.00 - 101-555624.1Comm Proj Bond SR04-Interest265,009 - 279,226.88- 265,008.13 - 101-555626LS&D SR2006-Principal - 100,000.00- - - - 101-555626.1LS&D SR2006-Interest 650,982 - 652,981.25- 650,981.25 - 101-555628CO Bond 2007-Principal 99,567 - 92,933.33- 99,709.25 - 101-555628.1CO Bond 2007-Interest 26,617 - 15,030.52- 26,523.79 - 101-555629GO Bond 2007-Principal 275,000 - 250,000.00- 275,000.00 - 101-555629.1GO Bond 2007-Interest 209,097 - 234,677.81- 209,096.25 - 101-555630GO Bond SR2008 Principal 355,000 - 235,000.00- 355,000.00 - 101-555630.1GO Bond SR2008 Interest 379,651 - 349,224.17- 379,650.25 - 101-555631GO Bond SR2009 Principal 140,000 - 80,000.00- 140,000.00 - 101-555631.1BO Bond SR2009 Interest309,480.21283,062.50 283,063 - - - TOTAL Debt Service3,611,124- 3,521,014.17-3,625,353.50 -(14,229.50) TOTAL EXPENDITURES3,614,324 400.00 3,524,564.17- 3,626,903.50 -(12,579.50) 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking669.50$ Cash in Investment Pools MBIA Investment- Tax I&S88,589.78 Federated Investment-Tax I&S56.79 Total Cash in Bank & Investment Pools$89,316.07 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 ***************************************************** 2 0 1 0 - 2 0 1 1 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET100% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,035,795640,065.55 2,080,253.67- 2,352,177.47 - (316,382.47) Fund Transfers - - 100,000 - - - (100,000) Miscellaneous78,0002,987.6633,618.3218,648.91 - - ,,,.,,.,,. TOTALREVENUES211379564305321211387199247082638 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 23,000 1,938.96 623.28 16,606.67 20,899.52 903.90 Utility Service 85,800 23,495.79 87,256.81- 80,782.47 - 5,017.53 Maintenance Services 65,300 15,243.43 5,965.50 42,791.20 71,356.93 2,247.51 Operating Equipment 8,498 18,494.00- 6,999.31 - - 1,498.69 Capital Outlay6,999.31 -- - - - TOTAL NONDEPARTMENTA182,59840,678.1813,588.09165,148.68180,038.233,151.41 L ECONOMIC DEVELOPMEN T Personnel Services 202,062 14,525.93 241,094.53- 156,414.67 - 45,647.33 Supplies 2,000 640.81 - 781.60 1,524.83 562.17 Human Services 100 - - - 54.00 - City Support Services 33,500 982.78 623.92 48,461.05 17,642.22 2,750.54 Utility Services 4,850 286.18 - 3,944.63 2,907.67 - 1,942.33 Operations Support 76,100 1,623.15 3,242.89 83,964.51 53,126.94 5,092.15 Staff Support 97,000 1,942.72 1,782.11 102,483.29 74,218.02 2,112.76 City Assistance 80,000 60,000.00- - - - 80,000.00 Professional Services 379,000 47,622.09 21,340.80 255,055.36 253,412.25 30,935.60 Fund Charges/Transfers 105,432 5,430.00 105,500.00- 105,431.97 - Fund Replenish-Fund Balance 216,000 - - - - - 216,000.00 Maintenance Services - 781.89 - - - - Debt Service 792,432 536,176.71- 792,432.00 - - Operating Equipment1,500248,230.741,112.82 - - - TOTAL ECONO DEVELOPMEN 73,053.661,989,97626,989.721,686,474.311,458,223.39 T 41,507.22 TOTAL EXPENDITURE 113,731.842,172,57440,577.811,851,622.991,638,261.62 S 44,658.63 ** REVENUE OVER(UNDER) EXPEND(58,779)832,564.76 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: SEPTEMBER 30th, 2011 *************************************************** 2 0 1 0 - 2 0 1 1 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET100% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,035,795640,065.552,080,253.672,352,177.47 - - TOTAL Taxes2,035,795640,065.55 2,080,253.67- 2,352,177.47 -(316,382.47) Fund Transfers 000-486000Transfer In 100,000.00- - - - - TOTAL Fund Transfers- 100,000.00- - - -(100,000.00) Miscellaneous 42.35- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 1,000 38.57 - 673.14 280.40 - 000-491200Investment Earnings 12,000 2,873.03 24,665.62- 12,797.75 - 000-497000Misc Income 15,000 76.06 - 8,237.21 5,570.76 -9,429.24 000-499000Transfer From Reserves50,000 -- - - - TOTAL Miscellaneous 78,000 2,987.66 33,618.32- 18,648.91 - TOTAL REVENUES2,113,795643,053.21 2,113,871.99-2,470,826.38 -(357,031.38) 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: SEPTEMBER 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking433,649.64$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,015,675.17 Schertz Bank & Trust-Certificate of Deposit506,692.64 Schertz Bank & Trust-Certificate of Deposit1,031,406.35 Total Cash in Bank & Investment Pools2,987,423.80$ 50 4B SALES TAX $300,000 $250,000 -1% 16% 17% $200,000 23% 24% 5% -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 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 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 SEPTEMBER 30th, 2011 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,827,392.01,757,497.52.0900,044,291.22,974,396.73,827,392.01,827,392.01 204322 TOTAL OPERATIONS2,827,392.01,757,497.52,044,291.22,974,396.73,827,392.01,827,392.01 24322 LOGIC General Fund954,756.60,009,068.02.138193.58,054,505.0054,756.60 N/A54,756.60 201199 G/F-Equipment Replacement73,298.2473,289.920.1381 -8.3273,298.24 N/A73,298.24 G/F-Vehicle Replacement7,074.82,074.02.1381 -.80,074.82 N/A,074.82 70077 G/F-Air Conditioner Replacement122,349.07122,335.190.1381 -13.88122,349.07 N/A122,349.07 ,156,201.35.13814,750.04-,210,951.39,210,951.39 SR2009 Bond-Street Projects(II)2,210,951.39 20522 TOTAL LOGIC3,368,430.12,367,968.504,966.62,054,505.00,368,430.12,368,430.12 45133 LONESTA R Capital Recovery - Sewer280,362.07280,317.510.1700 -44.56280,362.07 N/A280,362.07 Capital Recovery - Water452,571.2552,499.32.1700 -1.9352,571.25 N/A52,571.25 40744 Drainage Fund283,080.64283,035.650.1700 -44.99283,080.64 N/A283,080.64 GO SR2011 Animal Shelter2,267,590.64,267,230.22.1700 -60.42,267,590.64 N/A,267,590.64 20322 GO SR2011 Athletic Fields1,491,284.461,491,047.430.1700 -237.031,491,284.46 N/A1,491,284.46 GO SR2011 Soccer Fields1,511,727.08,511,486.80.1700 -40.28,511,727.08 N/A,511,727.08 10211 GO SR2011 Swimming Pool3,023,454.163,022,973.600.1700 -480.563,023,454.16 N/A3,023,454.16 W/S-Customer Deposits293,595.8193,549.14.1700 -6.6793,595.81 N/A93,595.81 20422 W/S-Equipment Repl/Cap.Imp372,980.54372,921.260.1700 -59.28372,980.54 N/A372,980.54 Water&Sewer857,487.3257,351.03.1700 -36.2957,487.32 N/A57,487.32 80188 W/S-Vehicle Replacement543,850.20543,763.760.1700 -86.44543,850.20 N/A543,850.20 34,607.47.17001.40-34,628.8734,628.87 Water/SSLG - SAWS134,628.87 10211 TOTAL LONESTA10,779,679.720,777,966.36 -,713.360,779,679.720,779,679.72 R1111 MBIA Tax I&S88,589.7888,579.870.1400 -9.9188,589.78 N/A88,589.78 Police Forfeiture359,115.0259,074.83.1400 -0.1959,115.02 N/A59,115.02 30433 Economic Development Corporation1,015,675.171,015,561.450.1400 -113.721,015,675.17 N/A1,015,675.17 Special Events Fund66,554.746,547.24.1400 -.506,554.74 N/A6,554.74 60766 SEDC Tax Notes 2010--0.1400---- 00,714.08.14003.65-00,747.7300,747.73 EMS Tax Notes 2010300,747.73 30333 TOTAL MBIA1,830,682.44,830,477.47 -04.97,830,682.44,830,682.44 1211 FEDERATED SR2007a Bond-City Wide Projects867,718.07867,634.710.1200 -83.36867,718.07 N/A867,718.07 Hotel Occupancy Tax78,126.048,118.53.1200 -.518,126.04 N/A8,126.04 70777 Park Fund (Developers Fee)252,690.39252,666.110.1200 -24.28252,690.39 N/A252,690.39 Park Fund (Tree Mitigation)126,234.7626,221.96.1200 -2.8026,234.76 N/A26,234.76 10111 Tax I&S56.7956.780.1200 -0.0156.79 N/A56.79 4,676.33.1200.29-4,680.624,680.62 Library Board Fund44,680.62 40444 TOTAL FEDERATED1,369,506.67,369,374.42 -32.25,369,506.67,369,506.67 1111 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,280,744.111,308,660.162.3600 275.485,504.151,313,888.83 N/A1,333,486.96 ,715,683.83.07007.55353.43,715,377.95,708,113.64 Capital One Capital Recovery1,640,748.60 12411 TOTAL CAPITAL ONE2,921,492.71,024,343.99 628.91,551.70,029,266.78,041,600.60 3533 52 City Portfolio By Investment Type Schertz Bank &Trust C.D.s 10% Operations Account Schertz Bank & Trust 5% Capital One Managed LOGIC Pool 9% FEDERATED Pool 21% MBIA Pool 16% LONESTAR Pool 13% 54 City Portfolio By Use Pooled-Daily Operations, $2,827,392 Designated Funds, $5,962,540 Special Revenue Funds, $5,907,764 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.04000.01000.16000.01000.0200 1 Month T-Bill 0.11700.17000.12000.15000.15000.09000.04000.06000.03000.10000.02000.0200 3 Month T-Bill 0.16500.21000.19000.17000.18000.17000.11000.12000.10000.16000.05000.0600 6 Month T-Bill 0.61000.61000.58000.52000.53000.54000.45000.45000.44400.44090.45000.4500 Schertz Portfolio 0.15000.15000.1500 JPMorgan Chase 0.25000.25000.25000.10000.10000.10000.10000.10000.10000.10000.10000.0900 Schertz Bank&Trust 0.22940.22440.21380.20900.20840.21000.20000.17850.17450.14240.13800.1381 LOGIC 0.28000.25000.24000.24000.24000.24000.23000.22000.20000.17000.17000.1700 LoneStar 0.26000.24000.23000.22000.18000.17000.17000.16000.16000.14000.14000.1400 MBIA 0.13000.21000.19000.19000.18000.18000.15000.12000.11000.10000.14000.1200 Federated 2.22002.24002.24002.24002.24002.24002.21002.20002.20002.20002.20002.2000 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:9/30/2011 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69195,744.1195,744.1195,744.119.000.01 Bank of Amer NA Disc Bank Accpt 10/17/201117.0065,000.0064,886.2564,782.610.000.00 General Elec Cap Corp Disc Com Paper3/12/2012164.0065,000.0064,891.2264,891.22 Total Cash & Equivalent25,744.11225,521.525,417.9 s2824 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012383.00150,000.00162,031.50156,567.006,750.00 Federal Home Loan Bks Cons Bds10/28/201128.00135,000.00135,000.00135,016.20337.00 Federal Home Ln Mtg Corp Disc Nts Dtd10/7/20117.00100,000.0099,746.5099,750.840.00 Federal Home Ln Mtg Corp Deb11/15/2013777.00170,000.00191,084.25186,110.908,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013725.00250,000.00250,000.00269,312.5010,937.00 Federal Natl Mtg Assn 4/20/2012203.00250,000.00250,505.00252,265.00 Total Fixed Incom,055,000.01,088,367.2,099,022.4 e105143 Total Assets349.241,280,744.111,313,888.831,324,440.383 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #691120,748.60120,748.60120,748.6012.000.01 Bank of Amer N A Disc Bankers Accp Prgm10/17/201117.0085,000.0084,851.2584,715.730.000.00 84,857.7484,857.74 General Elec Cap Corp Disc Coml Paper3/12/2012164.0085,000.00 Total Cash & Equivalent90,748.6290,457.590,322.0 s20927 Fixed Income Federal Farm Cr Bks Cons Systemwide Bds10/17/2012383.00250,000.00270,052.50260,945.0011,250.00 Federal Home Loan Bks Cons Bds10/28/201128.00175,000.00175,000.00175,021.00437.000.25 Federal Home Ln Mtg Corp Disc Nts10/7/20117.00125,000.00124,683.13124,688.550.000.00 Federal Home Ln Mtg Corp Deb11/15/2013777.00250,000.00281,006.25273,692.5012,187.004.34 Federal Natl Mtg Assn Nts10/15/2013746.00200,000.00223,001.60216,906.009,250.004.15 Federal Natl Mtg Assn10/30/2012396.00250,000.00250,192.50250,777.501,250.000.50 US Treasury Note12/15/201176.00100,000.00100,984.38100,231.00 Total Fixed Incom,350,000.01,424,920.3,402,261.5 e106153 Total Assets359.111,640,748.601,715,377.951,692,583.623