Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
04-JANUARY 2012 FINANCIAL STATEMENT
JANUARY 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department March 2, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,7252,308,485.89 6,457,855.71-7,757,773.13(2,369.81) Franchises 1,617,000 180,904.40 107,256.10- 273,267.91 - 1,343,732.09 Permits 1,187,800 40,051.00 826,648.83- 241,127.00 - 946,673.00 Licenses 31,300 5,330.00 12,872.10- 12,617.50 - 18,682.50 Fees 3,341,727 227,650.62 986,603.34- 733,306.87 - 2,608,420.13 Fines 30,000 2,321.15 - 8,372.74 7,893.71 (47.46) Inter-Jurisdictional 571,245 77,221.64 117,149.26- 183,160.92 - 388,084.08 Fund Transfers 1,760,658 108,750.59 316,615.75- 435,002.36 - 1,325,655.64 Miscellaneous615,50024,139.37164,439.72216,738.70(8.90) - TOTAL REVENUES20,958,9552,974,854.668,997,813.559,860,888.10(2,426.17) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,813.46 - 7,211.42 6,951.26 - 15,848.74 Supplies500 - - 46.00 95.98 - City Support Services 20,500 100.00 219.98 12,337.23 866.86 31.75 Utility Services - - - - - - Operations Support 300 - - - - - Staff Support17,400362.372,150.00 8,586.9314,641.221,286.18 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 2,275.83 2,369.98 28,181.58 22,555.32 1,317.93 CITY MANAGE R Personnel Services750,83856,163.25 219,275.42-227,127.08 - 523,710.92 Supplies5,331 1,181.26 268.94 1,277.76 2,207.30 - City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 2,667.05 1,527.05 10,010.21 13,059.19 2,615.68 Operating Equipment -133.43 - - - - TOTAL CITY MANAGER 781,719 60,011.56 230,696.821,795.99 242,393.57 2,615.68 538,505.74 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 16,901.49 - 75,847.32 75,490.65 - 181,622.35 Supplies2,500 57.30 99.00 499.94 617.24 76.19 1,905.57 City Support Services1,000 - - - - - Operations Support 3,000 - 700.00 1,166.00 1,558.00 - Staff Support 5,500 116.09 285.20 1,020.22 1,278.66 108.92 Court Support 800 - - - - - Professional Services 71,100 4,541.25 15,645.00- 18,167.50 20,597.50 Maintenance Services 2,200 - - - 249.94 - Operating Equipment1,000150.00497.14 747.14500.00 - TOTAL MUNICIPAL COURT 21,766.13344,213 1,581.34 94,678.48 98,109.13 20,782.61 226,902.60 CUSTOMER RELATIONS-311 Personnel Services109,618 6,577.17 - 26,178.05 26,904.02 - 82,713.98 Supplies300 - - - 27.64 - Staff Support1,100 -- - - - Operating Equipment500142.00 192.00- - - TOTAL CUSTOMER RELATIONS-311 111,518 6,719.17 26,178.05- 27,123.66 - 84,394.34 PLANNING & ZONING Personnel Services 217,495 9,369.63 41,136.87- 41,220.26 - 176,274.74 Supplies 2,700 195.26 156.45 58.36 686.04 - Operations Support 750 - - - - - Staff Support 17,150 - 548.55 2,963.18 1,720.85 43.06 Professional Services 76,650 4,867.50 1,366.40 18,959.73 13,144.28 - 64,872.12 Operating Equipment3,500 -1,055.002,112.00 - - TOTAL PLANNING & ZONING318,24514,432.392,071.4064,173.1456,771.432,155.06 LEGAL SERVICES Operations Support 13,000 - - 7,986.92 - - 13,000.00 Professional Services245,00060,891.38 60,891.3828,705.4833.18 - TOTAL LEGAL SERVICES 258,000 60,891.38 36,692.40- 60,891.38 33.18 197,075.44 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services648,323 37,500.00 - 204,827.55 173,256.57 - 475,066.43 Supplies57,100 8,591.81 1,224.76 21,833.87 23,636.21 4,492.48 30,196.07 Utility Services111,000 10,343.12 - 17,015.77 23,154.85 - 87,845.15 - - - - Operations Support - - Staff Support 11,179 2,558.64 41.35 4,422.63 4,794.52 705.03 Maintenance Services 106,450 14,197.92 673.05 52,929.88 33,133.35 2,929.49 Rental/Leasing 1,400 - - 456.96 - - Operating Equipment2,500 -- - - - Capital Outlay24,500 -- - - - TOTAL FACILITIES MAINTENANCE 962,452 73,191.49 1,939.16 301,486.66 257,975.50 8,127.00 CITY SECRETAR Y Personnel Services 164,529 11,414.80 51,636.77- 48,047.75 - 116,481.25 Supplies 1,250 196.29 - 745.78 576.05 33.79 City Support Services 9,780 - - 1,400.00 - - Staff Support8,605271.00 2,074.451,837.80627.82 - TOTAL CITY SECRETARY 184,164 11,882.09 55,620.35- 50,698.25 661.61 NON-DEPARTMENTA L Supplies 2,500 - - 195.44 10.71 - City Support Services 551,462 1,294.02- 211,346.66 168,395.27 - 384,360.75 Operations Support 139,000 6,745.10 1,076.05 42,031.00 49,404.69 50.00 Staff Support - - - - - - City Assistance 459,046 96,046.91 196,822.44- 192,093.82 - 266,952.18 Professional Services 157,150 12,883.96 19,009.86- 20,632.31 - 136,517.69 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,320,008 115,675.97 2,370.07 469,405.40 430,536.80 50.00 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services215,678 19,624.06 - 44,353.02 74,010.70 - 141,667.30 Supplies2,900 83.79 - 129.87 1,004.34 135.31 1,760.35 Operations Support35,100 1,219.81 4,989.75 5,754.41 7,840.08 375.00 31,874.67 Staff Support4,350 137.50 196.44 682.87 1,007.73 143.08 3,395.63 Operating Equipment300 -- - - - TOTAL PUBLIC AFFAIRS 258,328 21,065.16 5,186.19 50,920.17 83,862.85 653.39 RECORDS MANAGEMEN T Personnel Services 47,850 3,104.33 14,471.37- 14,286.47 - 33,563.53 Supplies 750 - - - 71.00 - Staff Support 1,500 - - 85.00 85.00 739.40 Professional Services 15,000 149.00 - 1,659.00 1,204.50 - 13,795.50 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 3,253.33 16,215.37- 15,646.97 739.40 SCHERTZ TALES MAGAZINE Personnel Services 129,161 9,077.89 36,576.35- 37,736.87 - 91,424.13 Supplies 200 - - - - - Opperations Support 200 - - - - - Staff Support 1,500 - - - 85.74 31.23 Professional Services302,70020,598.56 92,445.3883,839.76600.00 - TOTAL SCHERTZ TALES MAGAZINE 433,761 29,676.45 120,416.11- 130,267.99 631.23 ENGINEERING Personnel Services 164,460 4,836.21 50,922.09- 23,922.83 - 140,537.17 Supplies 400 28.03 - 67.35 134.87 121.38 City Support Services - - - - - - Utility Services 600 - - - - - Staff Support 2,213 - - 395.00 130.00 - Professional Services 48,165 9,437.50 - 1,710.00 34,892.50 - 13,272.50 Maintenance Services 4,044 - - 2,145.29 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,0001,737.31 25,451.31- - - TOTAL ENGINEERING 245,882 16,039.05 55,239.73- 87,876.80 121.38 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 8,300.90 - 35,463.72 35,370.61 - 86,708.39 Supplies3,500 216.00 - - 552.02 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 8,516.90 35,463.72- 35,922.63 - 95,706.37 TOTAL GENERAL GOVERNMENT 5,476,519 445,396.90 17,314.13 1,585,367.98 1,600,632.28 37,888.47 PUBLIC SAFETY POLICE Personnel Services4,536,879 294,607.80 - 1,334,819.97 1,326,586.60 - 3,210,292.40 Supplies31,957 1,213.98 4,761.16 4,469.62 7,455.29 1,792.37 27,470.50 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 8,279.44 - 21,465.55 25,854.87 - 97,601.13 Operations Support1,500 - - 98.00 675.00 45.00 780.00 Staff Support58,372 2,181.40 1,732.17 1,021.74 7,026.29 8,028.00 45,049.88 City Assistance10,914 1,782.97 - 1,439.98 2,217.74 283.00 8,413.26 Professional Services20,000 5,200.00 - - 5,842.85 - 14,157.15 Maintenance Services44,435 - - 14,851.50 5,540.00 - 38,895.00 Operating Equipment57,887 4,585.24 2,905.10 19,914.76 9,971.35 28,559.27 22,261.48 Capital Outlay142,52512,554.80147,872.00155,076.05 - - TOTAL POLICE 5,062,925317,850.8321,953.231,545,953.121,565,764.4538,707.64 FIRE RESCUE Personnel Services 2,508,586 191,199.45 768,359.34- 787,783.43 - 1,720,802.57 Supplies 20,500 851.67 9,239.99 1,757.33 11,243.39 237.60 Utility Services 57,000 5,324.36 7.64 10,677.95 14,327.44 - 42,680.20 Operations Support 800 - - - 215.00- Staff Support 120,185 6,903.78 19,618.33 22,834.53 38,384.79 11,527.36 City Assistance 18,600 8,122.00- 10,323.17 8,366.30 - 18,355.70 Professional Services 18,140 - - 1,200.00 11,793.0022.19 Maintenance Services 56,000 2,863.16 3,710.01 3,409.45 7,722.50 174.21 Operating Equipment58,300 12,206.238,988.361,238.95 -15,553.04 Capital Outlay35,000 -- - - 31,116.00 TOTAL FIRE 2,893,111 207,142.42 56,251.01 830,768.00 876,838.40 56,302.12 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 28,245.36 - 112,196.70 123,232.43 - 297,285.57 Supplies2,500 36.95 - 565.15 529.96 36.87 1,933.17 Utility Services6,500 437.77 - 1,366.86 1,295.24 - Operations Support 1,500 - - - - - Staff Support 8,000 87.30 581.37 1,632.71 1,490.21 - Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 450,01828,807.38581.37115,761.42126,547.8436.87 MARSHAL SERVICE Personnel Services 534,355 35,447.77 124,763.58- 160,941.72 - 373,413.28 Supplies 4,600 (3.30) 205.82 166.30 1,354.60 99.00 Utility Services 12,000 884.32 - 1,348.80 3,020.43 - Operations Support 4,000 - - 119.88 986.41 - Staff Support 15,400 650.00 410.00 918.61 3,992.67 30.00 Professional Services - - - - - - Maintenance Services 30,700 145.00 - 1,900.00 149.00 - 30,551.00 Operating Equipment16,0003,557.162,206.37 5,508.919,207.0330.00 Capital Outlay34,000 31,022.0541,560.29 - - - TOTAL MARSHAL SERVICE 651,055 40,680.95 2,822.19 176,286.37 210,673.91 159.00 TOTAL PUBLIC SAFETY 9,057,109 594,481.58 81,607.80 2,668,768.91 2,779,824.60 95,205.63 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 42,934.30 - 205,864.49 206,829.12 - 473,527.88 Supplies7,100 414.42 21.04 2,542.17 1,994.68 192.87 4,933.49 Utility Services113,900 10,048.56 - 22,988.60 32,005.44 - 81,894.56 - - - - Operations Support - - Staff Support 10,265 638.81 79.91 1,831.83 1,722.63 384.05 Maintenance Services 270,800 16,927.57 579.71 46,067.57 62,073.42 4,987.65 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 4,200.00 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,82270,963.66680.66297,164.66308,111.285,564.57 TOTAL PUBLIC ENVIRONMENT 1,086,822 70,963.66 680.66 297,164.66 308,111.28 5,564.57 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 33,149.55 - 147,639.98 146,216.64 - 360,653.36 Supplies40,555 3,830.09 1,169.51 12,813.87 14,928.15 651.31 26,145.05 Utility Services113,000 16,204.75 - 16,995.55 32,192.96 70.16 80,736.88 Operations Support700 - - 600.00 - - Staff Support 8,573 520.55 3,190.4160.93 3,693.11 115.80 4,825.02 Professional Services62,610 12,639.50 - 8,045.00 22,934.00 - 39,676.00 Maintenance Services22,000 1,091.37 44.99 8,852.07 6,128.61 5,333.13 10,583.25 Rental/Leasing42,200 3,225.40 - 25,443.34 16,257.20 25,803.20 139.60 - - 4,950.94 - Operating Equipment - - Capital Outlay -- - - - - TOTAL PARKS DEPARTMENT796,50870,661.211,275.43228,531.16242,350.6731,973.60 SWIM POOL Supplies 16,700 - 392.93 413.62 516.58 - 16,576.35 Utility Services 25,500 1,099.32 - 2,357.57 5,370.50 - 20,129.50 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 4,000.00- - 4,000.00 - 199,378.00 Rental/Lease500 -- - - - TOTAL SWIM POOL 1,099.32243,003 4,392.93 2,771.19 10,637.08 - 236,758.85 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services107,533 4,015.95 - 16,574.54 17,759.67 - 89,773.33 Supplies28,300 2,787.16 1,127.61 4,524.34 5,157.15 435.67 23,834.79 Utility Services47,550 3,658.56 - 7,420.55 8,696.84 - 38,853.16 Operations Support15,200 1,431.65 - 1,188.50 2,830.26 8.00 12,361.74 Staff Support3,300 15.00 439.45 250.00 722.46 100.49 2,916.50 Professional Services1,600 - 150.00 825.00 150.00 - Operating Equipment5,0004,243.88 6,059.58100.00 - - TOTAL COMMUNITY/CIVIC CNTR208,48311,908.325,960.9430,882.9341,375.96544.16 TOTAL PARKS & RECREATION 1,247,994 83,668.85 11,629.30 262,185.28 294,363.71 32,517.76 CULTURAL LIBRARY Personnel Services 692,531 47,007.79 207,065.19- 211,324.51 - 481,206.49 Supplies14,000 484.58 86.59 3,142.97 3,966.40 33.92 10,086.27 Utility Services41,000 3,061.08 - 9,706.04 9,750.45 - 31,249.55 Operations Support2,000 - 174.00 - 174.00 - Staff Support 4,215 439.71 58.97 309.82 607.16 150.00 Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 400.00 - 800.00 800.00 - Operating Equipment 75,000 621.98 2,366.43 27,496.79 16,207.52 15,078.04 Capital Outlay -- - - - - TOTAL LIBRARY 52,015.14833,246 2,685.99 250,585.81 244,970.04 15,261.96 575,699.99 TOTAL CULTURAL833,246 52,015.14 2,685.99 250,585.81 244,970.04 15,261.96 575,699.99 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 14,839.31 - 96,188.21 86,992.01 - 209,446.99 Supplies25,000 896.81 319.99 5,506.17 6,146.06 2,484.51 16,689.42 Utility Services11,200 824.65 - 2,251.16 2,063.61 - Operations Support 500 - - - - - Staff Support 11,560 1,013.37 34.48 1,542.10 2,869.25 646.49 City Assistance 10,000 - - 2,160.12 2,516.82 2,241.02 Professional Services 14,500 435.00 - 3,948.50 885.00 - 13,615.00 Maintenance Services 6,200 - - 1,161.78 2,340.00 220.50 Operating Equipment9,500110.51 3,995.001,374.38 - - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES384,89918,119.65354.47116,753.04105,187.135,592.52 TOTAL HEALTH 384,899 18,119.65 354.47 116,753.04 105,187.13 5,592.52 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 18,474.51 77,255.93- 85,009.41 - 175,022.59 Supplies 2,000 - - 403.49 68.84 - City Support Services 372,354 20,461.20 40,416.73- 59,543.63 15,723.00 Utility Services 154,949 8,219.24 1,585.17 28,982.04 38,919.25 1,400.31 Staff Support 15,250 25.38 2,036.38 2,987.63 4,365.61 2,215.77 Professional Services 2,500 - - - - - Maintenance Services 12,500 1,074.70 - 8,295.07 5,732.44 - Operating Equipment 129,315 7,490.58 4,911.44 24,829.23 18,415.65 18,286.25 Capital Outlay213,500 -- - - - TOTAL INFORMATION TECHNOLOGY1,162,400 55,745.61 8,532.99 183,170.12 212,054.83 37,625.33 921,252.83 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 24,722.38 - 68,339.41 73,777.11 - 222,972.89 Supplies1,329 598.97 - - 781.57 - Human Services 47,156 1,494.68 654.00 11,846.40 13,173.04 40.00 Operations Support 16,596 59.99 532.56 2,613.30 1,432.41 175.00 Staff Support 14,897 - 550.72 5,044.96 7,227.73 783.61 City Assistance 9,860 730.00 - 2,072.00 1,521.00 - Professional Services - - - - - - Operating Equipment4,162.83 4,162.83- - - - TOTAL HUMAN RESOURCES 27,606.02386,588 5,900.11 89,916.07 102,075.69 998.61 289,413.83 FINANCE Personnel Services429,810 33,180.36 - 127,963.50 139,616.54 - 290,193.46 Supplies3,600 463.83 - 1,148.68 1,265.72 28.97 2,305.31 Operations Support850 - - - 640.65 - Staff Support 15,805 375.00 - 1,830.00 988.67 - 14,816.33 Rental/Leasing 2,230 - - - - - Operating Equipment1,000266.47 266.47- - - TOTAL FINANCE453,29534,019.19266.47130,942.18142,778.0528.97 PURCHASING & ASSET MG T Personnel Services 241,940 16,350.57 72,357.84- 72,135.15 - 169,804.85 Supplies 800 66.01 - 20.30 119.70 6.63 Utility Services 750 - - 41.18 133.80 - Operations Support 850 - - 60.68 - 78.34 Staff Support 9,450 729.50 65.00 2,115.57 1,812.20 400.00 Operating Equipment7,500 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 17,146.08 65.00 74,595.57 81,791.67 484.97 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 11,520.47 - 51,317.62 55,642.73 - 162,237.27 Supplies109,600 8,826.89 2,927.39 28,764.30 49,110.43 11,516.35 51,900.61 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 238.58 - 877.86 789.00 - Operations Support 400 - - - 375.00- Staff Support 3,835 101.30 620.41 584.65 880.41 214.96 Maintenance Services 65,750 1,639.33 1,685.29 17,559.99 9,890.96 8,178.93 Rental/Lease200 -269.80 - - - Operating Equipment5,0001,467.72 -5,349.97 - - Capital Outlay -- - - - - TOTAL FLEET SERVICE411,36523,794.295,233.09100,604.42123,433.3020,285.24 TOTAL INTERNAL SERVICE 2,674,938 158,311.19 19,997.66 579,228.36 662,133.54 59,423.12 MISC & PROJECTS CITY ASSISTANCE - - 174.42 86.17 Utility Services - - Patient Assistance 5,000 - - 5,000.00 2,500.00 - Children's Advocacy Assistance 5,000 - - - - - Senior Citizen's Hot Meals42,00010,500.00 21,000.0021,000.00 - 21,000.00 TOTAL CITY ASSISTANCE52,00010,500.00 26,174.42-23,586.1721,000.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 10,500 - 26,174 23,586 21,000 TOTAL EXPENDITURES20,813,5271,433,456.97 134,270.01 5,786,228.46 6,018,808.75272,454.03 REVENUE OVER(UNDER) EXPEND.145,4283,842,079.35 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,4541,871,054.31 5,707,144.19- 6,082,062.23 - 802,391.77 000-411200Advalorem Tax - Delinquent 50,000 11,325.02 18,598.11- 30,899.04 - 19,100.96 000-411300Advalorem Tax - P&I 50,000 3,538.25 - 6,129.65 9,772.96 - 40,227.04 000-411500Sales Tax Revenue-Gen Fund4,784,071 415,822.14 708,273.32- 1,621,262.66 (2,369.81) 000-411600Bingo Tax 2,200 - - 981.20 - - 000-411700Mixed Beverage Ta6,746.1716,729.2413,776.24 x 33,000.00 - - TOTAL Taxes11,803,7252,308,485.89 6,457,855.71- 7,757,773.13 (2,369.81) Franchises 000-421200Center Point/Entex Energy 36,000 - 17,748.73- - - 36,000.00 000-421220City Public Service 330,000 - 55,622.15- 32,130.52 - 297,869.48 000-421240Guadalupe Valley Elec Co-op 440,000 93,299.47 - 93,299.47- - 346,700.53 000-421250New Braunfels Utilities 55,000 - - - - - 55,000.00 000-421300Time Warner-State Franchise 345,000 79,013.12 - 56.48 79,013.12 - 265,986.88 000-421350Time Warner-PEG Fee 65,000 - - 16,039.50- - 48,960.50 000-421460AT&T Franchise Fee 185,000 - - 610.74 - - 185,000.00 000-421465AT&T PEG Fees 26,000 - - 7,247.95 000-421480Other Telecom Franchise 35,000 50.82 - 511.49 13,255.14 - 21,744.86 000-421500Solid Waste Franchise Fee100,0008,540.9932,706.5132,282.21 - - TOTAL Franchises1,617,000180,904.40 107,256.10-273,267.91 - 1,343,732.09 Permits 000-431100Home Occupation Permit 500 105.00 - 210.00 175.00 - 000-431200Building Permit 727,042.83- 149,648.00 - 21,828.00 - (149,648.00) 000-431205Building Permit - Residential 600,000 - - - - - 600,000.00 000-431210Building Permit - Commercial 300,000 - - - - - 300,000.00 000-431300Mobile Home Permit 200 40.00 - 80.00 40.00 - 000-431400Signs Permit 1,700 55.00 - 210.00 275.00 - 000-431500Food Establishmnt Permit 30,000 50.00 10,995.00- 9,475.00 - 20,525.00 000-431600Garage Sale Permit 8,600 320.00 - 2,750.00 2,860.00 - 000-431700Plumbing Permit 80,000 6,328.00 25,842.50- 28,754.00 - 51,246.00 000-431750Electrical Permit 55,000 3,340.00 18,600.00- 13,340.00 - 41,660.00 000-431800Mechanical Permit 59,000 3,120.00 22,420.00- 15,300.00 - 43,700.00 000-431900Solicitor/Peddler Permit 60.00 - 170.00 250.00 - - 000-431950Animal/Pet Permit 2,000 115.00 - 1,130.00 710.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800550.00-1,900.002,700.00 - 000-432100Security Alarm Permit 42,000 3,815.00 12,561.00- 15,475.00 - 26,525.00 000-435000Fire Permit5,000325.00 2,125.002,737.50 - - TOTAL Permits1,187,80040,051.00 826,648.83-241,127.00 - 946,673.00 Licenses 000-441000Alcohol Beverage License 6,300 30.00 - 420.00 1,032.50 - 000-442000Contractors License 22,000 4,800.00 11,075.00- 10,135.00 - 11,865.00 000-444000Pet License3,000500.00 1,450.001,377.10 - - TOTAL Licenses 31,300 5,330.00 12,872.10- 12,617.50 - 18,682.50 Fees 000-451000Municipal Court Fines 1,665,009 88,740.50 318,873.16- 303,359.33 - 1,361,649.67 000-451100Arrest Fee 50,694 4,749.12 14,492.77- 16,272.53 - 34,421.47 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 11,763.00 33,324.76- 39,061.00 - 152,939.00 000-451210Court - Claims & Judgements 919.50 - - 1,842.23 - - (1,842.23) 000-451320Civil Justice Fee-Court 75 7.37 22.33 25.67 - 000-451321Civil Justice Fee-State 66.34 - - 231.76 - - 000-451340Judicial Fee - City 6,826 627.10 - 1,914.99 2,142.96 - 000-451400Traffic Fine Costs TTL 25,984 2,404.54 - 7,388.74 8,422.43 - 17,561.57 000-451500Teen Court Admin Fee 260 40.00 - 180.00 220.00 - 000-451510Juvenile Case Mgmt Fee 55,896 5,225.26 15,992.55- 17,867.21 - 38,028.79 000-451600Technology Fund Fee 45,601 4,170.16 12,755.81- 14,386.06 - 31,214.94 000-451700Security Fee 34,220 3,127.64 - 9,566.87 10,789.62 23,430.38 000-451800Time Payment Fee - City 7,336 422.40 - 1,789.12 1,696.81 - 000-451850State Fines 10% Service Fee 72,470 14,781.30 33,448.06- 28,248.02 - 44,221.98 000-451900DPS Payment - Local 11,858 904.83 - 2,880.23 3,115.60 - 000-452000Child Safety Fee 12,243 1,775.20 - 3,840.95 10,081.24 - 000-452050Indigent Defense Fee 21,655 2,074.10 - 6,196.64 6,931.63 - 14,723.37 000-452100Platting Fees 98,000 7,000.00 24,000.00- 17,000.00 - 81,000.00 000-452200Site Plan Fee 74,000 - - 7,500.00 6,000.00 - 68,000.00 000-452300Plan Check Fee 465,000 27,262.50 368,095.91- 94,318.50 - 370,681.50 000-452310Miscellaneous Review Fee 13,500 - - - 3,000.00 - 10,500.00 000-452320Tree Mitigation Admin Fee 10,500 780.00 - - 780.00 - 000-452400BOA/Zoning Fees 4,000 1,250.00 - 1,050.00 2,750.00 - 000-452500Food Handler Class 7,000 320.00 - 2,980.00 1,530.00 - 000-452520Fire Training Classes 400 - -- - - 13 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452600Specific Use/Zone Chng Fee -20,000 - - 12,350.00 - 000-452710Zoning Ltr & Dev Rights 1,500 750.00 - 225.00 1,050.00 - 000-453100Reinspection Fees 30,000 2,050.00 18,600.00- 12,825.00 - 17,175.00 000-453200Mowing Fees - Inspections 12,000 395.83 - 8,881.16 710.83 - 11,289.17 000-453211Admin Fee-Inspections 7,480 200.00 - 3,300.00 1,140.00 - 000-453310Misc Inspection Fee - - 35.00 19.49 - - 000-453500SubContractor Reg. Fee 17,000 4,150.00 - 7,345.00 8,280.00 - 000-453710Foster Care 500 - - 400.00 250.00 - 000-454100Swim Pool Reservation Fee - - 55.00 - - 000-454200Pool Gate Admission Fee 25,000 - - - - - 25,000.00 000-454300Seasonal Pool Pass Fee 5,500 - - - - - 000-456500Haz Mat Fees 800 - - - - - 000-456510Fire Plan Review 3,000 - - - - 000-456600Fire Re-inspection Fee 180 - - 450.00 250.00 - 000-458100Sale of Merchandise - - - - - - 000-458300Sale of Property/Auction 22,000 7,359.56 - 1,344.95 9,583.02 - 12,416.98 000-458400Civic Center Rental Fees 171,000 14,158.75 38,217.75- 33,000.25 - 137,999.75 000-458401Capital Recovery Fee-Civic Cntr 7,500 175.00 - 910.00 850.00 - 000-458450North Center Rental Fees 15,000 2,031.92 - 2,156.00 7,702.92 - 000-458500Community Center Rental Fees18,000 4,084.50 - 5,273.92 7,888.99 - 10,111.01 000-458550Pavilion Rental Fees 18,500 855.00 - 4,263.70 2,972.00 - 15,528.00 000-458560Chamber of Comm rent 11,700 1,950.00 - 3,900.00 3,900.00 - 000-458570Non-Resident SYSA League 12,000 3,660.00 - 7,060.00 13,490.00 - (1,490.00) 000-458600Ball Field Use - - 1.76 2,445.00 - - (2,445.00) 000-458650NonResident User Fee-BVYA 11,000 - - 2,820.00 2,670.00 - 000-458660BVYA Utility Reimbursement - -- 3,195.72 - - (3,195.72) 000-458680Tournament Fees-Soccer 15,000 4,600.00 - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee 250 - - 288.00 - - 000-459300Notary Fee 300 48.00 - 150.00 114.00 - 000-459400Maps, Copies, UDC, & Misc F 400 50.00 - 5.00 58.10 - 000-459600Animal Adoption Fee 15,000 1,028.00 - 3,770.00 4,242.50 - 10,757.50 000-459700Pet Impoundment Fee 15,000 1,284.00 - 6,555.01 4,765.25 - 10,234.75 000-459800Police Reports Fee6,500409.20 1,801.201,958.20 - - TOTAL Fees 3,341,727 227,650.62 986,603.34- 733,306.87 - 2,608,420.13 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,321.15 7,893.718,372.74(47.46) - TOTAL Fines30,0002,321.15-8,372.747,893.71(47.46) Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 5,269.44 - 7,025.92 7,025.92 - 14,051.08 000-473200City of Seguin - Fire Contract 40,263 3,355.26 13,421.04- 13,421.04 - 26,841.96 000-473300Guad Co - Library 180,000 15,901.33 60,272.00- 63,605.32 - 116,394.68 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,100.00 300.00 - 000-474200Library Services - Cibolo 20,000 - - - - - 20,000.00 000-474210Library Services-Selma 19,000 - - - - - 19,000.00 000-474400Dispatch Service - Cibolo 133,305 - 33,326.25- 33,326.25 - 99,978.75 000-474600School Crossing Guard-Bexar6,6002,695.61 2,004.0510,278.43 - - 000-474610School Cross Guard-Guadalupe -5,203.96 - - - - 000-474700School Officer Funding150,00050,000.00 50,000.00- - - TOTAL Inter-Jurisdictional571,24577,221.64 117,149.26-183,160.92 - 388,084.08 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 21,960.00- 29,280.00 - 58,560.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 42,555.25- 47,542.00 - 95,084.00 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 3,486.25 - 9,722.00 13,945.00 - 21,535.00 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 156,194.25- 293,740.68 - 587,481.32 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-487000Interfund Charges-Fleet 98,484 8,207.00 22,326.25- 32,828.00 - 65,656.00 000-488000Interfund Charges-4B 53,000 4,416.67 13,858.00- 17,666.68 - 35,333.32 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 -108,750.59 316,615.75 435,002.36 - 1,325,655.64 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned3,00041.84-1,285.1376.81 - 000-491200Investment Income 30,000 4,216.97 10,363.38- 14,347.47 - 15,652.53 267.25 - - 247.42 000-491800Gain/Loss - - 000-491900Unrealized Gain/Loss (9,968.60)- (9,300.80) - (2,141.75) - 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - - - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 21,608.00- 4,754.34 - 4,087.34 - (4,754.34) 000-493400Donation - Animal Control 1,200 964.99 - 2,049.26 1,559.01 - 000-493401Donations-A/C Microchip 500 155.00 - 835.00 675.00 - 000-493402Donations-Spay&Neuter 13,500 906.50 - 6,065.50 4,247.00 - 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed - - - - - - 000-494482DOJ-PD GRANT - - 2,893.77 - 2,893.77 - (2,893.77) 000-495040Friends of N. Schertz Park - - - 3,074.00 - - (3,074.00) 000-497000Misc Income-Gen Fund 81,000 2,941.39 (3,038.85)- 9,617.93 (8.90) 000-497005Misc Income-Publications 290,000 6,486.00 40,921.95- 55,414.00 - 234,586.00 000-497020Misc Income-Fleet Recycled - - - - - - 000-497100Misc Income-Police 25,000 641.14 13,411.63- 1,979.04 - 23,020.96 000-497200Misc Income-Library 19,000 337.05 - 989.30 1,377.54 - 17,622.46 000-497210Misc Income-Library Copier 13,500 627.80 3,360.75 4,255.06 - 000-497300Misc Income-Animal Control 500 - - 476.50 105.00 - 000-497400Misc Income-Streets Dept. 20,000 525.00 - 7,250.00 6,121.88 - 13,878.12 000-497500Misc Income-TML Insurance 78,000 - 49,731.90- - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 525.00 - 7,250.00 6,121.88 - 13,878.12 000-497600Misc Income-Parks/Vending Mach.2,500 94.21 -709.41 646.59 - 000-498000Reimbursmnt-Gen Fund5,000 33.0020,792.02 - - -(15,792.02) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA 569.87 - 2,157.39 569.87 - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 29,296.028,078.07 - - - TOTAL Miscellaneous 615,500 24,139.37 164,439.72- 216,738.70 398,770.20(8.90) TOTAL REVENUES20,958,9552,974,854.66 8,997,813.55- 9,860,888.10 (2,426.17) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking1,171,932.73$ Cash in Investment Pools LOGIC Investment-General Fund3,807,092.25 LOGIC Investment-Equip Replacement73,347.32 LOGIC Investment-Veh Replacement7,079.55 LOGIC Investment-Air Condi Replacment146,444.08 CAPITAL ONE Investment-General Fund1,336,040.02 Total Cash in Bank & Investment Pools$6,664,186.21 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 2011-12 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 2010-11 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 29,955 5,346 3,535 2009-10 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 2008-09 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 24,241 6,294 10,447 2007-08 18-A Sales Tax - General Fund $600,000 $500,000 40% 25% 17% $400,000 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 2011-12 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2010-11 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2009-10 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2008-09 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2007-08 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 306,696 382,743 298,203 2006-07 18-B CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 - - - 2011-12 83,433 62,692 67,561 95,887 2010-11 77,354 61,468 63,276 80,716 2009-10 77,308 53,071 57,506 83,329 2008-09 55,729 50,340 48,120 86,572 2007-08 18-C C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfers 62,100.00 - - - - - 62,100.00 Wilenchik Walk for Life 28,000.00 40.00 - - 40.00 - 27,960.00 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - - - - - 24,000.00 Miscellaneous175.0051.72- 748.45407.67 - TOTAL REVENUES114,275.00 91.72 - 407.67 788.45 - 113,486.55 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 14,250.00 148.24 12,622.63- 13,050.46 - 1,199.54 Employee Appreciation Event 5,000.00 - 126.00 - 4,950.0050.00 - 4th of July Jubilee 218.05 - 218.05 - - - National Night Out 100.00 - - - - - 100.00 Wilenchik Walk for Life 31,500.00 - - 160.00 - - 31,340.00 Blue Santa - - - - - - Schertz Fest - 455.91 - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 436.92 11,510.96- 2,983.16 33,516.84500.00 Hal Baldwin Scholarship11,000.001,000.00- -1,000.00 -10,000.00 Selma-Schertz 5K- -- - - - TOTAL CULTURAL 1,585.16103,600.00 218.05 24,715.50 17,411.67 550.00 85,856.38 TOTAL EXPENDITURES108,750.00 1,585.16 218.05 24,715.50 17,411.67 550.00 91,006.38 REVENUE OVER(UNDER) EXPEND5,525.00(16,623.22) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking10,231.02$ Cash in Investment Pools MBIA Special Events66,593.19 Total Cash in Bank & Investment Pools$76,824.21 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,000- 35,061.00-- 180,000.00- Fees14,164,2501,233,817.76 4,510,071.05-5,090,267.83 9,073,982.17- Fund Transfers484,6747,056.17 20,154.00-28,224.68 456,449.32- Miscellaneous12,424.8384,430.03189,966.96 103,260 - - TOTAL REVENUES14,932,1841,253,298.764,649,716.085,308,459.47 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers27,365.47 27,365.47- 27,366 - - TOTAL NON DEPARTMENTAL27,365 27,365.47- 27,366 - - BUSINESS OFFICE Personnel Services383,89425,617.71 135,380.46-110,079.50 273,814.50- Supplies5,400414.98418.331,160.011,404.52450.56 Human Services100----- Operations Support114,00012,991.00 19,271.90-33,838.896.43 Staff Support7,100138.2794.261,117.31404.741,056.40 Professional Services16,0001,384.76395.003,644.327,251.98- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300420.00-1,820.003,180.002,260.00 Operating Equipmen500.005,979.625,932.94 t 6,200 - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE40,966.721,407.59168,373.62162,092.573,773.39 603,994 W & S ADMINISTRATION Personnel Services1,184,89884,486.06 400,582.36-352,577.81 832,320.19- Supplies200,7005,744.294,458.8168,362.6521,902.891,989.80 Human Services1,000--64.00-40.00 City Support Services123,999894.11 34,116.32-34,329.5950.00 Utility Services2,634,344306,199.85 450,233.46-1,236,097.25 1,398,246.75- Operations Support8,750256.01-2,082.381,259.82- Staff Support33,0004,337.39294.547,986.096,229.771,754.89 City Assistance1,91230.00-236.00150.00- Professional Services187,40010,635.66 55,115.41-15,868.265,703.75 Fund Charges/Transfers2,623,507289,996.94 588,422.55-1,054,558.56 1,568,948.44- Maintenance Services5,507,250488,077.4812,287.431,422,378.551,536,713.45128,114.18 Other Costs35,000- 28,911.85-1,250.00 33,750.00- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353890.22 382,189.99-890.22 1,229,462.78- Rental-Leasing6,0702,087.38-662.532,516.68- Operating Equipment8,000--9,548.99-- Capital Outla82,000.0030,784.00 y 114,000 - -52,233.00 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,1831,193,635.3917,040.78 4,346,344.303,503,126.13 168,436.62 9,402,442.86 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-14,494.961,750.79 48,000.00- Maintenance Services22.35 - 334,500 - - - 14,517.311,750.79 TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -400,000.00 FM3009 RD&BRIDGE EXPANSION Professional Services 30,358.80-1,977.50 (1,977.50)- - 1,977.50 Maintenance Services 71,088.8729.03 71,088.87 - - - 73,066.37 TOTAL FM3009 RD&BRIDGE EXPANSION -73,066.37 -30,387.83 -(73,066.37) TOTAL MISC & PROJECTS73,066.371,750.79 74,817.1644,905.14 400,000 -326,933.63 TOTAL EXPENDITURES14,931,5431,335,03420,1993,716,4054,610,620172,210 ** REVENUE OVER(UNDER)EXPENSES **697,839.97 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 35,061.00 - 000-421490Tower Leasing180,000 - - - TOTAL Franchises 180,000 - 35,061.00- - - 180,000.00 Fees 000-455200Garbage Collection Fee 3,400,000 289,123.24 1,078,438.98- 1,173,971.14 - 2,226,028.86 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,376.80 64,526.41- 83,974.16 - 157,025.84 000-455800W&S Line Constructn Reimbursemnt50,000 1,356.07 12,603.79- 8,536.15 - 41,463.85 000-457100Sale of Water 7,210,000 646,280.14 2,228,435.60- 2,644,480.28 - 4,565,519.72 000-457110Edwards Water Lease 166,250 - 132,707.46- 14,800.60 - 151,449.40 000-457120Water Transfer Charge-Selma 5,000 12,281.12 - 13,657.95- - (8,657.95) 000-457130Water Transfer Charge-U. C. 1,000 - - - 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 1,331.35 32,883.71- 14,483.35 - 75,516.65 000-457400Sewer Charges 2,800,000 247,787.93 882,362.62- 1,050,088.76 - 1,749,911.24 000-457500Water Penalties 180,000 14,861.11 58,843.19- 63,155.47 - 116,844.53 000-459200NSF Check Fee-Water&Sewer2,000420.00839.291,230.00 - - TOTAL Fees14,164,2501,233,817.76 4,510,071.05-5,090,267.83 - 9,073,982.17 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1720,154.00 28,224.68 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 20,154.00- 28,224.68 - 456,449.32 Miscellaneous 000-490000Misc Charges 10,000 46.00 - 4,431.88 73.05 - 000-491000Interest Earned 1,000 163.09 - 1,028.08 685.63 - 000-491200Investment Income 6,000 12,222.00 - 5,850.82 5,533.45 - 000-493400Donations-Christmas Activitise - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - - 134,500.00- - - (134,500.00) 000-497000Misc Income-W&S (6.26) 14,094.16- 22,725.53 - - (22,725.53) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 50,615.45- 25,699.30 - 50,615.70 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 12,424.83 84,430.03- 189,966.96 - (86,706.96) TOTAL REVENUES14,932,1841,253,298.76 4,649,716.08- 5,308,459.47 - 9,623,724.53 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking231,703.94$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,358,603.73 Lone Star Investment-W&S Customer Deposits293,859.19 Lone Star Investment-W&S Equip Replacement373,315.13 Lone Star Investment-W&S Veh Replacement544,338.08 Lone Star Investment-Water/SSLGC SAWS269,343.97 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,895,368.72 Total Cash in Bank & Investment Pools4,127,072.66$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 430,082.00 1,086,401.37- 1,134,407.70 2,954,525.30- Inter-Jurisdictional1,438,836 316,015.50 619,934.39- 673,848.63 - 764,987.37 Miscellaneous24,156.94-62,139.3850,450.28 256,000 - TOTAL REVENUES 770,254.44 - 1,768,475.14 1,858,706.61 - 3,925,062.39 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891210,907.4168.00868,255.45846,936.33 1,740,011.6711.00 Supplies 35,781.20 13,149.22 104,442.61 124,455.84 44,709.89 324,039 Human Services - 446.00 - 800 - - City Support Services 10,902.09- 10,277.40 31,505 - - 21,227.60 Utility Services 17,899.97 10.41 23,950.58 37,868.14 74,627.2715.00 112,500 Operations Support 2,004.78 364.65 26,028.89 27,930.25 18,015.6518.75 45,600 Staff Support 7,023.69 449.08 21,315.97 20,462.38 8,260.96 72,400 City Assistance 648.00 - 3,016.00 1,885.00 862.50 9,000 Professional Services 6,445.47 133.00 38,535.85 41,628.85 9,774.37 164,200 Fund Charges/Transfers2,084,785 10,196.57 389,978.36- 261,793.37 - 1,822,991.63 Maintenance Services 12,141.40- 6,208.00 19,187.52 37,700 - Debt Service 5,863.00 69,799.33- 5,863.00 111,176 - 105,313.00 Rental-Leasing - 836.33 - 20,000.00 20,000 - - Operating Equipment 322.80 820.75 4,577.32 36,379.51 5,278.99 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 297,092.89 14,995.11 1,574,226.18 1,421,688.07 88,118.98 4,218,784.06 5,713,596 TOTAL EXPENDITURE297,092.8914,995.111,574,226.181,421,688.07 S 5,713,596 88,118.98 ** REVENUE OVER(UNDER) EXPENSES 437,018.54 * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 427,402.00 - 1,070,581.37 1,118,332.70 - 2,700,400.30 29.29% 000-456110Subscription Program Fees55,000 2,680.00 - 15,820.00 16,075.00 29.23% -38,925.00 000-456120EMT Class - Fees95,200 - - - - -95,200.00 000-459200Paramedic Class Fees 120,000 - - - - -120,000.00 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933430,082.00 1,086,401.37- 1,134,407.70 2,954,525.30- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,844.04 - 96,475.41 95,376.16 33.33% -190,749.84 000-474300Cibolo Support222,018 55,524.98 - 106,650.00 111,049.96 50.02% -110,968.04 000-475100Comal Co ESD #682,875 20,726.48 - 666.56 39,686.48 47.89% -43,188.52 000-475200Live Oak Support148,125 40,082.38 - 74,062.50 80,164.76 54.12% -67,960.24 000-475300Universal City Support226,168 57,412.83 - 102,206.26 113,975.66 50.39% -112,192.34 000-475400Selma Support67,618 16,910.85 - 34,365.00 33,821.70 50.02% -33,796.30 000-475500Schertz Support384,046 96,046.91 - 193,729.74 192,093.82 50.02% -191,952.18 000-475600Santa Clara Support8,849 2,213.06 - 5,267.34 4,426.12 50.02% -4,422.88 000-475800Marion Support13,0113,253.976,511.583,253.97 - - TOTAL Inter-Jurisdictional1,438,836316,015.50 619,934.39- 673,848.63 -764,987.37 Miscellaneous 000-491000Interest Earned - - - 0.00% - - - 000-491200Investment Income 53.06 - 243.28 173.31 - - 000-493203Donations-EMS 6,000 250.00 - 1,100.00 475.00 -5,525.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - - 0.00% - - - 000-497000Misc Income 150,000 12,677.88 32,236.10- 25,010.97 -124,989.03 000-497100Recovery of Bad Debt 100,000 875.00 - 6,350.00 890.00 -99,110.00 000-497500Misc Income-EMT Classes22,210.0023,901.00 - 10,301.00 - - TOTAL Miscellaneous256,00024,156.94 62,139.38-50,450.28 -205,549.72 TOTAL REVENUES5,783,769770,254.44 1,768,475.14- 1,858,706.61 3,925,062.39- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank $ (380,760.80) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010300,921.04 $(79,839.76) 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: JANUARY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60061,688.18 236,004.77- 253,899.70 -455,700.30 Fund Transfers - - - - - - - 0.00% Miscellaneous900470.07300.76 86.53 - - TOTAL REVENUES 61,774.71710,500236,474.84 -254,200.46456,299.54 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40423,369.92 119,499.33- 106,743.22 -267,660.78 Supplies 8,300 184.48 - 326.87 549.10 183.10 Human Services 325 - - - - -325.00 City Support Services 32,563 - 1,832.18 1,508.72 - -31,054.28 Utility Services 14,688 2,609.45 - 3,130.59 6,391.62 -8,296.38 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 100.74 43.02 1,016.92 615.94 134.67 City Assistance 840 - 15.00 57.00 - -783.00 Professional Services 19,800 5,250.00 - - 5,250.00 1,286.25 Fund Charges/Transfers 199,87611,785.92 32,662.25- 47,143.68 -152,732.32 Maintenance Services 22,000 - 1,987.00 - - -22,000.00 Other costs 100 - 100.00 100.00- - - 100.00% Debt Service 17,564 1,632.07 - 1,918.78 1,632.07 15,931.93 - Rental/Leasing500-- - - -500.00 Operating Equipment-- - - - - - TOTAL DRAINAGE 44,932.58701,72543.02162,488.92 1,704.02169,891.35530,172.65 TOTAL EXPENDITURE 44,932.58701,72543.02162,488.92 1,704.02169,891.35530,172.65 S ** REVENUE OVER(UNDER) EXPEND8,77584,309.11 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 1,484.69 1,771.17 4,000 517.56 -2,228.83 000-457600Drainage Fee 61,170.62-234,520.08252,128.53 -453,471.47 705,600 TOTAL Fees61,688.18 236,004.77-253,899.70 455,700.30- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 130.40 26.03 100 8.73 - 000-491200Investment Interest - 238.09 253.94 600 73.18 -346.06 000-497000Misc Income-Drainage-101.5820.79 200 4.62 - TOTAL Miscellaneous - 470.07 300.76 900 86.53 -599.24 TOTAL REVENUES61,774.71 236,474.84- 254,200.46 456,299.54- 710,500 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 153,704.78 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,334.58 Total Cash in Bank & Investment Pools$437,039.36 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 31,325.54 55,410.96- 88,110.33 -302,643.67 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50021.27-175.6884.62 - TOTAL REVENUES 31,346.81411,386-55,586.6488,194.95323,191.05 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 - 231.08 - -2,481.92 City Support Services 15,407.0085,948 29,616.85- 36,657.00 -49,291.00 Operations Support 74,000 346.04 3,734.38 7,587.29 - -66,758.75 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 42,555.25- 47,542.00 -146,334.00 Operating Equipment 52,562 14,809.98- 1,000.00 - 6,645.00 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 27,292.50411,3867,204.0475,906.48106,827.35310,762.69 L 1,000.00 TOTAL EXPENDITURE 27,292.50411,3867,204.0475,906.48106,827.35310,762.69 S 1,000.00 (18,632.40) REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 31,325.5455,410.9688,110.33 -302,643.67 - TOTAL Taxes 390,754 31,325.54 55,410.96- 88,110.33 - 302,643.67 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned30011.61-123.5039.96 - 260.04 000-491200Investment Interest 200 9.66 - 52.18 44.66 - 155.34 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50021.27-175.6884.62 - 415.38 TOTAL REVENUES 411,386 31,346.81 55,586.64- 88,194.95 - 323,191.05 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking207,214.72$ Cash in Investment Pools Federated Investment-Hotel/Motel78,170.70 Total Cash in Bank & Investment Pools$285,385.42 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 2011-12 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2010-11 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2009-10 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 2008-09 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 26,866 30,247 26,313 2007-08 34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 - 52,575.00- - -197,425.00 Tree Mitigation Fees 75,000 - - 4,420.00 4,420.00 -70,580.00 Miscellaneous600-281.05225.12 50.90 - TOTAL REVENUES 4,470.90325,600-281.0557,220.12268,379.88 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 - - - - -3,500.00 Operating Equipment 32,000 35,468.60- 5,872.20 5,046.20 3,192.20 Capital Outlay169,000 31,658.35--81,939.45 - TOTAL PARKLAND DEDICATION 34,850.55217,500-35,468.6087,811.65124,642.15 5,046.20 TREE MITIGATION Maintenance Services-Trees28,500 17,976.00- 390.00 - -28,110.00 Capital Outlay -18,000--19,900.00 - TOTAL TREE MITIGATION -46,500-17,976.0020,290.00 - TOTAL EXPENDITURE 34,850.55264,000-53,444.60108,101.65150,852.15 S 5,046.20 REVENUE OVER(UNDER) EXPEND (50,881.53)61,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 - 52,575.00- 197,425.00- - 000-458900Tree Mitigation 4,420.0075,000- -4,420.00 - TOTAL Fees 325,000 4,420.00 -- 56,995.00 - 268,005.00 Miscellaneous 000-491000Interest Earned 100 - 126.51 6.78 93.22- - 000-491200Investment Interest 500 50.90 - 154.54 218.34 281.66- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60050.90-281.05225.12 374.88- TOTAL REVENUES 325,600 4,470.90 - 281.05 57,220.12 268,379.88- 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$21,724.13 Cash in Investment Pools Federated Investment-Park Fund192,831.68 Federated Investment-Tree Mitigation126,311.81 Total in Investment Pool 319,143.49 Total Cash in Bank & Investment Pools$340,867.62 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer 27,365.4727,366--27,365.47 - 0.53 TOTAL REVENUES 27,365.4727,366--27,365.47 - - EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor--- - - - - TOTAL NONDEPARTMENTA--- L - - - - TOTAL EXPENDITURE--- S - - - - REVENUE OVER(UNDER) EXPEND 27,365.4727,36627,365.47 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S 27,365.4727,366--27,365.47 - 0.53 TOTAL Fund Transfers 27,365.4727,366- 27,365.47- - 0.53100.00% TOTAL REVENUES 27,366 - - 27,365 27,365 - 1100.00% 39 RECYCLE FUND CASH IN BANK AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking - 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: JANUARY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 (45,820.96) 931,184.51- 317,290.04 -2,408,109.96 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 222,612.6883,491.31225,628.99 - - TOTAL REVENUES13,713,000 176,791.721,014,675.82542,919.0313,170,080.97 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 354.07 - 1,059.16 1,415.66 292.50 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - 0.00% - - Debt Service - 108,671.00- - 108,671.00 -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000 109,025.079,487.16110,195.16 L - 292.50 MISC & PROJECTS Projects13,025,000 35,663.25-53,183.3610,488.42 -13,050,174.83-0.19% Schaefer RD Water Improvements 599,643-- - - -599,643.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant-- 0.00% - - - - Town Creek Project-- 0.00% - - - - Live Oak Water Plant- 0.00% - - -204,243.74 - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP239,284.45- A - - - - TOTAL MISC & PROJECTS13,624,643 -35,663.25496,711.5510,488.4213,649,817.83 - TOTAL EXPENDITURE13,662,643 109,025.0735,663.25506,198.71120,683.5813,577,330.17 S 292.50 REVENUE OVER(UNDER) EXPENDITURES50,357 422,235 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 (9,864.00) 621,619.34- 243,591.00 -1,236,009.00 000-455910Capital Recovery - Waste Wtr613,800 (43,156.96) 308,965.17- 66,499.04 -547,300.96 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 7,200.00600.007,200.00 - - TOTAL Fees 2,725,400 -(45,820.96) 931,184.51 317,290.04 11.64% -2,408,109.96 Fund Transfers 000-481000Transfer from Reserves10,673,600 - - - - 0.00% -10,673,600.00 000-486202Transfer in-Water -- - - - - -- 000-486406Transfer in-Public Improvement - - - - TOTAL Fund Transfers10,673,600---- 0.00% -10,673,600.00 Miscellaneous 000-491000Interest Earned50030.70-210.1188.43 - 000-491200Investment Income 30,000 4,019.30 12,014.17- 15,535.03 -14,464.97 000-491800Gain/Loss - - (768.78) - 243.38 - 000-491900Unrealized Gain/Loss-Cap One (12,107.97)- (9,225.69) - (1,680.70) -9,225.69 000-497000Misc Income - - - 0.00% - - - 000-498000Reimbursmnt - 220,000.00 - 220,000.00- -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 12,500.00- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -70,875.00- - - TOTAL Miscellaneous 314,000222,612.68 83,491.31- 225,628.99 -88,371.01 TOTAL REVENUES13,713,000176,791.72 1,014,675.82- 542,919.03 3.96% -13,170,080.97 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking614,817.14$ Cash in Investments: Lone Star Investment-Capital Recovery Water452,977.23 Lone Star Investment-Capital Recovery Sewer280,613.58 Capital One-Investment1,711,566.54 Schertz Bank & Trust-Certificate of Deposit525,586.08 Total Cash in Bank & Investment Pools$3,585,560.57 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 1,163,224.214,281,098 - 2,872,784.94 3,778,878.27 88.27% -502,219.73 - - - - 0.00% Fund Transfers - - Miscellaneous 2,551.412,25014,785.108,163.80 - - TOTAL REVENUES 1,165,775.624,283,3482,887,570.04 -3,787,042.07496,305.93 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL 400.00 - 36,210.39- Professional Services - -(36,210.39) Debt Service 1,915,513.894,276,6672,883,831.23 -1,915,513.892,324,942.22 - TOTAL GENERAL GOVERNMEN 1,915,913.894,276,6672,883,831.23 -1,951,724.282,324,942.22 T - TOTAL EXPENDITURE 1,915,913.894,276,6672,883,831.23 -1,951,724.282,324,942.22 S - ** REVENUE OVER(UNDER) EXPEND6,682 1,835,317.79 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 1,163,224.212,872,784.943,778,878.27 - - TOTAL Taxes4,281,0981,163,224.21 2,872,784.94-3,778,878.27 - 502,219.73 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 8.17 14,409.41- 27.87 - 000-491200Investment Earnings1,5002,543.24375.69 8,135.93 - - TOTAL Miscellaneous 2,250 2,551.41 14,785.10- 8,163.80 - (5,913.80) TOTAL REVENUES4,283,3481,165,775.62 2,887,570.04- 3,787,042.07 - 496,305.93 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent400.00 -400.00 - - - 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services400--36,210 - -(36,210.39) Debt Service 101-555612Bond-GO Refunding 2010-Principal -240,000 - 285,000.00 - -240,000.00 101-555612.1Bond-GO Refunding 2010 Interest82,650 - - 37,977.08 - -82,650.00 101-555622Schertz C O SR2003-Principal200,000 - - 190,000.00 - -200,000.00 101-555622.1Schertz C O SR2003-Interest53,800 - - 32,120.00 - -53,800.00 101-555624Comm Proj Bond-SR04-Principal315,000 - - 325,000.00 - -315,000.00 101-555624.1Comm Proj Bond SR04-Interest251,009 - - 136,058.76 - -251,009.00 101-555626LS&D SR2006-Principal100,000 100,000.00 - - 100,000.00 - 101-555626.1LS&D SR2006-Interest 648,982 325,490.64 650,981.28- 325,490.64 -323,491.36 101-555628CO Bond 2007-Principal 102,900 - - 142.58 - -102,900.00 101-555628.1CO Bond 2007-Interest 22,625 10,864.43 13,308.53- 10,864.43 -11,760.57 101-555629GO Bond 2007-Principal 225,000 225,000.00 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 101,750.00 107,346.25- 101,750.00 -97,172.00 101-555630GO Bond SR2008 Principal 370,000 370,000.00 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 186,159.75 193,490.50- 186,159.75 -178,519.25 101-555631GO Bond SR2009 Principal 200,000 - 140,000.00- - -200,000.00 101-555631.1BO Bond SR2009 Interest 278,813- - -142,406.25 -278,812.50 101-555633GO SR2011 Principal 532,28790,000.00 90,000.00- - -442,287.00 101-555633.1GO SR2011 Interest90,000346,167.71 346,167.71- - -(256,167.71) 101-555634GO SR2011A Refund Principal 140,000.00- -140,000.00 - -(140,000.00) 20,081.36 20,081.36- 101-555634.1GO SR2011A Refund Interest - - - TOTAL Debt Service4,276,6671,915,513.89 2,883,831.23-1,915,513.89 -2,361,152.61 TOTAL EXPENDITURES4,276,6671,915,913.89 2,883,831.23- 1,951,724.28 -2,324,942.22 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking690,390.56$ Cash in Investment Pools MBIA Investment- Tax I&S1,237,870.53 Federated Investment-Tax I&S56.83 Total Cash in Bank & Investment Pools$1,928,317.92 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET33.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042207,911.07 354,136.64- 810,631.36 - 1,581,410.64 Fund Transfers - - - 0.00% - - - Miscellaneous (204.98)17,2004,555.49910.34 - - ,,,.,. -,., TOTALREVENUES24092422077060935869213811541701597 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 3,470.43 579.81 7,855.73 11,169.94 2,832.66 Utility Service 87,500 9,728.15 13,736.16- 21,042.35 - 66,457.65 Maintenance Services 72,300 4,364.81 632.25 28,454.23 23,372.72 2,158.44 47,401.09 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 17,563.39180,8001,212.0657,045.43 4,991.1055,585.01121,435.95 L ECONOMIC DEVELOPMEN T Personnel Services 241,233 12,364.04 48,997.05- 64,274.43 - 176,958.57 Supplies 1,100 50.02 - 509.32 230.55 62.88 Human Services 200 - - - - - City Support Services 42,772 945.05 1,363.42 4,752.74 7,698.29 332.06 Utility Services 7,200 92.34 - 913.71 438.97 - 6,761.03 Operations Support 63,600 256.45 4,813.35 20,527.45 10,149.05 259.21 Staff Support 112,800 1,821.56 937.31 59,226.29 59,590.02 3,265.81 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 926.25 30,935.60 67,141.17 47,962.75 11,895.00 274,577.85 Fund Charges/Transfers 105,985 4,665.42 63,585.00- 18,661.68 - 87,323.32 Fund Replenish-Fund Balance - - - 0.00% - - - Maintenance Services - - - 0.00% - - - Debt Service 795,154275,195.75 606,911.25- 275,195.75 519,958.25 - Operating Equipment -2,350-- - - TOTAL ECONO DEVELOPMEN 296,316.881,975,89438,049.68872,563.98 15,814.96494,201.491,503,927.23 T TOTAL EXPENDITURE 313,880.272,156,69439,261.74929,609.41 20,806.06549,786.501,625,363.18 S ** REVENUE OVER(UNDER) EXPEND252,548 261,755.20 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: JANUARY 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET33.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042207,911.07354,136.64810,631.36 - - TOTAL Taxes2,392,042207,911.07 354,136.64- 810,631.36 -1,581,410.64 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 14.21 - 33.17 78.73 - 000-491200Investment Earnings 15,000 280.81 - 4,215.02 3,021.43 -11,978.57 000-497000Misc Income 2,000 (500.00) - 307.30 (2,189.82) -4,189.82 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 (204.98) - 4,555.49 910.34 - TOTAL REVENUES2,409,242207,706.09 358,692.13-811,541.70 -1,597,700.30 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: JANUARY 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking413,616.79$ Cash in Investment Pools MBIA Investment-Economic Development Corp1,266,450.00 Schertz Bank & Trust-Certificate of Deposit507,004.98 Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investment Pools3,222,547.23$ 50 4B SALES TAX $300,000 40% $250,000 17% 25% -2% $200,000 $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 164,073 180,483 169,043 2007-08 51 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING JANUARY 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust4,151,224.79,866,956.82.0500,306,839.21,022,571.24,151,224.79,151,224.79 208744 TOTAL OPERATIONS4,151,224.79,866,956.82,306,839.21,022,571.24,151,224.79,151,224.79 28744 LOGIC General Fund3,807,092.25,906,445.51.2513 -00,646.74,807,092.25 N/A,807,092.25 20933 G/F-Equipment Replacement73,347.3273,331.670.2513 -15.6573,347.32 N/A73,347.32 G/F-Vehicle Replacement7,079.55,078.04.2513 -.51,079.55 N/A,079.55 70177 G/F-Air Conditioner Replacement146,444.08146,412.830.2513 -31.25146,444.08 N/A146,444.08 ,861,949.74.251393.380,000.00,792,343.12,792,343.12 SR2009 Bond-Street Projects(II)1,792,343.12 103711 TOTAL LOGIC5,826,306.32,995,217.7901,088.530,000.00,826,306.32,826,306.32 49755 LONESTA R Capital Recovery - Sewer280,613.58280,541.100.3100 -72.48280,613.58 N/A280,613.58 Capital Recovery - Water452,977.2352,860.24.3100 -16.9952,977.23 N/A52,977.23 40144 Drainage Fund283,334.58283,261.400.3100 -73.18283,334.58 N/A283,334.58 GO SR2011 Animal Shelter2,252,022.93,251,441.29.3100 -81.64,252,022.93 N/A,252,022.93 20522 GO SR2011 Athletic Fields1,480,900.291,480,517.810.3100 -382.481,480,900.29 N/A1,480,900.29 GO SR2011 Soccer Fields1,441,330.65,440,958.39.3100 -72.26,441,330.65 N/A,441,330.65 10311 GO SR2011 Swimming Pool2,937,995.752,937,236.940.3100 -758.812,937,995.75 N/A2,937,995.75 W/S-Customer Deposits293,859.1993,783.29.3100 -5.9093,859.19 N/A93,859.19 20722 W/S-Equipment Repl/Cap.Imp373,315.13373,218.710.3100 -96.42373,315.13 N/A373,315.13 Water&Sewer1,358,603.73,358,252.83.3100 -50.90,358,603.73 N/A,358,603.73 10311 W/S-Vehicle Replacement544,338.08544,197.490.3100 -140.59544,338.08 N/A544,338.08 69,274.40.31009.57-69,343.9769,343.97 Water/SSLG - SAWS269,343.97 20622 TOTAL LONESTA11,968,635.111,965,543.89 -,091.221,968,635.111,968,635.11 R1311 MBIA Tax I&S1,237,870.532,637,422.490.2100448.041,400,000.001,237,870.53 N/A1,237,870.53 Police Forfeiture359,322.0259,258.64.2100 -3.3859,322.02 N/A59,322.02 30633 Economic Development Corporation1,266,450.541,616,169.730.2100280.81350,000.001,266,450.54 N/A1,266,450.54 Special Events Fund66,593.196,581.47.2100 -1.726,593.19 N/A6,593.19 60166 EMS Tax Notes 2010300,921.0400,867.98.21003.06-00,921.0400,921.04 30533 TOTAL MBIA3,231,157.324,980,300.31857.011,750,000.003,231,157.323,231,157.32 FEDERATED SR2007a Bond-City Wide Projects868,214.0868,106.82.1449 -07.2668,214.08 N/A68,214.08 80188 Hotel Occupancy Tax78,170.7078,161.040.1449 -9.6678,170.70 N/A78,170.70 Park Fund (Developers Fee)192,831.6852,803.61.144952,843.5812,815.5192,831.68 N/A92,831.68 202311 Park Fund (Tree Mitigation)126,311.81126,288.980.2100 -22.83126,311.81 N/A126,311.81 Tax I&S56.836.82.2100 -.016.83 N/A6.83 50055 Library Board Fund44,706.154,700.63.1449.52-4,706.154,706.15 40544 TOTAL FEDERATED1,310,291.251,370,117.90252,988.86312,815.511,310,291.251,310,291.25 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,254,062.41,322,246.93.2000 831.3898.88,322,314.43 N/A,336,040.02 13811 Capital One Capital Recovery1,614,217.00,729,861.66.970094.80909.27,729,347.19,711,566.54 12311 TOTAL CAPITAL ONE2,868,279.413,052,108.591,293.681,740.653,051,661.623,047,606.56 52 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS 10% TOTAL CAPITAL ONE 13% 9% TOTAL FEDERATED TOTAL LOGIC 4% 18% TOTAL MBIA 10% TOTAL LONESTAR 36% 54 City Portfolio By Use Pooled-Daily Operations, Designated Funds, $4,151,224.79 $9,326,270.74 $11,042,150.79 Special Revenue Funds, Debt Service Fund, $6,722,295.66 $1,237,927.36 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.0400 1 Month T-Bill 0.01000.01000.02000.0600 3 Month T-Bill 0.06000.06000.06000.0800 6 Month T-Bill 0.46000.52000.49000.5000 Schertz Portfolio 0.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.4000 CD 365 Days 0.80000.80000.30000.3000 CD 180 Days 0.25000.25000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.2513 LOGIC 0.23000.25000.28000.3100 LoneStar 0.14000.15000.19000.2100 MBIA 0.09000.14000.13000.1500 Federated 2.32432.84002.83003.0700 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:1/31/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt Cl III #69124,062.4124,062.4124,062.412.000.01 General Elec Cap Corp Disc Com Paper3/12/201241.0065,000.0064,891.2264,891.220.000.00 JPMorgan Chase Disc Bank Accpt Note3/1/201230.0065,000.0064,941.4564,941.45 Total Cash & Equivalent54,062.41153,895.053,895.0 s1818 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014925.00125,000.00141,987.30141,011.256,875.00 Federal Home Loan Bks Cons Bds6/21/2013507.0080,000.0082,004.4081,785.601,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151415.00100,000.00116,185.00115,684.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012260.00150,000.00162,031.50154,564.506,750.00 Federal Home Ln Mtg Corp Deb11/15/2013654.00170,000.00191,084.25183,804.008,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013602.00250,000.00250,000.00266,707.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141029.00100,000.0099,874.40100,617.00750.00 Federal Natl Mtg Assn 4/20/201280.00125,000.00125,252.50125,496.25 Total Fixed Income1,100,000.001,168,419.351,169,670.104 Total Assets584.061,254,062.411,322,314.431,323,565.184 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCost/unitMrk Value/unit Fidelity Inst Prime Mmkt CL III #69134,217.0034,217.0034,217.003.000.01 General Elec Cap Corp Disc Coml Paper3/12/201241.0085,000.0084,857.7484,857.740.000.00 84,923.4384,923.43 JPMorgan Chase Disc Bank Accpt Note3/1/201230.0085,000.00 Total Cash & Equivalent04,217.0203,998.103,998.1 s20727 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014925.00165,000.00187,423.24186,134.859,075.00 Federal Home Loan Bks Cons Bds6/21/2013507.00100,000.00102,505.50102,232.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151415.00100,000.00116,185.00115,684.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012260.00250,000.00270,052.50257,607.5011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013654.00250,000.00281,006.25270,300.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013623.00200,000.00223,001.60214,682.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/20141029.00220,000.00220,078.68221,357.401,650.00 0/30/201273.0025,000.00125,096.2525,331.25 Federal Natl Mtg Ass n1211 Total Fixed Incom,410,000.01,525,349.0,493,329.0 e102105 Total Assets606.761,614,217.001,729,347.191,697,327.175