Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
08-MAY 2012 FINANCIAL STATEMENT
MAY 2012 Financial Report C I T Y OF S C H E R T Z Prepared By: The Finance Department June 29, 2012 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes11,803,725386,780.02 8,997,497.87-10,154,684.02 1,649,040.98 Franchises 1,617,000 144,467.43 785,016.62- 1,029,503.53 - 587,496.47 Permits 1,187,800 114,252.00 1,305,380.13- 728,570.75 - 459,229.25 Licenses 48,300 7,750.00 45,435.60- 48,530.00 - Fees 3,324,727 324,712.48 1,876,044.16- 1,790,236.48 - 1,534,490.52 Fines 30,000 2,769.57 17,060.91- 17,914.67 - 12,085.33 Inter-Jurisdictional 571,245 32,705.90 223,050.63- 383,546.96 - 187,698.04 Fund Transfers 1,760,658 114,569.85 786,046.36- 876,823.98 - 883,834.02 Miscellaneous615,50019,726.17325,916.57367,657.83(18.90) - TOTAL REVENUES20,958,9551,147,733.4214,361,448.8515,397,468.22(18.90) - - EXPENDITURE SUMMAR Y GENERAL GOVERNMEN T CITY COUNCIL Personnel Services22,800 1,366.30 15,371.99- 14,441.09 - Supplies 700 - - 239.97 314.06 109.54 City Support Services 17,500 2,067.00 219.98 13,080.87 3,702.08 240.43 Utility Services - - - - - - Operations Support 100 - - 127.40 - - Staff Support20,400370.602,150.00 10,723.9316,284.89 - Operating Equipment -- - - - - TOTAL CITY COUNCIL 61,500 3,803.90 2,369.98 39,544.16 34,742.12 349.97 CITY MANAGE R Personnel Services852,20171,136.43 484,139.60-524,775.80 - 327,425.20 Supplies5,331 70.76 268.94 711.05 2,573.13 124.78 2,902.03 - - - - City Support Services - - Operations Support - - - 45.00 - - Staff Support 25,550 893.47 1,527.05 16,644.72 17,697.85 3,843.81 Operating Equipment -1,393.36 - - - - TOTAL CITY MANAGER 883,082 72,100.66 502,888.731,795.99 545,091.78 3,968.59 335,817.62 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET MUNICIPAL COURT Personnel Services257,113 19,180.83 159,230.90- 165,702.75 - 91,410.25 Supplies2,500 - 99.00 697.34 1,204.27 87.11 1,307.62 City Support Services1,000 - - - - - Operations Support 3,000 - 700.00 1,951.00 1,558.00 474.00 Staff Support 5,500 305.59 285.20 1,690.86 1,826.63 458.44 Court Support 800 - - - - - Professional Services 71,100 4,882.50 34,244.00- 36,411.25 10,150.00 Maintenance Services 2,200 - - 600.00 399.94 - Operating Equipment1,000497.14 1,047.14650.0042.13 - TOTAL MUNICIPAL COURT 24,368.92344,213 1,581.34 199,064.10 208,149.98 11,211.68 126,432.68 CUSTOMER RELATIONS-311 Personnel Services109,700 8,751.16 54,438.18- 64,716.05 - 44,983.95 Supplies300 - - 49.84 150.61 24.64 124.75 Staff Support1,018 25.00 543.00636.20 - - Operating Equipment500 213.00- - - - TOTAL CUSTOMER RELATIONS-311 111,518 8,776.16 55,031.02- 65,715.86 24.64 PLANNING & ZONING Personnel Services 139,925 10,476.06 88,188.19- 89,534.58 - 50,390.42 Supplies 2,700 24.01 156.45 259.39 798.70 - Operations Support 750 - - 77.95 - - Staff Support 17,150 - 548.55 3,232.12 1,759.35 43.06 Professional Services 76,650 18,774.46 1,366.40 52,072.45 38,553.29 - 39,463.11 Operating Equipment3,500 2,112.001,055.00 - - - TOTAL PLANNING & ZONING240,67529,274.532,071.40144,885.10132,757.9243.06 LEGAL SERVICES Operations Support13,000 - 8,117.96- - - 13,000.00 Professional Services245,00051,351.72116,614.93241,917.40 - - TOTAL LEGAL SERVICES 258,000 51,351.72 124,732.89- 241,917.40 - 16,082.60 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FACILITIES MAINTENANCE Personnel Services648,323 46,339.43 410,343.62- 382,394.18 - 265,928.82 Supplies61,100 6,612.49 1,224.76 44,233.66 45,927.03 4,473.82 11,923.91 Utility Services112,000 7,848.50 - 46,148.94 54,032.12 - 57,967.88 - - - - Operations Support - - Staff Support 13,179 812.99 41.35 6,820.00 7,925.67 252.48 Maintenance Services 99,554 9,874.06 673.05 86,026.01 68,273.53 4,078.64 Rental/Leasing 400 99.20 - 763.92 257.19 74.40 Operating Equipment3,396862.22 1,278.552,564.55 - - Capital Outlay24,500 -2,524.53 - - - TOTAL FACILITIES MAINTENANCE 962,452 72,448.89 1,939.16 598,139.23 561,374.27 8,879.34 CITY SECRETAR Y Personnel Services 164,529 12,574.95 107,115.15- 105,939.65 - 58,589.35 Supplies1,250 - - 1,049.97 750.69 - City Support Services 9,780 - - 6,788.22 1,902.20 - Staff Support8,605483.24 4,431.733,150.10477.79 - TOTAL CITY SECRETARY 184,164 13,058.19 118,103.44- 113,024.27 477.79 NON-DEPARTMENTA L Supplies 2,500 - - 395.35 10.71 - City Support Services 510,169 71.00 1,294.02 250,095.57 214,820.48 - 296,642.54 Operations Support 139,000 9,875.01 1,076.05 85,570.12 93,129.48 - 46,946.57 City Assistance 459,046 96,973.24 326,077.60- 385,113.97 - 73,932.03 Professional Services 174,650 3,196.26 47,858.54- 65,511.28 5,000.00 Fund Chrgs/Transfrs-Spec Events Fnd 10,850 - - - - - 10,850.00 Operating Equipment - - - - - - Capital Outlay -- - - - - TOTAL NON-DEPARTMENTAL 1,296,215 110,115.51 2,370.07 709,997.18 758,585.92 5,000.00 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC AFFAIRS Personnel Services268,919 21,439.40 95,582.08- 173,050.85 - 95,868.15 Supplies2,900 169.68 - 374.24 1,960.31 129.16 810.53 Operations Support34,585 1,289.97 4,989.75 11,061.68 11,955.63 171.89 27,447.23 Staff Support4,865 34.92 196.44 1,197.45 1,448.39 736.70 2,876.35 Operating Equipment300 -1,894.78 - - - TOTAL PUBLIC AFFAIRS 311,569 22,933.97 5,186.19 110,110.23 188,415.18 1,037.75 RECORDS MANAGEMEN T Personnel Services 47,850 3,560.62 30,037.06- 31,088.87 - 16,761.13 Supplies 750 12.87 - 290.24 180.82 - Staff Support 1,500 212.25 - 641.90 784.35 218.90 Professional Services 15,000 148.50 - 7,776.64 6,301.66 - Operating Equipment -- - - - - TOTAL RECORDS MANAGEMENT 65,100 3,934.24 38,745.84- 38,355.70 218.90 SCHERTZ TALES MAGAZINE Personnel Services 129,161 9,986.56 80,536.25- 83,679.70 - 45,481.30 Supplies 200 - - - 45.00 - Opperations Support 200 - - - - - Staff Support 1,500 - - - 116.08 90.04 Professional Services302,70017,049.38148,534.40181,324.82 - - TOTAL SCHERTZ TALES MAGAZINE 433,761 27,035.94 229,070.65- 265,165.60 90.04 ENGINEERING Personnel Services 123,405 4,351.13 106,288.97- 47,414.11 - 75,990.89 Supplies 400 - - 67.35 284.85 - City Support Services - - - - - - Utility Services 600 74.32 - - 208.18 - Staff Support 2,213 - - 395.00 130.00 29.95 Professional Services 89,220 7,318.75 18,391.25- 59,727.50 - 29,492.50 Maintenance Services 4,044 - - 2,745.24 3,345.29 - Operating Equipment -- - - - - Capital Outlay26,000 25,352.30- - - - TOTAL ENGINEERING 245,882 11,744.20 127,887.81- 136,462.23 29.95 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET GIS Personnel Services122,079 9,210.62 75,195.94- 78,377.74 - 43,701.26 Supplies3,500 - - 1,141.65 951.02 - Staff Support 4,050 - - - - - Professional Services2,000 -- - - - TOTAL GIS 131,629 9,210.62 76,337.59- 79,328.76 - 52,300.24 TOTAL GENERAL GOVERNMENT 5,529,760 460,157.45 17,314.13 3,074,537.97 3,369,086.99 31,331.71 PUBLIC SAFETY POLICE Personnel Services4,536,879 338,582.72 2,747,245.67- 2,840,151.30 - 1,696,727.70 Supplies25,837 1,704.27 6,769.16 9,911.66 21,413.34 2,274.40 8,918.42 City Support Services35,000 - - - 19,518.41 - 15,481.59 Utility Services123,456 10,679.06 - 57,873.97 65,339.29 - 58,116.71 Operations Support1,565 265.00 - 193.00 1,385.00 180.00 - Staff Support57,083 2,830.00 1,732.17 8,338.31 25,973.33 10,432.69 22,409.15 City Assistance9,414 - - 2,184.98 2,820.74 1,851.00 4,742.26 Professional Services19,500 840.00 - 875.00 2,082.85 - 17,417.15 Maintenance Services44,435 1,820.00 - 22,570.80 33,448.23 - 10,986.77 Operating Equipment67,231 12,102.60 4,945.10 43,573.12 47,912.21 17,917.01 6,346.88 Capital Outlay142,52512,554.80153,726.40155,076.05 - - TOTAL POLICE 5,062,925368,823.6526,001.233,046,492.913,215,120.7532,655.10 FIRE RESCUE Personnel Services 2,508,586 181,631.65 1,584,740.76- 1,646,034.19 - 862,551.81 Supplies 20,500 956.44 9,239.99 4,824.02 12,871.86 65.70 Utility Services 57,000 5,012.47 7.64 27,309.55 29,486.45 - 27,521.19 Operations Support 800 - - 120.00 323.39 115.00 Staff Support 120,185 27,727.79 20,833.33 55,648.70 98,450.54 3,581.00 City Assistance 18,600 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 3,895.00 3,710.01 18,509.50 23,463.09 884.99 Operating Equipment58,300966.4215,553.04 27,365.4816,041.801,516.93 Capital Outlay35,000 31,116.00- - - - TOTAL FIRE 2,893,111 220,189.77 57,466.01 1,730,341.18 1,878,668.66 6,163.62 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET INSPECTIONS Personnel Services420,518 31,435.70 234,676.86- 269,598.82 - 150,919.18 Supplies2,500 22.32 - 642.12 1,466.00 - Utility Services 6,500 589.23 - 3,096.19 3,196.42 - Operations Support 1,500 - - 439.87 44.00 231.00 Staff Support 8,000 87.30 581.37 2,409.15 1,848.20 69.00 Professional Services 10,000 - - - - - 10,000.00 Operating Equipment1,000 -- - - - TOTAL INSPECTIONS 450,01832,134.55581.37241,264.19276,153.44300.00 MARSHAL SERVICE Personnel Services 534,355 36,531.12 288,590.88- 332,935.74 - 201,419.26 Supplies 4,600 83.91 205.82 392.95 1,964.29 395.20 Utility Services 12,000 1,423.28 - 5,103.77 7,958.60 - Operations Support 4,000 48.00 - 829.99 1,120.41 45.00 Staff Support 15,400 40.00 410.00 1,821.18 5,104.66 42.14 Professional Services - - - - - - Maintenance Services 30,700 690.00 - 7,453.85 2,904.00 - 27,796.00 Operating Equipment16,0001,683.392,206.37 22,683.7810,918.42640.00 Capital Outlay34,000 31,022.0540,406.00 - - - TOTAL MARSHAL SERVICE 651,055 40,499.70 2,822.19 367,282.40 393,928.17 1,122.34 TOTAL PUBLIC SAFETY 9,057,109 661,647.67 86,870.80 5,385,380.68 5,763,871.02 40,241.06 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET PUBLIC ENVIRONMENT STREETS Personnel Services680,357 49,548.55 378,723.78- 435,233.97 - 245,123.03 Supplies7,100 522.94 21.04 3,165.33 4,132.71 61.29 2,927.04 Utility Services113,900 9,538.34 - 69,038.05 70,511.20 424.63 42,964.17 - - - - Operations Support - - Staff Support 10,265 891.71 79.91 4,082.30 5,087.30 175.00 Maintenance Services 270,800 9,596.66 579.71 107,170.50 108,588.52 8,263.18 Rental/Lease 200 - - - - - Operating Equipment 4,200 - - 4,379.99 3,485.99 - Capital Outlay -13,670.00 - - - - TOTAL STREETS 1,086,82270,098.20680.66580,229.95627,039.698,924.10 TOTAL PUBLIC ENVIRONMENT 1,086,822 70,098.20 680.66 580,229.95 627,039.69 8,924.10 PARKS & RECREATION PARKS DEPARTMENT Personnel Services506,870 35,435.92 306,401.32- 311,413.64 - 195,456.36 Supplies40,555 1,661.57 1,169.51 22,013.24 22,047.33 1,140.58 18,536.60 Utility Services113,000 13,162.72 - 69,924.24 77,626.05 609.21 34,764.74 Operations Support700 - - 880.80 - - Staff Support 8,573 255.91 5,801.9760.93 6,296.24 179.24 2,158.45 Professional Services62,610 3,230.00 - 24,445.00 36,253.07 9,663.42 16,693.51 Maintenance Services22,000 188.96 44.99 12,590.94 13,637.96 50.00 8,357.03 Rental/Leasing42,200 3,349.73 - 27,051.43 23,080.99 19,601.06 (482.05) - - 6,197.93 - Operating Equipment - - Capital Outlay -190.56 - - - - TOTAL PARKS DEPARTMENT796,50857,284.811,275.43475,497.43490,355.2831,243.51 SWIM POOL Supplies 16,700 782.27 392.93 5,994.33 6,802.84 1,527.21 Utility Services 25,500 1,389.96 - 7,413.16 10,613.71 - 14,886.29 Staff Support 925 - - - 750.00 - Maintenance Services 199,378 818.70 4,000.00 4,826.27 12,904.63 - 190,473.37 Rental/Lease500104.20 208.20378.00 - - TOTAL SWIM POOL 3,095.13243,003 18,611.764,392.93 31,279.38 1,527.21 214,589.34 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET COMMUNITY/CIVIC CENTER Personnel Services54,292 4,031.61 48,749.16- 36,440.14 - 17,851.86 Supplies28,300 737.02 1,127.61 5,745.75 9,524.42 605.50 19,297.69 Utility Services47,550 3,432.43 - 19,812.57 20,975.86 - 26,574.14 Operations Support15,200 6.91 - 5,667.26 7,196.78 8.00 7,995.22 Staff Support3,300 72.72 439.45 377.47 1,081.48 - Professional Services 1,600 - 150.00 925.00 150.00 - Operating Equipment5,0004,243.88 5,398.58285.00 - - TOTAL COMMUNITY/CIVIC CNTR155,242 5,960.948,280.69 81,562.21 80,767.26 613.50 79,822.18 TOTAL PARKS & RECREATION1,194,753 68,660.63 575,671.4011,629.30 602,401.92 33,384.22 570,596.16 CULTURAL LIBRARY Personnel Services 692,531 51,604.17 437,389.39- 452,591.10 - 239,939.90 Supplies14,000 1,865.11 86.59 5,168.65 6,913.45 1,044.95 6,128.19 Utility Services41,000 4,407.52 - 25,382.87 25,279.56 - 15,720.44 Operations Support2,000 983.00 174.00 70.00 1,157.00 - Staff Support 4,215 24.57 58.97 1,243.04 1,513.52 24.66 Professional Services 2,100 - - 2,065.00 2,140.00 - Maintenance Services 2,400 - - 1,200.00 1,600.00 - Operating Equipment 75,000 8,132.95 2,366.43 48,627.35 51,394.65 8,416.60 Capital Outlay -- - - - - TOTAL LIBRARY 67,017.32833,246 2,685.99 521,146.30 542,589.28 9,486.21 283,856.50 TOTAL CULTURAL833,246 67,017.32 521,146.302,685.99 542,589.28 9,486.21 283,856.50 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HEALTH ANIMAL SERVICES Personnel Services296,439 22,155.97 197,200.34- 179,560.74 - 116,878.26 Supplies25,000 1,175.96 319.99 11,347.31 12,458.12 2,078.92 10,782.95 Utility Services11,200 928.75 - 6,178.48 6,652.77 194.75 4,352.48 Operations Support500 - - - - - Staff Support 12,560 276.90 34.48 1,652.00 5,478.95 163.69 City Assistance 10,000 - - 6,471.48 5,270.08 - Professional Services 13,500 - - 6,575.00 6,211.50 210.00 Maintenance Services 6,200 200.00 - 1,926.78 4,025.00 238.66 Operating Equipment9,500170.60 5,999.761,544.982,945.16 - Capital Outlay -- - - - - TOTAL ANIMAL SERVICES384,89924,908.18354.47237,351.15221,202.145,831.18 TOTAL HEALTH 384,899 24,908.18 354.47 237,351.15 221,202.14 5,831.18 INTERNAL SERVICE INFORMATION TECHNOLOG Y Personnel Services 260,032 21,111.09 168,206.42- 183,118.85 - 76,913.15 Supplies2,000 - - 533.62 326.22 - City Support Services 362,354 331.23 166,962.45- 196,165.35 - 166,188.65 Utility Services 164,949 7,202.70 1,585.17 86,225.51 86,351.43 349.97 Staff Support 15,250 2,704.54 2,036.38 4,970.57 11,076.31 73.59 Professional Services 2,500 - - - - - Maintenance Services 12,500 821.00 14,604.48- 7,334.36 2,850.00 Operating Equipment 129,315 1,458.23 4,911.44 53,629.58 45,084.35 27,860.79 Capital Outlay213,500 7,266.0035,880.00 - - - TOTAL INFORMATION TECHNOLOGY1,162,400 33,628.79 531,012.638,532.99 536,722.87 31,134.35 603,075.77 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET HUMAN RESOURCES Personnel Services296,750 17,057.98 138,499.79- 160,227.41 - 136,522.59 Supplies1,329 - - 720.42 838.87 - Human Services 47,156 7,964.76 654.00 20,582.45 25,174.61 - 22,635.39 Operations Support 16,596 1,536.00 532.56 6,654.41 3,942.25 - 13,186.33 Staff Support 14,897 79.00 550.72 5,936.18 8,139.82 (55.00) City Assistance 9,860 420.00 - 4,806.00 4,599.50 - Professional Services - - - - - - Operating Equipment4,162.83 4,302.13- - - - TOTAL HUMAN RESOURCES 27,057.74386,588 177,199.255,900.11 207,224.59 (55.00) 185,318.54 FINANCE Personnel Services429,810 35,493.67 267,415.21- 284,476.84 - 145,333.16 Supplies3,600 - - 1,966.69 2,191.93 59.30 1,348.77 Operations Support850 - - - 97.31 - Staff Support 15,805 666.96 - 7,846.61 6,074.98 258.54 Rental/Leasing 2,230 - - - 502.32 - Operating Equipment1,000266.47 266.47880.68 - - TOTAL FINANCE453,29536,160.63266.47278,109.19293,609.85317.84 PURCHASING & ASSET MG T Personnel Services 241,940 18,168.00 151,624.75- 156,452.43 - 85,487.57 Supplies1,103 - - 528.84 385.31 310.64 407.05 Utility Services450 88.22 - 185.42 419.85 - Operations Support 909 788.62 - 60.68 1,763.12 - Staff Support 9,297 162.95 65.00 4,057.77 4,004.15 - Operating Equipment7,591 7,590.82- - - - TOTAL PURCHASING & ASSET MGT 261,290 19,207.79 65.00 156,457.46 170,615.68 310.64 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET FLEET SERVICE Personnel Services217,880 13,836.06 101,828.82- 138,346.48 - 79,533.52 Supplies121,556 6,691.59 2,927.39 68,560.88 98,132.28 7,066.01 19,285.10 City Support Services1,500 - - 1,500.00 1,500.00 - Utility Services 7,200 390.55 - 2,746.24 2,185.48 - Operations Support 400 - - 375.00 375.00 - Staff Support 3,835 190.61 620.41 1,095.20 2,202.31 80.09 Maintenance Services 53,724 2,102.00 1,685.29 39,630.70 26,701.80 2,805.55 Rental/Lease270 150.00269.80 - - - Operating Equipment5,000 3,973.904,931.79 - - - Capital Outlay -- - - - - TOTAL FLEET SERVICE411,36523,210.815,233.09219,860.74274,644.949,951.65 TOTAL INTERNAL SERVICE 2,674,938 139,265.76 19,997.66 1,362,639.27 1,482,817.93 41,659.48 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 -1,090.00 - - - 18,359.00 TOTAL CITY ASSISTANCE - - 1,090.00 18,359.00- - TOTAL MISC & PROJECTS 52,000 - - 37,804 34,000 28,859 TOTAL EXPENDITURES20,813,5271,491,755.21 139,533.0111,774,760.9312,643,008.97199,716.96 REVENUE OVER(UNDER) EXPEND.145,4282,754,459.25 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Taxes 000-411100Advalorem Tax - Current 6,884,454 29,918.60 6,681,179.64- 6,839,768.57 - 44,685.43 000-411200Advalorem Tax - Delinquent 50,000 1,626.81 39,477.28- 43,064.48 - 000-411300Advalorem Tax - P&I 50,000 1,953.10 35,252.47- 34,011.57 - 15,988.43 000-411500Sales Tax Revenue-Gen Fund4,784,071 353,281.51 2,215,074.39- 3,216,860.24 - 1,567,210.76 000-411600Bingo Tax 2,200 - - 1,161.08 - - 000-411700Mixed Beverage Ta33,000.0025,353.0120,979.16 x - - - TOTAL Taxes11,803,725 386,780.02 8,997,497.87- 10,154,684.02 1,649,040.98 Franchises 000-421200Center Point/Entex Energy 36,000 2,731.32 27,235.78- 38,848.38 - (2,848.38) 000-421220City Public Service 330,000 33,146.48 185,874.73- 219,088.58 - 110,911.42 000-421240Guadalupe Valley Elec Co-op 440,000 32,515.58 186,840.44- 248,934.50 - 191,065.50 000-421250New Braunfels Utilities 55,000 4,736.88 - 5,633.66 32,041.65 - 22,958.35 000-421300Time Warner-State Franchise 345,000 29,633.84 161,780.70- 216,721.73 - 128,278.27 000-421350Time Warner-PEG Fee 65,000 - 32,344.84- 16,039.50 - 48,960.50 000-421460AT&T Franchise Fee 185,000 14,306.99 76,453.51- 101,311.73 - 83,688.27 000-421465AT&T PEG Fees 26,000 7,332.42 12,036.28 14,580.37 000-421480Other Telecom Franchise 35,000 14,879.70 27,079.58- 78,195.00 - (43,195.00) 000-421500Solid Waste Franchise Fee100,0005,184.2269,737.1063,742.09 - - TOTAL Franchises1,617,000144,467.43 785,016.62-1,029,503.53 - 587,496.47 Permits 000-431100Home Occupation Permit 500 - - 280.00 245.00 - 000-431200Building Permit - 1,047,285.83- - - - 000-431205Building Permit - Residential 600,000 27,719.00 - 263,066.00- - 336,934.00 000-431210Building Permit - Commercial 300,000 42,107.00 - 177,030.00- - 122,970.00 000-431215Building Permit - General - 78,942.00- - 16,887.00 - (78,942.00) 000-431300Mobile Home Permit 200 165.00 - 80.00 175.00 - 000-431400Signs Permit 1,700 552.00 - 470.00 1,429.00 - 000-431500Food Establishmnt Permit 30,000 2,475.00 14,120.00- 13,300.00 - 16,700.00 000-431600Garage Sale Permit 8,600 1,265.00 - 6,785.00 6,665.00 - 000-431700Plumbing Permit 80,000 9,567.00 83,063.80- 77,553.75 - 000-431750Electrical Permit 55,000 3,360.00 53,720.00- 29,250.00 - 25,750.00 000-431800Mechanical Permit 59,000 4,820.00 59,600.00- 33,520.00 - 25,480.00 000-431900Solicitor/Peddler Permit 600.00 - 950.00 1,030.00 - - 000-431950Animal/Pet Permit 2,000 465.00 - 1,385.00 1,475.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-432000Cert. of Occupancy Prmt3,800350.00 4,000.00- 6,150.00 - (2,350.00) 000-432100Security Alarm Permit42,000 3,295.00 - 27,478.00 32,915.00 - 000-435000Fire Permit5,000625.00 5,825.006,162.50 - - TOTAL Permits 114,252.001,187,800 - 1,305,380.13 728,570.75 - 459,229.25 Licenses 000-441000Alcohol Beverage License 6,300 235.00 - 3,017.50 3,450.00 - 000-441300Mobile Home License - - - 80.00 - - 000-442000Contractors License 39,000 7,020.00 39,405.00- 41,825.00 - (2,825.00) 000-444000Pet License3,000495.00 3,175.003,013.10 - - TOTAL Licenses 48,300 7,750.00 45,435.60- 48,530.00 - Fees 000-451000Municipal Court Fines 1,665,009 189,177.87 727,944.73- 852,490.82 - 812,518.18 000-451100Arrest Fee 50,694 6,042.44 30,618.03- 37,046.62 - 13,647.38 000-451110Expunction Fee 90 - - - - - 000-451200Warrant Fees 192,000 10,603.90 90,582.99- 91,944.90 - 100,055.10 000-451210Court - Claims & Judgements - - - 1,842.60 - - (1,842.60) 000-451320Civil Justice Fee-Court 75 9.73 45.58 57.69 - 000-451321Civil Justice Fee-State 88.15 - - 520.13 - - 000-451340Judicial Fee - City 6,826 778.11 - 4,101.67 4,904.00 - 000-451400Traffic Fine Costs TTL 25,984 3,147.12 15,373.02- 19,021.94 - 000-451500Teen Court Admin Fee 260 20.00 - 260.00 420.00 - 000-451510Juvenile Case Mgmt Fee 55,896 6,478.27 34,199.30- 40,890.80 - 15,005.20 000-451600Technology Fund Fee 45,601 5,190.12 27,772.27- 32,938.19 - 12,662.81 000-451700Security Fee 34,220 3,892.58 20,838.21- 24,703.69 - 000-451800Time Payment Fee - City 7,336 361.19 - 4,040.98 3,624.24 - 000-451850State Fines 10% Service Fee 72,470 - 49,510.11- 48,016.77 - 24,453.23 000-451900DPS Payment - Local 11,858 869.60 - 7,438.63 7,310.00 - 000-452000Child Safety Fee 12,243 3,405.62 - 8,528.78 21,259.77 - (9,016.77) 000-452050Indigent Defense Fee 21,655 2,564.95 13,210.78- 15,860.36 - 000-452100Platting Fees 98,000 3,500.00 45,500.00- 46,500.00 - 51,500.00 000-452200Site Plan Fee 74,000 1,500.00 17,000.00- 18,000.00 - 56,000.00 000-452300Plan Check Fee 465,000 42,554.00 530,274.91- 214,440.00 - 250,560.00 000-452310Miscellaneous Review Fee 13,500 - - 900.00 5,700.00 - 000-452320Tree Mitigation Admin Fee 10,500 7,995.00 - 11,090.25- - 000-452400BOA/Zoning Fees 4,000 - - 1,400.00 3,250.00 - 000-452500Food Handler Class 7,000 340.00 - 5,110.00 2,540.00 - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET 000-452520Fire Training Classes400---- - 000-452600Specific Use/Zone Chng Fee 20,000 - 11,650.00- 24,500.00 - (4,500.00) 000-452710Zoning Ltr & Dev Rights 1,500 300.00 - 300.00 1,800.00 - 000-453100Reinspection Fees 30,000 3,075.00 29,250.00- 27,475.00 - 000-453110Swim Pool Inspection Fee - 1,050.00 1,050.00 - 1,050.00 - (1,050.00) 000-453200Mowing Fees - Inspections 12,000 200.00 11,045.00- 1,706.58 - 10,293.42 000-453211Admin Fee-Inspections 7,480 800.00 - 4,900.00 5,340.00 - 000-453310Misc Inspection Fee 50.00 - 40.00 69.49 - - 000-453710Foster Care 500 - - 650.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 800 - - - 6,984.73 - (6,184.73) 000-456510Fire Plan Review 3,000 - - - - - 000-456600Fire Re-inspection Fee 180 - - 700.00 500.00 - 000-458100Sale of Merchandise 36.50 - 17.00 36.50 - - 000-458300Sale of Property/Auction 22,000 77.03 20,557.80- 21,602.48 - 000-458400Civic Center Rental Fees 171,000 14,018.00 83,780.00- 73,653.50 - 97,346.50 000-458401Capital Recovery Fee-Civic Cntr 7,500 - - 1,060.00 3,500.00 - 000-458450North Center Rental Fees 15,000 2,110.00 - 6,722.00 15,242.92 - 000-458500Community Center Rental Fees 18,000 2,069.70 11,316.02- 19,412.19 - (1,412.19) 000-458550Pavilion Rental Fees 18,500 2,422.50 12,825.70- 12,337.00 - 000-458560Chamber of Comm rent 11,700 - - 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 5,430.00 -2,820.008,100.00 - 000-458660BVYA Utility Reimbursement 766.40 - - 5,178.24 - - (5,178.24) 000-458670SYSA Utility Reimbursement - - - 4,926.73 - - (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 - - 548.00 - - 000-459300Notary Fee 300 36.00 - 279.00 228.00 - 000-459400Maps, Copies, UDC, & Misc F 400 10.00 - 608.18 68.10 - 000-459600Animal Adoption Fee 15,000 1,557.50 - 7,506.50 8,137.50 - 000-459700Pet Impoundment Fee 15,000 1,527.00 14,449.01- 9,899.25 - 000-459800Police Reports Fee6,500658.20 4,150.504,008.20 - - TOTAL Fees 324,712.483,324,727 - 1,876,044.16 1,790,236.48 - 1,534,490.52 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fines 000-463000Library Fines30,0002,769.5717,060.9117,914.67 - - TOTAL Fines30,0002,769.57 17,060.91-17,914.67 - 12,085.33 Inter-Jurisdictional 000-473100Bexar Co - Fire 21,077 7,025.92 - 7,025.92 14,051.84 - 000-473200City of Seguin - Fire Contract 40,263 3,355.26 26,842.08- 26,842.08 - 13,420.92 000-473300Guad Co - Library 180,000 15,901.33 105,476.00- 111,309.31 - 68,690.69 000-473400Randolph AFB-Animal Cntrl 1,000 - - 1,400.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- 99,978.75 - 33,326.25 000-474600School Crossing Guard-Bexar6,6006,423.39 4,550.9723,402.79 - -(16,802.79) 000-474610School Cross Guard-Guadalupe19,862.19 - - -11,102.76 -(19,862.19) 000-474700School Officer Funding150,000 87,500.00- - - - TOTAL Inter-Jurisdictional571,24532,705.90 223,050.63-383,546.96 - 187,698.04 Fund Transfers 000-480000Indirect Costs - EMS 87,840 7,320.00 58,560.00- 58,560.00 - 29,280.00 000-480100Indirect Costs - Hotel/Motel 142,626 11,885.50 113,480.66- 95,084.00 - 47,542.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 25,827.00- 27,890.00 - 000-486000Interfund Chrges-Admin W&S 881,222 73,435.17 416,518.00- 587,481.36 - 293,740.64 000-486106Transfer in-Special Events - - - 1,000.00 - - (1,000.00) 000-486317Transfer From Park Fund 13,000 5,819.26 - - 5,819.26 - 000-486402Transfer from City Wide Projects - 25,372.05- - - - 000-487000Interfund Charges-Fleet 98,484 8,207.00 59,536.66- 65,656.00 - 32,828.00 000-488000Interfund Charges-4B 53,000 4,416.67 36,751.99- 35,333.36 - 17,666.64 000-490020Transfer In-SEDC50,00050,000.00- - - - TOTAL Fund Transfers 1,760,658 114,569.85 786,046.36- 876,823.98 - 883,834.02 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ************************************************ 2 0 1 1 - 2 0 1 2 **************************************************** 101 GENERAL FUND CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Miscellaneous 000-491000Interest Earned 3,000 18.62 - 1,565.58 207.03 - 000-491200Investment Income 30,000 4,437.69 23,723.20- 32,748.13 - (2,748.13) 000-491800Gain/Loss - - - 443.67 - - 000-491900Unrealized Gain/Loss (13,685.29)- (20,956.80) - (3,352.80) - 20,956.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. 50.00 24,701.00- 5,031.34 - - (5,031.34) 000-493400Donation - Animal Control 1,200 576.59 - 2,859.26 2,943.60 - (1,743.60) 000-493401Donations-A/C Microchip 500 250.00 - 1,605.00 1,375.00 - 000-493402Donations-Spay&Neuter 13,500 1,617.00 10,615.82- 8,945.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-495100Mobile Stage Rental Fees - - 1,550.00 - 1,550.00 - (1,550.00) 000-497000Misc Income-Gen Fund 81,000 (15,903.54) - 945.23 17,539.70 (18.90) 000-497005Misc Income-Publications 290,000 13,831.00 97,858.10- 133,755.00 - 156,245.00 000-497007Misc Income-Schertz Artz - - - 20.00 - - 000-497100Misc Income-Police 25,000 8,284.65 15,277.23- 15,278.90 - 000-497200Misc Income-Library 19,000 379.65 17,326.95- 2,581.59 - 16,418.41 000-497210Misc Income-Library Copier 13,500 1,535.20 7,300.65 9,218.31 - 000-497300Misc Income-Animal Control 500 - - 1,256.37 105.00 - 000-497400Misc Income-Streets Dept. 20,000 1,410.00 12,550.00- 10,567.48 - 000-497500Misc Income-TML Insurance 78,000 546.66 49,728.90- 623.36 - 77,376.64 000-497550Misc Income-TML Reimbursemt20,000 2,224.50 22,447.21-15,373.06 - 000-497600Misc Income-Parks/Vending Mach.2,500 154.26 - 1,202.59 1,114.36 - 000-498000Reimbursmnt-Gen Fund5,000 4,624.1223,908.83 - - -(18,908.83) 000-498100Reimbursmnt Fire - Training 800 - - 846.00 - - 000-498105Reimburmnt Police - DEA - 4,925.36 3,256.44 - 2,116.69 - (3,256.44) 000-498110Reimbursmnt Fire - Emg. Acti-O12,000 - - 9,328.07 38,143.21 - (26,143.21) 000-498500Settlement - Litigation25,000.00- - - - - TOTAL Miscellaneous615,500 19,726.17 - 325,916.57 367,657.83 (18.90) 247,861.07 TOTAL REVENUES20,958,955 1,147,733.42 - 14,361,448.85 15,397,468.22 (18.90) 5,561,505.68 GENERAL FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking421,868.95$ Cash in Investments LOGIC Investment-General Fund 3,310,869.52 LOGIC Investment-Equip Replacement 73,416.33 LOGIC Investment-Veh Replacement 7,086.21 LOGIC Investment-Air Condi Replacment 146,581.84 CAPITAL ONE Investment-General Fund1,337,886.06 Total Cash in Bank & Investments$5,444,290.75 ADVALOREM TAX OCTNOVDECJANFEBMARAPRMAYJUNJULAUGSEP 1,540,041 228,924 2,439,123 1,871,054 635,719 64,190 27,878 29,919 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 26% $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 535,930 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 77,398 - 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: MAY 31st, 2012 ************************************************** 2 0 1 1 - 2 0 1 2 ************************************************** 106-SPECIAL EVENTS FUND CURRENTCURRENTPRIOR YEARPRIORCURRENTY-T-DBUDGET66.67% 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 3,500.00 30,461.91- 26,451.06 - 1,548.94 TML Dinner - - 194.69 - - - (194.69) Hal Balwin Scholarship 24,000.00 23,585.00- 16,142.00 - - 7,858.00 Miscellaneous175.009,624.55- 1,373.54445.09 - TOTAL REVENUES114,275.00 13,124.55 - 54,492.00 44,161.29 - 70,113.71 EXPENDITURE SUMMARY GENERAL GOVERNMENT Non Departmental5,150.00- -- - - TOTAL GENERAL GOVERNMENT5,150.00 - - - - - 5,150.00 CULTURAL Other Events 4,750.00 10,200.32 - 10,200.32- (5,631.79)181.47 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 - - 194.69 - - (194.69) Schertz Sweetheart 37,000.00 5,227.16 33,010.72- 19,131.99 1,261.99 Hal Baldwin Scholarship11,000.00-8,332.411,000.00 - -10,000.00 Selma-Schertz 5K- -400.00 - - - TOTAL CULTURAL 15,622.17103,600.00 218.05 84,976.65 47,675.51 1,493.46 54,649.08 TOTAL EXPENDITURES108,750.00 15,622.17 218.05 84,976.65 47,675.51 1,493.46 59,799.08 REVENUE OVER(UNDER) EXPEND5,525.00(3,514.22) SPECIAL EVENTS FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking23,284.93$ Cash in Investments MBIA Special Events66,648.28 Total Cash in Bank & Investments$89,933.21 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Franchises180,00028,737.00 164,765.87-150,502.07 29,497.93- Fees14,164,2501,251,873.77 9,063,338.01-9,692,358.72 4,471,891.28- Fund Transfers484,6747,056.17 53,744.00-56,449.36 428,224.64- Miscellaneous162,469.51277,364.65388,444.67 103,260 - - TOTAL REVENUES14,932,1841,450,136.459,559,212.5310,287,754.82 - - 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,929.63 274,006.46-228,374.58 155,519.42- Supplies5,4003.78418.331,694.872,367.44571.01 Human Services10040.00--40.00- Operations Support106,0008,306.20 45,321.52-71,192.55 34,807.45- Staff Support7,100256.6494.261,822.813,257.2543.30 Professional Services24,0001,962.88395.0010,990.5113,689.65 10,705.35- Fund Charges/Transfers20,000---- 20,000.00- Maintenance Services9,300--3,920.004,440.001,420.00 Operating Equipmen500.006,117.625,932.94 t 6,200 - - -- Capital Outlay 42,000 - - - TOTAL BUSINESS OFFICE36,499.131,407.59343,873.79329,294.412,034.31 603,994 W & S ADMINISTRATION Personnel Services1,184,89867,719.37 795,238.98-686,706.83 498,191.17- Supplies200,5205,582.384,458.81100,799.10100,251.962,489.96 Human Services1,000102.00-64.00102.00- City Support Services73,999- 34,899.05-34,379.59 39,619.41- Utility Services2,571,844282,379.95 1,467,506.94-1,752,849.76424.61 Operations Support8,7503,656.01-2,152.435,699.94- Staff Support33,0002,198.98294.5414,219.8713,183.67215.89 City Assistance1,912--296.00297.00- Professional Services187,40028,233.64 153,888.68-94,560.181,880.00 Fund Charges/Transfers2,686,007183,675.97 1,400,200.04-1,682,108.93 1,003,898.07- Maintenance Services5,557,250331,306.3112,287.433,208,681.513,388,833.46160,729.31 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: MAY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Debt Service1,230,353- 590,483.94-96,868.35 1,133,484.65- Rental-Leasing6,070--2,508.532,888.75- Operating Equipment8,180- 16,463.08-3,463.80- Capital Outla1,381.26113,606.66 y 114,000 -132,061.40 - -- Water Line Relocation - - - - TOTAL PUBLIC WORKS13,900,183906,235.87 7,948,375.4017,040.78 8,006,757.32 165,739.77 5,744,726.69 MISC & PROJECTS AVIATION HEIGHTS WTR IMPROVEMNTS City Support Services17,000---- 17,000.00- Operations Support500----- Professional Services48,000 1,750.79-52,298.84- 49,750.79- Maintenance Services184,763.68- 334,500 - - - 237,062.52- TOTAL AVIATION HEIGHTS WTR IMP 400,000 -1,750.79 -401,750.79 FM3009 RD&BRIDGE EXPANSION Professional Services 30,358.80-5,370.50 (5,370.50)- - 3,375.00 Maintenance Services 37.74 71,088.87 - - - - 76,459.37 TOTAL FM3009 RD&BRIDGE EXPANSION -3,375.00 -30,396.54 -(76,459.37) TOTAL MISC & PROJECTS3,375.001,750.79267,459.0676,459.37 400,000 -325,291.42 TOTAL EXPENDITURES14,931,543946,11020,1998,590,7088,412,511167,774 ** REVENUE OVER(UNDER)EXPENSES **1,875,243.72 641 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ****************************************************** 202-WATER & SEWE RCURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Franchises 28,737.00164,765.87150,502.07 000-421490Tower Leasing180,000 - - TOTAL Franchises 180,000 28,737.00 164,765.87- 150,502.07 - 29,497.93 Fees 000-455200Garbage Collection Fee 3,400,000 281,380.55 2,143,779.96- 2,313,435.42 - 1,086,564.58 000-455600Fire Line Fees 19,000 - 18,430.00- 19,690.00 - 000-455700Recycle Fee Revenue 241,000 20,581.21 142,514.67- 167,182.06 - 73,817.94 000-455800W&S Line Constructn Reimbursemnt50,000 1,660.87 19,528.92- 16,633.70 - 33,366.30 000-457100Sale of Water 7,210,000 663,129.05 4,556,066.99- 4,779,101.50 - 2,430,898.50 000-457110Edwards Water Lease 166,250 14,670.24 192,995.00- 180,046.09 - (13,796.09) 000-457120Water Transfer Charge-Selma 5,000 - - 2,668.48 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 4,474.00 54,896.06- 34,573.40 - 55,426.60 000-457400Sewer Charges 2,800,000 252,396.31 1,821,983.25- 2,045,235.21 - 754,764.79 000-457500Water Penalties 180,000 13,441.54 109,007.92- 114,549.90 - 65,450.10 000-459200NSF Check Fee-Water&Sewer2,000140.001,465.481,950.00 - - TOTAL Fees14,164,2501,251,873.77 9,063,338.01-9,692,358.72 - 4,471,891.28 Fund Transfers 000-481000Transfer In- Reserve400,000---- - 400,000.00 7,056.1753,744.00 56,449.36 000-486204Interfnd Chrg-Drainage Bill84,674 - - TOTAL Fund Transfers 484,674 7,056.17 53,744.00- 56,449.36 - 428,224.64 Miscellaneous 000-490000Misc Charges 10,000 200.00 - 4,043.88 408.05 - 000-491000Interest Earned 1,000 150.77 - 1,151.69 1,280.16 - 000-491200Investment Income 6,000 586.23 7,978.36 7,974.39 - (1,974.39) 000-493400Donations-Christmas Activities - - 1,000.00 750.00 - - 000-496050SSLG - SAWS Reservation 134,500.00- 269,000.00 -134,500.00 - (269,000.00) 000-497000Misc Income-W&S 963.40 - 8,891.33 31,158.46 - - (31,158.46) 000-497550TML Reimbursements - - 2,291.34 - - - 000-498100Reimbursement-EMS Loan 9,945 - - - - - 000-498110Reimbursement-SSLGC 76,315 26,069.11 76,314.75- 77,873.61 - (1,558.61) 000-498200W&S Project Reimbursement41,193.30 - - - - - TOTAL Miscellaneous 103,260 162,469.51 277,364.65- 388,444.67 - (285,184.67) TOTAL REVENUES14,932,1841,450,136.45 9,559,212.53- 10,287,754.82 4,644,429.18 WATER & SEWER CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking621,844.31$ Cash in Investments Lone Star Investment-Water&Sewer 1,359,771.66 Lone Star Investment-W&S Customer Deposits294,111.80 Lone Star Investment-W&S Equip Replacement373,636.05 Lone Star Investment-W&S Veh Replacement 544,806.02 Lone Star Investment-Water/SSLGC SAWS 269,575.51 Schertz Bank & Trust-Certificate of Deposit1,055,908.62 $3,897,809.66 Total Cash in Bank & Investments4,519,653.97$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees4,088,933 457,575.26 2,209,841.49- 2,329,166.47 1,760,066.53(300.00) Inter-Jurisdictional1,438,836 30,752.71 1,013,959.52- 1,058,656.60 380,179.40- Miscellaneous16,149.49-75,442.9574,388.88 256,000 - TOTAL REVENUES 504,477.46 - 3,299,243.96 3,462,211.95 (300.00) 2,321,857.05 5,783,769 EXPENDITURE SUMMARY PUBLIC SAFETY SCHERTZ EMS Personnel Services2,586,891189,483.61 1,757,535.2868.001,734,926.04 852,021.9611.00 Supplies 14,228.69 13,149.22 208,165.12 217,001.30 45,962.38 324,039 Human Services - 580.00 - 800 - - City Support Services 10,974.19- 10,277.40 31,505 - - 21,227.60 Utility Services 11,524.00 10.41 63,919.62 68,474.00 44,021.4115.00 112,500 Operations Support 1,825.57 364.65 34,663.20 36,539.93 810.99 52,600 Staff Support 2,106.46 449.08 44,505.53 40,722.45 18,971.94 72,400 City Assistance 1,317.74 - 5,743.00 7,132.74 96.00 9,000 Professional Services 4,567.64 133.00 88,606.09 83,022.87 7,632.86 157,200 Fund Charges/Transfers2,084,785 10,187.36 577,166.58- 381,961.09 - 1,702,823.91 Maintenance Services 4,170.00 21,779.91- 36,465.52 37,700 - 1,234.48 Debt Service 69,799.33- 5,863.00 111,176 - - 105,313.00 Rental-Leasing - 2,748.61 - 20,000 - - Operating Equipment 48.17 820.75 17,577.45 41,322.80 779.97 113,000 Capital Outlay-- - - - - TOTAL PUBLIC SAFETY 239,459.24 14,995.11 2,903,763.91 2,663,709.14 74,280.14 2,990,601.83 5,713,596 TOTAL EXPENDITURE239,459.2414,995.112,903,763.912,663,709.14 S 5,713,596 74,280.14 ** REVENUE OVER(UNDER) EXPENSES 798,502.81 * 70,173 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 203-EMS CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-456100Ambulance/Mileage Transprt3,818,733 449,815.26 - 2,146,206.49 2,262,529.47 - 1,556,203.53 59.25% 000-456110Subscription Program Fees55,000 155.00 - 18,555.00 17,925.00 32.59% - 37,075.00 000-456120EMT Class - Fees95,200 7,605.00 - 45,080.00 45,486.00 (300.00) 50,014.00 47.46% 000-459200Paramedic Class Fees120,000 - - - - 000-456130Immunization Fees - 3,226.00- - - - (3,226.00) 000-459200NSF Check Fee -- - - - - - TOTAL Fees4,088,933457,575.26 2,209,841.49- 2,329,166.47 1,760,066.53(300.00) Inter-Jurisdictional 000-473500Seguin/Guadalupe Co Support286,126 23,843.88 - 191,850.89 190,751.04 - 95,374.96 000-474300Cibolo Support 222,018 159,975.00- 166,574.94 - - 55,443.06 000-475100Comal Co ESD #6 82,875 6,908.83 37,920.00- 55,270.62 - 27,604.38 000-475200Live Oak Support 148,125 111,093.75- 120,247.14 - - 27,877.86 000-475300Universal City Support 226,168 153,309.39- 170,538.49 - - 55,629.51 000-475400Selma Support 67,618 51,547.50- 50,732.55 - - 16,885.45 000-475500Schertz Support 384,046 290,594.61- 288,140.73 - - 95,905.27 000-475600Santa Clara Support 8,849 - 7,901.01 6,639.18 - - 2,209.82 000-475800Marion Support13,0119,767.379,761.91 - - - TOTAL Inter-Jurisdictional1,438,836 30,752.71 1,013,959.52- 1,058,656.60 380,179.40- Miscellaneous 000-491000Interest Earned--- 0.00% - - - 000-491200Investment Income 66.10 - 412.17 423.08 - - 000-493203Donations-EMS 6,000 - 1,400.00 695.00 - - 5,305.00 000-493204Donations-Dilworth Fund - 1,000.00 - 0.00% - - - 000-493205Donations- Golf Tournament - 3,690.00 15,550.00 -12,290.00 - (15,550.00) 000-497000Misc Income 150,000 3,613.39 59,765.03- 54,059.90 - 95,940.10 000-497100Recovery of Bad Debt100,000180.009,175.753,660.90 - - TOTAL Miscellaneous256,00016,149.49 75,442.95-74,388.88 - 181,611.12 TOTAL REVENUES5,783,769504,477.46 3,299,243.96- 3,462,211.95 2,321,857.05(300.00) SCHERTZ EMS CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank $ (419,017.52) Claim on Operating Cash Pool-Checking Cash in Investments MBIA Investment-EMS Note 2010301,170.81 $(117,846.71) 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: MAY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARBUDGEPERIODEXPENSEY-T-D ACTUAY-T-D ACTUAENCUMBBALANCEBUDGE YTLLR REVENUE SUMMARY Fees 709,60061,336.67 469,083.94- 498,258.14 -211,341.86 Fund Transfers - - - - - - - 0.00% Miscellaneous900805.34599.60 74.59 - - TOTAL REVENUES 61,411.26710,500469,889.28 -498,857.74211,642.26 - EXPENDITURE SUMMARY PUBLIC WORKS DRAINAGE Personnel Services 374,40423,520.67 236,042.93- 214,263.20 -160,140.80 Supplies 8,300 184.23 - 1,209.56 1,738.62 6,528.3633.02 Human Services 325 - - - - -325.00 City Support Services 22,165 - 4,332.18 1,508.72 - -20,656.28 Utility Services 24,188 1,703.39 - 8,598.92 12,636.05 11,127.32424.63 Operations Support 2,460 - - - - -2,460.00 Staff Support 8,305 400.43 43.02 2,344.61 2,722.96 826.63 City Assistance 840 - 15.00 72.00 - -768.00 Professional Services 20,698 2,578.00 14,280.00- 14,959.25 -5,738.75 Fund Charges/Transfers 199,87611,785.92 87,001.00- 94,287.36 -105,588.64 Maintenance Services 22,000 - 1,987.00 - 21,957.8842.12 - Other costs 100 - 100.00 100.00 - - - 100.00% Debt Service 17,564 - 1,918.78 1,632.07 - - Rental/Leasing500-- - - -500.00 Operating Equipment-- - - - - - TOTAL DRAINAGE 40,172.64701,72543.02357,829.98 1,326.40343,920.23356,521.39 TOTAL EXPENDITURE 40,172.64701,72543.02357,829.98 1,326.40343,920.23356,521.39 S ** REVENUE OVER(UNDER) EXPEND8,775154,937.51 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *********************************************** 2 0 1 1 - 2 0 1 2 ************************************************* 204-DRAINAGE CURRENTCURRENTPRIOR YEARPRIOR YEARY-T-DY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALACTUALENCUMBRBALANCEBUDGET Fees 000-457500Drainage Penalties - 2,827.84 3,452.26 4,000 415.84 -547.74 000-457600Drainage Fee 60,920.83-466,256.10494,805.88 -210,794.12 705,600 TOTAL Fees61,336.67 469,083.94-498,258.14 211,341.86- 709,600 Fund Transfers 000-486202Transfer In-Water-- - - - - - TOTAL Fees -- - - - - -0.00% Miscellaneous 000-491000Interest Earned - 210.08 59.18 100 10.14 - 000-491200Investment Interest - 452.10 498.84 600 59.83 -101.16 000-497000Misc Income-Drainage-143.1641.58 200 4.62 - TOTAL Miscellaneous - 805.34 599.60 900 74.59 -300.40 TOTAL REVENUES61,411.26 469,889.28- 498,857.74 211,642.26- 710,500 DRAINAGE CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Ban k Claim on Operating Cash Pool-Checking 119,667.98 Cash in Investments Lone Star Investment-Drainage Maint Fund383,579.48 Total Cash in Bank & Investments$503,247.46 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 390,754 37,317.20 157,746.00- 241,758.42 -148,995.58 Fund Transfers 20,132 - - - - -20,132 Miscellaneous50025.74-874.85179.00 - TOTAL REVENUES 37,342.94411,386-158,620.85241,937.42 - EXPENDITURE SUMMARY NONDEPARTMENTAL Supplies 2,500 213.00 2,315.40 1,826.50 - -886.50 City Support Services 85,948 47,298.85- 49,564.00 - -36,384.00 Operations Support 74,000 1,058.77 346.04 6,654.28 16,306.31 500.00 Professional Services 2,500.002,500 - 2,500.00 2,500.00 - -100.00% Fund Charges/Transfers 193,876 11,885.50 113,480.66- 95,084.00 -98,792.00 Operating Equipment 52,562 762.80 6,645.00 17,763.38- 7,000.00 Capital Outlay--- - - - - TOTAL NONDEPARTMENTA 16,207.07411,3867,204.04172,249.19183,044.19228,045.85 L 7,500.00 TOTAL EXPENDITURE 16,207.07411,3867,204.04172,249.19183,044.19228,045.85 S 7,500.00 58,893.23 REVENUE OVER(UNDER) EXPENDITURE - C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 314-HOTEL TAX CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411800Hotel Occupancy Tax390,754 37,317.20157,746.00241,758.42 -148,995.58 - TOTAL Taxes 390,754 37,317.20 157,746.00- 241,758.42 - 148,995.58 Fund Transfers 000-481000Transfer From Reserve20,132 ---20,132.00 - - TOTAL Fund Transfers 20,132 - - - - - 20,132.00 Miscellaneous 000-491000Interest Earned30012.52-181.9181.62 - 218.38 000-491200Investment Interest 200 13.22 - 92.94 97.38 - 102.62 000-497000Misc Income600.00- - - - - - TOTAL Miscellaneous50025.74-874.85179.00 - 321.00 TOTAL REVENUES 411,386 37,342.94 158,620.85- 241,937.42 - 169,448.58 HOTEL OCCUPANCY TAX FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking82,187.63$ Cash in Investments MBIA - Hotel Tax200,001.44 Federated Investment-Hotel/Motel78,221.98 Total Cash in Bank & Investments$360,411.05 ôíè÷ð íùùçìûîùã èûä $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 36,518 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: MAY 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Parkland Dedication Fees 250,00012,150.00 107,000.00- 118,025.00 -131,975.00 Tree Mitigation Fees 45,305.0075,000 - 62,844.75- -12,155.25 Miscellaneous600-462.79448.54 53.72 - TOTAL REVENUES 57,508.72325,600-107,462.79181,318.29144,281.71 - EXPENDITURE SUMMARY PARKLAND DEDICATION Fund Charges/Transfers 13,000 - - 5,819.26 5,819.26 -7,180.74 Maintenance Services-Landscape 3,500 12,234.00- 135.88 - -3,364.12 Operating Equipment 32,000 56,748.78- 20,737.20 7,417.72 - Capital Outlay169,000 ---68,873.45100,126.55 - TOTAL PARKLAND DEDICATION 5,819.26217,500-68,982.7895,565.79114,516.49 7,417.72 TREE MITIGATION Maintenance Services-Trees28,500 28,004.55- 3,623.00 12.71% 500.00 -24,877.00 Capital Outlay18,000 ---19,900.00 - TOTAL TREE MITIGATION 500.0046,500-28,004.5523,523.00 - TOTAL EXPENDITURE 6,319.26264,000-96,987.33119,088.79137,493.49 S 7,417.72 REVENUE OVER(UNDER) EXPEND 62,229.5061,600 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 317-PAR KCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRANCEBALANCEBUDGET Fees 000-458800Parkland Dedication 250,00012,150.00 107,000.00- 118,025.00 131,975.00- 000-458900Tree Mitigation 45,305.0075,000- -62,844.75 - TOTAL Fees 325,00057,455.00 107,000.00- 180,869.75 144,130.25- Miscellaneous 000-491000Interest Earned 100 5.62 - 187.54 20.81 79.19- 000-491200Investment Interest 500 48.10 - 275.25 427.73 72.27- 000-497000Miscellaneous Income--- - - - TOTAL Miscellaneous60053.72-462.79448.54 151.46- TOTAL REVENUES 325,60057,508.72 107,462.79- 181,318.29 144,281.71- PARK FUND CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking$134,625.77 Cash in Investments Federated Investment-Park Fund 192,958.20 Federated Investment-Tree Mitigation126,394.68 Total in Investment Pool 319,352.88 Total Cash in Bank & Investments$453,978.65 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ******************************************************* 2 0 1 1 - 2 0 1 2 ******************************************************* 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSESY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Fees 2,725,400 124,218.04 1,919,918.82- 971,199.76 -1,754,200.24 Fund Transfers10,673,600 - - - - 0.00% -10,673,600.00 Miscellaneous314,000 527.54232,679.63230,738.70 - - TOTAL REVENUES13,713,000 124,745.582,152,598.45 -1,201,938.4612,511,061.54 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies5,000--- -5,000.00 Operations Support 1,000 - - - 108.50 - Professional Services 22,000 2,421.99 1,120,464.18- 5,190.02 -16,809.98 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 2,421.991,128,892.18113,969.52 L - - MISC & PROJECTS Projects13,025,000 35,663.25-88,719.5610,488.42 -13,050,174.83-0.19% Schaefer RD Water Improvements 599,643-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 -35,663.25637,485.2013,563.4213,646,742.83 - TOTAL EXPENDITURE13,662,643 2,421.9935,663.251,766,377.38127,532.9413,570,773.31 S - REVENUE OVER(UNDER) EXPENDITURES50,357 1,074,406 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 **************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 411-CAPITAL RECOVER YCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Fees 000-455900Capital Recovery - Water 1,479,600 90,391.00 1,013,279.74- 628,543.00 -851,057.00 000-455910Capital Recovery - Waste Wtr613,800 28,427.04 682,240.79- 313,856.76 -299,943.24 - - - 0.00% 000-455911Capital Recovery-Wste Wtr Zone 1 - - - 000-455913Cap Recovery-North Sewer Tr632,000 5,400.00224,398.2928,800.00 - - TOTAL Fees 2,725,400124,218.04 1,919,918.82- 971,199.76 -1,754,200.24 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 Earned50032.75-367.04224.46 - 000-491200Investment Income 30,000 4,854.39 25,604.40- 34,693.73 -(4,693.73) 000-491800Gain/Loss - - (554.28) - - - 000-491900Unrealized Gain/Loss-Cap One (15,625.13)- (23,625.21) - (4,359.60) -23,625.21 000-497000Misc Income - - - 0.00% - - - 000-498000Reimbursmnt - - 220,000.00- - -(220,000.00) 000-498100Reimbursmnt - FM 78 Project 33,333.32- - 0.00% - - - 000-498200Re-imbursement-Water Meters283,500 -189,000.00- - - TOTAL Miscellaneous 314,000 527.54 232,679.63- 230,738.70 73.48% -83,261.30 TOTAL REVENUES13,713,000 124,745.58 2,152,598.45- 1,201,938.46 8.76% -12,511,061.54 CAPITAL RECOVERY CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking288,254.71$ Cash in Investments Lone Star Investment-Capital Recovery Water1,754,003.53 Lone Star Investment-Capital Recovery Sewer480,857.48 Capital One-Investment1,713,851.34 Total Cash in Bank & Investments4,236,967.06$ C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ****************************************************** 2 0 1 1 - 2 0 1 2 **************************************************** 505-TAX I&S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes 20,452.434,281,098 - 3,384,947.74 4,263,262.36 -17,835.64 - - - - Fund Transfers - - Miscellaneous2,250(6,210.22)15,294.947,965.70 - - TOTAL REVENUES 14,242.214,283,3483,400,242.684,271,228.06 - - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL 350.00 - 350.00 36,560.39 Professional Services - -(36,560.39) Debt Service -4,276,6672,558,340.593,074,924.52 - - TOTAL GENERAL GOVERNMEN 350.004,276,6672,558,690.593,111,484.91 T - - TOTAL EXPENDITURE 350.004,276,6672,558,690.593,111,484.91 S - - ** REVENUE OVER(UNDER) EXPEND6,6821,159,743.15 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 505-TAX I & S CURRENTCURRENTPRIOR YEARPRIOR YEARCURRRENTY-T-DBUDGET66.67% REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411900Property Tax Revenue4,281,098 20,452.433,384,947.744,263,262.36 - - TOTAL Taxes4,281,09820,452.43 3,384,947.74-4,263,262.36 - 17,835.64 Fund Transfers 000-486000Transfer From Reserves - - - - - - 000-486103Transfer In -- - - - - 000-486401Transfer In Fund 401- - - - - - TOTAL Fund Transfers - - - - - - Miscellaneous 000-491000Interest Earned 750 0.43 14,414.72- 28.30 - 000-491200Investment Earnings1,5001,905.42 880.2216,053.47 - -(14,553.47) 000-497000Misc Income(8,116.07)- (8,116.07) - - - TOTAL Miscellaneous2,250(6,210.22) 15,294.94-7,965.70 - (5,715.70) TOTAL REVENUES4,283,348 14,242.21 3,400,242.68- 4,271,228.06 - 12,119.94 C I T Y O F S C H E R T Z REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: MAY 31st, 2012 505-TAX I & S***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** GENERAL GOVERNMENTCURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% NON DEPARTMENTALBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Professional Services 101-541500Paying Agent350.00 350.00750.00 - - - 35,810.39- 101-541502Cost of Bond Issuance - - - - TOTAL Professional Services350-35036,560 - -(36,560.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 350.00 2,558,690.59- 3,111,484.91 -1,165,181.59 TAX I&S CASH IN BANK AND INVESTMENTS AS OF: MAY 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking6,090.37$ Cash in Investments MBIA Investment- Tax I&S 1,247,797.96 Federated Investment-Tax I&S56.87 Total Cash in Bank & Investments$1,253,945.20 CITY OF SCHERTZ REVENUE AND EXPENSE REPORT (UNAUDITED) AS OF: May 31st, 2012 ***************************************************** 2 0 1 1 - 2 0 1 2 ***************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-DBUDGET66.67% OF FINANCIAL SUMMARYBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET REVENUE SUMMARY Taxes2,392,042175,294.43 1,107,537.18- 1,609,615.56 - 782,426.44 Fund Transfers - - - 0.00% - - - Miscellaneous 491.1717,2006,430.91 -16,216.58 - ,,,.,,. -,,. TOTALREVENUES240924217578560111396809162583214783 - EXPENDITURE SUMMARY GENERAL GOVERNMENT NONDEPARTMENTAL Supplies 24,000 1,694.15 579.81 15,415.28 20,600.88 1,262.56 Utility Service 87,500 5,700.83 32,889.10- 43,549.99 707.51 43,242.50 Maintenance Services 69,300 3,546.92 632.25 47,405.19 41,801.10 1,433.26 Operating Equipment - 6,999.31 - 0.00% - - - Capital Outlay --- - - - TOTAL NONDEPARTMENTA 10,941.90180,8001,212.06102,708.88 3,403.33105,951.97 L ECONOMIC DEVELOPMEN T Personnel Services 241,233 22,607.92 112,392.44- 148,606.71 - 92,626.29 Supplies 1,100 - 560.22 441.17 110.41 - Human Services 200 - - - - - City Support Services 42,772 13,619.71 7,717.90 -1,363.42 - 36,417.52 Utility Services 7,200 73.53 - 2,190.00 992.35 - 6,207.65 Operations Support 63,600 4,269.39 4,813.35 49,053.53 17,985.08 1,509.18 48,919.09 Staff Support 112,800 4,298.49 937.31 65,368.80 72,194.92 3,362.63 City Assistance 300,000 - 10,000.00- - - 290,000.00 Professional Services 303,500 8,209.03 30,935.60 160,792.90 97,002.40 - 237,433.20 Fund Charges/Transfers 105,985 4,665.42 86,751.99- 37,323.36 - 68,661.64 Fund Replenish-Fund Balance - - - 0.00% - - - Maintenance Services - - - 0.00% - - - Debt Service 795,154 606,911.25- 613,014.50182,139.50 - - Operating Equipment -2,350-212.88(50.94) - TOTAL ECONO DEVELOPMEN 44,123.781,975,89438,049.681,097,640.84 4,931.281,005,491.271,003,521.13 T TOTAL EXPENDITURE 55,065.682,156,69439,261.741,200,349.72 8,334.611,111,443.241,076,177.89 S ** REVENUE OVER(UNDER) EXPEND252,548 514,388.90 C I T Y O F S C H E R T Z REVENUE REPORT (UNAUDITED) AS OF: May 31st, 2012 *************************************************** 2 0 1 1 - 2 0 1 2 *************************************************** 620-SED CORPORATION CURRENTCURRENTPRIOR YEARPRIOR YEARCURRENTY-T-D BUDGET66.67% OF REVENUESBUDGETPERIODEXPENSEY-T-D ACTUALY-T-D ACTUALENCUMBRBALANCEBUDGET Taxes 000-411500Sales Tax Revenue (4B)2,392,042175,294.431,107,537.181,609,615.56 - - TOTAL Taxes2,392,042175,294.43 1,107,537.18- 1,609,615.56 -782,426.44 Fund Transfers 000-486000Transfer In -- - - - - TOTAL Fund Transfers--- - - - Miscellaneous -- - 000-490420Donations from Escrow Fund - - - 000-491000Interest Earned 200 12.88 - 120.45 115.99 - 000-491200Investment Earnings 15,000 478.29 - 4,956.66 4,613.67 -10,386.33 000-497000Misc Income 2,000 - 1,353.80 11,486.92 - -(9,486.92) 000-499000Transfer From Reserves -- - - - - TOTAL Miscellaneous 17,200 491.17 - 6,430.91 16,216.58 - TOTAL REVENUES2,409,242175,785.60 1,113,968.09-1,625,832.14 -783,409.86 SED CORPORATION CASH IN BANK AND INVESTMENTS AS OF: May 31st, 2012 Cash in Bank Claim on Operating Cash Pool-Checking179,360.35$ Cash in Investments MBIA Investment-Economic Development Corp2,325,047.76 Schertz Bank & Trust-Certificate of Deposit- Schertz Bank & Trust-Certificate of Deposit1,035,475.46 Total Cash in Bank & Investments3,539,883.57$ 4B SALES TAX $300,000 26% 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 267,965 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 MAY 31st, 2012 INVESTMENT POOLSPareginningeposits/ndingndingMaturity BDEE ValueBook ValueYieldPurchasesWithdrawalsBook ValueMkt Value OPERATIONS-BANK CASH Schertz Bank & Trust2,696,676.16,929,711.00.0500,440,571.22,673,606.06,696,676.16,696,676.16 204422 TOTAL OPERATIONS2,696,676.16,929,711.00,440,571.22,673,606.06,696,676.16,696,676.16 24422 LOGIC General Fund3,310,869.52,610,093.78.268375.7400,000.00,310,869.52 N/A,310,869.52 307333 G/F-Equipment Replacement73,416.3373,399.600.2683 -16.7373,416.33 N/A73,416.33 G/F-Vehicle Replacement7,086.21,084.60.2683 -.61,086.21 N/A,086.21 70177 G/F-Air Conditioner Replacement146,581.84146,548.440.2683 -33.40146,581.84 N/A146,581.84 ,721,448.55.268391.965,000.00,696,840.51,696,840.51 SR2009 Bond-Street Projects(II)1,696,840.51 103211 TOTAL LOGIC5,234,794.41,558,574.97,219.4425,000.00,234,794.41,234,794.41 51355 LONESTA R Capital Recovery - Sewer480,857.48280,796.870.2400 -200,060.61480,857.48 N/A480,857.48 Capital Recovery - Water1,754,003.53,153,699.05.2400 -00,304.48,754,003.53 N/A,754,003.53 10611 Drainage Fund383,579.48283,519.650.2400 -100,059.83383,579.48 N/A383,579.48 GO SR2011 Animal Shelter2,155,414.94,222,967.13.240047.818,000.00,155,414.94 N/A,155,414.94 204622 GO SR2011 Athletic Fields1,482,173.351,481,867.610.2400 -305.741,482,173.35 N/A1,482,173.35 GO SR2011 Soccer Fields1,343,348.86,411,068.57.240080.298,000.00,343,348.86 N/A,343,348.86 102611 GO SR2011 Swimming Pool2,909,830.672,934,229.260.2400601.4125,000.002,909,830.67 N/A2,909,830.67 W/S-Customer Deposits294,111.8094,051.13.2400 -0.6794,111.80 N/A94,111.80 20622 W/S-Equipment Repl/Cap.Imp373,636.05373,558.980.2400 -77.07373,636.05 N/A373,636.05 Water&Sewer1,359,771.66,359,491.16.2400 -80.50,359,771.66 N/A,359,771.66 10211 W/S-Vehicle Replacement544,806.02544,693.640.2400 -112.38544,806.02 N/A544,806.02 69,519.90.24005.61-69,575.5169,575.51 Water/SSLG - SAWS269,575.51 20522 TOTAL LONESTA13,351,109.352,609,462.9502,646.4061,000.003,351,109.353,351,109.35 R19111 MBIA Tax I&S1,247,797.961,215,693.960.2600 -32,104.001,247,797.96 N/A1,247,797.96 Police Forfeiture359,620.0559,541.19.2600 -8.8659,620.05 N/A59,620.05 30733 Economic Development Corporation2,325,047.762,024,569.470.2600 -300,478.292,325,047.76 N/A2,325,047.76 Hotel Tax200,001.44.2600 -00,001.4400,001.44 N/A00,001.44 -0222 Special Events Fund66,648.2866,633.730.2600 -14.5566,648.28 N/A66,648.28 01,104.71.26006.10-01,170.8101,170.81 EMS Tax Notes 2010301,170.81 30633 TOTAL MBIA4,500,286.30,967,543.06 -32,743.24,500,286.30,500,286.30 3544 FEDERATED SR2007a Bond-City Wide Projects868,783.73868,652.880.1800 -130.85868,783.73 N/A868,783.73 Hotel Occupancy Tax78,221.988,210.20.1800 -1.788,221.98 N/A8,221.98 70177 Park Fund (Developers Fee)192,958.20192,929.140.1800 -29.06192,958.20 N/A192,958.20 Park Fund (Tree Mitigation)126,394.6826,375.64.1800 -9.0426,394.68 N/A26,394.68 10111 Tax I&S56.8756.860.1800 -0.0156.87 N/A56.87 4,728.74.1800.74-4,735.484,735.48 Library Board Fund44,735.48 40644 TOTAL FEDERATED1,311,150.94,310,953.46 -97.48,311,150.94,311,150.94 1111 INVESTMENT MANAGED ACCOUNT Capital One General Fund1,263,292.761,334,744.103.2300 276.604,518.891,338,986.39 N/A1,337,886.06 ,743,586.72.0600,918.87354.49,750,151.10,713,851.34 Capital One Capital Recovery1,626,804.94 13611 TOTAL CAPITAL ONE2,890,097.70,078,330.82 631.091,437.76,089,137.49,051,737.40 3133 City Portfolio By Investment Type TOTAL C.D.s TOTAL OPERATIONS TOTAL CAPITAL ONE 7% 8% 9% TOTAL LOGIC TOTAL FEDERATED 16% 4% TOTAL MBIA 14% TOTAL LONESTAR 42% City Portfolio By Use Pooled-Daily Operations, Designated Funds, $2,696,676.16 $8,842,035.38 $ Special Revenue Funds, Debt Service Fund, $8,362,963.56 $1,247,854.83 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.07000.0300 1 Month T-Bill 0.01000.01000.02000.06000.08000.07000.10000.0700 3 Month T-Bill 0.06000.06000.06000.08000.13000.15000.15000.1400 6 Month T-Bill 0.46000.52000.49000.50000.52000.53000.53000.5100 Schertz Portfolio 0.05000.05000.05000.05000.05000.05000.05000.0500 Schertz Bank&Trust 1.10001.10001.10000.40000.40000.40000.40000.4000 CD 365 Days 0.80000.80000.30000.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.28640.2683 LOGIC 0.23000.25000.28000.31000.26000.27000.27000.2400 LoneStar 0.14000.15000.19000.21000.25000.24000.25000.2600 MBIA 0.09000.14000.13000.15000.22000.21000.19000.1800 Federated 2.32432.84002.83003.07003.07003.15003.15003.1300 Capital One C I T Y O F S C H E R T Z Investment Report Capital One Assets Date:5/31/2012 d General Fun Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt Cl III #69123,292.7623,292.7623,292.762.000.01 39,940.3339,940.33 JPMorgan Chase Disc Coml Paper9/21/2012113.0040,000.00 Total Cash & Equivalent3,292.763,233.03,233.0 s66969 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014804.00125,000.00141,987.30139,232.506,875.00 Federal Home Loan Bks Cons Bds6/21/2013386.0080,000.0082,004.4081,402.401,500.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151294.00100,000.00116,185.00114,623.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012139.00150,000.00162,031.50152,478.006,750.00 Federal Home Ln Mtg Corp Deb11/15/2013533.00170,000.00191,084.25181,495.408,287.00 Federal Natl Mtg Assn Meduim term Nts9/24/2013481.00250,000.00250,000.00263,495.0010,937.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014908.00100,000.0099,874.40100,575.00750.00 Federal Natl Mtg Assn 7/28/20151153.00125,000.00132,828.63132,053.752,968.00 US Treasury Note2/28/2014638.00100,000.0099,757.8299,993.00 Total Fixed Income1,200,000.001,275,753.301,265,348.054 Total Assets636.881,263,292.761,338,986.391,328,581.144 Cap Recovery Fund Assets P Cash & EquivalentsDueMaturitySharesCostMrk Value Fidelity Inst Prime Mmkt CL III #69126,804.9426,804.9426,804.942.000.01 JPMorgan Chase Disc Coml Paper9/21/2012113.0080,000.0079,880.6779,880.67 Total Cash & Equivalent06,804.9106,685.6106,685.61 s141 Fixed Income Federal Home Loan Bks Cons Bds8/13/2014804.00165,000.00187,423.24183,786.909,075.00 Federal Home Loan Bks Cons Bds6/21/2013386.00100,000.00102,505.50101,753.001,875.00 Federal Farm Cr Bks Cons Systemwide Bds12/16/20151294.00100,000.00116,185.00114,623.004,875.00 Federal Farm Cr Bks Cons Systemwide Bds10/17/2012139.00250,000.00270,052.50254,130.0011,250.00 Federal Home Ln Mtg Corp Deb11/15/2013533.00250,000.00281,006.25266,905.0012,187.00 Federal Natl Mtg Assn Nts10/15/2013502.00200,000.00223,001.60211,972.009,250.00 Federal Home Ln Mtg Corp Reference Nts11/25/2014908.00220,000.00220,078.68221,265.001,650.00 Federal Natl Mtg Assn7/28/20151153.00135,000.00143,454.91142,618.053,206.00 /28/201438.0000,000.0099,757.819,993.00 US Treasury Not e2619 Total Fixed Incom,520,000.01,643,465.4,597,045.9 e109155 Total Assets615.811,626,804.941,750,151.101,703,731.565