Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
06-MARCH 2012 FINANCIAL STATEMENT
MARCH 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department May 7, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725507,277.90 8,176,290.36-9,218,812.40 - 2,584,912.60 Franchises 1,617,000 139,918.04 440,138.07- 741,292.76 - 875,707.24 Permits 1,187,800 175,099.75 1,059,160.83- 548,526.75 - 639,273.25 Licenses 48,300 5,895.00 34,083.10- 35,087.50 - 13,212.50 Fees 3,324,727 256,693.77 1,446,570.31- 1,241,695.22 (100.00) Fines 30,000 2,871.92 12,788.62- 13,263.61 (15.99) Inter-Jurisdictional 571,245 22,439.08 192,993.25- 306,788.45 - 264,456.55 Fund Transfers 1,760,658 108,750.59 608,603.55- 653,503.54 - 1,107,154.46 Miscellaneous615,50097,667.48194,932.97314,781.41(1,008.90) - TOTAL REVENUES20,958,9551,316,613.5312,165,561.0613,073,751.64(1,124.89) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 2,720.19 - 10,838.34 11,484.91 - 11,315.09 Supplies500 79.68 - 120.03 269.61 17.45 212.94 City Support Services17,500 - 219.98 12,932.87 916.86 211.75 16,591.37 Utility Services2,837 271.98 - - 1,193.79 - Operations Support 300 - - - - - Staff Support17,563784.142,150.00 9,971.8515,714.291,027.80 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 3,855.99 2,369.98 33,863.09 29,579.46 1,257.00 CITY MANAGE R Personnel Services836,40093,057.02 336,287.49-383,007.84 - 453,392.16 Supplies5,331 266.42 268.94 671.07 2,502.37 - City Support Services - - - - - - Operations Support - - - - - - Staff Support 25,550 1,537.37 1,527.05 13,938.93 15,519.60 2,488.76 Operating Equipment -1,393.36 - - - - TOTAL CITY MANAGER 867,281 94,860.81 352,290.851,795.99 401,029.81 2,488.76 465,558.42 1 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 27,587.57 - 113,387.90 127,341.10 - 129,771.90 Supplies2,500 43.30 99.00 644.76 875.31 216.63 1,507.06 City Support Services1,000 - - - - - Operations Support 3,000 - 700.00 1,166.00 1,558.00 474.00 Staff Support 5,500 69.72 285.20 1,337.04 1,484.45 486.59 Court Support 800 - - - - - Professional Services 71,100 5,591.25 25,200.00- 27,591.25 15,426.25 Maintenance Services 2,200 100.00 - 350.00 349.94 - Operating Equipment1,000150.00497.14 997.14500.0042.13 TOTAL MUNICIPAL COURT 33,541.84344,213 1,581.34 142,585.70 160,197.19 16,645.60 168,951.55 CUSTOMER RELATIONS-311 Personnel Services109,618 11,620.26 - 38,855.75 47,851.31 - 61,766.69 Supplies300 77.21 - 49.84 121.96 24.64 153.40 Staff Support1,100 250.00 -250.00361.20 - Operating Equipment50071.00 263.00- - - TOTAL CUSTOMER RELATIONS-311 111,518 12,018.47 38,905.59- 48,486.27 385.84 PLANNING & ZONING Personnel Services 139,925 15,033.46 61,528.60- 68,564.43 - 71,360.57 Supplies 2,700 60.00 156.45 117.04 746.04 - Operations Support 750 - - 77.95 - - Staff Support 17,150 - 548.55 3,232.12 1,720.85 81.56 Professional Services 76,650 6,634.55 1,366.40 47,988.68 19,778.83 - 58,237.57 Operating Equipment3,5002,112.00 2,112.001,055.00 - - TOTAL PLANNING & ZONING240,67523,840.012,071.40113,999.3992,922.1581.56 LEGAL SERVICES Operations Support 13,000 - - 8,117.96 - - 13,000.00 Professional Services245,00046,023.79 189,944.0964,688.43 - - TOTAL LEGAL SERVICES 258,000 46,023.79 72,806.39- 189,944.09 - 68,055.91 2 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services648,323 63,803.32 - 297,375.87 290,933.39 - 357,389.61 Supplies57,100 5,562.76 1,224.76 35,294.90 33,168.80 6,222.26 18,933.70 Utility Services111,000 7,597.14 - 34,653.34 39,005.29 - 71,994.71 - - - - Operations Support - - Staff Support 11,179 810.91 41.35 6,279.14 6,140.46 361.23 Maintenance Services 106,450 5,862.14 673.05 72,396.43 45,060.10 3,904.67 Rental/Leasing 1,400 - - 763.92 157.99- Operating Equipment2,5001,702.33 289.451,702.33778.24 - Capital Outlay24,500 -- - - - TOTAL FACILITIES MAINTENANCE 962,452 85,338.60 1,939.16 447,053.05 416,010.37 11,424.39 CITY SECRETAR Y Personnel Services 164,529 18,388.93 76,831.81- 80,789.76 - 83,739.24 Supplies 1,250 56.94 - 1,018.95 693.39 - City Support Services 9,780 1,902.20 - 3,440.00 1,902.20 - Staff Support8,605342.77 3,370.043,291.77179.00 - TOTAL CITY SECRETARY 184,164 20,690.84 84,582.53- 86,755.39 179.00 NON-DEPARTMENTA L Supplies 2,500 - - 251.36 10.71 - City Support Services 525,970 35,651.21 1,294.02 246,823.36 204,046.48 210.00 Operations Support 139,000 11,275.63 1,076.05 69,578.31 72,657.93 14.80 City Assistance 459,046 - 229,212.73- 192,093.82 - 266,952.18 Professional Services 174,650 30,786.14 53,708.87- 52,996.35 - 121,653.65 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,312,016 77,712.98 2,370.07 599,574.63 521,805.29 224.80 3 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services215,678 31,212.22 - 67,332.12 130,171.99 - 85,506.01 Supplies2,900 7.99 - 460.05 1,695.07 64.94 1,139.99 Operations Support35,100 1,216.16 4,989.75 8,114.02 9,602.41 1,288.25 29,199.09 Staff Support4,350 158.66 196.44 1,084.90 1,357.47 98.51 3,090.46 Operating Equipment300 -1,894.78 - - - TOTAL PUBLIC AFFAIRS 258,328 32,595.03 5,186.19 78,885.87 142,826.94 1,451.70 RECORDS MANAGEMEN T Personnel Services 47,850 5,104.17 21,494.35- 23,967.65 - 23,882.35 Supplies 750 29.95 - 75.00 167.95 - Staff Support 1,500 50.00 - 641.90 390.00 159.40 Professional Services 15,000 148.50 - 6,465.14 1,502.00 - 13,498.00 Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 5,332.62 28,676.39- 26,027.60 159.40 SCHERTZ TALES MAGAZINE Personnel Services 129,161 14,506.36 56,325.64- 63,706.58 - 65,454.42 Supplies 200 - - - 45.00 - Opperations Support 200 - - - - - Staff Support 1,500 30.34 - - 116.08 31.23 Professional Services302,70025,785.63116,025.26141,841.648,352.56 - TOTAL SCHERTZ TALES MAGAZINE 433,761 40,322.33 172,350.90- 205,709.30 8,383.79 ENGINEERING Personnel Services 164,460 6,806.14 75,649.46- 38,420.78 - 126,039.22 Supplies 400 143.38 - 67.35 278.25 6.60 City Support Services - - - - - - Utility Services 600 73.67 - - 133.86 - Staff Support 2,213 - - 395.00 130.00 - Professional Services 48,165 5,805.00 - 6,710.00 46,705.00 - Maintenance Services 4,044 - - 2,745.24 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,000299.99 25,751.30- - - TOTAL ENGINEERING 245,882 13,128.18 85,567.05- 114,764.48 131,110.926.60 4 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 13,342.45 - 53,332.93 59,956.50 - 62,122.50 Supplies3,500 399.00 - 1,113.00 951.02 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 13,741.45 54,445.93- 60,907.52 - 70,721.48 TOTAL GENERAL GOVERNMENT 5,476,519 503,002.94 17,314.13 2,305,587.36 2,496,965.86 42,688.44 PUBLIC SAFETY POLICE Personnel Services4,536,879 474,030.86 - 1,960,363.25 2,179,768.13 - 2,357,110.87 Supplies31,837 3,465.02 6,769.16 7,312.58 11,724.07 9,282.04 17,600.05 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 9,657.66 - 38,110.51 44,584.00 - 78,872.00 Operations Support1,500 - - 98.00 720.00 535.00 245.00 Staff Support57,148 2,316.67 1,732.17 3,828.65 11,993.97 13,155.06 33,731.14 City Assistance10,914 283.00 - 1,664.98 2,500.74 320.00 8,093.26 Professional Services20,000 500.00 - - 1,142.85 100.00 18,757.15 Maintenance Services44,435 19,726.28 - 22,096.85 30,538.23 690.00 13,206.77 Operating Equipment59,231 17,573.04 4,945.10 31,735.12 32,124.37 19,430.33 12,621.40 Capital Outlay142,52512,554.80147,872.00155,076.05 - - TOTAL POLICE 5,062,925527,552.5326,001.232,213,081.942,489,690.8243,512.43 FIRE RESCUE Personnel Services 2,508,586 271,485.99 1,124,953.79- 1,286,985.45 - 1,221,600.55 Supplies 20,500 191.97 9,239.99 3,232.99 11,691.39 216.40 Utility Services 57,000 3,591.11 7.64 18,928.66 21,682.96 - 35,324.68 Operations Support 800 156.84 - 120.00 268.40 115.00 Staff Support 120,185 15,138.98 20,833.33 42,258.10 62,991.56 24,121.50 City Assistance 18,600 39.00 8,122.00 10,323.17 8,405.30 327.85 Professional Services 18,140 12,126.00 - 1,500.00 12,148.19 - Maintenance Services 56,000 8,339.50 3,710.01 12,674.01 19,032.21 535.88 Operating Equipment58,3002,602.4015,553.04 13,816.7614,881.80872.95 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 313,671.79 57,466.01 1,227,807.48 1,469,203.26 26,189.58 5 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 45,505.44 - 167,299.68 206,727.41 - 213,790.59 Supplies2,500 109.08 - 590.21 704.56 - Utility Services 6,500 522.24 - 2,119.36 2,121.76 - Operations Support 1,500 44.00 - 439.87 44.00 - Staff Support 8,000 116.40 581.37 2,219.95 1,650.26 37.89 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 450,01846,297.16581.37172,669.07211,247.9937.89 MARSHAL SERVICE Personnel Services 534,355 54,064.80 195,191.68- 262,206.03 - 272,148.97 Supplies 4,600 41.67 205.82 166.30 1,484.15 263.81 Utility Services 12,000 1,256.28 - 2,825.26 5,314.61 - Operations Support 4,000 86.00 - 367.49 1,072.41 - Staff Support 15,400 471.00 410.00 1,552.24 5,014.67 49.99 Professional Services - - - - - - Maintenance Services 30,700 1,785.00 - 6,389.00 1,934.00 - 28,766.00 Operating Equipment16,00028.002,206.37 5,718.079,235.03 - Capital Outlay34,000 31,022.0541,560.29 - - - TOTAL MARSHAL SERVICE 651,055 57,732.75 2,822.19 253,770.33 317,282.95 313.80 TOTAL PUBLIC SAFETY 9,057,109 945,254.23 86,870.80 3,867,328.82 4,487,425.02 70,053.70 6 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 72,409.62 - 285,906.78 341,833.84 - 338,523.16 Supplies7,100 708.38 21.04 2,474.39 2,764.81 704.10 3,652.13 Utility Services113,900 9,931.68 - 45,175.33 50,676.84 - 63,223.16 - - - - Operations Support - - Staff Support 10,265 523.26 79.91 3,132.66 2,602.50 514.66 Maintenance Services 270,800 14,271.16 579.71 70,114.25 85,613.38 11,130.06 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 4,200.00 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,82297,844.10680.66424,673.41486,977.3612,348.82 TOTAL PUBLIC ENVIRONMENT 1,086,822 97,844.10 680.66 424,673.41 486,977.36 12,348.82 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 51,410.58 - 218,230.24 240,000.70 - 266,869.30 Supplies40,555 2,813.98 1,169.51 19,412.59 18,422.11 1,108.70 22,193.70 Utility Services113,000 10,826.20 - 44,706.29 52,744.06 40.96 60,214.98 Operations Support700 - - 880.80 - - Staff Support 8,573 651.00 5,542.1760.93 4,901.62 1,125.25 2,607.06 Professional Services62,610 5,864.24 - 17,545.00 31,098.07 - 31,511.93 Maintenance Services22,000 3,918.98 44.99 10,404.53 13,178.16 238.52 8,628.31 Rental/Leasing42,200 124.33 - 23,760.56 16,381.53 26,300.52 (482.05) - - 5,428.93 (45.00) Operating Equipment - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT796,50875,609.311,275.43346,101.67376,681.2528,813.95 SWIM POOL Supplies 16,700 (33.54) 392.93 888.55 527.40 195.17 Utility Services 25,500 1,304.60 - 5,581.71 8,203.47 - 17,296.53 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 6,990.93 4,000.00 4,211.94 10,990.93 1,095.00 Rental/Lease500 -378.00 - - - TOTAL SWIM POOL 8,261.99243,003 4,392.93 11,060.20 20,471.80 1,290.17 225,633.96 7 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services107,533 6,030.36 - 31,397.77 28,376.92 - 79,156.08 Supplies28,300 1,235.84 1,127.61 5,347.02 7,538.03 1,273.61 20,615.97 Utility Services47,550 2,986.50 - 13,927.54 14,727.51 - 32,822.49 Operations Support15,200 88.66 - 4,514.51 4,290.37 2,907.50 8,002.13 Staff Support3,300 20.00 439.45 250.00 895.76 113.00 2,730.69 Professional Services1,600 - 150.00 925.00 150.00 - Operating Equipment5,000530.004,243.88 6,589.58285.00 - TOTAL COMMUNITY/CIVIC CNTR208,48310,891.365,960.9456,646.8462,568.174,294.11 TOTAL PARKS & RECREATION 1,247,994 94,762.66 11,629.30 413,808.71 459,721.22 34,398.23 CULTURAL LIBRARY Personnel Services 692,531 76,182.76 310,405.57- 349,733.42 - 342,797.58 Supplies14,000 235.37 86.59 4,983.20 4,369.77 1,442.26 8,274.56 Utility Services41,000 3,741.01 - 18,612.24 17,842.46 - 23,157.54 Operations Support2,000 - 174.00 70.00 174.00 - Staff Support 4,215 325.99 58.97 700.51 1,087.58 38.46 Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 400.00 - 1,200.00 1,200.00 - Operating Equipment 75,000 8,917.92 2,366.43 32,933.69 36,997.29 8,655.17 Capital Outlay -- - - - - TOTAL LIBRARY 89,803.05833,246 2,685.99 370,970.21 413,544.52 10,135.89 412,251.58 TOTAL CULTURAL833,246 89,803.05 2,685.99 370,970.21 413,544.52 10,135.89 412,251.58 8 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 27,935.23 - 141,461.35 135,153.43 - 161,285.57 Supplies25,000 545.57 319.99 7,539.59 8,073.98 3,783.87 13,462.14 Utility Services11,200 1,243.57 - 4,413.74 4,576.41 - Operations Support 500 - - - - - Staff Support 11,560 708.56 34.48 1,602.00 3,779.32 1,500.04 City Assistance 10,000 - - 3,358.35 5,384.73 967.73 Professional Services 14,500 225.00 - 5,386.50 2,130.50 150.00 Maintenance Services 6,200 1,000.00 - 1,926.78 3,825.00 220.50 Operating Equipment9,500 4,517.411,374.382,945.16 - - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES384,89931,657.93354.47170,205.72164,297.759,567.30 TOTAL HEALTH 384,899 31,657.93 354.47 170,205.72 164,297.75 9,567.30 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 31,099.02 120,722.06- 141,256.02 - 118,775.98 Supplies2,000 - - 439.01 68.84 - City Support Services 372,354 57,344.64 70,391.54- 132,611.27 - 239,742.73 Utility Services 154,949 13,449.26 1,585.17 57,769.81 67,781.94 29.99 Staff Support 15,250 1,445.76 2,036.38 3,285.68 7,337.21 2,201.44 Professional Services 2,500 - - - - - Maintenance Services 12,500 230.92 12,250.07- 5,963.36 1,345.00 Operating Equipment 129,315 4,451.46 4,911.44 29,708.61 38,219.06 7,553.15 Capital Outlay213,500 --7,266.00 - - TOTAL INFORMATION TECHNOLOGY1,162,400 108,021.06 8,532.99 294,566.78 393,237.70 18,395.58 759,299.71 9 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 13,187.20 - 97,276.95 113,820.38 - 182,929.62 Supplies1,329 - - 633.78 781.57 - Human Services 47,156 1,654.30 654.00 17,902.58 14,827.34 1,080.00 Operations Support 16,596 - 532.56 5,346.83 1,607.41 - 15,521.17 Staff Support 14,897 - 550.72 5,721.10 8,060.82 (55.00) City Assistance 9,860 1,625.00 - 2,159.00 3,275.50 - Professional Services - - - - - - Operating Equipment4,162.83 4,302.13- - - - TOTAL HUMAN RESOURCES 16,466.50386,588 5,900.11 129,040.24 146,675.15 1,025.00 244,787.98 FINANCE Personnel Services429,810 52,313.73 - 191,428.71 233,748.18 - 196,061.82 Supplies3,600 90.79 - 1,433.71 2,121.89 - Operations Support 850 - - - 97.31 - Staff Support 15,805 2,685.00 - 5,491.45 3,673.67 39.54 Rental/Leasing 2,230 - - - - - Operating Equipment1,000266.47 266.47866.69 - - TOTAL FINANCE453,29555,089.52266.47199,220.56239,907.5239.54 PURCHASING & ASSET MG T Personnel Services 241,940 26,304.41 108,008.41- 120,116.44 - 121,823.56 Supplies800 100.82 - 234.58 232.45 144.47 423.08 Utility Services450 81.66 - 131.70 331.63 - Operations Support 909 758.18 - 60.68 869.97 5.20 Staff Support 9,600 1,579.00 65.00 3,180.57 3,841.20 200.00 Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 28,824.07 65.00 111,615.94 132,982.51 349.67 10 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 35,363.99 - 73,926.32 108,791.72 - 109,088.28 Supplies109,600 17,872.69 2,927.39 50,137.74 78,718.21 11,706.39 22,102.79 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 244.94 - 1,566.42 1,497.71 - Operations Support 400 - - 375.00 375.00 - Staff Support 3,835 295.23 620.41 953.16 1,224.04 558.55 Maintenance Services 65,750 2,634.00 1,685.29 20,527.61 23,925.39 367.52 Rental/Lease200 150.00269.80 - - - Operating Equipment5,000(418.18) -4,931.79 - - Capital Outlay -- - - - - TOTAL FLEET SERVICE411,36555,992.675,233.09149,136.25221,233.6612,632.46 TOTAL INTERNAL SERVICE 2,674,938 264,393.82 19,997.66 883,579.77 1,134,036.54 32,442.25 MISC & PROJECTS CITY ASSISTANCE - - 214.21 - 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 31,500.0021,000.00 - 10,500.00 TOTAL CITY ASSISTANCE52,00010,500.00 26,214.21-34,000.0010,500.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - - TOTAL CITY ASSISTANCE - - - - - - TOTAL MISC & PROJECTS 52,000 10,500 - 26,214 34,000 10,500 TOTAL EXPENDITURES20,813,5272,037,218.73 139,533.01 8,462,368.21 9,676,968.27222,134.63 REVENUE OVER(UNDER) EXPEND.145,4283,396,783.37 11 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 64,190.11 6,600,730.50- 6,781,971.67 - 102,482.33 000-411200Advalorem Tax - Delinquent 50,000 4,041.73 25,990.84- 38,081.86 - 11,918.14 000-411300Advalorem Tax - P&I 50,000 6,275.43 25,753.13- 28,013.63 - 21,986.37 000-411500Sales Tax Revenue-Gen Fund4,784,071 432,770.63 1,505,925.57- 2,356,969.00 - 2,427,102.00 000-411600Bingo Tax 2,200 - - 1,161.08 - - 000-411700Mixed Beverage Ta16,729.2413,776.24 x 33,000.00 - - - TOTAL Taxes11,803,725 507,277.90 8,176,290.36- 9,218,812.40 - 2,584,912.60 Franchises 000-421200Center Point/Entex Energy 36,000 2,774.71 17,748.73- 20,762.15 - 15,237.85 000-421220City Public Service 330,000 26,643.80 118,313.65- 143,853.59 - 186,146.41 000-421240Guadalupe Valley Elec Co-op 440,000 36,795.62 86,926.39- 198,583.84 - 241,416.16 000-421250New Braunfels Utilities 55,000 3,879.15 - 5,633.66 22,406.87 - 32,593.13 000-421300Time Warner-State Franchise 345,000 20,548.92 81,908.40- 163,565.98 - 181,434.02 000-421350Time Warner-PEG Fee 65,000 - 16,370.38- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 6,234.40 45,445.16- 80,988.12 - 104,011.88 000-421465AT&T PEG Fees 26,000 - 5,834.61 7,247.95 000-421480Other Telecom Franchise 35,000 30,657.69 - 9,434.61 38,294.58 - (3,294.58) 000-421500Solid Waste Franchise Fee100,00012,383.7552,522.4849,550.18 - - TOTAL Franchises1,617,000139,918.04 440,138.07-741,292.76 - 875,707.24 Permits 000-431100Home Occupation Permit 500 35.00 - 245.00 245.00 - 000-431200Building Permit - 903,958.83- - - - 000-431205Building Permit - Residential 600,000 23,710.00 - 204,309.00- - 395,691.00 000-431210Building Permit - Commercial 300,000 112,787.00 - 133,149.00- - 166,851.00 000-431215Building Permit - General - 54,186.00- - 8,450.00 - (54,186.00) 000-431300Mobile Home Permit 200 - - 80.00 40.00 - 000-431400Signs Permit 1,700 - - 365.00 305.00 - 000-431500Food Establishmnt Permit 30,000 250.00 12,495.00- 10,225.00 - 19,775.00 000-431600Garage Sale Permit 8,600 970.00 - 4,435.00 4,080.00 - 000-431700Plumbing Permit 80,000 11,857.75 50,961.50- 58,662.75 - 21,337.25 000-431750Electrical Permit 55,000 5,030.00 26,020.00- 22,510.00 - 32,490.00 000-431800Mechanical Permit 59,000 3,920.00 31,420.00- 24,220.00 - 34,780.00 000-431900Solicitor/Peddler Permit 120.00 - 20.00 370.00 - - 000-431950Animal/Pet Permit 2,000 100.00 - 1,385.00 815.00 - 12 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,8001,500.00-3,000.005,450.00 - (1,650.00) 000-432100Security Alarm Permit 42,000 5,195.00 19,988.00- 25,510.00 - 16,490.00 000-435000Fire Permit5,0001,175.00 4,450.004,787.50 - - TOTAL Permits1,187,800175,099.75 1,059,160.83-548,526.75 - 639,273.25 Licenses 000-441000Alcohol Beverage License 6,300 - - 1,210.00 1,962.50 - 000-442000Contractors License 39,000 5,535.00 30,760.00- 30,780.00 - 000-444000Pet License3,000360.00 2,345.002,113.10 - - TOTAL Licenses 48,300 5,895.00 34,083.10- 35,087.50 - 13,212.50 Fees 000-451000Municipal Court Fines 1,665,009 144,987.24 535,915.07- 569,715.20 - 1,095,293.80 000-451100Arrest Fee 50,694 5,185.58 23,347.01- 26,797.27 - 23,896.73 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 14,656.00 65,498.16- 70,897.00 - 121,103.00 000-451210Court - Claims & Judgements - - 1,408.03 - (434.20) - (1,408.03) 000-451320Civil Justice Fee-Court 75 7.69 34.76 41.43 - 000-451321Civil Justice Fee-State 69.07 - - 373.31 - - 000-451340Judicial Fee - City 6,826 688.82 - 3,113.24 3,572.11 - 000-451400Traffic Fine Costs TTL 25,984 2,599.96 11,719.59- 13,712.65 - 12,271.35 000-451500Teen Court Admin Fee 260 40.00 - 220.00 360.00 - 000-451510Juvenile Case Mgmt Fee 55,896 5,755.27 25,948.27- 29,797.58 - 26,098.42 000-451600Technology Fund Fee 45,601 4,633.66 21,047.30- 23,987.39 - 21,613.61 000-451700Security Fee 34,220 3,475.24 15,794.48- 17,990.59 16,229.41 000-451800Time Payment Fee - City 7,336 389.09 - 3,385.62 2,755.74 - 000-451850State Fines 10% Service Fee 72,470 - 33,448.06- 28,248.02 - 44,221.98 000-451900DPS Payment - Local 11,858 1,160.13 - 5,473.22 5,656.53 - 000-452000Child Safety Fee 12,243 2,380.74 - 5,651.10 14,974.68 - (2,731.68) 000-452050Indigent Defense Fee 21,655 2,212.09 - 9,995.04 11,475.86 - 10,179.14 000-452100Platting Fees 98,000 12,000.00 37,500.00- 38,500.00 - 59,500.00 000-452200Site Plan Fee 74,000 4,500.00 15,000.00- 15,000.00 - 59,000.00 000-452300Plan Check Fee 465,000 17,536.00 457,647.41- 152,247.00 - 312,753.00 000-452310Miscellaneous Review Fee 13,500 300.00 - - 5,400.00 - 000-452320Tree Mitigation Admin Fee 10,500 1,957.50 - - 2,737.50 - 000-452400BOA/Zoning Fees 4,000 500.00 - 1,400.00 3,250.00 - 000-452500Food Handler Class 7,000 400.00 - 4,300.00 2,070.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: MARCH 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452600Specific Use/Zone Chng Fee 4,000.0020,000 - 11,000.00 23,850.00 - (3,850.00) 000-452710Zoning Ltr & Dev Rights1,500 - - 225.00 1,050.00 - 000-453100Reinspection Fees 30,000 3,925.00 23,175.00- 19,750.00 - 10,250.00 000-453200Mowing Fees - Inspections 12,000 450.00 - 9,882.91 1,160.83 - 10,839.17 000-453211Admin Fee-Inspections 7,480 600.00 - 4,100.00 3,740.00 - 000-453310Misc Inspection Fee - - 40.00 19.49 - - 000-453710Foster Care 500 50.00 - 550.00 450.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 (3,000.00)800 - - - - 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 50.00 - 600.00 450.00 000-458100Sale of Merchandise - - - - - - 000-458300Sale of Property/Auction 22,000 901.33 - 2,198.55 10,158.80 - 11,841.20 000-458400Civic Center Rental Fees 171,000 12,446.25 61,527.75- 52,588.50 - 118,411.50 000-458401Capital Recovery Fee-Civic Cntr 7,500 425.00 - 1,060.00 2,875.00 - 000-458450North Center Rental Fees 15,000 1,850.00 - 3,601.00 11,207.92 - 000-458500Community Center Rental Fees18,000 3,834.30 - 7,849.92 13,603.59 - 000-458550Pavilion Rental Fees 18,500 2,630.00 - 8,536.70 6,974.50 (100.00) 000-458560Chamber of Comm rent 11,700 - - 3,900.00 3,900.00 - 000-458570Non-Resident SYSA League 12,000 - - 7,060.00 15,935.00 - (3,935.00) 000-458600Ball Field Use - - 1.76 - - - 000-458650NonResident User Fee-BVYA 11,000 - - 2,820.00 2,670.00 - 000-458660BVYA Utility Reimbursement - - - 3,195.72 - - (3,195.72) 000-458670SYSA Utility Reimbursement -- 3,512.43 - 1,413.51 - (3,512.43) 000-458680Tournament Fees-Soccer 15,000 - - 2,400.00 7,625.00 - 000-458700Vehicle Impoundment 5,000 - - - - - 000-459200NSF Check Fee 250 - - 328.00 - - 000-459300Notary Fee 300 36.00 - 222.00 156.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - 593.18 58.10 - 000-459600Animal Adoption Fee 15,000 590.50 - 5,711.50 5,971.00 - 000-459700Pet Impoundment Fee 15,000 780.00 - 9,816.51 6,867.25 - 000-459800Police Reports Fee6,500712.00 2,903.202,932.20 - - TOTAL Fees 3,324,727 256,693.77 1,446,570.31- 1,241,695.22 (100.00) 14 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,871.9212,788.6213,263.61(15.99) - TOTAL Fines 30,000 2,871.92 12,788.62- 13,263.61 (15.99) Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 - - 7,025.92 7,025.92 - 14,051.08 000-473200City of Seguin - Fire Contract 40,263 3,355.26 20,131.56- 20,131.56 - 20,131.44 000-473300Guad Co - Library 180,000 15,901.33 90,408.00- 95,407.98 - 84,592.02 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,200.00 600.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 - 66,652.90- 66,652.50 - 66,652.50 000-474600School Crossing Guard-Bexar6,600 3,123.4013,111.41 - - - 000-474610School Cross Guard-Guadalupe 4,451.4716,359.08 -3,182.49 - -(16,359.08) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional 571,245 22,439.08 192,993.25- 306,788.45 - 264,456.55 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 43,920.00- 43,920.00 - 43,920.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 85,110.50- 71,313.00 - 71,313.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 19,444.00- 20,917.50 - 14,562.50 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 312,388.50- 440,611.02 - 440,610.98 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486317Transfer From Park Fund 13,000 - - - - - 13,000.00 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 44,652.50- 49,242.00 - 49,242.00 000-488000Interfund Charges-4B 53,000 4,416.67 27,716.00- 26,500.02 - 26,499.98 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 -108,750.59 608,603.55 653,503.54 - 1,107,154.46 15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 25.57 - 1,497.86 152.29 - 000-491200Investment Income 30,000 4,788.99 17,081.69- 23,757.27 - 000-491800Gain/Loss - - - 443.67 - - 000-491900Unrealized Gain/Loss (15,690.98)- (16,977.80) - (3,689.17) - 16,977.80 000-492100Proceeds-Sale of Land - - 57,867.85- - - (57,867.85) 000-493000Donations-Others - - 340.00 - - - 000-493120Donations-Public Library - - - - - - 000-493130Donations-Writing the Next Chap. 100.00 21,844.00- 4,906.34 - - (4,906.34) 000-493400Donation - Animal Control 1,200 547.00 - 2,365.26 2,126.01 - 000-493401Donations-A/C Microchip 500 100.00 - 1,345.00 1,010.00 - 000-493402Donations-Spay&Neuter 13,500 978.50 - 8,656.57 6,495.50 - 000-493503Donations - Fire Rescue - - 25.00 - - - 000-494481LawEnforcemtOfficersStnd&Ed - - 3,550.22 50.00 - - 000-494482Grants - Police - - - 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 62,334.44 (26,718.02)- 40,118.22 (1,008.90) 000-497005Misc Income-Publications 290,000 26,497.05 67,308.15- 99,543.00 - 190,457.00 000-497007Misc Income-Schertz Artz - - - 20.00 - - 000-497100Misc Income-Police 25,000 528.30 14,596.13- 2,911.25 - 22,088.75 000-497200Misc Income-Library 19,000 290.50 - 1,651.10 1,953.44 - 17,046.56 000-497210Misc Income-Library Copier 13,500 1,421.35 4,921.65 6,906.81 - 000-497300Misc Income-Animal Control 500 - - 989.30 105.00 - 000-497400Misc Income-Streets Dept. 20,000 613.00 - 8,525.00 7,632.48 - 12,367.52 000-497500Misc Income-TML Insurance 78,000 - 49,730.90- - - 78,000.00 000-497550Misc Income-TML Reimbursemt20,000 2,370.95 17,643.20- 8,166.86 - 11,833.14 000-497600Misc Income-Parks/Vending Mach.2,500 118.00 -1,011.66860.35 - 000-498000Reimbursmnt-Gen Fund5,000643.00 1,549.6022,052.02 - -(17,052.02) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA - - 3,785.61 569.87 - - 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 38,143.218,078.07 - - - TOTAL Miscellaneous 615,500 97,667.48 194,932.97- 314,781.41 (1,008.90) TOTAL REVENUES20,958,9551,316,613.53 12,165,561.06-13,073,751.64 (1,124.89) 16 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking328,191.26$ Cash in Investment Pools LOGIC Investment-General Fund4,109,211.22 LOGIC Investment-Equip Replacement73,382.32 LOGIC Investment-Veh Replacement7,082.93 LOGIC Investment-Air Condi Replacment146,513.95 CAPITAL ONE Investment-General Fund1,355,198.37 Total Cash in Bank & Investment Pools$6,141,830.31 17 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 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% -2% 25% 17% 12% $400,000 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 365,083 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 76,414 - - 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: MARCH 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET50% 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 22,511.06 30,461.91- 22,951.06 - 5,048.94 TML Dinner - - - - - - Hal Balwin Scholarship 24,000.00 - 9,610.00 60.00 - - 23,940.00 Miscellaneous175.0022,524.85- 775.18426.54 - TOTAL REVENUES114,275.00 45,035.91 - 40,498.45 23,786.24 - 90,488.76 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 12,645.61- 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 1,500.00 30,461.91- 3,880.00 - 27,620.00 Blue Santa - - - - - - TML Events - - - - - - Schertz Sweetheart 37,000.00 2,662.99 20,165.54- 5,664.31 30,715.69620.00 Hal Baldwin Scholarship11,000.00- -1,000.00 - -10,000.00 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 4,162.99103,600.00 218.05 63,799.06 23,812.82 670.00 79,335.23 TOTAL EXPENDITURES108,750.00 4,162.99 218.05 63,799.06 23,812.82 670.00 84,485.23 REVENUE OVER(UNDER) EXPEND5,525.00(26.58) 19 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking26,800.93$ Cash in Investment Pools MBIA Special Events66,619.92 Total Cash in Bank & Investment Pools$93,420.85 20 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,00026,225.45 110,290.49-78,443.91 101,556.09- Fees14,164,250911,037.05 6,611,875.52-7,262,125.21 6,902,124.79- Fund Transfers484,6747,056.17 40,308.00-42,337.02 442,336.98- Miscellaneous28,305.51222,742.16220,393.15 103,260 - - TOTAL REVENUES14,932,184972,624.186,985,216.177,603,299.29 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers31,000.00- 27,366 - - - TOTAL NON DEPARTMENTAL31,000- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services383,89436,767.39 201,392.53-176,670.96 207,223.04- Supplies5,40054.06418.331,361.992,061.30159.94 Human Services100----40.00 Operations Support114,00012,214.78 39,135.65-49,815.23 64,184.77- Staff Support7,1001,683.5694.261,277.222,514.1134.64 Professional Services16,0001,262.61395.005,784.6710,176.41- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300840.00-3,080.004,440.001,420.00 Operating Equipmen500.006,117.625,932.94 t 6,200 - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE52,822.401,407.59258,149.68251,610.951,654.58 603,994 W & S ADMINISTRATION Personnel Services1,184,898113,044.17 586,545.36-550,705.70 634,192.30- Supplies200,70065,852.474,458.8188,121.9089,577.134,119.73 Human Services1,000--64.00-40.00 City Support Services108,999- 34,811.55-34,379.59 74,619.41- Utility Services2,634,34485,923.05 906,693.22-1,227,309.07 1,407,034.93- Operations Support8,750272.09-1,650.691,787.92- Staff Support33,0001,634.93294.5411,444.089,174.74944.41 City Assistance1,912147.00-236.00297.00- Professional Services187,40027,526.93 96,158.84-52,216.44 135,183.56- Fund Charges/Transfers2,623,50777,414.25 1,180,900.40-1,314,756.99 1,308,750.01- Maintenance Services5,522,250608,321.9312,287.432,277,850.442,572,019.6820,569.06 Other Costs35,000- 28,911.85-30,956.44- 21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353- 534,900.62-96,868.35 1,133,484.65- Rental-Leasing6,070--662.532,516.68- Operating Equipment8,000- 13,783.09--- Capital Outla82,000.0031,996.38 y 114,000 - -132,061.40 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,183980,136.82 5,894,795.9717,040.78 6,064,565.73 57,669.58 7,794,988.47 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-37,605.31- 49,750.79- Maintenance Services303.28 - 334,500 - - - 37,908.59- TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -401,750.79 FM3009 RD&BRIDGE EXPANSION Professional Services18.00 30,358.80-1,995.50 (1,995.50)- - Maintenance Services 37.74 71,088.87 - - - - 18.0073,084.37 TOTAL FM3009 RD&BRIDGE EXPANSION - -30,396.54 -(73,084.37) TOTAL MISC & PROJECTS18.001,750.7968,305.1373,084.37 400,000 -328,666.42 TOTAL EXPENDITURES14,931,5431,032,97720,1996,252,2516,389,26159,324 ** REVENUE OVER(UNDER)EXPENSES **1,214,038.24 641 22 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 26,225.45110,290.4978,443.91 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 26,225.45 110,290.49- 78,443.91 - 101,556.09 Fees 000-455200Garbage Collection Fee 3,400,000 258,279.89 1,600,774.66- 1,740,329.24 - 1,659,670.76 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 17,207.76 103,768.37- 126,036.23 - 114,963.77 000-455800W&S Line Constructn Reimbursemnt50,000 1,124.00 15,996.81- 13,682.83 - 36,317.17 000-457100Sale of Water 7,210,000 416,365.73 3,263,234.45- 3,645,984.16 - 3,564,015.84 000-457110Edwards Water Lease 166,250 - 153,410.82- 41,585.85 - 124,664.15 000-457120Water Transfer Charge-Selma 5,000 - - 1,339.20 13,657.95 - (8,657.95) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 3,149.00 42,197.89- 26,158.00 - 63,842.00 000-457400Sewer Charges 2,800,000 202,470.36 1,329,984.20- 1,543,196.35 - 1,256,803.65 000-457500Water Penalties 180,000 12,360.31 81,555.62- 88,174.63 - 91,825.37 000-459200NSF Check Fee-Water&Sewer2,00080.001,182.221,430.00 - - TOTAL Fees14,164,250911,037.05 6,611,875.52-7,262,125.21 - 6,902,124.79 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1740,308.00 42,337.02 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 40,308.00- 42,337.02 - 442,336.98 Miscellaneous 000-490000Misc Charges 10,000 125.00 - 4,331.88 208.05 - 000-491000Interest Earned 1,000 149.99 - 1,097.39 981.75 - 000-491200Investment Income 6,000 638.63 - 6,889.58 6,762.89 - 000-493400Donations-Christmas Activitise - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation - 134,500.00- 134,500.00 - - (134,500.00) 000-497000Misc Income-W&S 16,898.22- 25,385.96 -1,286.69 - (25,385.96) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 26,105.20 50,615.45- 51,804.50 - 24,510.50 000-498200W&S Project Reimbursement5,118.30 - - - - - TOTAL Miscellaneous 103,260 28,305.51 222,742.16- 220,393.15 - (117,133.15) TOTAL REVENUES14,932,184 972,624.18 6,985,216.17- 7,603,299.29 - 7,328,884.71 23 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking116,100.38$ Cash in Investment Pools Lone Star Investment-Water&Sewer1,359,191.99 Lone Star Investment-W&S Customer Deposits293,986.42 Lone Star Investment-W&S Equip Replacement373,476.77 Lone Star Investment-W&S Veh Replacement544,573.77 Lone Star Investment-Water/SSLGC SAWS269,460.59 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,896,598.16 Total Cash in Bank & Investment Pools4,012,698.54$ 24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 312,884.63 1,678,678.50- 1,609,318.85 2,479,614.15- Inter-Jurisdictional1,438,836 34,006.68 667,622.13- 726,556.20 - 712,279.80 Miscellaneous13,943.99-48,327.9243,762.97 256,000 - TOTAL REVENUES 360,835.30 - 2,394,628.55 2,379,638.02 - 3,404,130.98 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891297,939.03 1,282,187.8168.001,354,296.43 1,232,651.5711.00 Supplies 28,100.20 13,149.22 136,673.60 178,827.47 32,221.85 324,039 Human Services - 580.00 - 800 - - City Support Services 10,902.09- 10,277.40 31,505 - - 21,227.60 Utility Services 10,014.37 10.41 41,976.33 46,487.48 66,007.9315.00 112,500 Operations Support 3,249.36 364.65 30,866.65 32,749.69 45,600 - 13,214.96 Staff Support 5,945.13 449.08 30,652.49 34,414.22 15,890.90 72,400 City Assistance 1,338.00 - 3,495.00 4,085.50 157.50 9,000 Professional Services 7,374.66 133.00 50,154.15 54,861.06 23,223.56 164,200 Fund Charges/Transfers2,084,785 143,565.32 557,516.58- 661,126.49 - 1,423,658.51 Maintenance Services 7,410.00 20,172.52- 30,645.52 37,700 - 7,054.48 Debt Service 69,799.33- 5,863.00 111,176 - - 105,313.00 Rental-Leasing - 1,682.20 - 20,000.00 20,000 - - Operating Equipment 229.00 820.75 10,570.16 41,152.01 672.61 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 505,165.07 14,995.11 2,247,228.91 2,454,786.27 72,192.42 3,201,612.42 5,713,596 TOTAL EXPENDITURE505,165.0714,995.112,247,228.912,454,786.27 S 5,713,596 72,192.42 ** REVENUE OVER(UNDER) EXPENSES (75,148.25) * 70,173 25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 301,094.63 - 1,624,678.50 1,554,826.85 - 2,263,906.15 40.72% 000-456110Subscription Program Fees55,000 590.00 - 18,340.00 17,585.00 31.97% - 37,415.00 000-456120EMT Class - Fees95,200 9,780.00 - 35,660.00 33,681.00 - 61,519.00 000-459200Paramedic Class Fees 120,000 - - - - - 120,000.00 000-456130Immunization Fees - 3,226.00- -1,420.00 - (3,226.00) 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933312,884.63 1,678,678.50- 1,609,318.85 2,479,614.15- Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.88 - 144,163.15 143,063.28 - 143,062.72 000-474300Cibolo Support 222,018 106,650.00- 111,049.96 - - 110,968.04 000-475100Comal Co ESD #6 82,875 6,908.83 - 666.56 41,452.96 - 41,422.04 000-475200Live Oak Support 148,125 74,062.50- 80,164.76 - - 67,960.24 000-475300Universal City Support 226,168 102,206.26- 113,975.66 - - 112,192.34 000-475400Selma Support 67,618 34,365.00- 33,821.70 - - 33,796.30 000-475500Schertz Support 384,046 193,729.74- 192,093.82 - - 191,952.18 000-475600Santa Clara Support 8,849 - 5,267.34 4,426.12 - - 4,422.88 000-475800Marion Support13,0113,253.976,511.586,507.94 - - TOTAL Inter-Jurisdictional1,438,836 34,006.68 667,622.13- 726,556.20 - 712,279.80 Miscellaneous 000-491000Interest Earned--- 0.00% - - - 000-491200Investment Income 62.50 - 328.45 294.51 - - 000-493203Donations-EMS 6,000 100.00 - 1,100.00 695.00 - 5,305.00 000-493204Donations-Dilworth Fund - - - 0.00% - - - 000-493205Donations- Golf Tournament - - 100.00 -100.00 - 000-497000Misc Income 150,000 11,818.21 38,630.97- 39,920.18 - 110,079.82 000-497100Recovery of Bad Debt100,0001,863.288,268.502,753.28 - - TOTAL Miscellaneous256,00013,943.99 48,327.92-43,762.97 - 212,237.03 TOTAL REVENUES5,783,769360,835.30 2,394,628.55- 2,379,638.02 3,404,130.98- 26 SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank $ (625,692.57) Claim on Operating Cash Pool-Checking Cash in Investment Pools MBIA Investment-EMS Note 2010301,042.24 $(324,650.33) 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: MARCH 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60052,881.07 353,235.30- 375,717.87 -333,882.13 Fund Transfers - - - - - - - 0.00% Miscellaneous900633.00449.29 78.71 - - TOTAL REVENUES 52,959.78710,500353,868.30 -376,167.16334,332.84 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40433,692.80 172,082.36- 167,221.85 -207,182.15 Supplies 8,300 246.99 - 614.18 888.05 418.02 Human Services 325 - - - - -325.00 City Support Services 23,063 - 4,332.18 1,508.72 - -21,554.28 Utility Services 24,188 2,221.59 - 4,815.99 8,613.21 -15,574.79 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 161.04 43.02 2,099.49 1,243.81 244.59 City Assistance 840 - 15.00 57.00 - -783.00 Professional Services 19,800 1,151.25 10,000.00- 7,957.50 -11,842.50 Fund Charges/Transfers 199,87611,785.92 65,324.50- 70,715.52 -129,160.48 Maintenance Services 22,000 - 1,987.00 - - -22,000.00 Other costs 100.00100 - 100.00 100.00 - - 100.00% Debt Service 17,564 - 1,918.78 1,632.07 15,931.93 - - Rental/Leasing500-- - - -500.00 Operating Equipment-- - - - - - TOTAL DRAINAGE 49,359.59701,72543.02263,289.48 662.61259,937.73441,167.68 TOTAL EXPENDITURE 49,359.59701,72543.02263,289.48 662.61259,937.73441,167.68 S ** REVENUE OVER(UNDER) EXPEND8,775116,229.43 28 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 2,110.88 2,584.63 4,000 451.39 -1,415.37 000-457600Drainage Fee 52,429.68-351,124.42373,133.24 -332,466.76 705,600 TOTAL Fees52,881.07 353,235.30-375,717.87 333,882.13- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 166.04 40.33 100 8.05 - 000-491200Investment Interest - 346.90 376.62 600 63.73 -223.38 000-497000Misc Income-Drainage-120.0632.34 200 6.93 - TOTAL Miscellaneous - 633.00 449.29 900 78.71 -450.71 TOTAL REVENUES52,959.78 353,868.30- 376,167.16 334,332.84- 710,500 29 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 185,550.57 Cash in Investment Pools Lone Star Investment-Drainage Maint Fund283,457.26 Total Cash in Bank & Investment Pools$469,007.83 30 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 62,081.55 98,328.72- 162,046.14 -228,707.86 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50023.77-226.65129.87 - TOTAL REVENUES 62,105.32411,386-98,555.37162,176.01249,209.99 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 - 1,826.50 - -886.50 City Support Services 85,948 29,616.85- 36,657.00 - -49,291.00 Operations Support 74,000 3,955.25 346.04 5,952.88 15,247.54 -59,098.50 Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 85,110.50- 71,313.00 -122,563.00 Operating Equipment 52,562 15,809.58- - 6,645.00 -43,397.42 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 15,840.75411,3867,204.04120,680.23140,853.62277,736.42 L - TOTAL EXPENDITURE 15,840.75411,3867,204.04120,680.23140,853.62277,736.42 S - 21,322.39 REVENUE OVER(UNDER) EXPENDITURE - 31 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 62,081.5598,328.72162,046.14 -228,707.86 - TOTAL Taxes 390,754 62,081.55 98,328.72- 162,046.14 - 228,707.86 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned30010.11-151.4658.06 - 241.94 000-491200Investment Interest 200 13.66 - 75.19 71.81 - 128.19 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50023.77-226.65129.87 - 370.13 TOTAL REVENUES 411,386 62,105.32 98,555.37- 162,176.01 - 249,209.99 32 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking244,642.36$ Cash in Investment Pools Federated Investment-Hotel/Motel78,197.85 Total Cash in Bank & Investment Pools$322,840.21 33 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 36,215 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: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,00052,000.00 82,000.00- 104,575.00 -145,425.00 Tree Mitigation Fees 11,092.5075,000 - 15,512.50- -59,487.50 Miscellaneous- 340.47371.83 600 59.44 - TOTAL REVENUES63,151.94-82,371.83120,427.97 325,600 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 12,234.00- 135.88 135.88 -3,364.12 Operating Equipment 32,000 46,826.52- 8,137.20 9,381.20 2,265.00 Capital Outlay -- 58,873.45 169,000 350.00 7,500.00 TOTAL PARKLAND DEDICATION-59,060.5267,146.53 217,500 2,750.88 16,881.20 TREE MITIGATION Maintenance Services-Trees28,500 18,171.00- 758.00 1,880.00 - Capital Outlay-- 19,900.00 18,000 - - TOTAL TREE MITIGATION-18,171.0020,658.00 46,500 - 1,880.00 TOTAL EXPENDITURE-77,231.5287,804.53 S 264,000 2,750.88 18,761.20 REVENUE OVER(UNDER) EXPEND32,623.44 61,600 35 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,00052,000.00 82,000.00- 104,575.00 145,425.00 000-458900Tree Mitigation75,000 15,512.50- 11,092.50 - TOTAL Fees 325,00063,092.50 82,000.00- 120,087.50 204,912.50 Miscellaneous 000-491000Interest Earned 100 3.65 - 149.14 11.25 88.75 000-491200Investment Interest 500 55.79 - 222.69 329.22 170.78 000-497000Miscellaneous Income -- - - - TOTAL Miscellaneous60059.44-371.83340.47 259.53 TOTAL REVENUES 325,60063,151.94 82,371.83- 120,427.97 205,172.03 36 PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$105,118.22 Cash in Investment Pools Federated Investment-Park Fund192,898.68 Federated Investment-Tree Mitigation126,355.69 Total in Investment Pool 319,254.37 Total Cash in Bank & Investment Pools$424,372.59 37 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 *********************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fund Transfer-- - 27,366 - - TOTAL REVENUES-- - 27,366 - - EXPENDITURE SUMMARY NONDEPARTMENTAL Payable to Waste Contractor-- - - - - TOTAL NONDEPARTMENTA-- - L - - - TOTAL EXPENDITURE-- - S - - - REVENUE OVER(UNDER) EXPEND- 27,366 - 38 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 318-RECYCLING CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fund Transfers 000-486202Transfer In-W&S27,366-- - - - TOTAL Fund Transfers27,366--- - -27,366.00 TOTAL REVENUES 27,366 - - - - - 27,366 39 RECYCLE FUND CASH IN BANK AS OF: MARCH 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: MARCH 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 129,487.20 1,250,482.39- 740,007.72 -1,985,392.28 Fund Transfers10,673,600 - - - - -10,673,600.00 Miscellaneous314,000(192.46)166,823.37226,166.82 - - TOTAL REVENUES13,713,000 129,294.741,417,305.76966,174.54 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 353.67 - 1,761.50 2,415.44 -19,584.56 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - - - Debt Service - - 108,671.00- - -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000353.6710,189.50111,194.94 L - - MISC & PROJECTS Projects13,025,000 35,663.25-63,983.3610,488.42 -13,050,174.83-0.19% Schaefer RD Water Improvements599,643 -- - - -599,643.00 Northcliffe Elevated Tnk -- - - - - Northcliffe Water Plant -- - - - - Town Creek Project -- - - - - Live Oak Water Plant- - - -204,531.74 - Loop Feed Water Line -- - - - - viation Heights WTR IMP307,269.43- A - - - - TOTAL MISC & PROJECTS13,624,643 -35,663.25575,784.5310,488.42 - TOTAL EXPENDITURE13,662,643 353.6735,663.25585,974.03121,683.36 S - REVENUE OVER(UNDER) EXPENDITURES50,357844,491 41 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 60,147.00 792,595.34- 482,406.00 -997,194.00 000-455910Capital Recovery - Waste Wtr613,800 71,140.20 457,287.05- 239,601.72 -374,198.28 - - - 000-455911Capital Recovery-Wste Wtr Zone 1 - - - (1,800.00) 18,000.00600.00 000-455913Cap Recovery-North Sewer Tr 632,000 - - TOTAL Fees 2,725,400129,487.20 1,250,482.39- 740,007.72 -1,985,392.28 Fund Transfers 000-481000Transfer from Reserves10,673,600 - - - - -10,673,600.00 000-486202Transfer in-Water -- - - - - -- 000-486406Transfer in-Public Improvement - - - - TOTAL Fund Transfers10,673,600---- -10,673,600.00 Miscellaneous 000-491000Interest Earned50034.23-274.33151.57 - 000-491200Investment Income 30,000 4,796.27 18,816.41- 25,035.74 -4,964.26 000-491800Gain/Loss - - (554.28) - - - 000-491900Unrealized Gain/Loss-Cap One (19,017.37)- (18,466.21) - (5,022.96) -18,466.21 000-497000Misc Income - - - - - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 25,000.00- - - - - 141,750.00- 000-498200Re-imbursement-Water Meters 283,500 - - - TOTAL Miscellaneous 314,000 (192.46) 166,823.37- 226,166.82 -87,833.18 TOTAL REVENUES13,713,000129,294.74 1,417,305.76- 966,174.54 -12,746,825.46 42 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking862,787.36$ Cash in Investments: Lone Star Investment-Capital Recovery Water1,153,445.16 Lone Star Investment-Capital Recovery Sewer280,735.08 Capital One-Investment1,710,740.20 Total Cash in Bank & Investment Pools4,007,707.80$ 43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 44,728.974,281,098 - 3,332,451.27 4,221,584.37 -59,513.63 - - - - Fund Transfers - - Miscellaneous2,2502,061.8315,044.2812,153.43 - - TOTAL REVENUES 46,790.804,283,3483,347,495.554,233,737.80 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - 350.00 36,210.39 Professional Services - -(36,210.39) Debt Service -4,276,6672,558,340.593,074,924.52 - - TOTAL GENERAL GOVERNMEN -4,276,6672,558,690.593,111,134.91 T - - TOTAL EXPENDITURE -4,276,6672,558,690.593,111,134.91 S - - ** REVENUE OVER(UNDER) EXPEND6,6821,122,602.89 44 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 44,728.973,332,451.274,221,584.37 - - TOTAL Taxes4,281,09844,728.97 3,332,451.27-4,221,584.37 - 59,513.63 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 - 14,409.41- 27.87 - 000-491200Investment Earnings1,5002,061.83634.87 12,125.56 - - TOTAL Miscellaneous 2,250 2,061.83 15,044.28- 12,153.43 - (9,903.43) TOTAL REVENUES4,283,348 46,790.80 3,347,495.55- 4,233,737.80 - 49,610.20 45 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent 350.00400.00 - - - - 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services--35036,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- 42,525.00 -40,125.00 101-555622Schertz C O SR2003-Principal200,000 - 190,000.00- 200,000.00 - 101-555622.1Schertz C O SR2003-Interest 53,800 - 32,120.00- 7,432.50 -46,367.50 101-555624Comm Proj Bond-SR04-Principal315,000 - 325,000.00- 315,000.00 - 101-555624.1Comm Proj Bond SR04-Interest251,009 - 136,058.76- 13,796.88 -237,212.12 101-555626LS&D SR2006-Principal 100,000 - - 100,000.00- - 101-555626.1LS&D SR2006-Interest 648,982 - 325,490.64- 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 - 13,308.53- 10,864.43 -11,760.57 101-555629GO Bond 2007-Principal 225,000 - 275,000.00- 225,000.00 - 101-555629.1GO Bond 2007-Interest 198,922 - 107,346.25- 101,750.00 -97,172.00 101-555630GO Bond SR2008 Principal 370,000 - 355,000.00- 370,000.00 - 101-555630.1GO Bond SR2008 Interest 364,679 - 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 Interest140,656.25 278,813 - -142,406.25 -138,156.25 101-555633GO SR2011 Principal 90,000.00- 532,287 - - -442,287.00 101-555633.1GO SR2011 Interest 346,167.71- 90,000 - - -(256,167.71) 101-555634GO SR2011A Refund Principal 140,000.00- - - - -(140,000.00) 20,081.36- 101-555634.1GO SR2011A Refund Interest - - - - TOTAL Debt Service4,276,667- 2,558,340.59-3,074,924.52 -1,201,741.98 TOTAL EXPENDITURES4,276,667 - 2,558,690.59- 3,111,134.91 -1,165,531.59 46 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking30,098.90$ Cash in Investment Pools MBIA Investment- Tax I&S1,181,939.89 Federated Investment-Tax I&S56.85 Total Cash in Bank & Investment Pools$1,212,095.64 47 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MARCH 31st, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET50% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042216,385.52 752,962.78- 1,179,670.05 - 1,212,371.95 Fund Transfers - - - - - - Miscellaneous17,20023,396.775,207.4025,520.58 - - ,,,.,.,,. TOTALREVENUES24092422397822975817018120519063 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 3,715.03 579.81 12,004.73 17,043.16 1,190.63 Utility Service 87,500 4,867.22 28,010.03- 32,898.41 - 54,601.59 Maintenance Services 72,300 10,340.65 632.25 34,488.38 35,829.34 846.34 Operating Equipment - 6,999.31 - - - - Capital Outlay -- - - - - TOTAL NONDEPARTMENTA180,80018,922.901,212.0681,502.4585,770.912,036.97 L ECONOMIC DEVELOPMEN T Personnel Services 241,233 26,739.66 66,267.74- 106,228.57 - 135,004.43 Supplies 1,100 - 540.23 267.92 144.43 - Human Services 200 - - 111.00- - City Support Services 42,772 19.61 1,363.42 9,559.57 7,717.90 332.06 Utility Services 7,200 158.72 - 1,602.76 749.63 - 6,450.37 Operations Support 63,600 609.78 4,813.35 38,490.69 11,148.04 2,581.75 Staff Support 112,800 1,094.20 937.31 62,352.04 61,390.91 7,112.03 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 15,480.61 30,935.60 143,782.52 75,607.11 - 258,828.49 Fund Charges/Transfers 105,985 4,665.42 77,716.00- 27,992.52 - 77,992.48 Fund Replenish-Fund Balance - - - - - - Maintenance Services - - - - - - Debt Service 795,154 606,911.25- 613,014.50 182,139.50 - - Operating Equipment2,35092.95 92.95- - - TOTAL ECONO DEVELOPMEN 48,860.951,975,89438,049.681,007,222.80914,210.05 T 10,281.27 TOTAL EXPENDITURE 67,783.852,156,69439,261.741,088,725.25999,980.96 S 12,318.24 ** REVENUE OVER(UNDER) EXPEND252,548205,209.67 48 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MARCH 31st, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET50% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042216,385.52752,962.781,179,670.05 - - TOTAL Taxes2,392,042216,385.52 752,962.78- 1,179,670.05 -1,212,371.95 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 7.11 - 63.16 92.78 - 000-491200Investment Earnings 15,000 441.17 - 4,790.44 3,715.38 -11,284.62 000-497000Misc Income 22,948.492,000 - 353.80 21,712.42 -(19,712.42) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 23,396.7717,200 - 5,207.40 25,520.58 - TOTAL REVENUES2,409,242239,782.29 758,170.18-1,205,190.63 -1,204,051.37 49 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: MARCH 31st, 2011 Cash in Bank Claim on Operating Cash Pool-Checking145,441.41$ Cash in Investment Pools MBIA Investment-Economic Development Corp2,024,149.47 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investment Pools3,205,066.34$ 50 4B SALES TAX $300,000 40% $250,000 -2% 17% 25% -2% $200,000 12% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 182,541 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 MARCH 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,938,213.18,003,816.63.0500,200,250.56,265,854.01,938,213.18,938,213.18 304422 TOTAL OPERATIONS2,938,213.18,003,816.63,200,250.56,265,854.01,938,213.18,938,213.18 34422 LOGIC General Fund4,109,211.22,608,068.00.2942,143.2200,000.00,109,211.22 N/A,109,211.22 401544 G/F-Equipment Replacement73,382.3273,363.990.2942 -18.3373,382.32 N/A73,382.32 G/F-Vehicle Replacement7,082.93,081.16.2942 -.77,082.93 N/A,082.93 70177 G/F-Air Conditioner Replacement146,513.95146,477.350.2942 -36.60146,513.95 N/A146,513.95 ,792,750.36.294246.742,153.72,721,043.38,721,043.38 SR2009 Bond-Street Projects(II)1,721,043.38 104711 TOTAL LOGIC6,057,233.80,627,740.86,646.6672,153.72,057,233.80,057,233.80 61566 LONESTA R Capital Recovery - Sewer280,735.08280,671.970.2700 -63.11280,735.08 N/A280,735.08 Capital Recovery - Water1,153,445.16,153,185.85.2700 -59.31,153,445.16 N/A,153,445.16 10211 Drainage Fund283,457.26283,393.530.2700 -63.73283,457.26 N/A283,457.26 GO SR2011 Animal Shelter2,222,477.94,234,527.24.270002.292,551.59,222,477.94 N/A,222,477.94 205122 GO SR2011 Athletic Fields1,481,541.511,481,208.430.2700 -333.081,481,541.51 N/A1,481,541.51 GO SR2011 Soccer Fields1,410,758.05,440,550.55.270023.480,115.98,410,758.05 N/A,410,758.05 103311 GO SR2011 Swimming Pool2,933,583.552,938,607.070.2700660.715,684.232,933,583.55 N/A2,933,583.55 W/S-Customer Deposits293,986.4293,920.33.2700 -6.0993,986.42 N/A93,986.42 20622 W/S-Equipment Repl/Cap.Imp373,476.77373,392.810.2700 -83.96373,476.77 N/A373,476.77 Water&Sewer1,359,191.99,358,886.42.2700 -05.57,359,191.99 N/A,359,191.99 10311 W/S-Vehicle Replacement544,573.77544,451.340.2700 -122.43544,573.77 N/A544,573.77 69,400.01.27000.58-69,460.5969,460.59 Water/SSLG - SAWS269,460.59 20622 TOTAL LONESTA12,606,688.092,652,195.55,844.348,351.802,606,688.092,606,688.09 R12411 MBIA Tax I&S1,181,939.891,142,110.500.2400 -39,829.391,181,939.89 N/A1,181,939.89 Police Forfeiture359,466.6359,392.11.2400 -4.5259,466.63 N/A59,466.63 30733 Economic Development Corporation2,024,149.471,366,703.320.2400 -657,446.152,024,149.47 N/A2,024,149.47 Special Events Fund66,619.926,606.13.2400 -3.796,619.92 N/A6,619.92 60166 EMS Tax Notes 2010301,042.2400,979.74.24002.50-01,042.2401,042.24 30633 TOTAL MBIA3,933,218.153,235,791.80 -697,426.353,933,218.153,933,218.15 FEDERATED SR2007a Bond-City Wide Projects868,515.7268,363.95.2100 -51.7768,515.72 N/A68,515.72 80188 Hotel Occupancy Tax78,197.8578,184.190.2100 -13.6678,197.85 N/A78,197.85 Park Fund (Developers Fee)192,898.6892,864.97.2100 -3.7192,898.68 N/A92,898.68 10311 Park Fund (Tree Mitigation)126,355.69126,333.610.2100 -22.08126,355.69 N/A126,355.69 Tax I&S56.856.84.2100 -.016.85 N/A6.85 50055 Library Board Fund44,721.684,713.87.2100.81-4,721.684,721.68 40744 TOTAL FEDERATED1,310,746.471,310,517.43 -229.041,310,746.471,310,746.47 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,255,950.97,326,294.97.2400 286.61,636.24,331,644.60 N/A,355,198.37 13511 Capital One Capital Recovery1,610,342.36,733,834.05.080019.01364.54,733,688.52,710,740.20 13211 TOTAL CAPITAL ONE2,866,293.333,060,129.02 651.155,855.253,065,333.123,065,938.57 52 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 7% 9% 9% TOTAL FEDERATED TOTAL LOGIC 4% 19% TOTAL MBIA 12% TOTAL LONESTAR 40% 54 City Portfolio By Use Pooled-Daily Operations, Designated Funds, $2,938,213.18 $9,631,662.80 $10,907,380.74 Special Revenue Funds, Debt Service Fund, $7,144,523.64 $1,181,996.74 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.04000.08000.0500 1 Month T-Bill 0.01000.01000.02000.06000.08000.0700 3 Month T-Bill 0.06000.06000.06000.08000.13000.1500 6 Month T-Bill 0.46000.52000.49000.50000.52000.5300 Schertz Portfolio 0.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.30000.30000.3000 CD 180 Days 0.25000.25000.10000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.25130.28600.2942 LOGIC 0.23000.25000.28000.31000.26000.2700 LoneStar 0.14000.15000.19000.21000.25000.2400 MBIA 0.09000.14000.13000.15000.22000.2100 Federated 2.32432.84002.83003.07003.07003.1500 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:3/31/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69115,950.9715,950.9715,950.971.000.01 39,940.3339,940.33 JPMorgan Chase Disc Coml Paper9/21/2012174.0040,000.00 Total Cash & Equivalent5,950.955,891.35,891.3 s57050 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014865.00125,000.00141,987.30139,908.756,875.00 Federal Home Loan Bks Cons Bds6/21/2013447.0080,000.0082,004.4081,581.601,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151355.00100,000.00116,185.00114,435.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012200.00150,000.00162,031.50153,529.506,750.00 Federal Home Ln Mtg Corp Deb11/15/2013594.00170,000.00191,084.25182,632.708,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013542.00250,000.00250,000.00264,962.5010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014969.00100,000.0099,874.40100,514.00750.00 Federal Natl Mtg Assn 7/28/20151214.00125,000.00132,828.63131,895.002,968.00 US Treasury Note2/28/2014699.00100,000.0099,757.8299,868.00 Total Fixed Income1,200,000.001,275,753.301,269,327.054 Total Assets648.291,255,950.971,331,644.601,325,218.354 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69110,342.3610,342.3610,342.362.000.01 JPMorgan Chase Disc Coml Paper9/21/2012174.0080,000.0079,880.6779,880.67 Total Cash & Equivalent0,342.390,223.00,223.0 s96393 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014865.00165,000.00187,423.24184,679.559,075.00 Federal Home Loan Bks Cons Bds6/21/2013447.00100,000.00102,505.50101,977.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151355.00100,000.00116,185.00114,435.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012200.00250,000.00270,052.50255,882.5011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013594.00250,000.00281,006.25268,577.5012,187.00 Federal Natl Mtg Assn Nts10/15/2013563.00200,000.00223,001.60213,208.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014969.00220,000.00220,078.68221,130.801,650.00 Federal Natl Mtg Assn7/28/20151214.00135,000.00143,454.91142,446.603,206.00 /28/201499.0000,000.0099,757.819,868.00 US Treasury Not e2619 Total Fixed Incom,520,000.01,643,465.4,602,204.9 e109155 Total Assets682.301,610,342.361,733,688.521,692,427.985