Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
07-APRIL 2012 FINANCIAL STATEMENT
APRIL 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department May 31, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725463,609.52 8,522,419.70-9,785,359.95 - 2,018,365.05 Franchises 1,617,000 116,353.10 548,889.40- 857,645.86 - 759,354.14 Permits 1,187,800 65,872.00 1,236,710.83- 614,398.75 - 573,401.25 Licenses 48,300 5,612.50 40,910.60- 40,700.00 - Fees 3,324,727 223,828.78 1,666,564.36- 1,465,524.00 1,859,153.0050.00 Fines 30,000 1,881.49 14,917.56- 15,145.10 - 14,854.90 Inter-Jurisdictional 571,245 44,052.61 215,849.65- 350,841.06 - 220,403.94 Fund Transfers 1,760,658 108,750.59 697,426.29- 762,254.13 - 998,403.87 Miscellaneous615,50024,094.00258,720.11338,883.41(8.90) - TOTAL REVENUES20,958,9551,054,054.5913,202,408.5014,230,752.2641.10 - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,589.88 - 13,558.53 13,074.79 - Supplies 500 44.45 - 239.97 314.06 - City Support Services 17,500 718.22 219.98 12,932.87 1,635.08 30.45 Utility Services 2,837 - - - 1,193.79 - Operations Support 300 - - 127.40 - - Staff Support17,563572.742,150.00 10,418.6416,287.03633.27 Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 2,925.29 2,369.98 37,277.41 32,504.75 663.72 CITY MANAGE R Personnel Services852,20170,631.53 423,909.80-453,639.37 - 398,561.63 Supplies5,331 - 268.94 711.05 2,502.37 70.76 3,026.81 - - - - City Support Services - - Operations Support - - - 45.00 - - Staff Support 25,550 1,284.78 1,527.05 16,053.43 16,804.38 2,338.06 Operating Equipment -1,393.36 - - - - TOTAL CITY MANAGER 883,082 71,916.31 442,067.641,795.99 472,991.12 2,408.82 409,478.05 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 19,180.83 - 140,464.80 146,521.93 - 110,591.07 Supplies2,500 249.82 99.00 644.76 1,204.27 87.11 1,307.62 City Support Services1,000 - - - - - Operations Support 3,000 - 700.00 1,166.00 1,558.00 474.00 Staff Support 5,500 36.59 285.20 1,537.04 1,521.04 486.27 Court Support 800 - - - - - Professional Services 71,100 3,937.50 28,679.00- 31,528.75 12,906.25 Maintenance Services 2,200 50.00 - 600.00 399.94 - Operating Equipment1,000497.14 997.14500.0042.13 - TOTAL MUNICIPAL COURT 23,454.74344,213 1,581.34 173,591.60 183,731.07 13,995.76 148,067.51 CUSTOMER RELATIONS-311 Personnel Services109,618 8,113.58 - 48,112.40 55,964.89 - 53,653.11 Supplies300 28.65 - 49.84 150.61 24.64 124.75 Staff Support1,100 361.20 -611.20 - - Operating Equipment500 263.00- - - - TOTAL CUSTOMER RELATIONS-311 111,518 8,503.43 48,162.24- 56,989.70 24.64 PLANNING & ZONING Personnel Services 139,925 10,494.09 76,254.95- 79,058.52 - 60,866.48 Supplies 2,700 28.65 156.45 117.04 774.69 24.01 Operations Support 750 - - 77.95 - - Staff Support 17,150 38.50 548.55 3,232.12 1,759.35 43.06 Professional Services 76,650 1,366.40- 47,988.68 19,778.83 454.28 Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING240,67510,561.242,071.40128,725.74103,483.39521.35 LEGAL SERVICES Operations Support 13,000 - - 8,117.96 - - 13,000.00 Professional Services245,000621.59 190,565.6864,688.43 - - TOTAL LEGAL SERVICES 258,000 -621.59 72,806.39 190,565.68 - 67,434.32 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services648,323 45,121.36 - 364,451.43 336,054.75 - 312,268.25 Supplies57,100 6,145.74 1,224.76 39,409.79 39,314.54 7,974.67 11,035.55 Utility Services111,000 7,178.33 - 40,208.76 46,183.62 - 64,816.38 - - - - Operations Support - - Staff Support 11,179 972.22 41.35 6,684.29 7,112.68 754.20 Maintenance Services 106,450 13,339.37 673.05 77,468.38 58,399.47 6,776.07 Rental/Leasing 1,400 157.99 - 763.92 157.99 99.20 Operating Equipment2,500 289.451,702.332,074.63 - - Capital Outlay24,500 -2,524.53 - - - TOTAL FACILITIES MAINTENANCE 962,452 72,915.01 1,939.16 531,800.55 488,925.38 17,678.77 CITY SECRETAR Y Personnel Services 164,529 12,574.94 94,825.67- 93,364.70 - 71,164.30 Supplies 1,250 - - 1,049.97 750.69 - City Support Services 9,780 - - 3,440.00 1,902.20 - Staff Support8,605578.45 3,948.493,291.77342.99 - TOTAL CITY SECRETARY 184,164 13,153.39 102,607.41- 99,966.08 342.99 NON-DEPARTMENTA L Supplies 2,500 - - 395.35 10.71 - City Support Services 510,169 10,703.00 1,294.02 246,823.36 214,749.48 - 296,713.54 Operations Support 139,000 11,098.86 1,076.05 77,605.37 83,756.79 25.24 City Assistance 459,046 96,046.91 326,077.60- 288,140.73 - 170,905.27 Professional Services 174,650 9,318.67 79,567.90- 62,315.02 5,000.00 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,296,215 127,167.44 2,370.07 730,469.58 648,972.73 5,025.24 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services268,919 21,439.46 - 84,105.96 151,611.45 - 117,307.55 Supplies2,900 95.56 - 460.05 1,790.63 64.94 1,044.43 Operations Support35,100 1,096.25 4,989.75 8,949.03 10,665.66 407.21 29,016.88 Staff Support4,350 56.00 196.44 1,084.90 1,413.47 42.51 3,090.46 Operating Equipment300 -1,894.78 - - - TOTAL PUBLIC AFFAIRS 311,569 22,687.27 5,186.19 96,494.72 165,481.21 514.66 RECORDS MANAGEMEN T Personnel Services 47,850 3,560.60 26,531.90- 27,528.25 - 20,321.75 Supplies 750 - - 75.00 167.95 12.87 Staff Support 1,500 182.10 - 641.90 572.10 90.00 Professional Services 15,000 4,651.16 - 6,739.14 6,153.16 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 8,393.86 33,987.94- 34,421.46 102.87 SCHERTZ TALES MAGAZINE Personnel Services 129,161 9,986.56 70,675.87- 73,693.14 - 55,467.86 Supplies 200 - - - 45.00 - Opperations Support 200 - - - - - Staff Support 1,500 - - - 116.08 31.23 Professional Services302,70022,433.80127,878.17164,275.44 - - TOTAL SCHERTZ TALES MAGAZINE 433,761 32,420.36 198,554.04- 238,129.66 31.23 ENGINEERING Personnel Services 164,460 4,642.20 93,940.38- 43,062.98 - 121,397.02 Supplies 400 6.60 - 67.35 284.85 - City Support Services - - - - - - Utility Services 600 - - - 133.86 - Staff Support 2,213 - - 395.00 130.00 - Professional Services 48,165 5,703.75 15,337.50- 52,408.75 - (4,243.75) Maintenance Services 4,044 - - 2,745.24 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,000(399.00) 25,352.30- - - TOTAL ENGINEERING 245,882 9,953.55 112,485.47- 124,718.03 - 121,163.97 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 9,210.62 - 66,274.60 69,167.12 - 52,911.88 Supplies3,500 - - 1,113.00 951.02 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 9,210.62 67,387.60- 70,118.14 - 61,510.86 TOTAL GENERAL GOVERNMENT 5,529,760 413,884.10 17,314.13 2,776,418.33 2,910,998.40 41,310.05 PUBLIC SAFETY POLICE Personnel Services4,536,879 321,800.45 - 2,448,829.57 2,501,568.58 - 2,035,310.42 Supplies25,837 7,813.10 6,769.16 7,472.58 19,709.07 2,067.31 10,829.78 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 10,076.23 - 47,626.06 54,660.23 - 68,795.77 Operations Support1,500 400.00 - 98.00 1,120.00 400.00 (20.00) Staff Support57,148 11,149.36 1,732.17 5,867.23 23,143.33 7,550.00 28,186.84 City Assistance9,414 320.00 - 1,664.98 2,820.74 - Professional Services 19,500 100.00 - - 1,242.85 - 18,257.15 Maintenance Services 44,435 1,090.00 22,096.85- 31,628.23 - 12,806.77 Operating Equipment 67,231 3,685.24 4,945.10 31,735.12 35,809.61 19,858.91 Capital Outlay142,52512,554.80153,726.40155,076.05 - - TOTAL POLICE 5,062,925356,434.3826,001.232,719,116.792,846,297.1029,876.22 FIRE RESCUE Personnel Services 2,508,586 177,417.09 1,395,664.32- 1,464,402.54 - 1,044,183.46 Supplies 20,500 195.38 9,239.99 4,655.89 11,915.42 1,046.70 Utility Services 57,000 2,791.02 7.64 23,275.85 24,473.98 825.50 Operations Support 800 54.99 - 120.00 323.39 115.00 Staff Support 120,185 7,731.19 20,833.33 48,380.90 70,722.75 27,118.22 City Assistance 18,600 327.85 8,122.00 10,323.17 8,733.15 - 17,988.85 Professional Services 18,140 - - 1,500.00 12,148.19 - Maintenance Services 56,000 535.88 3,710.01 15,183.21 19,568.09 - 40,141.92 Operating Equipment58,300193.5815,553.04 26,615.3315,075.381,954.51 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 189,246.98 57,466.01 1,525,718.67 1,658,478.89 31,059.93 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 31,435.71 - 207,197.60 238,163.12 - 182,354.88 Supplies2,500 567.22 - 590.21 1,443.68 22.32 1,034.00 Utility Services6,500 485.43 - 2,670.09 2,607.19 - Operations Support 1,500 - - 439.87 44.00 - Staff Support 8,000 110.64 581.37 2,303.15 1,760.90 43.65 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 450,01832,599.00581.37213,200.92244,018.8965.97 MARSHAL SERVICE Personnel Services 534,355 34,198.59 250,527.94- 296,404.62 - 237,950.38 Supplies 4,600 396.23 205.82 166.30 1,880.38 29.95 Utility Services 12,000 1,220.71 - 3,878.55 6,535.32 - Operations Support 4,000 - - 367.49 1,072.41 - Staff Support 15,400 49.99 410.00 1,552.24 5,064.66 - 10,745.34 Professional Services - - - - - - Maintenance Services 30,700 280.00 - 7,453.85 2,214.00 - 28,486.00 Operating Equipment16,000 13,311.259,235.03 -2,206.37 - Capital Outlay34,000 31,022.0540,406.00 - - - TOTAL MARSHAL SERVICE 651,055 36,145.52 2,822.19 317,663.62 353,428.47 29.95 TOTAL PUBLIC SAFETY 9,057,109 614,425.88 86,870.80 4,775,700.00 5,102,223.35 61,032.07 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 43,851.58 - 339,807.41 385,685.42 - 294,671.58 Supplies7,100 844.96 21.04 2,945.83 3,609.77 522.94 2,988.33 Utility Services113,900 10,296.02 - 57,075.21 60,972.86 - 52,927.14 - - - - Operations Support - - Staff Support 10,265 1,593.09 79.91 4,036.42 4,195.59 265.66 Maintenance Services 270,800 13,378.48 579.71 92,248.30 98,991.86 10,435.95 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 4,200.00 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,82269,964.13680.66513,983.17556,941.4911,224.55 TOTAL PUBLIC ENVIRONMENT 1,086,822 69,964.13 680.66 513,983.17 556,941.49 11,224.55 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 35,977.02 - 270,102.14 275,977.72 - 230,892.28 Supplies40,555 1,951.56 1,169.51 19,685.06 20,385.76 2,043.42 19,295.33 Utility Services113,000 11,719.27 - 61,503.83 64,463.33 - 48,536.67 Operations Support700 - - 880.80 - - Staff Support 8,573 1,138.71 60.93 5,801.97 6,040.33 200.15 Professional Services 62,610 1,925.00 19,445.00- 33,023.07 - 29,586.93 Maintenance Services 22,000 270.84 44.99 10,637.15 13,449.00 142.79 Rental/Leasing 42,200 3,349.73 23,760.56- 19,731.26 22,950.79 Operating Equipment - - 6,197.93 - - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT796,50856,332.131,275.43418,205.00433,070.4725,337.15 SWIM POOL Supplies 16,700 5,493.17 392.93 4,970.18 6,020.57 166.52 Utility Services 25,500 1,020.28 - 6,354.72 9,223.75 - 16,276.25 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 1,095.00 4,000.00 4,780.77 12,085.93 669.20 Rental/Lease500104.00 104.00378.00104.20 - TOTAL SWIM POOL 7,712.45243,003 4,392.93 16,483.67 28,184.25 939.92 218,271.76 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services54,292 4,031.61 - 41,441.09 32,408.53 - 21,883.47 Supplies28,300 1,216.61 1,127.61 5,347.02 8,787.40 799.93 19,840.28 Utility Services47,550 2,815.92 - 16,403.84 17,543.43 - 30,006.57 Operations Support15,200 2,899.50 - 5,244.51 7,189.87 8.00 8,002.13 Staff Support3,300 113.00 439.45 250.00 1,008.76 - Professional Services 1,600 - 150.00 925.00 150.00 - Operating Equipment5,0004,243.88 6,589.58285.00 - - TOTAL COMMUNITY/CIVIC CNTR155,24211,076.645,960.9469,896.4673,677.57807.93 TOTAL PARKS & RECREATION 1,194,753 75,121.22 11,629.30 504,585.13 534,932.29 27,085.00 CULTURAL LIBRARY Personnel Services 692,531 51,253.51 386,347.98- 400,986.93 - 291,544.07 Supplies14,000 678.57 86.59 5,158.65 5,048.34 2,788.28 6,249.97 Utility Services41,000 3,029.58 - 21,843.74 20,872.04 - 20,127.96 Operations Support2,000 - 174.00 70.00 174.00 - Staff Support 4,215 401.37 58.97 998.46 1,488.95 24.57 Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 400.00 - 1,200.00 1,600.00 - Operating Equipment 75,000 6,264.41 2,366.43 33,497.42 43,261.70 11,713.13 Capital Outlay -- - - - - TOTAL LIBRARY 62,027.44833,246 2,685.99 451,181.25 475,571.96 14,525.98 345,834.05 TOTAL CULTURAL833,246 62,027.44 2,685.99 451,181.25 475,571.96 14,525.98 345,834.05 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 22,251.34 - 174,676.23 157,404.77 - 139,034.23 Supplies25,000 2,964.36 319.99 9,867.92 11,282.16 11,318.40 2,719.43 Utility Services11,200 1,147.61 - 5,413.47 5,724.02 - Operations Support 500 - - - - - Staff Support 11,560 1,422.73 34.48 1,602.00 5,202.05 687.12 City Assistance 10,000 2,677.85 - 5,831.96 8,062.58 - Professional Services 14,500 1,288.50 - 5,544.00 3,419.00 - 11,081.00 Maintenance Services 6,200 - - 1,926.78 3,825.00 220.50 Operating Equipment9,500 4,558.211,374.383,115.76 - - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES384,89931,752.39354.47209,420.57196,293.9615,341.78 TOTAL HEALTH 384,899 31,752.39 354.47 209,420.57 196,293.96 15,341.78 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 20,751.74 147,356.01- 162,007.76 - 98,024.24 Supplies2,000 257.38 - 439.01 326.22 - City Support Services 372,354 63,222.85 149,011.92- 195,834.12 249.75 Utility Services 154,949 9,800.26 1,585.17 69,447.24 77,582.20 29.99 Staff Support 15,250 1,034.56 2,036.38 3,285.68 8,371.77 2,296.96 Professional Services 2,500 - - - - - Maintenance Services 12,500 550.00 13,122.78- 6,513.36 795.00 Operating Equipment 129,315 5,407.06 4,911.44 45,297.50 43,626.12 17,543.18 Capital Outlay213,5007,266.00 7,266.00- - - TOTAL INFORMATION TECHNOLOGY1,162,400 108,289.85 8,532.99 427,960.14 501,527.55 20,914.88 648,490.56 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 29,349.05 - 123,960.48 143,169.43 8,018.12 145,562.45 Supplies1,329 - - 862.98 838.87 - Human Services 47,156 2,382.51 654.00 17,981.58 17,209.85 80.00 Operations Support 16,596 798.84 532.56 6,654.41 2,406.25 - 14,722.33 Staff Support 14,897 - 550.72 5,921.10 8,060.82 (55.00) City Assistance 9,860 904.00 - 3,240.00 4,179.50 - Professional Services - - - - - - Operating Equipment4,162.83 4,302.13- - - - TOTAL HUMAN RESOURCES 33,434.40386,588 5,900.11 158,620.55 180,166.85 8,043.12 204,278.16 FINANCE Personnel Services429,810 15,234.90 - 237,662.41 248,983.17 - 180,826.83 Supplies3,600 - - 1,915.44 2,191.93 - Operations Support 850 - - - 97.31 - Staff Support 15,805 1,734.35 - 5,642.61 5,408.02 706.50 Rental/Leasing 2,230 - - - - - Operating Equipment1,000266.47 266.47880.68 - - TOTAL FINANCE453,29516,969.25266.47246,101.14256,946.90706.50 PURCHASING & ASSET MG T Personnel Services 241,940 18,167.99 133,825.96- 138,284.43 - 103,655.57 Supplies800 152.86 - 268.70 385.31 - Utility Services 450 - - 185.42 331.63 - Operations Support 909 104.53 - 60.68 974.50 - Staff Support 9,600 - 65.00 3,254.27 3,841.20 200.00 Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 18,425.38 65.00 137,595.03 151,407.89 200.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 15,718.70 - 90,766.43 124,510.42 - 93,369.58 Supplies109,556 12,722.48 2,927.39 61,175.78 91,440.69 2,848.21 18,194.49 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 297.22 - 2,194.43 1,794.93 - Operations Support 400 - - 375.00 375.00 - Staff Support 3,835 787.66 620.41 1,083.73 2,011.70 27.44 Maintenance Services 65,724 674.41 1,685.29 23,524.84 24,599.80 1,713.92 Rental/Lease270 150.00269.80 - - - Operating Equipment5,000 780.164,931.79 - - - Capital Outlay -- - - - - TOTAL FLEET SERVICE411,36530,200.475,233.09181,550.37251,434.134,589.57 TOTAL INTERNAL SERVICE 2,674,938 207,319.35 19,997.66 1,151,827.23 1,341,483.32 34,454.07 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,000 31,500.0031,500.00 - - 10,500.00 TOTAL CITY ASSISTANCE52,000- 36,714.21-34,000.0010,500.00 COURT - RESTRICTED FUNDS Operating Equipment -- - - - 15,019.00 TOTAL CITY ASSISTANCE - - - 15,019.00- - TOTAL MISC & PROJECTS 52,000 - - 36,714 34,000 25,519 TOTAL EXPENDITURES20,813,5271,474,494.51 139,533.0110,419,829.8911,152,444.77230,492.50 REVENUE OVER(UNDER) EXPEND.145,4283,078,307.49 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 27,878.30 6,638,071.86- 6,809,849.97 - 74,604.03 000-411200Advalorem Tax - Delinquent 50,000 3,355.81 37,748.90- 41,437.67 - 000-411300Advalorem Tax - P&I 50,000 4,044.84 30,858.92- 32,058.47 - 17,941.53 000-411500Sales Tax Revenue-Gen Fund4,784,071 421,127.65 1,789,225.93- 2,881,034.68 - 1,903,036.32 000-411600Bingo Tax 2,200 - - 1,161.08 - - 000-411700Mixed Beverage Ta33,000.007,202.9225,353.0120,979.16 x - - TOTAL Taxes11,803,725 463,609.52 8,522,419.70- 9,785,359.95 - 2,018,365.05 Franchises 000-421200Center Point/Entex Energy 36,000 2,731.32 17,748.73- 23,493.47 - 12,506.53 000-421220City Public Service 330,000 23,354.61 118,313.65- 167,208.20 - 162,791.80 000-421240Guadalupe Valley Elec Co-op 440,000 32,515.58 186,840.44- 231,099.42 - 208,900.58 000-421250New Braunfels Utilities 55,000 4,736.88 - 5,633.66 27,143.75 - 27,856.25 000-421300Time Warner-State Franchise 345,000 29,633.84 81,908.40- 193,199.82 - 151,800.18 000-421350Time Warner-PEG Fee 65,000 - 16,370.38- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 14,306.99 45,445.16- 95,295.11 - 89,704.89 000-421465AT&T PEG Fees 26,000 - 5,834.61 7,247.95 000-421480Other Telecom Franchise 35,000 66.19 - 9,512.75 38,360.77 - (3,360.77) 000-421500Solid Waste Franchise Fee100,0009,007.6961,281.6258,557.87 - - TOTAL Franchises1,617,000116,353.10 548,889.40-857,645.86 - 759,354.14 Permits 000-431100Home Occupation Permit 500 - - 280.00 245.00 - 000-431200Building Permit - 1,003,594.83- - - - 000-431205Building Permit - Residential 600,000 31,038.00 - 235,347.00- - 364,653.00 000-431210Building Permit - Commercial 300,000 1,774.00 - 134,923.00- - 165,077.00 000-431215Building Permit - General - 62,105.00- - 7,919.00 - (62,105.00) 000-431300Mobile Home Permit 200 - - 80.00 40.00 - 000-431400Signs Permit 1,700 572.00 - 420.00 877.00 - 000-431500Food Establishmnt Permit 30,000 600.00 13,520.00- 10,825.00 - 19,175.00 000-431600Garage Sale Permit 8,600 1,320.00 - 5,845.00 5,400.00 - 000-431700Plumbing Permit 80,000 9,324.00 75,750.50- 67,986.75 - 12,013.25 000-431750Electrical Permit 55,000 3,380.00 49,860.00- 25,890.00 - 29,110.00 000-431800Mechanical Permit 59,000 4,480.00 53,880.00- 28,700.00 - 30,300.00 000-431900Solicitor/Peddler Permit 60.00 - 320.00 430.00 - - 000-431950Animal/Pet Permit 2,000 195.00 - 1,385.00 1,010.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800350.00 3,000.00- 5,800.00 - (2,000.00) 000-432100Security Alarm Permit42,000 4,110.00 - 23,438.00 29,620.00 - 12,380.00 000-435000Fire Permit5,000750.00 5,200.005,337.50 - - TOTAL Permits 65,872.001,187,800 - 1,236,710.83 614,398.75 - 573,401.25 Licenses 000-441000Alcohol Beverage License 6,300 1,252.50 - 2,782.50 3,215.00 - 000-442000Contractors License 39,000 4,025.00 35,565.00- 34,805.00 - 000-444000Pet License3,000335.00 2,680.002,563.10 - - TOTAL Licenses 48,300 5,612.50 40,910.60- 40,700.00 - Fees 000-451000Municipal Court Fines 1,665,009 93,597.75 633,588.61- 663,312.95 - 1,001,696.05 000-451100Arrest Fee 50,694 4,206.91 26,591.19- 31,004.18 - 19,689.82 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 10,444.00 75,590.79- 81,341.00 - 110,659.00 000-451210Court - Claims & Judgements 434.57 - - 1,842.60 - - (1,842.60) 000-451320Civil Justice Fee-Court 75 6.53 39.58 47.96 - 000-451321Civil Justice Fee-State 58.67 - - 431.98 - - 000-451340Judicial Fee - City 6,826 553.78 - 3,548.82 4,125.89 - 000-451400Traffic Fine Costs TTL 25,984 2,162.17 13,356.54- 15,874.82 - 10,109.18 000-451500Teen Court Admin Fee 260 40.00 - 220.00 400.00 - 000-451510Juvenile Case Mgmt Fee 55,896 4,614.95 29,587.83- 34,412.53 - 21,483.47 000-451600Technology Fund Fee 45,601 3,760.68 24,061.07- 27,748.07 - 17,852.93 000-451700Security Fee 34,220 2,820.52 18,054.81- 20,811.11 13,408.89 000-451800Time Payment Fee - City 7,336 507.31 - 3,749.65 3,263.05 - 000-451850State Fines 10% Service Fee 72,470 19,768.75 49,510.11- 48,016.77 - 24,453.23 000-451900DPS Payment - Local 11,858 783.87 - 6,318.08 6,440.40 - 000-452000Child Safety Fee 12,243 2,879.47 - 6,730.42 17,854.15 - (5,611.15) 000-452050Indigent Defense Fee 21,655 1,819.55 11,406.32- 13,295.41 - 000-452100Platting Fees 98,000 4,500.00 39,000.00- 43,000.00 - 55,000.00 000-452200Site Plan Fee 74,000 1,500.00 16,500.00- 16,500.00 - 57,500.00 000-452300Plan Check Fee 465,000 19,639.00 507,816.91- 171,886.00 - 293,114.00 000-452310Miscellaneous Review Fee 13,500 300.00 - - 5,700.00 - 000-452320Tree Mitigation Admin Fee 10,500 357.75 - - 3,095.25 - 000-452400BOA/Zoning Fees 4,000 - - 1,400.00 3,250.00 - 000-452500Food Handler Class 7,000 130.00 - 4,760.00 2,200.00 - 000-452520Fire Training Classes 400 - -- - - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452600Specific Use/Zone Chng Fee20,000650.00 11,000.00-24,500.00 - (4,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 450.00 - 300.00 1,500.00 - 000-453100Reinspection Fees 30,000 4,650.00 25,650.00- 24,400.00 - 000-453110Swim Pool Inspection Fee - - 825.00 - - - 000-453200Mowing Fees - Inspections 12,000 345.75 10,970.60- 1,506.58 - 10,493.42 000-453211Admin Fee-Inspections 7,480 800.00 - 4,300.00 4,540.00 - 000-453310Misc Inspection Fee - - 40.00 19.49 - - 000-453710Foster Care 500 50.00 - 600.00 500.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 6,984.73800 - - 6,984.73 - (6,184.73) 000-456510Fire Plan Review 3,000 - - - - 000-456600Fire Re-inspection Fee 180 50.00 - 650.00 500.00 - 000-458100Sale of Merchandise - - - - - - 000-458300Sale of Property/Auction 22,000 11,366.65 - 2,446.09 21,525.45 - 000-458400Civic Center Rental Fees 171,000 7,047.00 70,217.75- 59,635.50 100.00 000-458401Capital Recovery Fee-Civic Cntr 7,500 625.00 - 1,060.00 3,500.00 - 000-458450North Center Rental Fees 15,000 1,925.00 - 5,187.00 13,132.92 - 000-458500Community Center Rental Fees 18,000 3,738.90 - 9,529.02 17,342.49 - 000-458550Pavilion Rental Fees 18,500 2,940.00 10,316.70- 9,914.50 (50.00) 000-458560Chamber of Comm rent 11,700 1,950.00 - 5,850.00 5,850.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 -- 4,411.84 - 1,216.12 - (4,411.84) 000-458670SYSA Utility Reimbursement - - 4,926.73 - 1,414.30 - (4,926.73) 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 - 255.00 192.00 - 000-459400Maps, Copies, UDC, & Misc F 400 - - 255.00 58.10 - 000-459600Animal Adoption Fee 15,000 609.00 - 6,666.50 6,580.00 - 000-459700Pet Impoundment Fee 15,000 1,505.00 12,481.01- 8,372.25 - 000-459800Police Reports Fee6,500589.10 3,492.303,524.20 - - TOTAL Fees 223,828.783,324,727 - 1,666,564.36 1,465,524.00 50.00 1,859,153.00 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0001,881.4914,917.5615,145.10 - - TOTAL Fines30,0001,881.49 14,917.56-15,145.10 - 14,854.90 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 23,486.82- 23,486.82 - 16,776.18 000-473300Guad Co - Library 180,000 - 105,476.00- 95,407.98 - 84,592.02 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,300.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 33,326.25 66,652.90- 99,978.75 - 33,326.25 000-474600School Crossing Guard-Bexar6,6003,867.99 3,927.9316,979.40 - -(10,379.40) 000-474610School Cross Guard-Guadalupe 7,980.0819,862.19 -3,503.11 - -(19,862.19) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional571,24544,052.61 215,849.65-350,841.06 - 220,403.94 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 51,240.00- 51,240.00 - 36,600.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 99,295.58- 83,198.50 - 59,427.50 000-481000Transfer From Reserves 355,000 - - - - - 355,000.00 000-482100Transfer From Reserves-Ct Tech15,000 - - - - 15,000.00 000-482150Transfer From Court Security 29,006 - - - 29,006.00 000-485000Interfund Charge-Drainage 35,480 3,486.25 22,635.50- 24,403.75 - 11,076.25 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 364,453.25- 514,046.19 - 367,175.81 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 52,094.58- 57,449.00 - 41,035.00 000-488000Interfund Charges-4B 53,000 4,416.67 32,335.33- 30,916.69 - 22,083.31 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 108,750.59 697,426.29- 762,254.13 - 998,403.87 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 36.12 - 1,527.59 188.41 - 000-491200Investment Income 30,000 4,545.17 20,473.35- 28,310.44 - 000-491800Gain/Loss - - - 443.67 - - 000-491900Unrealized Gain/Loss (626.20) (14,362.50)- (17,604.00) - - 17,604.00 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. 75.00 24,587.00- 4,981.34 - - (4,981.34) 000-493400Donation - Animal Control 1,200 241.00 - 2,645.26 2,367.01 - (1,167.01) 000-493401Donations-A/C Microchip 500 115.00 - 1,465.00 1,125.00 - 000-493402Donations-Spay&Neuter 13,500 832.50 - 9,905.32 7,328.00 - 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 (15,723.23) (18,416.53)- 24,394.99 (8.90) 000-497005Misc Income-Publications 290,000 20,381.00 89,442.10- 119,924.00 - 170,076.00 000-497007Misc Income-Schertz Artz - - - 20.00 - - 000-497100Misc Income-Police 25,000 4,083.00 14,906.13- 6,994.25 - 18,005.75 000-497200Misc Income-Library 19,000 248.50 16,995.50- 2,201.94 - 16,798.06 000-497210Misc Income-Library Copier 13,500 776.30 6,169.65 7,683.11 - 000-497300Misc Income-Animal Control 500 - - 989.30 105.00 - 000-497400Misc Income-Streets Dept. 20,000 1,525.00 - 9,500.00 9,157.48 - 10,842.52 000-497500Misc Income-TML Insurance 78,000 76.70 49,728.90- 76.70 - 77,923.30 000-497550Misc Income-TML Reimbursemt20,000 4,981.70 22,447.21- 13,148.56 - 000-497600Misc Income-Parks/Vending Mach.2,500 99.75 -1,202.59960.10 - 000-498000Reimbursmnt-Gen Fund5,0001,856.81 1,749.5923,908.83 - -(18,908.83) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA 569.88 - 4,925.36 1,139.75 - - (1,139.75) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 38,143.218,078.07 - - - TOTAL Miscellaneous 615,500 24,094.00 258,720.11- 338,883.41 276,625.49(8.90) TOTAL REVENUES20,958,9551,054,054.59 13,202,408.50-14,230,752.26 6,728,161.6441.10 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking328,517.41$ Cash in Investments LOGIC Investment-General Fund3,610,093.78 LOGIC Investment-Equip Replacement73,399.60 LOGIC Investment-Veh Replacement7,084.60 LOGIC Investment-Air Condi Replacment146,548.44 CAPITAL ONE Investment-General Fund1,337,905.25 Total Cash in Bank & Investments$5,625,799.34 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 2011-12 1,406,160 244,255 2,331,487 1,725,242 735,329 174,687 37,341 43,108 15,120 26,143 13,773 5,356 2010-11 1,277,006 1,642,355 702,874 1,730,904 562,689 (32,792) 59,545 34,762 19,836 29,955 5,346 3,535 2009-10 703,350 1,823,090 757,602 1,345,602 699,462 114,537 10,514 45,087 36,659 25,468 13,593 21,472 2008-09 993,926 1,293,621 615,170 1,462,883 310,479 74,418 17,900 44,799 19,066 24,241 6,294 10,447 2007-08 Sales Tax - General Fund $600,000 $500,000 40% -2% 25% 17% 12% 23% $400,000 -2% $300,000 $200,000 $100,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 428,995 463,636 339,192 415,822 461,400 365,083 347,395 2011-12 339,709 332,264 347,605 353,229 470,399 324,575 283,300 425,848 408,664 342,513 453,063 385,230 2010-11 300,384 338,514 281,259 288,350 477,063 293,178 273,874 366,704 350,314 324,169 419,127 402,804 2009-10 332,597 414,845 371,763 300,829 434,646 298,499 282,410 394,233 317,296 310,159 373,041 315,947 2008-09 336,749 350,854 312,547 327,798 421,873 330,131 287,316 355,054 336,094 328,147 360,965 338,085 2007-08 278,463 305,857 266,440 281,920 358,831 236,723 250,774 319,604 300,214 306,696 382,743 298,203 2006-07 CITY PUBLIC SERVICE $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 96,392 76,414 - - 2011-12 83,433 62,692 67,561 95,887 2010-11 77,354 61,468 63,276 80,716 2009-10 77,308 53,071 57,506 83,329 2008-09 55,729 50,340 48,120 86,572 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET58.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 30,461.91- 22,951.06 - - 5,048.94 TML Dinner - - 194.69 - - - (194.69) Hal Balwin Scholarship 24,000.00 23,525.00- 10,602.00 - - 13,398.00 Miscellaneous175.0010,680.50- 788.99435.95 - TOTAL REVENUES114,275.00 10,680.50 - 54,422.86 34,536.74 - 79,738.26 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 - - 182.64- - 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 30,461.91- 3,880.00 - - 27,620.00 Blue Santa - - - - - - TML Events - - 194.69- - - Schertz Sweetheart 37,000.00 8,240.52 27,750.50- 13,904.83 2,133.00 Hal Baldwin Scholarship11,000.00-8,298.461,000.00 - -10,000.00 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 8,240.52103,600.00 218.05 79,682.48 32,053.34 2,560.33 69,204.38 TOTAL EXPENDITURES108,750.00 8,240.52 218.05 79,682.48 32,053.34 2,560.33 74,354.38 REVENUE OVER(UNDER) EXPEND5,525.002,483.40 SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking29,297.10$ Cash in Investments MBIA Special Events66,633.73 Total Cash in Bank & Investments$95,930.83 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 110-PEG FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises - 23,009.77- - - - (23,009.77) Miscellaneous- 12.49- - - - TOTAL REVENUES - - - 23,022.26 - (23,022.26) - EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental- -- - - - TOTAL GENERAL GOVERNMENT - - - - - - - TOTAL EXPENDITURES - - - - - - - REVENUE OVER(UNDER) EXPEND23,022.26 - PEG FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Cash Balance317,189.43$ Total Cash in Bank & Investments$317,189.43 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,00043,321.16 164,765.87-121,765.07 58,234.93- Fees14,164,2501,178,359.74 7,615,480.71-8,440,484.95 5,723,765.05- Fund Transfers484,6747,056.17 47,026.00-49,393.19 435,280.81- Miscellaneous5,582.01267,821.28225,975.16 103,260 - - TOTAL REVENUES14,932,1841,234,319.088,095,093.868,837,618.37 - - EXPENDITURE SUMMARY NON DEPARTMENTAL Fund Charges/Transfers31,000.00- 27,366 - - - TOTAL NON DEPARTMENTAL31,000- 27,366 - - -27,366.00 BUSINESS OFFICE Personnel Services383,89425,773.99 244,259.69-202,444.95 181,449.05- Supplies5,40083.96418.331,361.992,363.6685.97 Human Services100----40.00 Operations Support114,00013,071.12 38,144.81-62,886.35 51,113.65- Staff Support7,100486.5094.261,370.863,000.61- Professional Services16,0001,550.36395.007,206.5011,726.77- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300--3,080.004,440.001,420.00 Operating Equipmen500.006,117.625,932.94 t 6,200 - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE40,965.931,407.59301,541.47292,795.281,545.97 603,994 W & S ADMINISTRATION Personnel Services1,184,89868,281.76 711,274.40-618,987.46 565,910.54- Supplies200,7005,083.904,458.8190,659.6694,669.585,552.38 Human Services1,000--64.00-40.00 City Support Services108,999- 34,899.05-34,379.59 74,619.41- Utility Services2,634,344243,160.74 1,105,825.47-1,470,469.81 1,163,874.19- Operations Support8,750256.01-1,906.702,043.93- Staff Support33,0001,809.95294.5412,340.0710,984.691,205.19 City Assistance1,912--251.00297.00- Professional Services187,40014,110.10 114,457.55-66,326.54 121,073.46- Fund Charges/Transfers2,623,507183,675.97 1,344,126.96-1,498,432.96 1,125,074.04- Maintenance Services5,522,250485,507.4712,287.432,762,952.883,057,527.1531,517.16 Other Costs35,000- 28,911.85-30,956.44- C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353- 562,692.28-96,868.35 1,133,484.65- Rental-Leasing6,070372.07-662.532,888.75- Operating Equipment8,0003,463.80 13,783.09-3,463.80- Capital Outla30,225.40112,225.401,381.26 y 114,000 -132,061.40 -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,1831,035,947.1717,040.78 7,100,521.456,916,868.89 39,695.99 6,777,006.34 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-41,348.45- 49,750.79- Maintenance Services303.28 - 334,500 - - - 41,651.73- 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.7972,048.2773,084.37 400,000 -328,666.42 TOTAL EXPENDITURES14,931,5431,076,93120,1997,321,4597,466,40141,242 ** REVENUE OVER(UNDER)EXPENSES **1,371,217.27 641 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 43,321.16164,765.87121,765.07 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 43,321.16 164,765.87- 121,765.07 - 58,234.93 Fees 000-455200Garbage Collection Fee 3,400,000 291,725.63 1,853,681.97- 2,032,054.87 - 1,367,945.13 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,564.62 119,317.03- 146,600.85 - 94,399.15 000-455800W&S Line Constructn Reimbursemnt50,000 1,290.00 17,889.92- 14,972.83 - 35,027.17 000-457100Sale of Water 7,210,000 593,778.29 3,763,767.18- 4,239,762.45 - 2,970,237.55 000-457110Edwards Water Lease 166,250 - 153,410.82- 41,585.85 - 124,664.15 000-457120Water Transfer Charge-Selma 5,000 4,103.52 - 1,339.20 17,761.47 - (12,761.47) 000-457130Water Transfer Charge-U. C. 1,000 - - 1.28 2,199.97 - (1,199.97) 000-457200Sale of Meters 90,000 3,941.40 50,598.32- 30,099.40 - 59,900.60 000-457400Sewer Charges 2,800,000 249,642.55 1,541,193.61- 1,792,838.90 - 1,007,161.10 000-457500Water Penalties 180,000 12,933.73 94,525.90- 101,108.36 - 78,891.64 000-459200NSF Check Fee-Water&Sewer2,000380.001,325.481,810.00 - - TOTAL Fees14,164,2501,178,359.74 7,615,480.71-8,440,484.95 - 5,723,765.05 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1747,026.00 49,393.19 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 47,026.00- 49,393.19 - 435,280.81 Miscellaneous 000-490000Misc Charges 10,000 - - 4,331.88 208.05 - 000-491000Interest Earned 1,000 147.64 - 1,128.31 1,129.39 - 000-491200Investment Income 6,000 625.27 7,451.85 7,388.16 - (1,388.16) 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 - (390.15) 30,195.06 -4,809.10 - (30,195.06) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 - 76,314.75- 51,804.50 - 24,510.50 000-498200W&S Project Reimbursement41,193.30 - - - - - TOTAL Miscellaneous 103,260 5,582.01 267,821.28- 225,975.16 - (122,715.16) TOTAL REVENUES14,932,1841,234,319.08 8,095,093.86- 8,837,618.37 - 6,094,565.63 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking56,448.03$ Cash in Investments Lone Star Investment-Water&Sewer1,359,491.16 Lone Star Investment-W&S Customer Deposits294,051.13 Lone Star Investment-W&S Equip Replacement373,558.98 Lone Star Investment-W&S Veh Replacement544,693.64 Lone Star Investment-Water/SSLGC SAWS269,519.90 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,897,223.43 Total Cash in Bank & Investments3,953,671.46$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 256,044.08 1,687,558.50- 1,865,362.93 2,223,671.27(101.20) Inter-Jurisdictional1,438,836 301,347.69 1,013,959.52- 1,027,903.89 410,932.11- Miscellaneous14,053.80-65,386.4957,816.77 256,000 - TOTAL REVENUES 571,445.57 - 2,766,904.51 2,951,083.59 (101.20) 2,832,786.61 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891191,146.00 1,559,390.8068.001,545,442.43 1,041,505.5711.00 Supplies 23,773.24 13,149.22 164,690.04 202,772.61 29,923.31 324,039 Human Services - 580.00 - 800 - - City Support Services 10,974.19- 10,277.40 31,505 - - 21,227.60 Utility Services 10,462.52 10.41 51,892.60 56,950.00 55,545.4115.00 112,500 Operations Support 1,964.67 364.65 32,900.27 34,714.36 265.00 45,600 Staff Support 5,566.77 449.08 32,945.95 39,980.99 12,699.22 72,400 City Assistance 364.50 - 5,497.00 4,450.00 9,000 - 4,550.00 Professional Services 23,594.17 133.00 72,991.84 78,455.23 3,298.59 164,200 Fund Charges/Transfers2,084,785 10,191.98 567,341.58- 671,318.47 - 1,413,466.53 Maintenance Services 1,650.00 20,369.91- 32,295.52 1,410.00 37,700 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 122.62 820.75 13,427.14 41,274.63 579.99 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 268,836.47 14,995.11 2,604,482.85 2,723,794.64 48,202.11 2,956,594.36 5,713,596 TOTAL EXPENDITURE268,836.4714,995.112,604,482.852,723,794.64 S 5,713,596 48,202.11 ** REVENUE OVER(UNDER) EXPENSES 227,288.95 * 70,173 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 251,659.08 - 1,624,678.50 1,806,485.93 - 2,012,247.07 47.31% 000-456110Subscription Program Fees55,000 185.00 - 18,340.00 17,770.00 32.31% - 37,230.00 000-456120EMT Class - Fees95,200 4,200.00 - 44,540.00 37,881.00 (101.20) 57,420.20 39.68% 000-459200Paramedic Class Fees120,000 - - - - - 120,000.00 000-456130Immunization Fees - 3,226.00- - - - (3,226.00) 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933256,044.08 1,687,558.50- 1,865,362.93 2,223,671.27(101.20) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.88 - 191,850.89 166,907.16 - 119,218.84 000-474300Cibolo Support 222,018 55,524.98 159,975.00- 166,574.94 - 55,443.06 000-475100Comal Co ESD #6 82,875 6,908.83 37,920.00- 48,361.79 - 34,513.21 000-475200Live Oak Support 148,125 40,082.38 111,093.75- 120,247.14 - 27,877.86 000-475300Universal City Support 226,168 56,562.83 153,309.39- 170,538.49 - 55,629.51 000-475400Selma Support 16,910.8567,618 51,547.50- 50,732.55 - 16,885.45 000-475500Schertz Support 384,046 96,046.91 290,594.61- 288,140.73 - 95,905.27 000-475600Santa Clara Support 2,213.068,849 - 7,901.01 6,639.18 - 2,209.82 000-475800Marion Support13,0113,253.979,767.379,761.91 - - TOTAL Inter-Jurisdictional1,438,836301,347.69 1,013,959.52- 1,027,903.89 410,932.11- Miscellaneous 000-491000Interest Earned--- 0.00% - - - 000-491200Investment Income 62.47 - 370.84 356.98 - - 000-493203Donations-EMS 6,000 - 1,300.00 695.00 - - 5,305.00 000-493204Donations-Dilworth Fund - 1,000.00 - 0.00% - - - 000-493205Donations- Golf Tournament - 350.00 3,260.00 -3,160.00 - (3,260.00) 000-497000Misc Income 150,000 10,526.33 53,243.24- 50,446.51 - 99,553.49 000-497100Recovery of Bad Debt100,000305.009,122.413,058.28 - - TOTAL Miscellaneous256,00014,053.80 65,386.49-57,816.77 - 198,488.23 TOTAL REVENUES5,783,769571,445.57 2,766,904.51- 2,951,083.59 2,833,091.61(101.20) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank $ (423,246.64) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,104.71 $(122,141.93) Total Cash in Bank & Investments C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60061,203.60 402,648.35- 436,921.47 -272,678.53 Fund Transfers - - - - - - - 0.00% Miscellaneous900720.62525.01 75.72 - - TOTAL REVENUES 61,279.32710,500403,368.97 -437,446.48273,053.52 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40423,520.68 209,774.87- 190,742.53 -183,661.47 Supplies 8,300 666.34 - 747.60 1,554.39 133.59 Human Services 325 - - - - -325.00 City Support Services 22,165 - 4,332.18 1,508.72 - -20,656.28 Utility Services 24,188 2,319.45 - 6,299.19 10,932.66 -13,255.34 Operations Support 2,460 - - - - -2,460.00 Staff Support 1,078.728,305 43.02 2,317.84 2,322.53 917.71 City Assistance 840 15.00 - 15.00 72.00 -768.00 Professional Services 20,698 4,423.75 10,000.00- 12,381.25 -8,316.75 Fund Charges/Transfers 199,87611,785.92 76,162.75- 82,501.44 -117,374.56 Maintenance Services 22,000 - 1,987.00 - - -22,000.00 Other costs 100 - 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 43,809.86701,72543.02313,655.21 1,051.30303,747.59396,969.13 TOTAL EXPENDITURE 43,809.86701,72543.02313,655.21 1,051.30303,747.59396,969.13 S ** REVENUE OVER(UNDER) EXPEND8,775133,698.89 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 2,493.62 3,036.42 4,000 451.79 -963.58 000-457600Drainage Fee 60,751.81-400,154.73433,885.05 -271,714.95 705,600 TOTAL Fees61,203.60 402,648.35-436,921.47 272,678.53- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 186.32 49.04 100 8.71 - 000-491200Investment Interest - 400.38 439.01 600 62.39 -160.99 000-497000Misc Income-Drainage-133.9236.96 200 4.62 - TOTAL Miscellaneous - 720.62 525.01 900 75.72 -374.99 TOTAL REVENUES61,279.32 403,368.97- 437,446.48 273,053.52- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 197,991.48 Cash in Investments Lone Star Investment-Drainage Maint Fund283,519.65 Total Cash in Bank & Investments$481,511.13 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 42,395.08 122,607.68- 204,441.22 -186,312.78 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50023.39-250.07153.26 - TOTAL REVENUES 42,418.47411,386-122,857.75204,594.48206,791.52 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 819.90 1,826.50 - -886.50 City Support Services 12,907.0085,948 44,173.85- 49,564.00 -36,384.00 Operations Support 74,000 346.04 6,452.88 15,247.54 118.77 - Professional Services 2,500 - - - - -2,500.00 Fund Charges/Transfers 193,876 11,885.50 99,295.58- 83,198.50 -110,677.50 Operating Equipment 52,562 15,809.58- 2,500.00 - 6,645.00 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 24,792.50411,3867,204.04150,742.21165,646.12250,325.15 L 2,618.77 TOTAL EXPENDITURE 24,792.50411,3867,204.04150,742.21165,646.12250,325.15 S 2,618.77 38,948.36 REVENUE OVER(UNDER) EXPENDITURE - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 42,395.08122,607.68204,441.22 -186,312.78 - TOTAL Taxes 390,754 42,395.08 122,607.68- 204,441.22 - 186,312.78 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned30011.04-165.2969.10 - 230.90 000-491200Investment Interest 200 12.35 - 84.78 84.16 - 115.84 000-497000Misc Income-- - - - - - TOTAL Miscellaneous50023.39-250.07153.26 - 346.74 TOTAL REVENUES 411,386 42,418.47 122,857.75- 204,594.48 - 206,791.52 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking262,255.98$ Cash in Investments Federated Investment-Hotel/Motel78,210.20 Total Cash in Bank & Investments$340,466.18 ôíè÷ð íùùçìûîùã èûä $60,000 $50,000 $40,000 $30,000 $20,000 $10,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 33,128 32,675 32,143 35,829 36,215 45,071 2011-12 27,689 25,112 23,231 19,619 22,667 36,728 28,215 34,157 45,854 53,433 42,181 32,294 2010-11 23,625 22,026 20,768 19,924 23,169 33,638 26,531 32,368 36,676 46,069 36,697 26,655 2009-10 17,549 20,134 18,461 17,255 15,138 19,297 19,548 24,769 29,695 32,336 37,633 45,428 2008-09 19,122 21,531 20,663 19,204 17,475 20,760 25,081 24,748 23,122 26,866 30,247 26,313 2007-08 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,000 107,000.00- 105,875.00 1,300.00 -144,125.00 Tree Mitigation Fees 75,000 - 17,539.75- 2,027.25 -57,460.25 Miscellaneous600-418.22394.82 54.35 - TOTAL REVENUES 3,381.60325,600-107,418.22123,809.57201,790.43 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - - - -13,000.00 Maintenance Services-Landscape 3,500 12,234.00- 135.88 - -3,364.12 Operating Equipment 12,600.0032,000 53,203.80- 20,737.20 7,417.72 Capital Outlay169,000 10,000.00--68,873.45100,126.55 - TOTAL PARKLAND DEDICATION 22,600.00217,500-65,437.8089,746.53120,335.75 7,417.72 TREE MITIGATION Maintenance Services-Trees28,500 18,171.00- 3,123.00 500.00 24,877.00 12.71% 2,365.00 Capital Outlay18,000 ---19,900.00 - TOTAL TREE MITIGATION 2,365.0046,500-18,171.0023,023.00 500.00 TOTAL EXPENDITURE 24,965.00264,000-83,608.80112,769.53143,312.75 S 7,917.72 REVENUE OVER(UNDER) EXPEND 11,040.0461,600 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,000 1,300.00 107,000.00- 105,875.00 144,125.00- 000-458900Tree Mitigation 2,027.2575,000- -17,539.75 - TOTAL Fees 325,000 3,327.25 107,000.00- 123,414.75 - 201,585.25 Miscellaneous 000-491000Interest Earned 100 3.94 - 167.14 15.19 84.81- 000-491200Investment Interest 500 50.41 - 251.08 379.63 120.37- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60054.35-418.22394.82 205.18- TOTAL REVENUES 325,600 3,381.60 107,418.22- 123,809.57 201,790.43- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$83,484.41 Cash in Investments Federated Investment-Park Fund192,929.14 Federated Investment-Tree Mitigation126,375.64 Total in Investment Pool 319,304.78 Total Cash in Bank & Investments$402,789.19 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: ARPIL 30th, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 106,974.00 1,592,042.86- 846,981.72 -1,878,418.28 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 4,044.34200,225.34230,211.16 - - TOTAL REVENUES13,713,000 111,018.341,792,268.20 -1,077,192.8812,635,807.12 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 352.59 - 2,111.54 2,768.03 -19,231.97 Maintenance Services 10,000 - - - - -10,000.00 Fund Charges/Transfers - - - - 0.00% - - Debt Service - - 108,671.00- - -(108,671.00) Capital Outlay8,428.00- - - - - TOTAL NON DEPARTMENTA38,000 352.5910,539.54111,547.53 L - - MISC & PROJECTS Projects13,025,000 35,663.25-70,106.7810,488.42 -13,050,174.83-0.19% Schaefer RD Water Improvements 599,6433,075.00-3,075.00 - -596,568.00 Northcliffe Elevated Tnk-- 0.00% - - - - Northcliffe Water Plant-- 0.00% - - - - Town Creek Project-- 0.00% - - - - Live Oak Water Plant- 0.00% - - -204,531.74 - Loop Feed Water Line-- 0.00% - - - - viation Heights WTR IMP344,233.90- A - - - - TOTAL MISC & PROJECTS13,624,643 3,075.0035,663.25618,872.4213,563.4213,646,742.83 - TOTAL EXPENDITURE13,662,643 3,427.5935,663.25629,411.96125,110.9513,573,195.30 S - REVENUE OVER(UNDER) EXPENDITURES50,357 952,082 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: ARPIL 30th, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 55,746.00 944,231.74- 538,152.00 -941,448.00 000-455910Capital Recovery - Waste Wtr613,800 45,828.00 647,211.12- 285,429.72 -328,370.28 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 5,400.00600.0023,400.00 - - TOTAL Fees 2,725,400106,974.00 1,592,042.86- 846,981.72 -1,878,418.28 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 Earned50040.14-331.60191.71 - 000-491200Investment Income 30,000 4,803.60 22,229.36- 29,839.34 - 000-491800Gain/Loss - - (554.28) - - - 000-491900Unrealized Gain/Loss-Cap One (16,877.28)- (19,265.61) - (799.40) -19,265.61 000-497000Misc Income - - - 0.00% - - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 29,166.66- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -165,375.00- - - TOTAL Miscellaneous 314,000 4,044.34 200,225.34- 230,211.16 73.32% -83,788.84 TOTAL REVENUES13,713,000 111,018.34 - 1,792,268.20 1,077,192.88 7.86% -12,635,807.12 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: ARPIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking966,726.50$ Cash in Investments Lone Star Investment-Capital Recovery Water1,153,699.05 Lone Star Investment-Capital Recovery Sewer280,796.87 Capital One-Investment1,714,076.13 Total Cash in Bank & Investments4,115,298.55$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 21,225.564,281,098 - 3,360,279.03 4,242,809.93 99.11% -38,288.07 - - - - 0.00% Fund Transfers - - Miscellaneous 2,022.492,25015,177.2714,175.94 - - TOTAL REVENUES 23,248.054,283,3483,375,456.30 -4,256,985.87 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL - - 350.00 36,210.39 Professional Services - -(36,210.39) Debt Service -4,276,6672,558,340.59 -3,074,924.521,165,531.59 - TOTAL GENERAL GOVERNMEN -4,276,6672,558,690.59 -3,111,134.911,165,531.59 T - TOTAL EXPENDITURE -4,276,6672,558,690.59 -3,111,134.911,165,531.59 S - ** REVENUE OVER(UNDER) EXPEND6,682 1,145,850.96 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 21,225.563,360,279.034,242,809.93 - - TOTAL Taxes4,281,09821,225.56 3,360,279.03-4,242,809.93 - 38,288.07 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 - 14,411.81- 27.89 - 000-491200Investment Earnings1,5002,022.49765.46 14,148.05 - - TOTAL Miscellaneous 2,250 2,022.49 15,177.27- 14,175.94 - (11,925.94) TOTAL REVENUES4,283,348 23,248.05 3,375,456.30- 4,256,985.87 - 26,362.13 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent350.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 Interest 278,813140,656.25 - -142,406.25 -138,156.25 101-555633GO SR2011 Principal 532,287 90,000.00- - - -442,287.00 101-555633.1GO SR2011 Interest90,000 346,167.71- - - -(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 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2012 Cash in Bank Claim on Operating Cash Pool-Checking17,821.35$ Cash in Investments MBIA Investment- Tax I&S1,215,693.96 Federated Investment-Tax I&S56.86 Total Cash in Bank & Investments$1,233,572.17 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET58.33% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042210,564.00 894,612.96- 1,441,702.87 - 950,339.13 Fund Transfers - - - 0.00% - - - Miscellaneous (8,413.49)17,2005,310.75 -17,107.09 - ,,,.,. -,,. TOTALREVENUES24092422021505189992371145880996950 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 21,000 1,863.57 579.81 14,421.53 18,906.73 1,094.97 Utility Service 87,500 4,950.75 30,431.91- 37,849.16 - 49,650.84 Maintenance Services 72,300 1,424.84 632.25 43,685.15 38,254.18 3,546.92 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 8,239.16180,8001,212.0695,537.90 4,641.8995,010.07 L ECONOMIC DEVELOPMEN T Personnel Services 241,233 19,770.22 87,987.66- 125,998.79 - 115,234.21 Supplies 1,100 173.25 - 560.22 441.17 62.88 Human Services 200 - - 111.00- 55.50% - City Support Services 42,772 12,811.76 7,717.90 332.06 -1,363.42 Utility Services 7,200 169.19 - 1,906.78 918.82 - 6,281.18 Operations Support 63,600 2,567.65 4,813.35 40,679.55 13,715.69 712.70 Staff Support 112,800 5,505.52 937.31 63,623.44 66,896.43 5,162.03 41,678.85 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 13,186.26 30,935.60 143,782.52 88,793.37 1,059.98 244,582.25 Fund Charges/Transfers 105,985 4,665.42 82,335.33- 32,657.94 - 73,327.06 Fund Replenish-Fund Balance - - - 0.00% - - - Maintenance Services - - - 0.00% - - - Debt Service 795,154 606,911.25- 613,014.50 182,139.50 - - Operating Equipment 119.932,350-212.88(50.94) - TOTAL ECONO DEVELOPMEN 46,157.441,975,89438,049.681,040,598.51 7,389.71960,367.491,046,186.48 T TOTAL EXPENDITURE 54,396.602,156,69439,261.741,136,136.41 12,031.601,055,377.561,128,546.58 S ** REVENUE OVER(UNDER) EXPEND252,548 403,432.40 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: APRIL 30th, 2011 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET58.33% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042210,564.00894,612.961,441,702.87 - - TOTAL Taxes2,392,042210,564.00 894,612.96- 1,441,702.87 -950,339.13 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 10.33 - 92.12 103.11 - 000-491200Investment Earnings 15,000 420.00 - 4,864.83 4,135.38 -10,864.62 000-497000Misc Income (8,843.82)2,000 - 353.80 12,868.60 -(10,868.60) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 (8,413.49) - 5,310.75 17,107.09 - TOTAL REVENUES2,409,242202,150.51 899,923.71-1,458,809.96 -950,432.04 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: APRIL 30th, 2011 Cash in Bank Claim on Operating Cash Pool-Checking265,499.38$ Cash in Investments MBIA Investment-Economic Development Corp2,024,569.47 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investments3,325,544.31$ 4B SALES TAX $300,000 40% $250,000 -2% 17% 25% -2% 23% $200,000 12% $150,000 $100,000 $50,000 $- OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 214,497 231,818 169,596 207,911 230,700 182,541 173,698 2011-12 171,042 166,132 173,802 177,864 235,199 163,627 141,650 212,924 204,332 171,256 226,531 192,615 2010-11 150,192 169,257 140,629 144,175 238,531 146,589 136,939 184,582 175,160 163,328 210,780 201,402 2009-10 166,298 207,422 185,879 150,414 217,323 149,249 141,205 197,117 158,648 155,080 185,494 159,088 2008-09 168,374 175,427 156,274 163,899 210,937 165,065 143,668 177,527 168,047 164,073 180,483 169,043 2007-08 C I T Y O F S C H E R T Z INVESTMENT REPORT FOR MONTH ENDING APRIL 30th, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,929,711.00,938,213.18.0500,664,714.21,673,216.39,929,711.00,929,711.00 203322 TOTAL OPERATIONS2,929,711.00,938,213.18,664,714.21,673,216.39,929,711.00,929,711.00 23322 LOGIC General Fund3,610,093.78,109,211.22.286482.5600,000.00,610,093.78 N/A,610,093.78 408533 G/F-Equipment Replacement73,399.6073,382.320.2864 -17.2873,399.60 N/A73,399.60 G/F-Vehicle Replacement7,084.60,082.93.2864 -.67,084.60 N/A,084.60 70177 G/F-Air Conditioner Replacement146,548.44146,513.950.2864 -34.49146,548.44 N/A146,548.44 ,721,043.38.286405.17-,721,448.55,721,448.55 SR2009 Bond-Street Projects(II)1,721,448.55 10411 TOTAL LOGIC5,558,574.97,057,233.80,341.1700,000.00,558,574.97,558,574.97 61555 LONESTA R Capital Recovery - Sewer280,796.87280,735.080.2700 -61.79280,796.87 N/A280,796.87 Capital Recovery - Water1,153,699.05,153,445.16.2700 -53.89,153,699.05 N/A,153,699.05 10211 Drainage Fund283,519.65283,457.260.2700 -62.39283,519.65 N/A283,519.65 GO SR2011 Animal Shelter2,222,967.13,222,477.94.2700 -89.19,222,967.13 N/A,222,967.13 20422 GO SR2011 Athletic Fields1,481,867.611,481,541.510.2700 -326.101,481,867.61 N/A1,481,867.61 GO SR2011 Soccer Fields1,411,068.57,410,758.05.2700 -10.52,411,068.57 N/A,411,068.57 10311 GO SR2011 Swimming Pool2,934,229.262,933,583.550.2700 -645.712,934,229.26 N/A2,934,229.26 W/S-Customer Deposits294,051.1393,986.42.2700 -4.7194,051.13 N/A94,051.13 20622 W/S-Equipment Repl/Cap.Imp373,558.98373,476.770.2700 -82.21373,558.98 N/A373,558.98 Water&Sewer1,359,491.16,359,191.99.2700 -99.17,359,491.16 N/A,359,491.16 10211 W/S-Vehicle Replacement544,693.64544,573.770.2700 -119.87544,693.64 N/A544,693.64 69,460.59.27009.31-69,519.9069,519.90 Water/SSLG - SAWS269,519.90 20522 TOTAL LONESTA12,609,462.952,606,688.09 -,774.862,609,462.952,609,462.95 R1211 MBIA Tax I&S1,215,693.961,181,939.890.2500 -33,754.071,215,693.96 N/A1,215,693.96 Police Forfeiture359,541.1959,466.63.2500 -4.5659,541.19 N/A59,541.19 30733 Economic Development Corporation2,024,569.472,024,149.470.2500 -420.002,024,569.47 N/A2,024,569.47 Special Events Fund66,633.736,619.92.2500 -3.816,633.73 N/A6,633.73 60166 EMS Tax Notes 2010301,104.7101,042.24.25002.47-01,104.7101,104.71 30633 TOTAL MBIA3,967,543.063,933,218.15 -34,324.913,967,543.063,967,543.06 FEDERATED SR2007a Bond-City Wide Projects868,652.8868,515.72.1900 -37.1668,652.88 N/A68,652.88 80188 Hotel Occupancy Tax78,210.2078,197.850.1900 -12.3578,210.20 N/A78,210.20 Park Fund (Developers Fee)192,929.1492,898.68.1900 -0.4692,929.14 N/A92,929.14 10311 Park Fund (Tree Mitigation)126,375.64126,355.690.1900 -19.95126,375.64 N/A126,375.64 Tax I&S56.866.85.1900 -.016.86 N/A6.86 50055 Library Board Fund44,728.744,721.68.1900.06-4,728.744,728.74 40744 TOTAL FEDERATED1,310,953.461,310,746.47 -206.991,310,953.461,310,953.46 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,259,050.47,331,644.60.2400 276.09,375.59,334,744.10 N/A,337,905.25 13311 Capital One Capital Recovery1,620,240.56,733,688.52.08000,250.79352.59,743,586.72,714,076.13 13111 TOTAL CAPITAL ONE2,879,291.033,065,333.12 628.6813,626.383,078,330.823,051,981.38 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 7% 9% 9% TOTAL FEDERATED TOTAL LOGIC 4% 18% TOTAL MBIA 13% TOTAL LONESTAR 40% City Portfolio By Use Pooled-Daily Operations, Designated Funds, $2,929,711.00 $9,136,347.60 $10,909,753.90 Special Revenue Funds, Debt Service Fund, $7,155,357.23 $1,215,750.82 MONTHLY YIELDS 3.50 3.00 2.50 2.00 1.50 1.00 0.50 0.00 OCT-11NOV-11DEC-11JAN-12FEB-12MAR-12APR-12MAY-12JUN-12JUL-12AUG-12SEP-12 0.02000.02000.01000.04000.08000.05000.0700 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.1000 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.1500 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.5300 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.30000.30000.30000.3000 CD 180 Days 0.25000.25000.10000.10000.1000 CD 90 Days 0.05000.05000.05000.0500 CD 28 Days 0.14700.18740.20850.25130.28600.29420.2864 LOGIC 0.23000.25000.28000.31000.26000.27000.2700 LoneStar 0.14000.15000.19000.21000.25000.24000.2500 MBIA 0.09000.14000.13000.15000.22000.21000.1900 Federated 2.32432.84002.83003.07003.07003.15003.1500 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:4/30/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69119,050.4719,050.4719,050.471.000.01 39,940.3339,940.33 JPMorgan Chase Disc Coml Paper9/21/2012144.0040,000.00 Total Cash & Equivalent9,050.458,990.88,990.8 s57050 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014835.00125,000.00141,987.30139,772.506,875.00 Federal Home Loan Bks Cons Bds6/21/2013417.0080,000.0082,004.4081,490.401,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151325.00100,000.00116,185.00114,916.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012170.00150,000.00162,031.50152,985.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013564.00170,000.00191,084.25182,156.708,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013512.00250,000.00250,000.00264,320.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014939.00100,000.0099,874.40100,802.00750.00 Federal Natl Mtg Assn 7/28/20151184.00125,000.00132,828.63132,246.252,968.00 US Treasury Note2/28/2014669.00100,000.0099,757.82100,012.00 Total Fixed Income1,200,000.001,275,753.301,268,700.854 Total Assets619.461,259,050.471,334,744.101,327,691.654 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69120,240.5620,240.5620,240.562.000.01 JPMorgan Chase Disc Coml Paper9/21/2012144.0080,000.0079,880.6779,880.67 Total Cash & Equivalent00,240.5100,121.200,121.2 s16313 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014835.00165,000.00187,423.24184,499.709,075.00 Federal Home Loan Bks Cons Bds6/21/2013417.00100,000.00102,505.50101,863.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151325.00100,000.00116,185.00114,916.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012170.00250,000.00270,052.50254,975.0011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013564.00250,000.00281,006.25267,877.5012,187.00 Federal Natl Mtg Assn Nts10/15/2013533.00200,000.00223,001.60212,672.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014939.00220,000.00220,078.68221,764.401,650.00 Federal Natl Mtg Assn7/28/20151184.00135,000.00143,454.91142,825.953,206.00 /28/201469.0000,000.0099,757.8100,012.00 US Treasury Not e2611 Total Fixed Incom,520,000.01,643,465.4,601,405.5 e109155 Total Assets648.771,620,240.561,743,586.721,701,526.785